Revision 10592
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/U/Specimen/postprocess.sql | ||
|---|---|---|
| 4 | 4 |
SELECT mk_derived_col((:table_str, 'county'), |
| 5 | 5 |
$$_alt("Gazetteer", "Newgazett")$$)
|
| 6 | 6 |
; -- runtime: 0.5 s ("Time: 610.516 ms") @starscream
|
| 7 |
|
|
| 8 |
SELECT mk_derived_col((:table_str, 'recordedBy'), |
|
| 9 |
$$_join("Collector", "Addcoll")$$)
|
|
| 10 |
; -- runtime: 2 s ("Time: 2273.582 ms") @starscream
|
|
| inputs/U/Specimen/map.csv | ||
|---|---|---|
| 2 | 2 |
row_num,*row_num,, |
| 3 | 3 |
ID,dataProviderRecordID,, |
| 4 | 4 |
Barcode,accessionNumber,, |
| 5 |
Collector,recordedBy,/_join/1,
|
|
| 5 |
Collector,recordedBy_primary,,the primary collector
|
|
| 6 | 6 |
Prefix,UNUSED#Prefix,, |
| 7 | 7 |
Number,collectorNumber,, |
| 8 | 8 |
Suffix,UNUSED#Suffix,, |
| 9 |
Addcoll,recordedBy,/_join/2,
|
|
| 9 |
Addcoll,recordedBy_additional,,additional collectors
|
|
| 10 | 10 |
Colldd,dayCollected,, |
| 11 | 11 |
Collmm,monthCollected,, |
| 12 | 12 |
Collyy,yearCollected,, |
| ... | ... | |
| 33 | 33 |
Notes,occurrenceRemarks,, |
| 34 | 34 |
:U,specimenHolderInstitutions,, |
| 35 | 35 |
county,county,, |
| 36 |
recordedBy,recordedBy,, |
|
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 27 | 27 |
:U,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value", |
| 28 | 28 |
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 29 | 29 |
Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 30 |
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/1, |
|
| 31 |
Addcoll,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/2, |
|
| 30 |
recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
|
| 32 | 31 |
ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 33 | 32 |
Number,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 34 | 33 |
ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| ... | ... | |
| 55 | 54 |
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2, |
| 56 | 55 |
Majorarea,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,closest equivalent for Guyana/Suriname |
| 57 | 56 |
Majorarea,/location/locationplace/*_id/place/stateprovince,closest equivalent for Guyana/Suriname |
| 57 |
Addcoll,,** No join mapping for recordedBy_additional ** additional collectors |
|
| 58 | 58 |
Alt,,** No join mapping for *Alt ** What is this? |
| 59 | 59 |
Alt2,,** No join mapping for *Alt2 ** What is this? |
| 60 |
Collector,,** No join mapping for recordedBy_primary ** the primary collector |
|
| 60 | 61 |
Coorsyst,,** No join mapping for *Coorsyst ** |
| 61 | 62 |
DateInfo,,** No non-empty join mapping for UNUSED#DateInfo ** |
| 62 | 63 |
EW,,** No join mapping for *EW ** |
| inputs/U/Specimen/test.xml.ref | ||
|---|---|---|
| 80 | 80 |
</specimenreplicate> |
| 81 | 81 |
</plantobservation> |
| 82 | 82 |
</aggregateoccurrence> |
| 83 |
<collector_id> |
|
| 84 |
<party> |
|
| 85 |
<fullname> |
|
| 86 |
<_join> |
|
| 87 |
<1>$Collector</1> |
|
| 88 |
<2>$Addcoll</2> |
|
| 89 |
</_join> |
|
| 90 |
</fullname> |
|
| 91 |
</party> |
|
| 92 |
</collector_id> |
|
| 83 |
<collector_id><party><fullname>$recordedBy</fullname></party></collector_id> |
|
| 93 | 84 |
<sourceaccessioncode>$ID</sourceaccessioncode> |
| 94 | 85 |
<taxondetermination> |
| 95 | 86 |
<party_id><party><fullname>$Detby</fullname></party></party_id> |
| inputs/U/Specimen/new_terms.csv | ||
|---|---|---|
| 1 | 1 |
Number,collectorNumber,, |
| 2 |
Addcoll,recordedBy,/_join/2,
|
|
| 2 |
Addcoll,recordedBy_additional,,additional collectors
|
|
| 3 | 3 |
Colldd,dayCollected,, |
| 4 | 4 |
Collmm,monthCollected,, |
| 5 | 5 |
Collyy,yearCollected,, |
| inputs/U/Specimen/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
*row_num |
| 2 |
recordedBy_primary |
|
| 3 |
recordedBy_additional |
|
| 2 | 4 |
county.main |
| 3 | 5 |
county.alt |
| 4 | 6 |
*Coorsyst |
Also available in: Unified diff
inputs/U/Specimen/map.csv: translated remaining multi-column filters to postprocessing derived columns, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns