Texas Parks

Explore

This base is a comprehensive list of both national and state parks in Texas, with a few important landmarks sprinkled in too.

ā€‹

Parks table

  • Overview: Basic information about each park
  • Editorialized: View including visit status, distance from home*

ā€‹

Visits table

  • Your visits by date**, including how far and which trails you did
  • Calendar view of visits

ā€‹

Apps

  • Map: Including markers sized by number of visits (from Visits table) and colored by status
  • Chart of visits organized by driving duration: Answers some interesting questions, such as: What is available to you as a day trip? What requires a weekend? How many of the parks within a 2hr radius of Austin have you visited?
  • Additional charts to visualize your own visits by month, day of the week, companions, etc.

ā€‹

ā€‹

Notes

* I've removed my personal information from the Visits table, but have left a few examples in the template for you to add your own and see your stats.

** All distances/durations are from south Austin. Replace with your own distance calculations by using your address for the second Lat/Long in these functions: https://www.labnol.org/google-maps-sheets-200817

Explore
Updated April 14, 2021 at 6:46 PM
Copied 19 times

Sharon Brener

I'm the Product Design director for data.world, where we use Airtable for organizing our user research. I nerd out on making databases for my recipes and state park adventures. www.sharonbrener.com
Explore the base
Overview
Editorialized
Grid view
Calendar