Description of Fields in each Data Table


The following table lists and describes each of the fields contained within the data tables. Each field listed here represents a column in the data table; the first field in every data table serves as the table's primary key.

Data Table

Field

Description

Aggregation Class

Aggregation Class

Unique identifier for the aggregation class

 

Aggregation Class Abbr

Abbreviation for the aggregation class

 

Aggregation Class Name

Name of the aggregation class

 

Subcategory

Subcategory

 

Aggregation Class Comment

Comment for the aggregation class

Aggregation Member

Aggregation Member

Unique identifier for the aggregation member

 

Aggregation Class

Identifier for the aggregation class

 

Aggregation Member Abbr

Abbreviation for the aggregation member

 

Aggregation Member Name

Name of the aggregation member

 

Aggregation Member Comment

Comment for the aggregation member

Category

Category

Unique identifier for the category

 

Category Abbr

Abbreviation for the category

 

Category Name

Name of the category

Country

Country

Unique identifier for the country

 

CountryID

Unique numeric ID for the country

 

Country Abbr

Abbreviation for the country

 

Country Name

Name of the country

Feature

Feature

Unique identifier for the feature

 

FeatureID

Unique numeric ID for the feature

 

Location

Identifier for location associated with the feature

 

Theme Field

Identifier for the field in the ArcView theme table providing the lookup for the feature

 

Theme Field Value

Value for the theme field associated with the feature

Junction Aggregation Member Reading

Aggregation Member

Aggregation member linked to a reading

 

Reading

Reading linked to an aggregation member

Locality

Locality

Unique identifier for the locality

 

LocalityID

Unique numeric ID for the locality

 

Locality Abbr

Abbreviation for the locality

 

Locality Name

Name of the locality

 

Region

Region in which the locality is located

 

Locality Comment

Comment for the locality

Location

Location

Unique identifier for the location

 

Location Abbr

Abbreviation for the location

 

Location Name

Name of the location

 

Point?

Is this a point location?

 

Locality

Locality within which the location is situated

 

Location Comment

Comment for the location

Lookup

Lookup

Unique identifier of this lookup value

 

Variable

Variable with which this value is associated

 

Lookup Value

Value in enumerated lookup table for this variable

Measurement Set

Measurement Set

Unique identifier for the measurement set

 

Location

Location of the measurement set

 

Start Date and Time

Start date/time of the measurement set

 

End Date and Time

End date/time of the measurement set

 

Source

Source of the measurement set

 

Measurement Set Comment

Comment for the measurement set

Point

Point

Unique identifier for the point

 

PointID

Unique numeric ID for the point

 

Location

Location associated with the point

 

Point Latitude

Latitude of the point

 

Point Longitude

Longitude of the point

Reading

Reading

Unique identifier for the reading

 

Measurement Set

Measurement set associated with the reading

 

Variable

Variable associated with the reading

 

Below Detection Limit

Was the reading below a detection limit indicated in the value field?

 

Value Type

Type of value associated with the reading

 

Value

Value associated with the reading

 

Reading Comment

Comment for the reading

Region

Region

Unique identifier for the region

 

RegionID

Unique numeric ID for the region

 

Region Abbr

Abbreviation for the region

 

Region Name

Name of the region

 

Country

Country in which the region is located

 

Region Comment

Comment for the region

Source

Source

Unique identifier for the source

 

Source Metadata

Link to the location of the metadata for the source

 

Source Comment

Comment for the source

Subcategory

Subcategory

Unique identifier for the subcategory

 

Subcategory Abbr

Abbreviation for the subcategory

 

Subcategory Name

Name of the subcategory

 

Category

Category within which the subcategory is found

Theme

Theme

Unique identifier for the ArcView theme

 

ThemeID

Unique numeric ID for the theme

 

Theme Filename

Filename of the theme

 

Theme Type

Type of theme

 

Theme Comment

Comment for the theme

Theme Field

Theme Field

Unique identifier for the theme field

 

Theme

Identifier of ArcView theme associated with the theme field

 

Theme Field Name

Name of the ArcView theme table field associated with the theme field

 

Theme Field Type

Identifier of the ArcView data type for the theme field

 

Theme Field Comment

Comment for the theme field

Theme Field Type

Theme Field Type

Unique identifier of the data type for the theme field

 

Theme Field Type Abbr

Abbreviation for the theme field data type

 

Theme Field Type Name

Name of the theme field data type

Theme Type

Theme Type

Unique identifier of the theme type

 

Theme Type Abbr

Abbreviation for the theme type

 

Theme Type Name

Name of the theme type

Value Boolean

Value Boolean

Unique identifier for the value Boolean

 

Value

The Yes/No value recorded for the reading

Value Double

Value Double

Unique identifier for the value double

 

Value

The double precision real number value recorded for the reading

Value Long

Value Long

Unique identifier for the value long

 

Value

The long integer value recorded for the reading

Value Lookup

Value Lookup

Unique identifier for the value lookup

 

Value

Value of index entry in Lookup

Value Text

Value Text

Unique identifier for the value text

 

Value

The text value recorded for the reading

Value Theme

Value Theme

Unique identifier for the value theme

 

Theme Field

Identifier for the theme field containing the values

Value Type

Value Type

Unique identifier of the value type

 

Value Type Abbr

Abbreviation for the value type

 

Value Type Name

Name of the value type

Variable

Variable

Unique identifier for the variable

 

Variable Abbr

Abbreviation for the variable

 

Variable Name

Name of the variable

 

Subcategory

Subcategory within which the variable is found

 

Variable Type

Type of data value stored for this variable

 

Variable Units

Units for the variable

 

Sum?

Values for this variable can be summed across strata

 

Average?

Values for this variable can be averaged across strata

 

Variable Comment

Comment for the variable

Variable Type

Variable Type

Unique identifier of the variable type

 

Variable Type Abbr

Abbreviation for the variable type

 

Variable Type Name

Name of the variable type

 


Topics      Steps      System Manual Home      CPACC Home

Questions or problems regarding this web site should be directed to [email protected].
Last modified: July 13, 2001