Explore Colorado

Explore

Whether you're visiting Colorado or a long-time local, here are some of pre-vetted Colorado destinations curated by a recent Denver transplant.

Identifying the Need

Moving from Florida to Colorado, I was eager to learn the lay of the Colorado land! Searching Google gave me tons of results, but results were often riddled with all-to-common tourist destinations. I wanted something that was a bit more local.

So I started reaching out to friends, colleagues and other locals to see what they suggested. Soon enough I had recommendations everywhere--on my iPhone note app, in forwarded emails, scribbled on post-its. I needed a place for it all! *enter Airtable*

Structuring the Base & Loading Content

Choosing Airtable wasn't difficult--it had the dynamic capabilities that would bring my static recommendations to life.

In the linked base, I've organized the content into the following tables (content objects):

  1. Places: the primary table that houses all the bulk of the recommendations / places to visit.
  2. **Neighborhoods: **a still-growing list of different areas / neighborhoods to check out.
  3. **Cities: **Cities that you may want to visit, along with how many referenced "places to visit" there are in that city.
  4. **Trails: **a separate table for recommended trails…since it deserved it's own table.
  5. **Hiking Areas: **a list of hiking areas, so you can see how many reference trails each hiking area has and it's closest cities.

While some of the tables still need some content love, I structured the base this way for a couple of reasons:

  • Easy Content Manipulation - Sort, Group, View the content how you'd like to.
  • Quantifying Data - Ability to see how many places of interest a city or neighborhood has.
  • **Scalability **- This can hold data for just one city up to a whole state. Add another table and a couple more table references…and you could have the entire USA!

At the end of the day, I had a couple different use cases in mind.

My Potential Use Cases

The following are some potential use cases that came into mind when creating this Airtable.

Walking and Explore a Denver Neighborhood by…

  1. grouping the 'Places' list by 'Neighborhood'
  2. viewing what places I have or haven't 'done' yet
  3. navigating to the 'yelp link' to find out more detailed information

**Looking up a Place to Hang or Eat after a Hike **by…

  1. locating the 'Hiking Area' I'm currently at and looking at 'Nearest City'
  2. clicking into the 'City' and looking at how many 'Places to Visit' it has
  3. while en route to the city, a friend can look at some of the recommended 'Places' in the 'City'

**Aid in planning a Friend's Trip Itinerary **by…

  1. grouping 'Neighborhoods' by 'City' and planning which city to hit up first, then which neighborhoods
  2. planning 'Places' to visit depending on the friend's interests compared to the place's 'Highlights' and 'my Rating'

In Conclusion

While the base has a good amount of content, I'm still adding to it everyday (as long as I'm a Colorado resident)! I'm hoping someday to have a more robust list of trails / hiking areas, and maybe even a way to plan an itinerary for visiting friends…directly within the base.

With Airtable, the options are endless!

So use the base as a template for your own city, or come visit Colorado and try some of my favorite places. If you need help, or have ideas on how to modify this template… shout out to me via twitter @radzz108, I'd love to hear from you!

Explore
Updated April 8, 2017 at 6:02 PM
Copied 467 times

Radha Nath

UX Designer + Researcher. MHCI @ CMU. Fueled by coffee & boardgames. I enjoy finding new, creative ways to use Airtable.
Explore the base
Main View
Gallery
Main View
Main View
Main View
Gallery 2
Main View