Table: COUNTY_CODE_TEXAS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6420 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionSEFSC.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
Name | Type | Description | ||
---|---|---|---|---|
100
|
NMFSSTATE | VARCHAR2 | NMFS State Code | |
100
|
NMFSCOUNTY | VARCHAR2 | NMFS County Code | |
100
|
COUNTYNAME | VARCHAR2 | County Name | |
100
|
TXCOUNTY | NUMBER | Converted Coastal Texas County Code | |
100
|
COUNTYSOLD | VARCHAR2 | Uncorrected Texas County Code |
Attribute Details
NMFSSTATE
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
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
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
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
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 |