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

Sidewalk Management Database - ReInspection

gx72-kirfTransportation8 columns
Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks. A reinspection can be requested by the property owner if they do not agree with the initial inspection. A different DOT inspector performs a second sidewalk inspection. For more information please visit NYC DOT website: www.nyc.gov/sidewalks
View on NYC Open Data↗

Quality

B88.5 / 100

From a 500-row sample across 8 columns.

completeness91/ 25% weight
consistency63/ 20% weight
accuracy96/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Sidewalk Management Database - Violations0.55
  • Protected Streets Block (Dataset)0.32
  • Taxi Improvement Fund (TIF) Medallion Payments0.32
  • Medallion Taxi Initial Inspection Schedule0.31
  • Street Resurfacing Schedule0.31
  • TLC New Driver Application Status0.31
  • Street Hail Livery (SHL) Drivers - Active0.30
  • For Hire Vehicles (FHV) - Active Drivers

Sample rows

reinspectionidrequestreinspectionrequestreinspectiondatedamageiddamagetypecodereinspectsqftactualreinspectdateresponsedate
14711Yes2010-10-14T00:00:00.0005NS———
7658Yes—5NS01999-01-21T00:00:00.000—

Columns

8 queryable · 8 profiled

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

FieldTypeDescriptionNullValues
reinspectionidintegerUnique numerical ID used to track inspection records.0%2808979924481
requestreinspectioncategoricalIf the property owner requested a re-inspection.0%YesNoof 2
requestreinspectiondatedatetimeThe date the re-inspection was requested by the property owner.18%2004-04-22T00:00:00.0002010-09-21T00:00:00.0002010-12-17T00:00:00.000
reinspectsqftintegerThe square footage of the defective sidewalk identified from the re-inspection.15%

Query this from your own app

GET /api/datasets/gx72-kirf
GET /api/datasets/gx72-kirf/quality
GET /api/datasets/gx72-kirf/related
GET /api/columns?dataset=gx72-kirf
0.30
30014
Yes
2019-04-25T00:00:00.000
5
NS
91
2019-08-21T00:00:00.000
2019-11-13T00:00:00.000
20027Yes2012-11-19T00:00:00.0005NS352013-03-20T00:00:00.0002013-04-08T00:00:00.000
2673Yes—5NS6851993-09-22T00:00:00.0001993-09-23T00:00:00.000
20044Yes2012-11-30T00:00:00.0005NS29072013-11-04T00:00:00.0002013-11-26T00:00:00.000
20309Yes2013-04-29T00:00:00.0005NS1252013-07-18T00:00:00.0002013-07-26T00:00:00.000
29439Yes2018-11-25T00:00:00.0005NS1322019-02-28T00:00:00.0002019-05-07T00:00:00.000
30262Yes2019-05-03T00:00:00.0005NS12302020-02-14T00:00:00.0002021-02-09T00:00:00.000
18282No—5NS1302012-06-13T00:00:00.0002012-06-27T00:00:00.000
0
50
25
actualreinspectdatedatetimeThe actual date the re-inspection was performed on the property.9%2022-09-14T00:00:00.0002016-09-21T00:00:00.0002017-04-12T00:00:00.000
responsedatedatetimeThe date the re-inspection results were mailed to the property owner.33%2024-08-26T00:00:00.0002019-02-28T00:00:00.0002019-04-18T00:00:00.000
damageidcategoricalA numerical code identifying the root of the sidewalk damage.0%563of 6
damagetypecodecategoricalIdentifies if all or any of the sidewalk defects are caused by a City tree0%NSNLNTof 6