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 (2013-2021)

c9sj-fmsgTransportation39 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 2022-present: https://data.cityofnewyork.us/Transportation/Street-Construction-Permits-2022-Present-/tqtj-sjs8
View on NYC Open Data↗

Quality

C75.6 / 100

From a 500-row sample across 30 columns.

completeness48/ 25% weight
consistency80/ 20% weight
accuracy95/ 20% weight
timeliness57/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Street Construction Permits (2022 - Present)0.84
    joins onnextpermitnumbernumberofcontainersonstreetname+36
  • Street Construction Permits - Fee0.55
    joins onpermitnumbermodifiedoncreatedon
  • Street Construction Permits - Cranes0.53
    joins onpermitnumbermodifiedoncreatedon
  • Street Construction Permits - Related Agency0.52

Geography

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

Sample rows

permitnumberpermitstatusidpermitstatusshortdescpermitseriesidpermitseriesshortdescpermittypeidpermittypedescpermitissuedatepermitteenamecreatedonmodifiedonpermitnumberofzones
B001992115003006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0041MISCELLANEOUS - MINOR SALES1992-04-24T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.000

Columns

39 queryable · 39 profiled

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

FieldTypeDescriptionNullValues
permitnumbertext—0%B001992091001B001992091002B001992091003
applicationtrackingidtext—61%202111150042241620210707009213162021071201044123
sequencenumbertext—55%000100020003
applicationtypeshortdesccategorical—61%NewRenewReissueof 6

Query this from your own app

GET /api/datasets/c9sj-fmsg
GET /api/datasets/c9sj-fmsg/quality
GET /api/datasets/c9sj-fmsg/related
GET /api/columns?dataset=c9sj-fmsg
joins onpermitnumbermodifiedoncreatedon
  • Street Construction Permits - Stipulations (Historical)0.50
    joins onpermitnumbercreatedon
  • Street Construction Permits - Stipulations (2020 - Present)0.50
    joins onpermitnumbercreatedon
  • Street Construction Inspections and Corrective Action Requests0.31
    joins ononstreetnamepermitnumbermodifiedon+4
  • Traffic Volume Counts (Historical)0.30
    • —
    B001992115004006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0041MISCELLANEOUS - MINOR SALES1992-04-24T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.000—
    B001992154004006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0031MISCELLANEOUS - SEARCHES1992-06-02T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001
    B001992155002006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0031MISCELLANEOUS - SEARCHES1992-06-03T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001
    B001992155003006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0031MISCELLANEOUS - SEARCHES1992-06-03T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001
    B001992156001006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0041MISCELLANEOUS - MINOR SALES1992-06-04T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001
    B001992160001006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0031MISCELLANEOUS - SEARCHES1992-06-08T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001
    B001992160002006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0041MISCELLANEOUS - MINOR SALES1992-06-08T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001
    B001992162002006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0031MISCELLANEOUS - SEARCHES1992-06-10T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001
    B001992167001006ISSUED & PRINTED00MISCELLANEOUS CASH RECEIPTS0031MISCELLANEOUS - SEARCHES1992-06-15T00:00:00.000FOREST HILLS JEWISH CENTER2013-12-14T21:03:08.0002013-12-14T21:03:08.0001

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

    permitstatusid
    text
    —
    0%
    030015006
    permitstatusshortdesctext—0%EXPIREDDELINQUENT CUTFORM/COMPA…ISSUED & PRINTED
    permitseriesidcategorical—0%010216of 17
    permitseriesshortdesccategorical—0%STREET OPENING PERMITBUILDING OPERATION PERMI…COMMERICAL REFUSE CONTAI…of 19
    permittypeidtext—0%020403011600
    permittypedesctext—0%PLACE EQUIPMENT OTHER TH…UTILITY MANHOLE EMBARGO …COMMERCIAL REFUSE CONTAI…
    permitnumberofzonesinteger—39%123
    permitlinearfeetinteger—56%30010010
    permittotalsqfeetinteger—79%91218
    permitestimatednumberofcutsinteger—67%123
    equipmenttypedesctext—93%Maintain FenceJersey BarrierBoom Truck
    numberofcontainerscategorical—99%120of 14
    numberofminicontainersinteger—99%0110
    specificstipulationstext—45%ITXAMJ
    previouspermitnumbertext—70%NONES012017275A42S012017275A43
    nextpermitnumbertext—73%M012002253007B011992090007B011999330004
    emergencyissuedatedatetime—95%2004-08-23T00:00:00.0002004-08-30T00:00:00.0002004-10-18T00:00:00.000
    permitissuedatedatetime—0%2014-03-27T00:00:00.0002013-11-14T00:00:00.0002013-11-15T00:00:00.000
    issuedworkstartdatedatetime—0%2018-01-01T00:00:00.0002017-01-01T00:00:00.0002021-01-01T00:00:00.000
    issuedworkenddatedatetime—1%2017-12-31T23:59:59.0002016-12-31T23:59:59.0002015-12-31T23:59:59.000
    boroughnamecategorical—3%MANHATTANBROOKLYNQUEENSof 5
    permithousenumbertext—56%12100
    onstreetnametext—3%BROADWAY3 AVENUE5 AVENUE
    fromstreetnametext—3%5 AVENUE7 AVENUEBROADWAY
    tostreetnametext—18%PARK AVENUEBROADWAY6 AVENUE
    permitteenametext—0%CONSOLIDATED EDISONVERIZON NEW YORK INC.KEYSPAN ENERGY DELIVERY …
    permitpurposecommentstext—52%NB ProjectMOS35841MOS53841
    permitlocationcommentstext—57%See addressMILLING AND PAVINGsegment
    pavementshortdesccategorical—41%ASPHALTCONCRETECOBBLESTONEof 7
    sidewalkshortdesccategorical—43%CONCRETEDISTINCTIVEDIRT SIDEWALKof 9
    createdondatetime—0%2013-12-14T21:03:08.0002014-01-02T15:44:43.0002013-12-17T12:02:46.000
    modifiedondatetime—0%2013-12-14T21:03:08.0002018-06-22T20:16:47.0002018-05-20T00:05:42.000
    oftcodetext—3%134910110410110510134610110610110810134890110410110510
    wkttext—4%LINESTRING (987078.37031…LINESTRING (990566.76524…LINESTRING (987893.47367…
    locationgeometrytext—4%D70800000104030000000000…D7080000011480C2CD87CD3A…D70800000104030000000000…