Project

General

Profile

« Previous | Next » 

Revision 3946

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv: catalogNumber: Added _if wrapper for mergability with VegCSV-VegBIEN.specimens.csv

View differences:

inputs/XAL/test/import.specimens.xml.ref
184 184 
                            <definedvalue>$Sex</definedvalue>
185 185 
                        </definedvalue>
186 186 
                        <specimenreplicate>
187 
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
187 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if>
188 188 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
189 189 
                            <collectionnumber>
190 190 
                                <_alt>
inputs/XAL/maps/VegBIEN.specimens.csv
16 16 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
17 17 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
18 18 
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",http://rs.tdwg.org/dwc/terms/#sex,26
19 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
19 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
20 20 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
21 21 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
22 22 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
inputs/NY/test/import.specimens.xml.ref
210 210 
                            <definedvalue>$Sex</definedvalue>
211 211 
                        </definedvalue>
212 212 
                        <specimenreplicate>
213 
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
213 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if>
214 214 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
215 215 
                            <collectionnumber>
216 216 
                                <_alt>
inputs/NY/maps/VegBIEN.specimens.csv
18 18 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
19 19 
PlantFungusDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2/_label[label=""plant fungus""]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
20 20 
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",http://rs.tdwg.org/dwc/terms/#sex,26
21 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 22 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
23 23 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
24 24 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
inputs/ACAD/test/import.specimens.xml.ref
61 61 
                    <collectiondate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></collectiondate>
62 62 
                    <plantobservation>
63 63 
                        <specimenreplicate>
64 
                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
64 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$catalogNumber</catalognumber_dwc></else></_if>
65 65 
                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>
66 66 
                            <collectionnumber>
67 67 
                                <_alt>
inputs/ACAD/maps/VegBIEN.specimens.csv
6 6 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
7 7 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://rs.tdwg.org/dwc/terms/#continent,59
8 8 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
9 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
9 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
10 10 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
11 11 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
12 12 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
inputs/U/test/import.specimens.xml.ref
90 90 
                    <notes>$Notes</notes>
91 91 
                    <plantobservation>
92 92 
                        <specimenreplicate>
93 
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
93 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$Barcode</catalognumber_dwc></else></_if>
94 94 
                            <collectionnumber><_alt><1><_alt><2>$Number</2></_alt></1></_alt></collectionnumber>
95 95 
                            <sourceaccessioncode>$ID</sourceaccessioncode>
96 96 
                        </specimenreplicate>
inputs/U/maps/VegBIEN.specimens.csv
6 6 
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
7 7 
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
8 8 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
9 
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
9 
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
10 10 
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
11 11 
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
12 12 
Detyy,"/location/locationevent/taxonoccurrence/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#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
inputs/ARIZ/test/import.specimens.xml.ref
196 196 
                            <definedvalue>$Sex</definedvalue>
197 197 
                        </definedvalue>
198 198 
                        <specimenreplicate>
199 
                            <catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc>
199 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc></else></_if>
200 200 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
201 201 
                            <collectionnumber>
202 202 
                                <_alt>
inputs/ARIZ/maps/VegBIEN.specimens.csv
20 20 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
21 21 
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
22 22 
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",http://rs.tdwg.org/dwc/terms/#sex,26
23 
CatalogNumberNumeric,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
23 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
24 24 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
25 25 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
26 26 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
inputs/GBIF/test/import.specimens.xml.ref
141 141 
                    <collectiondate><_date><date><_dateRangeStart><value><_alt><2>$LatestDateCollected</2></_alt></value></_dateRangeStart></date></_date></collectiondate>
142 142 
                    <plantobservation>
143 143 
                        <specimenreplicate>
144 
                            <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
144 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNO</catalognumber_dwc></else></_if>
145 145 
                            <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
146 146 
                            <institution_id><party><organizationname>$InstitutionCD</organizationname></party></institution_id>
147 147 
                        </specimenreplicate>
inputs/GBIF/maps/VegBIEN.specimens.csv
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/#stateProvince,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",,http://rs.tdwg.org/dwc/terms/#country,63
14 14 
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
15 
CatalogNO,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
15 
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
16 16 
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
17 17 
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
18 18 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
inputs/NCU-NCSC/test/import.specimens.xml.ref
66 66 
                    <collectiondate><_date><date><_dateRangeStart><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeStart></date></_date></collectiondate>
67 67 
                    <plantobservation>
68 68 
                        <specimenreplicate>
69 
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
69 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$Barcode</catalognumber_dwc></else></_if>
70 70 
                            <collectioncode_dwc>$SeriesName</collectioncode_dwc>
