MT

id

establishmentMeans

locality

language

collectionID

occurrenceRemarks

type

institutionCode

rights

family

continent

collectionCode

datasetName

rightsHolder

genus

basisOfRecord

individualCount

countryCode

MT[DwC],DwC:/list/,Comments

MT[DwC],"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments

basisOfRecord,basisOfRecord

collectionCode,collectionCode

collectionID,collectionID

continent,continent

countryCode,countryCode

datasetName,datasetName

establishmentMeans,establishmentMeans

family,family

genus,genus

id,id

individualCount,individualCount

institutionCode,institutionCode

language,language

locality,locality

occurrenceRemarks,occurrenceRemarks

rights,rights

rightsHolder,rightsHolder

type,type

MT[DwC],VegBIEN:/specimenreplicate,Comments,Order

continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59

locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68

genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147

family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146

establishmentMeans,"/*_id/taxonoccurrence/{growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=],iscultivated/_map:[cultivated=t,wild=f,*=],isnative/_map:[native=t,exotic=f,*=]}/value",,30

collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12

id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19

collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9

basisOfRecord,,** No non-empty join mapping for basisOfRecord ** 

countryCode,,** No non-empty join mapping for countryCode ** 

datasetName,,** No non-empty join mapping for datasetName ** 

individualCount,,** No non-empty join mapping for individualCount ** 

institutionCode,,** No non-empty join mapping for institutionCode ** 

language,,** No non-empty join mapping for language ** 

occurrenceRemarks,,** No non-empty join mapping for occurrenceRemarks ** 

rights,,** No non-empty join mapping for rights ** 

rightsHolder,,** No non-empty join mapping for rightsHolder ** 

type,,** No non-empty join mapping for type **