Bibliographic Table
National Centers for Coastal Ocean Science
Entity
(ENT)
| ID: 40911
| Published / External
Created: 2017-04-06
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 38725
ID: 40911
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Bibliographic Table |
---|---|
Short Name | Bibliographic Table |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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. |
* Purpose | |
Notes |
Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script. |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description | |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | 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 | No | No | Title | Unknown | Title of report, article, or information source. | Description Source: Title as cited in original source. |
100 | No | No | 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 | No | No | Year | Unknown | Year of publication of report, article, or information source. | Description Source: Year of publication as cited in original source. |
100 | No | No | Organization | Unknown | Primary organization of lead author or sponsor. | Description Source: As reported in original source cited. |
100 | No | No | Type of Document | Unknown | journal article, technical report, management plan, etc. | Description Source: As reported in original source cited. |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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
Attribute Name | bibID |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Title |
---|---|
Seq. Order | 2 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Title of report, article, or information source. | Description Source: Title as cited in original source. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Title is recorded as in the original source, in free text format. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Author(s) |
---|---|
Seq. Order | 3 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Author(s) are recorded as text, as reported in the original source. They are presumed, but not guaranteed, to be accurate. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Year |
---|---|
Seq. Order | 4 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of publication of report, article, or information source. | Description Source: Year of publication as cited in original source. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Year is recorded as in the original source, in free text format. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Organization |
---|---|
Seq. Order | 5 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Primary organization of lead author or sponsor. | Description Source: As reported in original source cited. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Organization is recorded as reported in the original source, in free text format. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Type of Document |
---|---|
Seq. Order | 6 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
journal article, technical report, management plan, etc. | Description Source: As reported in original source cited. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Values are recorded as reported in the original source, in free text format. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Publication Info |
---|---|
Seq. Order | 7 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Values are recorded as reported in the original source, in free text format. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Web Location |
---|---|
Seq. Order | 8 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Values are recorded as reported in the original source, in free text format. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | State(s) |
---|---|
Seq. Order | 9 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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.) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Waterbodies |
---|---|
Seq. Order | 10 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Values are recorded as either a singular Waterbody number (UniqueID), or as a comma-delimited string to represent several waterbodies. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | Type of Information |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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. | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ACFHP Species |
---|---|
Seq. Order | 12 |
Data Storage Type | Unknown |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ACFHP Habitat Types |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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. | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2017-04-17 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-04-17 |
Tags |
---|