Methodology

Methodology:

1. Clean & Convert Raw Parks Acreage Data

• Recieve raw data via Councilman Casar's Director of Policy. (raw .xls file)
• Refine data by adding Lat & Long from "PARK ADDRESS SERVICE" column using Geo for Google Spreadsheets. Create "Park Type" column and merge data from 5 given sheets into one table.
• Where Geo failed to find Lat/Long from Address, use Get Lat Lon web service. 14 (out of 148) Parks Locations required this manually reference after Geo failed.
• Where still uncertain with Get Lat Lon, use Google Maps by searching "PARK NAME" field.
• Export to [GeoJSON file] (https://github.com/mateoclarke/Austin_Parks_Acreage/blob/master/data/austinParksAcreageData.geojson) via Geo tool.

2. Find & Convert Park GIS Data to GeoJSON

• Download "City of Austin Parks" GIS data from City of Austin Data Portal.(https://data.austintexas.gov/dataset/City-Of-Austin-Parks/99qw-4ixs).
• Convert Shapefile to GeoJSON using GDAL. I referenced this blog post from Ben Balter for help.

3. Add District Shapefiles from a past project

"Need Score" Methodology:

1. Percent Population Age Under 19
   • 0 points < 10%
   • 7 points > 40%
2. Health Insurance Coverage
   • 0 points > 40%
   • 7 points < 10%
3. Ratio of Housing Buildings with 2 or less units (Density)
   • 0 points > 80%
   • 7 points < 20%

Current Max Score: 21