%cover,coverPercent,,

-----

-----"

Accession Number,occurrenceID,,

Accuracy,coordinateUncertaintyInMeters,,

Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity,,

Colldd,dayCollected,,

Collect Date,dateCollected,,

CollectionCD,collectionCode,,

Collmm,monthCollected,,

Collyy,yearCollected,,

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

Detby,identifiedBy,,

Determined by,identifiedBy,,

Detyy,yearIdentified,,

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

Ecology,habitat,,

Elev,elevationInMeters,,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.

Method,samplingProtocol,,

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].

MinimumElevationInMeter,minimumElevationInMeters,,

Newgazett,verbatimLocality,"/_join/1/_label[label=""gazetteer""]/value/_join/2",Only used in 1 row

Nitrógeno total (ISRIC 6–%–0.0014),nitrogen,,

NoInd,individualCount,,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."

OBSERVATION_ID,individualID,,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."

ORDER BY ""Altitude""::real DESC

Observaciones,plotNotes,,

Observations,fieldNotes,,

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

OrigFamily,verbatimFamily,,Brad: OMIT

SciName,scientificName,,

ScientificNameOriginal,verbatimScientificName,,

SeriesName,collectionCode,,

SiteCode,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)

SizeOfSite,plotArea_ha,,"""Size in hectares"" (SizeOfSite comments in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>)"

Slope,slopeGradient,,

SourceVoucher,catalogNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."

Specie+autor,scientificNameWithAuthorship,,

Species and morphotypes,scientificName,,"Contains less than ""Specie+autor"""

SpeciesAuthority,scientificNameAuthorship,,

Specimen,catalogNumber,,

Substrate,locality,"/_join/2/_label[label=""substrate""]/value",

Suffix,UNUSED,,

Tag number,tag,,

Tissues,UNUSED,,

Topographical situation,landform,,

Total height,height,,

Tree number,recordNumber,,

TreeTag,tag,,

Trunk,authorStemCode,,

Typology,typeStatus,,

WHERE ""Minimum altitude"" IS NOT NULL

WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""

WHERE subplot IS NOT NULL AND census_date IS NOT NULL

[1] Using the following query:

[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>"

accession,occurrenceID,,

specific_authority,scientificNameAuthorship,,Brad: This is the author of the scientificName.

stem_canopy_form,canopyForm,,

stem_canopy_position,canopyPosition,,

stem_height_first_branch_m,heightFirstBranch,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."

stem_height_m,height,,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."

stem_height_m,height,/_alt/1,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."

stem_liana_infestation,lianaInfestation,,

stem_tag1,tag,/_alt/1/_alt/2,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems."

stem_tag1,tag,/_alt/2,"The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."

tag2,tag,/_alt/2/_alt/1,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."

taxonobservation_id,taxonOccurrenceID,,

temp_c,temperature,,

usdaRank,taxonRank,/_alt/1,

voucher_string,catalogNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."

x,organismX,,

"Type Inventory (C, PP, TP)"

0

1

25

3

AccessCode

Collaborators

Comments

Common name

Coordinates

Coorsyst

CountryID

Country_index

Crown position

Crown shape

Description

DimX

DimY

Installed and evaluated by

Inventory number

IsMorpho

Majorarea

MethodCode

NS

Number of inventory (expedition)

Number of inventory (general)

Number of stems

OMIT

OrigAuth

OrigRecordID

PRIVATE

Phenology

Plot X

PrimOwnerID_index

PrimaryStem

Project specimen

ReferenceID

ReferenceX

ReferenceY

Related Epilocs

RevisionComments

Similar specimen

SiteName

Soil sample

dateaccuracy

dateentered

day

dcterms:bibliographicCitation

dcterms:language

dcterms:modified

long_min

long_sec

long_string

month

morphocf

morphoname