Project

General

Profile

« Previous | Next » 

Revision 7221

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/Madidi/new_terms.csv: Regenerated

View differences:

inputs/Madidi/new_terms.csv
1 

  		




  2
  
  
    
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,Assuming units are % based on the range of values


  		




  3
  
  
    
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,Assuming units are % based on the range of values


  		




  4
  
  
    
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,Assuming units are % based on the range of values


  		




  5
  
  
    
"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,Assuming units are % based on the range of values


  		




  6
  
  
    
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,Assuming units are % based on the range of values


  		




  7
  
  
    
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,Assuming units are % based on the range of values


  		




  8
  
  
    
-----


  		




  9
  
  
    
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,Assuming units are % based on the range of values


  		




  10
  
  
    
Altitude,elevationInMeters,,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  11
  
  
    
Arcilla (DIN 18 123–%–1),clay_percent,,Assuming units are % based on the range of values


  		




  12
  1
  
    
Area,plotArea_ha,,


  		




  13
  
  
    
Area,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"


  		




  14
  
  
    
Arena (DIN 18 123–%–2.5),sand_percent,,Assuming units are % based on the range of values


  		




  15
  
  
    
Autor (revised),scientificNameAuthorship,,


  		




  16
  2
  
    
Available Phosphor,phosphorus_percent,,Assuming units are % based on the range of values


  		




  17
  
  
    
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,


  		




  18
  3
  
    
CIC,cationExchangeCapacity_cmol_kg,,


  		




  19
  4
  
    
CollectorAbbrev,recordedBy,/_first/3,


  		




  20
  5
  
    
CollectorString,recordedBy,/_first/1/_merge/2,


  		




  21
  6
  
    
CollectorStringShortened,recordedBy,/_first/2,


  		




  22
  
  
    
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,


  		




  23
  7
  
    
CurrentDet,scientificName,,


  		




  24
  8
  
    
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"


  		




  25
  9
  
    
CurrentDetQualifier,identificationQualifier,,


  		




  26
  10
  
    
CurrentDetRank,taxonRank,,


  		




  27
  
  
    
Determined by,identifiedBy,,


  		




  28
  11
  
    
Diameter,diameterBreastHeight_cm,,


  		




  29
  
  
    
Diameter,diameterBreastHeight_cm,,Assuming units based on the range and precision of values


  		




  30
  
  
    
Direction,slopeAspect,/_alt/1,Part files provide either this field or Orientación


  		




  31
  12
  
    
Electric conductivity,conductivity,,


  		




  32
  13
  
    
Expedition Name,projectName,,


  		




  33
  14
  
    
Expedition Number,projectID,,


  		




  34
  
  
    
Expedition name,projectName,,Consistent (globally unique) between PPM and PT data


  		




  35
  
  
    
Expedition number,projectID,,Consistent (globally unique) between PPM and PT data


  		




  36
  
  
    
Expedition,projectName,,


  		




  37
  
  
    
FROM ""Madidi"".""Plot""


  		




  38
  
  
    
Family (revised),family,,


  		




  39
  
  
    
Field family,originalFamily,,


  		




  40
  
  
    
Field name,originalGenus,,Often = Genera


  		




  41
  15
  
    
FieldFamilyFullName,family,,


  		




  42
  16
  
    
FieldFamilyFullName,originalFamily,,


  		




  43
  17
  
    
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"


  		




  44
  18
  
    
FieldNameAuthors,originalScientificNameAuthorship,,


  		




  45
  19
  
    
FieldNameFullName,originalTaxonName,,


  		




  46
  20
  
    
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors


  		




  47
  
  
    
First evaluation,eventDate,,


  		




  48
  
  
    
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,Assuming units are % based on the range of values


  		




  49
  
  
    
GROUP BY ""Altitude""::real , ""Locality""


  		




  50
  
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  51
  
  
    
Genera,genus,,


  		




  52
  21
  
    
HabitName,growthForm,,


  		




  53
  
  
    
Index collector,recordedBy,,


  		




  54
  22
  
    
Institutions,institutionCode,,


  		




  55
  23
  
    
Interchangable Calcium,calcium_percent,,Assuming units are % based on the range of values


  		




  56
  24
  
    
Interchangeable Acidity,acidity_percent,,Assuming units are % based on the range of values


  		




  57
  25
  
    
