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

ORR_lines

it7p-hbtdCity Government14 columns
Completed, ongoing, and planned recovery and resiliency projects throughout New York City.
View on NYC Open Data↗

Quality

B85.1 / 100

From a 95-row sample across 14 columns.

completeness99/ 25% weight
consistency96/ 20% weight
accuracy97/ 20% weight
timeliness10/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • ORR_polys0.89
    joins onlinkmore_infoone_nyc+11
  • ORR_points0.89
    joins onlinkmore_infoone_nyc+11
  • Hazard Mitigation Plan - Mitigation Actions Database (Lines)0.33
    joins onthe_geom
  • Hazard Mitigation Plan - Mitigation Actions Database (Polygons)0.30
    joins onthe_geom
  • Hazard Mitigation Plan – Mitigation Actions Database (points)

Geography

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

Sample rows

the_geommang_agenproj_nameorridone_nycproj_valschedulecomp_datefnd_sourcboroughcoun_distcomm_bord
NaN, NaNDepartment of City PlanningResilient Neighborhoods Planning [Multisite]DCP999Buildings8000000PlanningQ4 2016HUD CDBG-DRCitywide1, 2, 3, 13, 18, 31, 32, 42, 46, 48, 50MN-3, MN-4, BX-9, BX-10, BK-15, BK-18, QN-10, QN-14, SI-2, SI-3

Columns

14 queryable · 13 profiled

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

FieldTypeDescriptionNullValues
the_geomunknown———
mang_agencategorical—0%New York City Department…Department of Environmen…Mayor's Office of Recove…of 6
proj_nametext—0%High Level Storm, Sanita…High Level Storm, Sanita…Roma & Hett Avenues Area…
orridtext—0%DEP150DEP159DEP107

Query this from your own app

GET /api/datasets/it7p-hbtd
GET /api/datasets/it7p-hbtd/quality
GET /api/datasets/it7p-hbtd/related
GET /api/columns?dataset=it7p-hbtd
0.26
joins onthe_geom
  • NYC Climate Budgeting Report: Forecast of Emissions and PM 2.5 Reductions from City Actions0.26
  • J-51 Exemption and Abatement (Historical)0.25
  • CDBG-DR Program Categories0.25
    • NaN, NaNDepartment of Environmental ProtectionStorm and Sanitary Sewer Work at Twin Pond Bluebelts (BMP)DEP091Infrastructure21000000ConstructionQ3 2018City FundsQueens31QN-13
    NaN, NaNDepartment of Environmental ProtectionSpringfield Gardens Residential Area ReconstructionDEP100Infrastructure84000000CompletedQ2 2016City Funds, NYS, Other FederalQueens31QN-13
    NaN, NaNDepartment of Environmental ProtectionHigh Level Storm, Sanitary & Combined Sewers in Fresh Creek Basin - Phase 3ADEP104Infrastructure20000000DesignQ4 2022City FundsBrooklyn42BK-5
    NaN, NaNDepartment of Environmental ProtectionStorm and Sanitary Sewer Work at Last Chance Pond (BMP)DEP106Infrastructure37000000DesignQ1 2020USDAStaten Island50SI-2
    NaN, NaNDepartment of Environmental ProtectionStorm & Sanitary Sewer Construction & Water Main Replacement in Mason AveDEP107Infrastructure35000000DesignQ1 2021City FundsStaten Island50SI-2
    {"type":"MultiLineString","coordinates":[[[-74.18065906145007,40.55772138703883],[-74.18015368766368,40.5583124569334],[-74.18032692049941,40.55997178801753],[-74.18040908564626,40.56053797279521],[-74.18042286397203,40.560663513494745],[-74.18057709073312,40.56137052193994],[-74.18072345039647,40.56206643811627],[-74.18086758703743,40.562767482470385],[-74.18101173364775,40.56347108949062],[-74.18116150585408,40.5641832298199],[-74.18131123256711,40.56487743148618]]]}Department of Environmental ProtectionStorm, Sanitary Sewer, and Water Main Work in Woodrow Road (BMP)DEP118Infrastructure14000000CompletedQ4 2014USDAStaten Island51SI-3
    NaN, NaNDepartment of Environmental ProtectionStorm and Sanitary Sewers in Snug Harbor Area (BMP)DEP109Infrastructure35000000DesignQ2 2021USDAStaten Island49SI-1
    NaN, NaNDepartment of Environmental ProtectionHigh Level Storm, Sanitary & Combined Sewers in Fresh Creek Basin - Phase 2ADEP110Infrastructure56000000DesignQ4 2020City FundsBrooklyn42BK-5, BK-18
    NaN, NaNDepartment of Environmental ProtectionHigh Level Storm, Sanitary & Combined Sewers in Fresh Creek Basin - Phase 2BDEP111Infrastructure48000000DesignQ4 2020City FundsBrooklyn42BK-5, BK-18

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

    one_nyccategorical—0%InfrastructureCoastal DefenseNeighborhoodsof 4
    proj_valinteger—0%40000001300000019000000
    schedulecategorical—0%DesignConstructionPlanningof 4
    comp_datetext—8%Q2 2019Q4 2020Q3 2018
    fnd_sourctext—0%City FundsFEMA, City FundsFHWA, City Funds
    boroughcategorical—0%QueensStaten IslandBrooklynof 6
    coun_disttext—0%515032
    comm_bordtext—0%QN-14SI-2SI-3
    more_infotext—0%Work includes roadway re…Work includes roadways, …Work includes storm & co…
    linkurl—0%http://www1.nyc.gov/html…http://www.nycgovparks.o…http://www.nycedc.com/pr…of 5