QMOR[DwC],VegBIEN:,Comments

verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,

locality,/location/locationnarrative/_merge/1,

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

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

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

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

DwC,VegBIEN:,Comments

verbatimElevation,//location/elevation,

maximumElevationInMeters,//location/elevation,

minimumElevationInMeters,//location/elevation,

habitat,"//location/locationnarrative/_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?"

locationID,//location/sourceaccessioncode,

occurrenceID,//location/sourceaccessioncode,

acceptedNameUsage,,

acceptedNameUsageID,,

associatedMedia,,

DwC,VegBIEN:,Comments

verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

locality,/location/locationnarrative/_merge/1,

verbatimLocality,/location/locationnarrative/_merge/2,

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

locationID,/location/sourceaccessioncode,

acceptedNameUsage,,

acceptedNameUsageID,,

accessRights,,** No non-empty join mapping for dcterms:accessRights ** 

Put template:

<VegBIEN>

    <location id="-1">

        <locationdetermination>

            <namedplace_id>

                <_simplifyPath>

            </taxonoccurrence>

        </locationevent>

        <locationnarrative><_merge><1>$locality</1></_merge></locationnarrative>

    </location>

</VegBIEN>

Inserted 22 new rows into database

MT[DwC],VegBIEN:,Comments

continent,"/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",

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

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

genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",

family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",

locality,/location/locationnarrative/_merge/1,

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

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

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

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <2>

            </waterdepth>

        </locationevent>

        <locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative>

    </location>

</VegBIEN>

Inserted 47 new rows into database

"XAL[DwC,darwin:]:/content/record/",VegBIEN:,Comments

MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

Locality,/location/locationnarrative/_merge/1,

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

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

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

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <2>

                </3>

            </_merge>

        </locationnarrative>

    </location>

</VegBIEN>

Inserted 39 new rows into database

NY[DwC],VegBIEN:,Comments

MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",

MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",

Substrate,"/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value",

Vegetation,"/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value",

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

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

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

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

Put template:

<VegBIEN>

    <location id="-1">

        <locationdetermination>

            <namedplace_id>

                <_simplifyPath>

                </3>

            </_merge>

        </locationnarrative>

    </location>

</VegBIEN>

Inserted 21 new rows into database

UNCC[DwC],VegBIEN:,Comments

county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",

state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",

country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",

collector3,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/4,

locality,/location/locationnarrative/_merge/1,

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

filler,,"Where used, same as family"

flower,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"

fruit,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <1>

                </3>

            </_merge>

        </locationnarrative>

    </location>

</VegBIEN>

Inserted 38 new rows into database

ACAD[DwC],VegBIEN:,Comments

verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",

decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",

recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,

locality,/location/locationnarrative/_merge/1,

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

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

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

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

Put template:

<VegBIEN>

    <location id="-1">

        <locationdetermination>

            <latitude>

                <_alt>

                </3>

            </_merge>

        </locationnarrative>

    </location>

</VegBIEN>

Inserted 26 new rows into database

REMIB[DwC],VegBIEN:,Comments

lat_deg,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",

long_deg,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",

county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",

collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,

locality,/location/locationnarrative/_merge/1,

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

lat_min,,** No input mapping for lat_min ** 

lat_sec,,** No input mapping for lat_sec ** 

long_min,,** No input mapping for long_min ** 

Put template:

<VegBIEN>

    <location id="-1">

        <locationdetermination>

            <latitude>

                <_alt>

                </3>

            </_merge>

        </locationnarrative>

    </location>

</VegBIEN>

Inserted 26 new rows into database

U[DwC],VegBIEN:,Comments

Lat,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",

Long,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",

Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",

Newgazett,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row

Locnotes,/location/locationnarrative/_merge/2/_merge/2,

Ecology,"/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?"

Alt,,What is this?

Alt2,,What is this?

Coorsyst,,** No input mapping for Coorsyst ** 

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <1>

            </waterdepth>

        </locationevent>

        <locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative>

    </location>

</VegBIEN>

Inserted 38 new rows into database

ARIZ[DwC],VegBIEN:,Comments

VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

Locality,/location/locationnarrative/_merge/1,

AgeClass,,** No non-empty join mapping for lifeStage ** 

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

CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <2>

            </taxonoccurrence>

        </locationevent>

        <locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative>

    </location>

</VegBIEN>

Inserted 31 new rows into database

GBIF[DwC],VegBIEN:,Comments

MaximumElevationInMeter,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumElevationInMeter,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

MinimumElevationInMeter,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",

Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,

Locality,/location/locationnarrative/_merge/1,

GBIFFamilyOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations

GBIFGenusOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations

LastDateModified,,** No non-empty join mapping for DateLastModified ** 

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <1>

                </taxondetermination>

            </taxonoccurrence>

        </locationevent>

    </location>

</VegBIEN>

Inserted 26 new rows into database

NCU-NCSC[DwC],VegBIEN:,Comments

Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

Accuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,

Lat (-=S),"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",

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]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",

Alt E/W,,** No input mapping for Alt E/W ** 

Alt N/S,,** No input mapping for Alt N/S ** 

FIPS,,FIPS county code

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <2>

                </1>

            </_merge>

        </locationnarrative>

    </location>

</VegBIEN>

Inserted 40 new rows into database

"SpeciesLink[DwC,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",VegBIEN:,Comments

MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

Locality,/location/locationnarrative/_merge/1,

locality,/location/locationnarrative/_merge/1,

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

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

DayOfYear,,** No non-empty join mapping for JulianDay ** 

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <2>

            </taxonoccurrence>

        </locationevent>

        <locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative>

    </location>

</VegBIEN>

Inserted 38 new rows into database

MO[DwC],VegBIEN:,Comments

MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",

Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,

Locality,/location/locationnarrative/_merge/1,

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

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

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

Put template:

<VegBIEN>

    <location id="-1">

        <elevation>

            <_alt>

                <1>

                </3>

            </_merge>

        </locationnarrative>

    </location>

</VegBIEN>

Inserted 34 new rows into database

DwC,VegBIEN:,Comments

verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",

verbatimLocality,/location/locationnarrative/_merge/2,

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

locationID,/location/sourceaccessioncode,

acceptedNameUsage,,

acceptedNameUsageID,,

associatedMedia,,

DwC,VegBIEN:,Comments

VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",

MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",

verbatimLocality,/location/locationnarrative/_merge/2,

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

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

LocationID,/location/sourceaccessioncode,

locationID,/location/sourceaccessioncode,

AcceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage ** 

AcceptedNameUsageID,,** No non-empty join mapping for acceptedNameUsageID ** 

AccessRights,,** No non-empty join mapping for accessRights **