Interchangeable Magnesium,magnesium_percent,,Assuming units are % based on the range of values


  		




  58
  26
  
    
Interchangeable Potassium,potassium_percent,,Assuming units are % based on the range of values


  		




  59
  27
  
    
Interchangeable Sodium,sodium_percent,,Assuming units are % based on the range of values


  		




  60
  
  
    
Inventory code,locationID,,


  		




  61
  
  
    
Inventory name,locationName,,


  		




  62
  28
  
    
LatitudeDecDeg,decimalLatitude,,


  		




  63
  
  
    
Liana presence,lianaInfestation,,


  		




  64
  
  
    
Limo (DIN 18 123–%–1),silt_percent,,Assuming units are % based on the range of values


  		




  65
  
  
    
Locality description,communityName,,Often begins with the text in Vegetation type


  		




  66
  29
  
    
LocalityDescription,locality,,


  		




  67
  30
  
    
LongitudeDecDeg,decimalLongitude,,


  		




  68
  31
  
    
LowerName,county,,


  		




  69
  32
  
    
MaximumElevationMeters,maximumElevationInMeters,,


  		




  70
  
  
    
Minimum altitude,verbatimElevation_m,,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  71
  33
  
    
MinimumElevationMeters,minimumElevationInMeters,,


  		




  72
  34
  
    
MorphoSpeciesName,morphoname,,


  		




  73
  
  
    
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,Assuming units are % based on the range of values


  		




  74
  35
  
    
Note,plotNotes,,


  		




  75
  36
  
    
Notes 2,plotNotes,,


  		




  76
  
  
    
Number of subplot,subplot,,


  		




  77
  
  
    
ORDER BY ""Altitude""::real DESC


  		




  78
  
  
    
Observaciones,plotNotes,,


  		




  79
  
  
    
Observations,fieldNotes,,


  		




  80
  37
  
    
Organic Carbon,carbon_percent,,Assuming units are % based on the range of values


  		




  81
  38
  
    
Organic material,organic_percent,,Assuming units are % based on the range of values


  		




  82
  
  
    
Orientación/exposicion,slopeAspect,/_alt/2,Part files provide either this field or Direction


  		




  83
  39
  
    
PlotInventoryName,fieldNumber,,


  		




  84
  
  
    
Qualifier,identificationQualifier,,


  		




  85
  
  
    
SELECT ""Altitude""::real, ""Locality""


  		




  86
  
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  87
  40
  
    
SeniorCollector,recordedBy,/_first/1/_merge/1,


  		




  88
  41
  
    
Sequence,subplot,,


  		




  89
  42
  
    
Slope,slopeGradient,,


  		




  90
  
  
    
Specie+autor,scientificName,,


  		




  91
  
  
    
Species and morphotypes,taxonName,,"Contains less than ""Specie+autor"""


  		




  92
  
  
    
Specimen,catalogNumber,,


  		




  93
  43
  
    
SpecimenID,catalogNumber,,


  		




  94
  
  
    
Tag number,tag,,


  		




  95
  44
  
    
Textural Class,texture,,


  		




  96
  
  
    
Textural class,texture,,


  		




  97
  
  
    
Topographical situation,landform,,


  		




  98
  45
  
    
Topography,landform,,


  		




  99
  46
  
    
Total Nitrogen,nitrogen_percent,,Assuming units are % based on the range of values


  		




  100
  
  
    
Total height,height_m,,Assuming units based on the range and precision of values


  		




  101
  47
  
    
TotalHeight,height_m,,


  		




  102
  
  
    
Tree number,individualCode,,


  		




  103
  48
  
    
Tree,individualCode,,


  		




  104
  49
  
    
TreeNotes,fieldNotes,,


  		




  105
  50
  
    
Trunk,authorStemCode,,


  		




  106
  51
  
    
UpperName,stateProvince,,


  		




  107
  52
  
    
Vegetation Type,communityID,,


  		




  108
  
  
    
Vegetation type,communityID,,


  		




  109
  
  
    
WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'


  		




  110
  
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  111
  
  
    
[1] Using the following query:


  		




  112
  
  
    
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"


  		




  113
  
  
    
pH acuoso (ISRIC 4–– 1 - 14),ph,,


  		




  114
  53
  
    
pH disolved,ph,,


  		












Also available in:  Unified diff