Air: DEP dataset output schema

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

Open AmandaDoyle opened 4 years ago

AmandaDoyle commented 4 years ago

Field Name	Hide for public view	Update Frequency
requestid	Y	Monthly
applicationid	N
requesttype	N
ownername	N
expiration_date	N
make	N
model	N
burnermake	N
burnermodel	N
primaryfuel	N
secondaryfuel	N
quantity	N
issue_date	N
status	N
premisename	N
housenum	N
streetname	N
borough	N
geo_housenum	Y
geo_streetname	Y
geo_address	Y
geo_bbl	Y
geo_bin	Y
geo_latitude	Y
geo_longitude	Y
geom	Y

mgraber commented 4 years ago

Changes from current output schema:

Remove address
Remove streetname_1
Remove streetname_2
Remove geo_x_coord
Remove geo_y_coord
Remove geo_function: Consider removing this only in the output table, and retaining in the geo_rejects table

mgraber commented 4 years ago

Need to rework how to remove the fields geo_function ,geo_x_coord, and geo_y_coord, since the creation of the field geom depends on them.