Many of these components came together for the final project of the course in the capstone project. The following scenerio was given to us:
- Query for specific vertebrate species locations.
- Buffer existing power transmission lines.
- Allows managers to propose the location of high power transmission line.
- Create a corridor around the proposed transmission line.
- Determine if a vertebrate monitoring sites is within the proposed corridor.
- Determine if any culturally sensitive buildings are within the corridor.
- Print maps and reports of the analysis.
The following is the creation of my capstone project to fulfill these requirements.
DIA Diagram in UML and Conversion to DDL
Data initially had to be accessed through Microsoft Access where the data was cleaned of errors then exported to text documents. Once the schema was understood it was replicated with DIA as a diagram in UML. From there it was converted into DDL which is viewable here.
Populating Tables and Creating Views in SQL
Once the database was created the tables need to be populated using the following code:
In order to adequately fulfill the requirements of the project, two views had to be created. One view concerned the observation locations while the other was of the vertebrates. The code for these views can be found here.
Creating and Populating an ArcSDE Geodatabase
After the database was populated the ArcSDE Geodatabase needed to be created and populated. The spatial data files were imported from those provided while the tabulated data was brought in from the database. The resulting schema looked like this:
Creating a Web Mapping Application with Tasks
Several tasks were created for this project which ranged from queries to interactive geoprocessing actives. Below are the screen shots depicting these tasks.
This was a great capstone project which really helped to tie all the core components of the course together. I especially liked learning how to create a proposed power line since I could see this kind of functionality being used in cultural resource management (similar to how it was in the project for cultural buildings).