Project

General

Profile

« Previous | Next » 

Revision 3837

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC1-DwC2.specimens.csv: Added source of DwC 1.2 (http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd), aka DwC Classic, terms

View differences:

inputs/XAL/maps/VegBIEN.specimens.csv
1 1 
"XAL[DwC,darwin:]:/content/record/",VegBIEN:,Comments,Source,Order
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
3 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
4 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
5 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
6 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
3 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
4 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
5 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
6 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
7 7 
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,89
8 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
9 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
8 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
9 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
10 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",,http://rs.tdwg.org/dwc/terms/,66
11 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",,http://rs.tdwg.org/dwc/terms/,65
12 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",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
......
22 22 
CollectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,7; 22
23 23 
FieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",http://rs.tdwg.org/dwc/terms/,53
24 24 
Sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
25 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
25 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
26 26 
InstitutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
27 27 
DayIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,55; 120
28 28 
MonthIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,54; 120
......
33 33 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
34 34 
ScientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,50; 153
35 35 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
36 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
36 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
37 37 
Genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
38 38 
Family,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,146
39 39 
Order,"/location/locationevent/specimenreplicate/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,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/,145
......
41 41 
Phylum,"/location/locationevent/specimenreplicate/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,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/,143
42 42 
Kingdom,"/location/locationevent/specimenreplicate/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,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/,142
43 43 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,6; 23
44 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
45 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
44 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,40; 75
45 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,39; 74
46 46 
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
47 47 
InstitutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
48 48 
CollectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/,12
inputs/NY/maps/VegBIEN.specimens.csv
1 1 
NY[DwC],VegBIEN:,Comments,Source,Order
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
3 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",,http://rs.tdwg.org/dwc/terms/,71
4 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",,http://rs.tdwg.org/dwc/terms/,71
5 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
6 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",,http://rs.tdwg.org/dwc/terms/,71
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
3 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
4 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
5 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
6 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
7 7 
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,89
8 8 
BoundingBox,/location/locationdetermination/footprintgeometry_dwc,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 91
9 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
10 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
9 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
10 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
11 11 
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",,http://rs.tdwg.org/dwc/terms/,66
12 12 
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",,http://rs.tdwg.org/dwc/terms/,65
13 13 
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",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
......
23 23 
CollectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,7; 22
24 24 
FieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",http://rs.tdwg.org/dwc/terms/,53
25 25 
Sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
26 
Notes,/location/locationevent/specimenreplicate/description/_merge/1/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
27 
PlantFungusDescription,"/location/locationevent/specimenreplicate/description/_merge/1/_merge/2/_label[label=""plant fungus""]/value",,http://rs.tdwg.org/dwc/terms/,54
26 
Notes,/location/locationevent/specimenreplicate/description/_merge/1/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
27 
PlantFungusDescription,"/location/locationevent/specimenreplicate/description/_merge/1/_merge/2/_label[label=""plant fungus""]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
28 28 
InstitutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
29 29 
UniqueNYInternalRecordNumber,/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/,19
30 30 
DayIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,55; 120
......
36 36 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
37 37 
ScientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,50; 153
38 38 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
39 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
39 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
40 40 
Genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
41 41 
Family,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,146
42 42 
Order,"/location/locationevent/specimenreplicate/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,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/,145
......
44 44 
Phylum,"/location/locationevent/specimenreplicate/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,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/,143
45 45 
Kingdom,"/location/locationevent/specimenreplicate/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,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/,142
46 46 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,6; 23
47 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
48 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
47 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,40; 75
48 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,39; 74
49 49 
Locality,/location/locationnarrative/_merge/1/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
50 50 
Substrate,"/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value",,http://rs.tdwg.org/dwc/terms/,68
51 51 
Vegetation,"/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value",,http://rs.tdwg.org/dwc/terms/,68
inputs/UNCC/maps/VegBIEN.specimens.csv
24 24 
SciName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
25 25 
authors,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://rs.tdwg.org/dwc/terms/,153
26 26 
infraname,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/,150
27 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
27 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
28 28 
genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
29 29 
family,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,146
30 30 
collector,/location/locationevent/specimenreplicate/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,6; 23
inputs/U/maps/VegBIEN.specimens.csv
10 10 
Collyy,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,9; 44
11 11 
Barcode,/location/locationevent/specimenreplicate/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",http://rs.tdwg.org/dwc/terms/,20
12 12 
Number,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/,22
13 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
13 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
14 14 
ID,/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/tdwg_dw_core.xsd; http://rs.tdwg.org/dwc/terms/,0; 19
15 15 
Detyy,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,53; 120
16 16 
Detby,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
inputs/ARIZ/maps/VegBIEN.specimens.csv
40 40 
ScientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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/1","Contains the binomial in addition to the authority; Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
41 41 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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/2","Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
42 42 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
43 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
43 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
44 44 
Genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
45 45 
Family,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,146
46 46 
Order,"/location/locationevent/specimenreplicate/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,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/,145
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
1 1 
NCU-NCSC[DwC],VegBIEN:,Comments,Source,Order
2 2 
Accuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/,88
3 
Lat (-=S),"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,http://rs.tdwg.org/dwc/terms/,81
4 
Long (-=W),"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,http://rs.tdwg.org/dwc/terms/,82
3 
Lat (-=S),"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
4 
Long (-=W),"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
5 5 
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",,http://rs.tdwg.org/dwc/terms/,66
6 6 
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",,http://rs.tdwg.org/dwc/terms/,65
7 7 
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",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
1 1 
"SpeciesLink[DwC,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",VegBIEN:,Comments,Source,Order
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
3 3 
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
4 4 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
5 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
5 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
6 6 
MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
7 7 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
8 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
8 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
9 9 
MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
10 10 
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
11 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
11 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
12 12 
MaximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
13 13 
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
14 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
14 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
15 15 
MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
16 16 
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
17 17 
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/,88
18 18 
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,89
19 19 
BoundingBox,/location/locationdetermination/footprintgeometry_dwc,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 91
20 20 
DecimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,85
21 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
21 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
22 22 
VerbatimLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
23 23 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,85
24 24 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
25 25 
DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,86
26 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
26 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
27 27 
VerbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
28 28 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,86
29 29 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
......
53 53 
fieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",http://rs.tdwg.org/dwc/terms/,53
54 54 
Sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
55 55 
sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
56 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
56 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
57 57 
Remarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,65; 158
58 58 
InstitutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
59 59 
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
......
76 76 
InfraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/,150
77 77 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
78 78 
infraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/,150
79 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
79 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
80 80 
SpecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
81 81 
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
82 82 
Genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
......
93 93 
kingdom,"/location/locationevent/specimenreplicate/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,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/,142
94 94 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,6; 23
95 95 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
96 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
96 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,40; 75
97 97 
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
98 98 
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
99 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
99 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,39; 74
100 100 
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
101 101 
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
102 102 
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
inputs/MO/maps/VegBIEN.specimens.csv
1 1 
MO[DwC],VegBIEN:,Comments,Source,Order
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
3 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
4 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
5 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
6 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
7 
latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
8 
longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
3 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
4 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
5 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
6 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
7 
latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
8 
longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
9 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",,http://rs.tdwg.org/dwc/terms/,66
10 10 
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",,http://rs.tdwg.org/dwc/terms/,65
11 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",Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
......
19 19 
CatalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",http://rs.tdwg.org/dwc/terms/,20
20 20 
CollectionCode,/location/locationevent/specimenreplicate/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,http://rs.tdwg.org/dwc/terms/,12
21 21 
CollectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,7; 22
22 
convertednotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
22 
convertednotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
23 23 
InstitutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
24 24 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
25 25 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
......
27 27 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
28 28 
ScientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,50; 153
29 29 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
30 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
30 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
31 31 
genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
32 32 
family,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,146
33 33 
Kingdom,"/location/locationevent/specimenreplicate/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,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/,142
mappings/for_review/DwC1-DwC2.specimens.csv
22 22 
yearCollected,eventDate,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,9
23 23 
eventDate,eventDate,,http://rs.tdwg.org/dwc/terms/,44
24 24 
collectedDate,eventDate,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,29
25 
timeOfDay,eventTime,,,
26 
notes,fieldNotes,,,
25 
timeOfDay,eventTime,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,27
26 
notes,fieldNotes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,47
27 27 
boundingBox,footprintWKT,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,33
28 28 
subspecies,infraspecificEpithet,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,49
29 
maximumDepth,maximumDepthInMeters,,,
30 
maximumElevation,maximumElevationInMeters,,,
31 
minimumDepth,minimumDepthInMeters,,,
32 
minimumElevation,minimumElevationInMeters,,,
29 
maximumDepth,maximumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,40
30 
maximumElevation,maximumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,38
31 
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,39
32 
minimumElevation,minimumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,37
33 33 
globalUniqueIdentifier,occurrenceID,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd,0
34 34 
id,occurrenceID,,,
35 35 
preparation,preparations,,,
36 
preparationType,preparations,,,
37 
previousCatalogNumber,previousIdentifications,?,,
36 
preparationType,preparations,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
37 
previousCatalogNumber,previousIdentifications,?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44
38 38 
collectorNumber,recordNumber,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,7
39 39 
recordNumber,recordNumber,,http://rs.tdwg.org/dwc/terms/,22
40 40 
collector,recordedBy,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,6
41 
relatedCatalogItem,relatedResourceID,,,
42 
relationshipType,relationshipOfResource,,,
41 
relatedCatalogItem,relatedResourceID,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,46
42 
relationshipType,relationshipOfResource,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,45
43 43 
scientificNameAuthor,scientificNameAuthorship,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,50
44 
species,specificEpithet,,,
44 
species,specificEpithet,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,12
45 45 
state,stateProvince,,,
46 46 
remarks,taxonRemarks,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,65
47 
latitude,verbatimLatitude,,,
48 
longitude,verbatimLongitude,,,
47 
latitude,verbatimLatitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,34
48 
longitude,verbatimLongitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,33
mappings/DwC-VegBIEN.specimens.csv
1 1 
DwC,VegBIEN:,Comments,Source,Order
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
2 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
3 3 
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
4 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
4 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
5 5 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
6 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
6 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
7 7 
MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
8 
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
8 
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
9 9 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
10 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
10 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
11 11 
MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
12 
minimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
12 
minimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
13 13 
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
14 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
14 
MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
15 15 
MaximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
16 
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
16 
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
17 17 
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
18 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
18 
MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
19 19 
MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
20 
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
20 
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
21 21 
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
22 22 
CoordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/,88
23 23 
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/,88
......
28 28 
boundingBox,/location/locationdetermination/footprintgeometry_dwc,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 91
29 29 
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,,http://rs.tdwg.org/dwc/terms/,91
30 30 
DecimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,85
31 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
31 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
32 32 
VerbatimLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
33 33 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,85
34 
latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
34 
latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
35 35 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
36 36 
DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,86
37 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
37 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
38 38 
VerbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
39 39 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,86
40 
longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
40 
longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
41 41 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
42 42 
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",,http://rs.tdwg.org/dwc/terms/,66
43 43 
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",,http://rs.tdwg.org/dwc/terms/,66
......
90 90 
Sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
91 91 
sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
92 92 
FieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
93 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
93 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
94 94 
fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
95 
notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
95 
notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
96 96 
Remarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,65; 158
97 97 
TaxonRemarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/,158
98 98 
remarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,65; 158
......
139 139 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
140 140 
infraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/,150
141 141 
subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
142 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
142 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
143 143 
SpecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
144 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
144 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
145 145 
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
146 146 
Genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
147 147 
genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
......
159 159 
RecordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
160 160 
collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,6; 23
161 161 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
162 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
162 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,40; 75
163 163 
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
164 
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
164 
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,40; 75
165 165 
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
166 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
166 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,39; 74
167 167 
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
168 
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
168 
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,39; 74
169 169 
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
170 170 
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
171 171 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
......
442 442 
parentNameUsageID,,,http://rs.tdwg.org/dwc/terms/,129
443 443 
pointRadiusSpatialFit,,,http://rs.tdwg.org/dwc/terms/,90
444 444 
preparation,,** No non-empty join mapping for preparations ** ,,
445 
preparationType,,** No non-empty join mapping for preparations ** ,,
445 
preparationType,,** No non-empty join mapping for preparations ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
446 446 
preparations,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,32
447 
previousCatalogNumber,,** No non-empty join mapping for previousIdentifications ** ?,,
447 
previousCatalogNumber,,** No non-empty join mapping for previousIdentifications ** ?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44
448 448 
previousIdentifications,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,35
449 449 
references,,** No non-empty join mapping for dcterms:references ** Versions without namespace,http://rs.tdwg.org/dwc/terms/,7
450 
relatedCatalogItem,,** No non-empty join mapping for relatedResourceID ** ,,
450 
relatedCatalogItem,,** No non-empty join mapping for relatedResourceID ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,46
451 451 
relatedResourceID,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,161
452 452 
relationshipAccordingTo,,,http://rs.tdwg.org/dwc/terms/,163
453 453 
relationshipEstablishedDate,,,http://rs.tdwg.org/dwc/terms/,164
454 454 
relationshipOfResource,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,162
455 455 
relationshipRemarks,,,http://rs.tdwg.org/dwc/terms/,165
456 
relationshipType,,** No non-empty join mapping for relationshipOfResource ** ,,
456 
relationshipType,,** No non-empty join mapping for relationshipOfResource ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,45
457 457 
reproductiveCondition,,,http://rs.tdwg.org/dwc/terms/,28
458 458 
resourceID,,,http://rs.tdwg.org/dwc/terms/,160
459 459 
resourceRelationshipID,,,http://rs.tdwg.org/dwc/terms/,159
......
468 468 
taxonID,,,http://rs.tdwg.org/dwc/terms/,126
469 469 
taxonRank,,,http://rs.tdwg.org/dwc/terms/,151
470 470 
taxonomicStatus,,,http://rs.tdwg.org/dwc/terms/,156
471 
timeOfDay,,** No non-empty join mapping for eventTime ** ,,
471 
timeOfDay,,** No non-empty join mapping for eventTime ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,27
472 472 
type,,** No non-empty join mapping for dcterms:type ** Versions without namespace,http://rs.tdwg.org/dwc/terms/,0
473 473 
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,http://rs.tdwg.org/dwc/terms/,125
474 474 
verbatimCoordinateSystem,,,http://rs.tdwg.org/dwc/terms/,83
mappings/DwC1-DwC2.specimens.csv
22 22 
yearCollected,"eventDate/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,9
23 23 
eventDate,eventDate/_alt/2,,http://rs.tdwg.org/dwc/terms/,44
24 24 
collectedDate,eventDate/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/tbl_structure.php?db=bien2_staging&table=nybg_raw,29
25 
timeOfDay,eventTime,,,
26 
notes,fieldNotes,,,
25 
timeOfDay,eventTime,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,27
26 
notes,fieldNotes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,47
27 27 
boundingBox,footprintWKT,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,33
28 28 
subspecies,infraspecificEpithet,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,49
29 
maximumDepth,maximumDepthInMeters,,,
30 
maximumElevation,maximumElevationInMeters,,,
31 
minimumDepth,minimumDepthInMeters,,,
32 
minimumElevation,minimumElevationInMeters,,,
29 
maximumDepth,maximumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,40
30 
maximumElevation,maximumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,38
31 
minimumDepth,minimumDepthInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,39
32 
minimumElevation,minimumElevationInMeters,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,37
33 33 
globalUniqueIdentifier,occurrenceID,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd,0
34 34 
id,occurrenceID,,,
35 35 
preparation,preparations,,,
36 
preparationType,preparations,,,
37 
previousCatalogNumber,previousIdentifications,?,,
36 
preparationType,preparations,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
37 
previousCatalogNumber,previousIdentifications,?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44
38 38 
collectorNumber,recordNumber/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,7
39 39 
recordNumber,recordNumber/_alt/2,,http://rs.tdwg.org/dwc/terms/,22
40 40 
collector,recordedBy,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,6
41 
relatedCatalogItem,relatedResourceID,,,
42 
relationshipType,relationshipOfResource,,,
41 
relatedCatalogItem,relatedResourceID,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,46
42 
relationshipType,relationshipOfResource,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,45
43 43 
scientificNameAuthor,scientificNameAuthorship,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,50
44 
species,specificEpithet,,,
44 
species,specificEpithet,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,12
45 45 
state,stateProvince,,,
46 46 
remarks,taxonRemarks,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd,65
47 
latitude,verbatimLatitude,,,
48 
longitude,verbatimLongitude,,,
47 
latitude,verbatimLatitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,34
48 
longitude,verbatimLongitude,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,33
mappings/DwC.cs-VegBIEN.specimens.csv
1 1 
DwC,VegBIEN:,Comments,Source,Order
2 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
2 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
3 3 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
4 
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
4 
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
5 5 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
6 
minimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
6 
minimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
7 7 
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
8 
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
8 
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,38; 72
9 9 
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
10 
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
10 
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,37; 71
11 11 
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
12 12 
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/,88
13 13 
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,89
14 14 
boundingBox,/location/locationdetermination/footprintgeometry_dwc,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 91
15 15 
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,,http://rs.tdwg.org/dwc/terms/,91
16 16 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,85
17 
latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
17 
latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,34; 81
18 18 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
19 19 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,86
20 
longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
20 
longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,33; 82
21 21 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
22 22 
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",,http://rs.tdwg.org/dwc/terms/,66
23 23 
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",,http://rs.tdwg.org/dwc/terms/,65
......
45 45 
fieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",http://rs.tdwg.org/dwc/terms/,53
46 46 
sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/,26
47 47 
fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
48 
notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
48 
notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,47; 54
49 49 
remarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,65; 158
50 50 
taxonRemarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/,158
51 51 
establishmentMeans,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
......
69 69 
scientificNameAuthorship,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://rs.tdwg.org/dwc/terms/,153
70 70 
infraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://rs.tdwg.org/dwc/terms/,150
71 71 
subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,49; 150
72 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
72 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,12; 149
73 73 
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,http://rs.tdwg.org/dwc/terms/,149
74 74 
genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,147
75 75 
family,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/,146
......
79 79 
kingdom,"/location/locationevent/specimenreplicate/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,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/,142
80 80 
collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,6; 23
81 81 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
82 
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
82 
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,40; 75
83 83 
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
84 
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
84 
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd; http://rs.tdwg.org/dwc/terms/,39; 74
85 85 
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
86 86 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
87 87 
verbatimLocality,/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",http://rs.tdwg.org/dwc/terms/,69
......
201 201 
parentNameUsageID,,,http://rs.tdwg.org/dwc/terms/,129
202 202 
pointRadiusSpatialFit,,,http://rs.tdwg.org/dwc/terms/,90
203 203 
preparation,,** No non-empty join mapping for preparations ** ,,
204 
preparationType,,** No non-empty join mapping for preparations ** ,,
204 
preparationType,,** No non-empty join mapping for preparations ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,42
205 205 
preparations,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,32
206 
previousCatalogNumber,,** No non-empty join mapping for previousIdentifications ** ?,,
206 
previousCatalogNumber,,** No non-empty join mapping for previousIdentifications ** ?,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,44
207 207 
previousIdentifications,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,35
208 208 
references,,** No non-empty join mapping for dcterms:references ** Versions without namespace,http://rs.tdwg.org/dwc/terms/,7
209 
relatedCatalogItem,,** No non-empty join mapping for relatedResourceID ** ,,
209 
relatedCatalogItem,,** No non-empty join mapping for relatedResourceID ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,46
210 210 
relatedResourceID,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,161
211 211 
relationshipAccordingTo,,,http://rs.tdwg.org/dwc/terms/,163
212 212 
relationshipEstablishedDate,,,http://rs.tdwg.org/dwc/terms/,164
213 213 
relationshipOfResource,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,162
214 214 
relationshipRemarks,,,http://rs.tdwg.org/dwc/terms/,165
215 
relationshipType,,** No non-empty join mapping for relationshipOfResource ** ,,
215 
relationshipType,,** No non-empty join mapping for relationshipOfResource ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,45
216 216 
reproductiveCondition,,,http://rs.tdwg.org/dwc/terms/,28
217 217 
resourceID,,,http://rs.tdwg.org/dwc/terms/,160
218 218 
resourceRelationshipID,,,http://rs.tdwg.org/dwc/terms/,159
......
227 227 
taxonID,,,http://rs.tdwg.org/dwc/terms/,126
228 228 
taxonRank,,,http://rs.tdwg.org/dwc/terms/,151
229 229 
taxonomicStatus,,,http://rs.tdwg.org/dwc/terms/,156
230 
timeOfDay,,** No non-empty join mapping for eventTime ** ,,
230 
timeOfDay,,** No non-empty join mapping for eventTime ** ,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd,27
231 231 
type,,** No non-empty join mapping for dcterms:type ** Versions without namespace,http://rs.tdwg.org/dwc/terms/,0
232 232 
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,http://rs.tdwg.org/dwc/terms/,125
233 233 
verbatimCoordinateSystem,,,http://rs.tdwg.org/dwc/terms/,83

Also available in: Unified diff