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

CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,

FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,

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

CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,

FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,Usage inconsistent with DwC definition

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,

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

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

collectno,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,

cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values

cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values

SciName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",

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

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

recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,

authorObsCode,/location/locationevent/authoreventcode,

obsStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,

%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,

currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",

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

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

individual_code,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."

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,"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."

specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",Brad: This is the author of the scientificName.

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

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

Ind,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."

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,"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."

auth,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",Brad: This is the author of the scientificName.

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

CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,

FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,Usage inconsistent with DwC definition

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,

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

CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/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[role=identifier]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_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/_merge/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/_map:[cultivated=t,wild=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",

Cultivated?,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",

Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",

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

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

-----"

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/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,

CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,

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

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

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

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,

identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,

relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,

relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,

recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1,

growthForm,/location/locationevent/taxonoccurrence/growthform,

establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",

establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",

recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,

AuthorPlantCode,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/3,

authorPlantCode,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/3,

GrowthForm,/location/locationevent/taxonoccurrence/growthform,

growthForm,/location/locationevent/taxonoccurrence/growthform,

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

collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,

recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,

authorPlantCode,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/3,

growthForm,/location/locationevent/taxonoccurrence/growthform,

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

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

relativePlotX,//stemobservation/xposition,

relativePlotY,//stemobservation/yposition,

recordNumber,//taxonoccurrence/authortaxoncode,

scientificName,//taxonoccurrence/authortaxoncode,

growthForm,//taxonoccurrence/growthform,

establishmentMeans,//taxonoccurrence/iscultivated,