Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: GLRI_UPDATED
Status: Completed
Publication Date: 2023-08
Abstract:

The GLRI_UPDATED table contains attribute information for the vector point data, GLRI_UNIQUE_SITES Points, representing GLRI Restoration sites. The key field, FEATURE_ID, links to the GLRI_UNIQUE_SITES dataset.

See the Entity_and_Attribute_Overview for a detailed description of how the primary attribute tables relate to the geographic data layers.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Alias: GLRI_UPDATED
Description:

The GLRI_UPDATED table contains attribute information for the vector point data, GLRI_UNIQUE_SITES Points, representing GLRI Restoration sites. The key field, FEATURE_ID, links to the GLRI_UNIQUE_SITES dataset.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FEATURE_ID LONG INTEGER Primary key that relates to the Feature ID in GLRI_UNIQUE_SITES as well as the ID on the abbreviated spreadsheet (found on page xvii of the Lake Ontario 2023 ESI atlas introductory pages)
100
UNIQUE ID TEXT Atlas-specific feature ID (Lake Ontario, LO%) created for each project at each point location
100
FUNDER TEXT Funding organization
100
YEAR_S_ TEXT Years funded. Discrete or representing a range.
100
PROJECT_TITLE_SHORT TEXT Abbreviated Project title
100
RECIPIENT_NAME TEXT Recipient of funding
100
FOCUS_AREAS TEXT Generalized project scope
100
AFFECTED_STATES TEXT States associated with project
100
LATITUDE DOUBLE Latitude of project location
100
LONGITUDE DOUBLE Longitude of project location

Attribute Details

FEATURE_ID

CC ID: 1265934
Seq. Order: 1
Data Storage Type: LONG INTEGER
Required: No
Primary Key: Yes
Status: Active
Description:

Primary key that relates to the Feature ID in GLRI_UNIQUE_SITES as well as the ID on the abbreviated spreadsheet (found on page xvii of the Lake Ontario 2023 ESI atlas introductory pages)

UNIQUE ID

CC ID: 1265941
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Atlas-specific feature ID (Lake Ontario, LO%) created for each project at each point location

FUNDER

CC ID: 1265936
Seq. Order: 3
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Funding organization

YEAR_S_

CC ID: 1265942
Seq. Order: 4
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Years funded. Discrete or representing a range.

PROJECT_TITLE_SHORT

CC ID: 1265939
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Abbreviated Project title

RECIPIENT_NAME

CC ID: 1265940
Seq. Order: 6
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Recipient of funding

FOCUS_AREAS

CC ID: 1265935
Seq. Order: 7
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Generalized project scope

AFFECTED_STATES

CC ID: 1265933
Seq. Order: 8
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

States associated with project

LATITUDE

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

Latitude of project location

LONGITUDE

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

Longitude of project location

Catalog Details

Catalog Item ID: 70510
GUID: gov.noaa.nmfs.inport:70510
Metadata Record Created By: Katy R Beckham
Metadata Record Created: 2023-08-15 15:05+0000
Metadata Record Last Modified By: Adam Rotert
Metadata Record Last Modified: 2023-09-26 15:20+0000
Metadata Record Published: 2023-09-26
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-11-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-11-18