interpretationDate,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value",

taxonFit,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",

collectionDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,

collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

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

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

<meta name="description" content="Redmine" />

<meta name="keywords" content="issue,bug,tracker" />

<meta content="authenticity_token" name="csrf-param" />

<link rel='shortcut icon' href='/nceas/favicon.ico?1347421715' />

<link href="/nceas/stylesheets/jquery/jquery-ui-1.8.21.css?1357775071" media="all" rel="stylesheet" type="text/css" />

<link href="/nceas/stylesheets/application.css?1357775071" media="all" rel="stylesheet" type="text/css" />

</li><li><a href="#Occurrence">Occurrence</a><ul><li><ul><li><a href="#Observation_VegCore">Observation_VegCore</a></li></ul>

</li><li><a href="#occurrenceID">occurrenceID</a><ul><li><a href="#globalUniqueIdentifier_DwC">globalUniqueIdentifier_DwC</a></li></ul>

</li><li><a href="#globalUniqueIdentifier">?globalUniqueIdentifier</a><ul><li><a href="#Alternative-globalUniqueIdentifier_DwC">Alternative: globalUniqueIdentifier_DwC</a></li><li><a href="#Alternative-globalUniqueIdentifier_SpeciesLink">Alternative: globalUniqueIdentifier_SpeciesLink</a></li></ul>

</li><li><a href="#recordedBy_givenName">recordedBy_givenName</a></li><li><a href="#recordedBy_middleName">recordedBy_middleName</a></li><li><a href="#recordedBy_surName">recordedBy_surName</a></li><li><a href="#associatedMedia">associatedMedia</a></li><li><a href="#associatedReferences">associatedReferences</a></li><li><a href="#associatedOccurrences">associatedOccurrences</a></li><li><a href="#associatedSequences">associatedSequences</a></li></ul>

</li><li><a href="#Observation">?Observation</a><ul><li><ul><li><a href="#Alternative-Observation_VegCore">Alternative: Observation_VegCore</a></li><li><a href="#Alternative-Observation_VegBank">Alternative: Observation_VegBank</a></li></ul>

</li></ul>

</li><li><a href="#canopyForm">canopyForm</a><ul><li><a href="#stemCanopyForm">stemCanopyForm</a></li></ul>

</li><li><a href="#canopyPosition">canopyPosition</a><ul><li><a href="#stemCanopyPosition">stemCanopyPosition</a></li></ul>

</li><li><a href="#lianaInfestation">lianaInfestation</a><ul><li><a href="#stemLianaInfestation">stemLianaInfestation</a></li></ul>

</li></ul>

</li><li><a href="#Stem">Stem</a><ul><li><ul><li><a href="#StemLocation">StemLocation</a></li></ul>

</li><li><a href="#stemID">stemID</a></li><li><a href="#stemTag">stemTag</a><ul><li><a href="#stemTag2">stemTag2</a></li></ul>

<h2  style="padding-left:2em;"><a href="#occurrenceRemarks" class="wiki-page">occurrenceRemarks</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://rs.tdwg.org/dwc/terms/#occurrenceRemarks"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#occurrenceRemarks" class="wiki-anchor">&para;</a></h2>

	<a name="recordedBy"></a>

<h2  style="padding-left:2em;"><a href="#recordedBy" class="wiki-page">recordedBy</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://rs.tdwg.org/dwc/terms/#recordedBy"><img src="_" style="font-size: small;" title="DwC" alt="DwC" /></a><a href="#recordedBy" class="wiki-anchor">&para;</a></h2>

<h3  style="padding-left:4em;"><img src="_" style="padding: 0 0.3em 3pt 0.65em;font-weight: normal;" title="Synonym:" alt="Synonym:" /> <a href="#stemLianaInfestation" class="wiki-page">stemLianaInfestation</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/stem_liana_infestation"><img src="_" style="font-size: small;" title="SALVIAS" alt="SALVIAS" /></a><a href="#stemLianaInfestation" class="wiki-anchor">&para;</a></h3>

	<a name="Stem"></a>

<h1 ><a href="#Stem" class="wiki-page">Stem</a> <img src="_" style="padding-left: 1em;font-size: small;font-weight: normal;" title="from" alt="from" /> <a href="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/CTFS#Stem"><img src="_" style="font-size: small;" title="CTFS" alt="CTFS" /></a><a href="#Stem" class="wiki-anchor">&para;</a></h1>

?distanceToStateProvince,"?distanceToStateProvince_m,distanceToStateProvince_km"

?elevation,"?elevationInMeters,verbatimElevation,verbatimElevation_m"

?exchangeCapacity,"?cationExchangeCapacity_cmol_kg,cationExchangeCapacity_meq_100g"

?fieldNumber,"?collectorNumber,authorEventCode"

