NPS: Nature & Science » Networks: Klamath Network

Klamath Network Vital Sign Databases

The KLMN is making every attempt to use databases that have already been developed to obtain and store data collected from our monitoring projects. If a database is not available, we will adapt the Natural Resource Database Template (NRDT) developed by the National I&M Program staff to meet the needs of our projects. The NRDT is a core relational database structure that can be modified and built upon by different parks and networks depending on the components of their inventory and monitoring programs and the specific sampling protocols they use (Washington Support Office, 2004).

In addition, the Network will work closely with the parks to determine what system, if any, they are utilizing to collect data that are similar to the data being gathered as part of our monitoring effort. While it is recognized that we will not be able to conform to all databases utilized by each park, the Network will make every attempt to utilize databases that are compatible with the park databases.

Listed below are the 10 Vital Sign Monitoring Projects the KLMN will be implementing, along with a brief description of the databases we plan on using to collect and store data as part of those monitoring projects.

Cave Entrance Communities and Cave Environments

The Klamath Network is working closely with the staff and Lava Beds and Oregon Caves National Monument to implement this protocol. In an effort to find a solution on how to manage the data collected as part of this protocol we examined database systems currently being utilized by the park to manage data similar to what is being collected as part of this protocol. It was determined that no one database was available that stores information related to all the parameters we are collecting so the KLMN developed a cave monitoring database that follows the NRDT format. In addition to this database, Lava Beds National Monument utilized a park specific bat database to store all information collected on bats from this project and other bat related projects. The cave database used for this project has the ability to automatically extract bat data that was collected as part of this protocol and stored in the Lava Beds bat databases to ensure all data from this project is stored in one location.

Click to Download a DRAFT copy of the KLMN Cave Database

Intertidal Communities

As part of a regional effort, the Klamath Network is monitoring three intertidal sites located at Redwood National Park. The data from these three sites are incorporated into the MARINe database. MARINe (Multi-Agency Rocky Intertidal Network) is a partnership of local, state, and federal agencies; universities; and private organizations monitoring 80 rocky intertidal sites along the coast of California and Oregon (core monitoring) and 91 sites over a broader area from Alaska to Mexico (biodiversity monitoring).

Landbird Communities

The Network has entered into an agreement with the Klamath Bird Observatory (KBO) to implement our Landbird Communities Monitoring Project. KBO currently utilizes six relational databases and a series of SAS programs to collect, store, and quality control the data they collect. Once the data has been finalized by the KBO it is uploaded into a database developed by the KLMN that follows the NRDT format. The data undergoes one more round of automated quality control checks, issues are addressed, and then the data is finalized. The final KLMN NRDT data is expected to be completed in Summer 2010.

Click to Download a DRAFT copy of the KLMN Landbird Database

Land Cover / Land Use

The Klamath Network has entered into an agreement with Southern Oregon University to provide GIS and Remote Sensing support for the Network. As we begin to develop our protocol, the Network will work closely with SOU, the park units within the Network, other networks, and the National I&M Staff to develop a data storage method for this protocol.

Non-Native Species

Development of a standardized invasive plant database for the NPS is the ideal for easily sharing information about invasive species. However, this product is still in the planning stages while the NPS Natural Resource Stewardship and Science (NRSS) office in Fort Collins, Colorado transitions data systems to a Service Oriented Architecture (SOA) and XML web services development approach for data management and delivery. After discussions with the NRSS staff, analyzing the data collection methods currently being implemented by the parks, and conversations with the several members of the Exotic Plant Management Teams (EPMT), we have decided to develop our own database using the NRDT template and incorporating many of the utilities provided in the Weed Information Management System (WIMS) database developed by The Nature Conservancy. This database along with mobile mapping efforts using Trimble Pocket PCs and ArcPad give us the opportunity to collect data electronically in the field, quickly implement our quality control process, and develop reports in a timely manner. When the standardized database becomes available, the Network will determine if the database meets our needs and will utilize the database if applicable.

Click to Download a DRAFT copy of the KLMN

Invasives Database and Mobile Mapping Files

Terrestrial Vegetation and Whitebark Pine

Our program co-locates plots from our vegetation monitoring and whitebark pine monitoring projects to help provide a variety of data that can be used to describe the ecosystems of our parks. There are a variety of databases that have been developed by multiple agencies and organizations to store and manage vegetation and whitebark pine data . The Klamath Network looked at several of these database but we were unable to find a database that could meet the majority of the needs for both of our projects. Since we could not find a database that meets our needs, It was determined that we will developed a database using the Natural Resource Database Template (NRDT) developed by the National Park Service. The database will contain automated reporting functionality, built-in quality control processes, complete documentation on the design and use of the database, and will meet all the needs of the lead ecologist.

