Project

General

Profile

« Previous | Next » 

Revision 4620

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/VegCore-VegBIEN.csv: namedplace elements: _simplifyPath() calls: Removed no longer needed `require` arg, and removed no longer needed table suffix from `next` arg

View differences:

inputs/VegBank/plot_/test.xml.ref
30 30 
            </longitude>
31 31 
            <namedplace_id>
32 32 
                <_simplifyPath>
33 
                    <next>parent_id/namedplace</next>
34 
                    <require>placename</require>
33 
                    <next>parent_id</next>
35 34 
                    <path>
36 35 
                        <namedplace>
37 36 
                            <rank>county</rank>
mappings/VegCore-VegBIEN.csv
29 29 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
30 30 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
31 31 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
32 
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",
33 
stateProvince,"/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",
34 
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",
35 
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",
32 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
33 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
34 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
35 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
36 36 
samplingProtocol,/location/locationevent/*_id/method/name,
37 37 
projectName,/location/locationevent/*_id/project/projectname,
38 38 
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
inputs/GBIF/Specimen/VegBIEN.csv
11 11 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
12 12 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
13 13 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
14 
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",
15 
stateProvince,"/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",
16 
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",
14 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
15 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
16 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
17 17 
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
18 18 
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
19 19 
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
inputs/NCU-NCSC/Specimen/VegBIEN.csv
6 6 
Accuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
7 7 
Lat (-=S),"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
8 8 
Long (-=W),"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
9 
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",
10 
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",
11 
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",
9 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
10 
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
11 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
12 12 
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date,
13 13 
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
14 14 
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
inputs/SpeciesLink/Specimen/VegBIEN.csv
23 23 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
24 24 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
25 25 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
26 
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",
27 
stateProvince,"/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",
28 
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",
29 
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",
30 
continentOcean,"/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",
26 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
27 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
28 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
29 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
30 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
31 31 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
32 32 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
33 33 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/MO/Specimen/VegBIEN.csv
9 9 
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10 10 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
11 11 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
12 
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",
13 
stateProvince,"/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",
14 
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",
15 
continentOcean,"/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",
12 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
13 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
14 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
15 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
16 16 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
17 17 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
18 18 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/VegBank/plot_/VegBIEN.csv
11 11 
shape,/location/locationdetermination/footprintgeometry_dwc,
12 12 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
13 13 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
14 
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",
15 
region|state|province,"/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",
16 
stateProvince,"/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",
17 
area|country|territory,"/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",
18 
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",
19 
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",
14 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
15 
region|state|province,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
16 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
17 
area|country|territory,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
18 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
19 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
20 20 
authorplotcode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
21 21 
plot_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
22 22 
locationNarrative,/location/locationnarrative/_merge/1,
inputs/QMOR/Specimen/test.xml.ref
151 151 
            </longitude>
152 152 
            <namedplace_id>
153 153 
                <_simplifyPath>
154 
                    <next>parent_id/namedplace</next>
155 
                    <require>placename</require>
154 
                    <next>parent_id</next>
156 155 
                    <path>
157 156 
                        <namedplace>
158 157 
                            <rank>county</rank>
inputs/MT/Specimen/VegBIEN.csv
3 3 
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
4 4 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
5 5 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2",
6 
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",
6 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
7 7 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
8 8 
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
9 9 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,
inputs/MT/Specimen/test.xml.ref
20 20 
        <locationdetermination>
21 21 
            <namedplace_id>
22 22 
                <_simplifyPath>
23 
                    <next>parent_id/namedplace</next>
24 
                    <require>placename</require>
23 
                    <next>parent_id</next>
25 24 
                    <path>
26 25 
                        <namedplace>
27 26 
                            <rank>county</rank>
inputs/XAL/Specimen/VegBIEN.csv
10 10 
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
11 11 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
12 12 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
13 
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",
14 
stateProvince,"/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",
15 
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",
16 
continentOcean,"/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",
13 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
17 17 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
18 18 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
19 19 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/NY/Specimen/VegBIEN.csv
12 12 
boundingBox,/location/locationdetermination/footprintgeometry_dwc,
13 13 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
14 14 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
15 
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",
16 
stateProvince,"/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",
17 
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",
18 
continentOcean,"/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",
15 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
16 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
17 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
18 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
19 19 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
20 20 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
21 21 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/NY/Specimen/test.xml.ref
129 129 
            </longitude>
130 130 
            <namedplace_id>
131 131 
                <_simplifyPath>
132 
                    <next>parent_id/namedplace</next>
133 
                    <require>placename</require>
132 
                    <next>parent_id</next>
134 133 
                    <path>
135 134 
                        <namedplace>
136 135 
                            <rank>county</rank>
inputs/UNCC/Specimen/VegBIEN.csv
1 1 
UNCC[Veg+],VegBIEN:,Comments
2 2 
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3 
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
4 
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",
5 
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",
6 
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",
4 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
5 
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
6 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
7 7 
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
8 8 
collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
9 9 
collyear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/UNCC/Specimen/test.xml.ref
10 10 
        <locationdetermination>
11 11 
            <namedplace_id>
12 12 
                <_simplifyPath>
13 
                    <next>parent_id/namedplace</next>
14 
                    <require>placename</require>
13 
                    <next>parent_id</next>
15 14 
                    <path>
16 15 
                        <namedplace>
17 16 
                            <rank>county</rank>
inputs/ACAD/Specimen/VegBIEN.csv
7 7 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
8 8 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
9 9 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
10 
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",
11 
stateProvince,"/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",
12 
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",
13 
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",
10 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
11 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
12 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
13 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
14 14 
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
15 15 
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
16 16 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
inputs/ACAD/Specimen/test.xml.ref
41 41 
            </longitude>
42 42 
            <namedplace_id>
43 43 
                <_simplifyPath>
44 
                    <next>parent_id/namedplace</next>
45 
                    <require>placename</require>
44 
                    <next>parent_id</next>
46 45 
                    <path>
47 46 
                        <namedplace>
48 47 
                            <rank>county</rank>
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
13 13 
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
14 14 
lat_decimal,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
15 15 
long_decimal,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
16 
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish
17 
pol1,"/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",Brad: No; pol1=stateProvince
18 
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",
19 
major_geo,"/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",
16 
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish
17 
pol1,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince
18 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
19 
major_geo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
20 20 
plot_methodology,/location/locationevent/*_id/method/name,
21 21 
project,/location/locationevent/*_id/project/projectname,
22 22 
plot_code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
inputs/SALVIAS-CSV/Plot/test.xml.ref
113 113 
            </longitude>
114 114 
            <namedplace_id>
115 115 
                <_simplifyPath>
116 
                    <next>parent_id/namedplace</next>
117 
                    <require>placename</require>
116 
                    <next>parent_id</next>
118 117 
                    <path>
119 118 
                        <namedplace>
120 119 
                            <rank>county</rank>
inputs/CVS/Organism/VegBIEN.csv
3 3 
locationAccuracy-m,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
4 4 
publicLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
5 5 
publicLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
6 
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",
7 
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",
6 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
7 
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
8 8 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
9 9 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/2",
10 10 
authorObsCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/authorlocationcode",
inputs/CVS/Organism/test.xml.ref
20 20 
            </longitude>
21 21 
            <namedplace_id>
22 22 
                <_simplifyPath>
23 
                    <next>parent_id/namedplace</next>
24 
                    <require>placename</require>
23 
                    <next>parent_id</next>
25 24 
                    <path>
26 25 
                        <namedplace>
27 26 
                            <rank>county</rank>
inputs/REMIB/Specimen/VegBIEN.csv
3 3 
acronym,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4 4 
lat_deg,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
5 5 
long_deg,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
6 
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",
7 
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",
8 
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",
6 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
7 
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
8 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
9 9 
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
10 10 
coll_month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
11 11 
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/REMIB/Specimen/test.xml.ref
24 24 
            </longitude>
25 25 
            <namedplace_id>
26 26 
                <_simplifyPath>
27 
                    <next>parent_id/namedplace</next>
28 
                    <require>placename</require>
27 
                    <next>parent_id</next>
29 28 
                    <path>
30 29 
                        <namedplace>
31 30 
                            <rank>county</rank>
inputs/CTFS/Plot/VegBIEN.csv
9 9 
ShapeOfSite,/location/locationdetermination/footprintgeometry_dwc,
10 10 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
11 11 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
12 
CountryName,"/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",
12 
CountryName,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
13 13 
plotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",
14 14 
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
15 15 
DescriptionOfSite,/location/locationnarrative/_merge/1,
inputs/CTFS/Plot/test.xml.ref
28 28 
            </longitude>
29 29 
            <namedplace_id>
30 30 
                <_simplifyPath>
31 
                    <next>parent_id/namedplace</next>
32 
                    <require>placename</require>
31 
                    <next>parent_id</next>
33 32 
                    <path>
34 33 
                        <namedplace>
35 34 
                            <rank>county</rank>
inputs/FIA/Organism/VegBIEN.csv
4 4 
PlotCD,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
5 5 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
6 6 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
7 
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",
8 
stateProvince,"/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",
7 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
8 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
9 9 
PlotCD,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode",
10 10 
MeasDay,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
11 11 
MeasMon,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
inputs/FIA/Organism/test.xml.ref
19 19 
            </longitude>
20 20 
            <namedplace_id>
21 21 
                <_simplifyPath>
22 
                    <next>parent_id/namedplace</next>
23 
                    <require>placename</require>
22 
                    <next>parent_id</next>
24 23 
                    <path>
25 24 
                        <namedplace>
26 25 
                            <rank>county</rank>
inputs/SALVIAS/plotMetadata/VegBIEN.csv
13 13 
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
14 14 
LatDec,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
15 15 
LongDec,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
16 
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish
17 
PolDiv1,"/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",Brad: No; pol1=stateProvince
18 
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",
19 
MajorGeo,"/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",
16 
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish
17 
PolDiv1,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince
18 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
19 
MajorGeo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
20 20 
PlotMethod,/location/locationevent/*_id/method/name,
21 21 
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
22 22 
SiteCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/*_id/location/authorlocationcode",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
inputs/SALVIAS/plotMetadata/test.xml.ref
113 113 
            </longitude>
114 114 
            <namedplace_id>
115 115 
                <_simplifyPath>
116 
                    <next>parent_id/namedplace</next>
117 
                    <require>placename</require>
116 
                    <next>parent_id</next>
118 117 
                    <path>
119 118 
                        <namedplace>
120 119 
                            <rank>county</rank>
inputs/U/Specimen/VegBIEN.csv
3 3 
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
4 4 
Lat,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
5 5 
Long,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
6 
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",
6 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
7 7 
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
8 8 
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
9 9 
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
inputs/U/Specimen/test.xml.ref
24 24 
            </longitude>
25 25 
            <namedplace_id>
26 26 
                <_simplifyPath>
27 
                    <next>parent_id/namedplace</next>
28 
                    <require>placename</require>
27 
                    <next>parent_id</next>
29 28 
                    <path>
30 29 
                        <namedplace>
31 30 
                            <rank>county</rank>
inputs/ARIZ/Specimen/VegBIEN.csv
16 16 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
17 17 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
18 18 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
19 
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",
20 
stateProvince,"/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",
21 
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",
22 
continentOcean,"/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",
19 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
20 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
21 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
22 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
23 23 
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/0,
24 24 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
25 25 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
inputs/ARIZ/Specimen/test.xml.ref
151 151 
            </longitude>
152 152 
            <namedplace_id>
153 153 
                <_simplifyPath>
154 
                    <next>parent_id/namedplace</next>
155 
                    <require>placename</require>
154 
                    <next>parent_id</next>
156 155 
                    <path>
157 156 
                        <namedplace>
158 157 
                            <rank>county</rank>
inputs/GBIF/Specimen/test.xml.ref
129 129 
            </longitude>
130 130 
            <namedplace_id>
131 131 
                <_simplifyPath>
132 
                    <next>parent_id/namedplace</next>
133 
                    <require>placename</require>
132 
                    <next>parent_id</next>
134 133 
                    <path>
135 134 
                        <namedplace>
136 135 
                            <rank>county</rank>
inputs/NCU-NCSC/Specimen/test.xml.ref
46 46 
            </longitude>
47 47 
            <namedplace_id>
48 48 
                <_simplifyPath>
49 
                    <next>parent_id/namedplace</next>
50 
                    <require>placename</require>
49 
                    <next>parent_id</next>
51 50 
                    <path>
52 51 
                        <namedplace>
53 52 
                            <rank>county</rank>
inputs/SpeciesLink/Specimen/test.xml.ref
220 220 
            </longitude>
221 221 
            <namedplace_id>
222 222 
                <_simplifyPath>
223 
                    <next>parent_id/namedplace</next>
224 
                    <require>placename</require>
223 
                    <next>parent_id</next>
225 224 
                    <path>
226 225 
                        <namedplace>
227 226 
                            <rank>county</rank>
inputs/MO/Specimen/test.xml.ref
107 107 
            </longitude>
108 108 
            <namedplace_id>
109 109 
                <_simplifyPath>
110 
                    <next>parent_id/namedplace</next>
111 
                    <require>placename</require>
110 
                    <next>parent_id</next>
112 111 
                    <path>
113 112 
                        <namedplace>
114 113 
                            <rank>county</rank>
inputs/QMOR/Specimen/VegBIEN.csv
16 16 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
17 17 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
18 18 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
19 
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",
20 
stateProvince,"/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",
21 
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",
22 
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",
19 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
20 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
21 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
22 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
23 23 
samplingProtocol,/location/locationevent/*_id/method/name,
24 24 
eventDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
25 25 
eventDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
mappings/Veg+-VegBIEN.csv
50 50 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
51 51 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
52 52 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
53 
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",
54 
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",
55 
stateProvince,"/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",
56 
CountryName,"/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",
57 
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",
58 
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",
59 
continentOcean,"/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",
53 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
54 
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
55 
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
56 
CountryName,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
57 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
58 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
59 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
60 60 
samplingProtocol,/location/locationevent/*_id/method/name,
61 61 
projectName,/location/locationevent/*_id/project/projectname,
62 62 
projectID,/location/locationevent/*_id/project/sourceaccessioncode,

Also available in: Unified diff