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

OER Cleanup Sites

3279-pp7vEnvironment18 columns
Properties remediated under OER's oversight, both in the E-Designation program and the NYC Voluntary Cleanup Program. Includes sites completed and in progress.
View on NYC Open Data↗

Quality

A92.4 / 100

From a 500-row sample across 18 columns.

completeness99/ 25% weight
consistency78/ 20% weight
accuracy95/ 20% weight
timeliness100/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • DSNY Special Waste Drop-off Sites0.31
  • Urban Park Ranger Animal Condition Response0.30
    joins onborough
  • Forestry Tree Points0.30
  • Food Scrap Drop-Off Locations in NYC0.30
    joins onlatitudebblborough+1
  • DSNY Litter Basket Inventory0.30
    joins onlatitudeboroughlongitude
  • Asbestos Control Program (ACP7)0.29

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

oer_project_numbersproject_namestreet_numberstreet_nameboroughbbloer_programclassphaseproject_specific_documentlatitudelongitude
15TMP0176M,15EH-A176M,15CVCP096M572 & 568-570 Broome Street572Broome StreetManhattan1005780075,1005780077,1005787501VCP (Enrolled), E/RD (Review)Completed (C)Completed{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/2609"}40.724469

Columns

18 queryable · 17 profiled

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

FieldTypeDescriptionNullValues
oer_project_numberstext—0%17TMP0458K,18EHAZ395K22TMP0410K,22EH-N088K14TMP0450M,14EHAN450M
project_nametext—0%111 Leroy Street434 Manhattan Ave3545 WHITE PLAINS ROAD
street_numbertext—0%150400
street_nametext—0%Fulton Street3rd AvenueGrand Street

Query this from your own app

GET /api/datasets/3279-pp7v
GET /api/datasets/3279-pp7v/quality
GET /api/datasets/3279-pp7v/related
GET /api/columns?dataset=3279-pp7v
joins onlatitudestreet_namebbl+3
  • Electronics Drop Off Locations in NYC0.28
    joins onlatitudebblcommunity_district+2
  • Clean Air Tracking System (CATS) Permits0.28
    joins onborough
  • -74.006649
    14TMP0137M,14EH-N137M,17CVCP010M350 West 39th Street350West 39th StreetManhattan1007620006,1007620067VCP (Enrolled), E/RD (Review)Completed (C)Site Management{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/2299"}40.755932-73.992626
    17TMP0501X,18EHAN451X1221 Spofford Avenue (The Peninsula Site 1A/1B)1221SPOFFORD AVENUEBronx2027380035,2027630001,2027630002,2027630029,2027380036,2027380037E/RD (Review), State BCPCompleted (C)Completed{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/4144"}40.813893-73.890566
    22TMP1581K,22EH-N359K62 HURON STREET62HURON STREETBrooklyn3025310010E/RD (No Cleanup)Active (A)Approved Remedial Plan{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/33028"}40.732594-73.959245
    22TMP1526X,22EHAN344X,23CVCP044X1985 JEROME AVENUE1985JEROME AVENUEBronx2028630050VCP (Withdrawn), E/RD (Review)Active (A)Closure{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/32973"}40.852340-73.908718
    13TMP0215Q,13ENOS215Q49-18 Vernon Boulevard (DOB Job No: 420602324)49-18Vernon BlvdQueens4000320001E/RD (No Cleanup)Active (A)Closure{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/1886"}40.743228-73.953945
    21TMP0660Q,21EH-N141Q46-30 21st Street46-3021ST STREETQueens4000560051,4000567501E/RD (Review)Completed (C)Completed{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/21468"}40.745183-73.948349
    21TMP0325X,21EH-N074X,21CVCP021X1400 Cromwell Avenue1400CROMWELL AVENUEBronx2028570001VCP (Enrolled), E/RD (Review)Completed (C)Site Management{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/20134"}40.841163-73.919557
    16TMP0224K,16EHAZ222K,17CVCP018K74-76 Ainslie Street74Ainslie StreetBrooklyn3023750010VCP (Enrolled), E/RD (Review)Completed (C)Site Management{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/3359"}40.712580-73.951957
    15TMP0592K,15CVCP148KHenry Apartments - Site A - 1676 Broadway1676BroadwayBrooklyn3015030029,3015037501,3015030031,3015030034,3015030038VCP (Enrolled)Completed (C)Completed{"url":"https://a002-epic.nyc.gov/environment/public/document-repository/2545"}40.684159-73.912683

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

    borough
    categorical
    —
    0%
    BrooklynManhattanQueensof 5
    bbltext—0%100962750110037700663000200029
    oer_programcategorical—1%VCP (Enrolled), E/RD (Re…E/RD (Review)E/RD (No Cleanup)of 15
    classcategorical—0%Completed (C)Active (A)of 2
    phasecategorical—0%CompletedSite ManagementClosureof 5
    project_specific_documenturl———
    latitudecoordinate—1%40.71309640.75357440.714156
    longitudecoordinate—1%-73.954602-73.959716-73.978202
    zip_codetext—1%112111110111222
    community_districtcategorical—1%123of 19
    city_council_districttext—1%33326
    census_tract_2010text—1%9955531
    building_identification_numbertext—6%300000040000001000000
    nta_nametext—1%North Side-South SideHudson Yards-Chelsea-Fla…Greenpoint