Revision 11160
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/VegBank/import_order.txt | ||
|---|---|---|
| 8 | 8 |
stemlocation_ |
| 9 | 9 |
taxon_observation.** |
| 10 | 10 |
observationcontributor_ |
| 11 |
observation__community |
|
| inputs/VegBank/observation__community/create.sql | ||
|---|---|---|
| 1 |
SELECT DISTINCT ON (commclass_id, comminterpretation.commname) |
|
| 2 |
/* there are 330 more comminterpretations than commclasses. some of these |
|
| 3 |
multiple determinations have the same commname. */ |
|
| 4 |
* |
|
| 5 |
FROM commclass |
|
| 6 |
LEFT JOIN comminterpretation USING (commclass_id) |
|
| 7 |
ORDER BY commclass_id, comminterpretation.commname, comminterpretation_id |
|
| inputs/VegBank/observation__community/header.csv | ||
|---|---|---|
| 1 |
commclass_id,observation_id,inspection,tableanalysis,multivariateanalysis,classpublication_id,classnotes,commclass__commname,commclass__commcode,commframework,commlevel,classstartdate,classstopdate,emb_commclass,expertsystem,accessioncode,comminterpretation_id,commconcept_id,commcode,commname,classfit,classconfidence,commauthority_id,notes,type,nomenclaturaltype,emb_comminterpretation |
|
| inputs/VegBank/observation__community/run | ||
|---|---|---|
| 1 |
#!/bin/bash -e |
|
| 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run
|
|
| 0 | 3 | |
| inputs/VegBank/observation__community/map.csv | ||
|---|---|---|
| 1 |
VegBank,VegCore,Filter,Comments |
|
| 2 |
commclass_id,*observation__community--commclass_id,, |
|
| 3 |
observation_id,eventID,, |
|
| 4 |
inspection,*observation__community--inspection,, |
|
| 5 |
tableanalysis,*observation__community--tableanalysis,, |
|
| 6 |
multivariateanalysis,*observation__community--multivariateanalysis,, |
|
| 7 |
classpublication_id,*observation__community--classpublication_id,, |
|
| 8 |
classnotes,*observation__community--classnotes,, |
|
| 9 |
commclass__commname,*observation__community--commclass__commname,, |
|
| 10 |
commclass__commcode,*observation__community--commclass__commcode,, |
|
| 11 |
commframework,*observation__community--commframework,, |
|
| 12 |
commlevel,*observation__community--commlevel,, |
|
| 13 |
classstartdate,*observation__community--classstartdate,, |
|
| 14 |
classstopdate,*observation__community--classstopdate,, |
|
| 15 |
emb_commclass,*observation__community--emb_commclass,, |
|
| 16 |
expertsystem,*observation__community--expertsystem,, |
|
| 17 |
accessioncode,*observation__community--accessioncode,, |
|
| 18 |
comminterpretation_id,communityID,, |
|
| 19 |
commconcept_id,*observation__community--commconcept_id,, |
|
| 20 |
commcode,*observation__community--commcode,, |
|
| 21 |
commname,communityName,, |
|
| 22 |
classfit,*observation__community--classfit,, |
|
| 23 |
classconfidence,*observation__community--classconfidence,, |
|
| 24 |
commauthority_id,*observation__community--commauthority_id,, |
|
| 25 |
notes,*observation__community--notes,, |
|
| 26 |
type,*observation__community--type,, |
|
| 27 |
nomenclaturaltype,*observation__community--nomenclaturaltype,, |
|
| 28 |
emb_comminterpretation,*observation__community--emb_comminterpretation,, |
|
| inputs/VegBank/observation__community/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| inputs/VegBank/observation__community/test.xml.ref | ||
|---|---|---|
| 1 |
Put template: |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>VegBank.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 12 |
<commclass> |
|
| 13 |
<commdetermination> |
|
| 14 |
<commconcept_id> |
|
| 15 |
<commconcept> |
|
| 16 |
<commname_id><commname><commname>$communityID</commname></commname></commname_id> |
|
| 17 |
<commdescription>$communityName</commdescription> |
|
| 18 |
</commconcept> |
|
| 19 |
</commconcept_id> |
|
| 20 |
</commdetermination> |
|
| 21 |
</commclass> |
|
| 22 |
<locationevent fkey="parent_id"><sourceaccessioncode>$eventID</sourceaccessioncode></locationevent> |
|
| 23 |
</locationevent> |
|
| 24 |
</location> |
|
| 25 |
</path> |
|
| 26 |
</_simplifyPath> |
|
| 27 |
</path> |
|
| 28 |
</_setDefault> |
|
| 29 |
</VegBIEN> |
|
| 30 |
Inserted 11 new rows into database |
|
| inputs/VegBank/observation__community/new_terms.csv | ||
|---|---|---|
| 1 |
commclass_id,*observation__community--commclass_id,, |
|
| 2 |
observation_id,eventID,, |
|
| 3 |
inspection,*observation__community--inspection,, |
|
| 4 |
tableanalysis,*observation__community--tableanalysis,, |
|
| 5 |
multivariateanalysis,*observation__community--multivariateanalysis,, |
|
| 6 |
classpublication_id,*observation__community--classpublication_id,, |
|
| 7 |
classnotes,*observation__community--classnotes,, |
|
| 8 |
commclass__commname,*observation__community--commclass__commname,, |
|
| 9 |
commclass__commcode,*observation__community--commclass__commcode,, |
|
| 10 |
commframework,*observation__community--commframework,, |
|
| 11 |
commlevel,*observation__community--commlevel,, |
|
| 12 |
classstartdate,*observation__community--classstartdate,, |
|
| 13 |
classstopdate,*observation__community--classstopdate,, |
|
| 14 |
emb_commclass,*observation__community--emb_commclass,, |
|
| 15 |
expertsystem,*observation__community--expertsystem,, |
|
| 16 |
accessioncode,*observation__community--accessioncode,, |
|
| 17 |
comminterpretation_id,communityID,, |
|
| 18 |
commconcept_id,*observation__community--commconcept_id,, |
|
| 19 |
commcode,*observation__community--commcode,, |
|
| 20 |
commname,communityName,, |
|
| 21 |
classfit,*observation__community--classfit,, |
|
| 22 |
classconfidence,*observation__community--classconfidence,, |
|
| 23 |
commauthority_id,*observation__community--commauthority_id,, |
|
| 24 |
nomenclaturaltype,*observation__community--nomenclaturaltype,, |
|
| 25 |
emb_comminterpretation,*observation__community--emb_comminterpretation,, |
|
| inputs/VegBank/observation__community/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*observation__community--commclass_id |
|
| 2 |
*observation__community--inspection |
|
| 3 |
*observation__community--tableanalysis |
|
| 4 |
*observation__community--multivariateanalysis |
|
| 5 |
*observation__community--classpublication_id |
|
| 6 |
*observation__community--classnotes |
|
| 7 |
*observation__community--commclass__commname |
|
| 8 |
*observation__community--commclass__commcode |
|
| 9 |
*observation__community--commframework |
|
| 10 |
*observation__community--commlevel |
|
| 11 |
*observation__community--classstartdate |
|
| 12 |
*observation__community--classstopdate |
|
| 13 |
*observation__community--emb_commclass |
|
| 14 |
*observation__community--expertsystem |
|
| 15 |
*observation__community--accessioncode |
|
| 16 |
*observation__community--commconcept_id |
|
| 17 |
*observation__community--commcode |
|
| 18 |
*observation__community--classfit |
|
| 19 |
*observation__community--classconfidence |
|
| 20 |
*observation__community--commauthority_id |
|
| 21 |
*observation__community--notes |
|
| 22 |
*observation__community--type |
|
| 23 |
*observation__community--nomenclaturaltype |
|
| 24 |
*observation__community--emb_comminterpretation |
|
Also available in: Unified diff
inputs/VegBank/: added observation__community/