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 Construction Permits (2022 - Present)

tqtj-sjs8Transportation39 columns
DOT issues over 150 different types of sidewalk and roadway construction permits to utilities, contractors, government agencies and homeowners. Permits cover activities such as street openings, sidewalk construction and installing canopies over sidewalks. The core permit data, including permittee, type of permit, date issued, location. Street Construction Permits 2013-2021: https://data.cityofnewyork.us/Transportation/Street-Construction-Permits-2013-2021-/c9sj-fmsg
View on NYC Open Data↗

Quality

B86.5 / 100

From a 500-row sample across 39 columns.

completeness72/ 25% weight
consistency77/ 20% weight
accuracy91/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Street Construction Permits (2013-2021)0.84
    joins onpreviouspermitnumbertostreetnamefromstreetname+36
  • Street Construction Permits - Fee0.55
    joins onmodifiedoncreatedonpermitnumber
  • Street Construction Permits - Related Agency0.53
    joins onmodifiedoncreatedonpermitnumber
  • Street Construction Permits - Stipulations (2020 - Present)0.53

Geography

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

Sample rows

permitnumberapplicationtrackingidsequencenumberapplicationtypeshortdescpermitstatusidpermitstatusshortdescpermitseriesidpermitseriesshortdescpermittypeidpermittypedescpermitnumberofzonespermitlinearfeet
B012026247B6120260901004412960034New006ISSUED & PRINTED01STREET OPENING PERMIT0120TREE PITS125

Columns

39 queryable · 39 profiled

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

FieldTypeDescriptionNullValues
permitnumbertext—0%B002022003A01B002022003A02B002022005A00
applicationtrackingidtext—0%202303270126096020220524005629362023061300973320
sequencenumbertext—0%000100020003
applicationtypeshortdesccategorical—0%NewRenewReissueof 6

Query this from your own app

GET /api/datasets/tqtj-sjs8
GET /api/datasets/tqtj-sjs8/quality
GET /api/datasets/tqtj-sjs8/related
GET /api/columns?dataset=tqtj-sjs8
joins oncreatedonpermitnumber
  • Street Construction Permits - Cranes0.53
    joins onmodifiedoncreatedonpermitnumber
  • Street Construction Permits - Stipulations (Historical)0.47
    joins oncreatedonpermitnumber
  • Street Construction Inspections and Corrective Action Requests0.35
    joins ontostreetnamefromstreetnamemodifiedon+4
  • Bus Breakdown and Delays0.35
    • B012026247B6220260901004412960036New006ISSUED & PRINTED01STREET OPENING PERMIT0162NYC PARKS - RECONSTRUCTION CONTRACT125
    B012026247B6320260901011377630001New006ISSUED & PRINTED01STREET OPENING PERMIT0120TREE PITS1100
    B012026247B7520260904006701930001New020EXPIRED UNDER GUARANTEE01STREET OPENING PERMIT0174TRIBUTARY INSTALL - ELECTRIC190
    B012026247B6920260904007294600001Renew020EXPIRED UNDER GUARANTEE01STREET OPENING PERMIT0124REPAIR ELECTRIC/COMMUNICATIONS165
    B012026247B7020260904007307860001Renew020EXPIRED UNDER GUARANTEE01STREET OPENING PERMIT0124REPAIR ELECTRIC/COMMUNICATIONS165
    B012026247B6420260901011377630002New006ISSUED & PRINTED01STREET OPENING PERMIT0120TREE PITS1100
    B012026247B6520260901011377630003New006ISSUED & PRINTED01STREET OPENING PERMIT0120PTREE PITS - PROTECTED1100
    B012026247B6620260901011377630005New006ISSUED & PRINTED01STREET OPENING PERMIT0120TREE PITS1100
    B012026247B7420260904007450100001Renew020EXPIRED UNDER GUARANTEE01STREET OPENING PERMIT0124REPAIR ELECTRIC/COMMUNICATIONS1200

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

    permitstatusid
    categorical
    —
    0%
    030020006of 16
    permitstatusshortdesccategorical—0%EXPIREDEXPIRED UNDER GUARANTEEISSUED & PRINTEDof 16
    permitseriesidcategorical—0%010216of 10
    permitseriesshortdesccategorical—0%STREET OPENING PERMITBUILDING OPERATION PERMI…COMMERCIAL REFUSE CONTAI…of 11
    permittypeidtext—0%020416000211
    permittypedesctext—0%PLACE EQUIPMENT OTHER TH…COMMERCIAL REFUSE CONTAI…OCCUPANCY OF ROADWAY AS …
    permitnumberofzonesinteger—49%124
    permitlinearfeetinteger—49%30010050
    permittotalsqfeetinteger—88%55001
    permitestimatednumberofcutsinteger—83%123
    equipmenttypedesctext—86%Maintain FenceJersey BarrierPort-o-San
    numberofcontainerscategorical—98%120of 11
    numberofminicontainersinteger—99%0110
    specificstipulationstext—18%DPXAMS
    previouspermitnumbertext—53%S012022363A60S012022363A68S012022363A72
    nextpermitnumbertext—54%B012017094A58B012017111A04B012017118A66
    emergencyissuedatedatetime—97%2018-12-12T09:29:01.0002019-07-24T00:42:33.0002019-01-15T08:40:24.000
    permitissuedatedatetime—0%2026-06-15T08:26:37.0002026-06-15T08:34:13.0002026-06-24T09:15:17.000
    issuedworkstartdatedatetime—0%2025-01-01T00:00:00.0002026-01-01T00:00:00.0002024-01-01T00:00:00.000
    issuedworkenddatedatetime—0%2025-12-31T23:59:59.0002024-12-31T23:59:59.0002023-12-31T23:59:59.000
    boroughnamecategorical—0%BROOKLYNMANHATTANQUEENSof 5
    permithousenumbertext—64%152001
    onstreetnametext—0%BROADWAY3 AVENUE5 AVENUE
    fromstreetnametext—0%BEND5 AVENUEBROADWAY
    tostreetnametext—16%PARK AVENUEBROADWAYBEND
    permitteenametext—0%CONSOLIDATED EDISONTHE BROOKLYN UNION GAS C…VERIZON NEW YORK INC.
    permitpurposecommentstext—29%NB ProjectMAJOR INSTALLATION - GASGAS MAIN
    permitlocationcommentstext—38%SEGMENT AND INTERSECTIONSEE SKETCHSEE SKETCH FOR DETAILS
    pavementshortdesccategorical—34%ASPHALTCONCRETECOBBLESTONEof 6
    sidewalkshortdesccategorical—27%CONCRETEDIRT SIDEWALKBLUE STONE (SOME LANDMAR…of 6
    createdondatetime—0%2013-12-14T21:03:08.0002023-08-31T09:18:37.0002022-12-23T12:16:13.000
    modifiedondatetime—0%2025-01-01T00:05:17.0002024-01-01T00:05:10.0002026-01-01T00:05:13.000
    oftcodetext—22%134590111010116920134910100039110510134050110510110610
    wkttext—22%LINESTRING (985807.52639…LINESTRING (990566.76540…LINESTRING (985125.73330…
    locationgeometrytext—22%D70800000114004D840D9F15…D708000001148082E287CD3A…D70800000114001973774B10…