Revision 7413
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/FIA/import_order.txt | ||
|---|---|---|
| 1 | 1 |
Source |
| 2 | 2 |
FIA_COND_unique |
| 3 | 3 |
Organism |
| 4 |
COND_unique |
|
| inputs/FIA/COND_unique/create.sql | ||
|---|---|---|
| 1 |
SELECT |
|
| 2 |
DISTINCT ON ("PLT_CN")
|
|
| 3 |
* |
|
| 4 |
, |
|
| 5 |
( |
|
| 6 |
"STDAGE"::integer>80 |
|
| 7 |
AND ("TRTCD1"='0' OR "TRTCD1" IS NULL)
|
|
| 8 |
AND (("DSTRBCD1"<>'30' AND "DSTRBCD1"<>'31' AND "DSTRBCD1"<>'32' AND "DSTRBCD1"<>'80') OR "DSTRBCD1" IS NULL)
|
|
| 9 |
AND ("STUMP_CD_PNWRS"='N' OR "STUMP_CD_PNWRS" IS NULL)
|
|
| 10 |
AND "HARVEST_TYPE1_SRS" IS NULL |
|
| 11 |
AND "PRESNFCD" IS NULL |
|
| 12 |
AND ("STDORGCD"='0' OR "STDORGCD" IS NULL)
|
|
| 13 |
) |
|
| 14 |
OR "STND_COND_CD_PNWRS"='7' |
|
| 15 |
AS oldgrowth |
|
| 16 |
FROM "COND" |
|
| 17 |
; |
|
| 18 |
|
|
| 19 |
ALTER TABLE :table ADD PRIMARY KEY ("PLT_CN");
|
|
| inputs/FIA/COND_unique/header.csv | ||
|---|---|---|
| 1 |
row_num,CN,PLT_CN,INVYR,STATECD,UNITCD,COUNTYCD,PLOT,CONDID,COND_STATUS_CD,COND_NONSAMPLE_REASN_CD,RESERVCD,OWNCD,OWNGRPCD,FORINDCD,ADFORCD,FORTYPCD,FLDTYPCD,MAPDEN,STDAGE,STDSZCD,FLDSZCD,SITECLCD,SICOND,SIBASE,SISP,STDORGCD,STDORGSP,PROP_BASIS,CONDPROP_UNADJ,MICRPROP_UNADJ,SUBPPROP_UNADJ,MACRPROP_UNADJ,SLOPE,ASPECT,PHYSCLCD,GSSTKCD,ALSTKCD,DSTRBCD1,DSTRBYR1,DSTRBCD2,DSTRBYR2,DSTRBCD3,DSTRBYR3,TRTCD1,TRTYR1,TRTCD2,TRTYR2,TRTCD3,TRTYR3,PRESNFCD,BALIVE,FLDAGE,ALSTK,GSSTK,FORTYPCDCALC,HABTYPCD1,HABTYPCD1_PUB_CD,HABTYPCD1_DESCR_PUB_CD,HABTYPCD2,HABTYPCD2_PUB_CD,HABTYPCD2_DESCR_PUB_CD,MIXEDCONFCD,VOL_LOC_GRP,SITECLCDEST,SITETREE_TREE,SITECL_METHOD,CARBON_DOWN_DEAD,CARBON_LITTER,CARBON_SOIL_ORG,CARBON_STANDING_DEAD,CARBON_UNDERSTORY_AG,CARBON_UNDERSTORY_BG,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE,CYCLE,SUBCYCLE,SOIL_ROOTING_DEPTH_PNW,GROUND_LAND_CLASS_PNW,PLANT_STOCKABILITY_FACTOR_PNW,STND_COND_CD_PNWRS,STND_STRUC_CD_PNWRS,STUMP_CD_PNWRS,FIRE_SRS,GRAZING_SRS,HARVEST_TYPE1_SRS,HARVEST_TYPE2_SRS,HARVEST_TYPE3_SRS,LAND_USE_SRS,OPERABILITY_SRS,STAND_STRUCTURE_SRS,NF_COND_STATUS_CD,NF_COND_NONSAMPLE_REASN_CD,CANOPY_CVR_SAMPLE_METHOD_CD,LIVE_CANOPY_CVR_PCT,LIVE_MISSING_CANOPY_CVR_PCT,NBR_LIVE_STEMS,OWNSUBCD,INDUSTRIALCD_FIADB,RESERVCD_FLD,ADMIN_WITHDRAWN_CD,oldgrowth |
|
| inputs/FIA/COND_unique/map.csv | ||
|---|---|---|
| 1 |
FIA,VegCore,Filter,Comments |
|
| 2 |
row_num,*row_num,, |
|
| 3 |
CN,*CN,, |
|
| 4 |
PLT_CN,locationID,, |
|
| 5 |
INVYR,*INVYR,, |
|
| 6 |
STATECD,*STATECD,, |
|
| 7 |
UNITCD,*UNITCD,, |
|
| 8 |
COUNTYCD,*COUNTYCD,, |
|
| 9 |
PLOT,*PLOT,, |
|
| 10 |
CONDID,*CONDID,, |
|
| 11 |
COND_STATUS_CD,*COND_STATUS_CD,, |
|
| 12 |
COND_NONSAMPLE_REASN_CD,*COND_NONSAMPLE_REASN_CD,, |
|
| 13 |
RESERVCD,*RESERVCD,, |
|
| 14 |
OWNCD,*OWNCD,, |
|
| 15 |
OWNGRPCD,*OWNGRPCD,, |
|
| 16 |
FORINDCD,*FORINDCD,, |
|
| 17 |
ADFORCD,*ADFORCD,, |
|
| 18 |
FORTYPCD,*FORTYPCD,, |
|
| 19 |
FLDTYPCD,*FLDTYPCD,, |
|
| 20 |
MAPDEN,*MAPDEN,, |
|
| 21 |
STDAGE,*STDAGE,, |
|
| 22 |
STDSZCD,*STDSZCD,, |
|
| 23 |
FLDSZCD,*FLDSZCD,, |
|
| 24 |
SITECLCD,*SITECLCD,, |
|
| 25 |
SICOND,*SICOND,, |
|
| 26 |
SIBASE,*SIBASE,, |
|
| 27 |
SISP,*SISP,, |
|
| 28 |
STDORGCD,*STDORGCD,, |
|
| 29 |
STDORGSP,*STDORGSP,, |
|
| 30 |
PROP_BASIS,*PROP_BASIS,, |
|
| 31 |
CONDPROP_UNADJ,*CONDPROP_UNADJ,, |
|
| 32 |
MICRPROP_UNADJ,*MICRPROP_UNADJ,, |
|
| 33 |
SUBPPROP_UNADJ,*SUBPPROP_UNADJ,, |
|
| 34 |
MACRPROP_UNADJ,*MACRPROP_UNADJ,, |
|
| 35 |
SLOPE,*SLOPE,, |
|
| 36 |
ASPECT,*ASPECT,, |
|
| 37 |
PHYSCLCD,*PHYSCLCD,, |
|
| 38 |
GSSTKCD,*GSSTKCD,, |
|
| 39 |
ALSTKCD,*ALSTKCD,, |
|
| 40 |
DSTRBCD1,*DSTRBCD1,, |
|
| 41 |
DSTRBYR1,*DSTRBYR1,, |
|
| 42 |
DSTRBCD2,*DSTRBCD2,, |
|
| 43 |
DSTRBYR2,*DSTRBYR2,, |
|
| 44 |
DSTRBCD3,*DSTRBCD3,, |
|
| 45 |
DSTRBYR3,*DSTRBYR3,, |
|
| 46 |
TRTCD1,*TRTCD1,, |
|
| 47 |
TRTYR1,*TRTYR1,, |
|
| 48 |
TRTCD2,*TRTCD2,, |
|
| 49 |
TRTYR2,*TRTYR2,, |
|
| 50 |
TRTCD3,*TRTCD3,, |
|
| 51 |
TRTYR3,*TRTYR3,, |
|
| 52 |
PRESNFCD,*PRESNFCD,, |
|
| 53 |
BALIVE,*BALIVE,, |
|
| 54 |
FLDAGE,*FLDAGE,, |
|
| 55 |
ALSTK,*ALSTK,, |
|
| 56 |
GSSTK,*GSSTK,, |
|
| 57 |
FORTYPCDCALC,*FORTYPCDCALC,, |
|
| 58 |
HABTYPCD1,*HABTYPCD1,, |
|
| 59 |
HABTYPCD1_PUB_CD,*HABTYPCD1_PUB_CD,, |
|
| 60 |
HABTYPCD1_DESCR_PUB_CD,*HABTYPCD1_DESCR_PUB_CD,, |
|
| 61 |
HABTYPCD2,*HABTYPCD2,, |
|
| 62 |
HABTYPCD2_PUB_CD,*HABTYPCD2_PUB_CD,, |
|
| 63 |
HABTYPCD2_DESCR_PUB_CD,*HABTYPCD2_DESCR_PUB_CD,, |
|
| 64 |
MIXEDCONFCD,*MIXEDCONFCD,, |
|
| 65 |
VOL_LOC_GRP,*VOL_LOC_GRP,, |
|
| 66 |
SITECLCDEST,*SITECLCDEST,, |
|
| 67 |
SITETREE_TREE,*SITETREE_TREE,, |
|
| 68 |
SITECL_METHOD,*SITECL_METHOD,, |
|
| 69 |
CARBON_DOWN_DEAD,*CARBON_DOWN_DEAD,, |
|
| 70 |
CARBON_LITTER,*CARBON_LITTER,, |
|
| 71 |
CARBON_SOIL_ORG,*CARBON_SOIL_ORG,, |
|
| 72 |
CARBON_STANDING_DEAD,*CARBON_STANDING_DEAD,, |
|
| 73 |
CARBON_UNDERSTORY_AG,*CARBON_UNDERSTORY_AG,, |
|
| 74 |
CARBON_UNDERSTORY_BG,*CARBON_UNDERSTORY_BG,, |
|
| 75 |
CREATED_BY,*CREATED_BY,, |
|
| 76 |
CREATED_DATE,*CREATED_DATE,, |
|
| 77 |
CREATED_IN_INSTANCE,*CREATED_IN_INSTANCE,, |
|
| 78 |
MODIFIED_BY,*MODIFIED_BY,, |
|
| 79 |
MODIFIED_DATE,*MODIFIED_DATE,, |
|
| 80 |
MODIFIED_IN_INSTANCE,*MODIFIED_IN_INSTANCE,, |
|
| 81 |
CYCLE,*CYCLE,, |
|
| 82 |
SUBCYCLE,*SUBCYCLE,, |
|
| 83 |
SOIL_ROOTING_DEPTH_PNW,*SOIL_ROOTING_DEPTH_PNW,, |
|
| 84 |
GROUND_LAND_CLASS_PNW,*GROUND_LAND_CLASS_PNW,, |
|
| 85 |
PLANT_STOCKABILITY_FACTOR_PNW,*PLANT_STOCKABILITY_FACTOR_PNW,, |
|
| 86 |
STND_COND_CD_PNWRS,*STND_COND_CD_PNWRS,, |
|
| 87 |
STND_STRUC_CD_PNWRS,*STND_STRUC_CD_PNWRS,, |
|
| 88 |
STUMP_CD_PNWRS,*STUMP_CD_PNWRS,, |
|
| 89 |
FIRE_SRS,*FIRE_SRS,, |
|
| 90 |
GRAZING_SRS,*GRAZING_SRS,, |
|
| 91 |
HARVEST_TYPE1_SRS,*HARVEST_TYPE1_SRS,, |
|
| 92 |
HARVEST_TYPE2_SRS,*HARVEST_TYPE2_SRS,, |
|
| 93 |
HARVEST_TYPE3_SRS,*HARVEST_TYPE3_SRS,, |
|
| 94 |
LAND_USE_SRS,*LAND_USE_SRS,, |
|
| 95 |
OPERABILITY_SRS,*OPERABILITY_SRS,, |
|
| 96 |
STAND_STRUCTURE_SRS,*STAND_STRUCTURE_SRS,, |
|
| 97 |
NF_COND_STATUS_CD,*NF_COND_STATUS_CD,, |
|
| 98 |
NF_COND_NONSAMPLE_REASN_CD,*NF_COND_NONSAMPLE_REASN_CD,, |
|
| 99 |
CANOPY_CVR_SAMPLE_METHOD_CD,*CANOPY_CVR_SAMPLE_METHOD_CD,, |
|
| 100 |
LIVE_CANOPY_CVR_PCT,*LIVE_CANOPY_CVR_PCT,, |
|
| 101 |
LIVE_MISSING_CANOPY_CVR_PCT,*LIVE_MISSING_CANOPY_CVR_PCT,, |
|
| 102 |
NBR_LIVE_STEMS,*NBR_LIVE_STEMS,, |
|
| 103 |
OWNSUBCD,*OWNSUBCD,, |
|
| 104 |
INDUSTRIALCD_FIADB,*INDUSTRIALCD_FIADB,, |
|
| 105 |
RESERVCD_FLD,*RESERVCD_FLD,, |
|
| 106 |
ADMIN_WITHDRAWN_CD,*ADMIN_WITHDRAWN_CD,, |
|
| 107 |
oldgrowth,oldGrowth,, |
|
| inputs/FIA/COND_unique/VegBIEN.csv | ||
|---|---|---|
| 1 |
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments |
|
| 2 |
PLT_CN,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
|
| 3 |
PLT_CN,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
|
| 4 |
PLT_CN,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
|
| 5 |
oldgrowth,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/1/_not/value", |
|
| 6 |
PLT_CN,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
|
| 7 |
PLT_CN,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
|
| 8 |
oldgrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/1/_not/value", |
|
| 9 |
PLT_CN,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists", |
|
| 10 |
PLT_CN,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1", |
|
| 11 |
ADFORCD,,** No join mapping for *ADFORCD ** |
|
| 12 |
ADMIN_WITHDRAWN_CD,,** No join mapping for *ADMIN_WITHDRAWN_CD ** |
|
| 13 |
ALSTK,,** No join mapping for *ALSTK ** |
|
| 14 |
ALSTKCD,,** No join mapping for *ALSTKCD ** |
|
| 15 |
ASPECT,,** No join mapping for *ASPECT ** |
|
| 16 |
BALIVE,,** No join mapping for *BALIVE ** |
|
| 17 |
CANOPY_CVR_SAMPLE_METHOD_CD,,** No join mapping for *CANOPY_CVR_SAMPLE_METHOD_CD ** |
|
| 18 |
CARBON_DOWN_DEAD,,** No join mapping for *CARBON_DOWN_DEAD ** |
|
| 19 |
CARBON_LITTER,,** No join mapping for *CARBON_LITTER ** |
|
| 20 |
CARBON_SOIL_ORG,,** No join mapping for *CARBON_SOIL_ORG ** |
|
| 21 |
CARBON_STANDING_DEAD,,** No join mapping for *CARBON_STANDING_DEAD ** |
|
| 22 |
CARBON_UNDERSTORY_AG,,** No join mapping for *CARBON_UNDERSTORY_AG ** |
|
| 23 |
CARBON_UNDERSTORY_BG,,** No join mapping for *CARBON_UNDERSTORY_BG ** |
|
| 24 |
CN,,** No join mapping for *CN ** |
|
| 25 |
CONDID,,** No join mapping for *CONDID ** |
|
| 26 |
CONDPROP_UNADJ,,** No join mapping for *CONDPROP_UNADJ ** |
|
| 27 |
COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND_NONSAMPLE_REASN_CD ** |
|
| 28 |
COND_STATUS_CD,,** No join mapping for *COND_STATUS_CD ** |
|
| 29 |
COUNTYCD,,** No join mapping for *COUNTYCD ** |
|
| 30 |
CREATED_BY,,** No join mapping for *CREATED_BY ** |
|
| 31 |
CREATED_DATE,,** No join mapping for *CREATED_DATE ** |
|
| 32 |
CREATED_IN_INSTANCE,,** No join mapping for *CREATED_IN_INSTANCE ** |
|
| 33 |
CYCLE,,** No join mapping for *CYCLE ** |
|
| 34 |
DSTRBCD1,,** No join mapping for *DSTRBCD1 ** |
|
| 35 |
DSTRBCD2,,** No join mapping for *DSTRBCD2 ** |
|
| 36 |
DSTRBCD3,,** No join mapping for *DSTRBCD3 ** |
|
| 37 |
DSTRBYR1,,** No join mapping for *DSTRBYR1 ** |
|
| 38 |
DSTRBYR2,,** No join mapping for *DSTRBYR2 ** |
|
| 39 |
DSTRBYR3,,** No join mapping for *DSTRBYR3 ** |
|
| 40 |
FIRE_SRS,,** No join mapping for *FIRE_SRS ** |
|
| 41 |
FLDAGE,,** No join mapping for *FLDAGE ** |
|
| 42 |
FLDSZCD,,** No join mapping for *FLDSZCD ** |
|
| 43 |
FLDTYPCD,,** No join mapping for *FLDTYPCD ** |
|
| 44 |
FORINDCD,,** No join mapping for *FORINDCD ** |
|
| 45 |
FORTYPCD,,** No join mapping for *FORTYPCD ** |
|
| 46 |
FORTYPCDCALC,,** No join mapping for *FORTYPCDCALC ** |
|
| 47 |
GRAZING_SRS,,** No join mapping for *GRAZING_SRS ** |
|
| 48 |
GROUND_LAND_CLASS_PNW,,** No join mapping for *GROUND_LAND_CLASS_PNW ** |
|
| 49 |
GSSTK,,** No join mapping for *GSSTK ** |
|
| 50 |
GSSTKCD,,** No join mapping for *GSSTKCD ** |
|
| 51 |
HABTYPCD1,,** No join mapping for *HABTYPCD1 ** |
|
| 52 |
HABTYPCD1_DESCR_PUB_CD,,** No join mapping for *HABTYPCD1_DESCR_PUB_CD ** |
|
| 53 |
HABTYPCD1_PUB_CD,,** No join mapping for *HABTYPCD1_PUB_CD ** |
|
| 54 |
HABTYPCD2,,** No join mapping for *HABTYPCD2 ** |
|
| 55 |
HABTYPCD2_DESCR_PUB_CD,,** No join mapping for *HABTYPCD2_DESCR_PUB_CD ** |
|
| 56 |
HABTYPCD2_PUB_CD,,** No join mapping for *HABTYPCD2_PUB_CD ** |
|
| 57 |
HARVEST_TYPE1_SRS,,** No join mapping for *HARVEST_TYPE1_SRS ** |
|
| 58 |
HARVEST_TYPE2_SRS,,** No join mapping for *HARVEST_TYPE2_SRS ** |
|
| 59 |
HARVEST_TYPE3_SRS,,** No join mapping for *HARVEST_TYPE3_SRS ** |
|
| 60 |
INDUSTRIALCD_FIADB,,** No join mapping for *INDUSTRIALCD_FIADB ** |
|
| 61 |
INVYR,,** No join mapping for *INVYR ** |
|
| 62 |
LAND_USE_SRS,,** No join mapping for *LAND_USE_SRS ** |
|
| 63 |
LIVE_CANOPY_CVR_PCT,,** No join mapping for *LIVE_CANOPY_CVR_PCT ** |
|
| 64 |
LIVE_MISSING_CANOPY_CVR_PCT,,** No join mapping for *LIVE_MISSING_CANOPY_CVR_PCT ** |
|
| 65 |
MACRPROP_UNADJ,,** No join mapping for *MACRPROP_UNADJ ** |
|
| 66 |
MAPDEN,,** No join mapping for *MAPDEN ** |
|
| 67 |
MICRPROP_UNADJ,,** No join mapping for *MICRPROP_UNADJ ** |
|
| 68 |
MIXEDCONFCD,,** No join mapping for *MIXEDCONFCD ** |
|
| 69 |
MODIFIED_BY,,** No join mapping for *MODIFIED_BY ** |
|
| 70 |
MODIFIED_DATE,,** No join mapping for *MODIFIED_DATE ** |
|
| 71 |
MODIFIED_IN_INSTANCE,,** No join mapping for *MODIFIED_IN_INSTANCE ** |
|
| 72 |
NBR_LIVE_STEMS,,** No join mapping for *NBR_LIVE_STEMS ** |
|
| 73 |
NF_COND_NONSAMPLE_REASN_CD,,** No join mapping for *NF_COND_NONSAMPLE_REASN_CD ** |
|
| 74 |
NF_COND_STATUS_CD,,** No join mapping for *NF_COND_STATUS_CD ** |
|
| 75 |
OPERABILITY_SRS,,** No join mapping for *OPERABILITY_SRS ** |
|
| 76 |
OWNCD,,** No join mapping for *OWNCD ** |
|
| 77 |
OWNGRPCD,,** No join mapping for *OWNGRPCD ** |
|
| 78 |
OWNSUBCD,,** No join mapping for *OWNSUBCD ** |
|
| 79 |
PHYSCLCD,,** No join mapping for *PHYSCLCD ** |
|
| 80 |
PLANT_STOCKABILITY_FACTOR_PNW,,** No join mapping for *PLANT_STOCKABILITY_FACTOR_PNW ** |
|
| 81 |
PLOT,,** No join mapping for *PLOT ** |
|
| 82 |
PRESNFCD,,** No join mapping for *PRESNFCD ** |
|
| 83 |
PROP_BASIS,,** No join mapping for *PROP_BASIS ** |
|
| 84 |
RESERVCD,,** No join mapping for *RESERVCD ** |
|
| 85 |
RESERVCD_FLD,,** No join mapping for *RESERVCD_FLD ** |
|
| 86 |
SIBASE,,** No join mapping for *SIBASE ** |
|
| 87 |
SICOND,,** No join mapping for *SICOND ** |
|
| 88 |
SISP,,** No join mapping for *SISP ** |
|
| 89 |
SITECLCD,,** No join mapping for *SITECLCD ** |
|
| 90 |
SITECLCDEST,,** No join mapping for *SITECLCDEST ** |
|
| 91 |
SITECL_METHOD,,** No join mapping for *SITECL_METHOD ** |
|
| 92 |
SITETREE_TREE,,** No join mapping for *SITETREE_TREE ** |
|
| 93 |
SLOPE,,** No join mapping for *SLOPE ** |
|
| 94 |
SOIL_ROOTING_DEPTH_PNW,,** No join mapping for *SOIL_ROOTING_DEPTH_PNW ** |
|
| 95 |
STAND_STRUCTURE_SRS,,** No join mapping for *STAND_STRUCTURE_SRS ** |
|
| 96 |
STATECD,,** No join mapping for *STATECD ** |
|
| 97 |
STDAGE,,** No join mapping for *STDAGE ** |
|
| 98 |
STDORGCD,,** No join mapping for *STDORGCD ** |
|
| 99 |
STDORGSP,,** No join mapping for *STDORGSP ** |
|
| 100 |
STDSZCD,,** No join mapping for *STDSZCD ** |
|
| 101 |
STND_COND_CD_PNWRS,,** No join mapping for *STND_COND_CD_PNWRS ** |
|
| 102 |
STND_STRUC_CD_PNWRS,,** No join mapping for *STND_STRUC_CD_PNWRS ** |
|
| 103 |
STUMP_CD_PNWRS,,** No join mapping for *STUMP_CD_PNWRS ** |
|
| 104 |
SUBCYCLE,,** No join mapping for *SUBCYCLE ** |
|
| 105 |
SUBPPROP_UNADJ,,** No join mapping for *SUBPPROP_UNADJ ** |
|
| 106 |
TRTCD1,,** No join mapping for *TRTCD1 ** |
|
| 107 |
TRTCD2,,** No join mapping for *TRTCD2 ** |
|
| 108 |
TRTCD3,,** No join mapping for *TRTCD3 ** |
|
| 109 |
TRTYR1,,** No join mapping for *TRTYR1 ** |
|
| 110 |
TRTYR2,,** No join mapping for *TRTYR2 ** |
|
| 111 |
TRTYR3,,** No join mapping for *TRTYR3 ** |
|
| 112 |
UNITCD,,** No join mapping for *UNITCD ** |
|
| 113 |
VOL_LOC_GRP,,** No join mapping for *VOL_LOC_GRP ** |
|
| 114 |
row_num,,** No join mapping for *row_num ** |
|
| inputs/FIA/COND_unique/test.xml.ref | ||
|---|---|---|
| 1 |
Put template: |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>FIA</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<sourceaccessioncode>$PLT_CN</sourceaccessioncode> |
|
| 11 |
<iscultivated><_not><value>$oldgrowth</value></_not></iscultivated> |
|
| 12 |
</location> |
|
| 13 |
</path> |
|
| 14 |
</_simplifyPath> |
|
| 15 |
</path> |
|
| 16 |
</_setDefault> |
|
| 17 |
</VegBIEN> |
|
| 18 |
Inserted 3 new rows into database |
|
| inputs/FIA/COND_unique/new_terms.csv | ||
|---|---|---|
| 1 |
PLT_CN,locationID,, |
|
| inputs/FIA/COND_unique/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*row_num |
|
| 2 |
*CN |
|
| 3 |
*INVYR |
|
| 4 |
*STATECD |
|
| 5 |
*UNITCD |
|
| 6 |
*COUNTYCD |
|
| 7 |
*PLOT |
|
| 8 |
*CONDID |
|
| 9 |
*COND_STATUS_CD |
|
| 10 |
*COND_NONSAMPLE_REASN_CD |
|
| 11 |
*RESERVCD |
|
| 12 |
*OWNCD |
|
| 13 |
*OWNGRPCD |
|
| 14 |
*FORINDCD |
|
| 15 |
*ADFORCD |
|
| 16 |
*FORTYPCD |
|
| 17 |
*FLDTYPCD |
|
| 18 |
*MAPDEN |
|
| 19 |
*STDAGE |
|
| 20 |
*STDSZCD |
|
| 21 |
*FLDSZCD |
|
| 22 |
*SITECLCD |
|
| 23 |
*SICOND |
|
| 24 |
*SIBASE |
|
| 25 |
*SISP |
|
| 26 |
*STDORGCD |
|
| 27 |
*STDORGSP |
|
| 28 |
*PROP_BASIS |
|
| 29 |
*CONDPROP_UNADJ |
|
| 30 |
*MICRPROP_UNADJ |
|
| 31 |
*SUBPPROP_UNADJ |
|
| 32 |
*MACRPROP_UNADJ |
|
| 33 |
*SLOPE |
|
| 34 |
*ASPECT |
|
| 35 |
*PHYSCLCD |
|
| 36 |
*GSSTKCD |
|
| 37 |
*ALSTKCD |
|
| 38 |
*DSTRBCD1 |
|
| 39 |
*DSTRBYR1 |
|
| 40 |
*DSTRBCD2 |
|
| 41 |
*DSTRBYR2 |
|
| 42 |
*DSTRBCD3 |
|
| 43 |
*DSTRBYR3 |
|
| 44 |
*TRTCD1 |
|
| 45 |
*TRTYR1 |
|
| 46 |
*TRTCD2 |
|
| 47 |
*TRTYR2 |
|
| 48 |
*TRTCD3 |
|
| 49 |
*TRTYR3 |
|
| 50 |
*PRESNFCD |
|
| 51 |
*BALIVE |
|
| 52 |
*FLDAGE |
|
| 53 |
*ALSTK |
|
| 54 |
*GSSTK |
|
| 55 |
*FORTYPCDCALC |
|
| 56 |
*HABTYPCD1 |
|
| 57 |
*HABTYPCD1_PUB_CD |
|
| 58 |
*HABTYPCD1_DESCR_PUB_CD |
|
| 59 |
*HABTYPCD2 |
|
| 60 |
*HABTYPCD2_PUB_CD |
|
| 61 |
*HABTYPCD2_DESCR_PUB_CD |
|
| 62 |
*MIXEDCONFCD |
|
| 63 |
*VOL_LOC_GRP |
|
| 64 |
*SITECLCDEST |
|
| 65 |
*SITETREE_TREE |
|
| 66 |
*SITECL_METHOD |
|
| 67 |
*CARBON_DOWN_DEAD |
|
| 68 |
*CARBON_LITTER |
|
| 69 |
*CARBON_SOIL_ORG |
|
| 70 |
*CARBON_STANDING_DEAD |
|
| 71 |
*CARBON_UNDERSTORY_AG |
|
| 72 |
*CARBON_UNDERSTORY_BG |
|
| 73 |
*CREATED_BY |
|
| 74 |
*CREATED_DATE |
|
| 75 |
*CREATED_IN_INSTANCE |
|
| 76 |
*MODIFIED_BY |
|
| 77 |
*MODIFIED_DATE |
|
| 78 |
*MODIFIED_IN_INSTANCE |
|
| 79 |
*CYCLE |
|
| 80 |
*SUBCYCLE |
|
| 81 |
*SOIL_ROOTING_DEPTH_PNW |
|
| 82 |
*GROUND_LAND_CLASS_PNW |
|
| 83 |
*PLANT_STOCKABILITY_FACTOR_PNW |
|
| 84 |
*STND_COND_CD_PNWRS |
|
| 85 |
*STND_STRUC_CD_PNWRS |
|
| 86 |
*STUMP_CD_PNWRS |
|
| 87 |
*FIRE_SRS |
|
| 88 |
*GRAZING_SRS |
|
| 89 |
*HARVEST_TYPE1_SRS |
|
| 90 |
*HARVEST_TYPE2_SRS |
|
| 91 |
*HARVEST_TYPE3_SRS |
|
| 92 |
*LAND_USE_SRS |
|
| 93 |
*OPERABILITY_SRS |
|
| 94 |
*STAND_STRUCTURE_SRS |
|
| 95 |
*NF_COND_STATUS_CD |
|
| 96 |
*NF_COND_NONSAMPLE_REASN_CD |
|
| 97 |
*CANOPY_CVR_SAMPLE_METHOD_CD |
|
| 98 |
*LIVE_CANOPY_CVR_PCT |
|
| 99 |
*LIVE_MISSING_CANOPY_CVR_PCT |
|
| 100 |
*NBR_LIVE_STEMS |
|
| 101 |
*OWNSUBCD |
|
| 102 |
*INDUSTRIALCD_FIADB |
|
| 103 |
*RESERVCD_FLD |
|
| 104 |
*ADMIN_WITHDRAWN_CD |
|
Also available in: Unified diff
Added inputs/FIA/COND_unique/, generated from new FIA data