?gentryDbh,"?diameterBreastHeightGentry_m,diameterBreastHeightGentry_cm,diameterBreastHeightGentry_in"

?globalUniqueIdentifier,"?occurrenceID,dataProviderRecordID"

?minimumElevation,"?minimumElevationInMeters,minimumElevation_verbatim"

?morphospecies,"?morphospeciesSuffix,speciesBinomialWithMorphospecies"

?nitrogen,"?nitrogen_fraction,nitrogen_percent"

?observationType,"?observationMeasure,observationGranularity"

?organic,"?organic_fraction,organic_percent"

?phosphorus,"?phosphorus_fraction,phosphorus_percent"

descriptionOfSite,locality

detType,voucherType

familyScore,matchedFamilyConfidence_fraction

fieldNotes_DwC_terms,eventRemarks

fieldNumber_DwC_classic,collectorNumber

fieldNumber_DwC_terms,authorEventCode

morphospecies_Brad_2,speciesBinomialWithMorphospecies

museumAccessionNumber,accessionNumber

notes_Madidi,locationRemarks

obsEndDate,endDate

obsStartDate,startDate

observationType_BIEN2,observationGranularity

observationType_SALVIAS,observationMeasure

overallScore,matchedTaxonConfidence_fraction

ownerInstitutionCode,specimenOwner

phenology,reproductiveCondition

references,distributors

relatedCatalogItem,relatedResourceID

relationshipType,relationshipOfResource

rightsHolder,dataOwners

scientificNameAuthor,scientificNameAuthorship

shapeOfSite,footprintWKT

MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,Usage inconsistent with DwC definition

Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

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

SubplotX2,*SubplotX2,,

SubplotY2,*SubplotY2,,

HabitName,growthForm,,

DNASample,*DNASample,,

IsAlive,*IsAlive,,

CompoundLeaf,UNUSED,,

Diameter,diameterBreastHeight_cm,,

TotalHeight,height_m,,

HabitName,growthForm,,

collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",

collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

collyear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

flower,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

fruit,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

museum_ID,*museum_ID,,

museumAccessionNumber,accessionNumber,,

groupType,*groupType,,

notesPublic,*notesPublic,,

notesMgt,*notesMgt,,

revisions,*revisions,,

MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

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

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

interpretationdate,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/determinationdate/_alt/1/_dateRangeStart/value",

taxonfit,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",

collectiondate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,

collectionnumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

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

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

intercept_m,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m,

intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m/_cm_to_m/value,

occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1,

individualCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,

collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

endDayOfYear,endDayOfYear,,

verbatimEventDate,verbatimEventDate,,

habitat,habitat,,

fieldNumber,collectorNumber,,

occurrenceRemarks,occurrenceRemarks,/_merge/1,

dynamicProperties,occurrenceRemarks,/_merge/2,Contains occurrenceRemarks data

taxonRemarks,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/notes",

identificationQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",

individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_merge/1,

dynamicProperties,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_merge/2,Contains occurrenceRemarks data

fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

darwin:PreviousCatalogNumber,otherCatalogNumbers,,

darwin:RelationshipType,relationshipOfResource,,

darwin:RelatedCatalogItem,relatedResourceID,,

darwin:MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

darwin:YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

darwin:IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

darwin:CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

darwin:Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"

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

darwin:PreviousCatalogNumber,otherCatalogNumbers,,

darwin:RelationshipType,relationshipOfResource,,

darwin:RelatedCatalogItem,relatedResourceID,,

BarCode,OMIT,,"Omitted because this isn't specified on all rows, but SpecimenPK is"

CatalogNumber,accessionNumber,,

CatalogSeriesPrefix,specimenHolders,/_alt/1,

LandOwner,*LandOwner,,

BlockLocationReason,*BlockLocationReason,,

BlockSpecificLocation,*BlockSpecificLocation,,

VerbatimLocality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_alt/1,

CityLocality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/2/_alt/2,

CollectionDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,

firstCollectorRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,"Actually the collector's number, not remarks"

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

CollectionGUID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,

CurrentScientificNameWithAuthor,scientificName,,

CollectionDate,dateCollected,,

CatalogSeriesPrefix,specimenHolders,/_alt/1,

CityLocality,verbatimLocality,/_alt/2,

Latitude1,decimalLatitude,,

Longitude1,decimalLongitude,,

ELEVATION,verbatimElevation,,

ECOLOGICAL INFORMATION,habitat,,

UTM,*UTM,,

DET NOTES,identificationRemarks,,

DATA ENTRY BY,*DATA ENTRY BY,,

DATA ENTRY DATE,*DATA ENTRY DATE,,

ECOLOGICAL INFORMATION,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,

COLL. DATE (EXACT),/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/1,

