Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

E-Designations

hxm3-23vyCity Government16 columns
This data set contains information and locations of (E) Designations, including CEQR Environment Requirements (Table 1) and CEQR Restrictive Declarations (Table 2), in Appendix C of the Zoning Resolution. An (E) Designation provides notice of the presence of an environmental requirement pertaining to potential hazardous materials contamination, high ambient noise levels or air emission concerns on a particular tax lot. All previously released versions of this data are available on the DCP Website: BYTES of the BIG APPLE . Current version: 20260707
View on NYC Open Data↗

Quality

A92.3 / 100

From a 500-row sample across 13 columns.

completeness92/ 25% weight
consistency77/ 20% weight
accuracy97/ 20% weight
timeliness95/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • PLUTO Change File0.36
    joins onbbl
  • NYC Zoning Tax Lot Database0.36
    joins onbbl
  • 2020 Community District Tabulation Areas (CDTAs)0.35
    joins onborocode
  • 2020 Census Blocks0.35
    joins onborocode
  • 2020 Census Tracts0.35
    joins onborocode
  • Zoning Application Portal (ZAP) - Project Data

Geography

Has borough codes (`borocode`) — joinable, but needs boundary shapes to draw.

Sample rows

enumbereffective_dateborocodetaxblocktaxlothazmat_codeair_codenoise_codeceqr_numulurp_numdescriptionbbl
E-11983-04-28T00:00:00.00033191falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190001
E-11983-04-28T00:00:00.000

Columns

16 queryable · 16 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
enumbertextIdentification number assigned to E-Designations0%E-175E-138E-216
effective_datedatetimeThe date the E-Designation went in to effect or was established.0%2007-09-10T00:00:00.0002005-05-11T00:00:00.0002009-07-29T00:00:00.000
borocodecategoricalA one digit numeric code that represents the Borough of New York City where the E-desigination is located0%341of 5
taxblockintegerA five digit numeric code that represents the tax block where the E-desigination is located0%

Query this from your own app

GET /api/datasets/hxm3-23vy
GET /api/datasets/hxm3-23vy/quality
GET /api/datasets/hxm3-23vy/related
GET /api/columns?dataset=hxm3-23vy
0.34
  • Borough Boundaries0.31
    joins onborocode
  • Primary Land Use Tax Lot Output (PLUTO)0.31
    joins onbblborocode
    • 3
    319
    10
    false
    false
    true
    82-252K
    C830178ZMK
    Double Glazed Windows
    3003190010
    E-11983-04-28T00:00:00.000331911falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190011
    E-11983-04-28T00:00:00.000331912falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190012
    E-11983-04-28T00:00:00.000331913falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190013
    E-11983-04-28T00:00:00.000331914falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190014
    E-11983-04-28T00:00:00.000331915falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190015
    E-11983-04-28T00:00:00.000331916falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190016
    E-11983-04-28T00:00:00.000331917falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190017
    E-11983-04-28T00:00:00.000331918falsefalsetrue82-252KC830178ZMKDouble Glazed Windows3003190018

    Showing 12 of 13 columns. All of them are listed below.

    111623801468
    taxlotintegerA four digit numeric code that represents the tax block where the E-desigination is located0%157
    hazmat_codebooleanA code indicating whether the E-Designation is related to hazardous materials0%TrueFalseof 2
    air_codebooleanA code indicating whether the E-Designation is related to air quality0%FalseTrueof 2
    noise_codebooleanA code indicating whether the E-Designation is related to noise quality to air quality0%TrueFalseof 2
    hazmat_datedatetimeThe date the hazardous material component of the E-designation was satisfied (remediated)100%—
    air_datedatetimeThe date the air quality component of the E-designation was satisfied (remediated)100%—
    noise_datedatetimeThe date the noise quality component of the E-designation was satisfied (remediated)98%2025-12-19T00:00:00.0002023-05-30T00:00:00.0002018-08-02T00:00:00.000
    ceqr_numtextCEQR Number assigned to CEQR applications associated to the E-designation0%05DCP081Q04DCP003K07DCP078M
    ulurp_numtextULURP Numbers assigned to all ULURP applications associated to the E-designation0%C070314AZMQ; N070315AZRQC050111ZMK; C050111AZMK;…C080397AZMM; N080398AZRM
    zoning_maptextZoning Map index number associated to the E-designation100%—
    descriptiontextA description of the E-Designation5%Window Wall Attenuation …Hazardous Materials* Pha…Underground Gasoline Sto…
    bblintegerA ten digit numeric code that represents the tax lot where the E-desigination is located0%100778001610198700013011427503