NYCPlanning / ceqr-app-data-archive

(DEPRECATED)data pipelines for CEQR app, managed by data engineering
https://github.com/NYCPlanning/ceqr-app-data
1 stars 1 forks source link

Improve Geocoding / address cleanup for DEP air quality permits #45

Closed AmandaDoyle closed 4 years ago

AmandaDoyle commented 4 years ago

If any component of the address is missing (house number (i.e. 13B), street name, borough) we cannot fix the address Do not fix addresses where the error code indicates there is an extra hyphen (GRC 13 3) Most likely cannot fix addresses where GRC = 13

baolingz commented 4 years ago
-- number of records where GRC code or GRC code 2 is 42 or 41
-- 818
SELECT * FROM dep_cats_permits.geo_rejects
WHERE geo_grc = '42' OR geo_grc = '41'
OR geo_grc2 = '42' OR geo_grc2 = '41'
;