Assessment Table
Entity (ENT) | National Centers for Coastal Ocean Science (NCCOS)GUID: gov.noaa.nmfs.inport:40912 | Updated: August 9, 2022 | Published / External
Data Attributes
Attribute Summary
|
|
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
| 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
| 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
| 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
| 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
| 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. |