search

NYCPlanning / db-zoningtaxlots

Zoning Tax Lot Database (ZTLDB) -- associates zoning designations with lots from the Department of Finance Digital Tax Map
https://edm-data-engineering.nycplanningdigital.com/?page=Zoning+Tax+Lots
0 stars 0 forks source link

Add special subdistrict fields #91

Open AmandaDoyle opened 3 years ago

AmandaDoyle commented 3 years ago

There are three fields in ZTLDB for special zoning districts. Add three additional fields for the corresponding subdistricts: subdistrict1, subdistrict2, subdistrict3. To create a description for the subdistricts in ZTLDB, concatenate three fields from nysp_sd: SUBDIST_LBL, SUBAREA_LBL, and SUBAREA_OTR. If the lot has more than one subdistrict for a given special district, the corresponding subdistrict field in ZTLDB will contain all of them, separated by semicolons.

Examples:

Lot with one special district and four different special subdistrict values BBL 3070730101 specialdistrict1 = 'CI' subdistrict1 = 'CW; CW, Parcel E; CW, Parcel F; KeySpan Park'

Lot with more than one special district, each with a sub-district BBL 1010340027 specialdistrict1 = 'CL' specialdistrict2 = 'MiD' subdistrict1 = 'B, Subject to Article 8 Chapter 1(MID)' subdistrict2 = 'Theater Subdistrict, Theater Subdistrict Eighth Avenue Corridor'

Subdistricts will be assigned to a lot if they cover at least 10% of the lot's area. This is the same criteria we use for other zoning data.

Need to finalize source data because apparently polygon file only contains ~30% of subdistrict data.

Only use polygon dataset.

AmandaDoyle commented 3 years ago

Once data is release review LS's latest logic before working on