Air: DEP dataset output schema

[AmandaDoyle]

Field Name	Alias	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]

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]

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.