Revision 3972
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/NY/test/import.specimens.xml.ref | ||
|---|---|---|
| 214 | 214 |
<collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc> |
| 215 | 215 |
<collectionnumber> |
| 216 | 216 |
<_alt> |
| 217 |
<1><_alt><1>$CollectorNumber</1></_alt></1> |
|
| 218 |
<3>$FieldNumber</3> |
|
| 217 |
<1> |
|
| 218 |
<_alt> |
|
| 219 |
<1>$CollectorNumber</1> |
|
| 220 |
<2>$FieldNumber</2> |
|
| 221 |
</_alt> |
|
| 222 |
</1> |
|
| 219 | 223 |
</_alt> |
| 220 | 224 |
</collectionnumber> |
| 221 | 225 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
| inputs/NY/maps/DwC.specimens.csv | ||
|---|---|---|
| 1 | 1 |
NY[DwC],DwC,Comments |
| 2 | 2 |
key,,Not used because UniqueNYInternalRecordNumber is a better pkey |
| 3 |
FieldNumber,recordNumber,Usage inconsistent with DwC definition |
|
| 3 | 4 |
Locality,Locality/_merge/1, |
| 4 | 5 |
MinimumElevation,MinimumElevation/_nullIf:[null=.]/value, |
| 5 | 6 |
Notes,Notes/_merge/1, |
| inputs/NY/maps/DwC.specimens.full.csv | ||
|---|---|---|
| 14 | 14 |
DayCollected,DayCollected |
| 15 | 15 |
DayIdentified,DayIdentified |
| 16 | 16 |
Family,Family |
| 17 |
FieldNumber,FieldNumber |
|
| 18 | 17 |
Genus,Genus |
| 19 | 18 |
Habitat,Habitat |
| 20 | 19 |
IdentifiedBy,IdentifiedBy |
| ... | ... | |
| 52 | 51 |
YearCollected,YearCollected |
| 53 | 52 |
YearIdentified,YearIdentified |
| 54 | 53 |
UniqueNYInternalRecordNumber,occurrenceID, |
| 54 |
FieldNumber,recordNumber,Usage inconsistent with DwC definition |
|
| 55 | 55 |
key,,Not used because UniqueNYInternalRecordNumber is a better pkey |
| inputs/NY/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 21 | 21 |
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc", |
| 22 | 22 |
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| 23 | 23 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1, |
| 24 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
|
|
| 24 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,Usage inconsistent with DwC definition
|
|
| 25 | 25 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 26 | 26 |
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 27 | 27 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
| inputs/ARIZ/test/import.specimens.xml.ref | ||
|---|---|---|
| 200 | 200 |
<collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc> |
| 201 | 201 |
<collectionnumber> |
| 202 | 202 |
<_alt> |
| 203 |
<1><_alt><1>$CollectorNumber</1></_alt></1> |
|
| 204 |
<3>$FieldNumber</3> |
|
| 203 |
<1> |
|
| 204 |
<_alt> |
|
| 205 |
<1>$CollectorNumber</1> |
|
| 206 |
<2>$FieldNumber</2> |
|
| 207 |
</_alt> |
|
| 208 |
</1> |
|
| 205 | 209 |
</_alt> |
| 206 | 210 |
</collectionnumber> |
| 207 | 211 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
| inputs/ARIZ/maps/DwC.specimens.csv | ||
|---|---|---|
| 1 | 1 |
ARIZ[DwC],DwC,Comments |
| 2 | 2 |
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric |
| 3 | 3 |
CatalogNumberNumeric,CatalogNumber, |
| 4 |
FieldNumber,recordNumber,Usage inconsistent with DwC definition |
|
| 4 | 5 |
TimeCollected,TimeOfDay, |
| 5 | 6 |
VerbatimCollectingDate,eventDate/_alt/0, |
| 6 | 7 |
HorizontalDatum,,Not used |
| inputs/ARIZ/maps/DwC.specimens.full.csv | ||
|---|---|---|
| 17 | 17 |
DecimalLongitude,DecimalLongitude |
| 18 | 18 |
Family,Family |
| 19 | 19 |
FieldNotes,FieldNotes |
| 20 |
FieldNumber,FieldNumber |
|
| 21 | 20 |
Genus,Genus |
| 22 | 21 |
GlobalUniqueIdentifier,GlobalUniqueIdentifier |
| 23 | 22 |
HigherGeography,HigherGeography |
| ... | ... | |
| 61 | 60 |
LatLongComments,georeferenceRemarks, |
| 62 | 61 |
IdentificationModifier,identificationQualifier, |
| 63 | 62 |
AgeClass,lifeStage, |
| 63 |
FieldNumber,recordNumber,Usage inconsistent with DwC definition |
|
| 64 | 64 |
OriginalCoordinateSystem,verbatimSRS, |
| 65 | 65 |
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric |
| 66 | 66 |
HorizontalDatum,,Not used |
| inputs/ARIZ/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 23 | 23 |
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc", |
| 24 | 24 |
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| 25 | 25 |
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1, |
| 26 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
|
|
| 26 |
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,Usage inconsistent with DwC definition
|
|
| 27 | 27 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 28 | 28 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 29 | 29 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value", |
Also available in: Unified diff
inputs/NY, ARIZ: FieldNumber: Remapped to recordNumber because term usage was inconsistent with DwC definition. Datasources sometimes confuse this term, because it seems like the collection number, but is actually the author code for the event (VegBank's authorObsCode).