From a 500-row sample across 10 columns.
priorityfeaturepriorityfeaturefeature| diatype | typekey | dateresolved | datetimeentered | resolutionnotes | priority | feature | extended | iastatus |
|---|---|---|---|---|---|---|---|---|
| IA | 30452 | 2008-01-07T00:00:00.000 | 2008-07-16T08:11:00.000 | there are no vandal proof bench slats to replace splintered slats | 2 | Benches | false | Resolved |
| IA | 30453 | 2008-01-07T00:00:00.000 | 2008-07-16T08:22:00.000 | — | 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
diatype | categorical | Hazard type | 0% | IAGraffiti Hazardof 2 |
typekey | text | Hazard unique identification number | 0% | 1481113614655208 |
dateresolved | datetime | Date work performed to address hazard | 2% | 2023-03-23T00:00:00.0002016-07-22T00:00:00.0002021-12-04T00:00:00.000 |
datetimeentered | datetime | Date and time of most recent Parks action in database to address the hazard | 0% | 2016-09-30T12:27:00.0002016-05-02T10:36:00.000 |
GET /api/datasets/s6dm-mdan GET /api/datasets/s6dm-mdan/quality GET /api/datasets/s6dm-mdan/related GET /api/columns?dataset=s6dm-mdan
| Litter |
| false |
| Resolved |
| IA | 30454 | 2008-01-07T00:00:00.000 | 2008-07-16T08:18:00.000 | district needs vandal proof bench slats | 2 | Benches | false | Resolved |
| IA | 30455 | 2008-01-08T00:00:00.000 | 2008-07-31T09:14:00.000 | — | 2 | Paved Surfaces | false | Resolved |
| IA | 30456 | 2008-01-07T00:00:00.000 | 2008-07-16T08:20:00.000 | — | 2 | Benches | false | Resolved |
| IA | 30457 | 2008-09-01T00:00:00.000 | 2008-09-04T10:37:00.000 | — | 2 | Glass | false | Resolved |
| IA | 30458 | 2008-04-12T00:00:00.000 | 2008-04-13T08:30:00.000 | — | 2 | Litter | false | Resolved |
| IA | 30459 | 2008-09-01T00:00:00.000 | 2008-09-04T10:39:00.000 | — | 2 | Paved Surfaces | false | Resolved |
| IA | 30460 | 2008-04-08T00:00:00.000 | 2008-04-13T08:32:00.000 | — | 2 | Trails | false | Resolved |
| IA | 30461 | 2008-01-04T00:00:00.000 | 2008-05-09T14:41:00.000 | — | 2 | Safety Surface | false | Resolved |
2014-10-14T13:56:00.000resolutionnotes | text | Comments related to hazard resolution | 3% | removednoneLimb removed |
priority | categorical | Priority of hazard | 0% | 21of 2 |
feature | categorical | Property feature associated with hazard | 0% | Paved SurfacesTreesLitterof 17 |
workordernumber | text | Work order number associated with resolution of hazard (where applicable) | 61% | N/ADistrict Actionn/a |
extended | boolean | Hazard placed on the extended resolution list | 0% | FalseTrueof 2 |
iastatus | categorical | Indicates if the resolution has received supervisory sign-off as complete | 0% | ResolvedUnresolvedof 2 |