|
STS
Pre-Determined Site Information
Prior to the beginning
of the trapping season, pre-determined site data is entered into the database.
The sites are generated using a GIS, then a comma-delimited text file
is created in the GIS and loaded into the database using Oracle’s SQL*Loader
utility. The following are the items that are included in the text file
for each trap site:
| Column
Name |
Data
Type |
Values |
| QUAD |
VARCHAR2(8) |
USGS_CODE
(ex. 36079-B3) |
| SITE |
NUMBER(4) |
|
| AGENCY |
VARCHAR2(15) |
IDA (Illinois)
INDNR (Indiana)
UKY (Kentucky)
MDA (Michigan)
MNDA (Minnesota)
NCDACS (North Carolina)
ODA (Ohio)
APHIS (Virginia)
JNF_B (Blacksburg Ranger District)
JNF_MTR (Mt. Rogers Ranger District)
VDACS (Virginia)
WIDATCP
(Wisconsin)
WVDA (West Virginia)
WVDA-APHIS
|
| BLOCK_ID |
NUMBER(2) |
(Illinois
and Wisconsin only) |
| COUNTY |
NUMBER(3) |
FIPS
Code |
| STATE |
VARCHAR2(2) |
IL,
IN, KY, MI, MN, NC, OH, VA, WI, WV |
| UTM_EAST |
NUMBER(6) |
|
| UTM_NORTH |
NUMBER(7) |
|
| GRID |
VARCHAR2(12) |
250M,
500M, 1K, 1.5K, 2K, 3K, 5K, 8K, 4/MI, 5/MI, 9/MI 16/MI, 1X2MI, 1MI,
2MI, 3MI, 3/AC |
| TRAP_TYPE |
VARCHAR2(11) |
Delta,
Milk Carton |
| PROJECT |
VARCHAR2(10) |
MONITORING,
STATE, STS |
| BID_UNIT |
NUMBER(4) |
|
| UTM_ZONE |
NUMBER(2) |
|
Notes:
A unique ID value
is assigned by SQL*Loader as each record is loaded into the database.
This value is not included in the text file from the GIS.
|