71 71 
                            <sourceaccessioncode>$Accession Number</sourceaccessioncode>
72 72 
                        </specimenreplicate>
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
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",,"NCU-NCSC#State, REMIB#state, UNCC#state; http://rs.tdwg.org/dwc/terms/#stateProvince",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",,http://rs.tdwg.org/dwc/terms/#country,63
8 8 
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate; http://rs.tdwg.org/dwc/terms/#eventDate,29; 44
9 
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
9 
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
10 10 
SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
11 11 
Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
12 12 
Cultivated?,"/location/locationevent/taxonoccurrence/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
inputs/SpeciesLink/test/import.specimens.xml.ref
270 270 
                            </definedvalue>
271 271 
                        </definedvalue>
272 272 
                        <specimenreplicate>
273 
                            <catalognumber_dwc>
274 
                                <_alt>
275 
                                    <0>$dwc_dwcore_CatalogNumber</0>
276 
                                    <1>$conceptual_darwin_2003_1_0_CatalogNumber</1>
277 
                                    <2>$dwc_terms_catalogNumber</2>
278 
                                </_alt>
279 
                            </catalognumber_dwc>
273 
                            <_if name="if indirect voucher">
274 
                                <else>
275 
                                    <catalognumber_dwc>
276 
                                        <_alt>
277 
                                            <0>$dwc_dwcore_CatalogNumber</0>
278 
                                            <1>$conceptual_darwin_2003_1_0_CatalogNumber</1>
279 
                                            <2>$dwc_terms_catalogNumber</2>
280 
                                        </_alt>
281 
                                    </catalognumber_dwc>
282 
                                </else>
283 
                            </_if>
280 284 
                            <collectioncode_dwc>
281 285 
                                <_alt>
282 286 
                                    <0>$dwc_dwcore_CollectionCode</0>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
42 42 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
43 43 
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",http://rs.tdwg.org/dwc/terms/#sex,26
44 44 
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",http://rs.tdwg.org/dwc/terms/#sex,26
45 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
46 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
45 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
46 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
47 47 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
48 48 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
49 49 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
inputs/MO/test/import.specimens.xml.ref
174 174 
                    <notes>$convertednotes</notes>
175 175 
                    <plantobservation>
176 176 
                        <specimenreplicate>
177 
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
177 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if>
178 178 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
179 179 
                            <collectionnumber><_alt><1><_alt><1>$CollectorNumber</1></_alt></1></_alt></collectionnumber>
180 180 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
inputs/MO/maps/VegBIEN.specimens.csv
14 14 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
15 15 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
16 16 
convertednotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
17 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
17 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
18 18 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
19 19 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
20 20 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
inputs/QMOR/test/import.specimens.xml.ref
158 158 
                            <definedvalue>$sex</definedvalue>
159 159 
                        </definedvalue>
160 160 
                        <specimenreplicate>
161 
                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
161 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$catalogNumber</catalognumber_dwc></else></_if>
162 162 
                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>
163 163 
                            <collectionnumber><_alt><2>$collectionID</2></_alt></collectionnumber>
164 164 
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
inputs/QMOR/maps/VegBIEN.specimens.csv
16 16 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://rs.tdwg.org/dwc/terms/#continent,59
17 17 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 18 
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",http://rs.tdwg.org/dwc/terms/#sex,26
19 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
19 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
20 20 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
21 21 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
22 22 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
mappings/DwC2-VegBIEN.specimens.csv
18 18 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 19 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
20 20 
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",http://rs.tdwg.org/dwc/terms/#sex,26
21 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 22 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
23 23 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
24 24 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
mappings/for_review/DwC2-VegBIEN.specimens.csv
18 18 
eventDate,//aggregateoccurrence/collectiondate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 19 
fieldNotes,//aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
20 20 
sex,"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/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/#sex,26
21 
catalogNumber,//specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 
catalogNumber,"//plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 22 
collectionCode,//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/#collectionCode,12
23 23 
recordNumber,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
24 24 
collectionID,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#collectionID,9
mappings/DwC-VegBIEN.specimens.csv
69 69 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
70 70 
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",http://rs.tdwg.org/dwc/terms/#sex,26
71 71 
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",http://rs.tdwg.org/dwc/terms/#sex,26
72 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
73 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
72 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
73 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
74 74 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
75 75 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
76 76 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
mappings/DwC.cs-VegBIEN.specimens.csv
34 34 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
35 35 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
36 36 
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",http://rs.tdwg.org/dwc/terms/#sex,26
37 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
37 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
38 38 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#collectionCode,12
39 39 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
40 40 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22

Also available in: Unified diff