Click to Download a DRAFT copy of the KLMN

Vegetation / Whitebark Pine Database

Water Quality and Aquatic Communities (Streams and Lakes)

The water quality component of the Natural Resource Challenge (NRC) requires networks to archive all physical, chemical, and biological water quality data collected with NRC water quality funds in the National Park Service's STORET database maintained by the NPS' Water Resources Division (WRD). Networks are encouraged to also archive any other aquatic-related data collected with base Vital Signs funding in STORET. To facilitate archiving NPS data in STORET, the WRD has developed a series of Access-based templates (called NPSTORET), patterned after the Natural Resource Data Templates, for networks to use to enter their water quality data in a STORET-compatible format. Networks will send their data from NPSTORET to the WRD on an annual basis for quality assurance and upload into the WRD's copy of STORET and the Environmental Protection Agency's (EPA) STORET National Data Warehouse.

The Klamath Network is in the process of developing two protocols that document how we will collect and managed data for both stream and lake habitats. After reviewing the NPSTORET database, we have decided to develop our our database system that will have an automated export process that can export data to a format that is uploadable into NPSTORET. This decision was made based on the parameters we are collecting and the desire to collect data electronically while in the field. A draft copy of each of these database are expected to be available in the Winter of 2010.

Click to Download a DRAFT copy of the KLMN Lakes Database

Click to Download a DRAFT copy of the KLMN Streams Database

updated on 10/20/2010 I http://inp2300fcsdepo1.nps.doi.net/im/units/klmn/Data_Management/DM_KLMN_NRDT.cfm I Email: Webmaster

Please download the latest version of Adobe Reader :: Free Download
This site is best viewed in Internet Explorer 6.0 or later or Netscape 7.0

