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

Summary

Abstract

The NMFSCOUNTY codes for Texas Counties are limited to coastal counties. At some point in the past a decision was made to subjectively assign landings from inshore counties to the nearest adjacent coastal county. SEFSC.COUNTY_CODE_TEXAS provides crosstable between TPWD County Codes and coastal NMFS County Codes. It joins to the table ALS.ALS_LANDINGS.TXCOUNTY via the TXCOUNTY column so that the original county reported can be retrieved. It is likely that this table will be modified in the new data warehouse for ALS to include specific NMFS codes for all counties in East Texas.

Description

SEFSC.COUNTY_CODE_TEXAS gives crosstable between TPWD County Codes and NMFS County Codes.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NMFSSTATE
VARCHAR2
NMFS State Code
NMFSCOUNTY
VARCHAR2
NMFS County Code
COUNTYNAME
VARCHAR2
County Name
TXCOUNTY
NUMBER
Converted Coastal Texas County Code
COUNTYSOLD
VARCHAR2
Uncorrected Texas County Code

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

The NMFSCOUNTY codes for Texas Counties are limited to coastal counties. At some point in the past a decision was made to subjectively assign landings from inshore counties to the nearest adjacent coastal county. SEFSC.COUNTY_CODE_TEXAS provides crosstable between TPWD County Codes and coastal NMFS County Codes. It joins to the table ALS.ALS_LANDINGS.TXCOUNTY via the TXCOUNTY column so that the original county reported can be retrieved. It is likely that this table will be modified in the new data warehouse for ALS to include specific NMFS codes for all counties in East Texas.

Notes:

Loaded by batch 1924, 11-09-2007 10:56

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None County Codes
None Cross Tables

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Texas

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SEFSC
Description:

SEFSC.COUNTY_CODE_TEXAS gives crosstable between TPWD County Codes and NMFS County Codes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
NMFSSTATE VARCHAR2 NMFS State Code
100
NMFSCOUNTY VARCHAR2 NMFS County Code
100
COUNTYNAME VARCHAR2 County Name
100
Primary Key TXCOUNTY NUMBER Converted Coastal Texas County Code
100
COUNTYSOLD VARCHAR2 Uncorrected Texas County Code

Attribute Details

NMFSSTATE

CC ID: 21623
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

NMFS State Code

General Data Type: VARCHAR2
Foreign Key Relations:

Must Be A Valid NMFS State

NMFSCOUNTY

CC ID: 21624
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

NMFS County Code

General Data Type: VARCHAR2
Validation Rules:

Nmfs State , County combination musr

COUNTYNAME

CC ID: 21625
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

County Name

General Data Type: VARCHAR2

TXCOUNTY

CC ID: 21626
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 3
Scale: 0
Status: Active
Description:

Converted Coastal Texas County Code

General Data Type: NUMBER
Validation Rules:

Nmfsstate , nmfscounty combination must be a valid entry in sefsc.county_code_nmfs

COUNTYSOLD

CC ID: 21627
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Uncorrected Texas County Code

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6420
GUID: gov.noaa.nmfs.inport:6420
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-09 10:56+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06