{"id":607,"date":"2015-11-29T00:45:53","date_gmt":"2015-11-28T23:45:53","guid":{"rendered":"http:\/\/hannes.enjoys.it\/blog\/?p=607"},"modified":"2015-11-29T00:45:53","modified_gmt":"2015-11-28T23:45:53","slug":"oakland-all-license-plate-reader-data-alpr","status":"publish","type":"post","link":"https:\/\/hannes.enjoys.it\/blog\/2015\/11\/oakland-all-license-plate-reader-data-alpr\/","title":{"rendered":"Oakland: All license plate reader data (ALPR)"},"content":{"rendered":"

WTF!<\/p>\n

https:\/\/data.oaklandnet.com\/browse?q=alpr<\/a> via https:\/\/news.ycombinator.com\/item?id=10642139<\/a><\/p>\n

817159 timestamped car plate locations.<\/p>\n

\"oakland
\n\"oakland<\/p>\n

Pages:<\/strong><\/p>\n

\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-License-Plate-Reader-Data-ALPR-September-23-20\/6dab-n9nd
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-04-01-2014-thru\/k76g-27ne
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-3-1-2013-4-1-20\/m64r-jeei
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-3-19-2014-3-31-\/wy2w-ue82
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-4-1-14-thru-5-3\/7axi-hi5i
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-5-13-2012-7-3-2\/f28j-9q95
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-7-6-2011-12-19-\/7xz6-yzxz
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-8-6-2012-8-12-2\/gyu7-qpwz
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-8-26-2012-9-19-\/bd9f-4pn8
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-9-15-2012\/vwcs-329i” clas
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-10-20-2012-11-2\/cyhz-jk8v
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-11-20-2012-12-3\/jxx3-67d2
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-12-19-2013-1-31\/h4qp-hsyy
\nhttps:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-12-23-2010-thru\/t7dd-x7dh\n<\/p><\/blockquote>\n

grab.sh:<\/strong><\/p>\n

\nids=”6dab-n9nd
\n7axi-hi5i
\n7xz6-yzxz
\nbd9f-4pn8
\ncyhz-jk8v
\nf28j-9q95
\ngyu7-qpwz
\nh4qp-hsyy
\njxx3-67d2
\nk76g-27ne
\nm64r-jeei
\nt7dd-x7dh
\nvwcs-329i
\nwy2w-ue82″<\/p>\n

for id in ${ids}
\ndo
\n\techo “Grabbing ${id}”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.csv?accessType=DOWNLOAD”
\n# screw excel\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.csv?accessType=DOWNLOAD&bom=true”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.json?accessType=DOWNLOAD”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.pdf?accessType=DOWNLOAD”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.rdf?accessType=DOWNLOAD”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.rss?accessType=DOWNLOAD”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.xls?accessType=DOWNLOAD”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.xlsx?accessType=DOWNLOAD”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.xml?accessType=DOWNLOAD”
\n\twget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.xml?accessType=DOWNLOAD”
\ndone<\/p>\n

exit\n<\/p><\/blockquote>\n

Be aware that only the CSV format is guaranteed to have all records. At least that’s what some files say.<\/p>\n

\n$ sed ‘s#,.*##g’ *.csv | sort | uniq | wc -l
\n817159\n<\/p><\/blockquote>\n

\nsed ‘s#,.*##g’ *.csv | sort | uniq -c | sort -h | tail
\ngrep -h ‘^PLATENUMBER,’ *.csv | sed ‘s#,”(#,#g’ | sed ‘s#)”##’
\ngrep -hEo “\\(37.*\\)\\”” *.csv | sed ‘s#[()” ]*##g’<\/p>\n<\/blockquote>\n

Happy stalking :(<\/p>\n","protected":false},"excerpt":{"rendered":"

WTF! https:\/\/data.oaklandnet.com\/browse?q=alpr via https:\/\/news.ycombinator.com\/item?id=10642139 817159 timestamped car plate locations. Pages: https:\/\/data.oaklandnet.com\/Public-Safety\/All-License-Plate-Reader-Data-ALPR-September-23-20\/6dab-n9nd https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-04-01-2014-thru\/k76g-27ne https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-3-1-2013-4-1-20\/m64r-jeei https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-3-19-2014-3-31-\/wy2w-ue82 https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-4-1-14-thru-5-3\/7axi-hi5i https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-5-13-2012-7-3-2\/f28j-9q95 https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-7-6-2011-12-19-\/7xz6-yzxz https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-8-6-2012-8-12-2\/gyu7-qpwz https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-8-26-2012-9-19-\/bd9f-4pn8 https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-9-15-2012\/vwcs-329i” clas https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-10-20-2012-11-2\/cyhz-jk8v https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-11-20-2012-12-3\/jxx3-67d2 https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-12-19-2013-1-31\/h4qp-hsyy https:\/\/data.oaklandnet.com\/Public-Safety\/All-license-plate-reader-data-ALPR-12-23-2010-thru\/t7dd-x7dh grab.sh: ids=”6dab-n9nd 7axi-hi5i 7xz6-yzxz bd9f-4pn8 cyhz-jk8v f28j-9q95 gyu7-qpwz h4qp-hsyy jxx3-67d2 k76g-27ne m64r-jeei t7dd-x7dh vwcs-329i wy2w-ue82″ for id in ${ids} do echo “Grabbing ${id}” wget -a wget.log -x –content-disposition “https:\/\/data.oaklandnet.com\/api\/views\/${id}\/rows.csv?accessType=DOWNLOAD” # […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,29,10,16,34],"tags":[],"class_list":["post-607","post","type-post","status-publish","format-standard","hentry","category-fuck-surveillance","category-gis","category-open-data","category-tracking","category-wtf"],"_links":{"self":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts\/607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":7,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts\/607\/revisions"}],"predecessor-version":[{"id":617,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/posts\/607\/revisions\/617"}],"wp:attachment":[{"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/media?parent=607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/categories?post=607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hannes.enjoys.it\/blog\/wp-json\/wp\/v2\/tags?post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}