Revision 3996
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/ACAD/test/import.specimens.xml.ref | ||
|---|---|---|
| 1 | 1 |
Put template: |
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 |
<elevation> |
|
| 5 |
<_alt> |
|
| 6 |
<1> |
|
| 7 |
<_replace> |
|
| 8 |
<\bca\.?></\bca\.?> |
|
| 9 |
<value>$verbatimElevation</value> |
|
| 10 |
</_replace> |
|
| 11 |
</1> |
|
| 12 |
</_alt> |
|
| 13 |
</elevation> |
|
| 4 | 14 |
<locationdetermination> |
| 5 | 15 |
<latitude> |
| 6 | 16 |
<_alt> |
| inputs/ACAD/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
ACAD[DwC],VegBIEN:,Comments |
| 2 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 2 | 3 |
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value", |
| 3 | 4 |
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value", |
| 4 | 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", |
| ... | ... | |
| 52 | 53 |
taxonRank,,** No non-empty join mapping for taxonRank ** |
| 53 | 54 |
type,,** No non-empty join mapping for type ** |
| 54 | 55 |
verbatimDepth,,** No non-empty join mapping for verbatimDepth ** |
| 55 |
verbatimElevation,,** No non-empty join mapping for verbatimElevation ** |
|
| inputs/ARIZ/test/import.specimens.xml.ref | ||
|---|---|---|
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<elevation> |
| 5 | 5 |
<_alt> |
| 6 |
<1> |
|
| 7 |
<_replace> |
|
| 8 |
<\bca\.?></\bca\.?> |
|
| 9 |
<value>$VerbatimElevation</value> |
|
| 10 |
</_replace> |
|
| 11 |
</1> |
|
| 6 | 12 |
<2> |
| 7 | 13 |
<_avg> |
| 8 | 14 |
<max> |
| inputs/ARIZ/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
ARIZ[DwC],VegBIEN:,Comments |
| 2 |
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 2 | 3 |
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 3 | 4 |
MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 4 | 5 |
MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 73 | 74 |
Tissues,,Not used |
| 74 | 75 |
TypeStatus,,** No non-empty join mapping for TypeStatus ** |
| 75 | 76 |
VerbatimDepth,,** No non-empty join mapping for VerbatimDepth ** |
| 76 |
VerbatimElevation,,** No non-empty join mapping for VerbatimElevation ** |
|
| inputs/NCU-NCSC/test/import.specimens.xml.ref | ||
|---|---|---|
| 1 | 1 |
Put template: |
| 2 | 2 |
<VegBIEN> |
| 3 | 3 |
<location id="-1"> |
| 4 |
<elevation> |
|
| 5 |
<_alt> |
|
| 6 |
<1> |
|
| 7 |
<_replace> |
|
| 8 |
<\bca\.?></\bca\.?> |
|
| 9 |
<value>$Elevation</value> |
|
| 10 |
</_replace> |
|
| 11 |
</1> |
|
| 12 |
</_alt> |
|
| 13 |
</elevation> |
|
| 4 | 14 |
<locationdetermination> |
| 5 | 15 |
<coordsaccuracy><_noCV><value><_alt><1>$Accuracy</1></_alt></value></_noCV></coordsaccuracy> |
| 6 | 16 |
<latitude> |
| inputs/NCU-NCSC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
NCU-NCSC[DwC],VegBIEN:,Comments |
| 2 |
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 2 | 3 |
Accuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1, |
| 3 | 4 |
Lat (-=S),"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
| 4 | 5 |
Long (-=W),"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
| ... | ... | |
| 17 | 18 |
Barcode,/location/sourceaccessioncode/_alt/2/_merge/3, |
| 18 | 19 |
Alt E/W,,** No input mapping for Alt E/W ** |
| 19 | 20 |
Alt N/S,,** No input mapping for Alt N/S ** |
| 20 |
Elevation,,** No non-empty join mapping for VerbatimElevation ** |
|
| 21 | 21 |
FIPS,,FIPS county code |
| 22 | 22 |
Format,,** No non-empty join mapping for PreparationType ** |
| 23 | 23 |
Typology,,** No non-empty join mapping for typeStatus ** |
| inputs/QMOR/test/import.specimens.xml.ref | ||
|---|---|---|
| 3 | 3 |
<location id="-1"> |
| 4 | 4 |
<elevation> |
| 5 | 5 |
<_alt> |
| 6 |
<1> |
|
| 7 |
<_replace> |
|
| 8 |
<\bca\.?></\bca\.?> |
|
| 9 |
<value>$verbatimElevation</value> |
|
| 10 |
</_replace> |
|
| 11 |
</1> |
|
| 6 | 12 |
<2> |
| 7 | 13 |
<_avg> |
| 8 | 14 |
<max> |
| ... | ... | |
| 154 | 160 |
</namedplace_id> |
| 155 | 161 |
</locationdetermination> |
| 156 | 162 |
<locationevent> |
| 163 |
<method_id><method><name>$samplingProtocol</name></method></method_id> |
|
| 157 | 164 |
<taxonoccurrence> |
| 158 | 165 |
<aggregateoccurrence> |
| 159 | 166 |
<collectiondate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></collectiondate> |
| inputs/QMOR/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
QMOR[DwC],VegBIEN:,Comments |
| 2 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 2 | 3 |
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 3 | 4 |
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 4 | 5 |
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 14 | 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", |
| 15 | 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", |
| 16 | 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", |
| 18 |
samplingProtocol,/location/locationevent/*_id/method/name, |
|
| 17 | 19 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2, |
| 18 | 20 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| 19 | 21 |
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" |
| ... | ... | |
| 71 | 73 |
preparations,,** No non-empty join mapping for preparations ** |
| 72 | 74 |
rights,,** No non-empty join mapping for rights ** |
| 73 | 75 |
rightsHolder,,** No non-empty join mapping for rightsHolder ** |
| 74 |
samplingProtocol,,** No non-empty join mapping for samplingProtocol ** |
|
| 75 | 76 |
taxonRank,,** No non-empty join mapping for taxonRank ** |
| 76 | 77 |
type,,** No non-empty join mapping for type ** |
| 77 | 78 |
typeStatus,,** No non-empty join mapping for typeStatus ** |
| 78 | 79 |
verbatimCoordinateSystem,,** No non-empty join mapping for verbatimCoordinateSystem ** |
| 79 | 80 |
verbatimCoordinates,,** No non-empty join mapping for verbatimCoordinates ** |
| 80 |
verbatimElevation,,** No non-empty join mapping for verbatimElevation ** |
|
| 81 | 81 |
verbatimEventDate,,** No non-empty join mapping for verbatimEventDate ** |
| 82 | 82 |
verbatimSRS,,** No non-empty join mapping for verbatimSRS ** |
| 83 | 83 |
waterBody,,** No non-empty join mapping for waterBody ** |
| mappings/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
DwC,VegBIEN:,Comments |
| 2 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 2 | 3 |
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 3 | 4 |
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| 4 | 5 |
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 15 | 16 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 16 | 17 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| 17 | 18 |
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename", |
| 19 |
samplingProtocol,/location/locationevent/*_id/method/name, |
|
| 18 | 20 |
fieldNumber,/location/locationevent/authoreventcode, |
| 19 | 21 |
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value, |
| 20 | 22 |
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count, |
| ... | ... | |
| 165 | 167 |
resourceID,, |
| 166 | 168 |
resourceRelationshipID,, |
| 167 | 169 |
samplingEffort,, |
| 168 |
samplingProtocol,, |
|
| 169 | 170 |
scientificNameID,, |
| 170 | 171 |
startDayOfYear,, |
| 171 | 172 |
subgenus,, |
| ... | ... | |
| 177 | 178 |
verbatimCoordinateSystem,, |
| 178 | 179 |
verbatimCoordinates,, |
| 179 | 180 |
verbatimDepth,, |
| 180 |
verbatimElevation,, |
|
| 181 | 181 |
verbatimEventDate,, |
| 182 | 182 |
verbatimSRS,, |
| 183 | 183 |
verbatimTaxonRank,, |
| mappings/for_review/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
DwC,VegBIEN:,Comments |
| 2 |
verbatimElevation,//location/elevation, |
|
| 2 | 3 |
maximumElevationInMeters,//location/elevation, |
| 3 | 4 |
minimumElevationInMeters,//location/elevation, |
| 4 | 5 |
minimumElevationInMeters,//location/elevationrange, |
| ... | ... | |
| 15 | 16 |
stateProvince,//locationdetermination/namedplace_id[rank=stateProvince]/placename, |
| 16 | 17 |
country,//locationdetermination/namedplace_id[rank=country]/placename, |
| 17 | 18 |
continent,//locationdetermination/namedplace_id[rank=continent]/placename, |
| 19 |
samplingProtocol,//method/name, |
|
| 18 | 20 |
fieldNumber,//locationevent/authoreventcode, |
| 19 | 21 |
eventDate,//aggregateoccurrence/collectiondate/_*/date, |
| 20 | 22 |
individualCount,//aggregateoccurrence/count, |
| ... | ... | |
| 165 | 167 |
resourceID,, |
| 166 | 168 |
resourceRelationshipID,, |
| 167 | 169 |
samplingEffort,, |
| 168 |
samplingProtocol,, |
|
| 169 | 170 |
scientificNameID,, |
| 170 | 171 |
startDayOfYear,, |
| 171 | 172 |
subgenus,, |
| ... | ... | |
| 177 | 178 |
verbatimCoordinateSystem,, |
| 178 | 179 |
verbatimCoordinates,, |
| 179 | 180 |
verbatimDepth,, |
| 180 |
verbatimElevation,, |
|
| 181 | 181 |
verbatimEventDate,, |
| 182 | 182 |
verbatimSRS,, |
| 183 | 183 |
verbatimTaxonRank,, |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
DwC,VegBIEN:,Comments |
| 2 |
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 3 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 2 | 4 |
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 3 | 5 |
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 4 | 6 |
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 51 | 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", |
| 52 | 54 |
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", |
| 53 | 55 |
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", |
| 56 |
SamplingProtocol,/location/locationevent/*_id/method/name, |
|
| 57 |
samplingProtocol,/location/locationevent/*_id/method/name, |
|
| 54 | 58 |
FieldNumber,/location/locationevent/authoreventcode, |
| 55 | 59 |
fieldNumber,/location/locationevent/authoreventcode, |
| 56 | 60 |
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 |
| ... | ... | |
| 300 | 304 |
Rights,,** No non-empty join mapping for rights ** |
| 301 | 305 |
RightsHolder,,** No non-empty join mapping for rightsHolder ** |
| 302 | 306 |
SamplingEffort,,** No non-empty join mapping for samplingEffort ** |
| 303 |
SamplingProtocol,,** No non-empty join mapping for samplingProtocol ** |
|
| 304 | 307 |
ScientificNameID,,** No non-empty join mapping for scientificNameID ** |
| 305 | 308 |
StartDayOfYear,,** No non-empty join mapping for startDayOfYear ** |
| 306 | 309 |
Subgenus,,** No non-empty join mapping for subgenus ** |
| ... | ... | |
| 314 | 317 |
VerbatimCoordinateSystem,,** No non-empty join mapping for verbatimCoordinateSystem ** |
| 315 | 318 |
VerbatimCoordinates,,** No non-empty join mapping for verbatimCoordinates ** |
| 316 | 319 |
VerbatimDepth,,** No non-empty join mapping for verbatimDepth ** |
| 317 |
VerbatimElevation,,** No non-empty join mapping for verbatimElevation ** |
|
| 318 | 320 |
VerbatimEventDate,,** No non-empty join mapping for verbatimEventDate ** |
| 319 | 321 |
VerbatimSRS,,** No non-empty join mapping for verbatimSRS ** |
| 320 | 322 |
VerbatimTaxonRank,,** No non-empty join mapping for verbatimTaxonRank ** |
| ... | ... | |
| 446 | 448 |
rights,,** No non-empty join mapping for dcterms:rights ** |
| 447 | 449 |
rightsHolder,,** No non-empty join mapping for dcterms:rightsHolder ** |
| 448 | 450 |
samplingEffort,, |
| 449 |
samplingProtocol,, |
|
| 450 | 451 |
scientificNameID,, |
| 451 | 452 |
startDayOfYear,, |
| 452 | 453 |
subgenus,, |
| ... | ... | |
| 460 | 461 |
verbatimCoordinateSystem,, |
| 461 | 462 |
verbatimCoordinates,, |
| 462 | 463 |
verbatimDepth,, |
| 463 |
verbatimElevation,, |
|
| 464 | 464 |
verbatimEventDate,, |
| 465 | 465 |
verbatimSRS,, |
| 466 | 466 |
verbatimTaxonRank,, |
| mappings/DwC.cs-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
DwC,VegBIEN:,Comments |
| 2 |
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 2 | 3 |
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 3 | 4 |
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 4 | 5 |
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value", |
| ... | ... | |
| 25 | 26 |
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", |
| 26 | 27 |
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", |
| 27 | 28 |
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", |
| 29 |
samplingProtocol,/location/locationevent/*_id/method/name, |
|
| 28 | 30 |
fieldNumber,/location/locationevent/authoreventcode, |
| 29 | 31 |
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 |
| 30 | 32 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 212 | 214 |
rights,,** No non-empty join mapping for dcterms:rights ** |
| 213 | 215 |
rightsHolder,,** No non-empty join mapping for dcterms:rightsHolder ** |
| 214 | 216 |
samplingEffort,, |
| 215 |
samplingProtocol,, |
|
| 216 | 217 |
scientificNameID,, |
| 217 | 218 |
startDayOfYear,, |
| 218 | 219 |
subgenus,, |
| ... | ... | |
| 226 | 227 |
verbatimCoordinateSystem,, |
| 227 | 228 |
verbatimCoordinates,, |
| 228 | 229 |
verbatimDepth,, |
| 229 |
verbatimElevation,, |
|
| 230 | 230 |
verbatimEventDate,, |
| 231 | 231 |
verbatimSRS,, |
| 232 | 232 |
verbatimTaxonRank,, |
Also available in: Unified diff
mappings/DwC2-VegBIEN.specimens.csv: Mapped verbatimElevation and samplingProtocol, for mergability with VegCSV