search

FireCARES / firecares

The FireCARES application.
http://www.firecares.org
MIT License
11 stars 11 forks source link

Investigate cause of missing lat/lons for EMS heatmaps #497

Open meilinger opened 5 years ago

meilinger commented 5 years ago

A LOT of departments appear to not have geospatial information associated w/ EMS incidents prior to 2013. The goal of this task is to identify what might be the cause (bad query? missing data?).

josellausas commented 5 years ago

For the years 2012 and 2013, number of entries with geom=83.6527741894442;90

screen shot 2018-10-22 at 5 41 22 pm

For the years 2014 and 2015, number of entries with geom=18446743673.7096,18446743673.7096 screen shot 2018-10-22 at 5 29 06 pm

josellausas commented 5 years ago

NYPD has no entries for ems.

SELECT count(1) FROM ems.ems
WHERE fdid='24001' and state='NY'
// 0!!!

SELECT count(1) FROM ems.incidentaddresses
WHERE fdid='24001' and state='NY'
// 2,392,348