search

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

Air: DEP data subset for research #80

Closed AmandaDoyle closed 4 years ago

AmandaDoyle commented 4 years ago

Create subset of DEP dataset that contains only C-prefix permits with Certificate to Operate for research

mgraber commented 4 years ago

@AmandaDoyle Is this a subset of the source data or of the geocoded data?

mgraber commented 4 years ago 
SELECT * FROM dep_cats_permits.latest
WHERE LEFT(applicationid, 1) = 'C'
AND requesttype = 'CERTIFICATE TO OPERATE';

With 2019/09/24 data, the subset for review has 24044 records.

AmandaDoyle commented 4 years ago

subset of the source data

mgraber commented 4 years ago

For now, extract this subset from recipes with a query. Not needed in code yet.