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 Pothole Work Orders - Closed (Dataset)

x9wy-ing4Transportation15 columns
The Street Pothole Work Orders data consists of closed street potholes inspected and repaired by the New York City Department of Transportation. The dataset includes the pothole’s location, the date it was reported, and date the report was completed.
View on NYC Open Data↗

Quality

A95.9 / 100

From a 500-row sample across 15 columns.

completeness94/ 25% weight
consistency90/ 20% weight
accuracy97/ 20% weight
timeliness99/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Street Resurfacing Schedule0.36
  • Street Closures due to Construction Activities by Block0.36
    joins onthe_geomoft
  • Street Sign Work Orders0.35
  • Taxi and For Hire Vehicle (FHV) Relief Stands0.34
    joins onthe_geom
  • New York City Truck Routes0.34
    joins onthe_geomshape_leng
  • Routes0.33

Geography

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

Sample rows

the_geomdefnuminitbyoftonfacenameonprimnamefrmprimnamtoprimnameborosourcerptdaterptclosed
NaN, NaNDB2004041154YRD373480377030377030ROCKAWAY PYROCKAWAY PARKWAYBELT PARKWAYBELT PARKWAYBYRD2004/02/08 00:00:002023/01/27 00:00:00
NaN, NaNDB2004287021

Columns

15 queryable · 14 profiled

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

FieldTypeDescriptionNullValues
the_geomunknown———
defnumtext—0%DM2011034016DB2015179020DB2013141014
initbycategorical—0%YRDCSCSPHof 16
housenumtext—39%1100200
ofttext—0%

Query this from your own app

GET /api/datasets/x9wy-ing4
GET /api/datasets/x9wy-ing4/quality
GET /api/datasets/x9wy-ing4/related
GET /api/columns?dataset=x9wy-ing4
Bus Lanes - Local Streets
0.33
joins onthe_geomboroshape_leng
  • Protected Streets Block (Dataset)0.32
    joins onthe_geom
    • CSC
    318630377030377030
    BEDFORD AV
    BEDFORD AVENUE
    BELT PARKWAY
    BELT PARKWAY
    B
    CTZ
    2004/10/13 00:00:00
    2013/02/14 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.98570910180842,40.641185633551906],[-73.98629156768092,40.64062495072503]]]}DB2006085009CSC30638030848030853013 AV13 AVENUE38 STREET39 STREETBCTZ2006/03/26 00:00:002014/10/11 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.93487210852416,40.67959308775311],[-73.93435066426116,40.67956340762812],[-73.93289696780256,40.679484809586754]]]}DB2007166005CSC342730355530375430FULTON STFULTON STREETLEWIS AVENUESCHENECTADY AVENUEBCTZ2007/06/15 00:00:002011/01/14 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.97793940872546,40.68980619340545],[-73.97749778005212,40.68753511214334]]]}DB2009352004CSC380030331530342730ST FELIX STST FELIX STREETDEKALB AVENUEFULTON STREETBCTZ2009/12/18 00:00:002010/01/06 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.97501506812618,40.64076194953136],[-73.9739403128278,40.64088130885556],[-73.97379738896885,40.64089555049617],[-73.97364078299529,40.6409148380308]]]}DB2009362038CSC313830335030367730AV CAVENUE CEAST 5 STREETOCEAN PARKWAYBCTZ2009/12/28 00:00:002010/01/04 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.92232548215823,40.58629416179631],[-73.92356024978042,40.58740061692899]]]}DB2009362066CSC342890356960375990GAIN CTGAIN COURTLOIS AVENUESEBA AVENUEBCTZ2009/12/28 00:00:002010/01/05 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.96802285162667,40.62445088644654],[-73.96709695265238,40.62455305934499]]]}DB2009363041CSC314080335130335180AV JAVENUE JEAST 8 STREETEAST 9 STREETBCTZ2009/12/29 00:00:002010/01/04 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.9080474319009,40.69541616050735],[-73.90700504867863,40.69647991850026],[-73.90652350692359,40.696976143297114]]]}DB2009363045CSC347030352130394730HANCOCK STHANCOCK STREETIRVING AVENUEWYCKOFF AVENUEBCTZ2009/12/29 00:00:002010/01/10 00:00:00
    {"type":"MultiLineString","coordinates":[[[-73.95291388704382,40.70670031054531],[-73.95251503813391,40.7065585863031],[-73.95229955465915,40.70649029337218],[-73.95191055714336,40.70636007874866]]]}DB2009364034CSC323230349430364630BDWYBROADWAYHEWES STREETNEW MONTROSE AVENUEBCTZ2009/12/30 00:00:002010/01/10 00:00:00

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

    308530305010305130
    375760360440375730
    372250337280337510
    onfacenametext—0%BDWY3 AVJAMAICA AV
    onprimnametext—0%BROADWAY3 AVENUEJAMAICA AVENUE
    frmprimnamtext—0%BEND5 AVENUE1 AVENUE
    toprimnametext—0%BENDBROADWAYDEAD END
    specloctext—66%POTHOLEIN FRONT OF ADDRESSMULTIPLE POTHOLES
    borocategorical—0%QBMof 5
    sourcetext—0%CTZYRDOSE
    rptdatetext—0%2015/03/11 00:00:002010/03/02 00:00:002011/02/08 00:00:00
    rptclosedtext—0%2017/04/08 00:00:002015/05/30 00:00:002017/04/29 00:00:00
    shape_lengfloat—0%793.585339025259.773822816540.274572785