Course: Spatial Database | UW-Madison
Instructor: Qunying Huang
This repository contains the SQL file and the reports of this spatial database design project. We used PostgreSQL with its extension, PostGIS, to create the database and perform traditional and spatial data queries. The data for this project were obtained from the National Park Service (NPS) and the United States Department of Agriculture, Forest Service (USDA-FS). The database we created can be downloaded here or download NP_Database_postgres_Group1.sql in this repository.
If you are looking for a comprehensive report about how we designed the database and more, check out our Final Report.
If you just want a brief description about this project, check out the Abstract.
For the SQL code including the traditional and spatial queries, we have the code and the screenshots in SQL Results.