Revision 11814
Added by Aaron Marcuse-Kubitza over 10 years ago
| inputs/CVS/import_order.txt | ||
|---|---|---|
| 9 | 9 |
taxon_observation.** |
| 10 | 10 |
^taxon_observation.**.sample |
| 11 | 11 |
observationContributor_ |
| 12 |
observation_community |
|
| inputs/CVS/observation_community/create.sql | ||
|---|---|---|
| 1 |
SELECT DISTINCT ON ("COMMCLASS_ID", "commInterpretation".commname) *
|
|
| 2 |
FROM "commClass" |
|
| 3 |
LEFT JOIN "commInterpretation" USING ("COMMCLASS_ID")
|
|
| 4 |
ORDER BY "COMMCLASS_ID", "commInterpretation".commname, "COMMINTERPRETATION_ID" |
|
| inputs/CVS/observation_community/header.csv | ||
|---|---|---|
| 1 |
COMMCLASS_ID,OBSERVATION_ID,classStartDate,classStopDate,inspection,tableAnalysis,multivariateAnalysis,expertSystem,classPublication_ID,classNotes,commName,commCode,commFramework,commLevel,accessionCode,commClass--dba_src_ID,dba_dataSource,classStopReason,COMMINTERPRETATION_ID,COMMCONCEPT_ID,commcode,commname,classFit,classConfidence,commAuthority_ID,notes,type,nomenclaturalType,dba_src_ID,framework_id,primaryDetermination,primaryDeterminationStatus,primaryComments,primaryStartDate,primarySTOPDate,dba_interpretationStatus,previousFit,orderDeterminationForEvent,duplicateDetermination |
|
| inputs/CVS/observation_community/run | ||
|---|---|---|
| 1 |
#!/bin/bash -e |
|
| 2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run
|
|
| 0 | 3 | |
| inputs/CVS/observation_community/map.csv | ||
|---|---|---|
| 1 |
CVS,VegCore,Filter,Comments |
|
| 2 |
COMMCLASS_ID,*observation_community--COMMCLASS_ID,, |
|
| 3 |
OBSERVATION_ID,eventID,, |
|
| 4 |
classStartDate,*observation_community--classStartDate,, |
|
| 5 |
classStopDate,*observation_community--classStopDate,, |
|
| 6 |
inspection,*observation_community--inspection,, |
|
| 7 |
tableAnalysis,*observation_community--tableAnalysis,, |
|
| 8 |
multivariateAnalysis,*observation_community--multivariateAnalysis,, |
|
| 9 |
expertSystem,*observation_community--expertSystem,, |
|
| 10 |
classPublication_ID,*observation_community--classPublication_ID,, |
|
| 11 |
classNotes,*observation_community--classNotes,, |
|
| 12 |
commName,*observation_community--commName,, |
|
| 13 |
commCode,*observation_community--commCode,, |
|
| 14 |
commFramework,*observation_community--commFramework,, |
|
| 15 |
commLevel,*observation_community--commLevel,, |
|
| 16 |
accessionCode,*observation_community--accessionCode,, |
|
| 17 |
commClass--dba_src_ID,*observation_community--commClass--dba_src_ID,, |
|
| 18 |
dba_dataSource,*observation_community--dba_dataSource,, |
|
| 19 |
classStopReason,*observation_community--classStopReason,, |
|
| 20 |
COMMINTERPRETATION_ID,communityID,, |
|
| 21 |
COMMCONCEPT_ID,*observation_community--COMMCONCEPT_ID,, |
|
| 22 |
commcode,*observation_community--commcode,, |
|
| 23 |
commname,communityName,, |
|
| 24 |
classFit,*observation_community--classFit,, |
|
| 25 |
classConfidence,*observation_community--classConfidence,, |
|
| 26 |
commAuthority_ID,*observation_community--commAuthority_ID,, |
|
| 27 |
notes,*observation_community--notes,, |
|
| 28 |
type,*observation_community--type,, |
|
| 29 |
nomenclaturalType,*observation_community--nomenclaturalType,, |
|
| 30 |
dba_src_ID,*observation_community--dba_src_ID,, |
|
| 31 |
framework_id,*observation_community--framework_id,, |
|
| 32 |
primaryDetermination,*observation_community--primaryDetermination,, |
|
| 33 |
primaryDeterminationStatus,*observation_community--primaryDeterminationStatus,, |
|
| 34 |
primaryComments,*observation_community--primaryComments,, |
|
| 35 |
primaryStartDate,*observation_community--primaryStartDate,, |
|
| 36 |
primarySTOPDate,*observation_community--primarySTOPDate,, |
|
| 37 |
dba_interpretationStatus,*observation_community--dba_interpretationStatus,, |
|
| 38 |
previousFit,*observation_community--previousFit,, |
|
| 39 |
orderDeterminationForEvent,*observation_community--orderDeterminationForEvent,, |
|
| 40 |
duplicateDetermination,*observation_community--duplicateDetermination,, |
|
| inputs/CVS/observation_community/VegBIEN.csv | ||
|---|---|---|
| 1 |
link ../../../mappings/VegCore-VegBIEN.csv |
|
| 0 | 2 | |
| inputs/CVS/observation_community/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CVS.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 9 new rows into database |
|
| inputs/CVS/observation_community/new_terms.csv | ||
|---|---|---|
| 1 |
COMMCLASS_ID,*observation_community--COMMCLASS_ID,, |
|
| 2 |
OBSERVATION_ID,eventID,, |
|
| 3 |
classStartDate,*observation_community--classStartDate,, |
|
| 4 |
classStopDate,*observation_community--classStopDate,, |
|
| 5 |
inspection,*observation_community--inspection,, |
|
| 6 |
tableAnalysis,*observation_community--tableAnalysis,, |
|
| 7 |
multivariateAnalysis,*observation_community--multivariateAnalysis,, |
|
| 8 |
expertSystem,*observation_community--expertSystem,, |
|
| 9 |
classPublication_ID,*observation_community--classPublication_ID,, |
|
| 10 |
classNotes,*observation_community--classNotes,, |
|
| 11 |
commName,*observation_community--commName,, |
|
| 12 |
commCode,*observation_community--commCode,, |
|
| 13 |
commFramework,*observation_community--commFramework,, |
|
| 14 |
commLevel,*observation_community--commLevel,, |
|
| 15 |
accessionCode,*observation_community--accessionCode,, |
|
| 16 |
commClass--dba_src_ID,*observation_community--commClass--dba_src_ID,, |
|
| 17 |
dba_dataSource,*observation_community--dba_dataSource,, |
|
| 18 |
classStopReason,*observation_community--classStopReason,, |
|
| 19 |
COMMINTERPRETATION_ID,communityID,, |
|
| 20 |
COMMCONCEPT_ID,*observation_community--COMMCONCEPT_ID,, |
|
| 21 |
commcode,*observation_community--commcode,, |
|
| 22 |
commname,communityName,, |
|
| 23 |
classFit,*observation_community--classFit,, |
|
| 24 |
classConfidence,*observation_community--classConfidence,, |
|
| 25 |
commAuthority_ID,*observation_community--commAuthority_ID,, |
|
| 26 |
nomenclaturalType,*observation_community--nomenclaturalType,, |
|
| 27 |
dba_src_ID,*observation_community--dba_src_ID,, |
|
| 28 |
framework_id,*observation_community--framework_id,, |
|
| 29 |
primaryDetermination,*observation_community--primaryDetermination,, |
|
| 30 |
primaryDeterminationStatus,*observation_community--primaryDeterminationStatus,, |
|
| 31 |
primaryComments,*observation_community--primaryComments,, |
|
| 32 |
primaryStartDate,*observation_community--primaryStartDate,, |
|
| 33 |
primarySTOPDate,*observation_community--primarySTOPDate,, |
|
| 34 |
dba_interpretationStatus,*observation_community--dba_interpretationStatus,, |
|
| 35 |
previousFit,*observation_community--previousFit,, |
|
| 36 |
orderDeterminationForEvent,*observation_community--orderDeterminationForEvent,, |
|
| 37 |
duplicateDetermination,*observation_community--duplicateDetermination,, |
|
| inputs/CVS/observation_community/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*observation_community--COMMCLASS_ID |
|
| 2 |
*observation_community--classStartDate |
|
| 3 |
*observation_community--classStopDate |
|
| 4 |
*observation_community--inspection |
|
| 5 |
*observation_community--tableAnalysis |
|
| 6 |
*observation_community--multivariateAnalysis |
|
| 7 |
*observation_community--expertSystem |
|
| 8 |
*observation_community--classPublication_ID |
|
| 9 |
*observation_community--classNotes |
|
| 10 |
*observation_community--commName |
|
| 11 |
*observation_community--commCode |
|
| 12 |
*observation_community--commFramework |
|
| 13 |
*observation_community--commLevel |
|
| 14 |
*observation_community--accessionCode |
|
| 15 |
*observation_community--commClass--dba_src_ID |
|
| 16 |
*observation_community--dba_dataSource |
|
| 17 |
*observation_community--classStopReason |
|
| 18 |
*observation_community--COMMCONCEPT_ID |
|
| 19 |
*observation_community--commcode |
|
| 20 |
*observation_community--classFit |
|
| 21 |
*observation_community--classConfidence |
|
| 22 |
*observation_community--commAuthority_ID |
|
| 23 |
*observation_community--notes |
|
| 24 |
*observation_community--type |
|
| 25 |
*observation_community--nomenclaturalType |
|
| 26 |
*observation_community--dba_src_ID |
|
| 27 |
*observation_community--framework_id |
|
| 28 |
*observation_community--primaryDetermination |
|
| 29 |
*observation_community--primaryDeterminationStatus |
|
| 30 |
*observation_community--primaryComments |
|
| 31 |
*observation_community--primaryStartDate |
|
| 32 |
*observation_community--primarySTOPDate |
|
| 33 |
*observation_community--dba_interpretationStatus |
|
| 34 |
*observation_community--previousFit |
|
| 35 |
*observation_community--orderDeterminationForEvent |
|
| 36 |
*observation_community--duplicateDetermination |
|
Also available in: Unified diff
added inputs/CVS/observation_community/, as for VegBank