dwc_dwcore_InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

dwc_terms_institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

-----

SELECT count(*) FROM ""SpeciesLink"".specimens

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

-----"

-----

SELECT count(*) FROM ""SpeciesLink"".specimens

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

-----"

-----

SELECT count(*) FROM ""SpeciesLink"".specimens

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

-----"

dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <taxondetermination>

                            <party_id>

                                <party>

longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",

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

plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",

locationnarrative,/location/locationnarrative/_merge/1,

continent,/location/locationplace/*_id/placepath/continent,

area|country|territory,/location/locationplace/*_id/placepath/country,

organismX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,

organismY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,

aggregateOccurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,

growthForm,/location/locationevent/taxonoccurrence/growthform,

verbatimGrowthForm,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"

cultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,

TNRS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments

Accepted_name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/cond/_exists",

Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",

Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$ID</sourceaccessioncode>

                        <taxondetermination>

                            <party_id>

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>

                        <taxondetermination>

                            <party_id>

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <taxondetermination>

                            <party_id>

                                <party>

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <iscultivated>$Cultivated?</iscultivated>

                        <sourceaccessioncode>$Accession Number</sourceaccessioncode>

                        <taxondetermination>

CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,

soilsand,/location/locationevent/soilobs/sand_fraction/_percent_to_fraction/value,"""Percent sand in the soil horizon"" (soilSand definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"

soilsilt,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,"""Percent silt in the soil horizon"" (soilSilt definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"

soiltexture,/location/locationevent/soilobs/texture,

accessioncode,,** No join mapping for *accessioncode ** 

autotaxoncover,,** No join mapping for *autotaxoncover ** 

basalarea,,** No join mapping for *basalarea ** 

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$id</sourceaccessioncode>

                        <taxondetermination>

                            <party_id>

darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

darwin:CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

darwin:InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,

Tree Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,

1ha Plot X Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,

1ha Plot Y Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,

Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",

Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",

Tree Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,

1ha Plot X Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,

1ha Plot Y Coordinate,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,

Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",

Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",

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

CollectionDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,

CollectionDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,

1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate ** 

CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>

                        <taxondetermination>

                            <party_id>

Tag number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,

Subplot X,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,

Subplot Y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,

Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"

Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

Limo (DIN 18 123–%–1),/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

Textural class,/location/locationevent/soilobs/texture,

Locality,/location/locationnarrative/_merge/1,

Observaciones,/location/notespublic,

Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Orientación

GROUP BY herbarium, accession

HAVING count(*) > 1

-----"

cultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,Ignore other values

accession,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,"Globally unique, although occasionally duplicated. [1]

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <iscultivated>$cultivated</iscultivated>

                        <sourceaccessioncode>$accession</sourceaccessioncode>

                        <taxondetermination>

collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,

institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$id</sourceaccessioncode>

                        <taxondetermination>

                            <party_id>

tag1,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag/_alt/2/_alt/2,"The second tag supercedes the first. The stem tag supercedes the tree tag. 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."

x_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"Brad: These are important, fundamental values of many tree plots"

y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,Brad: See comment above for x_position

habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"

OBSERVATION_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","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."

family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",

silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,

soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

soil_texture,/location/locationevent/soilobs/texture,

temp_c,/location/locationevent/temperature_c,

locality_description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"

major_geo,/location/locationplace/*_id/placepath/continent,

authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",

obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,

%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,

currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",

currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,

county,/location/locationplace/*_id/placepath/county,

Tag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,

x,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,

y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,

MeasureID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",

Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",

Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",

QuadratID,/location/authorlocationcode,Not globally unique; unique only within Site

QuadratID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",Not globally unique; unique only within Site

PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",

StartX,/location/sublocationxposition_m,

StartY,/location/sublocationyposition_m,

DimX,,** No join mapping for *DimX ** 

CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",

EndDate,/location/locationevent/obsenddate/_*/date/_alt/1,

StartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,

Description,,** No join mapping for *Description ** 

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

PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",

CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",

SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,

Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",

Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",

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

PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",

CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode",

Longitude,"/location/locationcoords/longitude_deg/_nullIf:[null=0,type=float]/value",

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

PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",

DescriptionOfSite,/location/locationnarrative/_merge/1,

LocationName,/location/locationnarrative/_merge/1,

CountryName,/location/locationplace/*_id/placepath/country,

DBH,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_in_to_m/value,Assuming units based on the range and precision of values and location inside the U.S.

Height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,

TreeTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,

Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",

SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",

Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,

silt_percent,/location/locationevent/soilobs/silt_fraction/_percent_to_fraction/value,

soil_Na,/location/locationevent/soilobs/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

soil_texture,/location/locationevent/soilobs/texture,

Temp,/location/locationevent/temperature_c,

Locality_Description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"

Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"

stem_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,

stem_tag2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag/_alt/1,"The second tag supercedes the first. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."

stem_tag1,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/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."

PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",

origrecord_id_stems,,** No join mapping for *origrecord_id_stems ** 

plotobs_id_index,,** No join mapping for *plotobs_id_index ** 

tag1,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/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."

x_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"Brad: These are important, fundamental values of many tree plots"

y_position,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,Brad: See comment above for x_position

Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"

PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","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."

Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",

Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,

Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,

Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name

Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

Cultivated?,/location/locationevent/taxonoccurrence/iscultivated/_alt/1,

Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",

                                </specimenreplicate>

                            </plantobservation>

                        </aggregateoccurrence>

                        <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>

                        <taxondetermination>

                            <party_id>

collectiondate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,

notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,

museumaccessionnumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

taxonobservation_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,

Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",

Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",

collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,

institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,

id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,

organismX,//stemobservation/xposition_m,

organismY,//stemobservation/yposition_m,

aggregateOccurrenceID,//aggregateoccurrence/sourceaccessioncode,

growthForm,//taxonoccurrence/growthform,

verbatimGrowthForm,//taxonoccurrence/growthform,"According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"

cultivated,//taxonoccurrence/iscultivated,