search

codeforkansascity / Neighborhood-Dashboard

We're working to help neighborhoods help themselves by giving them easy access to useful data to allow them to identify and track problem areas in their neighborhood.
https://neighborhood-dashboard.codeforkc.org/
MIT License
18 stars 9 forks source link

Include Crime data for 2020 #172

Open moldybeats opened 4 years ago

moldybeats commented 4 years ago

The new dataset for 2020 Crime data can be found here:

https://data.kcmo.org/Crime/KCPD-Crime-Data-2020/vsgj-uufz

We need to include this in the crime stats.

moldybeats commented 4 years ago

@AmandaWilsonKC - thought this was going to be a quick task, but I hit a snag. Looks like the 2020 Crime data doesn't include the lat/lon coordinates we need to map crime reports. This was included in previous crime datasets.

I'll include an example of a query from the 2019 data and the 2020 data. You can see how the "location" field in the 2019 query includes latitude and longitude properties while the 2020 data does not:

2019: https://data.kcmo.org/resource/pxaa-ahcm.json?$where=report_no=%27KC19019730%27 2020: https://data.kcmo.org/resource/vsgj-uufz.json?$where=report_no=%27KC20001739%27

This is probably related to the fact that the addresses in the 2020 dataset don't have zip codes.

Is there someone involved in the Open Data KC datasets who could help us get that fixed?

moldybeats commented 4 years ago

We're going to leave this issue unresolved for the moment. Sounds like KCPD switched to a new platform for public crime data.