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.

   
  © 2012 Slow the Spread Foundation, Inc.  

Page developed and maintained by Virginia Tech

  Contact Us