6420
Table: COUNTY_CODE_TEXAS
COUNTY_CODE_TEXAS
Entity
Published / External
6419
Accumulative Landings System Code Tables
Data Set
Completed
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.
Loaded by batch 1924, 11-09-2007 10:56
Theme
County Codes
Theme
Cross Tables
Spatial
Texas
Data Table
Yes
SEFSC
SEFSC.COUNTY_CODE_TEXAS gives crosstable between TPWD County Codes and NMFS County Codes.
1
NMFSSTATE
VARCHAR2
2
No
No
Active
NMFS State Code
VARCHAR2
Must Be A Valid NMFS State
2
NMFSCOUNTY
VARCHAR2
2
No
No
Active
NMFS County Code
VARCHAR2
Nmfs State , County combination musr
3
COUNTYNAME
VARCHAR2
25
No
No
Active
County Name
VARCHAR2
4
TXCOUNTY
NUMBER
22
Yes
Yes
3
0
Active
Converted Coastal Texas County Code
NUMBER
Nmfsstate , nmfscounty combination must be a valid entry in sefsc.county_code_nmfs
5
COUNTYSOLD
VARCHAR2
25
No
No
Active
Uncorrected Texas County Code
VARCHAR2
gov.noaa.nmfs.inport:6420
Lee Weinberger
2007-11-09T10:56:00
SysAdmin InPortAdmin
2022-08-09T17:10:59
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06