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 Inspections and Corrective Action Requests

ydkf-mpxbTransportation27 columns
DOT's Highway Inspection & Quality Assurance (HIQA) enforces the laws and rules that govern the way utilities, plumbers, contractors, other governmental agencies, and property owners perform work on the City's sidewalks, roadways and highways. DOT's inspectors also review work sites for compliance with permit stipulations, and issue violations when they find non-compliance with the laws and rules.
View on NYC Open Data↗

Quality

B82.7 / 100

From a 500-row sample across 26 columns.

completeness52/ 25% weight
consistency83/ 20% weight
accuracy91/ 20% weight
timeliness99/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Street Construction Permits (2022 - Present)0.35
    joins ontostreetnamecreatedonpermitnumber+4
  • Street Sign Work Orders0.35
  • Sidewalk Management Database - Violations0.35
  • Parking Regulation Locations and Signs0.35
  • Open Restaurants Inspections (Historical)0.33
  • Bus Breakdown and Delays0.32
  • Street Resurfacing Schedule0.31

Geography

Has street addresses (`onstreetname`) — needs geocoding before it can be drawn.

Sample rows

inspectionidpermitnumberpermitteenamepermittypeonstreetnamefromstreetnametostreetnameinspectiontypeinspectiondateinspectionresulttypeinspectionremarkscarnumber
6461232M012017026A08EASY STREET PLUMBING, INC.REPAIR WATER - PROTECTEDMADISON AVENUEEAST 72 STREETEAST 73 STREETComplaint2017-01-26T22:04:49.000ZCAR (Other)found 3 steel plates marked AFIG countersunken w/ plow sign post it ; plates not sitting flat in the grove creating noise when cars drive over.

Columns

27 queryable · 27 profiled

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

FieldTypeDescriptionNullValues
inspectionidinteger—0%234
permitnumbertext—0%Q012017354C18B012015092A16B012018037C36
permitteenametext—0%CONSOLIDATED EDISONTHE BROOKLYN UNION GAS C…VERIZON NEW YORK INC.
permittypetext—0%PLACE EQUIPMENT OTHER TH…MAJOR INSTALLATION - GASREPAIR GAS

Query this from your own app

GET /api/datasets/ydkf-mpxb
GET /api/datasets/ydkf-mpxb/quality
GET /api/datasets/ydkf-mpxb/related
GET /api/columns?dataset=ydkf-mpxb
joins ontostreetnameonstreetnamefromstreetname
  • Open Restaurant Applications (Historical)0.30
    • 20173620041
    6461233Q012017026B54CONSOLIDATED EDISONREPAIR GASBEECHKNOLL AVENUEDEAD ENDMARATHON PARKWAYE-Number2017-01-26T22:26:56.000ZPassexcavation barricaded in r/w—
    6461234M012017011A98CONSOLIDATED EDISONFINAL RESTORATION ONLY - PROTECTEDEAST 80 STREET2 AVENUE3 AVENUEComplaint2017-01-26T22:41:19.000ZCAR (Other)one steel plate with no pins & no ramping in the roadway serving no purpose20173620042
    6461235Q012017026B55CONSOLIDATED EDISONREPAIR GAS23 AVENUE204 STREET205 STREETE-Number2017-01-26T22:43:55.000ZNOV (Other)A/T/P/O I observed the above respondent failed to display required sign at the work site. The respondent did not display the permit number, telephone number and the type of work being done.—
    6461236B162017017A55UNITED CONTAINERS OF QUEENS INC.COMMERCIAL REFUSE CONTAINEREAST 5 STREETAVENUE FDITMAS AVENUEPost-Audit2017-01-26T22:52:45.000ZPassContainer On Site New Permit#B162017022A00 On File Expires 1/26/17—
    6461237B012017019B37TRIBORO WATER MAIN AND SEWER CORP.REPAIR WATER - PROTECTEDNOSTRAND AVENUEGATES AVENUEQUINCY STREETComplaint2017-01-26T22:48:18.000ZNICA5 countersunken plates marked Triboro bouncing 2 inches as cars drive over20174860015
    6461238BNP2017026A30NYC DEPT OF ENVIRONMENTAL PROTECTIONNON PERMITST JOHNS PLACESCHENECTADY AVENUETROY AVENUEPick-Up2017-01-26T22:58:55.000ZCAR (Other)15'x10' area of sidewalk broken and cracked sunken 5-7 inches adjacent to NYC Sewer manhole20174860016
    6461239Q022016341A56TRIBOROUGH CONSTRUCTION SERVICES INC.PLACE MATERIAL ON STREETHUNTER STREET27 STREETQNSBO BR UP RY APPROACHActive2017-01-26T23:13:24.000ZPassmaterial stored on street—
    6461240Q022016341A62TRIBOROUGH CONSTRUCTION SERVICES INC.PLACE EQUIPMENT OTHER THAN CRANE OR SHOVHUNTER STREET27 STREETQNSBO BR UP RY APPROACHActive2017-01-26T23:14:14.000ZPassfence stored on sidewalk—
    6461241Q022016341A61TRIBOROUGH CONSTRUCTION SERVICES INC.PLACE EQUIPMENT OTHER THAN CRANE OR SHOVHUNTER STREET27 STREETQNSBO BR UP RY APPROACHActive2017-01-26T23:14:40.000ZPassboom truck stored—

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

    onstreetnametext—0%BROADWAY3 AVENUE2 AVENUE
    fromstreetnametext—0%5 AVENUEBENDBROADWAY
    tostreetnametext—13%BROADWAYPARK AVENUE3 AVENUE
    specificlocationtext—66%*INTERSECTIONOP 32
    inspectiontypecategorical—0%Post-AuditActiveCAR Re-Inspectof 12
    inspectiondatedatetime—0%2008-06-04T00:00:00.000Z2008-04-08T00:00:00.000Z2008-06-07T00:00:00.000Z
    inspectionresulttypetext—0%PassWork Not StartedCAR (Other)
    inspectionremarkstext—20%work not startedperm to gradework done
    carnumbertext—94%200436900022004369000320043690004
    defectivecutscategorical—94%012of 11
    feetfromcrossstreetinteger—94%01001
    feetfromcurbinteger—94%015
    carcommentstext—94%- Sidewalk expansion joi…- Restoration needs to b…- Remove Barricades Left…
    laneofcutcategorical—94%DrivingSideWalkParkingof 8
    trafficflowcategorical—94%MediumHeavyLightof 4
    crossstreetnametext—97%IntersectionN/ABROADWAY
    curbstreetnametext—100%—
    novnumbertext—97%000000002000000003000000004
    novcodetext—95%D4FD30D01
    novcodedescriptiontext—95%Failure to permanently r…Failure to comply with t…Use/opening of street wi…
    detailsofviolationtext—95%Failure to obtain a conf…Failure to permanently r…Failed to seal expansion…
    createdondatetime—0%2012-03-14T11:30:08.000Z2012-03-01T18:33:05.000Z2016-04-16T01:34:40.000Z
    modifiedondatetime—0%2012-03-14T11:30:08.0002012-03-01T18:33:05.0002016-04-16T01:34:40.000