From a 500-row sample across 8 columns.
| inspection_id | results_id | feature_category | feature | results | findings | action |
|---|---|---|---|---|---|---|
| 198265 | 2400778.0 | Showers | Showers | N/A | Not In Season | No Action |
| 198265 | 2400829.0 | Comfort Station | CS Litter-Men | Acceptable | No Finding | No Action |
| 198265 | 2400787.0 | Signs | Signs |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
inspection_id | integer | Foreign key for the Inspection record | 0% | 66016454896659609 |
results_id | integer | Unique identifier for the feature inspection record | 0% | 2686049.02686062.02686050.0 |
feature_category | categorical | Category the inspected feature falls within | 0% | CleanlinessLandscape FeaturesComfort Stationof 8 |
feature | text | Individual feature | 0% | LitterGraffiti |
GET /api/datasets/wag2-kf63 GET /api/datasets/wag2-kf63/quality GET /api/datasets/wag2-kf63/related GET /api/columns?dataset=wag2-kf63
| Acceptable |
| No Finding |
| No Action |
| 198265 | 2400840.0 | Cleanliness | Weeds | Acceptable | No Finding | No Action |
| 198265 | 2400834.0 | Comfort Station | CS Structural-Women | Acceptable | No Finding | No Action |
| 198265 | 2400782.0 | Flags | Flag U.S. Flag | N/A | N/A | No Action |
| 198265 | 2400828.0 | Comfort Station | CS Litter-Women | Acceptable | No Finding | No Action |
| 198265 | 2400772.0 | Landscape Features | Sidewalks | Acceptable | No Finding | No Action |
| 198265 | 2400752.0 | Cleanliness | Ice | Acceptable | No Finding | No Action |
| 198265 | 2400833.0 | Comfort Station | CS Graffiti-Men | Acceptable | No Finding | No Action |
Weedsresults | categorical | Rating for the feature | 0% | AcceptableUnacceptableNof 9 |
findings | text | Conditions or hazards, or reason feature was not rated. If there is a finding there will be a Feature code | 1% | No FindingNot In SeasonN/A |
action | categorical | Action taken by supervisor to mitigate conditions and hazards | 0% | No ActionDistrict ActionExisting Work Orderof 6 |
resulting_work_order | integer | The AMPS work order number produced as a result of this inspection | 99% | 198543220939092079553 |