1 / 10

Querying an Avian Inventory Database and Visualizing the Results

NR 595D Final Project Spring 2009 Jeff Smith. Querying an Avian Inventory Database and Visualizing the Results. GEORGE WASHINGTON BIRTHPLACE NATIONAL MONUMENT NATIONAL PARK SERVICE. Project Description.

marshall-maddox
Download Presentation

Querying an Avian Inventory Database and Visualizing the Results

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NR 595D Final Project Spring 2009 Jeff Smith Querying an Avian Inventory Database and Visualizing the Results GEORGE WASHINGTON BIRTHPLACE NATIONAL MONUMENT NATIONAL PARK SERVICE

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

  3. High-Level Pseudocode • QUERY Database • GET User Input • CALL Python, geoprocessing • Make feature layer, select layer by attributes, copy features • ADD Layers to Map

  4. Query Database • NPS MS Access database relationships (VBA – list Common Names) Point Table Species Table Point Shapefile Table Area Table Area Shapefile Table Transect Shapefile Table Transect Table

  5. Get User Input • GET database path, input shapefile directory, output directory and Common Name from user UI Button Control Browse Database Path Browse Input shapefile directory Browse Output directory Select Species

  6. Call Python (on OK click) • Message Box • Displays Results

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

  8. Results • Layers added to ArcMap display

  9. Project Demonstration • In ArcMap

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

More Related