Web Mapping Applications


Many of these components came together for the final project of the course in the capstone project. The following scenerio was given to us:

Due to the black-out of the northeastern United States on August 14, 2003 and Homeland Security issues, the Federal government is investigating possible locations for new high power transmission lines to increase the stability of the United States power grid. New River Gorge National River is being investigated as one possible location. As part of the investigation, the effects of a new power transmission line corridor within the park boundary must be assessed. The resulting environmental impact statement must address both the natural and cultural resources managed by the park. In order to facilitate the analysis requirements, you are tasked with developing a web mapping application that:

  1. Query for specific vertebrate species locations.
  2. Buffer existing power transmission lines.
  3. Allows managers to propose the location of high power transmission line.
  4. Create a corridor around the proposed transmission line.
  5. Determine if a vertebrate monitoring sites is within the proposed corridor.
  6. Determine if any culturally sensitive buildings are within the corridor.
  7. 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.

DIA Diagram in UML
DIA Diagram in UML

Populating Tables and Creating Views in SQL

Once the database was created the tables need to be populated using the following code:

–The following will read files from an unshared folder on virginislands.cnr.ncsu.edu
COPY tblEvents FROM ‘C:/GIS/jwall/finalProject/data/tblEvents.txt’Delimiters ‘,’ CSV;
COPY lu_species FROM ‘C:/GIS/jwall/finalProject/data/lu_species.txt’Delimiters ‘,’ CSV;
COPY tblLocations FROM ‘C:/GIS/jwall/finalProject/data/tblLocations.txt’Delimiters ‘,’ CSV;
COPY tbl_data FROM ‘C:/GIS/jwall/finalProject/data/tbl_data.txt’Delimiters ‘,’ CSV;

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).