Table: MRLOCATIONS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34813 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Location information used to calculate latitude and longitude from a reported location
DescriptionLocation information used to calculate latitude and longitude from a reported location
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
LOCCD
VARCHAR2 |
Location code. |
LOC_DESC
VARCHAR2 |
Location description. |
FISHERY_STRING
VARCHAR2 |
Fisheries to which species is affiliated (comma separated list of fishery codes). |
ONLAND
VARCHAR2 |
on land (not used). |
NOS
VARCHAR2 |
North or south. |
EOW
VARCHAR2 |
East or west. |
MAPCORRECT
FLOAT |
Map correct. |
COUNTY
VARCHAR2 |
County. |
COAST
VARCHAR2 |
Coast. |
DOE
DATE |
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
UOE
VARCHAR2 |
The Oracle username of the individual who entered the new record. |
DOC
DATE |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
UOC
VARCHAR2 |
The Oracle username of the individual who changed the current record. |
LAT_DEG
VARCHAR2 |
Latitude degrees. (redacted) |
LAT_MIN
VARCHAR2 |
Latitude minutes. (redacted) |
LAT_SEC
VARCHAR2 |
Latitude seconds. (redacted) |
LON_DEG
VARCHAR2 |
Longitude degrees. (redacted) |
LON_MIN
VARCHAR2 |
Longitude minutes. (redacted) |
LON_SEC
VARCHAR2 |
Longitude seconds. (redacted) |
MRSEQUENCE
VARCHAR2 |
Sequencing for web application select list |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: MRLOCATIONS |
---|---|
Short Name: | MRLOCATIONS |
Status: | Completed |
Abstract: |
Location information used to calculate latitude and longitude from a reported location |
Notes: |
Loaded by batch 9271, 09-13-2016 10:43 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | MRDBS |
Description: |
Location information used to calculate latitude and longitude from a reported location |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
LOCCD | VARCHAR2 | Location code. | |
100
|
LOC_DESC | VARCHAR2 | Location description. | |
100
|
FISHERY_STRING | VARCHAR2 | Fisheries to which species is affiliated (comma separated list of fishery codes). | |
100
|
ONLAND | VARCHAR2 | on land (not used). | |
100
|
NOS | VARCHAR2 | North or south. | |
100
|
EOW | VARCHAR2 | East or west. | |
100
|
MAPCORRECT | FLOAT | Map correct. | |
100
|
COUNTY | VARCHAR2 | County. | |
100
|
COAST | VARCHAR2 | Coast. | |
100
|
DOE | DATE | Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). | |
100
|
UOE | VARCHAR2 | The Oracle username of the individual who entered the new record. | |
100
|
DOC | DATE | Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). | |
100
|
UOC | VARCHAR2 | The Oracle username of the individual who changed the current record. | |
100
|
LAT_DEG | VARCHAR2 | Latitude degrees. (redacted) | |
100
|
LAT_MIN | VARCHAR2 | Latitude minutes. (redacted) | |
100
|
LAT_SEC | VARCHAR2 | Latitude seconds. (redacted) | |
100
|
LON_DEG | VARCHAR2 | Longitude degrees. (redacted) | |
100
|
LON_MIN | VARCHAR2 | Longitude minutes. (redacted) | |
100
|
LON_SEC | VARCHAR2 | Longitude seconds. (redacted) | |
100
|
MRSEQUENCE | VARCHAR2 | Sequencing for web application select list |
Attribute Details
LOCCD
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Location code. |
General Data Type: | VARCHAR2 |
LOC_DESC
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 80 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Location description. |
General Data Type: | VARCHAR2 |
FISHERY_STRING
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fisheries to which species is affiliated (comma separated list of fishery codes). |
General Data Type: | VARCHAR2 |
ONLAND
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
on land (not used). |
General Data Type: | VARCHAR2 |
NOS
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
North or south. |
General Data Type: | VARCHAR2 |
EOW
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
East or west. |
General Data Type: | VARCHAR2 |
MAPCORRECT
Seq. Order: | 7 |
---|---|
Data Storage Type: | FLOAT |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 126 |
Status: | Active |
Description: |
Map correct. |
General Data Type: | FLOAT |
COUNTY
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
County. |
General Data Type: | VARCHAR2 |
COAST
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coast. |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 10 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
General Data Type: | DATE |
UOE
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle username of the individual who entered the new record. |
General Data Type: | VARCHAR2 |
DOC
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
General Data Type: | DATE |
UOC
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Oracle username of the individual who changed the current record. |
General Data Type: | VARCHAR2 |
LAT_DEG
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees. (redacted) |
General Data Type: | VARCHAR2 |
LAT_MIN
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude minutes. (redacted) |
General Data Type: | VARCHAR2 |
LAT_SEC
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude seconds. (redacted) |
General Data Type: | VARCHAR2 |
LON_DEG
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees. (redacted) |
General Data Type: | VARCHAR2 |
LON_MIN
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes. (redacted) |
General Data Type: | VARCHAR2 |
LON_SEC
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude seconds. (redacted) |
General Data Type: | VARCHAR2 |
MRSEQUENCE
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sequencing for web application select list |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 34813 |
---|---|
GUID: | gov.noaa.nmfs.inport:34813 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-09-13 10:43+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-09-13 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-09-13 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-09-13 |