Revision 12963
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/HVAA/Specimen/map.csv | ||
|---|---|---|
| 70 | 70 |
rights,rights,, |
| 71 | 71 |
rightsHolder,dataOwners,, |
| 72 | 72 |
accessRights,accessRights,, |
| 73 |
symbiotaId,occurrenceID,, |
|
| 73 |
symbiotaId,dataProviderRecordID,, |
|
| trunk/inputs/HVAA/Specimen/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
<location> |
| 10 | 10 |
<authorlocationcode> |
| 11 | 11 |
<_alt> |
| 12 |
<1>$occurrenceID</1>
|
|
| 12 |
<1>$dataProviderRecordID</1>
|
|
| 13 | 13 |
<2> |
| 14 | 14 |
<_join> |
| 15 | 15 |
<1>$specimen_duplicate_institutions</1> |
| ... | ... | |
| 114 | 114 |
</sourcename> |
| 115 | 115 |
</sourcelist> |
| 116 | 116 |
</duplicate_institutions_sourcelist_id> |
| 117 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 117 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 118 | 118 |
</specimenreplicate> |
| 119 | 119 |
</plantobservation> |
| 120 | 120 |
</aggregateoccurrence> |
| ... | ... | |
| 135 | 135 |
<value>$establishmentMeans</value> |
| 136 | 136 |
</_map> |
| 137 | 137 |
</isnative> |
| 138 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 138 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 139 | 139 |
<taxondetermination> |
| 140 | 140 |
<party_id><party><fullname>$identifiedBy</fullname></party></party_id> |
| 141 | 141 |
<taxonverbatim_id> |
| trunk/inputs/HVAA/Specimen/new_terms.csv | ||
|---|---|---|
| 1 |
symbiotaId,occurrenceID,, |
|
| 1 |
symbiotaId,dataProviderRecordID,, |
|
| trunk/inputs/NCU/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
NCU,VegCore,Filter,Comments |
| 2 | 2 |
row_num,*row_num,, |
| 3 |
SpecimenPK,occurrenceID,,
|
|
| 3 |
SpecimenPK,dataProviderRecordID,,
|
|
| 4 | 4 |
DerivedFromID,*DerivedFromID,, |
| 5 | 5 |
CollectionObjectTypeID,*CollectionObjectTypeID,, |
| 6 | 6 |
CollectionObjectID,*CollectionObjectID,, |
| trunk/inputs/NCU/Specimen/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
<location> |
| 10 | 10 |
<authorlocationcode> |
| 11 | 11 |
<_alt> |
| 12 |
<1>$occurrenceID</1>
|
|
| 12 |
<1>$dataProviderRecordID</1>
|
|
| 13 | 13 |
<2> |
| 14 | 14 |
<_join> |
| 15 | 15 |
<1>$specimen_duplicate_institutions</1> |
| ... | ... | |
| 45 | 45 |
</sourcename> |
| 46 | 46 |
</sourcelist> |
| 47 | 47 |
</duplicate_institutions_sourcelist_id> |
| 48 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 48 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 49 | 49 |
</specimenreplicate> |
| 50 | 50 |
</plantobservation> |
| 51 | 51 |
</aggregateoccurrence> |
| 52 | 52 |
<collector_id><party><fullname>$recordedBy</fullname></party></collector_id> |
| 53 | 53 |
<iscultivated>$cultivated</iscultivated> |
| 54 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 54 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 55 | 55 |
<taxondetermination> |
| 56 | 56 |
<taxonverbatim_id> |
| 57 | 57 |
<taxonverbatim> |
| trunk/inputs/NCU/Specimen/new_terms.csv | ||
|---|---|---|
| 1 |
SpecimenPK,occurrenceID,,
|
|
| 1 |
SpecimenPK,dataProviderRecordID,,
|
|
| 2 | 2 |
OwnerInstitution,specimenOwner,,= specimen.owner_collection.institution.name |
| 3 | 3 |
CollectionGUID,collectionURL,, |
| 4 | 4 |
OriginalTaxonLabel,originalScientificName,, |
| trunk/inputs/bien2_traits/TraitObservation/map.csv | ||
|---|---|---|
| 1 | 1 |
bien2_traits,VegCore,Filter,Comments |
| 2 |
TraitObservationID,occurrenceID,,
|
|
| 2 |
TraitObservationID,dataProviderRecordID,,
|
|
| 3 | 3 |
TaxonomyID,UNUSED#TaxonomyID,,Always 0 |
| 4 | 4 |
Family,family,, |
| 5 | 5 |
Genus,genus,, |
| trunk/inputs/bien2_traits/TraitObservation/test.xml.ref | ||
|---|---|---|
| 7 | 7 |
<next>parent_id</next> |
| 8 | 8 |
<path> |
| 9 | 9 |
<location> |
| 10 |
<authorlocationcode>$occurrenceID</authorlocationcode>
|
|
| 10 |
<authorlocationcode>$dataProviderRecordID</authorlocationcode>
|
|
| 11 | 11 |
<elevation_m> |
| 12 | 12 |
<_units> |
| 13 | 13 |
<to>m</to> |
| ... | ... | |
| 20 | 20 |
<method_id><method><name>$samplingProtocol</name></method></method_id> |
| 21 | 21 |
<locationevent fkey="parent_id"> |
| 22 | 22 |
<taxonoccurrence> |
| 23 |
<aggregateoccurrence><plantobservation><specimenreplicate><sourceaccessioncode>$occurrenceID</sourceaccessioncode></specimenreplicate></plantobservation></aggregateoccurrence>
|
|
| 23 |
<aggregateoccurrence><plantobservation><specimenreplicate><sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode></specimenreplicate></plantobservation></aggregateoccurrence>
|
|
| 24 | 24 |
<growthform>$growthForm</growthform> |
| 25 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 25 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 26 | 26 |
<taxondetermination> |
| 27 | 27 |
<taxonverbatim_id> |
| 28 | 28 |
<taxonverbatim> |
| trunk/inputs/bien2_traits/TraitObservation/new_terms.csv | ||
|---|---|---|
| 1 |
TraitObservationID,occurrenceID,,
|
|
| 1 |
TraitObservationID,dataProviderRecordID,,
|
|
| 2 | 2 |
Taxon,taxonName,, |
| 3 | 3 |
AuthorOfScientificName,scientificNameAuthorship,, |
| 4 | 4 |
LocalityDescription,verbatimLocality,, |
| trunk/inputs/SpeciesLink/Specimen/map.csv | ||
|---|---|---|
| 1 | 1 |
SpeciesLink,VegCore,Filter,Comments |
| 2 | 2 |
row_num,*row_num,, |
| 3 |
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,,
|
|
| 3 |
dwc_dwcore_GlobalUniqueIdentifier,dataProviderRecordID,,
|
|
| 4 | 4 |
dwc_dwcore_DateLastModified,DUPLICATE#of:modified#dwcore_DateLastModified,,assumed duplicate because Darwin Core term is synonym |
| 5 | 5 |
dwc_dwcore_BasisOfRecord,DUPLICATE#of:basisOfRecord#dwcore_BasisOfRecord,,assumed duplicate because Darwin Core term is synonym |
| 6 | 6 |
dwc_dwcore_InstitutionCode,DUPLICATE#of:institutionCode#dwcore_InstitutionCode,,assumed duplicate because Darwin Core term is synonym |
| trunk/inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
<location> |
| 10 | 10 |
<authorlocationcode> |
| 11 | 11 |
<_alt> |
| 12 |
<1>$occurrenceID</1>
|
|
| 12 |
<1>$dataProviderRecordID</1>
|
|
| 13 | 13 |
<2> |
| 14 | 14 |
<_join> |
| 15 | 15 |
<1>$specimen_duplicate_institutions</1> |
| ... | ... | |
| 95 | 95 |
</sourcename> |
| 96 | 96 |
</sourcelist> |
| 97 | 97 |
</duplicate_institutions_sourcelist_id> |
| 98 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 98 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 99 | 99 |
</specimenreplicate> |
| 100 | 100 |
</plantobservation> |
| 101 | 101 |
</aggregateoccurrence> |
| 102 | 102 |
<collector_id><party><fullname>$recordedBy</fullname></party></collector_id> |
| 103 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 103 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 104 | 104 |
<taxondetermination> |
| 105 | 105 |
<party_id><party><fullname>$identifiedBy</fullname></party></party_id> |
| 106 | 106 |
<taxonverbatim_id> |
| trunk/inputs/SpeciesLink/Specimen/new_terms.csv | ||
|---|---|---|
| 1 |
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,,
|
|
| 1 |
dwc_dwcore_GlobalUniqueIdentifier,dataProviderRecordID,,
|
|
| 2 | 2 |
dwc_dwcore_DateLastModified,DUPLICATE#of:modified#dwcore_DateLastModified,,assumed duplicate because Darwin Core term is synonym |
| 3 | 3 |
dwc_dwcore_BasisOfRecord,DUPLICATE#of:basisOfRecord#dwcore_BasisOfRecord,,assumed duplicate because Darwin Core term is synonym |
| 4 | 4 |
dwc_dwcore_InstitutionCode,DUPLICATE#of:institutionCode#dwcore_InstitutionCode,,assumed duplicate because Darwin Core term is synonym |
| trunk/inputs/bien_web/observation/map.csv | ||
|---|---|---|
| 1 | 1 |
bien_web,VegCore,Filter,Comments |
| 2 |
observationID,occurrenceID,,
|
|
| 2 |
observationID,dataProviderRecordID,,
|
|
| 3 | 3 |
dataSourceID,*dataSourceID,, |
| 4 | 4 |
dataSourceName,specimen_duplicate_institutions,, |
| 5 | 5 |
dataSourceNamePrimary,*dataSourceNamePrimary,, |
| trunk/inputs/bien_web/observation/test.xml.ref | ||
|---|---|---|
| 35 | 35 |
</sourcename> |
| 36 | 36 |
</sourcelist> |
| 37 | 37 |
</duplicate_institutions_sourcelist_id> |
| 38 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 38 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 39 | 39 |
</specimenreplicate> |
| 40 | 40 |
</plantobservation> |
| 41 | 41 |
</aggregateoccurrence> |
| 42 | 42 |
<authortaxoncode>$collectorNumber</authortaxoncode> |
| 43 | 43 |
<collector_id><party><fullname>$recordedBy</fullname></party></collector_id> |
| 44 | 44 |
<iscultivated>$cultivated</iscultivated> |
| 45 |
<sourceaccessioncode>$occurrenceID</sourceaccessioncode>
|
|
| 45 |
<sourceaccessioncode>$dataProviderRecordID</sourceaccessioncode>
|
|
| 46 | 46 |
<taxondetermination> |
| 47 | 47 |
<party_id><party><fullname>$identifiedBy</fullname></party></party_id> |
| 48 | 48 |
<taxonverbatim_id> |
| trunk/inputs/bien_web/observation/new_terms.csv | ||
|---|---|---|
| 1 |
observationID,occurrenceID,,
|
|
| 1 |
observationID,dataProviderRecordID,,
|
|
| 2 | 2 |
taxon,scientificName,, |
| 3 | 3 |
taxonAuthor,scientificNameAuthorship,, |
| 4 | 4 |
countyParish,county,, |
Also available in: Unified diff
fix: inputs/*/*/map.csv: remapped occurrenceID-mapped fields to dataProviderRecordID when these were not globally unique DwC occurrenceIDs (http://rs.tdwg.org/dwc/terms/#occurrenceID)