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

Street Closures due to Construction Activities by Intersection

478a-yykkTransportation14 columns
DOT Street Closure data identifies locations in the New York City Street Closure map where a street is subject to a full closure, restricting through traffic, for the purpose of conducting construction related activity on a City street. Details about DOT construction permits can be found at Street Works Manual, http://streetworksmanual.nyc. Full Closure Permits are issued for a period of time during which the street may be closed to through traffic for only a portion of the time, and open at other times.
View on NYC Open Data↗

Quality

A92.7 / 100

From a 500-row sample across 14 columns.

completeness100/ 25% weight
consistency71/ 20% weight
accuracy92/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Street Closures due to Construction Activities by Block0.83
    joins onthe_geomfromstreetnameonstreetname+6
  • Street Closures due to Construction Activities by Block and Intersection0.70
    joins onfromstreetnameonstreetnamepurpose
  • Street Resurfacing Schedule0.42
    joins onfromstreetnameonstreetname
  • TLC Driver Exam Testing Center Locations0.37
    joins on:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_f5dn_yrer+1

Geography

Mappable — Socrata point column `the_geom`.

Open on the map →

Sample rows

the_geomnodeidoftonstreetnamefromstreetnameborough_codework_start_datework_end_dateuniqueidpurpose:@computed_region_yeji_bk3q:@computed_region_sbqj_enih
40.85087, -73.887369034561227120237020000000EAST 182 STREETGROTE STREETX2026-10-08T00:00:00.0002026-10-16T00:00:00.000ed1b9a9297f6791b8eeb8e59309fa0b8f46e4810c715d8926dfa739e11ba4f1eDOT IN-HOUSE PAVING531

Columns

10 queryable · 10 profiled

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

FieldTypeDescriptionNullValues
the_geomcoordinateGeometry column0%{'coordinates': [-73.956…{'coordinates': [-74.014…{'coordinates': [-73.956…
nodeidtextThe Node ID is a Department of City Planning LION reference number.0%196891969032970
oftintegerA 18 digit code consisting of three 6-digit street codes representing On-From-To (OFT) streets as returned by GeoSupport functions.0%323230378830000000424340465590000000424290465590000000
onstreetnametextThe On Street Name as is defined in GOAT, the Department of City Planning Geographic Online Address Translator (GOAT).

Query this from your own app

GET /api/datasets/478a-yykk
GET /api/datasets/478a-yykk/quality
GET /api/datasets/478a-yykk/related
GET /api/columns?dataset=478a-yykk
Street Pavement Ratings0.37
joins onthe_geom
  • DOT In-house Street Resurfacing Projects0.36
    joins onborough_code
  • Protected Streets Block (Dataset)0.36
    joins onthe_geom
  • Routes0.35
    • 40.73789, -73.883278924541089045999000000051 AVENUEQUEENS BOULEVARDQ2026-08-03T00:00:00.0002026-10-30T00:00:00.00010a69a0a0c2bf2b21cadfa02b10bfe6760c5c37f68de4dd082596e652106c51cDOT IN-HOUSE PAVING368
    40.70155, -73.99201103538342730349630000000FULTON STREETHICKS STREETB2026-10-16T00:00:00.0002026-10-19T00:00:00.0003da276e2f7aa0ef53dfb05ab3190a37c11442be19c1f8c0667c48440d2b11501DOT IN-HOUSE PAVING254
    40.74868, -73.896159035249437290437395000000BROADWAYBROOKLYN QNS EXPRESSWAYQ2026-09-21T00:00:00.0002026-10-30T00:00:00.0002b721bea6cd8d074451b2b15f87cd802f02aeaba751428258dabc55ff971c8d9DOT IN-HOUSE PAVING366
    40.69930, -73.9888093054311800373135000000ADAMS STREETRED CROSS PLACEB2026-10-15T00:00:00.0002026-10-16T00:00:00.000c8bf1050f4902dca3e9aca60d509f04f1924a6e6b4a1f8a4a5c5ad2a2ae4d298DOT IN-HOUSE PAVING254
    40.71739, -73.8216593069465590466690000000UNION TURNPIKEVLEIGH PLACEQ2026-09-01T00:00:00.0002026-10-30T00:00:00.00055250e408514b6893e2492641ba5e064ff940bac7e88532fe54cac505c937445DOT IN-HOUSE PAVING365
    40.72323, -73.7993455329424540465590000000169 STREETUNION TURNPIKEQ2026-09-14T00:00:00.0002026-10-30T00:00:00.0003ea55586440a13aa794959dbcdca6fe76c1f60a56a5aefb7f9e63dc76becc7c8DOT IN-HOUSE PAVING365
    40.86153, -73.8910648898229220256820000000EAST FORDHAM ROADPARK AVENUEX2026-10-08T00:00:00.0002026-11-13T00:00:00.0000cfe8f79c191c66b4da80cf55b76c15a877ced6d2a73d2ac213bd8a4a89dd085DOT IN-HOUSE PAVING531
    40.72696, -74.00344203931105101149100000006 AVENUECHARLTON STREETM2026-08-24T00:00:00.0002026-10-16T00:00:00.00008c503d026365a7e0768bdd8803670744d480c9ad5362b39224dba3acd0f8744DOT IN-HOUSE PAVING41
    40.73466, -73.864824987541244045179000000060 AVENUEJUNCTION BOULEVARDQ2026-10-26T00:00:00.0002026-12-11T00:00:00.00099f36f1ae12204ba0f452a5072031b927964182fccaa6297b3332ab885ba5adbDOT IN-HOUSE PAVING368

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

    0%
    51 AVENUE1 AVENUE30 AVENUE
    fromstreetnametextFrom Street Name refers to the cross street where the lowest house numbers of the on-street begins, or as defined in GOAT.0%UNION TURNPIKEBROADWAYFRANCIS LEWIS BOULEVARD
    borough_codecategoricalNew York City is composed of five boroughs, each borough has a code as an identifier. "Code Description: M Manhattan X Bronx B Brooklyn Q Queens S Staten Island "0%QBMof 5
    work_start_datedatetimeThe Work Start Date is the date the permit holder can begin the work.0%2026-09-01T00:00:00.0002026-08-19T00:00:00.0002026-08-03T00:00:00.000
    work_end_datedatetimeThe Work End Date is the permit expiration date.0%2026-10-30T00:00:00.0002026-11-27T00:00:00.0002026-11-09T00:00:00.000
    uniqueidtextUnique hexadecimal identification number of each entry.0%f62a5ee34bb45744b7be86d1…a878aee43d68f25bb6427189…52cdc1d5d80792d4b9a8c69b…
    purposetextType of work being done at location.0%DOT IN-HOUSE PAVINGDOT IN-HOUSE MILLINGMAJOR INSTALLATION - GAS