database template alaska implementation
Download
Skip this Video
Download Presentation
Database Template Alaska Implementation

Loading in 2 Seconds...

play fullscreen
1 / 12

Database Template - PowerPoint PPT Presentation


  • 363 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Database Template' - sherlock_clovis


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
database template alaska implementation

Database TemplateAlaska Implementation

Alaska Support Office

GIS Team

Angie Southwould

Alaska Support Office, GIS Team

what is the database template
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?

database template concept
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

database template ak region

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

database template ak region5
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

database template central ak
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
database template southwest ak
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
database template data model
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
database template data storage

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.

database template field forms
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
database template data entry

Habitat

Methods

Fish Collections

Study

Observation Event

Site Location

Database Template: Data Entry
database template data mgmt
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
ad