Revision 3919
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/QMOR/test/import.specimens.xml.ref | ||
|---|---|---|
| 146 | 146 |
<locationevent> |
| 147 | 147 |
<taxonoccurrence> |
| 148 | 148 |
<aggregateoccurrence> |
| 149 |
<collectiondate><_date><date><_alt><2>$eventDate</2></_alt></date></_date></collectiondate>
|
|
| 149 |
<collectiondate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></collectiondate>
|
|
| 150 | 150 |
<plantobservation> |
| 151 | 151 |
<definedvalue fkey="tablerecord_id"> |
| 152 | 152 |
<userdefined_id> |
| mappings/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 15 | 15 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/#stateProvince,65 |
| 16 | 16 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63 |
| 17 | 17 |
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 |
| 18 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 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 | 21 |
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
| mappings/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 20 | 20 |
/*s/plot/plotName,/location/locationevent/authorlocationcode, |
| 21 | 21 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 22 | 22 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 23 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,/location/locationevent/obsenddate, |
|
| 24 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,/location/locationevent/obsstartdate, |
|
| 23 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
|
|
| 24 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 25 | 25 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/1, |
| 26 | 26 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/2, |
| 27 | 27 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,/location/locationevent/parent_id/locationevent/authorlocationcode, |
| ... | ... | |
| 48 | 48 |
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left, |
| 49 | 49 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc, |
| 50 | 50 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc, |
| 51 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate, |
|
| 51 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value,
|
|
| 52 | 52 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 53 | 53 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 54 | 54 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue", |
| inputs/XAL/test/import.specimens.xml.ref | ||
|---|---|---|
| 138 | 138 |
<collectiondate> |
| 139 | 139 |
<_date> |
| 140 | 140 |
<date> |
| 141 |
<_alt> |
|
| 142 |
<1> |
|
| 143 |
<_date> |
|
| 144 |
<day> |
|
| 145 |
<_nullIf> |
|
| 146 |
<null>0</null> |
|
| 147 |
<type>float</type> |
|
| 148 |
<value>$DayCollected</value> |
|
| 149 |
</_nullIf> |
|
| 150 |
</day> |
|
| 151 |
<month> |
|
| 152 |
<_nullIf> |
|
| 153 |
<null>0</null> |
|
| 154 |
<type>float</type> |
|
| 155 |
<value>$MonthCollected</value> |
|
| 156 |
</_nullIf> |
|
| 157 |
</month> |
|
| 158 |
<year> |
|
| 159 |
<_nullIf> |
|
| 160 |
<null>0</null> |
|
| 161 |
<type>float</type> |
|
| 162 |
<value>$YearCollected</value> |
|
| 163 |
</_nullIf> |
|
| 164 |
</year> |
|
| 165 |
</_date> |
|
| 166 |
</1> |
|
| 167 |
</_alt> |
|
| 141 |
<_dateRangeStart> |
|
| 142 |
<value> |
|
| 143 |
<_alt> |
|
| 144 |
<1> |
|
| 145 |
<_date> |
|
| 146 |
<day> |
|
| 147 |
<_nullIf> |
|
| 148 |
<null>0</null> |
|
| 149 |
<type>float</type> |
|
| 150 |
<value>$DayCollected</value> |
|
| 151 |
</_nullIf> |
|
| 152 |
</day> |
|
| 153 |
<month> |
|
| 154 |
<_nullIf> |
|
| 155 |
<null>0</null> |
|
| 156 |
<type>float</type> |
|
| 157 |
<value>$MonthCollected</value> |
|
| 158 |
</_nullIf> |
|
| 159 |
</month> |
|
| 160 |
<year> |
|
| 161 |
<_nullIf> |
|
| 162 |
<null>0</null> |
|
| 163 |
<type>float</type> |
|
| 164 |
<value>$YearCollected</value> |
|
| 165 |
</_nullIf> |
|
| 166 |
</year> |
|
| 167 |
</_date> |
|
| 168 |
</1> |
|
| 169 |
</_alt> |
|
| 170 |
</value> |
|
| 171 |
</_dateRangeStart> |
|
| 168 | 172 |
</date> |
| 169 | 173 |
</_date> |
| 170 | 174 |
</collectiondate> |
| inputs/XAL/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 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/#stateProvince,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",,http://rs.tdwg.org/dwc/terms/#country,63 |
| 13 | 13 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 14 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 15 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 16 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 14 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 15 |
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
|
|
| 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 | 19 |
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
| inputs/NY/test/import.specimens.xml.ref | ||
|---|---|---|
| 154 | 154 |
<collectiondate> |
| 155 | 155 |
<_date> |
| 156 | 156 |
<date> |
| 157 |
<_alt> |
|
| 158 |
<1> |
|
| 159 |
<_date> |
|
| 160 |
<day> |
|
| 161 |
<_nullIf> |
|
| 162 |
<null>0</null> |
|
| 163 |
<type>float</type> |
|
| 164 |
<value>$DayCollected</value> |
|
| 165 |
</_nullIf> |
|
| 166 |
</day> |
|
| 167 |
<month> |
|
| 168 |
<_nullIf> |
|
| 169 |
<null>0</null> |
|
| 170 |
<type>float</type> |
|
| 171 |
<value>$MonthCollected</value> |
|
| 172 |
</_nullIf> |
|
| 173 |
</month> |
|
| 174 |
<year> |
|
| 175 |
<_nullIf> |
|
| 176 |
<null>0</null> |
|
| 177 |
<type>float</type> |
|
| 178 |
<value>$YearCollected</value> |
|
| 179 |
</_nullIf> |
|
| 180 |
</year> |
|
| 181 |
</_date> |
|
| 182 |
</1> |
|
| 183 |
</_alt> |
|
| 157 |
<_dateRangeStart> |
|
| 158 |
<value> |
|
| 159 |
<_alt> |
|
| 160 |
<1> |
|
| 161 |
<_date> |
|
| 162 |
<day> |
|
| 163 |
<_nullIf> |
|
| 164 |
<null>0</null> |
|
| 165 |
<type>float</type> |
|
| 166 |
<value>$DayCollected</value> |
|
| 167 |
</_nullIf> |
|
| 168 |
</day> |
|
| 169 |
<month> |
|
| 170 |
<_nullIf> |
|
| 171 |
<null>0</null> |
|
| 172 |
<type>float</type> |
|
| 173 |
<value>$MonthCollected</value> |
|
| 174 |
</_nullIf> |
|
| 175 |
</month> |
|
| 176 |
<year> |
|
| 177 |
<_nullIf> |
|
| 178 |
<null>0</null> |
|
| 179 |
<type>float</type> |
|
| 180 |
<value>$YearCollected</value> |
|
| 181 |
</_nullIf> |
|
| 182 |
</year> |
|
| 183 |
</_date> |
|
| 184 |
</1> |
|
| 185 |
</_alt> |
|
| 186 |
</value> |
|
| 187 |
</_dateRangeStart> |
|
| 184 | 188 |
</date> |
| 185 | 189 |
</_date> |
| 186 | 190 |
</collectiondate> |
| inputs/NY/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 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 15 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 16 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 17 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 15 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 16 |
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
|
|
| 17 |
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
|
|
| 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 |
| inputs/Madidi/test/import.plots.xml.ref | ||
|---|---|---|
| 64 | 64 |
</commconcept_id> |
| 65 | 65 |
</commdetermination> |
| 66 | 66 |
</commclass> |
| 67 |
<obsstartdate>$First evaluation</obsstartdate>
|
|
| 67 |
<obsstartdate><_date><date><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 68 | 68 |
<soilobs> |
| 69 | 69 |
<acidity>$Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05)</acidity> |
| 70 | 70 |
<calcium>$Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)</calcium> |
| inputs/Madidi/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 13 | 13 |
Inventory name,/location/locationevent/authorlocationcode, |
| 14 | 14 |
Vegetation type,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 15 | 15 |
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type |
| 16 |
First evaluation,/location/locationevent/obsstartdate, |
|
| 16 |
First evaluation,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
|
|
| 17 | 17 |
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity, |
| 18 | 18 |
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium, |
| 19 | 19 |
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon, |
| inputs/UNCC/test/import.specimens.xml.ref | ||
|---|---|---|
| 33 | 33 |
<collectiondate> |
| 34 | 34 |
<_date> |
| 35 | 35 |
<date> |
| 36 |
<_alt> |
|
| 37 |
<1> |
|
| 38 |
<_date> |
|
| 39 |
<day> |
|
| 40 |
<_nullIf> |
|
| 41 |
<null>0</null> |
|
| 42 |
<type>float</type> |
|
| 43 |
<value>$collday</value> |
|
| 44 |
</_nullIf> |
|
| 45 |
</day> |
|
| 46 |
<month> |
|
| 47 |
<_nullIf> |
|
| 48 |
<null>0</null> |
|
| 49 |
<type>float</type> |
|
| 50 |
<value>$collmonth</value> |
|
| 51 |
</_nullIf> |
|
| 52 |
</month> |
|
| 53 |
<year> |
|
| 54 |
<_nullIf> |
|
| 55 |
<null>0</null> |
|
| 56 |
<type>float</type> |
|
| 57 |
<value>$collyear</value> |
|
| 58 |
</_nullIf> |
|
| 59 |
</year> |
|
| 60 |
</_date> |
|
| 61 |
</1> |
|
| 62 |
</_alt> |
|
| 36 |
<_dateRangeStart> |
|
| 37 |
<value> |
|
| 38 |
<_alt> |
|
| 39 |
<1> |
|
| 40 |
<_date> |
|
| 41 |
<day> |
|
| 42 |
<_nullIf> |
|
| 43 |
<null>0</null> |
|
| 44 |
<type>float</type> |
|
| 45 |
<value>$collday</value> |
|
| 46 |
</_nullIf> |
|
| 47 |
</day> |
|
| 48 |
<month> |
|
| 49 |
<_nullIf> |
|
| 50 |
<null>0</null> |
|
| 51 |
<type>float</type> |
|
| 52 |
<value>$collmonth</value> |
|
| 53 |
</_nullIf> |
|
| 54 |
</month> |
|
| 55 |
<year> |
|
| 56 |
<_nullIf> |
|
| 57 |
<null>0</null> |
|
| 58 |
<type>float</type> |
|
| 59 |
<value>$collyear</value> |
|
| 60 |
</_nullIf> |
|
| 61 |
</year> |
|
| 62 |
</_date> |
|
| 63 |
</1> |
|
| 64 |
</_alt> |
|
| 65 |
</value> |
|
| 66 |
</_dateRangeStart> |
|
| 63 | 67 |
</date> |
| 64 | 68 |
</_date> |
| 65 | 69 |
</collectiondate> |
| inputs/UNCC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 2 | 2 |
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/#county,66 |
| 3 | 3 |
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 |
| 4 | 4 |
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 |
| 5 |
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 6 |
collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
collyear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 5 |
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 6 |
collmonth,"/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 |
collyear,"/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 |
comment1,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
| 9 | 9 |
comment2,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
| 10 | 10 |
comment3,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/3,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
| inputs/ACAD/test/import.specimens.xml.ref | ||
|---|---|---|
| 58 | 58 |
<locationevent> |
| 59 | 59 |
<taxonoccurrence> |
| 60 | 60 |
<aggregateoccurrence> |
| 61 |
<collectiondate><_date><date><_alt><2>$eventDate</2></_alt></date></_date></collectiondate>
|
|
| 61 |
<collectiondate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></collectiondate>
|
|
| 62 | 62 |
<plantobservation> |
| 63 | 63 |
<specimenreplicate> |
| 64 | 64 |
<catalognumber_dwc>$catalogNumber</catalognumber_dwc> |
| inputs/ACAD/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 5 | 5 |
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 |
| 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 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 8 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 9 | 9 |
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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 |
| inputs/CVS/test/import.organisms.xml.ref | ||
|---|---|---|
| 36 | 36 |
</locationdetermination> |
| 37 | 37 |
<locationevent> |
| 38 | 38 |
<authorlocationcode>$authorObsCode</authorlocationcode> |
| 39 |
<obsstartdate><_date><date>$obsStartDate</date></_date></obsstartdate>
|
|
| 39 |
<obsstartdate><_date><date><_dateRangeStart><value><_date><date>$obsStartDate</date></_date></value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 40 | 40 |
<taxonoccurrence> |
| 41 | 41 |
<aggregateoccurrence><cover>$%cover</cover></aggregateoccurrence> |
| 42 | 42 |
<sourceaccessioncode><_alt><3>$currentTaxonName sec Weakley 2006</3></_alt></sourceaccessioncode> |
| inputs/CVS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 7 | 7 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 8 | 8 |
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", |
| 9 | 9 |
authorObsCode,/location/locationevent/authorlocationcode, |
| 10 |
obsStartDate,/location/locationevent/obsstartdate/_*/date, |
|
| 10 |
obsStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_*/date,
|
|
| 11 | 11 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 12 | 12 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3, |
| 13 | 13 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/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/_name/first", |
| inputs/ARIZ/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 14 | 14 |
StateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/#stateProvince,65 |
| 15 | 15 |
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63 |
| 16 | 16 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 17 |
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/0,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 18 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 19 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 20 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/0,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 18 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 19 |
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
|
|
| 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 | 23 |
CatalogNumberNumeric,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20 |
| inputs/GBIF/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 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/#county,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/#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 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 14 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 15 | 15 |
CatalogNO,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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 |
| inputs/NCU-NCSC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 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/#county,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",,"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 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 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 | 9 |
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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 |
Cultivated?,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 36 | 36 |
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 |
| 37 | 37 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 38 | 38 |
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 |
| 39 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 40 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 41 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 39 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 40 |
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
|
|
| 41 |
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
|
|
| 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 |
| inputs/MO/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 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/#stateProvince,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",,http://rs.tdwg.org/dwc/terms/#country,63 |
| 12 | 12 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 13 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 14 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 13 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 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 |
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 | 17 |
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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 |
| mappings/VegCSV-VegBIEN.specimens.csv | ||
|---|---|---|
| 74 | 74 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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/#establishmentMeans,30
|
| 75 | 75 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
| 76 | 76 |
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30 |
| 77 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 78 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 77 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 79 | 78 |
eventID,,,http://rs.tdwg.org/dwc/terms/#eventID,41 |
| 80 | 79 |
eventRemarks,,,http://rs.tdwg.org/dwc/terms/#eventRemarks,55 |
| 81 | 80 |
eventTime,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#eventTime,45 |
| ... | ... | |
| 203 | 202 |
phosphorus,/location/locationevent/soilobs/phosphorus,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2 |
| 204 | 203 |
phylum,"/location/locationevent/taxonoccurrence/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/#phylum,143 |
| 205 | 204 |
plotArea,/location/area,Table added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/area,11 |
| 206 |
plotEventEndDate,/location/locationevent/obsenddate,Table added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsEndDate",", 44, 6" |
|
| 207 |
plotEventStartDate,/location/locationevent/obsstartdate,Table added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsStartDate",", 44, 5" |
|
| 205 |
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,Table added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsEndDate",", 44, 6"
|
|
| 206 |
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,Table added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsStartDate",", 44, 5"
|
|
| 208 | 207 |
plotID,/location/locationevent/sourceaccessioncode,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0" |
| 209 | 208 |
plotID,/location/sourceaccessioncode/_merge/2/_alt/1,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0" |
| 210 | 209 |
plotName,/location/locationevent/authorlocationcode,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName,1 |
| inputs/SALVIAS-CSV/test/import.plots.xml.ref | ||
|---|---|---|
| 95 | 95 |
</commconcept_id> |
| 96 | 96 |
</commdetermination> |
| 97 | 97 |
</commclass> |
| 98 |
<obsenddate><_date><date>$date_finish</date></_date></obsenddate>
|
|
| 99 |
<obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
|
|
| 98 |
<obsenddate><_date><date><_dateRangeEnd><value><_date><date>$date_finish</date></_date></value></_dateRangeEnd></date></_date></obsenddate>
|
|
| 99 |
<obsstartdate><_date><date><_dateRangeStart><value><_date><date>$date_start</date></_date></value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 100 | 100 |
<precipitation>$precip_mm</precipitation> |
| 101 | 101 |
<soilobs> |
| 102 | 102 |
<acidity> |
| inputs/SALVIAS-CSV/test/import.organisms.xml.ref | ||
|---|---|---|
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<locationevent> |
| 5 | 5 |
<authorlocationcode>$subplot</authorlocationcode> |
| 6 |
<obsstartdate><_date><year>$census_date</year></_date></obsstartdate>
|
|
| 6 |
<obsstartdate><_date><date><_dateRangeStart><value><_date><year>$census_date</year></_date></value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 7 | 7 |
<parent_id> |
| 8 | 8 |
<locationevent> |
| 9 | 9 |
<location_id> |
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 16 | 16 |
plot_code,/location/locationevent/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| 17 | 17 |
holdridge_life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 18 | 18 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 19 |
date_finish,/location/locationevent/obsenddate/_*/date, |
|
| 20 |
date_start,/location/locationevent/obsstartdate/_*/date, |
|
| 19 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_*/date,
|
|
| 20 |
date_start,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_*/date,
|
|
| 21 | 21 |
precip_mm,/location/locationevent/precipitation, |
| 22 | 22 |
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value", |
| 23 | 23 |
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value", |
| inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegBIEN:,Comments |
| 2 | 2 |
subplot,/location/locationevent/authorlocationcode, |
| 3 |
census_date,/location/locationevent/obsstartdate/_date/year, |
|
| 3 |
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_date/year,
|
|
| 4 | 4 |
PLOT_ID,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/1,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above." |
| 5 | 5 |
plot_code,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/2,"Brad: Same as plotCode, above" |
| 6 | 6 |
plot_code,/location/locationevent/parent_id/locationevent/authorlocationcode,"Brad: Same as plotCode, above" |
| inputs/REMIB/test/import.specimens.xml.ref | ||
|---|---|---|
| 55 | 55 |
<collectiondate> |
| 56 | 56 |
<_date> |
| 57 | 57 |
<date> |
| 58 |
<_alt> |
|
| 59 |
<1> |
|
| 60 |
<_date> |
|
| 61 |
<day> |
|
| 62 |
<_nullIf> |
|
| 63 |
<null>0</null> |
|
| 64 |
<type>float</type> |
|
| 65 |
<value>$coll_day</value> |
|
| 66 |
</_nullIf> |
|
| 67 |
</day> |
|
| 68 |
<month> |
|
| 69 |
<_nullIf> |
|
| 70 |
<null>0</null> |
|
| 71 |
<type>float</type> |
|
| 72 |
<value>$coll_month</value> |
|
| 73 |
</_nullIf> |
|
| 74 |
</month> |
|
| 75 |
<year> |
|
| 76 |
<_nullIf> |
|
| 77 |
<null>0</null> |
|
| 78 |
<type>float</type> |
|
| 79 |
<value>$coll_year</value> |
|
| 80 |
</_nullIf> |
|
| 81 |
</year> |
|
| 82 |
</_date> |
|
| 83 |
</1> |
|
| 84 |
</_alt> |
|
| 58 |
<_dateRangeStart> |
|
| 59 |
<value> |
|
| 60 |
<_alt> |
|
| 61 |
<1> |
|
| 62 |
<_date> |
|
| 63 |
<day> |
|
| 64 |
<_nullIf> |
|
| 65 |
<null>0</null> |
|
| 66 |
<type>float</type> |
|
| 67 |
<value>$coll_day</value> |
|
| 68 |
</_nullIf> |
|
| 69 |
</day> |
|
| 70 |
<month> |
|
| 71 |
<_nullIf> |
|
| 72 |
<null>0</null> |
|
| 73 |
<type>float</type> |
|
| 74 |
<value>$coll_month</value> |
|
| 75 |
</_nullIf> |
|
| 76 |
</month> |
|
| 77 |
<year> |
|
| 78 |
<_nullIf> |
|
| 79 |
<null>0</null> |
|
| 80 |
<type>float</type> |
|
| 81 |
<value>$coll_year</value> |
|
| 82 |
</_nullIf> |
|
| 83 |
</year> |
|
| 84 |
</_date> |
|
| 85 |
</1> |
|
| 86 |
</_alt> |
|
| 87 |
</value> |
|
| 88 |
</_dateRangeStart> |
|
| 85 | 89 |
</date> |
| 86 | 90 |
</_date> |
| 87 | 91 |
</collectiondate> |
| inputs/REMIB/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 4 | 4 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/#county,66 |
| 5 | 5 |
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,"NCU-NCSC#State, REMIB#state, UNCC#state; http://rs.tdwg.org/dwc/terms/#stateProvince",65 |
| 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 |
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 8 |
coll_month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 9 |
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 7 |
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 8 |
coll_month,"/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
|
|
| 9 |
coll_year,"/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
|
|
| 10 | 10 |
acronym,/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 |
collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23 |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 51 | 51 |
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 52 | 52 |
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 |
| 53 | 53 |
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 54 |
EventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 55 |
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 56 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 57 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 58 |
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 59 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 60 |
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 61 |
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 62 |
EventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 63 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 64 |
CollectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 65 |
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 54 |
EventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 55 |
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 56 |
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 57 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 58 |
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
|
|
| 59 |
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
|
|
| 60 |
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
|
|
| 61 |
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
|
|
| 62 |
EventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 63 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 64 |
CollectedDate,/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
|
|
| 65 |
collectedDate,/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
|
|
| 66 | 66 |
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
| 67 | 67 |
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 |
| 68 | 68 |
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54 |
| inputs/SALVIAS/test/import.plots.xml.ref | ||
|---|---|---|
| 95 | 95 |
</commconcept_id> |
| 96 | 96 |
</commdetermination> |
| 97 | 97 |
</commclass> |
| 98 |
<obsenddate><_date><date>$date_finish</date></_date></obsenddate>
|
|
| 99 |
<obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
|
|
| 98 |
<obsenddate><_date><date><_dateRangeEnd><value><_date><date>$date_finish</date></_date></value></_dateRangeEnd></date></_date></obsenddate>
|
|
| 99 |
<obsstartdate><_date><date><_dateRangeStart><value><_date><date>$date_start</date></_date></value></_dateRangeStart></date></_date></obsstartdate>
|
|
| 100 | 100 |
<precipitation>$Precip</precipitation> |
| 101 | 101 |
<soilobs> |
| 102 | 102 |
<acidity> |
| inputs/SALVIAS/test/import.organisms.xml.ref | ||
|---|---|---|
| 58 | 58 |
</then> |
| 59 | 59 |
</_if> |
| 60 | 60 |
<aggregateoccurrence> |
| 61 |
<collectiondate><_date><date>$census_date</date></_date></collectiondate>
|
|
| 61 |
<collectiondate><_date><date><_dateRangeStart><value><_date><date>$census_date</date></_date></value></_dateRangeStart></date></_date></collectiondate>
|
|
| 62 | 62 |
<count>$NoInd</count> |
| 63 | 63 |
<cover>$cover_percent</cover> |
| 64 | 64 |
<definedvalue fkey="tablerecord_id"> |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 16 | 16 |
SiteCode,/location/locationevent/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| 17 | 17 |
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 18 | 18 |
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 19 |
date_finish,/location/locationevent/obsenddate/_*/date, |
|
| 20 |
date_start,/location/locationevent/obsstartdate/_*/date, |
|
| 19 |
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_*/date,
|
|
| 20 |
date_start,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_*/date,
|
|
| 21 | 21 |
Precip,/location/locationevent/precipitation, |
| 22 | 22 |
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value", |
| 23 | 23 |
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value", |
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 9 | 9 |
SourceVoucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
| 10 | 10 |
coll_number,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc/_alt/1,Brad: Incorrect. Map instead as for voucher_string |
| 11 | 11 |
SourceVoucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
| 12 |
census_date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date, |
|
| 12 |
census_date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_*/date,
|
|
| 13 | 13 |
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this." |
| 14 | 14 |
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover, |
| 15 | 15 |
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not." |
| inputs/U/test/import.specimens.xml.ref | ||
|---|---|---|
| 53 | 53 |
<collectiondate> |
| 54 | 54 |
<_date> |
| 55 | 55 |
<date> |
| 56 |
<_alt> |
|
| 57 |
<1> |
|
| 58 |
<_date> |
|
| 59 |
<day> |
|
| 60 |
<_nullIf> |
|
| 61 |
<null>0</null> |
|
| 62 |
<type>float</type> |
|
| 63 |
<value>$Colldd</value> |
|
| 64 |
</_nullIf> |
|
| 65 |
</day> |
|
| 66 |
<month> |
|
| 67 |
<_nullIf> |
|
| 68 |
<null>0</null> |
|
| 69 |
<type>float</type> |
|
| 70 |
<value>$Collmm</value> |
|
| 71 |
</_nullIf> |
|
| 72 |
</month> |
|
| 73 |
<year> |
|
| 74 |
<_nullIf> |
|
| 75 |
<null>0</null> |
|
| 76 |
<type>float</type> |
|
| 77 |
<value>$Collyy</value> |
|
| 78 |
</_nullIf> |
|
| 79 |
</year> |
|
| 80 |
</_date> |
|
| 81 |
</1> |
|
| 82 |
</_alt> |
|
| 56 |
<_dateRangeStart> |
|
| 57 |
<value> |
|
| 58 |
<_alt> |
|
| 59 |
<1> |
|
| 60 |
<_date> |
|
| 61 |
<day> |
|
| 62 |
<_nullIf> |
|
| 63 |
<null>0</null> |
|
| 64 |
<type>float</type> |
|
| 65 |
<value>$Colldd</value> |
|
| 66 |
</_nullIf> |
|
| 67 |
</day> |
|
| 68 |
<month> |
|
| 69 |
<_nullIf> |
|
| 70 |
<null>0</null> |
|
| 71 |
<type>float</type> |
|
| 72 |
<value>$Collmm</value> |
|
| 73 |
</_nullIf> |
|
| 74 |
</month> |
|
| 75 |
<year> |
|
| 76 |
<_nullIf> |
|
| 77 |
<null>0</null> |
|
| 78 |
<type>float</type> |
|
| 79 |
<value>$Collyy</value> |
|
| 80 |
</_nullIf> |
|
| 81 |
</year> |
|
| 82 |
</_date> |
|
| 83 |
</1> |
|
| 84 |
</_alt> |
|
| 85 |
</value> |
|
| 86 |
</_dateRangeStart> |
|
| 83 | 87 |
</date> |
| 84 | 88 |
</_date> |
| 85 | 89 |
</collectiondate> |
| inputs/U/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 2 | 2 |
Lat,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85 |
| 3 | 3 |
Long,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86 |
| 4 | 4 |
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 |
| 5 |
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 6 |
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 5 |
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 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 |
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 | 9 |
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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 |
| inputs/ARIZ/test/import.specimens.xml.ref | ||
|---|---|---|
| 149 | 149 |
<collectiondate> |
| 150 | 150 |
<_date> |
| 151 | 151 |
<date> |
| 152 |
<_alt> |
|
| 153 |
<0>$VerbatimCollectingDate</0> |
|
| 154 |
<1> |
|
| 155 |
<_date> |
|
| 156 |
<day> |
|
| 157 |
<_nullIf> |
|
| 158 |
<null>0</null> |
|
| 159 |
<type>float</type> |
|
| 160 |
<value>$DayCollected</value> |
|
| 161 |
</_nullIf> |
|
| 162 |
</day> |
|
| 163 |
<month> |
|
| 164 |
<_nullIf> |
|
| 165 |
<null>0</null> |
|
| 166 |
<type>float</type> |
|
| 167 |
<value>$MonthCollected</value> |
|
| 168 |
</_nullIf> |
|
| 169 |
</month> |
|
| 170 |
<year> |
|
| 171 |
<_nullIf> |
|
| 172 |
<null>0</null> |
|
| 173 |
<type>float</type> |
|
| 174 |
<value>$YearCollected</value> |
|
| 175 |
</_nullIf> |
|
| 176 |
</year> |
|
| 177 |
</_date> |
|
| 178 |
</1> |
|
| 179 |
</_alt> |
|
| 152 |
<_dateRangeStart> |
|
| 153 |
<value> |
|
| 154 |
<_alt> |
|
| 155 |
<0>$VerbatimCollectingDate</0> |
|
| 156 |
<1> |
|
| 157 |
<_date> |
|
| 158 |
<day> |
|
| 159 |
<_nullIf> |
|
| 160 |
<null>0</null> |
|
| 161 |
<type>float</type> |
|
| 162 |
<value>$DayCollected</value> |
|
| 163 |
</_nullIf> |
|
| 164 |
</day> |
|
| 165 |
<month> |
|
| 166 |
<_nullIf> |
|
| 167 |
<null>0</null> |
|
| 168 |
<type>float</type> |
|
| 169 |
<value>$MonthCollected</value> |
|
| 170 |
</_nullIf> |
|
| 171 |
</month> |
|
| 172 |
<year> |
|
| 173 |
<_nullIf> |
|
| 174 |
<null>0</null> |
|
| 175 |
<type>float</type> |
|
| 176 |
<value>$YearCollected</value> |
|
| 177 |
</_nullIf> |
|
| 178 |
</year> |
|
| 179 |
</_date> |
|
| 180 |
</1> |
|
| 181 |
</_alt> |
|
| 182 |
</value> |
|
| 183 |
</_dateRangeStart> |
|
| 180 | 184 |
</date> |
| 181 | 185 |
</_date> |
| 182 | 186 |
</collectiondate> |
| inputs/GBIF/test/import.specimens.xml.ref | ||
|---|---|---|
| 138 | 138 |
<locationevent> |
| 139 | 139 |
<taxonoccurrence> |
| 140 | 140 |
<aggregateoccurrence> |
| 141 |
<collectiondate><_date><date><_alt><2>$LatestDateCollected</2></_alt></date></_date></collectiondate>
|
|
| 141 |
<collectiondate><_date><date><_dateRangeStart><value><_alt><2>$LatestDateCollected</2></_alt></value></_dateRangeStart></date></_date></collectiondate>
|
|
| 142 | 142 |
<plantobservation> |
| 143 | 143 |
<specimenreplicate> |
| 144 | 144 |
<catalognumber_dwc>$CatalogNO</catalognumber_dwc> |
| inputs/NCU-NCSC/test/import.specimens.xml.ref | ||
|---|---|---|
| 63 | 63 |
<locationevent> |
| 64 | 64 |
<taxonoccurrence> |
| 65 | 65 |
<aggregateoccurrence> |
| 66 |
<collectiondate><_date><date><_alt><3>$Collect Date</3></_alt></date></_date></collectiondate>
|
|
| 66 |
<collectiondate><_date><date><_dateRangeStart><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeStart></date></_date></collectiondate>
|
|
| 67 | 67 |
<plantobservation> |
| 68 | 68 |
<specimenreplicate> |
| 69 | 69 |
<catalognumber_dwc>$Barcode</catalognumber_dwc> |
| inputs/SpeciesLink/test/import.specimens.xml.ref | ||
|---|---|---|
| 218 | 218 |
<collectiondate> |
| 219 | 219 |
<_date> |
| 220 | 220 |
<date> |
| 221 |
<_alt> |
|
| 222 |
<1> |
|
| 223 |
<_date> |
|
| 224 |
<day> |
|
| 225 |
<_nullIf> |
|
| 226 |
<null>0</null> |
|
| 227 |
<type>float</type> |
|
| 228 |
<value>$conceptual_darwin_2003_1_0_DayCollected</value> |
|
| 229 |
</_nullIf> |
|
| 230 |
</day> |
|
| 231 |
<month> |
|
| 232 |
<_nullIf> |
|
| 233 |
<null>0</null> |
|
| 234 |
<type>float</type> |
|
| 235 |
<value>$conceptual_darwin_2003_1_0_MonthCollected</value> |
|
| 236 |
</_nullIf> |
|
| 237 |
</month> |
|
| 238 |
<year> |
|
| 239 |
<_nullIf> |
|
| 240 |
<null>0</null> |
|
| 241 |
<type>float</type> |
|
| 242 |
<value>$conceptual_darwin_2003_1_0_YearCollected</value> |
|
| 243 |
</_nullIf> |
|
| 244 |
</year> |
|
| 245 |
</_date> |
|
| 246 |
</1> |
|
| 247 |
</_alt> |
|
| 221 |
<_dateRangeStart> |
|
| 222 |
<value> |
|
| 223 |
<_alt> |
|
| 224 |
<1> |
|
| 225 |
<_date> |
|
| 226 |
<day> |
|
| 227 |
<_nullIf> |
|
| 228 |
<null>0</null> |
|
| 229 |
<type>float</type> |
|
| 230 |
<value>$conceptual_darwin_2003_1_0_DayCollected</value> |
|
| 231 |
</_nullIf> |
|
| 232 |
</day> |
|
| 233 |
<month> |
|
| 234 |
<_nullIf> |
|
| 235 |
<null>0</null> |
|
| 236 |
<type>float</type> |
|
| 237 |
<value>$conceptual_darwin_2003_1_0_MonthCollected</value> |
|
| 238 |
</_nullIf> |
|
| 239 |
</month> |
|
| 240 |
<year> |
|
| 241 |
<_nullIf> |
|
| 242 |
<null>0</null> |
|
| 243 |
<type>float</type> |
|
| 244 |
<value>$conceptual_darwin_2003_1_0_YearCollected</value> |
|
| 245 |
</_nullIf> |
|
| 246 |
</year> |
|
| 247 |
</_date> |
|
| 248 |
</1> |
|
| 249 |
</_alt> |
|
| 250 |
</value> |
|
| 251 |
</_dateRangeStart> |
|
| 248 | 252 |
</date> |
| 249 | 253 |
</_date> |
| 250 | 254 |
</collectiondate> |
| inputs/MO/test/import.specimens.xml.ref | ||
|---|---|---|
| 137 | 137 |
<collectiondate> |
| 138 | 138 |
<_date> |
| 139 | 139 |
<date> |
| 140 |
<_alt> |
|
| 141 |
<1> |
|
| 142 |
<_date> |
|
| 143 |
<day> |
|
| 144 |
<_nullIf> |
|
| 145 |
<null>0</null> |
|
| 146 |
<type>float</type> |
|
| 147 |
<value>$DayCollected</value> |
|
| 148 |
</_nullIf> |
|
| 149 |
</day> |
|
| 150 |
<month> |
|
| 151 |
<_nullIf> |
|
| 152 |
<null>0</null> |
|
| 153 |
<type>float</type> |
|
| 154 |
<value>$MonthCollected</value> |
|
| 155 |
</_nullIf> |
|
| 156 |
</month> |
|
| 157 |
<year> |
|
| 158 |
<_nullIf> |
|
| 159 |
<null>0</null> |
|
| 160 |
<type>float</type> |
|
| 161 |
<value>$YearCollected</value> |
|
| 162 |
</_nullIf> |
|
| 163 |
</year> |
|
| 164 |
</_date> |
|
| 165 |
</1> |
|
| 166 |
</_alt> |
|
| 140 |
<_dateRangeStart> |
|
| 141 |
<value> |
|
| 142 |
<_alt> |
|
| 143 |
<1> |
|
| 144 |
<_date> |
|
| 145 |
<day> |
|
| 146 |
<_nullIf> |
|
| 147 |
<null>0</null> |
|
| 148 |
<type>float</type> |
|
| 149 |
<value>$DayCollected</value> |
|
| 150 |
</_nullIf> |
|
| 151 |
</day> |
|
| 152 |
<month> |
|
| 153 |
<_nullIf> |
|
| 154 |
<null>0</null> |
|
| 155 |
<type>float</type> |
|
| 156 |
<value>$MonthCollected</value> |
|
| 157 |
</_nullIf> |
|
| 158 |
</month> |
|
| 159 |
<year> |
|
| 160 |
<_nullIf> |
|
| 161 |
<null>0</null> |
|
| 162 |
<type>float</type> |
|
| 163 |
<value>$YearCollected</value> |
|
| 164 |
</_nullIf> |
|
| 165 |
</year> |
|
| 166 |
</_date> |
|
| 167 |
</1> |
|
| 168 |
</_alt> |
|
| 169 |
</value> |
|
| 170 |
</_dateRangeStart> |
|
| 167 | 171 |
</date> |
| 168 | 172 |
</_date> |
| 169 | 173 |
</collectiondate> |
| inputs/QMOR/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 14 | 14 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,http://rs.tdwg.org/dwc/terms/#stateProvince,65 |
| 15 | 15 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63 |
| 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 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 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 | 19 |
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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 |
| mappings/for_review/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 20 | 20 |
/*s/plot/plotName,//locationevent/authorlocationcode, |
| 21 | 21 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,//*/commname, |
| 22 | 22 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,//commconcept/commdescription, |
| 23 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,//locationevent/obsenddate, |
|
| 24 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,//locationevent/obsstartdate, |
|
| 23 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,//locationevent/obsenddate/_*/date,
|
|
| 24 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,//locationevent/obsstartdate/_*/date,
|
|
| 25 | 25 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,//location/sourceaccessioncode, |
| 26 | 26 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,//location/sourceaccessioncode, |
| 27 | 27 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,//locationevent/authorlocationcode, |
| ... | ... | |
| 48 | 48 |
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",//locationevent/taxonoccurrence, |
| 49 | 49 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc, |
| 50 | 50 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc, |
| 51 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//aggregateoccurrence/collectiondate, |
|
| 51 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//aggregateoccurrence/collectiondate/_*/date,
|
|
| 52 | 52 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,//aggregateoccurrence/count, |
| 53 | 53 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,//aggregateoccurrence/cover, |
| 54 | 54 |
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue", |
| mappings/DwC.cs-VegBIEN.specimens.csv | ||
|---|---|---|
| 25 | 25 |
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 |
| 26 | 26 |
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 |
| 27 | 27 |
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59 |
| 28 |
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 29 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44 |
|
| 30 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 31 |
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 32 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44 |
|
| 33 |
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 |
|
| 28 |
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 29 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
|
|
| 30 |
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
|
|
| 31 |
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
|
|
| 32 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
|
|
| 33 |
collectedDate,/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
|
|
| 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 |
Also available in: Unified diff
VegBIEN mappings: Wrapped dates in _date() and _dateRangeStart()/_dateRangeEnd(), to assist in importing date and date range values that PostgreSQL cannot parse. This will increase the import time, but hopefully also decrease the # of invalid values in the errors tables. (These functions can later be optimized to reduce the impact on import time.)