From a 500-row sample across 18 columns.
ampsdistrictprop_idampsdistrictprop_idinspection_idcomments| prop_id | ampsdistrict | inspection_id | season | round | date | begininspection | endinspection | inspection_year | inspector | overall_condition | cleanliness |
|---|---|---|---|---|---|---|---|---|---|---|---|
| X028 | 04 | 135710 | Summer | 3 | 2020-07-15T00:00:00.000 | 15:00:00 | 15:50:00 | 2020 | 50 | U | U |
| M010-241 | 13 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
prop_id | text | Unique identification number for a property or portion of a property. In some cases – a standalone, smaller park for example – this number will be equivalent to the PropNum (see "All Sites" table). In other cases – a zone, playground or other site within a larger park – an additional designation of letters and/or numbers will be added. | 0% | M029-ZN03R109R065-ZN08 |
ampsdistrict | text | Maintenance district at time of inspection | 0% | 010302 |
inspection_id | text | Unique inspection identification number | 0% | 14814611891236146 |
season | categorical | Inspection season of inspection | 0% |
GET /api/datasets/yg3y-7juh GET /api/datasets/yg3y-7juh/quality GET /api/datasets/yg3y-7juh/related GET /api/columns?dataset=yg3y-7juh
prop_idinspection_idinspection_id| 135716 |
| Summer |
| 4 |
| 2020-07-16T00:00:00.000 |
| 11:30:00 |
| 11:59:00 |
| 2020 |
| 50 |
| A |
| A |
| Q104-02 | 01 | 135720 | Summer | 4 | 2020-07-16T00:00:00.000 | 10:22:00 | 10:37:00 | 2020 | 32 | U | U |
| X196 | 12 | 135735 | Summer | 4 | 2020-07-17T00:00:00.000 | 08:34:00 | 09:16:00 | 2020 | 32 | A | A |
| B073-ZN05 | 19 | 135743 | Summer | 4 | 2020-07-17T00:00:00.000 | 13:00:00 | 13:45:00 | 2020 | 50 | A | A |
| R038 | 02B | 135747 | Summer | 4 | 2020-07-17T00:00:00.000 | 11:48:00 | 12:13:00 | 2020 | 57 | A | A |
| M010-ZN16 | 13 | 135795 | Summer | 4 | 2020-07-21T00:00:00.000 | 10:50:00 | 11:46:00 | 2020 | 59 | A | A |
| Q300A-ZN01 | 11 | 135798 | Summer | 4 | 2020-07-21T00:00:00.000 | 10:14:00 | 11:04:00 | 2020 | 38 | A | A |
| M098-02 | 02 | 135816 | Summer | 4 | 2020-07-22T00:00:00.000 | 10:14:00 | 10:21:00 | 2020 | 32 | A | A |
| R022-05 | 01 | 135824 | Summer | 4 | 2020-07-22T00:00:00.000 | 09:40:00 | 09:50:00 | 2020 | 43 | A | A |
Showing 12 of 16 columns. All of them are listed below.
SummerSpringWinterof 6round | categorical | Inspection round of inspection | 0% | 213of 7 |
date | datetime | Date of inspection | 0% | 2012-06-29T00:00:00.0002010-12-29T00:00:00.0002004-02-02T00:00:00.000 |
begininspection | text | Time inspection began | 0% | 10:00:0010:30:0011:00:00 |
endinspection | text | Time inspection concluded | 0% | 11:00:0011:30:0010:30:00 |
inspection_year | integer | Inspection year of inspection | 0% | 202320252018 |
inspector | integer | The random ID assigned to an inspector, primary. | 0% | 313843 |
inspector2 | integer | The random ID assigned to an inspector, secondary. | 98% | 4.038.032.0 |
overall_condition | categorical | Overall Conditon rating | 0% | AUNof 3 |
cleanliness | categorical | Cleanliness rating | 0% | AUNof 4 |
safety_condition | categorical | Safety condition rating | 99% | AUof 2 |
structural_condition | categorical | Structural condition rating | 99% | AUof 2 |
visitorcount | text | Visitor estimate at site during time of inspection | 55% | 021 |
closed | categorical | Indicates if site was fully or partially closed at time of inspection | 94% | Partial Constr./Rest of …Under Construction.Closed / No Construct.of 12 |
comments | text | Additional inspection comments | 79% | N ratings due to snow co…Features rated "N" due t…Features with Ns were sn… |
inspectiontype | categorical | Type of inspection | 0% | PIPSWEEPWEPIPof 16 |
inspaddeddate | datetime | Date inspection was entered into database | 27% | 2015-08-18T20:15:00.0002008-01-10T19:37:00.0002020-03-24T12:58:00.000 |