Revision 11524
Added by Aaron Marcuse-Kubitza over 10 years ago
| inputs/VegBank/taxonobservation_/postprocess.sql | ||
|---|---|---|
| 1 | 1 |
SELECT util.search_path_append('util');
|
| 2 | 2 |
|
| 3 | 3 |
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("eventID")$$); -- runtime: 2 s ("2416.676 ms") @starscream
|
| 4 |
|
|
| 5 |
|
|
| 6 |
SELECT mk_derived_col((:table_str, 'identifiedBy'), |
|
| 7 |
$$_join_words("identifiedBy__first", "identifiedBy__middle", "identifiedBy__last")$$)
|
|
| 8 |
; -- runtime: 30 s ("29290.701 ms") @starscream
|
|
| inputs/VegBank/taxonobservation_/map.csv | ||
|---|---|---|
| 43 | 43 |
emb_taxoninterpretation,*taxonobservation_--emb_taxoninterpretation,, |
| 44 | 44 |
taxoninterpretation_accessioncode,*taxonobservation_--taxoninterpretation_accessioncode,, |
| 45 | 45 |
salutation,*taxonobservation--party--salutation,, |
| 46 |
givenname,*taxonobservation--party--givenname,,
|
|
| 47 |
middlename,*taxonobservation--party--middlename,,
|
|
| 48 |
surname,*taxonobservation--party--surname,,
|
|
| 46 |
givenname,identifiedBy__first,,
|
|
| 47 |
middlename,identifiedBy__middle,,
|
|
| 48 |
surname,identifiedBy__last,,
|
|
| 49 | 49 |
organizationname,*taxonobservation--party--organizationname,, |
| 50 | 50 |
currentname_id,*taxonobservation--party--currentname_id,, |
| 51 | 51 |
contactinstructions,*taxonobservation--party--contactinstructions,, |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 25 | 25 |
</aggregateoccurrence> |
| 26 | 26 |
<authortaxoncode>$collectorNumber</authortaxoncode> |
| 27 | 27 |
<taxondetermination> |
| 28 |
<party_id><party><fullname>$identifiedBy</fullname></party></party_id> |
|
| 28 | 29 |
<taxonverbatim_id> |
| 29 | 30 |
<taxonverbatim> |
| 30 | 31 |
<taxonlabel_id> |
| ... | ... | |
| 126 | 127 |
</path> |
| 127 | 128 |
</_setDefault> |
| 128 | 129 |
</VegBIEN> |
| 129 |
Inserted 12 new rows into database |
|
| 130 |
Inserted 13 new rows into database |
|
| inputs/VegBank/taxonobservation_/new_terms.csv | ||
|---|---|---|
| 30 | 30 |
emb_taxoninterpretation,*taxonobservation_--emb_taxoninterpretation,, |
| 31 | 31 |
taxoninterpretation_accessioncode,*taxonobservation_--taxoninterpretation_accessioncode,, |
| 32 | 32 |
salutation,*taxonobservation--party--salutation,, |
| 33 |
givenname,*taxonobservation--party--givenname,,
|
|
| 34 |
middlename,*taxonobservation--party--middlename,,
|
|
| 35 |
surname,*taxonobservation--party--surname,,
|
|
| 33 |
givenname,identifiedBy__first,,
|
|
| 34 |
middlename,identifiedBy__middle,,
|
|
| 35 |
surname,identifiedBy__last,,
|
|
| 36 | 36 |
organizationname,*taxonobservation--party--organizationname,, |
| 37 | 37 |
currentname_id,*taxonobservation--party--currentname_id,, |
| 38 | 38 |
contactinstructions,*taxonobservation--party--contactinstructions,, |
| inputs/VegBank/taxonobservation_/unmapped_terms.csv | ||
|---|---|---|
| 20 | 20 |
*taxonobservation_--emb_taxoninterpretation |
| 21 | 21 |
*taxonobservation_--taxoninterpretation_accessioncode |
| 22 | 22 |
*taxonobservation--party--salutation |
| 23 |
*taxonobservation--party--givenname
|
|
| 24 |
*taxonobservation--party--middlename
|
|
| 25 |
*taxonobservation--party--surname
|
|
| 23 |
identifiedBy__first
|
|
| 24 |
identifiedBy__middle
|
|
| 25 |
identifiedBy__last
|
|
| 26 | 26 |
*taxonobservation--party--organizationname |
| 27 | 27 |
*taxonobservation--party--currentname_id |
| 28 | 28 |
*taxonobservation--party--contactinstructions |
Also available in: Unified diff
inputs/VegBank/taxonobservation_/map.csv, postprocess.sql: mapped identifiedBy (the join_words() of identifiedBy_first, etc.)