Species-Environment Relations Database
Identification_Information
Data_Quality_Information
Spatial_Data_Organization_Information
Spatial_Reference_Information
Entity_and_Attribute_Information
Distribution_Information
Metadata_Reference_Information
Identification Information
Section Index
Citation:
Citation Information:
Originator: Interior Columbia Basin Ecosystem Management Project
Publication Date: 10/31/1997
Title: Species-Environment Relations Database
Other Citation Details: /emp/crbdb/crb/species/bdbser.exe
Online Linkage: http://www.icbemp.gov/spatial/species/
Description:
Abstract: Species-Environment Relations (SER) Databases - Plants, Inverts, Verts, CRBstats and Qspec
Purpose:
The SER databases (1 each for plants, invertebrates, and vertebrates) describe basic ecology and species-environment relations of species or groups of rare fungi, lichens, bryophytes, and vascular plants; selected invertebrates; and nearly all vertebrates in the Interior CRB.
Supplemental Information:
Theme ID: 792
Theme Group: SPECIES
Theme Abbreviation: SPCSER
Data dictionaries are included as auxiliary metadata for all five databases. Five keypunch errors to Vegtype field in table "habtbl" were corrected 02/97.
Time Period of Content:
Time Period Information:
Currentness Reference: Publication Date
Status:
Keywords:
Theme:
Theme Keyword Thesaurus: None
Theme Keyword: Environment
Theme Keyword: Vertebrates
Theme Keyword: Species
Theme Keyword: Habitat
Theme Keyword: Invertebrates
Theme Keyword: Plants
Theme Keyword: Interior Columbia Basin Ecosystem Management Project
Theme Keyword: ICBEMP
Access Constraints: NONE
Use Constraints:
These data were intended for use at the broad-scale, generally the regional, subbasin (4th field HUC), or possibly the subwatershed (6th field HUC) level. The individual listed as Contact Person can answer questions concerning appropriate use of data.
Point of Contact:
Contact Information:
Contact Person Primary:
Contact Person: Barbara Wales
Contact Organization: ICBEMP / USDA Forest Service
Contact Position: Wildlife Biologist
Contact Address:
Address Type: Mailing & Physical Address
Address: Forestry and Range Sciences Lab, 1401 Gekeler Lane
City: La Grande
State or Province: OR
Postal Code: 97850
Country: USA
Contact Voice Telephone: (541) 962-6535
Contact Electronic Mail Address: bwales@fs.fed.us
Hours of Service: 8:30 - 5:00
Native Data Set Environment: Computer Operating System: PC/PARADOX, Filename: /emp/crbdb/crb/species/bdbser.exe, Native File Size: 22.48 Mb, Export File Size: 22.48 Mb
Cross Reference:
Data Quality Information
Section Index
Attribute Accuracy:
Attribute Accuracy Report:
The attributes in this dataset are derived from modeling or analytical processes. The accuracy of the attributes are dependent on the accuracy of the source materials as well as the margin of error inherent in the modeling or analytical processes.
Completeness Report:
The SER databases (1 each for plants, invertebrates, and vertebrates) describe basic ecology and species-environment relations of species or groups of rare fungi, lichens, bryophytes, and vascular plants; selected invertebrates; and nearly all vertebrates in the Interior CRB. The information was derived from consultation with expert panels and contract reports from leading species experts. See the Terrestestrial Ecology Chapter (Marcot & others) of the Assessment of Ecosystem Components in the Interior Columbia Basin and Portions of the Klamath and Great Basins (Quigley and others 1997). SER includes vegetation cover type and structural stage habitat relationships, key environmental correlates (KEC), and key ecological functions (KEF) for each species or species group. Data are related by record number (RECNO) or species name code (SPPCODE). Two additional SER databases (QSPEC & CRBSTATS) give information related by SPPCODE, such as level of endemism; federal, state, and agency status; and breeding status. The SER database was compiled to answer very broad-scale questions about geographic patterns and environment relations in the Interior CRB. Digital documents provided with the data tell how to install SER and give important cautions and caveats in the use of these data related to issues such as completeness, resolution, confidence in the data, lack of field studies for most species, and the need for testing.
Lineage:
Process Step:
Process Description:
Capture Method: Information for plants, vertebrates, and invertebrates are from expert panels and contract reports from leading species experts. For CRBSTATS, from literature and expert reviews. For QSPEC, from USF&W, state, BLM, & USFS lists. Database developed in Paradox 4.5 for DOS.
Version 1.0 was documented and released on a limited basis. Version 1.01 resulted from adding 8 species to the vertebrates database and correcting some of the species habitat information.
Process Date: 9/30/97
Process Time: 00:00:00
Process Contact:
Contact Information:
Contact Person Primary:
Contact Person: Kevin Gutierrez
Contact Organization: Bureau of Land Management
Contact Address:
Address Type: Mailing & Physical Address
Address: Prineville District Office, P.O. Box 550 / 3050 N.E. Third
City: Prineville
State or Province: OR
Postal Code: 97754
Country: USA
Contact Voice Telephone: 5414166716
Contact Electronic Mail Address: kgutierr@or.blm.gov
Spatial Data Organization Information
Section Index
Spatial Reference Information
Section Index
Horizontal Coordinate System Definition:
Planar:
Map Projection:
Map Projection Name: Albers Conical Equal Area
Albers Conical Equal Area:
Standard Parallel: 43
Standard Parallel: 48
Longitude of Central Meridian: -117
Latitude of Projection Origin: 41
False Easting: 700000
False Northing: 0
Planar Coordinate Information:
Planar Coordinate Encoding Method: Coordinate Pair
Planar Distance Units: meters
Geodetic Model:
Horizontal Datum Name: North American Datum of 1927
Ellipsoid Name: Clarke 1866
Semi-major Axis: 6378206
Denominator of Flattening Ratio: 294.9786982
Entity and Attribute Information
Section Index
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = CRBSTATS)
Entity Type Definition: Entire list of all vertebrates within the Interior Columbia River Basin and some associated statistics of each species.
Attribute:
Attribute Label: ABUN
Attribute Definition:
Description = Species abundance
Width = 3
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: I
Enumerated Domain Value Definition:
Irregular - Usually seen in low numbers and not seen every year. An example would be the Pacific Loon which is seen in some years in low numbers along the Columbia river in Oregon. Another example is the Snowy Owl which is uncommon in the northwest when winters are hard farther north but completely absent in most years.
Enumerated Domain Value: R
Enumerated Domain Value Definition:
Rare - Seen every year in very low numbers. The Pacific Loon for example is rare in Washington. There are usually less than ten sightings each year. While the Pacific loon is out of its normal range when sighted inland other species can be rare within their breeding range. For example the black-backed woodpecker is a year round resident of Montana, It breeds there but it is at the edge of its range and is rarely seen because the populations are small.
Enumerated Domain Value: U
Enumerated Domain Value Definition:
Uncommon - It is unlikely that you would see birds in this category unless you knew exactly when and where to look. Even then there is no guarantee. Their populations are larger than that of rare birds but still not always seen when expected.
Enumerated Domain Value: C
Enumerated Domain Value Definition: Common - Within the right habitat and season you could expect to see a bird in this category every time you went looking.
Enumerated Domain Value: A
Enumerated Domain Value Definition: Abundant - Within the right habitat and season birds in this category would seem to be everywhere.
Attribute:
Attribute Label: BRSTS
Attribute Definition:
Description = Breeding status
Width = 3
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: R
Enumerated Domain Value Definition: Resident - A bird species that breeds in the State and can be seen there all year round.
Enumerated Domain Value: B
Enumerated Domain Value Definition: Breeding - A species that breeds in the state but winters elsewhere
Enumerated Domain Value: N
Enumerated Domain Value Definition:
Non-breeding summer resident - This is an unusual situation. Only a few birds in the northwest fall within this category. One example is the Blue Jay which does not breed anywhere in the northwest but a quite a few hang around all summer in northwestern Wyoming.
Enumerated Domain Value: W
Enumerated Domain Value Definition: Wintering - Bird species that spend the winter and breed elsewhere.
Enumerated Domain Value: M
Enumerated Domain Value Definition: Migrants - Bird species present only in the spring and fall as they fly between wintering and breeding areas.
Attribute:
Attribute Label: CLASS
Attribute Definition:
Description = Taxonomic Class
Width = 2
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Amphibian
Enumerated Domain Value: B
Enumerated Domain Value Definition: Bird
Enumerated Domain Value: M
Enumerated Domain Value Definition: Mammal
Enumerated Domain Value: R
Enumerated Domain Value Definition: Reptile
Attribute:
Attribute Label: COMMON_NAM
Attribute Definition:
Description = Common species name
Width = 42
Attribute Type = C
Attribute:
Attribute Label: ENDEMISM
Attribute Definition:
Description = Endemism
Width = 2
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: LE
Enumerated Domain Value Definition:
Locally Endemic - Populations are restricted to a very small area (ie., one portion of a mountain range, one canyon, etc.) These taxa may also be restricted to highly specialized habitats. The range may lie entirely within, or on the CRB Assessment Area boundary.
Enumerated Domain Value: RE
Enumerated Domain Value Definition:
Regionally Endemic - Populations inhabit a larger geographic area than that of the local endemics (i.e., southeast Oregon, the Palouse etc.) These species may also be closely associated with certain habitats, and their range may lie entirely within, or on the CRB Assessment Area boundary.
Enumerated Domain Value: PE
Enumerated Domain Value Definition:
Peripheral - Populations lie on the margins of the CRB Assessment Area boundary or in the case of some bird species completely outside of the CRB. Birds such as the Pacific loon are casual visitors away from the normal species range.
Enumerated Domain Value: DI
Enumerated Domain Value Definition: Disjunct - Populations in the CRB Assessment Area are substantially separated geographically from the remainder of the species range.
Enumerated Domain Value: SC
Enumerated Domain Value Definition: Scattered - Populations are sparsely distributed within the CRB Assessment Area. In the case of birds this might indicate specialized habitats for wintering, migrating or breeding.
Enumerated Domain Value: CO
Enumerated Domain Value Definition:
Common - Not to be confused with the abundance "common", this refers to populations. Populations can be common but not have a large number of individuals. For example, mountain lion populations are probably common within the northwest. However, each population has a relatively small number of individuals. In contrast some species such as the spotted frog in eastern Oregon may have just a few scattered populations with many individuals in each population. The spotted frog would go into the scattered category.
Attribute:
Attribute Label: FAMILY
Attribute Definition:
Description = Taxonomic Family
Width = 18
Attribute Type = C
Attribute:
Attribute Label: ID
Attribute Definition:
Description = Two letter code listed for each species of bird in Idaho, a combination of the breeding status (first letter) and abundance (second letter). See BRSTS and ABUN for definition of values.
Width = 3
Attribute Type = C
Attribute:
Attribute Label: MT
Attribute Definition:
Description = Two letter code listed for each species of bird in Montana, a combination of the breeding status (first letter) and abundance (second letter). See BRSTS and ABUN for definition of values.
Width = 3
Attribute Type = C
Attribute:
Attribute Label: NEO
Attribute Definition:
Description = Neotropical Migrant Status
Width = 2
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: long-distance migrant (south of the United States)
Enumerated Domain Value: B
Enumerated Domain Value Definition: short-distance migrant
Attribute:
Attribute Label: NV_UT
Attribute Definition:
Description = Two letter code listed for each species of bird in Nevada and Utah, a combination of the breeding status (first letter) and abundance (second letter). See BRSTS and ABUN for definition of values.
Width = 3
Attribute Type = C
Attribute:
Attribute Label: OR
Attribute Definition:
Description = Two letter code listed for each species of bird in Oregon, a combination of the breeding status (first letter) and abundance (second letter). See BRSTS and ABUN for definition of values.
Width = 3
Attribute Type = C
Attribute:
Attribute Label: SCIENTIFIC
Attribute Definition:
Description = Scientific species name
Width = 47
Attribute Type = C
Attribute:
Attribute Label: TAX
Attribute Definition:
Description = Number to put species in taxonomic order
Width = 3
Attribute Type = C
Attribute Domain Values:
Range Domain:
Range Domain Minimum: 1
Range Domain Maximum: 96
Attribute:
Attribute Label: WA
Attribute Definition:
Description = Two letter code listed for each species of bird in Washington, a combination of the breeding status (first letter) and abundance (second letter). See BRSTS and ABUN for definition of values.
Width = 3
Attribute Type = C
Attribute:
Attribute Label: WY
Attribute Definition:
Description = Two letter code listed for each species of bird in Wyoming, a combination of the breeding status (first letter) and abundance (second letter). See BRSTS and ABUN for definition of values.
Width = 3
Attribute Type = C
Attribute:
Attribute Label: XXRANGE
Attribute Definition:
Description = Percent of species range within Columbia river basin
Width = 2
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Nearly all (80-99%) of the overall species range occurs outside CRB
Enumerated Domain Value: B
Enumerated Domain Value Definition: More than half, but not nearly all (60-79%) occurs outside CRB
Enumerated Domain Value: C
Enumerated Domain Value Definition: About half (40-59%) occurs outside CRB
Enumerated Domain Value: D
Enumerated Domain Value Definition: Less than half, but not only a very small portion (20-39%) occurs outside CRB
Enumerated Domain Value: E
Enumerated Domain Value Definition: Only a very small portion (0-19%) occurs outside CRB
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = C-CLASS)
Entity Type Definition:
Environmental Correlate classification table.
See APPENDIX 1 of SER_AUX.PDF for "Classification of Key Environmental Correlates" for a description of the Classification numbers (C1, C2, C3, C4)
Attribute:
Attribute Label: C1
Attribute Definition:
Description = First classification number
Width = 2
Attribute Type = N
Range = 1 - 10
Attribute:
Attribute Label: C2
Attribute Definition:
Description = Second classification number
Width = 2
Attribute Type = N
Range = 1 - 22
Attribute:
Attribute Label: C3
Attribute Definition:
Description = Third classification number
Width = 2
Attribute Type = N
Range = 1 - 18
Attribute:
Attribute Label: C4
Attribute Definition:
Description = Forth classification number
Width = 2
Attribute Type = N
Range = 1 - 13
Attribute:
Attribute Label: CORNO
Attribute Definition:
Description = Correlate Number. Definition of the correlate number can be found by querying the "Lookups" table in the "Corno" field if the value is greater than 10. If the value for the correlate number is 10 or less you can locate the definitions of the correlates by querying the "Kectbl" or "Keftbl" tables.
Width = 4
Attribute Type = N
Range = 1 - 370
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = CORRTBL)
Entity Type Definition:
Environmental Correlates. These correlates are related to 4 other tables, namely, Kectbl, Measures, Seasons, and C-class. Because the classifications are related to these correlates, the user should include all five of the tables in their analysis. The tables by themselves may produce meaningless results. These correlates can be identified by their values of <= 10.
Attribute:
Attribute Label: CORNO
Attribute Definition:
Description - Correlate number. A composite of the correlate number and the record number keeps these record unique. Thus a record (species) may have multiple entries, with up to 10 correlates.
Width = 2
Attribute Type = N
Range = 1 - 370
Attribute:
Attribute Label: CORRELATES
Attribute Definition:
Description - Name of the correlate
Width = 60
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = DISPERSE)
Entity Type Definition: Dispersal table. Lists modes and requirements of dispersal.
Attribute:
Attribute Label: DISPMODE
Attribute Definition:
Description - Mode of dispersal.
Width = 60
Attribute Type = C
Attribute:
Attribute Label: DISPREQ
Attribute Definition:
Description - Requirements of dispersal.
Width = 150
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = F-CLASS)
Entity Type Definition:
Key ecological functions classifications. The functions were classified according to Bruce Marcot's document "Classification of Key Ecological Functions"
See APPENDIX 3 of SER_AUX.PDF "Classification of Key Ecological Functions" for a description of the function codes (F1, F2, F3, F4)
Attribute:
Attribute Label: F1
Attribute Definition:
Description - First classification number
Width = 2
Attribute Type = N
Range = 1 - 10
Attribute:
Attribute Label: F2
Attribute Definition:
Description - Second classification number
Width = 2
Attribute Type = N
Range = 1 - 13
Attribute:
Attribute Label: F3
Attribute Definition:
Description - Third classification number
Width = 2
Attribute Type = N
Range = 1 - 9
Attribute:
Attribute Label: F4
Attribute Definition:
Description - Fourth classification number
Width = 2
Attribute Type = N
Range = 1 - 8
Attribute:
Attribute Label: KEFNO
Attribute Definition:
Description - Key ecological function number. This number along with the record number form a unique identifier that links to the description of the function in the "Keftbl"
Width = 2
Attribute Type = N
Range = 1 - 8
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = GEOAREA)
Entity Type Definition:
Geographic area. Lists the geographic areas occupied by the species
See APPENDIX 4 of SER_AUX.PDF for a list of the Geographic Areas used for each class.
Attribute:
Attribute Label: GEOARHAB
Attribute Definition:
Description - Geographic area.
Width = 40
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = HABTBL)
Entity Type Definition: Habitats. See APPENDIX 5 of SER_AUX.PDF for a description of possible Vegetation and Structure codes
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Attribute:
Attribute Label: STRUCTURE
Attribute Definition:
Description - Structure code for the Vegetation.
Width = 8
Attribute Type = C
Attribute:
Attribute Label: VEGTYPE
Attribute Definition:
Description - Vegetation type code.
Width = 8
Attribute Type = C
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = HEADER)
Entity Type Definition: Contains information about the record such as the confidence of the information, trend, and other comments.
Attribute:
Attribute Label: COMMENTS
Attribute Definition:
Description - Comments
Width = 255
Attribute Type = C
Attribute:
Attribute Label: CONFIDENCE
Attribute Definition:
Description - Confidence level of the data rated 0 to 5 with 5 being the highest level of confidence.
Width = 1
Attribute Type = N
Attribute Domain Values:
Range Domain:
Range Domain Minimum: 0
Range Domain Maximum: 5
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = KECTBL)
Entity Type Definition: Correlate categories.
Attribute:
Attribute Label: CAT
Attribute Definition:
Description - Categories
Width = 60
Attribute Type = C
Attribute:
Attribute Label: CORNO
Attribute Definition:
Description - Correlate number. Also relates to the "C-class", "Corrtbl", and the "Seasons" tables.
Width = 4
Attribute Type = N
Range 1 - 370
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = KEFTBL)
Entity Type Definition: Functions table
Attribute:
Attribute Label: KEF
Attribute Definition:
Description - The function
Width = 140
Attribute Type = C
Attribute:
Attribute Label: KEFNO
Attribute Definition:
Description - Function number. The composite of the "Kefno" and the record number create a unique identifier for each function by species (related thru the record number)
Width = 1
Attribute Type = N
Range = 1 - 8
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = LOOKUPS)
Entity Type Definition: This table serves as a lookup to table values. The data diagram shows the relationships to the table. This document also describes the relationships.
Attribute:
Attribute Label: ATTRDESCRI
Attribute Definition:
Description - Attribute Description. This is the description of either the "Attribute name" or the "Corno"
Width = 60
Attribute Type = C
Attribute:
Attribute Label: ATTRNAME
Attribute Definition:
Description - Attribute Name. This is the main linking field for crosswalking codes in tables to their descriptions
Width = 25
Attribute Type = C
Attribute:
Attribute Label: CORNO_KEFN
Attribute Definition:
Description -This field provides descriptions for Correlate numbers greater than 10. Values less than 11 are described in the "Corrtbl"
Width = 2
Attribute Type = N
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = MEASURES)
Entity Type Definition:
Describes the measures and some values by which the species was measured, and is related to correlates. To be meaningful, you must link to a correlate number in "Seasons" or "Corrtbl" to find what it is that you are measuring.
Attribute:
Attribute Label: CORNO
Attribute Definition:
Description - Record number. Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Attribute:
Attribute Label: MAX
Attribute Definition:
Description - Maximum of the measure
Width =10
Attribute Type = C
Attribute:
Attribute Label: MEASURE
Attribute Definition:
Description - Type of measure
Width = 20
Attribute Type = C
Attribute:
Attribute Label: MIN
Attribute Definition:
Description - Minimum of the measure
Width =10
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = VEGSTRCT)
Entity Type Definition: Plant habitats
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Attribute:
Attribute Label: STRUCID
Attribute Definition:
Description - Structure Id number. Relates to CRBSUM tables.
Width = 2
Attribute Type = N
Attribute:
Attribute Label: STRUCTURE
Attribute Definition:
Description - Structure codes. These codes are a compilation of the structures in a VegCode.
Width = 4
Attribute Type = C
Attribute:
Attribute Label: VEGCODE
Attribute Definition:
Description - Vegetation codes for the plant habitat. Also is linkable to the "Attributes names" field in the "Lookup" table. This also allows a link to CRBSUM thru the "Vegstruct" table
Width = 18
Attribute Type = C
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = RECORD)
Entity Type Definition: Master table of valid record numbers and the SPPCODE (species) that the record number represents.
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Attribute:
Attribute Label: SPPCODE
Attribute Definition:
Description - Species for the record number
Width = 6
Attribute Type = C
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = SEASONS)
Entity Type Definition: Season table
Attribute:
Attribute Label: CORNO
Attribute Definition:
Description - Correlate number. The correlate number along with the record number creates a unique identifier that relates the proper seasons to the it's correlate. Related to "C-class", "Corrtbl", "Measures", and "Kectbl" tables.
Width = 1
Attribute Type = N
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Attribute:
Attribute Label: SEASON
Attribute Definition:
Description - Season. Either/or a combination of winter, spring, summer, or fall.
Width = 12
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Fall
Enumerated Domain Value: Spring
Enumerated Domain Value: Summer
Enumerated Domain Value: Winter
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = SPP)
Entity Type Definition: Species codes and other information such as common name, class, and scientific name.
Attribute:
Attribute Label: CLASS
Attribute Definition:
Description - Species class
Width = 2
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Amphibian
Enumerated Domain Value: B
Enumerated Domain Value Definition: Bird
Enumerated Domain Value: I
Enumerated Domain Value Definition: Invertebrate
Enumerated Domain Value: M
Enumerated Domain Value Definition: Mammal
Enumerated Domain Value: R
Enumerated Domain Value Definition: Reptile
Attribute:
Attribute Label: COMMON_NAM
Attribute Definition:
Description - Common name for the species
Width = 42
Attribute Type = C
Attribute:
Attribute Label: FAMILY
Attribute Definition:
Description - Species family
Width = 18
Attribute Type = C
Attribute:
Attribute Label: SCIENTIFIC
Attribute Definition:
Description - Scientific name
Width = 47
Attribute Type = C
Attribute:
Attribute Label: SPPCODE
Attribute Definition:
Description - Species code
Width = 6
Attribute Type = C
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = USTYTBL)
Entity Type Definition: Understory characteristics for the species
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Attribute:
Attribute Label: UNDERSTORY
Attribute Definition:
Description - Understory code. Related to the "Attribute names" field in the "Lookups" table
Width = 4
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Bar
Enumerated Domain Value Definition: Barren
Enumerated Domain Value: Ctr
Enumerated Domain Value Definition: Conifer Trees
Enumerated Domain Value: Grs
Enumerated Domain Value Definition: Grass
Enumerated Domain Value: Htr
Enumerated Domain Value Definition: Hardwood Trees
Enumerated Domain Value: Shr
Enumerated Domain Value Definition: Shrub
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = VEGCODES)
Entity Type Definition:
Vegetation codes
See APPENDIX 5 of SER_AUX.PDF for a description of Vegetation Codes.
Attribute:
Attribute Label: VEGCODE
Attribute Definition:
Description - Vegetation code.
Width = 17
attribute Type = C
Attribute:
Attribute Label: VEGDESC
Attribute Definition:
Description - Description of the vegetation code
Width = 50
Attribute Type = C
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = CLIMTBL)
Entity Type Definition:
Lists the types of climates associated with a species. Related to the species name by the record number. Whenever an entry was made for "Ann-precip" then there is usually a value given in the "Ann-precip" field"
This entity only exists for PLANTS
Attribute:
Attribute Label: ANN_PRECIP
Attribute Definition:
Description - Annual precipitation (inches).
Width = 8
Attribute Type = C
Attribute:
Attribute Label: CLIMATE
Attribute Definition:
Description - Climate type
Width = 12
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = CVRTBL)
Entity Type Definition:
Cover table. This table lists the characteristics of the cover types entered that are associated with the a species. the "Characteristics" field is linkable to the "Attributes" field in the "Lookups" table to include the description in your analysis.
This entity only exists for PLANTS.
Attribute:
Attribute Label: CHARACTERI
Attribute Definition:
Description - Characteristics of cover types associated with a species. Linkable to the "Attributes" field in the "Lookups" table to include the description in your analysis.
Width = 10
Attribute Type = C
Attribute:
Attribute Label: OSCANOPY
Attribute Definition:
Description - Dominant overstory canopy cover in forested communities measured in percentages
Width = 4
Attribute Type = N
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Attribute:
Attribute Label: TOTALCOVER
Attribute Definition:
Description - Total canopy cover in forested communities measured in percentages.
Width = 4
Attribute Type = N
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = EFFECTS)
Entity Type Definition:
Holds information about the effects of fire, exotics, grazing, grazing impacts, mining, and other effects.
This entity only exists for PLANTS.
Attribute:
Attribute Label: ATTRIBUTES
Attribute Definition:
Description - The attribute of the effect for that species. This code can be linked to the "ATTRNAME" field in the "Lookups" table to include an ancillary notation for that code.
Width = 15
Attribute Type = C
Attribute:
Attribute Label: EFFECTS
Attribute Definition:
Description - Type of effects.
Width = 15
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Exotic-effects
Enumerated Domain Value: Fire
Enumerated Domain Value: Grazing
Enumerated Domain Value: Grazing-impacts
Enumerated Domain Value: Logging
Enumerated Domain Value: Mining
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = EFF-COM)
Entity Type Definition:
Effects comments. This table will hold comments about all the effects described in the "Effects" table. Link is by record number and "Effect"
This entity only exists for PLANTS.
Attribute:
Attribute Label: COMMENT
Attribute Definition:
Description - Comment
Width = 255
Attribute Type = C
Attribute:
Attribute Label: EFFECT
Attribute Definition:
Description - Effect. Related to "Effect" field in "Effects" table.
Width = 15
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = ENDTBL)
Entity Type Definition:
Endemism. Generally, the prevalent locality of the species.
See APPENDIX 2 of SER_AUX.PDF for definitions of the endemism categories.
This entity only exists for PLANTS
Attribute:
Attribute Label: ENDEMISM
Attribute Definition:
Description - Endemic code for the species. This code can be linked to the "ATTRNAME" field in the "Lookups" table for a description of the code.
Width = 8
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Enddj
Enumerated Domain Value Definition: Endemism - Disjunct
Enumerated Domain Value: Endle
Enumerated Domain Value Definition: Endemism - Local endemic
Enumerated Domain Value: Endpe
Enumerated Domain Value Definition: Endemism - Peripheral
Enumerated Domain Value: Endre
Enumerated Domain Value Definition: Endemism - Regional endemic
Enumerated Domain Value: Endsc
Enumerated Domain Value Definition: Endemism - Scattered
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = ENDCOM)
Entity Type Definition:
Endemism comments.
This entity only exists for PLANTS
Attribute:
Attribute Label: COMMENT
Attribute Definition:
Description - Comments
Width = 100
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = EXCHANCE)
Entity Type Definition:
Exotic plants that have the most chance of impact. This table is more meaningful when exotics are also queried from the "Effects" table. Other effects of exotics can be located by querying the "Eff-com" (Effects comments) field.
This entity only exists for PLANTS.
Attribute:
Attribute Label: MOSTCHANCE
Attribute Definition:
Description - Exotic plants that have the most chance of impact.
Width = 50
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = GEOLOGY)
Entity Type Definition:
Describes the geology & soil characteristics associated with the species.
This entity only exists for PLANTS.
Attribute:
Attribute Label: ATTRIBUTES
Attribute Definition:
Description - Attribute for the Geology or Soil code. This can be linked to the "Attribute" field of the "Lookups" table for a description of the codes. Within the Attribute description, landform refers to the plants' position on the landscape, and geology refers to the composition of the substrate the plant is found on.
Width = 15
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Basalt
Enumerated Domain Value Definition: Basalt
Enumerated Domain Value: Calcareous
Enumerated Domain Value Definition: Calcareous Rock
Enumerated Domain Value: Clay
Enumerated Domain Value Definition: Clay (alluvium)
Enumerated Domain Value: Glacial
Enumerated Domain Value Definition: Glacial Till and Landslides
Enumerated Domain Value: Granite
Enumerated Domain Value Definition: Granite
Enumerated Domain Value: Playa
Enumerated Domain Value Definition: Playa
Enumerated Domain Value: Rhylolite
Enumerated Domain Value Definition: Rhylolite
Enumerated Domain Value: Sand
Enumerated Domain Value Definition: Sand (sandstone)
Enumerated Domain Value: Sed/meta
Enumerated Domain Value Definition: Sedimentary/Metamorphic
Enumerated Domain Value: Serpentine
Enumerated Domain Value Definition: Serpentine
Enumerated Domain Value: Talus
Enumerated Domain Value Definition: Talus
Enumerated Domain Value: Tuff
Enumerated Domain Value Definition: Tuff
Enumerated Domain Value: Cliff
Enumerated Domain Value Definition: Cliff
Enumerated Domain Value: Ridgetop
Enumerated Domain Value Definition: Ridgetop
Enumerated Domain Value: Scabland
Enumerated Domain Value Definition: Scabland
Enumerated Domain Value: Valleybottom
Enumerated Domain Value Definition: Valleybottom
Enumerated Domain Value: Acid
Enumerated Domain Value Definition: Soil pH - Acid
Enumerated Domain Value: Alkaline
Enumerated Domain Value Definition: Soil pH - Alkaline
Enumerated Domain Value: Coarstxtr
Enumerated Domain Value Definition: Soil Texture - Coarse (sand)
Enumerated Domain Value: Deep
Enumerated Domain Value Definition: Soil Depth - Deep (40-60")
Enumerated Domain Value: Finetxtr
Enumerated Domain Value Definition: Soil Texture - Fine
Enumerated Domain Value: Mediumtxtr
Enumerated Domain Value Definition: Soil Texture - Medium
Enumerated Domain Value: Mod-deep
Enumerated Domain Value Definition: Soil Depth - Moderately Deep (20-40")
Enumerated Domain Value: Moist-andic
Enumerated Domain Value Definition: Soil Moisture Regime - Aridic
Enumerated Domain Value: Moist-udic
Enumerated Domain Value Definition: Soil Moisture Regime - Udic
Enumerated Domain Value: Moist-ustic
Enumerated Domain Value Definition: Soil Moisture Regime - Ustic
Enumerated Domain Value: Moist-xeric
Enumerated Domain Value Definition: Soil Moisture Regime - Xeric
Enumerated Domain Value: Neutral
Enumerated Domain Value Definition: Soil pH - Neutral
Enumerated Domain Value: Shallow
Enumerated Domain Value Definition: Soil Depth - Shallow (10-20")
Enumerated Domain Value: Temp-cryic
Enumerated Domain Value Definition: Soil Temperature - Cryic (0-8'C)
Enumerated Domain Value: Temp-frigid
Enumerated Domain Value Definition: Soil Temperature - Frigid (diff. mean summer/winter = >5')
Enumerated Domain Value: Temp-mesic
Enumerated Domain Value Definition: Soil Temperature - Mesic (8-15'C)
Enumerated Domain Value: Verydeep
Enumerated Domain Value Definition: Soil Depth - Very Deep (>40")
Enumerated Domain Value: Veryshallow
Enumerated Domain Value Definition: Soil Depth - Very Shallow (<10")
Attribute:
Attribute Label: GEO_SOIL
Attribute Definition:
Description - Geology or soil
Width = 8
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Geology
Enumerated Domain Value: Soils
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = INDTBL)
Entity Type Definition:
Indicators.
This entity only exists for PLANTS.
Attribute:
Attribute Label: INDICATOR
Attribute Definition:
Description - Indicator. Related to the "Attribute" field in the "Lookups" table
Width = 15
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Airquality
Enumerated Domain Value Definition: Air Quality
Enumerated Domain Value: CaCO3
Enumerated Domain Value Definition: CaCO3
Enumerated Domain Value: Flow-high
Enumerated Domain Value Definition: Flow level, high water mark
Enumerated Domain Value: Flow-low
Enumerated Domain Value Definition: Flowe level, low water mark
Enumerated Domain Value: Grazdec
Enumerated Domain Value Definition: Grazing decreasers
Enumerated Domain Value: Grazin
Enumerated Domain Value Definition: Graxing increasers
Enumerated Domain Value: HighN
Enumerated Domain Value Definition: High N
Enumerated Domain Value: Metalrich
Enumerated Domain Value Definition: Metal rich rock
Enumerated Domain Value: Oldgrowth
Enumerated Domain Value Definition: Old growth
Enumerated Domain Value: Soiltemphigh
Enumerated Domain Value Definition: Soil temperature (high)
Enumerated Domain Value: Soiltemplow
Enumerated Domain Value Definition: Soil temperature (low)
Enumerated Domain Value: Texture-coarse
Enumerated Domain Value Definition: Soil texture, coarse
Enumerated Domain Value: Texture-fine
Enumerated Domain Value Definition: Soil texture, fine
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = INDCOM)
Entity Type Definition:
Indicator comments.
This entity only exists for PLANTS.
Attribute:
Attribute Label: COMMENT
Attribute Definition:
Description - Comment. Related to the "Indtbl" by the record number.
Width = 255
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = LFRMTBL)
Entity Type Definition:
Life forms
This entity only exists for PLANTS.
Attribute:
Attribute Label: LIFEFORM
Attribute Definition:
Description - Life form number. The definition of each lifeform number differs depending on whether the species is a vascular plant or a fungus.
Width = 3
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: Lf1
Enumerated Domain Value Definition:
Vascular Plants:
Phanerophytes: Species with perennating buds or shoot apices on aerial shoots. Group includes most woody shrubs or trees
Fungi: Mushroom
Enumerated Domain Value: Lf2
Enumerated Domain Value Definition:
Vascular plants:
Chamaephytes: Species that hold their perenating buds and shoot apices very close to the ground. Group includes semi-woody and herbaceous species that persist above ground throughout the year (though not necessarily in a physiological active state). Group includes bunch grasses and cushion plants.
Fungi: Resupinate
Enumerated Domain Value: Lf3
Enumerated Domain Value Definition:
Vascular plants:
Hemicryptophytes: Species with perennating buds at ground level, all parts above ground dying back at the end of the active growing season. Stolons may or may not be present. Group includes rosette plants (e.g. Taraxacum), partial rosette plants (e.g. Achillea millefolium, and stoloniferous species (e.g. Rubus).
Fungi: Truffle
Enumerated Domain Value: Lf4
Enumerated Domain Value Definition:
Vascular plants:
Cryptophytes: Species bear their perennating buds below ground level or submerged in water. Group includes rhizomatous and bulb forming species (e.g. Allium), and aquatic species such as Alisma and Nuphar.
Fungi: Puffball
Enumerated Domain Value: Lf5
Enumerated Domain Value Definition:
Vascular plants:
Therophytes: This is a group for annual species (e.g. Bromus tectorum or Stephanomeria malheurensis).
Fungi: Polypore
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = SUBSTRTS)
Entity Type Definition:
Substrates information
This entity only exists for PLANTS.
Attribute:
Attribute Label: ATTRIBUTES
Attribute Definition:
Description - Attributes
Width = 20
Attribute Type = C
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
range = 1 - 4423
Attribute:
Attribute Label: SUBSTRATES
Attribute Definition:
Description - Substrate
Width = 15
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: NonVeg
Enumerated Domain Value: OtherNonVeg
Enumerated Domain Value: OtherVeg
Enumerated Domain Value: Veg
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = TOPOTBL)
Entity Type Definition:
Topography. Associated topography for the species.
This entity only exists for PLANTS.
Attribute:
Attribute Label: ELEV_MAX
Attribute Definition:
Description - If the topography shows "Elev-max" as a correlate then there may be a value shown in this field.
Width = 5
Attribute Type = N
Attribute Domain Values:
Range Domain:
Range Domain Minimum: 500
Range Domain Maximum: 12000
Attribute:
Attribute Label: ELEV_MIN
Attribute Definition:
Description - If the topography shows "Elev-min" as a correlate then there may be a value shown in this field.
Width = 5
Attribute Type = N
Attribute Domain Values:
Range Domain:
Range Domain Minimum: 0
Range Domain Maximum: 9000
Attribute:
Attribute Label: RECORD
Attribute Definition:
Description = Record number - Used to relate to other entities of the database.
Width = 4
Attribute Type = C
Range = 1 - 4423
Attribute:
Attribute Label: TOPOGRAPHY
Attribute Definition:
Description - Topography. These tables can be linked to the "Attribute names" field in the "Lookups" table.
Width = 15
Attribute Type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: East
Enumerated Domain Value Definition: Aspect - East
Enumerated Domain Value: Flat
Enumerated Domain Value Definition: Aspect - Flat
Enumerated Domain Value: North
Enumerated Domain Value Definition: Aspect - North
Enumerated Domain Value: Northerly
Enumerated Domain Value Definition: Aspect - Northerly
Enumerated Domain Value: South
Enumerated Domain Value Definition: Aspect - South
Enumerated Domain Value: Elev-max
Enumerated Domain Value Definition: Maximum Elevation (feet)
Enumerated Domain Value: Elev-min
Enumerated Domain Value Definition: Minimum Elevation (feet)
Enumerated Domain Value: Pos-low
Enumerated Domain Value Definition: Slope Position - Lower
Enumerated Domain Value: Pos-mid
Enumerated Domain Value Definition: Slope Position - Middle
Enumerated Domain Value: Pos-upper
Enumerated Domain Value Definition: Slope Position - Upper
Enumerated Domain Value: Sl-flat
Enumerated Domain Value Definition: Slope - Flat (0-10%)
Enumerated Domain Value: Sl-gentle
Enumerated Domain Value Definition: Slope - Gentle (11-30%)
Enumerated Domain Value: Sl-steep
Enumerated Domain Value Definition: Slope - Steep (31-50%)
Enumerated Domain Value: Sl-verysteep
Enumerated Domain Value Definition: Slope - Very Steep (>51%)
Enumerated Domain Value: Southerly
Enumerated Domain Value Definition: Aspect - Southerly
Enumerated Domain Value: West
Enumerated Domain Value Definition: Aspect - West
Detailed Description:
Entity Type:
Entity Type Label: Species-Environment Relations Database (Table Name = QSPEC)
Entity Type Definition:
Entire list of: all vertebrates; plants (including bryophytes and fungi) and plant groups of concern; invertebrates of concern; and functional groups of invertebrates within the Interior Columbia River Basin.
Attribute:
Attribute Label: B_ID
Attribute Definition:
Description - Bureau of Land Management Idaho species designation
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Assessing
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: B_MT
Attribute Definition:
Description - Bureau of Land Management Montana species designation
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Assessing
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: B_NV
Attribute Definition:
Description - Bureau of Land Management Nevada species designation
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Assessing
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: B_OR
Attribute Definition:
Description - Bureau of Land Management Oregon species designation
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Assessing
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: B_WA
Attribute Definition:
Description - Bureau of Land Management Washington species designation
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Assessing
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: B_WY
Attribute Definition:
Description - Bureau of Land Management Wyoming species designation
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: A
Enumerated Domain Value Definition: Assessing
Attribute:
Attribute Label: BS
Attribute Definition:
Description - Bureau of Land Management senitive in any state
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: CLASS
Attribute Definition:
Description - Taxonomic Class
Width = 2
Attribute type - C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: B
Enumerated Domain Value Definition: Bird
Enumerated Domain Value: BG
Enumerated Domain Value Definition: Bryophyte group
Enumerated Domain Value: I
Enumerated Domain Value Definition: Invertebrate
Enumerated Domain Value: L
Enumerated Domain Value Definition: Lichen
Enumerated Domain Value: LG
Enumerated Domain Value Definition: Lichen group
Enumerated Domain Value: M
Enumerated Domain Value Definition: Mammal
Enumerated Domain Value: NV
Enumerated Domain Value Definition: Non-vascular
Enumerated Domain Value: P
Enumerated Domain Value Definition: Plant
Enumerated Domain Value: PG
Enumerated Domain Value Definition: Plant group
Enumerated Domain Value: R
Enumerated Domain Value Definition: Reptile
Attribute:
Attribute Label: COMMENTS
Attribute Definition:
Description - Comments
Width = 29
Attribute type = C
Attribute:
Attribute Label: COMMON_NAM
Attribute Definition:
Description - Common name
Width = 42
Attribute type = C
Attribute:
Attribute Label: DTB
Attribute Definition:
Description - Species in SERS database.
Width = 1
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: X
Enumerated Domain Value Definition: Species in SERS database
Attribute:
Attribute Label: EXT
Attribute Definition:
Description - Extinct or Extirpated in part or all of it's range- includes status from Oregon (ONHP list 1-ex or 2-ex), WA (TNC rank), and (ID INPS) - see COMMENTS for details and locations.
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: X
Enumerated Domain Value Definition: Extinct or Extirpated
Attribute:
Attribute Label: F_ID
Attribute Definition:
Description - Forest Service Idaho sensitive species
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: F_MT
Attribute Definition:
Description - Forest Service Montana sensitive species
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: F_NV
Attribute Definition:
Description - Forest Service Nevada sensitive species
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: F_OR
Attribute Definition:
Description - Forest Service Oregon sensitive species
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: F_WA
Attribute Definition:
Description - Forest Service Washington sensitive species
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: F_WY
Attribute Definition:
Description - Forest Service Wyoming sensitive species
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Attribute:
Attribute Label: FAMILY
Attribute Definition:
Description - Taxonomic Family
Width = 18
Attribute type = C
Attribute:
Attribute Label: FS
Attribute Definition:
Description - Forest Service sensitive in any state
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: S
Enumerated Domain Value Definition: Sensitive
Enumerated Domain Value: T
Enumerated Domain Value Definition: Threatened?
Enumerated Domain Value: E
Enumerated Domain Value Definition: Endangered?
Attribute:
Attribute Label: ID_STATUS
Attribute Definition:
Description - Concatenation of state status and Federal Status for that species in Idaho
Width = 10
Attribute type = C
Attribute:
Attribute Label: IDF_G
Attribute Definition:
Description - Idaho Department of Fish and Game AND Idaho Native Plant Society species designation
Width = 4
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: SA
Enumerated Domain Value Definition: Category A - Priority Species
Enumerated Domain Value: SP
Enumerated Domain Value Definition: Category B - Peripheral Species
Enumerated Domain Value: SU
Enumerated Domain Value Definition: Category C - Undetermined Species
Enumerated Domain Value: S1
Enumerated Domain Value Definition: State Priority 1
Enumerated Domain Value: S2
Enumerated Domain Value Definition: State priority 2
Enumerated Domain Value: SS
Enumerated Domain Value Definition: State sensitive
Enumerated Domain Value: SX
Enumerated Domain Value Definition: Historical/Extirpated
Attribute:
Attribute Label: LISTS
Attribute Definition:
Description - Listed by Natural Resources Defence Council or Tribes as species of concern
Width = 4
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: T
Enumerated Domain Value Definition: Tribe
Enumerated Domain Value: N
Enumerated Domain Value Definition: NRDC
Attribute:
Attribute Label: MDFW_P
Attribute Definition:
Description - Montana Department of Fish Wildlife and Parks AND Montana Natural Heritage
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: SE
Enumerated Domain Value Definition: State Endangered
Enumerated Domain Value: SP
Enumerated Domain Value Definition: State Protected
Enumerated Domain Value: SSC
Enumerated Domain Value Definition: Species of Special concern
Enumerated Domain Value: S
Enumerated Domain Value Definition: Follow-up needed
Attribute:
Attribute Label: MT_STATUS
Attribute Definition:
Description - Concatenation of state status and Federal Status for that species in Montana
Width = 10
Attribute type = C
Attribute:
Attribute Label: NDF_W
Attribute Definition:
Description - Nevada Department of Fish and Wildlife AND Nevada Division of Forestry species designation
Width = 3
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: SP
Enumerated Domain Value Definition: State Protected
Enumerated Domain Value: SS
Enumerated Domain Value Definition: State Sensitive (includes extra from heritage)
Enumerated Domain Value: ST
Enumerated Domain Value Definition: State Threatened
Enumerated Domain Value: SE
Enumerated Domain Value Definition: State Endangered
Enumerated Domain Value: SCE
Enumerated Domain Value Definition: State Critically Endangered
Enumerated Domain Value: SE#
Enumerated Domain Value Definition: Recommended for SE, pending formal listing
Enumerated Domain Value: SE
Enumerated Domain Value Definition: Endangered (NNNPS)
Enumerated Domain Value: ST
Enumerated Domain Value Definition: Threatened (NNNPS)
Attribute:
Attribute Label: NV_STATUS
Attribute Definition:
Description - Concatenation of state status and Federal Status for that species in Nevada
Width = 10
Attribute type = C
Attribute:
Attribute Label: ODF_W
Attribute Definition:
Description - Oregon Department of Fish and Wildlife AND Oregon Department of Agriculture species designation
Width = 2
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: SC
Enumerated Domain Value Definition: State Critical
Enumerated Domain Value: SV
Enumerated Domain Value Definition: State Vulnerable
Enumerated Domain Value: SP
Enumerated Domain Value Definition: State Peripheral/Rare
Enumerated Domain Value: SU
Enumerated Domain Value Definition: State Undetermined
Enumerated Domain Value: SE
Enumerated Domain Value Definition: State Endangered
Enumerated Domain Value: ST
Enumerated Domain Value Definition: State Threatened
Enumerated Domain Value: SC
Enumerated Domain Value Definition: State Candidate
Attribute:
Attribute Label: OR_STATUS
Attribute Definition:
Description - Concatenation of state status and Federal Status for that species in Oregon
Width = 10
Attribute type = C
Attribute:
Attribute Label: ORDER
Attribute Definition:
Description - Taxonomic Order
Width = 18
Attribute type = C
Attribute:
Attribute Label: SCIENTIFIC
Attribute Definition:
Description - Scientific name
Width = 47
Attribute type = C
Attribute:
Attribute Label: SPPCODE
Attribute Definition:
Description - 6 digit species code
Width = 6
Attribute type = C
Attribute:
Attribute Label: TAX
Attribute Definition:
Description - Number to put species in taxonomic order
Width = 3
Attribute type = N
Range = 1 - 96
Attribute:
Attribute Label: USFWS
Attribute Definition:
Description - U.S. Fish and Wildlife Service status designation
Width = 6
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: FE
Enumerated Domain Value Definition: Federally Endangered
Enumerated Domain Value: FT
Enumerated Domain Value Definition: Federally Threatened
Enumerated Domain Value: FPE
Enumerated Domain Value Definition: Federally Proposed Endangered
Enumerated Domain Value: FPT
Enumerated Domain Value Definition: Federally Proposed Threatened
Enumerated Domain Value: FC1
Enumerated Domain Value Definition: Federal Category 1 Candidate
Enumerated Domain Value: FC2
Enumerated Domain Value Definition: Federal Category 2 Candidate
Enumerated Domain Value: 3C
Enumerated Domain Value Definition: Federal Category 3 Candidate-NOT a complete list
Enumerated Domain Value: 3A
Enumerated Domain Value Definition: Undocumented value
Enumerated Domain Value: 3B
Enumerated Domain Value Definition: Undocumented value
Attribute:
Attribute Label: WA_STATUS
Attribute Definition:
Description - Concatenation of state status and Federal Status for that species in Washington
Width = 10
Attribute type = C
Attribute:
Attribute Label: WDF_W
Attribute Definition:
Description - Washington Department of Fish and Wildlife AND Washington Department of Natural Resources species designation
Width = 2
Attribute type = C
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: SE
Enumerated Domain Value Definition: State Endangered
Enumerated Domain Value: ST
Enumerated Domain Value Definition: State Threatened
Enumerated Domain Value: SS
Enumerated Domain Value Definition: State Sensitive
Enumerated Domain Value: SC
Enumerated Domain Value Definition: State Candidate
Enumerated Domain Value: SM
Enumerated Domain Value Definition: State monitor
Enumerated Domain Value: SX
Enumerated Domain Value Definition: State Extinct/Extirpated (TNC rank)
Attribute:
Attribute Label: WY_STATUS
Attribute Definition:
Description - Concatenation of state status and Federal Status for that species in Wyoming
Width = 10
Attribute type = C
Overview Description:
Entity and Attribute Overview:
The Species-Environment Relations (SER) database will extract into five directories: INVERTS, PLANTS, VERTS, CRBSTATS and QSPEC. INVERTS, PLANTS and VERTS contain the SER data for invertebrates, plants and vertebrates, respectively. Supplemental, non-environment, data is contained in the CRBSTATS and QSPEC directories.
Distribution Information
Section Index
Distributor:
Contact Information:
Contact Person Primary:
Contact Person: Becky Gravenmier
Contact Organization: Interior Columbia Basin Ecosystem Management Project
Contact Position: ICBEMP Spatial Team Lead
Contact Address:
Address Type: Mailing & Physical Address
Address: USDA Forest Service, Regional Office R6, 333 S.W. First Avenue, 4th Floor
City: Portland
State or Province: OR
Postal Code: 97204
Country: USA
Contact Voice Telephone: (503) 808-2851
Contact Facsimile Telephone: (503) 808-2622
Contact Electronic Mail Address: bgravenmier@fs.fed.us
Resource Description: BDBSER
Distribution Liability:
The ICBEMP cannot assure the reliability or suitability of this information for a particular purpose. Original data were compiled from various sources. Spatial information may not meet National Map Accuracy Standards. This information may be updated without notification.
Standard Order Process:
Digital Form:
Digital Transfer Information:
Format Name: EXE
Format Version Number: 7.0
Format Specification: Self-extracting zip files for the PC
File Decompression Technique: Double-click on the file to extract files from the self-extracting zip file.
Digital Transfer Option:
Online Option:
Online Computer and Operating System: Windows 3.1, Windows 95/98, Windows NT
Digital Form:
Digital Transfer Information:
Format Name: TAR
Format Specification: Compressed tar files on the Unix operating system.
File Decompression Technique: type: zcat <tarfilename>.tar.Z | tar xvf - to extract the contents of the archive.
Digital Transfer Option:
Online Option:
Online Computer and Operating System: Unix workstations
Fees: None for download from ICBEMP web site
Ordering Instructions: Download ICBEMP data from ICBEMP web site at www.icbemp.gov/spatial
Turnaround: Same day for download from ICBEMP web site
Custom Order Process:
If unable to download data directly from the ICBEMP web site (www.icbemp.gov/spatial), follow these instructions for the manual ICBEMP data request process.
Complete and mail the Data Request Form and the Available Data List to ICBEMP, Attn: Carole Smith, c/o USDA Forest Service, 333 S.W. First Ave, 4th Floor, Portland, OR 97204 (Internet: c3smith@or.blm.gov). These forms are available from the Project web site or can be requested via e-mail from bgravenmier@fs.fed.us. Please specify requested datasets by placing a checkmark in the space provided on the Available Data List.
Spatial data are released in Unix ARC/INFO export format. ARCVIEW files are made available when applicable. The digital data are provided on 8mm tape unless otherwise specified. Please specify special instructions for export format and tape density on the request form.
The Bureau of Land Management (BLM) Oregon State Office will telephone the requester to advise the cost of requested data. The requested data are mailed to the requester after payment has been received by the BLM.
Cost is based on a manual labor charge of $20.00 per hour (prorated), cost of the tape(s), and size of the map/plot(s). Digital data are provided on 8mm tape (cost $9.00) unless special instructions are specified on the request form. Federal offices are provided the information free of charge.
Technical Prerequisites:
Spatial data are released as both compressed Unix-based archive ARC(.TAR.Z) export files and PC-based executable (.EXE) files. Attribute files are released in dBASE IV (.DBF) format as Unix-based archive (.TAR.Z) files and PC-based (.EXE) files. Additionally, databases are released in both dBase IV and Paradox (.DB) format as .TAR.Z and .EXE files. All files within the archive .TAR.Z files and .EXE files follow the 8.3 naming convention to enable use on the Windows 3.1 operating system.
Available Time Period:
Metadata Reference Information
Section Index
Metadata Date: 7/2/2001
Metadata Review Date:
Metadata Future Review Date: 9/1/2001
Metadata Contact:
Contact Information:
Contact Person Primary:
Contact Person: Becky Gravenmier
Contact Organization: Interior Columbia Basin Ecosystem Management Project
Contact Position: ICBEMP Spatial Team Lead
Contact Address:
Address Type: Mailing & Physical Address
Address: USDA Forest Service, Regional Office R6, 333 S.W. First Avenue, 4th Floor
City: Portland
State or Province: OR
Postal Code: 97204
Country: USA
Contact Voice Telephone: (503) 808-2851
Contact Facsimile Telephone: (503) 808-2622
Contact Electronic Mail Address: bgravenmier@fs.fed.us
Metadata Standard Name: FGDC Content Standards for Digital Geospatial Metadata
Metadata Standard Version: June 1998
Metadata Time Convention: Local Time
SMMS Metadata report generated 8/9/2001