1 / 12

Database Template Alaska Implementation

Database Template Alaska Implementation. Alaska Support Office GIS Team. Angie Southwould Alaska Support Office, GIS Team. What is the Database Template?. The database template is a reusable set of tables and fields used to store data collected for the NPS Inventory & Monitoring Program.

sherlock_clovis
Download Presentation

Database Template Alaska Implementation

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. Database TemplateAlaska Implementation Alaska Support Office GIS Team Angie Southwould Alaska Support Office, GIS Team

  2. What is the Database Template? The database template is a reusable set of tables and fields used to store data collected for the NPS Inventory & Monitoring Program. What? Where? When? Who?

  3. Database Template: Concept study tables • The study tables are specific to a single field study • This data expands on the question: what was observed • These tables will not change, once created for a particular study • These tables may go away as more coordination occurs • The protocol tables are common to a study group or protocol • This data answers the question: what was observed • These tables will develop over time as more coordination occurs among field biologists • The core tables contain data common to all data collection studies • This data answers the questions: where and when • These tables are static; they never change protocol tables core tables

  4. birds plants marine fish freshwater fish nwan 2001 birds small mammals can 2001 plants amphibians can 2001 fresh fish swan 2002 fresh fish sean 2001 marine fish can 2002 small mammals ak 2001 amphibians Database Template: AK Region protocol tables core tables study tables all studies

  5. Database Template: AK Region New implementation for 2003: The individual freshwater fish study tables are being combined to create a single regional freshwater fish database. protocol tables study tables core tables all studies birds plants marine fish freshwater fish nwan 2001 birds small mammals can 2001 plants amphibians can 2001 fresh fish swan 2002 fresh fish sean 2001 marine fish can 2002 small mammals ak 2001 amphibians ak 2003 fresh fish

  6. Utilized a database from Alaska Dept of Fish & Game Recorded count of fish per species and life stage Several compatibility issues with data vs. mdb Database Template: Central AK

  7. Biologist worked with a database developer to create a model customized to fit the data being collected Recorded fish count per species Recorded present life stages Recorded fork lengths per fish Database Template: Southwest AK

  8. Fish biologists from the Central and Southwest Alaska Networks met with an inventory coordinator and database developers to design a regional freshwater fish database A model was created that accommodated both data collection protocols Database Template: Data Model

  9. Study Sites Observations Observers Habitat Methods Collections Database Template: Data Storage New implementation for 2003: Essentially, the study and protocol tables are merging for freshwater fish.

  10. Field forms were developed to correspond with the new regional data model The field forms match the data entry forms and allow for easy transfer of data into electronic format Database Template: Field Forms

  11. Habitat Methods Fish Collections Study Observation Event Site Location Database Template: Data Entry

  12. Database Template: Data Mgmt • Collaborate: Two heads are better than one • Think “Regionally” • Bring the field-area experts together for a combine effort • Design a single database that can be shared for similar protocols • Coordinate: Don’t reinvent the wheel • Take advantage of the database template or existing databases and tools • These concepts work outside of I&M

More Related