Querying an Avian Inventory Database and Visualizing the Results

GEORGE WASHINGTON BIRTHPLACE NATIONAL MONUMENT

NATIONAL PARK SERVICE

NR 595D Final ProjectSpring 2009

Jeff Smith

Project Description NPS would like to enter a common name for a

bird species and have the locations for that species displayed on a map

Locations

High-Level Pseudocode

QUERY Database

GET User Input

CALL Python, geoprocessing Make feature layer, select layer by attributes, copy

features

ADD Layers to Map

Query Database NPS MS Access database relationships (VBA – list Common

Names)

Species Table Area Table

Transect Table

Point Table

Area Shapefile

Table

Transect ShapefileTable

Point Shapefile Table

Get User Input GET database path, input shapefile directory,

output directory and Common Name from user

UI Button Control

Browse Database Path

Browse Input shapefiledirectory

Browse Output directory

Select Species

Call Python (on OK click) Message Box Displays Results

Add Shapefiles Allows user to select shapefiles to add to display,

go back and select another species, or cancel the program

Opens File Dialog Box

Results Layers added to ArcMap display

Project Demonstration In ArcMap

Challenges Populating combo box with common name values

from Access database (Thanks to Brent for help) Getting from table to table to retrieve required

information Deleting existing files and layers in VBA so

program would run correctly

STILL TO DO Customize symbology of added layers