tblFieldStationHeader
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:23932 | Updated: August 9, 2022 | Published / External
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 |