Nature & Science Air Biology Geology Natural Sounds Water I & M Home I & M Home Parks & Networks Inventory Monitoring Data Management Applications & Databases GIS Reports Standards & Policies Contacts I & M Intranet Site Map Network Home About Us Monitoring Inventories Data Management GIS Reports & Publications Outreach Partnerships Meetings & Presentations Data Management Data Management Documents Network Vital Sign Databases Project Deliverables Network Vital Signs Non-Native Species Whitebark Pine Terrestrial Vegetation Landbird Communities Intertidal Communities Water Quality and Aquatic Communities Lakes Monitoring Stream Monitoring Cave Entrance Communities and Cave Environments Land Cover KLMN Intranet	Klamath Network NPS » Nature & Science » Inventory & Monitoring » » Networks Klamath» Data Management Skip to Content Data Management Klamath Network Vital Sign Databases The KLMN is making every attempt to use databases that have already been developed to obtain and store data collected from our monitoring projects. If a database is not available, we will adapt the Natural Resource Database Template (NRDT) developed by the National I&M Program staff to meet the needs of our projects. The NRDT is a core relational database structure that can be modified and built upon by different parks and networks depending on the components of their inventory and monitoring programs and the specific sampling protocols they use (Washington Support Office, 2004). In addition, the Network will work closely with the parks to determine what system, if any, they are utilizing to collect data that are similar to the data being gathered as part of our monitoring effort. While it is recognized that we will not be able to conform to all databases utilized by each park, the Network will make every attempt to utilize databases that are compatible with the park databases. Listed below are the 10 Vital Sign Monitoring Projects the KLMN will be implementing, along with a brief description of the databases we plan on using to collect and store data as part of those monitoring projects. Cave Entrance Communities and Cave Environments The Klamath Network is working closely with the staff and Lava Beds and Oregon Caves National Monument to implement this protocol. In an effort to find a solution on how to manage the data collected as part of this protocol we examined database systems currently being utilized by the park to manage data similar to what is being collected as part of this protocol. It was determined that no one database was available that stores information related to all the parameters we are collecting so the KLMN developed a cave monitoring database that follows the NRDT format. In addition to this database, Lava Beds National Monument utilized a park specific bat database to store all information collected on bats from this project and other bat related projects. The cave database used for this project has the ability to automatically extract bat data that was collected as part of this protocol and stored in the Lava Beds bat databases to ensure all data from this project is stored in one location. Click to Download a DRAFT copy of the KLMN Cave Database Intertidal Communities As part of a regional effort, the Klamath Network is monitoring three intertidal sites located at Redwood National Park. The data from these three sites are incorporated into the MARINe database. MARINe (Multi-Agency Rocky Intertidal Network) is a partnership of local, state, and federal agencies; universities; and private organizations monitoring 80 rocky intertidal sites along the coast of California and Oregon (core monitoring) and 91 sites over a broader area from Alaska to Mexico (biodiversity monitoring). Landbird Communities The Network has entered into an agreement with the Klamath Bird Observatory (KBO) to implement our Landbird Communities Monitoring Project. KBO currently utilizes six relational databases and a series of SAS programs to collect, store, and quality control the data they collect. Once the data has been finalized by the KBO it is uploaded into a database developed by the KLMN that follows the NRDT format. The data undergoes one more round of automated quality control checks, issues are addressed, and then the data is finalized. The final KLMN NRDT data is expected to be completed in Summer 2010. Click to Download a DRAFT copy of the KLMN Landbird Database Land Cover / Land Use The Klamath Network has entered into an agreement with Southern Oregon University to provide GIS and Remote Sensing support for the Network. As we begin to develop our protocol, the Network will work closely with SOU, the park units within the Network, other networks, and the National I&M Staff to develop a data storage method for this protocol. Non-Native Species Development of a standardized invasive plant database for the NPS is the ideal for easily sharing information about invasive species. However, this product is still in the planning stages while the NPS Natural Resource Stewardship and Science (NRSS) office in Fort Collins, Colorado transitions data systems to a Service Oriented Architecture (SOA) and XML web services development approach for data management and delivery. After discussions with the NRSS staff, analyzing the data collection methods currently being implemented by the parks, and conversations with the several members of the Exotic Plant Management Teams (EPMT), we have decided to develop our own database using the NRDT template and incorporating many of the utilities provided in the Weed Information Management System (WIMS) database developed by The Nature Conservancy. This database along with mobile mapping efforts using Trimble Pocket PCs and ArcPad give us the opportunity to collect data electronically in the field, quickly implement our quality control process, and develop reports in a timely manner. When the standardized database becomes available, the Network will determine if the database meets our needs and will utilize the database if applicable. Click to Download a DRAFT copy of the KLMN Invasives Database and Mobile Mapping Files Terrestrial Vegetation and Whitebark Pine Our program co-locates plots from our vegetation monitoring and whitebark pine monitoring projects to help provide a variety of data that can be used to describe the ecosystems of our parks. There are a variety of databases that have been developed by multiple agencies and organizations to store and manage vegetation and whitebark pine data . The Klamath Network looked at several of these database but we were unable to find a database that could meet the majority of the needs for both of our projects. Since we could not find a database that meets our needs, It was determined that we will developed a database using the Natural Resource Database Template (NRDT) developed by the National Park Service. The database will contain automated reporting functionality, built-in quality control processes, complete documentation on the design and use of the database, and will meet all the needs of the lead ecologist. Click to Download a DRAFT copy of the KLMN Vegetation / Whitebark Pine Database Water Quality and Aquatic Communities (Streams and Lakes) The water quality component of the Natural Resource Challenge (NRC) requires networks to archive all physical, chemical, and biological water quality data collected with NRC water quality funds in the National Park Service's STORET database maintained by the NPS' Water Resources Division (WRD). Networks are encouraged to also archive any other aquatic-related data collected with base Vital Signs funding in STORET. To facilitate archiving NPS data in STORET, the WRD has developed a series of Access-based templates (called NPSTORET), patterned after the Natural Resource Data Templates, for networks to use to enter their water quality data in a STORET-compatible format. Networks will send their data from NPSTORET to the WRD on an annual basis for quality assurance and upload into the WRD's copy of STORET and the Environmental Protection Agency's (EPA) STORET National Data Warehouse. The Klamath Network is in the process of developing two protocols that document how we will collect and managed data for both stream and lake habitats. After reviewing the NPSTORET database, we have decided to develop our our database system that will have an automated export process that can export data to a format that is uploadable into NPSTORET. This decision was made based on the parameters we are collecting and the desire to collect data electronically while in the field. A draft copy of each of these database are expected to be available in the Winter of 2010. Click to Download a DRAFT copy of the KLMN Lakes Database Click to Download a DRAFT copy of the KLMN Streams Database TOP OF PAGE

Klamath Network

Data Management

Klamath Network Vital Sign Databases

Water Quality and Aquatic Communities (Streams and Lakes)