Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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)
UNIQUE ID
TEXT
Atlas-specific feature ID (Lake Ontario, LO%) created for each project at each point location
FUNDER
TEXT
Funding organization
YEAR_S_
TEXT
Years funded. Discrete or representing a range.
PROJECT_TITLE_SHORT
TEXT
Abbreviated Project title
RECIPIENT_NAME
TEXT
Recipient of funding
FOCUS_AREAS
TEXT
Generalized project scope
AFFECTED_STATES
TEXT
States associated with project
LATITUDE
DOUBLE
Latitude of project location
LONGITUDE
DOUBLE
Longitude of project location

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (ORR) for inquiries on this record.

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