Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Geocoding SLO PD Crime

No description
by

Chad Bunn

on 10 February 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Geocoding SLO PD Crime

Geocoding SLO PD Crime
Really Fast & Really Free
Google Refine
Vagrant
Geocode it!
Data Science ToolKit
Vagrant+Virtual Box
Get some
data
2014 SLO PD crime logs
-
Python
script
.txt ==> .csv
29,000+
-Accuracy?
-Limits?
-
$$$
?
-Pete Warden
-Census TIGER roads
-
OSM
Nomatim
-Easy to install virtual environment
-Unzip
LARGE
DSTK server (24GB)
-DSTK uses Linux Ubuntu to serve database
-
vagrant box add dstk dstk_0.51.box
-
vagrant init
-
vagrant up
-
VirtualBox
if errors appear
-Combine fields

-Extract
JSON
blob from DSTK

-Extract lat/lon from blob
cells['Address'].value + ', ' + cells[‘City’].value + ', ' + cells[‘State’].value + ', ' + cells['ZIP'].value
'http://localhost:8080/maps/api/geocode/json?sensor=false&address=' + escape(value, 'url')'
with(value.parseJson().results[0].geometry.location, pair, pair.lat)
with(value.parseJson().results[0].geometry.location, pair, pair.lat)
Contd.
-Export as CSV
-CSV ==>Geo Friendly
-Visualise w/ CartoDB
sources:
http://padaba.com/dst.or/
http://www.datasciencetoolkit.org/
Prepare the data
chadbunn.github.io
Full transcript