Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Abstract

The Bibliographic Table provides information on over 500 selected documents and data sources on Atlantic coastal fish species and habitats. It is linked to the Assessment Table by the Waterbody Number (UniqueID) field, and to the Geospatial Table via a many-to-many relationship with the Waterbody Number (UniqueID) field. | Description Source: Fields within this entity (Bibliographic Table)are described as a series of attributes in the detailed description.

Entity Information

Data Attribute / Type Description
bibID
VARCHAR
Unique identification number for each record, single integer starting at 1. This is also used to link to information sources cited in the Assessment Table. | Description Source: Unique ID assigned to each record when table was originally developed in Microsoft Excel, before being imported to SQL Server.
Title
Unknown
Title of report, article, or information source. | Description Source: Title as cited in original source.
Author(s)
Unknown
Authors as reported in original source for each record within Bibliographic Table. | Description Source: Author(s) as reported in original source, using American Fisheries Society (AFS) journal format.
Year
Unknown
Year of publication of report, article, or information source. | Description Source: Year of publication as cited in original source.
Organization
Unknown
Primary organization of lead author or sponsor. | Description Source: As reported in original source cited.
Type of Document
Unknown
journal article, technical report, management plan, etc. | Description Source: As reported in original source cited.
Publication Info
Unknown
Standard bibliographic information - series name and volume number, publisher, etc. | Description Source: Standard bibliographic information, using American Fisheries Society (AFS) journal format, represented as a single text string.
Web Location
Unknown
Standard URL for accessing source document represented by this record within the Bibliographic Table. | Description Source: Standard URL is represented as a "Click Here" link within the web version of the ACFHP Assessment Database.
State(s)
Unknown
State(s) - locations covered by the document or information source cited, using standard abbreviation codes. | Description Source: Standard state abbreviation codes (e.g. ME, NH, MA, etc.)
Waterbodies
Unknown
Recorded as a unique number (UniqueID), as defined in the Geospatial Table. | Description Source: Each waterbody or watershed is represented by a unique number (UniqueID), as defined in the Geospatial table. This field links the Bibliographic and Geospatial Tables via a many-to-many relationship.
Type of Information
VARCHAR
Type of information included in document or data source. | Description Source: Entries in the bibliographic database were selected because they were relevant to Atlantic coastal fish habitat, and were classified as to the type of information that they contain - see Attribute Domain Values.
ACFHP Species
Unknown
Common name of a species is recorded if document pertains to them, left blank if the source is not species-specific. | Description Source: Text string may contain a single species name, or a series of comma-delimited species names, or be null.
ACFHP Habitat Types
VARCHAR
One or more habitat types, represtented as a singlular text entry, or a comma-delimited character string. | Description Source: One or more habitat types as identified in ACFHP documentation, plus additional classes to capture the water column and terrestrial watershed components of the ACFHP study area.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Bibliographic Table
Short Name: Bibliographic Table
Status: Completed
Abstract:

The Bibliographic Table provides information on over 500 selected documents and data sources on Atlantic coastal fish species and habitats. It is linked to the Assessment Table by the Waterbody Number (UniqueID) field, and to the Geospatial Table via a many-to-many relationship with the Waterbody Number (UniqueID) field. | Description Source: Fields within this entity (Bibliographic Table)are described as a series of attributes in the detailed description.

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
bibID VARCHAR Unique identification number for each record, single integer starting at 1. This is also used to link to information sources cited in the Assessment Table. | Description Source: Unique ID assigned to each record when table was originally developed in Microsoft Excel, before being imported to SQL Server.
100
Title Unknown Title of report, article, or information source. | Description Source: Title as cited in original source.
100
Author(s) Unknown Authors as reported in original source for each record within Bibliographic Table. | Description Source: Author(s) as reported in original source, using American Fisheries Society (AFS) journal format.
100
Year Unknown Year of publication of report, article, or information source. | Description Source: Year of publication as cited in original source.
100
Organization Unknown Primary organization of lead author or sponsor. | Description Source: As reported in original source cited.
100
Type of Document Unknown journal article, technical report, management plan, etc. | Description Source: As reported in original source cited.
100
Publication Info Unknown Standard bibliographic information - series name and volume number, publisher, etc. | Description Source: Standard bibliographic information, using American Fisheries Society (AFS) journal format, represented as a single text string.
100
Web Location Unknown Standard URL for accessing source document represented by this record within the Bibliographic Table. | Description Source: Standard URL is represented as a "Click Here" link within the web version of the ACFHP Assessment Database.
100
State(s) Unknown State(s) - locations covered by the document or information source cited, using standard abbreviation codes. | Description Source: Standard state abbreviation codes (e.g. ME, NH, MA, etc.)
100
Waterbodies Unknown Recorded as a unique number (UniqueID), as defined in the Geospatial Table. | Description Source: Each waterbody or watershed is represented by a unique number (UniqueID), as defined in the Geospatial table. This field links the Bibliographic and Geospatial Tables via a many-to-many relationship.
100
Type of Information VARCHAR Type of information included in document or data source. | Description Source: Entries in the bibliographic database were selected because they were relevant to Atlantic coastal fish habitat, and were classified as to the type of information that they contain - see Attribute Domain Values.
100
ACFHP Species Unknown Common name of a species is recorded if document pertains to them, left blank if the source is not species-specific. | Description Source: Text string may contain a single species name, or a series of comma-delimited species names, or be null.
100
ACFHP Habitat Types VARCHAR One or more habitat types, represtented as a singlular text entry, or a comma-delimited character string. | Description Source: One or more habitat types as identified in ACFHP documentation, plus additional classes to capture the water column and terrestrial watershed components of the ACFHP study area.

