-- Dump File -- -- Database is ported from MS Access ---------------------------------------------------------- -- Program Version 3.0.148 CREATE DATABASE "FIADB_version4"; -- NOTICE: At this place you need to connect to the new database and run the rest of the statements. -- -- Table structure for table 'BOUNDARY' -- DROP TABLE IF EXISTS "BOUNDARY"; CREATE TABLE "BOUNDARY" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER, "STATECD" INTEGER, "UNITCD" INTEGER, "COUNTYCD" INTEGER, "PLOT" INTEGER, "SUBP" INTEGER, "SUBPTYP" INTEGER, "BNDCHG" INTEGER DEFAULT 0, "CONTRAST" INTEGER, "AZMLEFT" INTEGER, "AZMCORN" INTEGER, "DISTCORN" INTEGER DEFAULT 0, "AZMRIGHT" INTEGER, "CYCLE" INTEGER, "SUBCYCLE" INTEGER, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(50), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(50) ); -- -- Table structure for table 'COND' -- DROP TABLE IF EXISTS "COND"; CREATE TABLE "COND" ( "CN" VARCHAR(34) NOT NULL, "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "COND_STATUS_CD" INTEGER DEFAULT 0, "COND_NONSAMPLE_REASN_CD" INTEGER DEFAULT 0, "RESERVCD" INTEGER DEFAULT 0, "OWNCD" INTEGER DEFAULT 0, "OWNGRPCD" INTEGER DEFAULT 0, "FORINDCD" INTEGER DEFAULT 0, "ADFORCD" INTEGER DEFAULT 0, "FORTYPCD" INTEGER DEFAULT 0, "FLDTYPCD" INTEGER DEFAULT 0, "MAPDEN" INTEGER DEFAULT 0, "STDAGE" INTEGER DEFAULT 0, "STDSZCD" INTEGER DEFAULT 0, "FLDSZCD" INTEGER DEFAULT 0, "SITECLCD" INTEGER DEFAULT 0, "SICOND" INTEGER DEFAULT 0, "SIBASE" INTEGER DEFAULT 0, "SISP" INTEGER DEFAULT 0, "STDORGCD" INTEGER DEFAULT 0, "STDORGSP" INTEGER, "PROP_BASIS" VARCHAR(12), "CONDPROP_UNADJ" FLOAT NULL DEFAULT 0, "MICRPROP_UNADJ" FLOAT NULL DEFAULT 0, "SUBPPROP_UNADJ" FLOAT NULL DEFAULT 0, "MACRPROP_UNADJ" FLOAT NULL DEFAULT 0, "SLOPE" INTEGER DEFAULT 0, "ASPECT" INTEGER DEFAULT 0, "PHYSCLCD" INTEGER DEFAULT 0, "GSSTKCD" INTEGER DEFAULT 0, "ALSTKCD" INTEGER DEFAULT 0, "DSTRBCD1" INTEGER DEFAULT 0, "DSTRBYR1" INTEGER DEFAULT 0, "DSTRBCD2" INTEGER DEFAULT 0, "DSTRBYR2" INTEGER DEFAULT 0, "DSTRBCD3" INTEGER DEFAULT 0, "DSTRBYR3" INTEGER DEFAULT 0, "TRTCD1" INTEGER DEFAULT 0, "TRTYR1" INTEGER DEFAULT 0, "TRTCD2" INTEGER DEFAULT 0, "TRTYR2" INTEGER DEFAULT 0, "TRTCD3" INTEGER DEFAULT 0, "TRTYR3" INTEGER DEFAULT 0, "PRESNFCD" INTEGER DEFAULT 0, "BALIVE" DOUBLE PRECISION DEFAULT 0, "FLDAGE" INTEGER DEFAULT 0, "ALSTK" FLOAT NULL DEFAULT 0, "GSSTK" FLOAT NULL DEFAULT 0, "FORTYPCDCALC" INTEGER DEFAULT 0, "HABTYPCD1" VARCHAR(10), "HABTYPCD1_PUB_CD" VARCHAR(10), "HABTYPCD1_DESCR_PUB_CD" VARCHAR(10), "HABTYPCD2" VARCHAR(10), "HABTYPCD2_PUB_CD" VARCHAR(10), "HABTYPCD2_DESCR_PUB_CD" VARCHAR(10), "MIXEDCONFCD" VARCHAR(1), "VOL_LOC_GRP" VARCHAR(200), "SITECLCDEST" INTEGER DEFAULT 0, "SITETREE_TREE" INTEGER DEFAULT 0, "SITECL_METHOD" INTEGER DEFAULT 0, "CARBON_DOWN_DEAD" DOUBLE PRECISION DEFAULT 0, "CARBON_LITTER" DOUBLE PRECISION DEFAULT 0, "CARBON_SOIL_ORG" DOUBLE PRECISION DEFAULT 0, "CARBON_STANDING_DEAD" DOUBLE PRECISION DEFAULT 0, "CARBON_UNDERSTORY_AG" DOUBLE PRECISION DEFAULT 0, "CARBON_UNDERSTORY_BG" DOUBLE PRECISION DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0, "SOIL_ROOTING_DEPTH_PNW" VARCHAR(1), "GROUND_LAND_CLASS_PNW" VARCHAR(3), "PLANT_STOCKABILITY_FACTOR_PNW" DOUBLE PRECISION, "STND_COND_CD_PNWRS" INTEGER DEFAULT 0, "STND_STRUC_CD_PNWRS" INTEGER DEFAULT 0, "STUMP_CD_PNWRS" VARCHAR(1), "FIRE_SRS" INTEGER DEFAULT 0, "GRAZING_SRS" INTEGER DEFAULT 0, "HARVEST_TYPE1_SRS" INTEGER DEFAULT 0, "HARVEST_TYPE2_SRS" INTEGER DEFAULT 0, "HARVEST_TYPE3_SRS" INTEGER DEFAULT 0, "LAND_USE_SRS" INTEGER DEFAULT 0, "OPERABILITY_SRS" INTEGER DEFAULT 0, "STAND_STRUCTURE_SRS" INTEGER DEFAULT 0, "NF_COND_STATUS_CD" INTEGER, "NF_COND_NONSAMPLE_REASN_CD" INTEGER, "CANOPY_CVR_SAMPLE_METHOD_CD" INTEGER, "LIVE_CANOPY_CVR_PCT" INTEGER, "LIVE_MISSING_CANOPY_CVR_PCT" INTEGER, "NBR_LIVE_STEMS" INTEGER, PRIMARY KEY ("CN") ); -- -- Table structure for table 'COUNTY' -- DROP TABLE IF EXISTS "COUNTY"; CREATE TABLE "COUNTY" ( "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "COUNTYNM" VARCHAR(50), "CN" VARCHAR(34), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'DWM_COARSE_WOODY_DEBRIS' -- DROP TABLE IF EXISTS "DWM_COARSE_WOODY_DEBRIS"; CREATE TABLE "DWM_COARSE_WOODY_DEBRIS" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "TRANSECT" INTEGER DEFAULT 0, "CWDID" DOUBLE PRECISION, "MEASYEAR" INTEGER DEFAULT 0, "SLOPDIST" DOUBLE PRECISION, "SPCD" INTEGER DEFAULT 0, "DECAYCD" INTEGER DEFAULT 0, "TRANSDIA" INTEGER DEFAULT 0, "SMALLDIA" INTEGER DEFAULT 0, "LARGEDIA" INTEGER DEFAULT 0, "LENGTH" INTEGER DEFAULT 0, "HOLLOWCD" VARCHAR(1), "CWDHSTCD" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'DWM_DUFF_LITTER_FUEL' -- DROP TABLE IF EXISTS "DWM_DUFF_LITTER_FUEL"; CREATE TABLE "DWM_DUFF_LITTER_FUEL" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "TRANSECT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "SMPLOCCD" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "SMPLDCD" INTEGER DEFAULT 0, "DUFFDEP" DOUBLE PRECISION, "LITTDEP" DOUBLE PRECISION, "FUELDEP" DOUBLE PRECISION, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'DWM_FINE_WOODY_DEBRIS' -- DROP TABLE IF EXISTS "DWM_FINE_WOODY_DEBRIS"; CREATE TABLE "DWM_FINE_WOODY_DEBRIS" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "TRANSECT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "SMALLCT" INTEGER DEFAULT 0, "MEDIUMCT" INTEGER DEFAULT 0, "LARGECT" INTEGER DEFAULT 0, "RSNCTCD" INTEGER DEFAULT 0, "PILESCD" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'DWM_MICROPLOT_FUEL' -- DROP TABLE IF EXISTS "DWM_MICROPLOT_FUEL"; CREATE TABLE "DWM_MICROPLOT_FUEL" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "LVSHRBCD" INTEGER DEFAULT 0, "DSHRBCD" INTEGER DEFAULT 0, "LVHRBCD" INTEGER DEFAULT 0, "DHRBCD" INTEGER DEFAULT 0, "LITTERCD" DOUBLE PRECISION, "LVSHRBHT" DOUBLE PRECISION, "DSHRBHT" DOUBLE PRECISION, "LVHRBHT" DOUBLE PRECISION, "DHRBHT" DOUBLE PRECISION, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'DWM_RESIDUAL_PILE' -- DROP TABLE IF EXISTS "DWM_RESIDUAL_PILE"; CREATE TABLE "DWM_RESIDUAL_PILE" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "PILE" DOUBLE PRECISION, "MEASYEAR" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "SHAPECD" INTEGER DEFAULT 0, "AZIMUTH" INTEGER DEFAULT 0, "DENSITY" INTEGER DEFAULT 0, "HEIGHT1" INTEGER DEFAULT 0, "WIDTH1" INTEGER DEFAULT 0, "LENGTH1" INTEGER DEFAULT 0, "HEIGHT2" INTEGER DEFAULT 0, "WIDTH2" INTEGER DEFAULT 0, "LENGTH2" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'DWM_TRANSECT_SEGMENT' -- DROP TABLE IF EXISTS "DWM_TRANSECT_SEGMENT"; CREATE TABLE "DWM_TRANSECT_SEGMENT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "TRANSECT" INTEGER DEFAULT 0, "SEGMNT" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "BEGNDIST" DOUBLE PRECISION, "ENDDIST" DOUBLE PRECISION, "SLOPE" INTEGER, "HORIZDIST" DOUBLE PRECISION, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'DWM_VISIT' -- DROP TABLE IF EXISTS "DWM_VISIT"; CREATE TABLE "DWM_VISIT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "MEASDAY" INTEGER DEFAULT 0, "MEASMON" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "QASTATCD" INTEGER DEFAULT 0, "CRWTYPCD" INTEGER DEFAULT 0, "SMPKNDCD" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'EVALIDATOR_CHANGES' -- DROP TABLE IF EXISTS "EVALIDATOR_CHANGES"; CREATE TABLE "EVALIDATOR_CHANGES" ( "ID" SERIAL NOT NULL, "CHANGE_DATE" TIMESTAMP, "CHANGE" TEXT, PRIMARY KEY ("ID") ); -- -- Table structure for table 'LICHEN_LAB' -- DROP TABLE IF EXISTS "LICHEN_LAB"; CREATE TABLE "LICHEN_LAB" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "LICH_SPPCD" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "ABUNDANCE_CLASS" INTEGER DEFAULT 0, "ORIGIN_FLAG" INTEGER DEFAULT 0, "SPP_COMMENTS" TEXT, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'LICHEN_PLOT_SUMMARY' -- DROP TABLE IF EXISTS "LICHEN_PLOT_SUMMARY"; CREATE TABLE "LICHEN_PLOT_SUMMARY" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "SUMMATION" DOUBLE PRECISION DEFAULT 0, "RICHNESS" INTEGER DEFAULT 0, "EVENNESS" FLOAT NULL DEFAULT 0, "DIVERSITY" FLOAT NULL DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'LICHEN_SPECIES_SUMMARY' -- DROP TABLE IF EXISTS "LICHEN_SPECIES_SUMMARY"; CREATE TABLE "LICHEN_SPECIES_SUMMARY" ( "CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "LICHEN_REGION" INTEGER DEFAULT 0, "LICH_SPPCD" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "LICHEN_REGION_DESCR" VARCHAR(80), "SPP_ACRONYM" VARCHAR(6), "GENUS" VARCHAR(40), "SUM_ABUNDANCE" FLOAT NULL DEFAULT 0, "FREQUENCY_PCT" INTEGER DEFAULT 0, "SPECIES" VARCHAR(50), "PLOTS_IN_REGION" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'LICHEN_VISIT' -- DROP TABLE IF EXISTS "LICHEN_VISIT"; CREATE TABLE "LICHEN_VISIT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "MEASDAY" INTEGER DEFAULT 0, "MEASMON" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "LICHEN_STATCD" INTEGER DEFAULT 0, "LIPROJCD" INTEGER DEFAULT 0, "SMPLSTRT" INTEGER DEFAULT 0, "SMPLSTP" INTEGER DEFAULT 0, "SMPLTIME" INTEGER DEFAULT 0, "SFTWDPCT" INTEGER DEFAULT 0, "HRDWDPCT" INTEGER DEFAULT 0, "SHRUBPCT" INTEGER DEFAULT 0, "GAPPCT" INTEGER DEFAULT 0, "GAPRCNT" INTEGER DEFAULT 0, "TALLSHRB" INTEGER DEFAULT 0, "FTRCD1" DOUBLE PRECISION, "FTRCD2" DOUBLE PRECISION, "FTRCD3" DOUBLE PRECISION, "FTRCD4" DOUBLE PRECISION, "ISSUECD1" DOUBLE PRECISION, "ISSUECD2" DOUBLE PRECISION, "ISSUECD3" DOUBLE PRECISION, "ISSUECD4" DOUBLE PRECISION, "SZCLSCD1" INTEGER DEFAULT 0, "SZCLSCD2" INTEGER DEFAULT 0, "SZCLSCD3" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'OZONE_BIOSITE_SUMMARY' -- DROP TABLE IF EXISTS "OZONE_BIOSITE_SUMMARY"; CREATE TABLE "OZONE_BIOSITE_SUMMARY" ( "CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "O3PLOT" DOUBLE PRECISION, "FIELD_ID" INTEGER DEFAULT 0, "LOCATION_CNT" DOUBLE PRECISION, "GROUND_LOC_CD" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "PLANT_INJ_CNT" DOUBLE PRECISION, "PLANT_EVAL_CNT" DOUBLE PRECISION, "PLANT_RATIO" DOUBLE PRECISION, "SPECIES_EVAL_CNT" DOUBLE PRECISION, "BIOSITE_INDEX" DOUBLE PRECISION, "BIOSITE_INDEX_MULTIPLIER" DOUBLE PRECISION, "SVRTY_CLASS_ZERO" DOUBLE PRECISION, "SVRTY_CLASS_ONE" DOUBLE PRECISION, "SVRTY_CLASS_TWO" DOUBLE PRECISION, "SVRTY_CLASS_THREE" DOUBLE PRECISION, "SVRTY_CLASS_FOUR" DOUBLE PRECISION, "SVRTY_CLASS_FIVE" DOUBLE PRECISION, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'OZONE_PLOT' -- DROP TABLE IF EXISTS "OZONE_PLOT"; CREATE TABLE "OZONE_PLOT" ( "CN" VARCHAR(34), "SRV_CN" VARCHAR(34), "CTY_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "O3PLOT" DOUBLE PRECISION, "FIELD_ID" INTEGER DEFAULT 0, "SPLIT_PLOTID" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "MEASMON" INTEGER DEFAULT 0, "MEASDAY" INTEGER DEFAULT 0, "LAT" DOUBLE PRECISION DEFAULT 0, "LON" DOUBLE PRECISION DEFAULT 0, "ELEVATION" DOUBLE PRECISION, "MANUAL" FLOAT NULL DEFAULT 0, "QA_STATUS" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0 ); -- -- Table structure for table 'OZONE_PLOT_SUMMARY' -- DROP TABLE IF EXISTS "OZONE_PLOT_SUMMARY"; CREATE TABLE "OZONE_PLOT_SUMMARY" ( "CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "O3PLOT" DOUBLE PRECISION, "FIELD_ID" INTEGER DEFAULT 0, "SPLIT_PLOTID" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "SPECIES_EVAL_CNT" DOUBLE PRECISION, "BIOSITE_INDEX" DOUBLE PRECISION, "ELEV" INTEGER DEFAULT 0, "PLTSIZE" DOUBLE PRECISION, "ASPECT" INTEGER DEFAULT 0, "TERRPOS" DOUBLE PRECISION, "SOILDPTH" DOUBLE PRECISION, "SOILDRN" DOUBLE PRECISION, "PLOTWET" DOUBLE PRECISION, "PLTDSTRB" DOUBLE PRECISION, "BIOSITE_INDEX_MULTIPLIER" DOUBLE PRECISION, "LAT" DOUBLE PRECISION DEFAULT 0, "LON" DOUBLE PRECISION DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'OZONE_SPECIES_SUMMARY' -- DROP TABLE IF EXISTS "OZONE_SPECIES_SUMMARY"; CREATE TABLE "OZONE_SPECIES_SUMMARY" ( "CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "O3PLOT" DOUBLE PRECISION, "FIELD_ID" INTEGER DEFAULT 0, "SPLIT_PLOTID" INTEGER DEFAULT 0, "GROUND_LOC_CD" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "BIOSPCD" DOUBLE PRECISION, "AMNT_MAX" DOUBLE PRECISION, "AMNT_MIN" DOUBLE PRECISION, "AMNT_MEAN" DOUBLE PRECISION, "SVRTY_MAX" DOUBLE PRECISION, "SVRTY_MIN" DOUBLE PRECISION, "SVRTY_MEAN" DOUBLE PRECISION, "PLANT_INJ_CNT" DOUBLE PRECISION, "PLANT_EVAL_CNT" DOUBLE PRECISION, "PLANT_RATIO" DOUBLE PRECISION, "BIOSPCD_SUM" DOUBLE PRECISION, "BIOSPCD_INDEX" DOUBLE PRECISION, "ELEV" INTEGER DEFAULT 0, "PLTSIZE" DOUBLE PRECISION, "ASPECT" INTEGER DEFAULT 0, "TERRPOS" DOUBLE PRECISION, "SOILDPTH" DOUBLE PRECISION, "SOILDRN" DOUBLE PRECISION, "PLOTWET" DOUBLE PRECISION, "PLTDSTRB" DOUBLE PRECISION, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'OZONE_VALIDATION' -- DROP TABLE IF EXISTS "OZONE_VALIDATION"; CREATE TABLE "OZONE_VALIDATION" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "O3PLOT" DOUBLE PRECISION, "FIELD_ID" INTEGER DEFAULT 0, "SPLIT_PLOTID" INTEGER DEFAULT 0, "BIOSPCD" DOUBLE PRECISION, "QASTATCD" INTEGER DEFAULT 0, "CRWTYPCD" INTEGER DEFAULT 0, "LEAFVCHR" DOUBLE PRECISION, "INJVALID" DOUBLE PRECISION, "O3_STATCD" DOUBLE PRECISION, "MEASYEAR" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'OZONE_VISIT' -- DROP TABLE IF EXISTS "OZONE_VISIT"; CREATE TABLE "OZONE_VISIT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "O3PLOT" DOUBLE PRECISION, "FIELD_ID" INTEGER DEFAULT 0, "SPLIT_PLOTID" INTEGER DEFAULT 0, "SMPKNDCD" INTEGER DEFAULT 0, "MEASDAY" INTEGER DEFAULT 0, "MEASMON" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "PLTSIZE" DOUBLE PRECISION, "ASPECT" INTEGER DEFAULT 0, "TERRPOS" DOUBLE PRECISION, "SOILDPTH" DOUBLE PRECISION, "SOILDRN" DOUBLE PRECISION, "PLTDSTRB" DOUBLE PRECISION, "CRWTYPCD" INTEGER DEFAULT 0, "PLOTWET" DOUBLE PRECISION, "INJCHECK" INTEGER DEFAULT 0, "GRIDDEN" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'PLOT' -- DROP TABLE IF EXISTS "PLOT"; CREATE TABLE "PLOT" ( "CN" VARCHAR(34) NOT NULL, "SRV_CN" VARCHAR(34), "CTY_CN" VARCHAR(34), "PREV_PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "PLOT_STATUS_CD" INTEGER DEFAULT 0, "PLOT_NONSAMPLE_REASN_CD" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "MEASMON" INTEGER DEFAULT 0, "MEASDAY" INTEGER DEFAULT 0, "REMPER" FLOAT NULL DEFAULT 0, "KINDCD" INTEGER DEFAULT 0, "DESIGNCD" INTEGER DEFAULT 0, "RDDISTCD" INTEGER DEFAULT 0, "WATERCD" INTEGER DEFAULT 0, "LAT" DOUBLE PRECISION DEFAULT 0, "LON" DOUBLE PRECISION DEFAULT 0, "ELEV" INTEGER DEFAULT 0, "GROW_TYP_CD" INTEGER DEFAULT 0, "MORT_TYP_CD" INTEGER DEFAULT 0, "P2PANEL" INTEGER DEFAULT 0, "P3PANEL" INTEGER DEFAULT 0, "ECOSUBCD" VARCHAR(7), "CONGCD" INTEGER DEFAULT 0, "MANUAL" FLOAT NULL DEFAULT 0, "SUBPANEL" INTEGER DEFAULT 0, "KINDCD_NC" INTEGER DEFAULT 0, "QA_STATUS" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "MICROPLOT_LOC" VARCHAR(12), "DECLINATION" FLOAT NULL DEFAULT 0, "EMAP_HEX" INTEGER DEFAULT 0, "SAMP_METHOD_CD" INTEGER DEFAULT 0, "SUBP_EXAMINE_CD" INTEGER DEFAULT 0, "MACRO_BREAKPOINT_DIA" INTEGER DEFAULT 0, "INTENSITY" VARCHAR(2), "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0, "ECO_UNIT_PNW" VARCHAR(10), "TOPO_POSITION_PNW" VARCHAR(2), "NF_SAMPLING_STATUS_CD" INTEGER, "NF_PLOT_STATUS_CD" INTEGER, "NF_PLOT_NONSAMPLE_REASN_CD" INTEGER, "P2VEG_SAMPLING_STATUS_CD" INTEGER, "P2VEG_SAMPLING_LEVEL_DETAIL_CD" INTEGER, "INVASIVE_SAMPLING_STATUS_CD" INTEGER, "INVASIVE_SPECIMEN_RULE_CD" INTEGER, UNIQUE ("STATECD", "INVYR", "UNITCD", "COUNTYCD", "PLOT"), PRIMARY KEY ("CN") ); -- -- Table structure for table 'PLOTGEOM' -- DROP TABLE IF EXISTS "PLOTGEOM"; CREATE TABLE "PLOTGEOM" ( "CN" VARCHAR(34), "STATECD" INTEGER, "INVYR" INTEGER, "UNITCD" INTEGER, "COUNTYCD" INTEGER, "PLOT" INTEGER, "LAT" DOUBLE PRECISION, "LON" DOUBLE PRECISION, "CONGCD" INTEGER, "ECOSUBCD" VARCHAR(7), "HUC" INTEGER, "EMAPHEX" INTEGER, "FIPSCOUNTY" INTEGER, "ROADLESSCD" VARCHAR(4), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" INTEGER DEFAULT 0, "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" INTEGER DEFAULT 0, "ADFORCD" INTEGER ); -- -- Table structure for table 'PLOTSNAP' -- DROP TABLE IF EXISTS "PLOTSNAP"; CREATE TABLE "PLOTSNAP" ( "CN" VARCHAR(34), "SRV_CN" VARCHAR(34), "CTY_CN" VARCHAR(34), "PREV_PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "PLOT_STATUS_CD" INTEGER DEFAULT 0, "PLOT_NONSAMPLE_REASN_CD" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "MEASMON" INTEGER DEFAULT 0, "MEASDAY" INTEGER DEFAULT 0, "REMPER" FLOAT NULL DEFAULT 0, "KINDCD" INTEGER DEFAULT 0, "DESIGNCD" INTEGER DEFAULT 0, "RDDISTCD" INTEGER DEFAULT 0, "WATERCD" INTEGER DEFAULT 0, "LAT" DOUBLE PRECISION DEFAULT 0, "LON" DOUBLE PRECISION DEFAULT 0, "ELEV" INTEGER DEFAULT 0, "GROW_TYP_CD" INTEGER DEFAULT 0, "MORT_TYP_CD" INTEGER DEFAULT 0, "P2PANEL" INTEGER DEFAULT 0, "P3PANEL" INTEGER DEFAULT 0, "ECOSUBCD" VARCHAR(7), "CONGCD" INTEGER DEFAULT 0, "MANUAL" FLOAT NULL DEFAULT 0, "SUBPANEL" INTEGER DEFAULT 0, "KINDCD_NC" INTEGER DEFAULT 0, "QA_STATUS" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "MICROPLOT_LOC" VARCHAR(12), "DECLINATION" FLOAT NULL DEFAULT 0, "EMAP_HEX" INTEGER DEFAULT 0, "SAMP_METHOD_CD" INTEGER DEFAULT 0, "SUBP_EXAMINE_CD" INTEGER DEFAULT 0, "MACRO_BREAKPOINT_DIA" INTEGER DEFAULT 0, "INTENSITY" VARCHAR(2), "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0, "ECO_UNIT_PNW" VARCHAR(10), "TOPO_POSITION_PNW" VARCHAR(2), "EVAL_GRP_CN" VARCHAR(34), "EVAL_GRP" INTEGER DEFAULT 0, "EXPALL" DOUBLE PRECISION, "EXPCURR" DOUBLE PRECISION, "EXPVOL" DOUBLE PRECISION, "EXPGROW" DOUBLE PRECISION, "EXPMORT" DOUBLE PRECISION, "EXPREMV" DOUBLE PRECISION, "ADJ_EXPALL" DOUBLE PRECISION DEFAULT 0, "ADJ_EXPCURR" DOUBLE PRECISION, "ADJ_EXPVOL_MACR" DOUBLE PRECISION, "ADJ_EXPVOL_SUBP" DOUBLE PRECISION, "ADJ_EXPVOL_MICR" DOUBLE PRECISION, "ADJ_EXPGROW_MACR" DOUBLE PRECISION, "ADJ_EXPGROW_SUBP" DOUBLE PRECISION, "ADJ_EXPGROW_MICR" DOUBLE PRECISION, "ADJ_EXPMORT_MACR" DOUBLE PRECISION, "ADJ_EXPMORT_SUBP" DOUBLE PRECISION, "ADJ_EXPMORT_MICR" DOUBLE PRECISION, "ADJ_EXPREMV_MACR" DOUBLE PRECISION, "ADJ_EXPREMV_SUBP" DOUBLE PRECISION, "ADJ_EXPREMV_MICR" DOUBLE PRECISION ); -- -- Table structure for table 'POP_ESTN_UNIT' -- DROP TABLE IF EXISTS "POP_ESTN_UNIT"; CREATE TABLE "POP_ESTN_UNIT" ( "CN" VARCHAR(34) NOT NULL, "EVAL_CN" VARCHAR(34), "RSCD" INTEGER DEFAULT 0, "EVALID" INTEGER DEFAULT 0, "ESTN_UNIT" INTEGER DEFAULT 0, "ESTN_UNIT_DESCR" VARCHAR(255), "STATECD" INTEGER DEFAULT 0, "AREALAND_EU" DOUBLE PRECISION DEFAULT 0, "AREATOT_EU" DOUBLE PRECISION DEFAULT 0, "AREA_USED" DOUBLE PRECISION DEFAULT 0, "AREA_SOURCE" VARCHAR(50), "P1PNTCNT_EU" DOUBLE PRECISION DEFAULT 0, "P1SOURCE" VARCHAR(30), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), PRIMARY KEY ("CN") ); -- -- Table structure for table 'POP_EVAL' -- DROP TABLE IF EXISTS "POP_EVAL"; CREATE TABLE "POP_EVAL" ( "CN" VARCHAR(34) NOT NULL, "RSCD" INTEGER DEFAULT 0, "EVALID" INTEGER DEFAULT 0, "EVAL_DESCR" VARCHAR(255), "STATECD" INTEGER DEFAULT 0, "LOCATION_NM" VARCHAR(255), "REPORT_YEAR_NM" VARCHAR(255), "NOTES" TEXT, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "START_INVYR" INTEGER DEFAULT 0, "END_INVYR" INTEGER DEFAULT 0, PRIMARY KEY ("CN") ); -- -- Table structure for table 'POP_EVAL_ATTRIBUTE' -- DROP TABLE IF EXISTS "POP_EVAL_ATTRIBUTE"; CREATE TABLE "POP_EVAL_ATTRIBUTE" ( "CN" VARCHAR(34), "EVAL_CN" VARCHAR(34), "ATTRIBUTE_NBR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'POP_EVAL_GRP' -- DROP TABLE IF EXISTS "POP_EVAL_GRP"; CREATE TABLE "POP_EVAL_GRP" ( "CN" VARCHAR(34) NOT NULL, "EVAL_CN_FOR_EXPALL" VARCHAR(34), "EVAL_CN_FOR_EXPCURR" VARCHAR(34), "EVAL_CN_FOR_EXPVOL" VARCHAR(34), "EVAL_CN_FOR_EXPGROW" VARCHAR(34), "EVAL_CN_FOR_EXPMORT" VARCHAR(34), "EVAL_CN_FOR_EXPREMV" VARCHAR(34), "RSCD" INTEGER DEFAULT 0, "EVAL_GRP" INTEGER DEFAULT 0, "EVAL_GRP_DESCR" VARCHAR(255), "STATECD" INTEGER DEFAULT 0, "LAND_ONLY" VARCHAR(1), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "NOTES" TEXT, PRIMARY KEY ("CN") ); -- -- Table structure for table 'POP_EVAL_TYP' -- DROP TABLE IF EXISTS "POP_EVAL_TYP"; CREATE TABLE "POP_EVAL_TYP" ( "CN" VARCHAR(34) NOT NULL, "EVAL_GRP_CN" VARCHAR(34), "EVAL_CN" VARCHAR(34), "EVAL_TYP" VARCHAR(15), "STATECD" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), PRIMARY KEY ("CN") ); -- -- Table structure for table 'POP_PLOT_STRATUM_ASSGN' -- DROP TABLE IF EXISTS "POP_PLOT_STRATUM_ASSGN"; CREATE TABLE "POP_PLOT_STRATUM_ASSGN" ( "CN" VARCHAR(34) NOT NULL, "STRATUM_CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "STATECD" INTEGER DEFAULT 0, "INVYR" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "RSCD" INTEGER DEFAULT 0, "EVALID" INTEGER DEFAULT 0, "ESTN_UNIT" INTEGER DEFAULT 0, "STRATUMCD" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), PRIMARY KEY ("CN") ); -- -- Table structure for table 'POP_STRATUM' -- DROP TABLE IF EXISTS "POP_STRATUM"; CREATE TABLE "POP_STRATUM" ( "CN" VARCHAR(34) NOT NULL, "ESTN_UNIT_CN" VARCHAR(34), "RSCD" INTEGER DEFAULT 0, "EVALID" INTEGER DEFAULT 0, "ESTN_UNIT" INTEGER DEFAULT 0, "STRATUMCD" INTEGER DEFAULT 0, "STRATUM_DESCR" VARCHAR(255), "STATECD" INTEGER DEFAULT 0, "P1POINTCNT" DOUBLE PRECISION DEFAULT 0, "P2POINTCNT" DOUBLE PRECISION DEFAULT 0, "EXPNS" DOUBLE PRECISION DEFAULT 0, "ADJ_FACTOR_MACR" FLOAT NULL DEFAULT 0, "ADJ_FACTOR_SUBP" FLOAT NULL DEFAULT 0, "ADJ_FACTOR_MICR" FLOAT NULL DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), PRIMARY KEY ("CN") ); -- -- Table structure for table 'ref_attribute_access' -- DROP TABLE IF EXISTS "ref_attribute_access"; CREATE TABLE "ref_attribute_access" ( "ATTRIBUTE_NBR" INTEGER DEFAULT 0, "ATTRIBUTE_DESCR" VARCHAR(255), "VBA_SUMFROMWHERE" TEXT, "PEA_SURROGATE" INTEGER DEFAULT 0, "CONDTREESEED" VARCHAR(50) ); -- -- Table structure for table 'REF_CITATION' -- DROP TABLE IF EXISTS "REF_CITATION"; CREATE TABLE "REF_CITATION" ( "CITATION_NBR" INTEGER DEFAULT 0, "CITATION" TEXT, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_FIADB_VERSION' -- DROP TABLE IF EXISTS "REF_FIADB_VERSION"; CREATE TABLE "REF_FIADB_VERSION" ( "VERSION" VARCHAR(40), "DESCR" TEXT, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "INSTALL_TYPE" VARCHAR(10) ); -- -- Table structure for table 'REF_FOREST_TYPE' -- DROP TABLE IF EXISTS "REF_FOREST_TYPE"; CREATE TABLE "REF_FOREST_TYPE" ( "VALUE" INTEGER DEFAULT 0, "MEANING" VARCHAR(80), "TYPGRPCD" INTEGER DEFAULT 0, "MANUAL_START" FLOAT NULL DEFAULT 0, "MANUAL_END" FLOAT NULL DEFAULT 0, "ALLOWED_IN_FIELD" VARCHAR(1), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_HABTYP_DESCRIPTION' -- DROP TABLE IF EXISTS "REF_HABTYP_DESCRIPTION"; CREATE TABLE "REF_HABTYP_DESCRIPTION" ( "CN" VARCHAR(34), "HABTYPCD" VARCHAR(10), "PUB_CD" VARCHAR(10), "SCIENTIFIC_NAME" VARCHAR(115), "COMMON_NAME" VARCHAR(255), "VALID" VARCHAR(1), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_HABTYP_PUBLICATION' -- DROP TABLE IF EXISTS "REF_HABTYP_PUBLICATION"; CREATE TABLE "REF_HABTYP_PUBLICATION" ( "CN" VARCHAR(34), "PUB_CD" VARCHAR(10), "TITLE" VARCHAR(200), "AUTHOR" VARCHAR(200), "TYPE" VARCHAR(10), "VALID" VARCHAR(1), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_LICHEN_SPECIES' -- DROP TABLE IF EXISTS "REF_LICHEN_SPECIES"; CREATE TABLE "REF_LICHEN_SPECIES" ( "LICH_SPPCD" INTEGER DEFAULT 0, "YEARSTART" INTEGER DEFAULT 0, "YEAREND" INTEGER DEFAULT 0, "SPP_ACRONYM" VARCHAR(6), "GENUS" VARCHAR(40), "SPECIES" VARCHAR(50), "CN" VARCHAR(34), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_LICHEN_SPP_COMMENTS' -- DROP TABLE IF EXISTS "REF_LICHEN_SPP_COMMENTS"; CREATE TABLE "REF_LICHEN_SPP_COMMENTS" ( "LICH_SPPCD" INTEGER DEFAULT 0, "SPP_NAME" VARCHAR(80), "YEAREND" INTEGER DEFAULT 0, "YEARSTART" INTEGER DEFAULT 0, "SPP_COMMENTS" TEXT, "CN" VARCHAR(34), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_PLANT_DICTIONARY' -- DROP TABLE IF EXISTS "REF_PLANT_DICTIONARY"; CREATE TABLE "REF_PLANT_DICTIONARY" ( "CN" VARCHAR(34), "SYMBOL_TYPE" VARCHAR(20), "SYMBOL" VARCHAR(16), "SCIENTIFIC_NAME" VARCHAR(100), "NEW_SYMBOL" VARCHAR(16), "NEW_SCIENTIFIC_NAME" VARCHAR(100), "COMMON_NAME" VARCHAR(100), "CATEGORY" VARCHAR(15), "FAMILY" VARCHAR(25), "GROWTH_HABIT" VARCHAR(50), "DURATION" VARCHAR(50), "US_NATIVITY" VARCHAR(50), "STATE_DISTRIBUTION" TEXT, "XGENUS" VARCHAR(1), "GENUS" VARCHAR(20), "XSPECIES" VARCHAR(1), "SPECIES" VARCHAR(50), "SSP" VARCHAR(4), "SUBSPECIES" VARCHAR(30), "VAR" VARCHAR(4), "VARIETY" VARCHAR(30), "MANUAL_START" FLOAT NULL DEFAULT 0, "MANUAL_END" FLOAT NULL DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_POP_ATTRIBUTE' -- DROP TABLE IF EXISTS "REF_POP_ATTRIBUTE"; CREATE TABLE "REF_POP_ATTRIBUTE" ( "CN" VARCHAR(34), "ATTRIBUTE_NBR" INTEGER DEFAULT 0, "ATTRIBUTE_DESCR" VARCHAR(255), "EXPRESSION" TEXT, "WHERE_CLAUSE" VARCHAR(255), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "FOOTNOTE" TEXT ); -- -- Table structure for table 'REF_POP_EVAL_TYP_DESCR' -- DROP TABLE IF EXISTS "REF_POP_EVAL_TYP_DESCR"; CREATE TABLE "REF_POP_EVAL_TYP_DESCR" ( "CN" VARCHAR(34), "EVAL_TYP" VARCHAR(15), "EVAL_TYP_DESCR" VARCHAR(255), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_PRC' -- DROP TABLE IF EXISTS "REF_PRC"; CREATE TABLE "REF_PRC" ( "CLASSNBR" INTEGER DEFAULT 0, "CONDTREESEED" VARCHAR(50), "CLASSNM" VARCHAR(50), "FUNCTIONNM" VARCHAR(255), "PAGECLASS" VARCHAR(50), "ROWCLASS" VARCHAR(50), "COLCLASS" VARCHAR(50), UNIQUE ("CLASSNBR") ); -- -- Table structure for table 'REF_RSCDEVALID' -- DROP TABLE IF EXISTS "REF_RSCDEVALID"; CREATE TABLE "REF_RSCDEVALID" ( "rscdEvalid" INTEGER, "rscdEvalidLabel" VARCHAR(255) ); -- -- Table structure for table 'REF_SPECIES' -- DROP TABLE IF EXISTS "REF_SPECIES"; CREATE TABLE "REF_SPECIES" ( "SPCD" INTEGER, "COMMON_NAME" VARCHAR(100), "GENUS" VARCHAR(40), "SPECIES" VARCHAR(50), "VARIETY" VARCHAR(50), "SUBSPECIES" VARCHAR(50), "SPECIES_SYMBOL" VARCHAR(8), "E_SPGRPCD" INTEGER DEFAULT 0, "W_SPGRPCD" INTEGER DEFAULT 0, "MAJOR_SPGRPCD" INTEGER DEFAULT 0, "STOCKING_SPGRPCD" INTEGER DEFAULT 0, "FOREST_TYPE_SPGRPCD" INTEGER DEFAULT 0, "EXISTS_IN_NCRS" VARCHAR(1), "EXISTS_IN_NERS" VARCHAR(1), "EXISTS_IN_PNWRS" VARCHAR(1), "EXISTS_IN_RMRS" VARCHAR(1), "EXISTS_IN_SRS" VARCHAR(1), "SITETREE" VARCHAR(1), "SFTWD_HRDWD" VARCHAR(1), "ST_EXISTS_IN_NCRS" VARCHAR(1), "ST_EXISTS_IN_NERS" VARCHAR(1), "ST_EXISTS_IN_PNWRS" VARCHAR(1), "ST_EXISTS_IN_RMRS" VARCHAR(1), "ST_EXISTS_IN_SRS" VARCHAR(1), "EAST" VARCHAR(1), "WEST" VARCHAR(1), "WOODLAND" VARCHAR(1), "MANUAL_START" FLOAT NULL DEFAULT 0, "MANUAL_END" FLOAT NULL DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "CORE" VARCHAR(1), "JENKINS_SPGRPCD" INTEGER DEFAULT 0, "JENKINS_TOTAL_B1" DOUBLE PRECISION DEFAULT 0, "JENKINS_TOTAL_B2" DOUBLE PRECISION DEFAULT 0, "JENKINS_STEM_WOOD_RATIO_B1" DOUBLE PRECISION DEFAULT 0, "JENKINS_STEM_WOOD_RATIO_B2" DOUBLE PRECISION DEFAULT 0, "JENKINS_STEM_BARK_RATIO_B1" DOUBLE PRECISION DEFAULT 0, "JENKINS_STEM_BARK_RATIO_B2" DOUBLE PRECISION DEFAULT 0, "JENKINS_FOLIAGE_RATIO_B1" DOUBLE PRECISION DEFAULT 0, "JENKINS_FOLIAGE_RATIO_B2" DOUBLE PRECISION DEFAULT 0, "JENKINS_ROOT_RATIO_B1" DOUBLE PRECISION DEFAULT 0, "JENKINS_ROOT_RATIO_B2" DOUBLE PRECISION DEFAULT 0, "JENKINS_SAPLING_ADJUSTMENT" DOUBLE PRECISION DEFAULT 0, "WOOD_SPGR_GREENVOL_DRYWT" DOUBLE PRECISION DEFAULT 0, "WOOD_SPGR_GREENVOL_DRYWT_CIT" INTEGER DEFAULT 0, "BARK_SPGR_GREENVOL_DRYWT" DOUBLE PRECISION DEFAULT 0, "BARK_SPGR_GREENVOL_DRYWT_CIT" INTEGER DEFAULT 0, "MC_PCT_GREEN_WOOD" DOUBLE PRECISION DEFAULT 0, "MC_PCT_GREEN_WOOD_CIT" INTEGER DEFAULT 0, "MC_PCT_GREEN_BARK" DOUBLE PRECISION DEFAULT 0, "MC_PCT_GREEN_BARK_CIT" INTEGER DEFAULT 0, "WOOD_SPGR_MC12VOL_DRYWT" DOUBLE PRECISION DEFAULT 0, "WOOD_SPGR_MC12VOL_DRYWT_CIT" INTEGER DEFAULT 0, "BARK_VOL_PCT" DOUBLE PRECISION DEFAULT 0, "BARK_VOL_PCT_CIT" INTEGER DEFAULT 0, "RAILE_STUMP_DOB_B1" DOUBLE PRECISION, "RAILE_STUMP_DIB_B1" DOUBLE PRECISION, "RAILE_STUMP_DIB_B2" DOUBLE PRECISION ); -- -- Table structure for table 'REF_SPECIES_GROUP' -- DROP TABLE IF EXISTS "REF_SPECIES_GROUP"; CREATE TABLE "REF_SPECIES_GROUP" ( "SPGRPCD" INTEGER DEFAULT 0, "NAME" VARCHAR(35), "REGION" VARCHAR(8), "CLASS" VARCHAR(8), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'REF_STATE_ELEV' -- DROP TABLE IF EXISTS "REF_STATE_ELEV"; CREATE TABLE "REF_STATE_ELEV" ( "STATECD" INTEGER DEFAULT 0, "MIN_ELEV" INTEGER DEFAULT 0, "MAX_ELEV" INTEGER DEFAULT 0, "LOWEST_POINT" VARCHAR(30), "HIGHEST_POINT" VARCHAR(30), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'ref_stcty' -- DROP TABLE IF EXISTS "ref_stcty"; CREATE TABLE "ref_stcty" ( "STCTY" DOUBLE PRECISION NOT NULL, "STCTYLABEL" VARCHAR(255), PRIMARY KEY ("STCTY") ); -- -- Table structure for table 'REF_UNIT' -- DROP TABLE IF EXISTS "REF_UNIT"; CREATE TABLE "REF_UNIT" ( "STATECD" INTEGER DEFAULT 0, "VALUE" INTEGER DEFAULT 0, "MEANING" VARCHAR(80), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'SEEDLING' -- DROP TABLE IF EXISTS "SEEDLING"; CREATE TABLE "SEEDLING" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "SPCD" INTEGER, "SPGRPCD" INTEGER DEFAULT 0, "STOCKING" FLOAT NULL DEFAULT 0, "TREECOUNT" INTEGER DEFAULT 0, "TOTAGE" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "TREECOUNT_CALC" INTEGER, "TPA_UNADJ" DOUBLE PRECISION DEFAULT 0, "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0, UNIQUE ("CN") ); -- -- Table structure for table 'SITETREE' -- DROP TABLE IF EXISTS "SITETREE"; CREATE TABLE "SITETREE" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "PREV_SIT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "TREE" INTEGER DEFAULT 0, "SPCD" INTEGER, "DIA" FLOAT NULL DEFAULT 0, "HT" INTEGER DEFAULT 0, "AGEDIA" INTEGER DEFAULT 0, "SPGRPCD" INTEGER DEFAULT 0, "SITREE" INTEGER DEFAULT 0, "SIBASE" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "AZIMUTH" INTEGER DEFAULT 0, "DIST" FLOAT NULL DEFAULT 0, "METHOD" INTEGER DEFAULT 0, "SITREE_EST" INTEGER DEFAULT 0, "VALIDCD" INTEGER DEFAULT 0, "CONDLIST" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0 ); -- -- Table structure for table 'SOILS_EROSION' -- DROP TABLE IF EXISTS "SOILS_EROSION"; CREATE TABLE "SOILS_EROSION" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER, "MEASYEAR" INTEGER DEFAULT 0, "SOILSPCT" DOUBLE PRECISION, "COMPCPCT" DOUBLE PRECISION, "TYPRTDCD" DOUBLE PRECISION, "TYPCMPCD" DOUBLE PRECISION, "TYPAREACD" DOUBLE PRECISION, "TYPOTHRCD" DOUBLE PRECISION, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'SOILS_LAB' -- DROP TABLE IF EXISTS "SOILS_LAB"; CREATE TABLE "SOILS_LAB" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SMPLNNBR" DOUBLE PRECISION DEFAULT 0, "VSTNBR" INTEGER DEFAULT 0, "LAYER_TYPE" VARCHAR(10), "SAMPLER_TYPE" VARCHAR(2), "QASTATCD" INTEGER DEFAULT 0, "SAMPLE_DATE" TIMESTAMP, "LAB_ID" VARCHAR(10), "SAMPLE_ID" VARCHAR(12), "FIELD_MOIST_SOIL_WT" DOUBLE PRECISION DEFAULT 0, "AIR_DRY_SOIL_WT" DOUBLE PRECISION DEFAULT 0, "OVEN_DRY_SOIL_WT" DOUBLE PRECISION DEFAULT 0, "FIELD_MOIST_WATER_CONTENT_PCT" DOUBLE PRECISION DEFAULT 0, "RESIDUAL_WATER_CONTENT_PCT" DOUBLE PRECISION DEFAULT 0, "TOTAL_WATER_CONTENT_PCT" DOUBLE PRECISION DEFAULT 0, "BULK_DENSITY" DOUBLE PRECISION DEFAULT 0, "COARSE_FRACTION_PCT" DOUBLE PRECISION DEFAULT 0, "C_ORG_PCT" DOUBLE PRECISION DEFAULT 0, "C_INORG_PCT" DOUBLE PRECISION DEFAULT 0, "C_TOTAL_PCT" DOUBLE PRECISION DEFAULT 0, "N_TOTAL_PCT" DOUBLE PRECISION DEFAULT 0, "PH_H2O" DOUBLE PRECISION DEFAULT 0, "PH_CACL2" DOUBLE PRECISION DEFAULT 0, "EXCHNG_NA" DOUBLE PRECISION DEFAULT 0, "EXCHNG_K" DOUBLE PRECISION DEFAULT 0, "EXCHNG_MG" DOUBLE PRECISION DEFAULT 0, "EXCHNG_CA" DOUBLE PRECISION DEFAULT 0, "EXCHNG_AL" DOUBLE PRECISION DEFAULT 0, "ECEC" DOUBLE PRECISION DEFAULT 0, "EXCHNG_MN" DOUBLE PRECISION DEFAULT 0, "EXCHNG_FE" DOUBLE PRECISION DEFAULT 0, "EXCHNG_NI" DOUBLE PRECISION DEFAULT 0, "EXCHNG_CU" DOUBLE PRECISION DEFAULT 0, "EXCHNG_ZN" DOUBLE PRECISION DEFAULT 0, "EXCHNG_CD" DOUBLE PRECISION DEFAULT 0, "EXCHNG_PB" DOUBLE PRECISION DEFAULT 0, "EXCHNG_S" DOUBLE PRECISION DEFAULT 0, "BRAY1_P" DOUBLE PRECISION DEFAULT 0, "OLSEN_P" DOUBLE PRECISION DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'SOILS_SAMPLE_LOC' -- DROP TABLE IF EXISTS "SOILS_SAMPLE_LOC"; CREATE TABLE "SOILS_SAMPLE_LOC" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SMPLNNBR" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "FORFLTHK" DOUBLE PRECISION, "LTRLRTHK" DOUBLE PRECISION, "FORFLTHKN" DOUBLE PRECISION, "LTRLRTHKN" DOUBLE PRECISION, "FORFLTHKS" DOUBLE PRECISION, "LTRLRTHKS" DOUBLE PRECISION, "FORFLTHKE" DOUBLE PRECISION, "LTRLRTHKE" DOUBLE PRECISION, "FORFLTHKW" DOUBLE PRECISION, "LTRLRTHKW" DOUBLE PRECISION, "CONDID" INTEGER DEFAULT 0, "VSTNBR" INTEGER DEFAULT 0, "TXTRLYR1" DOUBLE PRECISION, "TXTRLYR2" DOUBLE PRECISION, "DPTHSBSL" DOUBLE PRECISION, "SOILS_STATCD" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'SOILS_VISIT' -- DROP TABLE IF EXISTS "SOILS_VISIT"; CREATE TABLE "SOILS_VISIT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "MEASDAY" INTEGER DEFAULT 0, "MEASMON" INTEGER DEFAULT 0, "MEASYEAR" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'SUBP_COND' -- DROP TABLE IF EXISTS "SUBP_COND"; CREATE TABLE "SUBP_COND" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "MICRCOND_PROP" FLOAT NULL DEFAULT 0, "SUBPCOND_PROP" FLOAT NULL DEFAULT 0, "MACRCOND_PROP" FLOAT NULL DEFAULT 0, "NONFR_INCL_PCT_SUBP" INTEGER DEFAULT 0, "NONFR_INCL_PCT_MACRO" INTEGER DEFAULT 0, "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0 ); -- -- Table structure for table 'SUBP_COND_CHNG_MTRX' -- DROP TABLE IF EXISTS "SUBP_COND_CHNG_MTRX"; CREATE TABLE "SUBP_COND_CHNG_MTRX" ( "CN" VARCHAR(34), "STATECD" DECIMAL(4,0), "SUBP" DECIMAL(1,0), "SUBPTYP" DECIMAL(1,0), "PLT_CN" VARCHAR(34), "CONDID" DECIMAL(1,0), "PREV_PLT_CN" VARCHAR(34), "PREVCOND" DECIMAL(1,0), "SUBPTYP_PROP_CHNG" DECIMAL(5,4), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'SUBPLOT' -- DROP TABLE IF EXISTS "SUBPLOT"; CREATE TABLE "SUBPLOT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "PREV_SBP_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "SUBP_STATUS_CD" INTEGER DEFAULT 0, "POINT_NONSAMPLE_REASN_CD" INTEGER DEFAULT 0, "MICRCOND" INTEGER DEFAULT 0, "SUBPCOND" INTEGER DEFAULT 0, "MACRCOND" INTEGER DEFAULT 0, "CONDLIST" INTEGER DEFAULT 0, "SLOPE" INTEGER DEFAULT 0, "ASPECT" INTEGER DEFAULT 0, "WATERDEP" INTEGER DEFAULT 0, "P2A_GRM_FLG" VARCHAR(1), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0, "ROOT_DIS_SEV_CD_PNWRS" INTEGER DEFAULT 0, "NF_SUBP_STATUS_CD" INTEGER, "NF_SUBP_NONSAMPLE_REASN_CD" INTEGER, "P2VEG_SUBP_STATUS_CD" INTEGER, "P2VEG_SUBP_NONSAMPLE_REASN_CD" INTEGER, "INVASIVE_SUBP_STATUS_CD" INTEGER, "INVASIVE_NONSAMPLE_REASN_CD" INTEGER ); -- -- Table structure for table 'SURVEY' -- DROP TABLE IF EXISTS "SURVEY"; CREATE TABLE "SURVEY" ( "CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "P3_OZONE_IND" VARCHAR(1), "STATECD" INTEGER DEFAULT 0, "STATEAB" VARCHAR(2), "STATENM" VARCHAR(28), "RSCD" INTEGER DEFAULT 0, "ANN_INVENTORY" VARCHAR(1), "NOTES" TEXT, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0 ); -- -- Table structure for table 'TempEstnUnitDescrLU' -- DROP TABLE IF EXISTS "TempEstnUnitDescrLU"; CREATE TABLE "TempEstnUnitDescrLU" ( "rscdEvalidEsntUnit" VARCHAR(34), "rscdEvalidEsntUnitLabel" VARCHAR(128), UNIQUE ("rscdEvalidEsntUnit") ); -- -- Table structure for table 'TREE' -- DROP TABLE IF EXISTS "TREE"; CREATE TABLE "TREE" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "PREV_TRE_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "UNITCD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "TREE" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "AZIMUTH" INTEGER DEFAULT 0, "DIST" FLOAT NULL, "PREVCOND" INTEGER DEFAULT 0, "STATUSCD" INTEGER DEFAULT 0, "SPCD" INTEGER, "SPGRPCD" INTEGER DEFAULT 0, "DIA" FLOAT NULL DEFAULT 0, "DIAHTCD" INTEGER DEFAULT 0, "HT" INTEGER DEFAULT 0, "HTCD" INTEGER DEFAULT 0, "ACTUALHT" INTEGER DEFAULT 0, "TREECLCD" INTEGER DEFAULT 0, "CR" INTEGER DEFAULT 0, "CCLCD" INTEGER DEFAULT 0, "TREEGRCD" INTEGER DEFAULT 0, "AGENTCD" INTEGER DEFAULT 0, "CULL" INTEGER DEFAULT 0, "DAMLOC1" INTEGER DEFAULT 0, "DAMTYP1" INTEGER DEFAULT 0, "DAMSEV1" INTEGER DEFAULT 0, "DAMLOC2" INTEGER DEFAULT 0, "DAMTYP2" INTEGER DEFAULT 0, "DAMSEV2" INTEGER DEFAULT 0, "DECAYCD" INTEGER DEFAULT 0, "STOCKING" FLOAT NULL DEFAULT 0, "WDLDSTEM" INTEGER DEFAULT 0, "VOLCFNET" DOUBLE PRECISION DEFAULT 0, "VOLCFGRS" DOUBLE PRECISION DEFAULT 0, "VOLCSNET" DOUBLE PRECISION DEFAULT 0, "VOLCSGRS" DOUBLE PRECISION DEFAULT 0, "VOLBFNET" DOUBLE PRECISION DEFAULT 0, "VOLBFGRS" DOUBLE PRECISION DEFAULT 0, "VOLCFSND" DOUBLE PRECISION DEFAULT 0, "GROWCFGS" DOUBLE PRECISION DEFAULT 0, "GROWBFSL" DOUBLE PRECISION DEFAULT 0, "GROWCFAL" DOUBLE PRECISION DEFAULT 0, "MORTCFGS" DOUBLE PRECISION DEFAULT 0, "MORTBFSL" DOUBLE PRECISION DEFAULT 0, "MORTCFAL" DOUBLE PRECISION DEFAULT 0, "REMVCFGS" DOUBLE PRECISION DEFAULT 0, "REMVBFSL" DOUBLE PRECISION DEFAULT 0, "REMVCFAL" DOUBLE PRECISION DEFAULT 0, "DIACHECK" INTEGER DEFAULT 0, "MORTYR" INTEGER DEFAULT 0, "SALVCD" INTEGER DEFAULT 0, "UNCRCD" INTEGER DEFAULT 0, "CPOSCD" INTEGER DEFAULT 0, "CLIGHTCD" INTEGER DEFAULT 0, "CVIGORCD" INTEGER DEFAULT 0, "CDENCD" INTEGER DEFAULT 0, "CDIEBKCD" INTEGER DEFAULT 0, "TRANSCD" INTEGER DEFAULT 0, "TREEHISTCD" INTEGER DEFAULT 0, "DIACALC" FLOAT NULL DEFAULT 0, "BHAGE" INTEGER DEFAULT 0, "TOTAGE" INTEGER DEFAULT 0, "CULLDEAD" INTEGER DEFAULT 0, "CULLFORM" INTEGER DEFAULT 0, "CULLMSTOP" INTEGER DEFAULT 0, "CULLBF" INTEGER DEFAULT 0, "CULLCF" INTEGER DEFAULT 0, "BFSND" INTEGER DEFAULT 0, "CFSND" INTEGER DEFAULT 0, "SAWHT" INTEGER DEFAULT 0, "BOLEHT" INTEGER DEFAULT 0, "FORMCL" INTEGER DEFAULT 0, "HTCALC" INTEGER DEFAULT 0, "HRDWD_CLUMP_CD" INTEGER DEFAULT 0, "SITREE" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6), "MORTCD" INTEGER DEFAULT 0, "HTDMP" FLOAT NULL DEFAULT 0, "ROUGHCULL" INTEGER DEFAULT 0, "MIST_CL_CD" INTEGER DEFAULT 0, "CULL_FLD" INTEGER DEFAULT 0, "RECONCILECD" INTEGER DEFAULT 0, "PREVDIA" FLOAT NULL DEFAULT 0, "FGROWCFGS" DOUBLE PRECISION DEFAULT 0, "FGROWBFSL" DOUBLE PRECISION DEFAULT 0, "FGROWCFAL" DOUBLE PRECISION DEFAULT 0, "FMORTCFGS" DOUBLE PRECISION DEFAULT 0, "FMORTBFSL" DOUBLE PRECISION DEFAULT 0, "FMORTCFAL" DOUBLE PRECISION DEFAULT 0, "FREMVCFGS" DOUBLE PRECISION DEFAULT 0, "FREMVBFSL" DOUBLE PRECISION DEFAULT 0, "FREMVCFAL" DOUBLE PRECISION DEFAULT 0, "P2A_GRM_FLG" VARCHAR(1), "TREECLCD_NERS" INTEGER DEFAULT 0, "TREECLCD_SRS" INTEGER DEFAULT 0, "TREECLCD_NCRS" INTEGER DEFAULT 0, "TREECLCD_RMRS" INTEGER DEFAULT 0, "STANDING_DEAD_CD" INTEGER DEFAULT 0, "PREV_STATUS_CD" INTEGER DEFAULT 0, "PREV_WDLDSTEM" INTEGER DEFAULT 0, "TPA_UNADJ" DOUBLE PRECISION DEFAULT 0, "TPAMORT_UNADJ" DOUBLE PRECISION DEFAULT 0, "TPAREMV_UNADJ" DOUBLE PRECISION DEFAULT 0, "TPAGROW_UNADJ" DOUBLE PRECISION DEFAULT 0, "DRYBIO_BOLE" DOUBLE PRECISION DEFAULT 0, "DRYBIO_TOP" DOUBLE PRECISION DEFAULT 0, "DRYBIO_STUMP" DOUBLE PRECISION DEFAULT 0, "DRYBIO_SAPLING" DOUBLE PRECISION DEFAULT 0, "DRYBIO_WDLD_SPP" DOUBLE PRECISION DEFAULT 0, "DRYBIO_BG" DOUBLE PRECISION DEFAULT 0, "CARBON_AG" DOUBLE PRECISION DEFAULT 0, "CARBON_BG" DOUBLE PRECISION DEFAULT 0, "CYCLE" INTEGER DEFAULT 0, "SUBCYCLE" INTEGER DEFAULT 0, "BORED_CD_PNWRS" INTEGER DEFAULT 0, "DAMLOC1_PNWRS" INTEGER DEFAULT 0, "DAMLOC2_PNWRS" INTEGER DEFAULT 0, "DIACHECK_PNWRS" INTEGER DEFAULT 0, "DMG_AGENT1_CD_PNWRS" INTEGER DEFAULT 0, "DMG_AGENT2_CD_PNWRS" INTEGER DEFAULT 0, "DMG_AGENT3_CD_PNWRS" INTEGER DEFAULT 0, "MIST_CL_CD_PNWRS" INTEGER DEFAULT 0, "SEVERITY1_CD_PNWRS" INTEGER DEFAULT 0, "SEVERITY1A_CD_PNWRS" INTEGER DEFAULT 0, "SEVERITY1B_CD_PNWRS" INTEGER DEFAULT 0, "SEVERITY2_CD_PNWRS" INTEGER DEFAULT 0, "SEVERITY2A_CD_PNWRS" INTEGER DEFAULT 0, "SEVERITY2B_CD_PNWRS" INTEGER DEFAULT 0, "SEVERITY3_CD_PNWRS" INTEGER DEFAULT 0, "UNKNOWN_DAMTYP1_PNWRS" INTEGER DEFAULT 0, "UNKNOWN_DAMTYP2_PNWRS" INTEGER DEFAULT 0, "PREV_PNTN_SRS" INTEGER DEFAULT 0, UNIQUE ("CN") ); -- -- Table structure for table 'TREE_REGIONAL_BIOMASS' -- DROP TABLE IF EXISTS "TREE_REGIONAL_BIOMASS"; CREATE TABLE "TREE_REGIONAL_BIOMASS" ( "TRE_CN" VARCHAR(34), "STATECD" INTEGER DEFAULT 0, "REGIONAL_DRYBIOT" DOUBLE PRECISION DEFAULT 0, "REGIONAL_DRYBIOM" DOUBLE PRECISION DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'VEG_PLOT_SPECIES' -- DROP TABLE IF EXISTS "VEG_PLOT_SPECIES"; CREATE TABLE "VEG_PLOT_SPECIES" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "VVT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "VEG_FLDSPCD" VARCHAR(16), "UNIQUE_SP_NBR" INTEGER DEFAULT 0, "VEG_SPCD" VARCHAR(16), "SPECIMEN_COLLECTED" VARCHAR(1), "SPECIMEN_LABEL_NBR" DOUBLE PRECISION, "SPECIMEN_NOT_COLLECTED_REASON" INTEGER DEFAULT 0, "SPECIMEN_RESOLVED" VARCHAR(1), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'VEG_QUADRAT' -- DROP TABLE IF EXISTS "VEG_QUADRAT"; CREATE TABLE "VEG_QUADRAT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "VVT_CN" VARCHAR(34), "VSB_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "QUADRAT" INTEGER DEFAULT 0, "CONDID" INTEGER DEFAULT 0, "QUADRAT_STATUS" INTEGER DEFAULT 0, "QUADRAT_STATUS_PRE2004" INTEGER DEFAULT 0, "TRAMPLING" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'VEG_QUADRAT_SPP_VW' -- DROP TABLE IF EXISTS "VEG_QUADRAT_SPP_VW"; CREATE TABLE "VEG_QUADRAT_SPP_VW" ( "PLT_CN" VARCHAR(34), "VVT_CN" VARCHAR(34), "VSB_CN" VARCHAR(34), "VQT_CN" VARCHAR(34), "VSS_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "QUADRAT" INTEGER DEFAULT 0, "VEG_FLDSPCD" VARCHAR(16), "UNIQUE_SP_NBR" INTEGER, "VEG_SPCD" VARCHAR(16), "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'VEG_SUBPLOT' -- DROP TABLE IF EXISTS "VEG_SUBPLOT"; CREATE TABLE "VEG_SUBPLOT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "VVT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "VEG_SUBP_STATUS_CD" INTEGER DEFAULT 0, "VEG_SUBP_NONSAMPLE_REASN_CD" INTEGER DEFAULT 0, "SUBP_ACCESSIBLE_FOREST_PCT" INTEGER DEFAULT 0, "DETAILED_NONFOREST_LAND_USE" INTEGER DEFAULT 0, "COMMUNITY_DESC_SPECIMEN_LABEL" VARCHAR(200), "TOTAL_CANOPY_COVER_LAYER_1" INTEGER DEFAULT 0, "TOTAL_CANOPY_COVER_LAYER_2" INTEGER DEFAULT 0, "TOTAL_CANOPY_COVER_LAYER_3" INTEGER DEFAULT 0, "TOTAL_CANOPY_COVER_LAYER_4" INTEGER DEFAULT 0, "CRYPTO_CRUST_COVER_PCT" INTEGER DEFAULT 0, "LICHEN_COVER_PCT" INTEGER DEFAULT 0, "LITTER_DUFF_COVER_PCT" INTEGER DEFAULT 0, "MINERAL_SOIL_COVER_PCT" INTEGER DEFAULT 0, "MOSS_COVER_PCT" INTEGER DEFAULT 0, "ROAD_TRAIL_COVER_PCT" INTEGER DEFAULT 0, "ROCK_COVER_PCT" INTEGER DEFAULT 0, "STANDING_WATER_COVER_PCT" INTEGER DEFAULT 0, "STREAM_LAKE_COVER_PCT" INTEGER DEFAULT 0, "TRASH_JUNK_COVER_PCT" INTEGER DEFAULT 0, "WOOD_COVER_PCT" INTEGER DEFAULT 0, "VEG_SUBP_STATUS_CD_PRE2004" INTEGER DEFAULT 0, "VEG_SUBP_NONSMP_RSN_CD_PRE2004" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'VEG_SUBPLOT_SPP' -- DROP TABLE IF EXISTS "VEG_SUBPLOT_SPP"; CREATE TABLE "VEG_SUBPLOT_SPP" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "VVT_CN" VARCHAR(34), "VSB_CN" VARCHAR(34), "VPS_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "SUBP" INTEGER DEFAULT 0, "VEG_FLDSPCD" VARCHAR(16), "UNIQUE_SP_NBR" INTEGER DEFAULT 0, "VEG_SPCD" VARCHAR(16), "SP_CANOPY_COVER_TOTAL" FLOAT NULL DEFAULT 0, "SP_CANOPY_COVER_LAYER_1_2" FLOAT NULL DEFAULT 0, "SP_CANOPY_COVER_LAYER_3" FLOAT NULL DEFAULT 0, "SP_CANOPY_COVER_LAYER_4" FLOAT NULL DEFAULT 0, "QUAD_1_PRESENCE" INTEGER DEFAULT 0, "QUAD_2_PRESENCE" INTEGER DEFAULT 0, "QUAD_3_PRESENCE" INTEGER DEFAULT 0, "DUMMY_SUBP_COVER_PRE2004" INTEGER DEFAULT 0, "MAX_COVER_LAYER_NBR_PRE2004" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) ); -- -- Table structure for table 'VEG_VISIT' -- DROP TABLE IF EXISTS "VEG_VISIT"; CREATE TABLE "VEG_VISIT" ( "CN" VARCHAR(34), "PLT_CN" VARCHAR(34), "INVYR" INTEGER DEFAULT 0, "STATECD" INTEGER DEFAULT 0, "COUNTYCD" INTEGER DEFAULT 0, "PLOT" INTEGER DEFAULT 0, "VEG_QA_STATUS" INTEGER DEFAULT 0, "VEG_KINDCD" INTEGER DEFAULT 0, "VEG_MANUAL" VARCHAR(8), "TRACE_COVER_ALLOWED" INTEGER DEFAULT 0, "VEG_MEASYEAR" INTEGER DEFAULT 0, "VEG_MEASMON" INTEGER DEFAULT 0, "VEG_MEASDAY" INTEGER DEFAULT 0, "VEG_SAMPLE_BASIS" INTEGER DEFAULT 0, "CREATED_BY" VARCHAR(30), "CREATED_DATE" TIMESTAMP, "CREATED_IN_INSTANCE" VARCHAR(6), "MODIFIED_BY" VARCHAR(30), "MODIFIED_DATE" TIMESTAMP, "MODIFIED_IN_INSTANCE" VARCHAR(6) );