Project

General

Profile

« Previous | Next » 

Revision 8203

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/FIA/*/map.csv for pre-refresh tables: Added back * before unmapped column names

View differences:

inputs/FIA/Organism/map.csv
11 11 
StateProvince,stateProvince,,
12 12 
County,county,,
13 13 
DBH,diameterBreastHeight_in,,Assuming units based on the range and precision of values and location inside the U.S.
14 
HOM,HOM,,
14 
HOM,*HOM,,
15 15 
BasalDiameter,basalDiameter_in,,Assuming units are the same as for DBH because the values are similar and they measure the same dimension
16 16 
Height,height_ft,,"Assuming units based on the range of values, the height of the tallest tree [1], and location inside the U.S.
17 17 

  		












  

    
      inputs/FIA/FIA_COND_unique/map.csv
    
  





  1
  1
  
    
FIA,VegCore,Filter,Comments


  		




  2
  
  
    
CN,CN,,


  		




  
  2
  
    
CN,*CN,,


  		




  3
  3
  
    
PLT_CN,locationID,,


  		




  4
  
  
    
INVYR,INVYR,,


  		




  5
  
  
    
STATECD,STATECD,,


  		




  6
  
  
    
UNITCD,UNITCD,,


  		




  7
  
  
    
COUNTYCD,COUNTYCD,,


  		




  
  4
  
    
INVYR,*INVYR,,


  		




  
  5
  
    
STATECD,*STATECD,,


  		




  
  6
  
    
UNITCD,*UNITCD,,


  		




  
  7
  
    
COUNTYCD,*COUNTYCD,,


  		




  8
  8
  
    
PLOT,locationName,,


  		




  9
  9
  
    
CONDID,authorEventCode,,


  		




  10
  
  
    
COND_STATUS_CD,COND_STATUS_CD,,


  		




  11
  
  
    
COND_NONSAMPLE_REASN_CD,COND_NONSAMPLE_REASN_CD,,


  		




  12
  
  
    
RESERVCD,RESERVCD,,


  		




  13
  
  
    
OWNCD,OWNCD,,


  		




  14
  
  
    
OWNGRPCD,OWNGRPCD,,


  		




  15
  
  
    
FORINDCD,FORINDCD,,


  		




  16
  
  
    
ADFORCD,ADFORCD,,


  		




  17
  
  
    
FORTYPCD,FORTYPCD,,


  		




  18
  
  
    
FLDTYPCD,FLDTYPCD,,


  		




  19
  
  
    
MAPDEN,MAPDEN,,


  		




  20
  
  
    
STDAGE,STDAGE,,


  		




  21
  
  
    
STDSZCD,STDSZCD,,


  		




  22
  
  
    
FLDSZCD,FLDSZCD,,


  		




  23
  
  
    
SITECLCD,SITECLCD,,


  		




  24
  
  
    
SICOND,SICOND,,


  		




  25
  
  
    
SIBASE,SIBASE,,


  		




  26
  
  
    
SISP,SISP,,


  		




  27
  
  
    
STDORGCD,STDORGCD,,


  		




  28
  
  
    
STDORGSP,STDORGSP,,


  		




  29
  
  
    
PROP_BASIS,PROP_BASIS,,


  		




  30
  
  
    
CONDPROP_UNADJ,CONDPROP_UNADJ,,


  		




  31
  
  
    
MICRPROP_UNADJ,MICRPROP_UNADJ,,


  		




  32
  
  
    
SUBPPROP_UNADJ,SUBPPROP_UNADJ,,


  		




  33
  
  
    
MACRPROP_UNADJ,MACRPROP_UNADJ,,


  		




  34
  
  
    
SLOPE,SLOPE,,


  		




  35
  
  
    
ASPECT,ASPECT,,


  		




  36
  
  
    
PHYSCLCD,PHYSCLCD,,


  		




  37
  
  
    
GSSTKCD,GSSTKCD,,


  		




  38
  
  
    
ALSTKCD,ALSTKCD,,


  		




  39
  
  
    
DSTRBCD1,DSTRBCD1,,


  		




  40
  
  
    
DSTRBYR1,DSTRBYR1,,


  		




  41
  
  
    
DSTRBCD2,DSTRBCD2,,


  		




  42
  
  
    
DSTRBYR2,DSTRBYR2,,


  		




  43
  
  
    
DSTRBCD3,DSTRBCD3,,


  		




  44
  
  
    
DSTRBYR3,DSTRBYR3,,


  		




  45
  
  
    
TRTCD1,TRTCD1,,


  		




  46
  
  
    
TRTYR1,TRTYR1,,


  		




  47
  
  
    
TRTCD2,TRTCD2,,


  		




  48
  
  
    
TRTYR2,TRTYR2,,


  		




  49
  
  
    
TRTCD3,TRTCD3,,


  		




  50
  
  
    
TRTYR3,TRTYR3,,


  		




  51
  
  
    
PRESNFCD,PRESNFCD,,


  		




  52
  
  
    
BALIVE,BALIVE,,


  		




  53
  
  
    
FLDAGE,FLDAGE,,


  		




  54
  
  
    
ALSTK,ALSTK,,


  		




  55
  
  
    
GSSTK,GSSTK,,


  		




  56
  
  
    
FORTYPCDCALC,FORTYPCDCALC,,


  		




  57
  
  
    
HABTYPCD1,HABTYPCD1,,


  		




  58
  
  
    
HABTYPCD1_PUB_CD,HABTYPCD1_PUB_CD,,


  		




  59
  
  
    
HABTYPCD1_DESCR_PUB_CD,HABTYPCD1_DESCR_PUB_CD,,


  		




  60
  
  
    
HABTYPCD2,HABTYPCD2,,


  		




  61
  
  
    
HABTYPCD2_PUB_CD,HABTYPCD2_PUB_CD,,


  		




  62
  
  
    
HABTYPCD2_DESCR_PUB_CD,HABTYPCD2_DESCR_PUB_CD,,


  		




  63
  
  
    
MIXEDCONFCD,MIXEDCONFCD,,


  		




  64
  
  
    
VOL_LOC_GRP,VOL_LOC_GRP,,


  		




  65
  
  
    
SITECLCDEST,SITECLCDEST,,


  		




  66
  
  
    
SITETREE_TREE,SITETREE_TREE,,


  		




  67
  
  
    
SITECL_METHOD,SITECL_METHOD,,


  		




  68
  
  
    
CARBON_DOWN_DEAD,CARBON_DOWN_DEAD,,


  		




  69
  
  
    
CARBON_LITTER,CARBON_LITTER,,


  		




  70
  
  
    
CARBON_SOIL_ORG,CARBON_SOIL_ORG,,


  		




  71
  
  
    
CARBON_STANDING_DEAD,CARBON_STANDING_DEAD,,


  		




  72
  
  
    
CARBON_UNDERSTORY_AG,CARBON_UNDERSTORY_AG,,


  		




  73
  
  
    
CARBON_UNDERSTORY_BG,CARBON_UNDERSTORY_BG,,


  		




  74
  
  
    
CREATED_BY,CREATED_BY,,


  		




  75
  
  
    
CREATED_DATE,CREATED_DATE,,


  		




  76
  
  
    
CREATED_IN_INSTANCE,CREATED_IN_INSTANCE,,


  		




  77
  
  
    
MODIFIED_BY,MODIFIED_BY,,


  		




  78
  
  
    
MODIFIED_DATE,MODIFIED_DATE,,


  		




  79
  
  
    
MODIFIED_IN_INSTANCE,MODIFIED_IN_INSTANCE,,


  		




  80
  
  
    
CYCLE,CYCLE,,


  		




  81
  
  
    
SUBCYCLE,SUBCYCLE,,


  		




  82
  
  
    
SOIL_ROOTING_DEPTH_PNW,SOIL_ROOTING_DEPTH_PNW,,


  		




  83
  
  
    
GROUND_LAND_CLASS_PNW,GROUND_LAND_CLASS_PNW,,


  		




  84
  
  
    
PLANT_STOCKABILITY_FACTOR_PNW,PLANT_STOCKABILITY_FACTOR_PNW,,


  		




  85
  
  
    
STND_COND_CD_PNWRS,STND_COND_CD_PNWRS,,


  		




  86
  
  
    
STND_STRUC_CD_PNWRS,STND_STRUC_CD_PNWRS,,


  		




  87
  
  
    
STUMP_CD_PNWRS,STUMP_CD_PNWRS,,


  		




  88
  
  
    
FIRE_SRS,FIRE_SRS,,


  		




  89
  
  
    
GRAZING_SRS,GRAZING_SRS,,


  		




  90
  
  
    
HARVEST_TYPE1_SRS,HARVEST_TYPE1_SRS,,


  		




  91
  
  
    
HARVEST_TYPE2_SRS,HARVEST_TYPE2_SRS,,


  		




  92
  
  
    
HARVEST_TYPE3_SRS,HARVEST_TYPE3_SRS,,


  		




  93
  
  
    
LAND_USE_SRS,LAND_USE_SRS,,


  		




  94
  
  
    
OPERABILITY_SRS,OPERABILITY_SRS,,


  		




  95
  
  
    
STAND_STRUCTURE_SRS,STAND_STRUCTURE_SRS,,


  		




  
  10
  
    
COND_STATUS_CD,*COND_STATUS_CD,,


  		




  
  11
  
    
COND_NONSAMPLE_REASN_CD,*COND_NONSAMPLE_REASN_CD,,


  		




  
  12
  
    
RESERVCD,*RESERVCD,,


  		




  
  13
  
    
OWNCD,*OWNCD,,


  		




  
  14
  
    
OWNGRPCD,*OWNGRPCD,,


  		




  
  15
  
    
FORINDCD,*FORINDCD,,


  		




  
  16
  
    
ADFORCD,*ADFORCD,,


  		




  
  17
  
    
FORTYPCD,*FORTYPCD,,


  		




  
  18
  
    
FLDTYPCD,*FLDTYPCD,,


  		




  
  19
  
    
MAPDEN,*MAPDEN,,


  		




  
  20
  
    
STDAGE,*STDAGE,,


  		




  
  21
  
    
STDSZCD,*STDSZCD,,


  		




  
  22
  
    
FLDSZCD,*FLDSZCD,,


  		




  
  23
  
    
SITECLCD,*SITECLCD,,


  		




  
  24
  
    
SICOND,*SICOND,,


  		




  
  25
  
    
SIBASE,*SIBASE,,


  		




  
  26
  
    
SISP,*SISP,,


  		




  
  27
  
    
STDORGCD,*STDORGCD,,


  		




  
  28
  
    
STDORGSP,*STDORGSP,,


  		




  
  29
  
    
PROP_BASIS,*PROP_BASIS,,


  		




  
  30
  
    
CONDPROP_UNADJ,*CONDPROP_UNADJ,,


  		




  
  31
  
    
MICRPROP_UNADJ,*MICRPROP_UNADJ,,


  		




  
  32
  
    
SUBPPROP_UNADJ,*SUBPPROP_UNADJ,,


  		




  
  33
  
    
MACRPROP_UNADJ,*MACRPROP_UNADJ,,


  		




  
  34
  
    
SLOPE,*SLOPE,,


  		




  
  35
  
    
ASPECT,*ASPECT,,


  		




  
  36
  
    
PHYSCLCD,*PHYSCLCD,,


  		




  
  37
  
    
GSSTKCD,*GSSTKCD,,


  		




  
  38
  
    
ALSTKCD,*ALSTKCD,,


  		




  
  39
  
    
DSTRBCD1,*DSTRBCD1,,


  		




  
  40
  
    
DSTRBYR1,*DSTRBYR1,,


  		




  
  41
  
    
DSTRBCD2,*DSTRBCD2,,


  		




  
  42
  
    
DSTRBYR2,*DSTRBYR2,,


  		




  
  43
  
    
DSTRBCD3,*DSTRBCD3,,


  		




  
  44
  
    
DSTRBYR3,*DSTRBYR3,,


  		




  
  45
  
    
TRTCD1,*TRTCD1,,


  		




  
  46
  
    
TRTYR1,*TRTYR1,,


  		




  
  47
  
    
TRTCD2,*TRTCD2,,


  		




  
  48
  
    
TRTYR2,*TRTYR2,,


  		




  
  49
  
    
TRTCD3,*TRTCD3,,


  		




  
  50
  
    
TRTYR3,*TRTYR3,,


  		




  
  51
  
    
PRESNFCD,*PRESNFCD,,


  		




  
  52
  
    
BALIVE,*BALIVE,,


  		




  
  53
  
    
FLDAGE,*FLDAGE,,


  		




  
  54
  
    
ALSTK,*ALSTK,,


  		




  
  55
  
    
GSSTK,*GSSTK,,


  		




  
  56
  
    
FORTYPCDCALC,*FORTYPCDCALC,,


  		




  
  57
  
    
HABTYPCD1,*HABTYPCD1,,


  		




  
  58
  
    
HABTYPCD1_PUB_CD,*HABTYPCD1_PUB_CD,,


  		




  
  59
  
    
HABTYPCD1_DESCR_PUB_CD,*HABTYPCD1_DESCR_PUB_CD,,


  		




  
  60
  
    
HABTYPCD2,*HABTYPCD2,,


  		




  
  61
  
    
HABTYPCD2_PUB_CD,*HABTYPCD2_PUB_CD,,


  		




  
  62
  
    
HABTYPCD2_DESCR_PUB_CD,*HABTYPCD2_DESCR_PUB_CD,,


  		




  
  63
  
    
MIXEDCONFCD,*MIXEDCONFCD,,


  		




  
  64
  
    
VOL_LOC_GRP,*VOL_LOC_GRP,,


  		




  
  65
  
    
SITECLCDEST,*SITECLCDEST,,


  		




  
  66
  
    
SITETREE_TREE,*SITETREE_TREE,,


  		




  
  67
  
    
SITECL_METHOD,*SITECL_METHOD,,


  		




  
  68
  
    
CARBON_DOWN_DEAD,*CARBON_DOWN_DEAD,,


  		




  
  69
  
    
CARBON_LITTER,*CARBON_LITTER,,


  		




  
  70
  
    
CARBON_SOIL_ORG,*CARBON_SOIL_ORG,,


  		




  
  71
  
    
CARBON_STANDING_DEAD,*CARBON_STANDING_DEAD,,


  		




  
  72
  
    
CARBON_UNDERSTORY_AG,*CARBON_UNDERSTORY_AG,,


  		




  
  73
  
    
CARBON_UNDERSTORY_BG,*CARBON_UNDERSTORY_BG,,


  		




  
  74
  
    
CREATED_BY,*CREATED_BY,,


  		




  
  75
  
    
CREATED_DATE,*CREATED_DATE,,


  		




  
  76
  
    
CREATED_IN_INSTANCE,*CREATED_IN_INSTANCE,,


  		




  
  77
  
    
MODIFIED_BY,*MODIFIED_BY,,


  		




  
  78
  
    
MODIFIED_DATE,*MODIFIED_DATE,,


  		




  
  79
  
    
MODIFIED_IN_INSTANCE,*MODIFIED_IN_INSTANCE,,


  		




  
  80
  
    
CYCLE,*CYCLE,,


  		




  
  81
  
    
SUBCYCLE,*SUBCYCLE,,


  		




  
  82
  
    
SOIL_ROOTING_DEPTH_PNW,*SOIL_ROOTING_DEPTH_PNW,,


  		




  
  83
  
    
GROUND_LAND_CLASS_PNW,*GROUND_LAND_CLASS_PNW,,


  		




  
  84
  
    
PLANT_STOCKABILITY_FACTOR_PNW,*PLANT_STOCKABILITY_FACTOR_PNW,,


  		




  
  85
  
    
STND_COND_CD_PNWRS,*STND_COND_CD_PNWRS,,


  		




  
  86
  
    
STND_STRUC_CD_PNWRS,*STND_STRUC_CD_PNWRS,,


  		




  
  87
  
    
STUMP_CD_PNWRS,*STUMP_CD_PNWRS,,


  		




  
  88
  
    
FIRE_SRS,*FIRE_SRS,,


  		




  
  89
  
    
GRAZING_SRS,*GRAZING_SRS,,


  		




  
  90
  
    
HARVEST_TYPE1_SRS,*HARVEST_TYPE1_SRS,,


  		




  
  91
  
    
HARVEST_TYPE2_SRS,*HARVEST_TYPE2_SRS,,


  		




  
  92
  
    
HARVEST_TYPE3_SRS,*HARVEST_TYPE3_SRS,,


  		




  
  93
  
    
LAND_USE_SRS,*LAND_USE_SRS,,


  		




  
  94
  
    
OPERABILITY_SRS,*OPERABILITY_SRS,,


  		




  
  95
  
    
STAND_STRUCTURE_SRS,*STAND_STRUCTURE_SRS,,


  		




  96
  96
  
    
oldgrowth,oldGrowth,,


  		




  97
  
  
    
Index_CN_index,Index_CN_index,,


  		




  98
  
  
    
Index_PLT_CN_index,Index_PLT_CN_index,,


  		




  99
  
  
    
Index_4_index,Index_4_index,,


  		




  100
  
  
    
Index_5_index,Index_5_index,,


  		




  101
  
  
    
Index_6_index,Index_6_index,,


  		




  102
  
  
    
Index_7_index,Index_7_index,,


  		




  103
  
  
    
Index_oldgrowth_index,Index_oldgrowth_index,,


  		




  
  97
  
    
Index_CN_index,*Index_CN_index,,


  		




  
  98
  
    
Index_PLT_CN_index,*Index_PLT_CN_index,,


  		




  
  99
  
    
Index_4_index,*Index_4_index,,


  		




  
  100
  
    
Index_5_index,*Index_5_index,,


  		




  
  101
  
    
Index_6_index,*Index_6_index,,


  		




  
  102
  
    
Index_7_index,*Index_7_index,,


  		




  
  103
  
    
Index_oldgrowth_index,*Index_oldgrowth_index,,


  		












  

    
      inputs/FIA/FIA_COND_unique/VegBIEN.csv
    
  





  1
  1
  
    
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments


  		




  
  2
  
    
PLOT,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",


  		




  2
  3
  
    
PLT_CN,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",


  		




  
  4
  
    
CONDID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",


  		




  3
  5
  
    
PLT_CN,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",


  		




  
  6
  
    
PLOT,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",


  		




  4
  7
  
    
PLT_CN,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",


  		




  5
  8
  
    
oldgrowth,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_alt/1/_not/value",


  		




  
  9
  
    
CONDID,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",


  		




  
  10
  
    
CONDID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",


  		




  
  11
  
    
PLOT,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",


  		




  6
  12
  
    
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",


  		




  
  13
  
    
CONDID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",


  		




  
  14
  
    
CONDID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",


  		




  
  15
  
    
PLOT,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",


  		




  7
  16
  
    
PLT_CN,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",


  		




  8
  17
  
    
oldgrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_alt/1/_not/value",


  		




  9
  18
  
    
PLT_CN,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",


  		




  ......




  20
  29
  
    
CARBON_UNDERSTORY_AG,,** No join mapping for *CARBON_UNDERSTORY_AG ** 


  		




  21
  30
  
    
CARBON_UNDERSTORY_BG,,** No join mapping for *CARBON_UNDERSTORY_BG ** 


  		




  22
  31
  
    
CN,,** No join mapping for *CN ** 


  		




  23
  
  
    
CONDID,,** No join mapping for *CONDID ** 


  		




  24
  32
  
    
CONDPROP_UNADJ,,** No join mapping for *CONDPROP_UNADJ ** 


  		




  25
  33
  
    
COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND_NONSAMPLE_REASN_CD ** 


  		




  26
  34
  
    
COND_STATUS_CD,,** No join mapping for *COND_STATUS_CD ** 


  		




  ......




  76
  84
  
    
OWNGRPCD,,** No join mapping for *OWNGRPCD ** 


  		




  77
  85
  
    
PHYSCLCD,,** No join mapping for *PHYSCLCD ** 


  		




  78
  86
  
    
PLANT_STOCKABILITY_FACTOR_PNW,,** No join mapping for *PLANT_STOCKABILITY_FACTOR_PNW ** 


  		




  79
  
  
    
PLOT,,** No join mapping for *PLOT ** 


  		




  80
  87
  
    
PRESNFCD,,** No join mapping for *PRESNFCD ** 


  		




  81
  88
  
    
PROP_BASIS,,** No join mapping for *PROP_BASIS ** 


  		




  82
  89
  
    
RESERVCD,,** No join mapping for *RESERVCD ** 


  		












Also available in:  Unified diff