Revision 4005
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/MT/test/import.specimens.xml.ref | ||
|---|---|---|
| 118 | 118 |
</taxonoccurrence> |
| 119 | 119 |
</locationevent> |
| 120 | 120 |
<locationnarrative><_merge><1>$locality</1></_merge></locationnarrative> |
| 121 |
<sourceaccessioncode>$id</sourceaccessioncode>
|
|
| 121 |
<sourceaccessioncode><_alt><1>$id</1></_alt></sourceaccessioncode>
|
|
| 122 | 122 |
</location> |
| 123 | 123 |
</VegBIEN> |
| 124 | 124 |
Inserted 22 new rows into database |
| inputs/MT/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 12 | 12 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
| 13 | 13 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
| 14 | 14 |
locality,/location/locationnarrative/_merge/1, |
| 15 |
id,/location/sourceaccessioncode, |
|
| 15 |
id,/location/sourceaccessioncode/_alt/1,
|
|
| 16 | 16 |
basisOfRecord,,** No non-empty join mapping for basisOfRecord ** |
| 17 | 17 |
countryCode,,** No non-empty join mapping for countryCode ** |
| 18 | 18 |
datasetName,,** No non-empty join mapping for datasetName ** |
| inputs/NY/test/import.specimens.xml.ref | ||
|---|---|---|
| 419 | 419 |
</3> |
| 420 | 420 |
</_merge> |
| 421 | 421 |
</locationnarrative> |
| 422 |
<sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
|
|
| 422 |
<sourceaccessioncode><_alt><1>$UniqueNYInternalRecordNumber</1></_alt></sourceaccessioncode>
|
|
| 423 | 423 |
</location> |
| 424 | 424 |
</VegBIEN> |
| 425 | 425 |
Inserted 39 new rows into database |
| inputs/NY/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 51 | 51 |
Substrate,"/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value", |
| 52 | 52 |
Vegetation,"/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value", |
| 53 | 53 |
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 54 |
UniqueNYInternalRecordNumber,/location/sourceaccessioncode, |
|
| 54 |
UniqueNYInternalRecordNumber,/location/sourceaccessioncode/_alt/1,
|
|
| 55 | 55 |
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord ** |
| 56 | 56 |
DateLastModified,,** No non-empty join mapping for DateLastModified ** |
| 57 | 57 |
JulianDay,,** No non-empty join mapping for JulianDay ** |
| inputs/UNCC/test/import.specimens.xml.ref | ||
|---|---|---|
| 203 | 203 |
</3> |
| 204 | 204 |
</_merge> |
| 205 | 205 |
</locationnarrative> |
| 206 |
<sourceaccessioncode>$accession</sourceaccessioncode>
|
|
| 206 |
<sourceaccessioncode><_alt><1>$accession</1></_alt></sourceaccessioncode>
|
|
| 207 | 207 |
</location> |
| 208 | 208 |
</VegBIEN> |
| 209 | 209 |
Inserted 22 new rows into database |
| inputs/UNCC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 30 | 30 |
collector3,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/4, |
| 31 | 31 |
locality,/location/locationnarrative/_merge/1, |
| 32 | 32 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 33 |
accession,/location/sourceaccessioncode, |
|
| 33 |
accession,/location/sourceaccessioncode/_alt/1,
|
|
| 34 | 34 |
filler,,"Where used, same as family" |
| 35 | 35 |
flower,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?" |
| 36 | 36 |
fruit,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?" |
| inputs/ACAD/test/import.specimens.xml.ref | ||
|---|---|---|
| 187 | 187 |
</3> |
| 188 | 188 |
</_merge> |
| 189 | 189 |
</locationnarrative> |
| 190 |
<sourceaccessioncode>$id</sourceaccessioncode>
|
|
| 190 |
<sourceaccessioncode><_alt><1>$id</1></_alt></sourceaccessioncode>
|
|
| 191 | 191 |
</location> |
| 192 | 192 |
</VegBIEN> |
| 193 | 193 |
Inserted 38 new rows into database |
| inputs/ACAD/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 33 | 33 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 34 | 34 |
locality,/location/locationnarrative/_merge/1, |
| 35 | 35 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 36 |
id,/location/sourceaccessioncode, |
|
| 36 |
id,/location/sourceaccessioncode/_alt/1,
|
|
| 37 | 37 |
basisOfRecord,,** No non-empty join mapping for basisOfRecord ** |
| 38 | 38 |
bibliographicCitation,,** No non-empty join mapping for bibliographicCitation ** |
| 39 | 39 |
dynamicProperties,,** No non-empty join mapping for dynamicProperties ** |
| inputs/REMIB/test/import.specimens.xml.ref | ||
|---|---|---|
| 158 | 158 |
</3> |
| 159 | 159 |
</_merge> |
| 160 | 160 |
</locationnarrative> |
| 161 |
<sourceaccessioncode>$accession_number</sourceaccessioncode>
|
|
| 161 |
<sourceaccessioncode><_alt><1>$accession_number</1></_alt></sourceaccessioncode>
|
|
| 162 | 162 |
</location> |
| 163 | 163 |
</VegBIEN> |
| 164 | 164 |
Inserted 26 new rows into database |
| inputs/REMIB/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 16 | 16 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 17 | 17 |
locality,/location/locationnarrative/_merge/1, |
| 18 | 18 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 19 |
accession_number,/location/sourceaccessioncode, |
|
| 19 |
accession_number,/location/sourceaccessioncode/_alt/1,
|
|
| 20 | 20 |
lat_min,,** No input mapping for lat_min ** |
| 21 | 21 |
lat_sec,,** No input mapping for lat_sec ** |
| 22 | 22 |
long_min,,** No input mapping for long_min ** |
| inputs/U/test/import.specimens.xml.ref | ||
|---|---|---|
| 208 | 208 |
</3> |
| 209 | 209 |
</_merge> |
| 210 | 210 |
</locationnarrative> |
| 211 |
<sourceaccessioncode>$ID</sourceaccessioncode>
|
|
| 211 |
<sourceaccessioncode><_alt><1>$ID</1></_alt></sourceaccessioncode>
|
|
| 212 | 212 |
</location> |
| 213 | 213 |
</VegBIEN> |
| 214 | 214 |
Inserted 26 new rows into database |
| inputs/U/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 23 | 23 |
Newgazett,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row |
| 24 | 24 |
Locnotes,/location/locationnarrative/_merge/2/_merge/2, |
| 25 | 25 |
Ecology,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 26 |
ID,/location/sourceaccessioncode, |
|
| 26 |
ID,/location/sourceaccessioncode/_alt/1,
|
|
| 27 | 27 |
Alt,,What is this? |
| 28 | 28 |
Alt2,,What is this? |
| 29 | 29 |
Coorsyst,,** No input mapping for Coorsyst ** |
| inputs/ARIZ/test/import.specimens.xml.ref | ||
|---|---|---|
| 391 | 391 |
</waterdepth> |
| 392 | 392 |
</locationevent> |
| 393 | 393 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative> |
| 394 |
<sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
|
|
| 394 |
<sourceaccessioncode><_alt><1>$GlobalUniqueIdentifier</1></_alt></sourceaccessioncode>
|
|
| 395 | 395 |
</location> |
| 396 | 396 |
</VegBIEN> |
| 397 | 397 |
Inserted 38 new rows into database |
| inputs/ARIZ/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 53 | 53 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 54 | 54 |
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 55 | 55 |
Locality,/location/locationnarrative/_merge/1, |
| 56 |
GlobalUniqueIdentifier,/location/sourceaccessioncode, |
|
| 56 |
GlobalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
|
|
| 57 | 57 |
AgeClass,,** No non-empty join mapping for lifeStage ** |
| 58 | 58 |
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord ** |
| 59 | 59 |
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric |
| inputs/NCU-NCSC/test/import.specimens.xml.ref | ||
|---|---|---|
| 138 | 138 |
</taxondetermination> |
| 139 | 139 |
</taxonoccurrence> |
| 140 | 140 |
</locationevent> |
| 141 |
<sourceaccessioncode>$Accession Number</sourceaccessioncode>
|
|
| 141 |
<sourceaccessioncode><_alt><1>$Accession Number</1></_alt></sourceaccessioncode>
|
|
| 142 | 142 |
</location> |
| 143 | 143 |
</VegBIEN> |
| 144 | 144 |
Inserted 26 new rows into database |
| inputs/NCU-NCSC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 15 | 15 |
Cultivated?,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Yes=cultivated,No=wild]/value", |
| 16 | 16 |
Cultivated?,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value", |
| 17 | 17 |
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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", |
| 18 |
Accession Number,/location/sourceaccessioncode, |
|
| 18 |
Accession Number,/location/sourceaccessioncode/_alt/1,
|
|
| 19 | 19 |
Alt E/W,,** No input mapping for Alt E/W ** |
| 20 | 20 |
Alt N/S,,** No input mapping for Alt N/S ** |
| 21 | 21 |
FIPS,,FIPS county code |
| inputs/SpeciesLink/test/import.specimens.xml.ref | ||
|---|---|---|
| 640 | 640 |
</1> |
| 641 | 641 |
</_merge> |
| 642 | 642 |
</locationnarrative> |
| 643 |
<sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
|
|
| 643 |
<sourceaccessioncode><_alt><1>$dwc_dwcore_GlobalUniqueIdentifier</1></_alt></sourceaccessioncode>
|
|
| 644 | 644 |
</location> |
| 645 | 645 |
</VegBIEN> |
| 646 | 646 |
Inserted 40 new rows into database |
| inputs/SpeciesLink/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 106 | 106 |
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 107 | 107 |
Locality,/location/locationnarrative/_merge/1, |
| 108 | 108 |
locality,/location/locationnarrative/_merge/1, |
| 109 |
GlobalUniqueIdentifier,/location/sourceaccessioncode, |
|
| 109 |
GlobalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
|
|
| 110 | 110 |
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord ** |
| 111 | 111 |
DateLastModified,,** No non-empty join mapping for DateLastModified ** |
| 112 | 112 |
DayOfYear,,** No non-empty join mapping for JulianDay ** |
| inputs/QMOR/test/import.specimens.xml.ref | ||
|---|---|---|
| 292 | 292 |
</3> |
| 293 | 293 |
</_merge> |
| 294 | 294 |
</locationnarrative> |
| 295 |
<sourceaccessioncode>$id</sourceaccessioncode>
|
|
| 295 |
<sourceaccessioncode><_alt><1>$id</1></_alt></sourceaccessioncode>
|
|
| 296 | 296 |
</location> |
| 297 | 297 |
</VegBIEN> |
| 298 | 298 |
Inserted 34 new rows into database |
| inputs/QMOR/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 45 | 45 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 46 | 46 |
locality,/location/locationnarrative/_merge/1, |
| 47 | 47 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 48 |
id,/location/sourceaccessioncode, |
|
| 48 |
id,/location/sourceaccessioncode/_alt/1,
|
|
| 49 | 49 |
acceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage ** |
| 50 | 50 |
basisOfRecord,,** No non-empty join mapping for basisOfRecord ** |
| 51 | 51 |
behavior,,** No non-empty join mapping for behavior ** |
| mappings/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 55 | 55 |
locality,/location/locationnarrative/_merge/1, |
| 56 | 56 |
verbatimLocality,/location/locationnarrative/_merge/2, |
| 57 | 57 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 58 |
locationID,/location/sourceaccessioncode,
|
|
| 59 |
occurrenceID,/location/sourceaccessioncode,
|
|
| 58 |
occurrenceID,/location/sourceaccessioncode/_alt/1,
|
|
| 59 |
locationID,/location/sourceaccessioncode/_alt/2,
|
|
| 60 | 60 |
acceptedNameUsage,, |
| 61 | 61 |
acceptedNameUsageID,, |
| 62 | 62 |
associatedMedia,, |
| mappings/for_review/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 55 | 55 |
locality,//location/locationnarrative, |
| 56 | 56 |
verbatimLocality,//location/locationnarrative, |
| 57 | 57 |
habitat,"//location/locationnarrative/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 58 |
occurrenceID,//location/sourceaccessioncode, |
|
| 58 | 59 |
locationID,//location/sourceaccessioncode, |
| 59 |
occurrenceID,//location/sourceaccessioncode, |
|
| 60 | 60 |
acceptedNameUsage,, |
| 61 | 61 |
acceptedNameUsageID,, |
| 62 | 62 |
associatedMedia,, |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 173 | 173 |
verbatimLocality,/location/locationnarrative/_merge/2, |
| 174 | 174 |
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 175 | 175 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 176 |
GlobalUniqueIdentifier,/location/sourceaccessioncode, |
|
| 177 |
Id,/location/sourceaccessioncode, |
|
| 178 |
LocationID,/location/sourceaccessioncode,
|
|
| 179 |
OccurrenceID,/location/sourceaccessioncode,
|
|
| 180 |
globalUniqueIdentifier,/location/sourceaccessioncode,
|
|
| 181 |
id,/location/sourceaccessioncode,
|
|
| 182 |
locationID,/location/sourceaccessioncode,
|
|
| 183 |
occurrenceID,/location/sourceaccessioncode,
|
|
| 176 |
GlobalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
|
|
| 177 |
Id,/location/sourceaccessioncode/_alt/1,
|
|
| 178 |
OccurrenceID,/location/sourceaccessioncode/_alt/1,
|
|
| 179 |
globalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
|
|
| 180 |
id,/location/sourceaccessioncode/_alt/1,
|
|
| 181 |
occurrenceID,/location/sourceaccessioncode/_alt/1,
|
|
| 182 |
LocationID,/location/sourceaccessioncode/_alt/2,
|
|
| 183 |
locationID,/location/sourceaccessioncode/_alt/2,
|
|
| 184 | 184 |
AcceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage ** |
| 185 | 185 |
AcceptedNameUsageID,,** No non-empty join mapping for acceptedNameUsageID ** |
| 186 | 186 |
AccessRights,,** No non-empty join mapping for accessRights ** |
| mappings/DwC.cs-VegBIEN.specimens.csv | ||
|---|---|---|
| 86 | 86 |
locality,/location/locationnarrative/_merge/1, |
| 87 | 87 |
verbatimLocality,/location/locationnarrative/_merge/2, |
| 88 | 88 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 89 |
globalUniqueIdentifier,/location/sourceaccessioncode, |
|
| 90 |
id,/location/sourceaccessioncode, |
|
| 91 |
locationID,/location/sourceaccessioncode,
|
|
| 92 |
occurrenceID,/location/sourceaccessioncode,
|
|
| 89 |
globalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
|
|
| 90 |
id,/location/sourceaccessioncode/_alt/1,
|
|
| 91 |
occurrenceID,/location/sourceaccessioncode/_alt/1,
|
|
| 92 |
locationID,/location/sourceaccessioncode/_alt/2,
|
|
| 93 | 93 |
acceptedNameUsage,, |
| 94 | 94 |
acceptedNameUsageID,, |
| 95 | 95 |
accessRights,,** No non-empty join mapping for dcterms:accessRights ** |
Also available in: Unified diff
mappings/DwC2-VegBIEN.specimens.csv: mappings to /location/sourceaccessioncode: Added _alt to prioritize them properly