Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Northeast Salmon Team (NEST) > Penobscot Estuary (Maine) Monitoring >

tblSites

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34068  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Lookup table of fish survey sites

Description

Lookup table of fish survey sites

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SiteID
AutoNumber 		Unique autonumber of trip used for maintaining referetial integrity
SiteCode
Short Text 		SiteCode (location) of sampling, related to values in tblTripData and in MaineSalmon georeference library
SiteName
Short Text 		Common name used for site
UTMEast
Long Integer 		Easting Position of site in UTM (NAD 1983)
Lat
Short Text 		Latitiude position of site in UTM (NAD 1983)
UTMNorth
Double 		Northing Position of site in UTM (NAD 1983)
Long
Short Text 		Longitude position of site in UTM (NAD 1983)
Index
Short Text 		Binary field (Yes/No) determined whether site was repeatedly used during sampling (YES) or was exploratory (NO)
Stratification
Short Text 		Location of site in either of three strata (Upper, Middle, Lower) used for grouping analysis
EcoZone
Short Text 		Location of site in either of 10 strata (EZ1 through 10) used for grouping analysis
GearCode
Short Text 		Coded gear type, related to tblCodeGear

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: tblSites
Short Name: tblSites
Abstract:

Lookup table of fish survey sites

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Lookup table of fish survey sites

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 SiteID AutoNumber Unique autonumber of trip used for maintaining referetial integrity
100
 SiteCode Short Text SiteCode (location) of sampling, related to values in tblTripData and in MaineSalmon georeference library
100
 SiteName Short Text Common name used for site
100
 UTMEast Long Integer Easting Position of site in UTM (NAD 1983)
100
 Lat Short Text Latitiude position of site in UTM (NAD 1983)
100
 UTMNorth Double Northing Position of site in UTM (NAD 1983)
100
 Long Short Text Longitude position of site in UTM (NAD 1983)
100
 Index Short Text Binary field (Yes/No) determined whether site was repeatedly used during sampling (YES) or was exploratory (NO)
100
 Stratification Short Text Location of site in either of three strata (Upper, Middle, Lower) used for grouping analysis
100
 EcoZone Short Text Location of site in either of 10 strata (EZ1 through 10) used for grouping analysis
100
 GearCode Short Text Coded gear type, related to tblCodeGear

Attribute Details

SiteID

CC ID: 342543
Seq. Order: 1
Data Storage Type: AutoNumber
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique autonumber of trip used for maintaining referetial integrity
General Data Type: Number

SiteCode

CC ID: 342544
Seq. Order: 2
Data Storage Type: Short Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

SiteCode (location) of sampling, related to values in tblTripData and in MaineSalmon georeference library
General Data Type: Text

SiteName

CC ID: 342545
Seq. Order: 3
Data Storage Type: Short Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Common name used for site
General Data Type: Text

UTMEast

CC ID: 342546
Seq. Order: 4
Data Storage Type: Long Integer
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Easting Position of site in UTM (NAD 1983)
General Data Type: Number

Lat

CC ID: 826335
Seq. Order: 5
Data Storage Type: Short Text
Required: No
Primary Key: No
Status: Active
Description:

Latitiude position of site in UTM (NAD 1983)

UTMNorth

CC ID: 342547
Seq. Order: 6
Data Storage Type: Double
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Northing Position of site in UTM (NAD 1983)
General Data Type: Number

Long

CC ID: 826336
Seq. Order: 7
Data Storage Type: Short Text
Required: No
Primary Key: No
Status: Active
Description:

Longitude position of site in UTM (NAD 1983)

Index

CC ID: 342548
Seq. Order: 8
Data Storage Type: Short Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Binary field (Yes/No) determined whether site was repeatedly used during sampling (YES) or was exploratory (NO)
General Data Type: Text

Stratification

CC ID: 342549
Seq. Order: 9
Data Storage Type: Short Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Location of site in either of three strata (Upper, Middle, Lower) used for grouping analysis
General Data Type: Text

EcoZone

CC ID: 342550
Seq. Order: 10
Data Storage Type: Short Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Location of site in either of 10 strata (EZ1 through 10) used for grouping analysis
General Data Type: Text

GearCode

CC ID: 342551
Seq. Order: 11
Data Storage Type: Short Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Coded gear type, related to tblCodeGear
General Data Type: Text

Catalog Details

Catalog Item ID: 34068
GUID: gov.noaa.nmfs.inport:34068
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-03 14:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-08
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-08
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-08