Colorado National Parks Camping Planner (Project 2)

Jenni Davis, Susan Farago, David Jimenez, Elizabeth Conway, & Austin Olea (April 2021)

For more information, please refer to Colorado National Parks Project Final Report!

Summary

Our team is continuing our deep dive into reservable camping spots in Colorado. For our ETL project we built a SQL database that identifies Colorado campground locations by latitude and longitude coordinates, provides the number of camping spaces at each location, and the allowable equipment to be used at each site. The database also provides enthusiasts with the opportunity to review historical availability from 2010 - 2020 and reservation lead-time by location. In addition to our database we will be adding weather JS library to complete our dashboard.

Target Audience:

• Our project targets camping enthusiasts who are planning their adventures in Colorado.

Database Information:

• Identify the 4 national park locations within Colorado.
• Quantify the availability of spaces.
• Retrieve the quantity of spaces available and of those, which are designated as RV only camping, tent only camping, or both.
• Retrieve weather-related data by search or by map.

Technical Specifications:

• Interactive HTML-based dashboard powered by a Python Flask API, HTML/CSS, JavaScript, and a SQL database
• Project Type: A dashboard with build-in user driven interactions (dropdown menus)with multiple charts that update from the same data
• HTML/CSS Template: Creative Tim templates
• JavaScript Libraries: jquery.js, d3.js, plotly.js, leaflet.js, stars.js (VirtualSky.ico.global)
• SQL database: From ETL project
• Number of Records: 528
• Final Visualizations: National Park Locations, Night Sky at Each Park, Camping Historical Activity, Local Weather Data
• Bonus Visualizations: Campfire and Live Weather Conditions