Dataset: San Francisco Park Scores

About this Dataset

San Francisco Park Scores

Context

Average quarterly park evaluation scores in San Francisco, from Q3 FY2005 to Q4 FY2014.

Content

Data includes merged data with Recreation and Parks Facilities data, including location and descriptions. Location (LatLong) data missing for 775 rows.

Acknowledgements

The data is provided by San Francisco Recreation & Parks Department via the San Francisco Open Data Portal.
Sources:

Park Scores 2005-2014
Recreation and Parks Facilities
Facilities maintained by the Recreation and Parks Department. A facility in this dataset represents a structural or physical amenity within a property's boundaries.

Photo by Casey Horner on Unsplash

Inspiration

What local geospatial or demographic effects are there on a parks rating?
Are park ratings static over time or do they improve?
What facilities have the highest ratings?

Tables

Sf Park Scores

@kaggle.danofer_sf_parks.sf_park_scores

91.8 KB
5494 rows
16 columns


CREATE TABLE sf_park_scores (
  "parkid" BIGINT,
  "psa" VARCHAR,
  "park" VARCHAR,
  "fq" VARCHAR,
  "score" DOUBLE,
  "facility_type" VARCHAR,
  "facility_name" VARCHAR,
  "address" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "floor_count" DOUBLE,
  "square_feet" DOUBLE,
  "perimeter_length" DOUBLE,
  "acres" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);