Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

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

The Assessment Table provides information on habitat condition indicators, threats, and conservation actions. It is linked to both the Bibliographic and Geospatial Tables by the Waterbody Number (UniqueID) field. | Description Source: Fields within this entity (Assessment 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 Reference Number, identifying the source document that contributed the row of information within the assessment table. | Description Source: Links to bibID field in Bibliographic Table, joining the two tables. Enables the tracking of assessment information back to its original source.
100
Waterbody Number VARCHAR Recorded as a single unique number (UniqueID), as defined in the Geospatial Table. | Description Source: The Waterbody Number (UniqueID) identifies the place (waterbody or watershed) that the row of assessment information pertains to. It is defined in the Geospatial table, and joins the Assessment to the Geospatial Tables.
100
Indicator/Threat/Action VARCHAR Specifies whether the information contained with the Parameter field refers to an Indicator, Threat, or Action. Indicator - measure of habitat condition. Threat - to some measure of habitat condition. Action - conservation recommendation. | Description Source: Information comes directly from the source document cited, but designation of information as Indicator, Threat, or Action is determined by the Project Manager who built the data tables.
100
Parameter Unknown Refers to what is being measured or reported in a single row of information, e.g. "status of eelgrass", in text string format. | Description Source: Parameter is defined within the source document, and recorded in the Assessment Table, in abbreviated terminology if necessary. The parameter is described as indicator, threat, or action in the previous field.
100
Value Unknown Refers to what measurement is reported for a single row of information in the Assessment Table. | Description Source: Value is defined within the source document, and recorded in the Assessment Table, and represents some quantitative or qualitative description of a Parameter

Attribute Details

bibID

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

Reference Number, identifying the source document that contributed the row of information within the assessment table. | Description Source: Links to bibID field in Bibliographic Table, joining the two tables. Enables the tracking of assessment information back to its original source.

Allowed Values: bibID: bibID - unique ID number assigned to records within Bibliographic Table. Also entered in Assessment Table to identify sources and join the two tables. Single integers ranging from 1 to 527, range can be extended indefinitely if records are added to a new version of the Bibliographic Table.

Waterbody Number

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

Recorded as a single unique number (UniqueID), as defined in the Geospatial Table. | Description Source: The Waterbody Number (UniqueID) identifies the place (waterbody or watershed) that the row of assessment information pertains to. It is defined in the Geospatial table, and joins the Assessment to the Geospatial Tables.

Allowed Values: Waterbody Number (UniqueID): Values are recorded as a singular Waterbody Number(UniqueID), joined to the same field within the Geospatial Table. Each row of information in the Assessment Table refers to only one waterbody.

Indicator/Threat/Action

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

Specifies whether the information contained with the Parameter field refers to an Indicator, Threat, or Action. Indicator - measure of habitat condition. Threat - to some measure of habitat condition. Action - conservation recommendation. | Description Source: Information comes directly from the source document cited, but designation of information as Indicator, Threat, or Action is determined by the Project Manager who built the data tables.

Allowed Values: Indicator: Evaluation of habitat condition, or a measure of some parameter relevant to habitat condition. | Threat: Something that is identified as having a negative impact on habitat condition or quality, e.g. water pollution. | Action: A conservation action or recommendation that is intended to have a beneficial effect on habitat condition or quality, e.g. "reduce water pollution". |

Parameter

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

Refers to what is being measured or reported in a single row of information, e.g. "status of eelgrass", in text string format. | Description Source: Parameter is defined within the source document, and recorded in the Assessment Table, in abbreviated terminology if necessary. The parameter is described as indicator, threat, or action in the previous field.

Allowed Values: Parameter names are recorded as reported in the original source document, or abbreviated as needed.

Value

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

Refers to what measurement is reported for a single row of information in the Assessment Table. | Description Source: Value is defined within the source document, and recorded in the Assessment Table, and represents some quantitative or qualitative description of a Parameter

Allowed Values: Value measurements may be either numeric or textual, and are recorded as reported in the original source document, or abbreviated as needed.

Catalog Details

Catalog Item ID: 40912
GUID: gov.noaa.nmfs.inport:40912
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