Project

General

Profile

« Previous | Next » 

Revision 4632

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/XAL/Specimen/src.csv, map.csv: Switched from using root prefixes to full column names, because the namespace mapping functionality can be handled much better by treating each namespace-qualified term as its own term rather than as a term and a prefix

View differences:

inputs/XAL/Specimen/src.csv
1 
"XAL[Veg+,darwin:]:/content/record/",Veg+,Comments,Original name
2 
DateLastModified,DateLastModified,,darwin:DateLastModified
3 
InstitutionCode,InstitutionCode,,darwin:InstitutionCode
4 
CollectionCode,CollectionCode,,darwin:CollectionCode
5 
CatalogNumber,CatalogNumber,,darwin:CatalogNumber
6 
ScientificName,ScientificName,,darwin:ScientificName
7 
BasisOfRecord,BasisOfRecord,,darwin:BasisOfRecord
8 
Kingdom,Kingdom,,darwin:Kingdom
9 
Phylum,Phylum,,darwin:Phylum
10 
Class,Class,,darwin:Class
11 
Order,Order,,darwin:Order
12 
Family,Family,,darwin:Family
13 
Genus,Genus,,darwin:Genus
14 
Species,Species,,darwin:Species
15 
Subspecies,Subspecies,,darwin:Subspecies
16 
ScientificNameAuthor,ScientificNameAuthor,,darwin:ScientificNameAuthor
17 
IdentifiedBy,IdentifiedBy,,darwin:IdentifiedBy
18 
YearIdentified,YearIdentified,,darwin:YearIdentified
19 
MonthIdentified,MonthIdentified,,darwin:MonthIdentified
20 
DayIdentified,DayIdentified,,darwin:DayIdentified
21 
TypeStatus,TypeStatus,,darwin:TypeStatus
22 
CollectorNumber,CollectorNumber,,darwin:CollectorNumber
23 
FieldNumber,FieldNumber,,darwin:FieldNumber
24 
Collector,Collector,,darwin:Collector
25 
YearCollected,YearCollected,,darwin:YearCollected
26 
MonthCollected,MonthCollected,,darwin:MonthCollected
27 
DayCollected,DayCollected,,darwin:DayCollected
28 
JulianDay,JulianDay,,darwin:JulianDay
29 
TimeOfDay,TimeOfDay,,darwin:TimeOfDay
30 
ContinentOcean,ContinentOcean,,darwin:ContinentOcean
31 
Country,Country,,darwin:Country
32 
StateProvince,StateProvince,,darwin:StateProvince
33 
County,County,,darwin:County
34 
Locality,Locality,,darwin:Locality
35 
Longitude,Longitude,,darwin:Longitude
36 
Latitude,Latitude,,darwin:Latitude
37 
CoordinatePrecision,CoordinatePrecision,,darwin:CoordinatePrecision
38 
MinimumElevation,MinimumElevation,,darwin:MinimumElevation
39 
MaximumElevation,MaximumElevation,,darwin:MaximumElevation
40 
MinimumDepth,MinimumDepth,,darwin:MinimumDepth
41 
MaximumDepth,MaximumDepth,,darwin:MaximumDepth
42 
Sex,Sex,,darwin:Sex
43 
PreparationType,PreparationType,,darwin:PreparationType
44 
IndividualCount,IndividualCount,,darwin:IndividualCount
45 
PreviousCatalogNumber,PreviousCatalogNumber,,darwin:PreviousCatalogNumber
46 
RelationshipType,RelationshipType,,darwin:RelationshipType
47 
RelatedCatalogItem,RelatedCatalogItem,,darwin:RelatedCatalogItem
48 
Notes,Notes,,darwin:Notes
1 
XAL[Veg+]:/content/record/,Veg+,Comments
2 
darwin:DateLastModified,DateLastModified,
3 
darwin:InstitutionCode,InstitutionCode,
4 
darwin:CollectionCode,CollectionCode,
5 
darwin:CatalogNumber,CatalogNumber,
6 
darwin:ScientificName,ScientificName,
7 
darwin:BasisOfRecord,BasisOfRecord,
8 
darwin:Kingdom,Kingdom,
9 
darwin:Phylum,Phylum,
10 
darwin:Class,Class,
11 
darwin:Order,Order,
12 
darwin:Family,Family,
13 
darwin:Genus,Genus,
14 
darwin:Species,Species,
15 
darwin:Subspecies,Subspecies,
16 
darwin:ScientificNameAuthor,ScientificNameAuthor,
17 
darwin:IdentifiedBy,IdentifiedBy,
18 
darwin:YearIdentified,YearIdentified,
19 
darwin:MonthIdentified,MonthIdentified,
20 
darwin:DayIdentified,DayIdentified,
21 
darwin:TypeStatus,TypeStatus,
22 
darwin:CollectorNumber,CollectorNumber,
23 
darwin:FieldNumber,FieldNumber,
24 
darwin:Collector,Collector,
25 
darwin:YearCollected,YearCollected,
26 
darwin:MonthCollected,MonthCollected,
27 
darwin:DayCollected,DayCollected,
28 
darwin:JulianDay,JulianDay,
29 
darwin:TimeOfDay,TimeOfDay,
30 
darwin:ContinentOcean,ContinentOcean,
31 
darwin:Country,Country,
32 
darwin:StateProvince,StateProvince,
33 
darwin:County,County,
34 
darwin:Locality,Locality,
35 
darwin:Longitude,Longitude,
36 
darwin:Latitude,Latitude,
37 
darwin:CoordinatePrecision,CoordinatePrecision,
38 
darwin:MinimumElevation,MinimumElevation,
39 
darwin:MaximumElevation,MaximumElevation,
40 
darwin:MinimumDepth,MinimumDepth,
41 
darwin:MaximumDepth,MaximumDepth,
42 
darwin:Sex,Sex,
43 
darwin:PreparationType,PreparationType,
44 
darwin:IndividualCount,IndividualCount,
45 
darwin:PreviousCatalogNumber,PreviousCatalogNumber,
46 
darwin:RelationshipType,RelationshipType,
47 
darwin:RelatedCatalogItem,RelatedCatalogItem,
48 
darwin:Notes,Notes,
inputs/XAL/Specimen/map.csv
1 
"XAL[Veg+,darwin:]:/content/record/",Veg+,Comments
2 
CollectorNumber,recordNumber/_alt/1,
3 
FieldNumber,recordNumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
1 
XAL[Veg+]:/content/record/,Veg+,Comments
2 
darwin:DateLastModified,dcterms:modified,
3 
darwin:InstitutionCode,institutionCode,
4 
darwin:CollectionCode,collectionCode,
5 
darwin:CatalogNumber,catalogNumber,
6 
darwin:ScientificName,scientificName,
7 
darwin:BasisOfRecord,BasisOfRecord,
8 
darwin:Kingdom,kingdom,
9 
darwin:Phylum,phylum,
10 
darwin:Class,class,
11 
darwin:Order,order,
12 
darwin:Family,family,
13 
darwin:Genus,genus,
14 
darwin:Species,specificEpithet,
15 
darwin:Subspecies,infraspecificEpithet,
16 
darwin:ScientificNameAuthor,scientificNameAuthorship,
17 
darwin:IdentifiedBy,identifiedBy,
18 
darwin:YearIdentified,yearIdentified,
19 
darwin:MonthIdentified,monthIdentified,
20 
darwin:DayIdentified,dayIdentified,
21 
darwin:TypeStatus,TypeStatus,
22 
darwin:CollectorNumber,recordNumber/_alt/1,
23 
darwin:FieldNumber,recordNumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
24 
darwin:Collector,recordedBy,
25 
darwin:YearCollected,yearCollected,
26 
darwin:MonthCollected,monthCollected,
27 
darwin:DayCollected,dayCollected,
28 
darwin:JulianDay,day,
29 
darwin:TimeOfDay,eventTime,
30 
darwin:ContinentOcean,continent,
31 
darwin:Country,country,
32 
darwin:StateProvince,stateProvince,
33 
darwin:County,county,
34 
darwin:Locality,locality,
35 
darwin:Longitude,verbatimLongitude,
36 
darwin:Latitude,verbatimLatitude,
37 
darwin:CoordinatePrecision,coordinatePrecision,
38 
darwin:MinimumElevation,minimumElevationInMeters,
39 
darwin:MaximumElevation,maximumElevationInMeters,
40 
darwin:MinimumDepth,minimumDepthInMeters,
41 
darwin:MaximumDepth,maximumDepthInMeters,
42 
darwin:Sex,sex,
43 
darwin:PreparationType,preparations,
44 
darwin:IndividualCount,individualCount,
45 
darwin:PreviousCatalogNumber,otherCatalogNumbers,
46 
darwin:RelationshipType,relationshipOfResource,
47 
darwin:RelatedCatalogItem,relatedResourceID,
48 
darwin:Notes,fieldNotes,
inputs/XAL/Specimen/map.full.csv
1 
"XAL[Veg+,darwin:]:/content/record/",Veg+,Comments
2 
catalogNumber,catalogNumber
3 
class,class
4 
collectionCode,collectionCode
5 
collector,collector
6 
continentOcean,continentOcean
7 
coordinatePrecision,coordinatePrecision
8 
country,country
9 
county,county
10 
dayCollected,dayCollected
11 
dayIdentified,dayIdentified
12 
family,family
13 
genus,genus
14 
identifiedBy,identifiedBy
15 
individualCount,individualCount
16 
institutionCode,institutionCode
17 
kingdom,kingdom
18 
latitude,latitude
19 
locality,locality
20 
longitude,longitude
21 
maximumDepth,maximumDepth
22 
maximumElevation,maximumElevation
23 
minimumDepth,minimumDepth
24 
minimumElevation,minimumElevation
25 
monthCollected,monthCollected
26 
monthIdentified,monthIdentified
27 
notes,notes
28 
order,order
29 
phylum,phylum
30 
CollectorNumber,recordNumber/_alt/1,
31 
FieldNumber,recordNumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
32 
scientificName,scientificName
33 
scientificNameAuthor,scientificNameAuthor
34 
sex,sex
35 
species,species
36 
stateProvince,stateProvince
37 
subspecies,subspecies
38 
yearCollected,yearCollected
39 
yearIdentified,yearIdentified
1 
XAL[Veg+]:/content/record/,Veg+,Comments
2 
darwin:BasisOfRecord,BasisOfRecord,
3 
darwin:TypeStatus,TypeStatus,
4 
darwin:CatalogNumber,catalogNumber,
5 
darwin:Class,class,
6 
darwin:CollectionCode,collectionCode,
7 
darwin:ContinentOcean,continent,
8 
darwin:CoordinatePrecision,coordinatePrecision,
9 
darwin:Country,country,
10 
darwin:County,county,
11 
darwin:JulianDay,day,
12 
darwin:DayCollected,dayCollected,
13 
darwin:DayIdentified,dayIdentified,
14 
darwin:DateLastModified,dcterms:modified,
15 
darwin:TimeOfDay,eventTime,
16 
darwin:Family,family,
17 
darwin:Notes,fieldNotes,
18 
darwin:Genus,genus,
19 
darwin:IdentifiedBy,identifiedBy,
20 
darwin:IndividualCount,individualCount,
21 
darwin:Subspecies,infraspecificEpithet,
22 
darwin:InstitutionCode,institutionCode,
23 
darwin:Kingdom,kingdom,
24 
darwin:Locality,locality,
25 
darwin:MaximumDepth,maximumDepthInMeters,
26 
darwin:MaximumElevation,maximumElevationInMeters,
27 
darwin:MinimumDepth,minimumDepthInMeters,
28 
darwin:MinimumElevation,minimumElevationInMeters,
29 
darwin:MonthCollected,monthCollected,
30 
darwin:MonthIdentified,monthIdentified,
31 
darwin:Order,order,
32 
darwin:PreviousCatalogNumber,otherCatalogNumbers,
33 
darwin:Phylum,phylum,
34 
darwin:PreparationType,preparations,
35 
darwin:CollectorNumber,recordNumber/_alt/1,
36 
darwin:FieldNumber,recordNumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
37 
darwin:Collector,recordedBy,
38 
darwin:RelatedCatalogItem,relatedResourceID,
39 
darwin:RelationshipType,relationshipOfResource,
40 
darwin:ScientificName,scientificName,
41 
darwin:ScientificNameAuthor,scientificNameAuthorship,
42 
darwin:Sex,sex,
43 
darwin:Species,specificEpithet,
44 
darwin:StateProvince,stateProvince,
45 
darwin:Latitude,verbatimLatitude,
46 
darwin:Longitude,verbatimLongitude,
47 
darwin:YearCollected,yearCollected,
48 
darwin:YearIdentified,yearIdentified,
inputs/XAL/Specimen/VegBIEN.csv
1 
"XAL[Veg+,darwin:]:/content/record/",VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
3 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
5 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 
minimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8 
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
9 
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10 
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
11 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
12 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
13 
county,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14 
stateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15 
country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16 
continentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
17 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
18 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
19 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
20 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
21 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
22 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
23 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
24 
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
25 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
26 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
27 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
28 
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
29 
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
30 
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
31 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
32 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
33 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
34 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
35 
scientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
36 
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
37 
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
38 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
39 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
40 
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
41 
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
42 
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
43 
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
44 
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
45 
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
46 
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
47 
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
48 
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
49 
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
50 
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
51 
locality,/location/locationnarrative/_merge/1,
1 
XAL[Veg+]:/content/record/,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
darwin:InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
3 
darwin:CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4 
darwin:CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
5 
darwin:MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 
darwin:MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 
darwin:MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8 
darwin:MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
9 
darwin:MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10 
darwin:CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
11 
darwin:Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
12 
darwin:Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
13 
darwin:County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14 
darwin:StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15 
darwin:Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16 
darwin:ContinentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
17 
darwin:DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
18 
darwin:MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
19 
darwin:YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
20 
darwin:IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
21 
darwin:Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
22 
darwin:CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
23 
darwin:FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
24 
darwin:Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
25 
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
26 
darwin:CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
27 
darwin:InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
28 
darwin:CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
29 
darwin:FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber). It is also unused: `grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines."
30 
darwin:ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
31 
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
32 
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
33 
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
34 
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
35 
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
36 
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
37 
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
38 
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
39 
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
40 
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
41 
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
42 
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
43 
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
44 
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
45 
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
46 
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
47 
darwin:Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
48 
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
49 
darwin:MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
50 
darwin:MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
51 
darwin:Locality,/location/locationnarrative/_merge/1,
52 
darwin:BasisOfRecord,,** No join mapping for BasisOfRecord **
53 
darwin:DateLastModified,,** No join mapping for dcterms:modified **
54 
darwin:JulianDay,,** No join mapping for day **
55 
darwin:PreparationType,,** No join mapping for preparations **
56 
darwin:PreviousCatalogNumber,,** No join mapping for otherCatalogNumbers **
57 
darwin:RelatedCatalogItem,,** No join mapping for relatedResourceID **
58 
darwin:RelationshipType,,** No join mapping for relationshipOfResource **
59 
darwin:TimeOfDay,,** No join mapping for eventTime **
60 
darwin:TypeStatus,,** No join mapping for TypeStatus **
inputs/XAL/Specimen/unmapped_terms.csv
1 
dcterms:modified
2 
BasisOfRecord
3 
TypeStatus
1 4 
recordNumber/_alt/1
2 5 
recordNumber/_alt/2
6 
day
7 
eventTime
8 
preparations
9 
otherCatalogNumbers
10 
relationshipOfResource
11 
relatedResourceID

Also available in: Unified diff