From a 500-row sample across 4 columns.
inspection_idinspection_idcommentsinspection_id| pepid | inspection_id | observation | comments |
|---|---|---|---|
| 48184 | 199601 | Homeless persons present | Found sleeping at the dugout of ballfield # 6. |
| 48183 | 199603 | Drug use | extremely large number of syringe caps throughout entire zone. |
| 48185 | 199608 | Homeless (or other) encampment | Found near the Willink Maintenance office building with his belongings in a shopping cart. |
| 48196 | 199592 | Unleashed or unauthorized dogs | Unleashed dog was inside handball court at playground. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pepid | text | Quality of experience unique identification number | 0% | 481812426825703 |
inspection_id | integer | Inspection identification number (where quality of experience issue was observed) | 0% | 111878150988123024 |
observation | text | Quality of experience issue type | 3% | Homeless persons presentHomeless (or other) enca…Unleashed or unauthorize… |
comments | text | Additional comments related to quality of experience issue | 4% | on site. |
GET /api/datasets/uisg-ivwv GET /api/datasets/uisg-ivwv/quality GET /api/datasets/uisg-ivwv/related GET /api/columns?dataset=uisg-ivwv
commentsinspection_id| 48186 | 199595 | Homeless persons present | Homeless persons present sleeping on rocks near entrance |
| 48176 | 199535 | Alcohol use | Beer cans and beer bottles present in many crosswalks. |
| 48179 | 199553 | Other patron complaints or suggestions | Patron states patrons selling alcohol, drinking inside of park, loud music all day and night. States PEP used to patrol the area, but hasn't in a while. States that its worse from 2-3 pm on. |
| 48178 | 199553 | Alcohol use | Patrons drinking inside park. |
| 48177 | 199553 | Public urination/defecation | Patron urinating inside park close to dugout. |
| 48180 | 199556 | Unleashed or unauthorized dogs | in skatepark & BBCT |
Patrons feeding pigeonsPatron smoking cigarette…