From a 500-row sample across 17 columns.
| inspectionid | noviolationfound | citydoit | ownerwilldoit | capconflictflag | cancel | inspectiondate | is_311_inspection | pickupsidewalk | curb311 | pickupcurb | other |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 302653 | No | No | No | No | No | 2019-09-25T00:00:00.000 | Yes | No | No | No | No |
| 218128 | No |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
inspectionid | text | Unique five digit numerical ID used to track inspection records. | 0% | 22817312377118912 |
noviolationfound | categorical | The inspection did not identify any sidewalk defects. | 0% | NoYesof 2 |
citydoit | categorical | Property owner requests that the city performs the sidewalk repairs. | 0% | NoYesof 2 |
ownerwilldoit | categorical | Property owner will perform the sidewalk repairs. | 0% | NoYesof 2 |
GET /api/datasets/dntt-gqwq GET /api/datasets/dntt-gqwq/quality GET /api/datasets/dntt-gqwq/related GET /api/columns?dataset=dntt-gqwq
inspectiondateinspectionid| No |
| No |
| No |
| No |
| 2016-03-01T00:00:00.000 |
| No |
| Yes |
| No |
| No |
| No |
| 75854 | No | No | No | No | No | 2007-08-16T00:00:00.000 | No | No | No | No | No |
| 8714 | Yes | No | No | No | No | 1999-07-28T00:00:00.000 | No | No | No | No | No |
| 104357 | No | No | No | No | No | 2010-05-27T00:00:00.000 | No | No | No | No | No |
| 145093 | No | No | No | No | No | 2012-01-05T00:00:00.000 | No | No | No | Yes | No |
| 121612 | No | No | No | No | No | 2011-03-30T00:00:00.000 | No | No | No | No | No |
| 92612 | No | No | No | No | No | 2009-06-12T00:00:00.000 | Yes | No | No | No | No |
| 36769 | No | No | No | Yes | No | — | No | No | No | No | No |
| 117914 | No | No | No | No | No | 2010-09-17T00:00:00.000 | No | No | No | No | No |
Showing 12 of 16 columns. All of them are listed below.
capconflictflag |
| categorical |
| Identifies if there is a capital project with planned work at the taxlot |
| 0% |
NoYesof 2 |
capitalconflicts | text | Identified there is a capital reconstruction project with sidewalk repairs at the location. | 92% | QN KissenaGK0H15-03BK-GK0H15-04 |
cancel | categorical | An outstanding violation cancelled - no sidewalk defects identified. | 0% | NoYesof 2 |
inspectiondate | datetime | Inspection Date | 11% | 2010-06-10T00:00:00.0002010-05-20T00:00:00.0002010-08-03T00:00:00.000 |
is_311_inspection | categorical | To determine if the sidewalk inspection occurred at a taxlot where a 311 complaint for defective sidewalk was received. | 0% | NoYesof 2 |
materialid | categorical | The type of material used for sidewalk. | 99% | 516of 8 |
pickupsidewalk | categorical | To determine if the sidewalk inspection occurred at a taxlot where a 311 complaint for defective sidewalk was received on the block. | 0% | NoYesof 2 |
curb311 | categorical | To determine if the sidewalk inspection occurred at a taxlot where a 311 complaint for defective curb was received. | 0% | NoYesof 2 |
pickupcurb | categorical | To determine if the sidewalk inspection occurred at a taxlot where a 311 complaint for defective curb was received on the block. | 0% | NoYesof 2 |
other | categorical | To determine if the sidewalk inspection occurred due to a reason other than the receipt of a 311 complaint or correspondence. | 0% | NoYesof 2 |
correspondence | categorical | To determine if the sidewalk inspection occurred at a taxlot where correspondence was received. | 0% | NoYesof 2 |
damageid | categorical | A numerical code identifying the root of the sidewalk damage. | 0% | 563of 6 |
damagetypecode | categorical | Identifies if all or any of the sidewalk defects are caused by a City tree | 0% | NSNLNTof 6 |