NAU Capstone Design Sequence
Corporate Capstone Project Description

Internet Map Server Application Development

Grand Canyon National Park
Arizona

National Park Service
U.S. Department of the Interior

 

Sponsor Information:

 

Steve Mietz

GIS Coordinator, Science Center
Grand Canyon National Park

National Park Service
823 N. San Francisco St., Suite A
Flagstaff, AZ 86001
(928) 226-0631 - Phone
(928) 774-1757 – Fax
steven_mietz@nps.gov 


Project Overview:

Description of Project

Currently, Geographic Information System (GIS) and tabular data related to the Grand Canyon region are scattered at different locations and in various states of completion.  An integrated ecological spatial database is required for the archiving, organizing, distribution and analysis of spatial and tabular data collected within the Grand Canyon Region.   The consolidation of disparate datasets from numerous sources provides a unique challenge.  To address this challenge, the Grand Canyon National Park has organized into a single, comprehensive database using ESRI’s Spatial Database Engine (SDE) and Microsoft SQL Server Database Management System.  The flexible database structure offered by SDE and SQL Server allows the use of a variety of  web-based query and analysis tools including Internet Map Server.  The Internet Map Server provides access to the GIS layers and tabular datasets using standard Internet browsing tools. The Capstone student(s) would focus upon application development using Internet Map Server software tools.

This project will address the needs of the overflight program, the Colorado River management team, and the backcountry management team.  The overflight program requires 3D visualization of airspace and air routes over the Grand Canyon to aid pilot navigation and provide analysis of noise patterns.  The overflight program also requires the ability to query and display records held within the enterprise database for analysis in specialized soundscape software.  The Colorado River management team requires the development of a visitor impact database and interface.  This database and interface would allow the managers to query and analyze visitor impacts on archeological sites, campgrounds, and endangered species.  The backcountry management team needs the development of a database and interface that integrates vegetation, campsite, and wildlife data into a cohesive set of tables that show visitor impacts on backcountry resources.  These data will be used in the development of management plan alternatives.  The team will be required to work with users from each program area to develop software requirements, write and get approved a requirement analysis, and then develop the database and/or web-based interface to address these information access needs of each program area.

Why do this project? 

The students involved in this project will develop the interface tools needed for accessing and utilizing data from both tabular and spatial enterprise-level geodatabases.  Base cartography, imagery, and other datasets (e.g., geology, soils, vegetation, archeological sites) address basic requirements for park planning, as well as, resource studies and modeling (both natural and cultural), and ArcIMS/SDE services will greatly enhance the availability, visualization, and ease of use of these geospatial data.  This project is a key component of the Grand Canyon National Park’s (GRCA) long-term information management strategy to provide GIS tools and support for park resource management. Currently, valuable datasets regarding the status and condition of Grand Canyon resources are stored at the USGS, Northern Arizona University, Utah State University, Grand Canyon North and South Rim’s village sites, and in Flagstaff, AZ.  The compilation, organization, and distribution of a single set of spatial and tabular data regarding the Grand Canyon region will allow Park Managers to leverage the abundance of scientific data collection (by park personnel and outside researchers) that occurs in the Grand Canyon region to make better informed management decisions.  Students will be exposed to a variety of resource managers and learn to develop customized applications that meet their query, analysis and visualization needs.  A team of students could potentially be composed of a mix of application developers and database developers.  The efforts of student(s) involved in this process will have a direct benefit to protecting the Grand Canyon for the enjoyment of future generations.


 

Knowledge, skills, and expertise required for this project:

Requirements: Ability to develop custom web applications using JAVA. Knowledge of Microsoft IIS,  Apache Tomcat, Microsoft Server 2000/2003 OS, Microsoft SQL Server including SQL Query , ODBC connections and basic database design concepts, XML, Active X and hardware RAID configurations for PC. 

Optional:  Knowledge/experience in Geographic Information Systems, enterprise database design, MS SQL Server Enterprise Manager, Internet Map Server, Spatial Data Engine, Arc Macro Language scripting and/or Python scripting. 


Equipment Requirements:

The Grand Canyon National Park can provide the software and hardware needed to complete all the tasks.  However, the student(s) may wish to have specialized development tools that they will need to provide.  Office space is extremely limited at GRCA and therefore it is preferred that the student provide their own space.  The park is willing to provide a “development” platform of software and hardware at an off-site location, if necessary.  NAU has licenses for most GIS and database softwares and potentially could be a source for a development platform at the University.


Deliverables:

The student(s) will be expected to propose and deliver the following:

  1. Customized web applications that query enterprise databases and report data in a manner that meets identified resource manager needs.

    1. Web-based form linked to overflights database and web-application of 3D visualization of overflight datasets.

    2. Web-based form to query Colorado River database and GIS-enabled web application of results.

    3. Web-based form to query backcountry database that allows minimally-skilled users to build queries in a GUI environment.

  2. Requirements analysis of client’s needs and proposal to meet those needs. 

  3. Thoroughly document code and other appropriate documentation.