Attribute Details

bibID

CC ID: 527979
Seq. Order: 1
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Unique identification number for each record, single integer starting at 1. This is also used to link to information sources cited in the Assessment Table. | Description Source: Unique ID assigned to each record when table was originally developed in Microsoft Excel, before being imported to SQL Server.

Allowed Values: bibID: bibID - unique ID number assigned to record when table was developed in Microsoft Excel. Single integers ranging from 1 to 527, range can be extended indefinitely if records are added to a new version of the table.

Title

CC ID: 527980
Seq. Order: 2
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Title of report, article, or information source. | Description Source: Title as cited in original source.

Allowed Values: Title is recorded as in the original source, in free text format.

Author(s)

CC ID: 527981
Seq. Order: 3
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Authors as reported in original source for each record within Bibliographic Table. | Description Source: Author(s) as reported in original source, using American Fisheries Society (AFS) journal format.

Allowed Values: Author(s) are recorded as text, as reported in the original source. They are presumed, but not guaranteed, to be accurate.

Year

CC ID: 527982
Seq. Order: 4
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Year of publication of report, article, or information source. | Description Source: Year of publication as cited in original source.

Allowed Values: Year is recorded as in the original source, in free text format.

Organization

CC ID: 527983
Seq. Order: 5
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Primary organization of lead author or sponsor. | Description Source: As reported in original source cited.

Allowed Values: Organization is recorded as reported in the original source, in free text format.

Type of Document

CC ID: 527984
Seq. Order: 6
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

journal article, technical report, management plan, etc. | Description Source: As reported in original source cited.

Allowed Values: Values are recorded as reported in the original source, in free text format.

Publication Info

CC ID: 527985
Seq. Order: 7
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Standard bibliographic information - series name and volume number, publisher, etc. | Description Source: Standard bibliographic information, using American Fisheries Society (AFS) journal format, represented as a single text string.

Allowed Values: Values are recorded as reported in the original source, in free text format.

Web Location

CC ID: 527986
Seq. Order: 8
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Standard URL for accessing source document represented by this record within the Bibliographic Table. | Description Source: Standard URL is represented as a "Click Here" link within the web version of the ACFHP Assessment Database.

Allowed Values: Values are recorded as reported in the original source, in free text format.

State(s)

CC ID: 527987
Seq. Order: 9
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

State(s) - locations covered by the document or information source cited, using standard abbreviation codes. | Description Source: Standard state abbreviation codes (e.g. ME, NH, MA, etc.)

Allowed Values: Values are recorded as standard state abbreviation codes, with some exceptions: Federal marine waters are represented as US New Brunswick, Canada, is represented as NB

Waterbodies

CC ID: 527988
Seq. Order: 10
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Recorded as a unique number (UniqueID), as defined in the Geospatial Table. | Description Source: Each waterbody or watershed is represented by a unique number (UniqueID), as defined in the Geospatial table. This field links the Bibliographic and Geospatial Tables via a many-to-many relationship.

Allowed Values: Values are recorded as either a singular Waterbody number (UniqueID), or as a comma-delimited string to represent several waterbodies.

Type of Information

CC ID: 527989
Seq. Order: 11
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Type of information included in document or data source. | Description Source: Entries in the bibliographic database were selected because they were relevant to Atlantic coastal fish habitat, and were classified as to the type of information that they contain - see Attribute Domain Values.

Allowed Values: Habitat Assessment: Documents which specifically assess the quality or condition of specific habitat parameters, with information on indicators and threats. | Habitat Characterization: Descriptive studies of specific habitat types or parameters, or mapping of specific areas. | Habitat Data: Data portals or mapping services which provide necessary raw or processed data for further study. | Species Characterization: Field studies or stock assessments of fish or other species, not specifically linked to their habitats. | Species/Habitat Association: Life history or quantitative modeling studies which describe the association between species and their habitats or habitat parameters. | Conservation Plan: Documents which recommend actions to manage and conserve species and habitats. | Science Plan: Documents which recommend monitoring and research on species and habitats. | Reference: Useful reference information, not pertaining to a particular location. |

ACFHP Species

CC ID: 527990
Seq. Order: 12
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Common name of a species is recorded if document pertains to them, left blank if the source is not species-specific. | Description Source: Text string may contain a single species name, or a series of comma-delimited species names, or be null.

Allowed Values: Values are recorded as either a singular common species name, or as a comma-delimited string to represent several species, or left blank.

ACFHP Habitat Types

CC ID: 527991
Seq. Order: 13
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

One or more habitat types, represtented as a singlular text entry, or a comma-delimited character string. | Description Source: One or more habitat types as identified in ACFHP documentation, plus additional classes to capture the water column and terrestrial watershed components of the ACFHP study area.

Allowed Values: Shellfish Beds: Includes oyster and mussel beds, but not coral reef. | Other Sessile Fauna: Includes corals, deep corals, "worm reefs", Sabellaria beds. | Macroalgae: Includes rockweeds and kelp. | Submerged Aquatic Vegetation: SAV, includes seagrasses. | Tidal Vegetation: Wetlands. | Coastal Inert Substrate: Generally unconsolidated sediment. | Riverine: Fresh water upstream from head of tide. | Estuarine Waters: Water column within estuaries. | Marine Waters: Water column within estuaries. | Watersheds: Lands draining to rivers, estuaries, or ocean, represented as Estuarine Drainage Areas (EDAs) or Coastal Drainage Areas (CDAs) within the ACFHP Spatial Framework. |

Catalog Details

Catalog Item ID: 40911
GUID: gov.noaa.nmfs.inport:40911
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 10:31+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-04-17
Owner Org: NCCOS
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-04-17
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-04-17