Park Accessibility Analysis with ArcGIS Online
The following tutorial describes how to perform simple urban park accessibility analysis using ArcGIS Online with publicly-accessible park location data.
Literature Review
Parks and Public Health
Fewer than half of all Americans meet the national recommendations for moderate to vigorous physical activity - at least 60 minutes/day for youth and 150 minutes/week for adults - and sedentary lifestyles are associated with serious chronic diseases like diabetes, heart disease, and cancer (USDHHS 2008; 2010). Accordingly, physicians have been encouraged to routinely counsel patients about physical activity and to offer "park prescriptions," identifying nearby parks and recommending regular visits (NRPA 2014; Puett et al 2014).
This makes neighborhood parks with large open spaces fundamental infrastructure to support public health (Cohen et al. 2016). Across the United States, over 9,000 local government agencies and organizations manage more than 108,000 public park facilities and 65,000 indoor recreational facilities (Godbey and Mowen 2010).
However, many urban parks were created in a time when work involved strenuous physical activity and fewer labor-saving devices. Accordingly, parks were designed for leisure and recreation rather than physical fitness (Olmstead 1870).
A park is a piece of ground in or near a city or town kept for ornament and recreation (Merriam-Webster 2019). Mertes and Hall (1996), group parks into five categories:
- Very small parks (under 2 acres, also called mini-parks, pocket parks, or parklets)
- Neighborhood parks
- Community and large urban parks
- Sports complexes
- Natural resource areas
Neighborhood parks represent an especially important category of park from the perspective of public health. Neighborhood parks are usually between two and twenty acres and are intended to serve the routine needs for local residents living within a one-mile radius. Neighborhood parks often contain more facilities than mini-parks: picnic tables, children's playgrounds, basketball courts, ball fields for organized sports, restrooms, green spaces, shade trees, etc. These facilities allow these parks to be useful to a wide variety of people at all stages of life.
Beyond physical health, green infrastructure like parks can also be advantageous for mental health (Sturm and Cohen 2014), heat and emissions mitigation (GIT 2016), reduced greenhouse gas emissions (Groth et al. 2008), and economic development (TPL 2018).
ParkServe and ParkScore
The Trust for Public Land (TPL) is an advocacy organization with a mission to "create parks and protect land for people, ensuring healthy, livable communities for generations to come" (TPL 2019a).
In support of their advocacy, the TPL maintains two products. ParkServe is a a comprehensive database of local parks in the nearly 14,000 cities, towns and communities. ParkScore ® is a more in-depth index that rates the 100 largest cities in the US in how they are meeting the need for parks. ParkScores are an ordinal ranking from zero (worst) to 100 (best) and are based on four groups of characteristics: acerage, investment, amenities, and access (TPL 2019b).
ParkScore ®is similar to WalkScore, which is an index on a scale of zero (bad) to 100 (good) that rates neighborhoods on the extent to which residents can perform their daily activities by walking rather than using automobiles (WalkScore.com 2019).
Methods
Open Data
Open data is data that can be freely used, re-used and redistributed by anyone - subject only, at most, to the requirement to attribute and sharealike (Open Knowledge Foundation 2019).
Open data is distinguished from proprietary data, which is generated by private companies to allow them to control and safeguard its competitiveness over other companies. This proprietary data is protected by copyright laws, patent laws and secrecy laws (The Law Dictionary 2019). Geospatial data collected by ESRI is often proprietary data. Data from Google Maps is proprietary, although they make it readily available to the you in exchange for showing you advertising and tracking your web activity.
Open data is also distinguished from confidential data, which needs to be kept private or secret for legal and/or business reasons. Confidential data often refers to information about private individuals (such as health or financial records) that organizations are legally or professionaly obligated not to share (Law Insider 2019). Data on individuals collected as a part of medical research is usually confidential data.
Many government entities routinely make non-confidential data available to the public as open data through their websites. Open data portals are web-based interfaces designed to make it easier to find re-usable information (European Commission 2018).
This movement toward open government data has numerous benefits to society as a whole (Open Knowledge Foundation 2019):
- Creates transparency and advances democratic control of government operations
- Improves public participation and self-empowerment
- Promotes improved or new commercial products and services
- Expedites technological and policy innovation
- Improves efficiency and effectiveness of government services
- Permits assessment of the impact of policies
- Facilitates the development of new knowledge from combined data sources and patterns in large data volumes
All data requires effort to capture and, therefore, costs money. Open data is paid for by the citizens of the city, state, or nation that captures that data, and constraints on public funding limit the amount of data that can be made available.
In contrast, proprietary data is paid for by companies that make money off of that data. Therefore, proprietary data can cover a wider variety of items in more depth than open data if there are businesses or customers willing to pay for the capture, processing, and maintenance of that data. For example, marketing data is very labor-intensive to capture, but businesses are willing to pay for that data because the benefits of that data for guiding business operations outweighs the cost of buying that data from a marketing research company.
Data Formats
Although most large city and county governments make some open data available, the amount, variety, and quality of this data can vary widely.
Of equal importance, there are no universal standards for how this geospatial data is made available, meaning an GIS analyst that uses open data needs to be prepared to process data that is made available through a variety of web apps and in a variety of formats. Some of the common formats include:
- Feature services through an application programmer interface (API) allow GIS software to access geospatial data directly from a server rather than requiring users to download data files (like those listed below) and then import them into GIS software. This is especially useful for data that changes frequently, permitting the data you are using to change without having to repeatedly download and import revised data
- Shapefile format was developed by ESRI in the late 1990s, and this age is reflected in its numerous limitations (such as column name length limit of 10 characters). However, this format is supported by a wide variety of GIS software, so it is still commonly use for sharing geospatial data on the web, usually in ZIP archives
- GeoJSON is a newer geospatial data format that is growing in popularity and can be imported into most major GIS software. However, ArcGIS Online sometimes freezes with the Checking Status message when importing very large GeoJSON files
- Keyhole Markup Language (KML) is a file format used by Google Earth and Google Maps that can also be used with other GIS software. Online shapefiles and GeoJSON, KML includes formatting information on how data should be displayed. The keyhole part of the name comes from the name of the software company that developed the language before being bought by Google in 2004, and that company was named after the KH series of Corona US intelligence satellites launched in the 1960s and 1970s.
- Comma separated values (CSV) files are simple text files that store table data as lines of text with fields separated by commas. These files can be edited in a spreadsheet program like Excel or Google Sheets. When all else fails, it is the simplest way of storing and sharing latitude/longitude point data, or addresses
Download and Import
Data Portal Download
Many cities make their geospatial data available through data portals. If data has been uploaded to the portal with location information, it can usually be downloaded as a shapefile, GeoJSON file, and/or KML file.
Socrata is a web app used by many government agencies for disseminating open data, including geospatial data. The video below demonstrates how to download a shapefile from a Socrata data portal, in this case, parks in Chicago:
- Locate the data portal
- Find the data set in the data catalog
- Select Export and choose Shapefile
- Save the file to your local hard drive
- In ArcGIS Online, go to Content
- Select Add item -> From my computer
- Select the file on your hard drive
- Give the file a meaningful name and some tags
- When Creating Service completes, open the layer in a New map viewer
- If the layer has an attribute for the type of park, use it to style the layer
- Save the map under a meaningful name and share it to get a link
Feature Services
Government agencies often use ArcGIS servers as part of their enterprise GIS infrastructure and some even use ESRI's ArcGIS Hub software to power their public open data portals. These servers can make feature services available that allow you to connect your GIS software directly to the servers rather than having to download and import geospatial data files.
The video below shows how to add a map layer from a service using Portland's GIS data portal as an example.
- Find the data portal
- Find the data set in the portal
- Select APIs and copy the GeoService URL
- Create a new map in ArcGIS Online
- Add Layer From Web
- Select An ArcGIS Server Web Service
- Paste the server URL into the URL box
- Remove any extra text after the MapServer and number part of the URL
- Click OK and the layer should appear in your map
Static Shapefiles
Some cities still disseminate data as shapefiles that you can select from a list of static files. These files often require some searching to file.
For example, even though the City of Orlando has an open data portal, they still distribute the shapefile of park boundaries as static shapefiles. The video below demonstrates how to find such files if you can't find them in the data portal.
Once you have downloaded a zipped shapefile, follow the instructions above to import it into ArcGIS Online.
Filter
City park data will often contain facilities like mini-parks and unimproved areas that are not particularly useful for recreation, and you will want to filter out those facilities from your data.
Optimally, the data will contain a field indicating the type of park, and you can use the Filter function to select features to ignore. The video example below uses park data from Chicago as an example, and the exact name and values in the fields will vary by city.
- View the table of attributes to see if there is a type field
- Click the Filter icon under the layer of parks
- Add a set of filters on the type field for all the types of parks associated with recreation
- Style the layer by the type field so you can see what you've got
- Save As the map under a meaningful name and Share to get a link
If there is no type field but there is a size field, you can filter out small parks. The video example below uses park data from Portland as an example, filtering in only parks of two acres or greater, which will catch most neighborhood parks.
- Click the Filter icon under the layer of parks
- Select the size field - in this case Acres
- Choose is at least and enter the minimum size - in this case two acres
- Apply Filter
- Save As the map under a meaningful name and Share to get a link
Buffer
To be optimally useful and convenient, a park needs to be within a ten-minute walk of a person's home. Buffers are areas of a specific distance around features. We can use a 1/4 mile buffer as a rough estimate of the area around parks that are within a ten-minute walk.
The example below creates buffers around parks in Portland, OR.
- Click the Perform Analysis icon under the layer of parks
- Select Use Proximity -> Create Buffers
- Enter buffer size - in this case 0.25 for 1/4 of a mile
- Select Options and Dissolve so that overlapping buffers are combined
- Give the buffer layer a meaningful name - Using your name and the name of the city can help uniquely identify your layer in your organization
- Unclick Use current map extent so that parks outside what you can see on the current map get buffered too
- Click Run Analysis
- Style the resulting layer so that it clearly stands out over the map
- Save As the map under a meaningful name and Share to get a link
ArcGIS Online does have a tool (Create Drive-Time Areas) that can calculate walking distance in a way that considers the street network and obstacles to walking (like rivers and freeways), although that tool is very credit-intensive and should only be used with small data sets or when you have access to a large number of credits.
Walking-Dependent Neighborhood
In areas where people have access to automobiles, it is possible for them to drive to a park for recreation, although that added step can be a disincentive. However, areas where a significant percent of the population does not have access to either an automobile or a park in convenient walking distance are candidates for adding parks. Low automobile access often (but not always) correlates with income, making this a social justice issue.
To find area with low automobile access, you can use American Community Survey data for auto ownership. Such information is in Table S2504: PHYSICAL HOUSING CHARACTERISTICS FOR OCCUPIED HOUSING UNITS.
In the example video below, this data has been included in a ZIP Code layer available from the FSC ArcGIS Online organization.
- Add and Search for Layers in My Organization for Minn 2017 American Community Survey Zip Code Tabulation Areas
- Style the layer based on the % No Vehicle variable
- Move the auto ownership layer under the park buffer layer so you can see the areas with low park access and low auto ownership
- Use the Measure Area and Distance tool to find the lat/long for a location in a prospective neighborhood and look around in Google Maps Street View for a possible park location
Bibliography
Cohen, Deborah A., Bing Han, Catherine J. Nagel, Peter Harnik, Thomas L. McKenzie, Kelly R. Evenson, Terry Marsh, Stephanie Williamson, Christine Vaughan, and Sweatha Katta. 2016. "The First National Study of Neighborhood Parks: Implications for Physical Activity." American Journal of Preventative Medicine 51 (4), 419–426. https://www.ajpmonline.org/article/S0749-3797(16)30079-4/fulltext.
European Commission. 2018. "Open Data Portals." Accessed 3 July 2019. https://ec.europa.eu/digital-single-market/en/open-data-portals.
Godbey, Geoffrey and Andrew Mowen. 2010. "The benefits of physical activity provided by park and recreation services: the scientific evidence." Accessed 3 July 2019. http://www.nrpa.org/uploadedFiles/nrpa.org/Publications_and_Research/Research/Papers/Godbey-Mowen-Research-Paper.pdf.
Groth, Philip, Rawlings Miller, Nikhil Nadkarni, Marybeth Riley, and Lilly Shoup. 2008. "Quantifying the greenhouse gas benefits of urban parks." Accessed 3 July 2019. https://www.tpl.org/quantifying-greenhouse-gas-benefits-urban-parks.
The Law Dictionary. 2019. "What is proprietary data?" Accessed 3 July 2019. https://thelawdictionary.org/proprietary-data/
Law Insider. 2019. "Definition of Confidential Information." Accessed 3 July 2019. https://www.lawinsider.com/dictionary/confidential-information.
Merriam-Webster. 2019. "Park." Accessed 3 July 2019. https://www.merriam-webster.com/dictionary/park.
Mertes, James David and James R. Hall. 1996. Park, Recreation, Open Space and Greenway Guidelines. Ashburn, VA: National Recreation and Park Association.
National Recreation and Park Association (NRPA). 2014. "Prescribing parks for better health: Success stories." http://www.nrpa.org/uploadedFiles/nrpa.org/Grants_and_Partners/Health_and_Livability/FINAL%20Prescribing%20Parks%20for%20Better%20Health%20Success%20Stories.pdf.
Olmsted, Frederick Law. 1870. "Public parks and the enlargement of towns." Larice, Michael and Elizabeth Macdonald (editors), "The Urban Design Reader," 2nd edition. London: Routledge.
Open Knowledge Foundation. 2019. "What is Open Data?" Accessed 3 July 2019. http://opendatahandbook.org/guide/en/what-is-open-data/.
Puett, Robin, Jane Teas, Vanesa España-Romero, Enrique Garcia Artero, Duck-chul Lee, Meghan Baruth, Xuemei Sui, Jessica Montresor-López, and Steven N. Blair. 2014. "Physical activity: Does environment make a difference for tension, stress, emotional outlook, and perceptions of health status?" Journal of Physical Activity and Health 11 (8), 1503–1511. https://doi.org/10.1123/jpah.2012-0375.
Sturm, Roland, and Deborah Cohen. 2014. "Proximity to urban parks and mental health." The Journal of Mental Health Policy and Economics 17 (1): 19-24.
Trust for Public Lands (TPL). 2018. "The economic benefits of Cleveland Metroparks." Accessed 3 July 2019. https://www.tpl.org/economic-benefits-cleveland-metroparks.
Trust for Public Lands (TPL). 2019a. "About us." Accessed 3 July 2019. https://www.tpl.org.
Trust for Public Lands (TPL). 2019b. "Parkscore® and Parkserve - About, Methodology, and FAQ." Accessed 3 July 2019. https://www.tpl.org/parkserve/about
United States Department of Health and Human Services (USDHHS). 2008. "Physical Activity Guidelines for Americans." Washington, DC: United States Department of Health and Human Services. https://health.gov/paguidelines/2008/.
United States Department of Health and Human Services (USDHHS). 2010. "The Surgeon General’s Vision for a healthy and fit nation." Accessed December 12, 2015. http://www.surgeongeneral.gov/priorities/healthy-fit-nation/obesityvision2010.pdf.
Urban Climate Lab at the Georgia Institute of Technology (GIT). 2016. "The benefits of green infrastructure for heat mitigation and emissions reductions in cities." Accessed 3 July 2019. https://www.tpl.org/benefits-green-infrastructure-heat-mitigation-and-emissions-reductions-cities.
WalkScore.com. 2019. "Walk Score Methodology." Accessed 3 July 2019. https://www.walkscore.com/methodology.shtml.
Appendix: Local Health Departments and Open Data Portals
1. New York, NY
NYC Department of Health and Mental Hygiene: https://www1.nyc.gov/site/doh/index.page
NYC Open Data (Socrata): https://opendata.cityofnewyork.us/
Parks (Shapefile, GeoJSON, KML): https://data.cityofnewyork.us/Recreation/Open-Space-Parks-/g84h-jbjm
2. Los Angeles, CA
Los Angeles County Department of Public Health: http://www.publichealth.lacounty.gov/
Los Angeles Open Data (Socrata): https://data.lacity.org/
Parks (Shapefile, GeoJSON, KML): https://data.lacity.org/A-Livable-and-Sustainable-City/Department-of-Recreation-and-Parks-GIS-Map-of-Park/nuub-r4zx/data
3. Chicago, IL
Department of Public Health: https://www.chicago.gov/city/en/depts/cdph.html
Chicago Data Portal (Socrata): https://data.cityofchicago.org/
Parks (Shapefile, GeoJSON, KML): https://data.cityofchicago.org/Parks-Recreation/Parks-Chicago-Park-District-Park-Boundaries-curren/ej32-qgdr
4. Dallas, TX
Dallas County Health and Human Services: https://www.dallascounty.org/departments/dchhs/
Dallas Open Data (Socrata): https://www.dallasopendata.com/
City of Dallas Park Polygons (Shapefile): https://gis.dallascityhall.com/Downloads/ShpZip/Parks/Parks.zip
5. Houston, TX
Houston Health Department: https://www.houstontx.gov/health/
City of Housting Open GIS Data (ArcGIS Hub): https://cohgis-mycity.opendata.arcgis.com/
Park Boundaries (Shapefile, KML, Feature Service): https://cohgis-mycity.opendata.arcgis.com/datasets/coh-park-boundary/data
6. Washington, DC
DC Health: https://dchealth.dc.gov/
Open Data DC (ArcGIS Hub): https://opendata.dc.gov/
Parks and Recreation Areas (Shapefile, KML, Feature Service): https://opendata.dc.gov/datasets/parks-and-recreation-areas
7. Philadelphia, PA
City of Philadelphia Department of Public Health: https://www.phila.gov/departments/department-of-public-health/
OpenDataPhilly: https://www.opendataphilly.org/
Parks & Recreation Assets (Shapefile, GeoService, GeoJSON): https://www.opendataphilly.org/dataset/parks-and-recreation-assets
8. Miami, FL
Florida Department of Health in Miami-Dade County: http://miamidade.floridahealth.gov/
Miami-Date Open Data Hub (ArcGIS Hub): https://gis-mdc.opendata.arcgis.com/
County Park Boundary: https://gis-mdc.opendata.arcgis.com/datasets/county-park-boundary
9. Atlanta, GA
Fulton County Board of Health: http://fultoncountyboh.org/boh/
Atlanta Regional Commission Open Data and Mapping Hub (ArcGIS Hub): http://opendata.atlantaregional.com/
Parks (Shapefile, KML, Feature Service): http://opendata.atlantaregional.com/datasets/coaplangis::parks
10. Boston, MA
Boston Public Health Commission: http://bphc.org/
Boston Maps Open Data (ArcGIS Hub): http://bostonopendata-boston.opendata.arcgis.com/
Open Space (Shapefile, KML, Feature Service): http://bostonopendata-boston.opendata.arcgis.com/datasets/open-space
11. San Fransisco, CA
San Francisco Department of Public Health: https://www.sfdph.org/
DataSF (Socrata): https://datasf.org/opendata/
Park Lands (Shapefile, KML, GeoJSON - use the original link to get a zipped shapefile): https://data.sfgov.org/Culture-and-Recreation/Park-Lands-Recreation-and-Parks-Department/42rw-e7xk
12. Phoenix, AZ
Maricopa County Department of Public Health: https://www.maricopa.gov/3849/Public-Health
Maricopa Association of Governments Open GIS: https://geodata-azmag.opendata.arcgis.com/
Park data only available in a web map
13. Riverside, CA
Riverside County Public Health: http://www.rivcoph.org/
City of Riverside Open Data GIS Portal (ArcGIS Hub): https://geodata-cityofriverside.opendata.arcgis.com/
City Parks (KML, Shapefile, Feature Service): https://geodata-cityofriverside.opendata.arcgis.com/datasets/7abb1122b461411595321b87553653fc_0
14. Detroit, MI
Detroit Health Department: https://detroitmi.gov/departments/detroit-health-department
Detroit's Open Data Portal (Socrata): https://data.detroitmi.gov/
Parks 2016 (KML, Shapefile, GeoJSON): https://data.detroitmi.gov/Fun/Parks-2016/yu9n-k8rd
15. Seattle, WA
Public Health — Seattle & King County: https://www.kingcounty.gov/depts/health.aspx
King County GIS Open Data (ArcGIS Hub): https://gis-kingcounty.opendata.arcgis.com/
Parks in King County / park area (Shapefile, KML, Feature Service): https://gis-kingcounty.opendata.arcgis.com/datasets/parks-in-king-county-park-area
16. Minneapolis, MN
City of Minneapolis Health Department http://www.minneapolismn.gov/health/
opendataminneapolis (ArcGIS Hub): http://opendata.minneapolismn.gov/
Parks (Shapefile, KML, Feature Service): http://opendata.minneapolismn.gov/datasets/parks
17. San Diego, CA
Public Health Services - County of San Diego: https://www.sandiegocounty.gov/hhsa/programs/phs/
SanGIS/SANDAG GIS Data Warehouse (Requires free login): http://rdw.sandag.org/Account/Login
18. Tampa, FL
Florida Department of Health in Hillsborough County: http://hillsborough.floridahealth.gov/
City of Tampa GeoHub (ArcGIS Hub): http://city-tampa.opendata.arcgis.com/
Park Polygons (Shapefile, KML, Feature Service): http://city-tampa.opendata.arcgis.com/datasets/park-polygons
19. Denver, CO
Denver Department of Public Health and the Environment: https://www.denvergov.org/content/denvergov/en/environmental-health.html
Denver Open Data: https://www.denvergov.org/opendata
Denver Parks: https://www.denvergov.org/opendata/dataset/city-and-county-of-denver-parks
20. St. Louis, MO
City of St. Louis Department of Health: https://www.stlouis-mo.gov/health/
City of St. Louis Open Data (CommonSpot): https://www.stlouis-mo.gov/data/
Park Data (Shapefile): https://www.stlouis-mo.gov/data/parks.cfm
21. Baltimore, MD
Baltimore City Health Department: https://health.baltimorecity.gov/
Open Baltimore: https://data.baltimorecity.gov/
Parks (CSV addresses only): https://data.baltimorecity.gov/Culture-Arts/Parks/3r8a-uawz
22. Charlotte, NC
Mecklenburg County Health Department: https://www.mecknc.gov/HealthDepartment/
Open Mapping (proprietary portal): http://maps.co.mecklenburg.nc.us/openmapping/data.html
Park Locations (Shapefile): http://maps.co.mecklenburg.nc.us/openmapping/data.html
23. Orlando, FL
Florida Department of Health in Orange: http://orange.floridahealth.gov/
Orlando Open Data (Socrata): https://data.cityoforlando.net/
Parks (Point Shapefile): ftp://ftp.onetgov.net/divisions/Infomap/pub/GIS_Downloads/FTP%20Shapefiles/Parks%20Countywide.zip
24. San Antonio, TX
City of San Antonio Metropolitan Health District: https://www.sanantonio.gov/Health
Open Data SA (Comprehensive Knowledge Archive Network - CKAN): https://data.sanantonio.gov/
Park Boundaries (Shapefile, KML, GeoJSON, API): https://data.sanantonio.gov/dataset/park-boundaries
25. Portland, OR
Multnomah County Health Department: https://multco.us/health
Portland Maps - Open Data (ArcGIS Hub): https://gis-pdx.opendata.arcgis.com/
Parks (Shapefile, KML, GeoJSON, or API): https://gis-pdx.opendata.arcgis.com/datasets/parks