COLL. DATE (GENERAL),/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/2,

COLLECTOR NUMBER,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

PHENOLOGY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition,

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

LONG SECONDS,longitude_sec,,

LOCATION,locality,,

ECOLOGICAL INFORMATION,habitat,,

DET NOTES,identificationRemarks,,

DATA EDITED DATE,modified,,

COUNTY,county,,

LOCALITY,locality,,

VEGETATION,habitat,,

ELEVATION,verbatimElevation,,

LATITUDE,latitude_DMS,,

LONGITUDE,longitude_DMS,,

EXACT DATE,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/1,

GENERAL DATE,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/2,

MISC NOTES,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1,

COLLECTOR NUMBER,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

PHENOLOGY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition,

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

HERBARIUM,collection,,

SPECIES AUTHORITY,scientificNameAuthorship,,

VEGETATION,habitat,,

EXACT DATE,dateCollected,/_alt/1,

GENERAL DATE,dateCollected,/_alt/2,

COLLECTOR 1 FIRST NAME,recordedBy,/_join/1/_join_words/1,

Habitat_Description,habitat,/_join/1,

Habitat_Summary,habitat,/_join/2,

Soil_Description,*Soil_Description,,

Phenology_Stage,reproductiveCondition,,

Height_Min,height_m,/_avg/1,Assuming units based on the range and precision of values

Height_Max,height_m,/_avg/2,Assuming units based on the range and precision of values

Day_Collected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",

Month_Collected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

Year_Collected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

Collection_Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

Phenology_Stage,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition,

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

Locality_Site_Specific,locality,/_join/3,

Habitat_Description,habitat,/_join/1,

Habitat_Summary,habitat,/_join/2,

Phenology_Stage,reproductiveCondition,,

Height_Min,height_m,/_avg/1,Assuming units based on the range and precision of values

Height_Max,height_m,/_avg/2,Assuming units based on the range and precision of values

canopy_position,canopyPosition,,

canopy_form,canopyForm,,

liana_infestation,lianaInfestation,,

tmp_PlotObsID,*tmp_PlotObsID,,

temp_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for intercept_cm, which measures the same dimension"

temp_liandbh,*temp_liandbh,,

cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,

census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."

intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover_m/_cm_to_m/value,"Brad: This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."

Ind,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,"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."

coll_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,Brad: Map instead as for voucher_string

SourceVoucher,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."

Alt2,*Alt2,,What is this?

Ecology,habitat,,

Phenology,reproductiveCondition,,

Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",

Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",

Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",

Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

Phenology,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition,

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

conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,,

conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,

conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,

conceptual_darwin_2003_1_0_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

dwc_curatorial_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

dwc_terms_individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

dwc_terms_occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1,

dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,

conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)

-----

conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,,

conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,

conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,

PreviousCatalogNumber,otherCatalogNumbers,,

RelationshipType,relationshipOfResource,,

RelatedCatalogItem,relatedResourceID,,

Habitat,habitat,,

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

Vegetation,locality,"/_join/3/_label[label=""vegetation""]/value",

UniqueNYInternalRecordNumber,OMIT,,Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.

pkey,OMIT,,"CatalogNumber, etc. is a better pkey"

key,OMIT,,"CatalogNumber, etc. is a better pkey"

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

Vegetation,locality,"/_join/3/_label[label=""vegetation""]/value",

UniqueNYInternalRecordNumber,OMIT,,Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.

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

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

CurrentDetQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",

Tree,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,

CollectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,

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

country,country,,

state,stateProvince,,

county,county,,

leaves,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

flower,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

fruit,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

root,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

locality,locality,,

habitat,habitat,,

sheetno,associatedMedia,,?

cultivated,cultivated,,Ignore other values

filler,*filler,,"Where used, same as family"

collmonth,monthCollected,,

collday,dayCollected,,

collyear,yearCollected,,

leaves,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

flower,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

fruit,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

root,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"

sheetno,associatedMedia,,?

MinimumElevation,minimumElevationInMeters,,

MaximumElevation,maximumElevationInMeters,,

IndividualCount,individualCount,,

museum_id,*museum_id,,

museumaccessionnumber,accessionNumber,,

grouptype,*grouptype,,

notespublic,*notespublic,,

notesmgt,*notesmgt,,

revisions,*revisions,,

/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/potassium,"?potassium_fraction,potassium_percent"

/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,communityID

/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,communityName

/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,individualCount

/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,stemNotes

/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],tag

intercept_m,//aggregateoccurrence/linecover_m,

intercept_cm,//aggregateoccurrence/linecover_m/_cm_to_m/value,

occurrenceRemarks,//aggregateoccurrence/notes,

individualCode,//plantobservation/authorplantcode,

collectorNumber,//plantobservation/authorplantcode,

sex,"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"