40911
Bibliographic Table
Bibliographic Table
Entity
Published / External
38725
Assessment of Existing Information for Atlantic Coastal Fish Habitat Partnership (ACFHP)
Data Set
Completed
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.
Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.
1
bibID
VARCHAR
No
No
Active
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.
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.
2
Title
Unknown
No
No
Active
Title of report, article, or information source. | Description Source: Title as cited in original source.
Title is recorded as in the original source, in free text format.
3
Author(s)
Unknown
No
No
Active
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.
Author(s) are recorded as text, as reported in the original source. They are presumed, but not guaranteed, to be accurate.
4
Year
Unknown
No
No
Active
Year of publication of report, article, or information source. | Description Source: Year of publication as cited in original source.
Year is recorded as in the original source, in free text format.
5
Organization
Unknown
No
No
Active
Primary organization of lead author or sponsor. | Description Source: As reported in original source cited.
Organization is recorded as reported in the original source, in free text format.
6
Type of Document
Unknown
No
No
Active
journal article, technical report, management plan, etc. | Description Source: As reported in original source cited.
Values are recorded as reported in the original source, in free text format.
7
Publication Info
Unknown
No
No
Active
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.
Values are recorded as reported in the original source, in free text format.
8
Web Location
Unknown
No
No
Active
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.
Values are recorded as reported in the original source, in free text format.
9
State(s)
Unknown
No
No
Active
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.)
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
10
Waterbodies
Unknown
No
No
Active
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.
Values are recorded as either a singular Waterbody number (UniqueID), or as a comma-delimited string to represent several waterbodies.
11
Type of Information
VARCHAR
No
No
Active
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.
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. |
12
ACFHP Species
Unknown
No
No
Active
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.
Values are recorded as either a singular common species name, or as a comma-delimited string to represent several species, or left blank.
13
ACFHP Habitat Types
VARCHAR
No
No
Active
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.
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. |
gov.noaa.nmfs.inport:40911
Tyler Christensen
2017-04-06T10:31:25
SysAdmin InPortAdmin
2022-08-09T17:11:24
2017-04-17
National Centers for Coastal Ocean Science
NCCOS
1002
Public
No
2017-04-17
1 Year
2018-04-17