From a 500-row sample across 8 columns.
commentsinspection_idinspection_idinspection_id| element | recommended | present | damaged | comments | outstanding | inspection_id | element_id |
|---|---|---|---|---|---|---|---|
| Parks flag | 1 | 0 | 0 | missing | 1 | 6450 | 1 |
| 1-800 Sign | 1 | 1 | 0 | — | 0 | 2919 | 2 |
| American flag | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
element | text | Property item counted/evaluated | 0% | Routed SignConsolidated SignAmerican flag |
recommended | integer | Number of expected elements for each element type | 0% | 124 |
present | integer | Number of elements present at time of inspection | 0% | 124 |
damaged | integer | Number of elements damaged at time of inspection | 12% | 012 |
comments | text |
GET /api/datasets/2jvr-j6ne GET /api/datasets/2jvr-j6ne/quality GET /api/datasets/2jvr-j6ne/related GET /api/columns?dataset=2jvr-j6ne
commentsinspection_id| 1 |
| 0 |
| — |
| 0 |
| 5351 |
| 3 |
| Routed Sign | 3 | 3 | 0 | — | 0 | 6955 | 4 |
| K-Swing | 2 | 2 | 0 | — | 0 | 1688 | 5 |
| Routed Sign | 3 | 3 | 1 | graffitied | 1 | 13382 | 6 |
| 1-800 Sign | 1 | 1 | 0 | — | 0 | 12816 | 7 |
| 1-800 Sign | 1 | 1 | 0 | — | 0 | 6619 | 8 |
| Parks flag | 2 | 2 | 0 | — | 0 | 13995 | 9 |
| Historic Sign | 1 | 1 | 0 | — | 0 | 12917 | 10 |
| Additional element details/comments |
| 88% |
neededmissingfrayed |
outstanding | integer | Total of situations that need addressing | 0% | 012 |
inspection_id | text | Inspection identification number | 0% | 225512254730738 |
element_id | text | Unique element identification number | 0% | 22817312377655825 |
nowatercount | categorical | Indicates number of water features without water for a given element type | 100% | 123of 11 |