search

openoakland / OakCrime-Decommissioned

Code supporting citizen analysis of crime in Oakland, CA
22 stars 16 forks source link

Create access to Socrata API #1

Closed rbelew closed 7 years ago

TomPyle commented 7 years ago

I attached this mapping document for replacing current input with new API: crimeApiDownloadFormatOpdJson.txt

In the short run, from master branch version of opdata.py cloned to new local server 54.183.111.215, a translated version of the regular CSV new input will be mapped like this from the new downloaded JSON format file, 3xav-7geq.201601206.json. After a bit more work, maybe the json input file will replace the csv format for the same data.

TomPyle commented 7 years ago

The current file called for as direct new OPD update file has fewer elements:

$head -2 crimePublicData.csv "CrimeType","DateTime","CaseNumber","Description","PoliceBeat","Address","City","State" "FELONY ASSAULT","2016-09-28 01:00:00","16-051524","SHOOT AT INHABITED DWELLING/VEHICLE/ETC","34X","9200 HOLLY ST","Oakland","CA" But I'm starting my test of the local batch environment with this original set of data. Mapping this original set first, and adding additional CSV fields from new JSON API (via python interim conversion) will be the next step.