Doc: Park Inspections.md - wimlds/smart_cities GitHub Wiki

The Parks Department of NYC regularly inspects the NYC parks. Several quality parameters are inspected by the park inspectors in person, as acceptable or not-acceptable. The data is released as an xml file, which has been (somewhat painfully) reformatted into a csv file for your convenience. The acceptable, unacceptable, and not rated values are mapped to 1, -1, 0 respectively (and there are additional missing values).

The code that generates the dataset is in this notebook


Table path:

  • `smart_cities_data.park_inspections`
Column Name Explanation
string_field_0 STRING park ID and name, comma separated
date_field_1 DATE inspection date
Benches INTEGER 1 Acceptable, -1 Unacceptable, 0 Not Rated.
Cleanliness INTEGER
Fences INTEGER
Glass INTEGER
Graffiti INTEGER
Landscape INTEGER
Lawns INTEGER
Litter INTEGER
OverallCleanliness INTEGER
OverallCondition INTEGER
PavedSurfaces INTEGER
PlayEquipment INTEGER
SafetySurface INTEGER
Sidewalks INTEGER
Structural INTEGER
Trees INTEGER
Weeds INTEGER