tblFieldStationHeader
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:23932 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | tblFieldStationHeader |
---|---|
Short Name: | tblFieldStationHeader |
Status: | Completed |
Abstract: |
1.0 Ground Station Header - station-wide biophysical |
Notes: |
Loaded by FGDC Metadata Uploader, batch 5629, 03-16-2015 15:41 |
Entity Information
Description: |
1.0 Ground Station Header - station-wide biophysical |
---|
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
station_ID | Unknown | Unique identifier for database. | |
100
|
station | Unknown | Assigned Station Number | |
100
|
RegionalID | VARCHAR2 | Regional location, ie Kenai, Katmai, Cook Inlet, or Kodiak. This field uses a lookup table. | |
100
|
Bioarea | Unknown | -no description- | |
100
|
Sitelocation | Unknown | From Physical Sheet - Location of the station | |
100
|
LocaleGroup | Unknown | Letter corresponding to groups of stations in one 'locale' | |
100
|
LocaleGroupName | Unknown | Name of the locale group | |
100
|
LocaleConcat | Unknown | Concatenation of SuperLocale, Locale and SubLocale | |
100
|
StationName | Unknown | Regional Name ie Pender Bay, Rocky Point, ect... -- NEEDS TO BE COMPLETED | |
100
|
AerialStn | VARCHAR2 | For Jim. Indicates data collected opportunistically during an aerial survey refuel or other time on the ground during an aerial survey | |
100
|
KDKRegion | Unknown | Subregions within Kodiak | |
100
|
KDKClusterID | Unknown | Kodiak Relative Abundance (Jan 16, 2005) Cluster Analysis ID codes | |
100
|
date | Unknown | Bio Form - date of survey | |
100
|
BioStartTime | Unknown | Bio Form - start time of survey | |
100
|
BioTeam | Unknown | Bio Form - crew working at site | |
100
|
ExpBio | Unknown | Bio Form - Biological exposure VE, E, SE,SP, P, VP | |
100
|
ExpBioOriginal | Unknown | As recorded in field | |
100
|
ExpBioNotes | Unknown | Bio Form - Notes on the biological exposure ie Low E, High SE. Initials of estimator | |
100
|
HabClass | Unknown | Habitat Classification | |
100
|
HabClassOriginal | Unknown | As recorded in field | |
100
|
HabClassNotes | Unknown | Habitat class notes. Initials of estimator | |
100
|
FreshwaterInfluence | VARCHAR2 | Bio Form - YES/No | |
100
|
CurrentInfluence | VARCHAR2 | Bio Form - YES/No | |
100
|
SwellInfluence | VARCHAR2 | Bio Form - YES/No | |
100
|
SiteDescription | Unknown | Notes from SiteComments, ExpBioNotes, HabClassNotes and SiteFormMaterial combined and edited for Webposting | |
100
|
SiteComments | Unknown | Bio Form - General comments regarding the fieldstation | |
100
|
PhysicalProfileOnly | VARCHAR2 | Check box to indicate stations where only a physical profile was measured (i.e., no biobands or species recorded) | |
100
|
phyTeam | Unknown | Physical Form - Geomorphology team | |
100
|
Coords_LatDegDec | Unknown | For Jim. Concatenated latitude in degrees decimal degrees. Imported from GIS. | |
100
|
Coords_LongDegDec | Unknown | For Jim. Concatenated longitude in degrees decimal degrees. Imported from GIS. | |
100
|
latitude-degree | Unknown | Physical Form - Latitude in degrees | |
100
|
latdecdegree | Unknown | Physical Form - Latitude in decimal degrees | |
100
|
latmindecmin | Unknown | Physical Form - Latitude in minutes, decimal minutes | |
100
|
longitude-degree | Unknown | Physical Form - Longitude in degrees | |
100
|
longdecdegree | Unknown | Physical Form - Longitude in decimal degrees | |
100
|
longmindecmin | Unknown | Physical Form - Longitude in minutes, decimal minutes | |
100
|
SiteFormMaterial | Unknown | Physical Form - Form and Materials along the transect | |
100
|
TimeAtWaterline | Unknown | Physical Form - Time measurement was taken at the waterline. | |
100
|
TidalHeightAtWaterline | Unknown | Predicted tidal height at the waterline (in centimeters) from predictions at nearest tidal station | |
100
|
TideStation | Unknown | Tide station used to assign tidal heights to physical profile measured | |
100
|
TideProgram | Unknown | Program used to look up predicted tides | |
100
|
profile bearing | Unknown | Physical Form - Profile Bearing | |
100
|
CoastalClass | Unknown | Physical Form - Coastal Class taken from Physical Coastal Classification Table. | |
100
|
CoastalClassOriginal | Unknown | As recorded in field | |
100
|
CoastalClass Notes | Unknown | If any, from field description notes | |
100
|
max fetch km | Unknown | Physical - maximum fetch at the site | |
100
|
Fetch catergory | Unknown | Physical based on max fetch or estimations | |
100
|
Fetch Notes | Unknown | Is fetch from maps or field? Initials of estimator | |
100
|
DateCreated | Unknown | auto fill, created date | |
100
|
hasBioband | Unknown | for Jim -- to sort for web, to show if station has bioband attributes, 1 for yes, blank for no | |
100
|
hasSpecies | Unknown | for Jim -- to sort for web, to show if station has species attributes, 1 for yes, blank for no | |
100
|
hasProfile | Unknown | for Jim -- to sort for web, to show if station has profile attributes, 1 for yes, blank for no | |
100
|
hasPhotos | Unknown | for Jim -- to sort for web, to show if station has photos attributes, 1 for yes, blank for no | |
100
|
SurveyYear | Unknown | -no description- |
Attribute Details
station_ID
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier for database. |
Allowed Values: | No domain defined. |
station
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Assigned Station Number |
Allowed Values: | No domain defined. |
RegionalID
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Regional location, ie Kenai, Katmai, Cook Inlet, or Kodiak. This field uses a lookup table. |
Allowed Values: | AFOG, ALEUT, ANIA, BEAU, CHUK, CI, KAMI, KATM, KBAY, KDK, KOTZ, KP, PWS, SE |
Bioarea
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
-no description- |
Allowed Values: | Unable to resolve domain. |
Sitelocation
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
From Physical Sheet - Location of the station |
Allowed Values: | No domain defined. |
LocaleGroup
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Letter corresponding to groups of stations in one 'locale' |
Allowed Values: | No domain defined. |
LocaleGroupName
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the locale group |
Allowed Values: | No domain defined. |
LocaleConcat
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Concatenation of SuperLocale, Locale and SubLocale |
Allowed Values: | No domain defined. |
StationName
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Regional Name ie Pender Bay, Rocky Point, ect... -- NEEDS TO BE COMPLETED |
Allowed Values: | No domain defined. |
AerialStn
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
For Jim. Indicates data collected opportunistically during an aerial survey refuel or other time on the ground during an aerial survey |
Allowed Values: | False, True |
KDKRegion
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Subregions within Kodiak |
Allowed Values: | No domain defined. |
KDKClusterID
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Kodiak Relative Abundance (Jan 16, 2005) Cluster Analysis ID codes |
Allowed Values: | No domain defined. |
date
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - date of survey |
Allowed Values: | No domain defined. |
BioStartTime
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - start time of survey |
Allowed Values: | No domain defined. |
BioTeam
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - crew working at site |
Allowed Values: | No domain defined. |
ExpBio
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - Biological exposure VE, E, SE,SP, P, VP |
Allowed Values: | Field source not limited to list. |
ExpBioOriginal
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
As recorded in field |
Allowed Values: | No domain defined. |
ExpBioNotes
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - Notes on the biological exposure ie Low E, High SE. Initials of estimator |
Allowed Values: | No domain defined. |
HabClass
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat Classification |
Allowed Values: | Unable to resolve domain. |
HabClassOriginal
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
As recorded in field |
Allowed Values: | No domain defined. |
HabClassNotes
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Habitat class notes. Initials of estimator |
Allowed Values: | No domain defined. |
FreshwaterInfluence
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - YES/No |
Allowed Values: | False, True |
CurrentInfluence
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - YES/No |
Allowed Values: | False, True |
SwellInfluence
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - YES/No |
Allowed Values: | False, True |
SiteDescription
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Notes from SiteComments, ExpBioNotes, HabClassNotes and SiteFormMaterial combined and edited for Webposting |
Allowed Values: | No domain defined. |
SiteComments
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bio Form - General comments regarding the fieldstation |
Allowed Values: | Free entry text field. |
PhysicalProfileOnly
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Check box to indicate stations where only a physical profile was measured (i.e., no biobands or species recorded) |
Allowed Values: | False, True |
phyTeam
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Geomorphology team |
Allowed Values: | No domain defined. |
Coords_LatDegDec
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
For Jim. Concatenated latitude in degrees decimal degrees. Imported from GIS. |
Allowed Values: | No domain defined. |
Coords_LongDegDec
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
For Jim. Concatenated longitude in degrees decimal degrees. Imported from GIS. |
Allowed Values: | No domain defined. |
latitude-degree
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Latitude in degrees |
Allowed Values: | No domain defined. |
latdecdegree
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Latitude in decimal degrees |
Allowed Values: | No domain defined. |
latmindecmin
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Latitude in minutes, decimal minutes |
Allowed Values: | No domain defined. |
longitude-degree
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Longitude in degrees |
Allowed Values: | No domain defined. |
longdecdegree
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Longitude in decimal degrees |
Allowed Values: | No domain defined. |
longmindecmin
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Longitude in minutes, decimal minutes |
Allowed Values: | No domain defined. |
SiteFormMaterial
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Form and Materials along the transect |
Allowed Values: | Free entry text field. |
TimeAtWaterline
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Time measurement was taken at the waterline. |
Allowed Values: | No domain defined. |
TidalHeightAtWaterline
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Predicted tidal height at the waterline (in centimeters) from predictions at nearest tidal station |
Allowed Values: | No domain defined. |
TideStation
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tide station used to assign tidal heights to physical profile measured |
Allowed Values: | No domain defined. |
TideProgram
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Program used to look up predicted tides |
Allowed Values: | No domain defined. |
profile bearing
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Profile Bearing |
Allowed Values: | No domain defined. |
CoastalClass
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical Form - Coastal Class taken from Physical Coastal Classification Table. |
Allowed Values: | No domain defined. |
CoastalClassOriginal
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
As recorded in field |
Allowed Values: | No domain defined. |
CoastalClass Notes
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If any, from field description notes |
Allowed Values: | No domain defined. |
max fetch km
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical - maximum fetch at the site |
Allowed Values: | No domain defined. |
Fetch catergory
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Physical based on max fetch or estimations |
Allowed Values: | No domain defined. |
Fetch Notes
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Is fetch from maps or field? Initials of estimator |
Allowed Values: | No domain defined. |
DateCreated
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
auto fill, created date |
Allowed Values: | No domain defined. |
hasBioband
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
for Jim -- to sort for web, to show if station has bioband attributes, 1 for yes, blank for no |
Allowed Values: | No domain defined. |
hasSpecies
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
for Jim -- to sort for web, to show if station has species attributes, 1 for yes, blank for no |
Allowed Values: | No domain defined. |
hasProfile
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
for Jim -- to sort for web, to show if station has profile attributes, 1 for yes, blank for no |
Allowed Values: | No domain defined. |
hasPhotos
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
for Jim -- to sort for web, to show if station has photos attributes, 1 for yes, blank for no |
Allowed Values: | No domain defined. |
SurveyYear
Data Storage Type: | Unknown |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
-no description- |
Allowed Values: | No domain defined. |
Catalog Details
Catalog Item ID: | 23932 |
---|---|
GUID: | gov.noaa.nmfs.inport:23932 |
Metadata Record Created By: | Emily A Fergusson |
Metadata Record Created: | 2015-03-16 15:41+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-18 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-18 |