Project

General

Profile

« Previous | Next » 

Revision 6759

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/CVS/: Joined together taxonImportance and stemCount tables to create stemCount_, because stemCount actually stores stem abundance by size, rather than grouping stems by organism (http://vegbankdev.nceas.ucsb.edu/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename), and is thus an AggregateOccurrence-related table along with taxonImportance

View differences:

inputs/CVS/taxonImportance/header.csv
1 
taxonImportance_ID,taxonObservation_ID,stratum_ID,cover,basalArea,biomass,inferenceArea,cust_cvs_StemFrequency,dba_src_ID,entry_herbLineID,entry_treeLineID,cust_cvs_corner1Presence,cust_cvs_corner2Presence,cust_cvs_corner3Presence,cust_cvs_corner4Presence,cust_cvs_corner5Presence,cust_cvs_originalCoverCode
inputs/CVS/taxonImportance/map.csv
1 
CVS,VegCore,Filter,Comments
2 
taxonImportance_ID,aggregateOccurrenceID,,
3 
taxonObservation_ID,taxonOccurrenceID,,
4 
stratum_ID,*stratum_ID,,
5 
cover,coverPercent,,
6 
basalArea,*basalArea,,
7 
biomass,*biomass,,
8 
inferenceArea,*inferenceArea,,
9 
cust_cvs_StemFrequency,*cust_cvs_StemFrequency,,
10 
dba_src_ID,*dba_src_ID,,
11 
entry_herbLineID,*entry_herbLineID,,
12 
entry_treeLineID,*entry_treeLineID,,
13 
cust_cvs_corner1Presence,*cust_cvs_corner1Presence,,
14 
cust_cvs_corner2Presence,*cust_cvs_corner2Presence,,
15 
cust_cvs_corner3Presence,*cust_cvs_corner3Presence,,
16 
cust_cvs_corner4Presence,*cust_cvs_corner4Presence,,
17 
cust_cvs_corner5Presence,*cust_cvs_corner5Presence,,
18 
cust_cvs_originalCoverCode,*cust_cvs_originalCoverCode,,
inputs/CVS/taxonImportance/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>CVS</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationevent>
11 
                            <taxonoccurrence>
12 
                                <aggregateoccurrence>
13 
                                    <cover_fraction><_percent_to_fraction><value>$cover</value></_percent_to_fraction></cover_fraction>
14 
                                    <sourceaccessioncode>$taxonImportance_ID</sourceaccessioncode>
15 
                                </aggregateoccurrence>
16 
                                <sourceaccessioncode>$taxonObservation_ID</sourceaccessioncode>
17 
                            </taxonoccurrence>
18 
                        </locationevent>
19 
                    </location>
20 
                </path>
21 
            </_simplifyPath>
22 
        </path>
23 
    </_setDefault>
24 
</VegBIEN>
25 
Inserted 4 new rows into database
inputs/CVS/taxonImportance/VegBIEN.csv
1 
CVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
taxonObservation_ID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
3 
cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
4 
taxonImportance_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,
5 
taxonObservation_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
6 
taxonObservation_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
7 
taxonImportance_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",
8 
basalArea,,** No join mapping for *basalArea **
9 
biomass,,** No join mapping for *biomass **
10 
cust_cvs_StemFrequency,,** No join mapping for *cust_cvs_StemFrequency **
11 
cust_cvs_corner1Presence,,** No join mapping for *cust_cvs_corner1Presence **
12 
cust_cvs_corner2Presence,,** No join mapping for *cust_cvs_corner2Presence **
13 
cust_cvs_corner3Presence,,** No join mapping for *cust_cvs_corner3Presence **
14 
cust_cvs_corner4Presence,,** No join mapping for *cust_cvs_corner4Presence **
15 
cust_cvs_corner5Presence,,** No join mapping for *cust_cvs_corner5Presence **
16 
cust_cvs_originalCoverCode,,** No join mapping for *cust_cvs_originalCoverCode **
17 
dba_src_ID,,** No join mapping for *dba_src_ID **
18 
entry_herbLineID,,** No join mapping for *entry_herbLineID **
19 
entry_treeLineID,,** No join mapping for *entry_treeLineID **
20 
inferenceArea,,** No join mapping for *inferenceArea **
21 
stratum_ID,,** No join mapping for *stratum_ID **
inputs/CVS/taxonImportance/new_terms.csv
1 
taxonImportance_ID,aggregateOccurrenceID,,
2 
taxonObservation_ID,taxonOccurrenceID,,
3 
cover,coverPercent,,
inputs/CVS/taxonImportance/unmapped_terms.csv
1 
*stratum_ID
2 
*basalArea
3 
*biomass
4 
*inferenceArea
5 
*cust_cvs_StemFrequency
6 
*dba_src_ID
7 
*entry_herbLineID
8 
*entry_treeLineID
9 
*cust_cvs_corner1Presence
10 
*cust_cvs_corner2Presence
11 
*cust_cvs_corner3Presence
12 
*cust_cvs_corner4Presence
13 
*cust_cvs_corner5Presence
14 
*cust_cvs_originalCoverCode
inputs/CVS/stemCount/header.csv
1 
STEMCOUNT_ID,TAXONIMPORTANCE_ID,stemDiameter,stemDiameterAccuracy,stemHeight,stemHeightAccuracy,stemCount,stemTaxonArea,dba_src_ID,cust_cvs_ddh,cust_cvs_ddhAccuracy,cust_cvs_isPlanted,cust_cvs_subsamplingFactor,entry_herbLineID,entry_treeLineID,entry_recordCount,entry_sortOrder
inputs/CVS/stemCount/map.csv
1 
CVS,VegCore,Filter,Comments
2 
STEMCOUNT_ID,individualID,,
3 
TAXONIMPORTANCE_ID,aggregateOccurrenceID,,
4 
stemDiameter,diameterBreastHeight_cm,,
5 
stemDiameterAccuracy,*stemDiameterAccuracy,,
6 
stemHeight,height_m,,
7 
stemHeightAccuracy,*stemHeightAccuracy,,
8 
stemCount,stemCount,,
9 
stemTaxonArea,*stemTaxonArea,,
10 
dba_src_ID,*dba_src_ID,,
11 
cust_cvs_ddh,*cust_cvs_ddh,,
12 
cust_cvs_ddhAccuracy,*cust_cvs_ddhAccuracy,,
13 
cust_cvs_isPlanted,*cust_cvs_isPlanted,,
14 
cust_cvs_subsamplingFactor,*cust_cvs_subsamplingFactor,,
15 
entry_herbLineID,*entry_herbLineID,,
16 
entry_treeLineID,*entry_treeLineID,,
17 
entry_recordCount,*entry_recordCount,,
18 
entry_sortOrder,*entry_sortOrder,,
inputs/CVS/stemCount/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>CVS</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationevent>
11 
                            <taxonoccurrence>
12 
                                <aggregateoccurrence>
13 
                                    <plantobservation>
14 
                                        <sourceaccessioncode>$STEMCOUNT_ID</sourceaccessioncode>
15 
                                        <stemcount>$stemCount</stemcount>
16 
                                        <stemobservation>
17 
                                            <diameterbreastheight_m><_cm_to_m><value>$stemDiameter</value></_cm_to_m></diameterbreastheight_m>
18 
                                            <height_m>$stemHeight</height_m>
19 
                                        </stemobservation>
20 
                                    </plantobservation>
21 
                                    <sourceaccessioncode>$TAXONIMPORTANCE_ID</sourceaccessioncode>
22 
                                </aggregateoccurrence>
23 
                            </taxonoccurrence>
24 
                        </locationevent>
25 
                    </location>
26 
                </path>
27 
            </_simplifyPath>
28 
        </path>
29 
    </_setDefault>
30 
</VegBIEN>
31 
Inserted 4 new rows into database
inputs/CVS/stemCount/VegBIEN.csv
1 
CVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
STEMCOUNT_ID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
3 
STEMCOUNT_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
4 
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
5 
stemDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,
6 
stemHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,
7 
TAXONIMPORTANCE_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,
8 
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
9 
TAXONIMPORTANCE_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",
10 
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",
11 
cust_cvs_ddh,,** No join mapping for *cust_cvs_ddh **
12 
cust_cvs_ddhAccuracy,,** No join mapping for *cust_cvs_ddhAccuracy **
13 
cust_cvs_isPlanted,,** No join mapping for *cust_cvs_isPlanted **
14 
cust_cvs_subsamplingFactor,,** No join mapping for *cust_cvs_subsamplingFactor **
15 
dba_src_ID,,** No join mapping for *dba_src_ID **
16 
entry_herbLineID,,** No join mapping for *entry_herbLineID **
17 
entry_recordCount,,** No join mapping for *entry_recordCount **
18 
entry_sortOrder,,** No join mapping for *entry_sortOrder **
19 
entry_treeLineID,,** No join mapping for *entry_treeLineID **
20 
stemDiameterAccuracy,,** No join mapping for *stemDiameterAccuracy **
21 
stemHeightAccuracy,,** No join mapping for *stemHeightAccuracy **
22 
stemTaxonArea,,** No join mapping for *stemTaxonArea **
inputs/CVS/stemCount/new_terms.csv
1 
STEMCOUNT_ID,individualID,,
2 
TAXONIMPORTANCE_ID,aggregateOccurrenceID,,
3 
stemDiameter,diameterBreastHeight_cm,,
4 
stemHeight,height_m,,
inputs/CVS/stemCount/unmapped_terms.csv
1 
*stemDiameterAccuracy
2 
*stemHeightAccuracy
3 
*stemTaxonArea
4 
*dba_src_ID
5 
*cust_cvs_ddh
6 
*cust_cvs_ddhAccuracy
7 
*cust_cvs_isPlanted
8 
*cust_cvs_subsamplingFactor
9 
*entry_herbLineID
10 
*entry_treeLineID
11 
*entry_recordCount
12 
*entry_sortOrder
inputs/CVS/stemCount_/header.csv
1 
taxonImportance_ID,taxonObservation_ID,stratum_ID,cover,basalArea,biomass,inferenceArea,cust_cvs_StemFrequency,taxonImportance_dba_src_ID,taxonImportance_entry_herbLineID,taxonImportance_entry_treeLineID,cust_cvs_corner1Presence,cust_cvs_corner2Presence,cust_cvs_corner3Presence,cust_cvs_corner4Presence,cust_cvs_corner5Presence,cust_cvs_originalCoverCode,STEMCOUNT_ID,stemDiameter,stemDiameterAccuracy,stemHeight,stemHeightAccuracy,stemCount,stemTaxonArea,stemCount_dba_src_ID,cust_cvs_ddh,cust_cvs_ddhAccuracy,cust_cvs_isPlanted,cust_cvs_subsamplingFactor,stemCount_entry_herbLineID,stemCount_entry_treeLineID,entry_recordCount,entry_sortOrder
inputs/CVS/stemCount_/map.csv
1 
CVS,VegCore,Filter,Comments
2 
taxonImportance_ID,OMIT,,Omitted because STEMCOUNT_ID is more specific
3 
taxonObservation_ID,taxonOccurrenceID,,
4 
stratum_ID,*stratum_id,,
5 
cover,coverPercent,,
6 
basalArea,*basalarea,,
7 
biomass,*biomass,,
8 
inferenceArea,*inferencearea,,
9 
cust_cvs_StemFrequency,*cust_cvs_StemFrequency,,
10 
taxonImportance_dba_src_ID,*taxonImportance_dba_src_ID,,
11 
taxonImportance_entry_herbLineID,*taxonImportance_entry_herbLineID,,
12 
taxonImportance_entry_treeLineID,*taxonImportance_entry_treeLineID,,
13 
cust_cvs_corner1Presence,*cust_cvs_corner1Presence,,
14 
cust_cvs_corner2Presence,*cust_cvs_corner2Presence,,
15 
cust_cvs_corner3Presence,*cust_cvs_corner3Presence,,
16 
cust_cvs_corner4Presence,*cust_cvs_corner4Presence,,
17 
cust_cvs_corner5Presence,*cust_cvs_corner5Presence,,
18 
cust_cvs_originalCoverCode,*cust_cvs_originalCoverCode,,
19 
STEMCOUNT_ID,aggregateOccurrenceID,,
20 
stemDiameter,diameterBreastHeight_cm,,
21 
stemDiameterAccuracy,*stemdiameteraccuracy,,
22 
stemHeight,height_m,,
23 
stemHeightAccuracy,*stemheightaccuracy,,
24 
stemCount,individualCount,,
25 
stemTaxonArea,*stemtaxonarea,,
26 
stemCount_dba_src_ID,*stemCount_dba_src_ID,,
27 
cust_cvs_ddh,*cust_cvs_ddh,,
28 
cust_cvs_ddhAccuracy,*cust_cvs_ddhAccuracy,,
29 
cust_cvs_isPlanted,*cust_cvs_isPlanted,,
30 
cust_cvs_subsamplingFactor,*cust_cvs_subsamplingFactor,,
31 
stemCount_entry_herbLineID,*stemCount_entry_herbLineID,,
32 
stemCount_entry_treeLineID,*stemCount_entry_treeLineID,,
33 
entry_recordCount,*entry_recordCount,,
34 
entry_sortOrder,*entry_sortOrder,,
inputs/CVS/stemCount_/VegBIEN.csv
1 
CVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
taxonObservation_ID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
3 
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
4 
cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,
5 
stemDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,
6 
stemHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,
7 
STEMCOUNT_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,
8 
taxonObservation_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
9 
taxonObservation_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,
10 
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",
11 
basalArea,,** No join mapping for *basalarea **
12 
biomass,,** No join mapping for *biomass **
13 
cust_cvs_StemFrequency,,** No join mapping for *cust_cvs_StemFrequency **
14 
cust_cvs_corner1Presence,,** No join mapping for *cust_cvs_corner1Presence **
15 
cust_cvs_corner2Presence,,** No join mapping for *cust_cvs_corner2Presence **
16 
cust_cvs_corner3Presence,,** No join mapping for *cust_cvs_corner3Presence **
17 
cust_cvs_corner4Presence,,** No join mapping for *cust_cvs_corner4Presence **
18 
cust_cvs_corner5Presence,,** No join mapping for *cust_cvs_corner5Presence **
19 
cust_cvs_ddh,,** No join mapping for *cust_cvs_ddh **
20 
cust_cvs_ddhAccuracy,,** No join mapping for *cust_cvs_ddhAccuracy **
21 
cust_cvs_isPlanted,,** No join mapping for *cust_cvs_isPlanted **
22 
cust_cvs_originalCoverCode,,** No join mapping for *cust_cvs_originalCoverCode **
23 
cust_cvs_subsamplingFactor,,** No join mapping for *cust_cvs_subsamplingFactor **
24 
entry_recordCount,,** No join mapping for *entry_recordCount **
25 
entry_sortOrder,,** No join mapping for *entry_sortOrder **
26 
inferenceArea,,** No join mapping for *inferencearea **
27 
stemCount_dba_src_ID,,** No join mapping for *stemCount_dba_src_ID **
28 
stemCount_entry_herbLineID,,** No join mapping for *stemCount_entry_herbLineID **
29 
stemCount_entry_treeLineID,,** No join mapping for *stemCount_entry_treeLineID **
30 
stemDiameterAccuracy,,** No join mapping for *stemdiameteraccuracy **
31 
stemHeightAccuracy,,** No join mapping for *stemheightaccuracy **
32 
stemTaxonArea,,** No join mapping for *stemtaxonarea **
33 
stratum_ID,,** No join mapping for *stratum_id **
34 
taxonImportance_ID,,** No non-empty join mapping for OMIT ** Omitted because STEMCOUNT_ID is more specific
35 
taxonImportance_dba_src_ID,,** No join mapping for *taxonImportance_dba_src_ID **
36 
taxonImportance_entry_herbLineID,,** No join mapping for *taxonImportance_entry_herbLineID **
37 
taxonImportance_entry_treeLineID,,** No join mapping for *taxonImportance_entry_treeLineID **
inputs/CVS/stemCount_/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_setDefault id="-1">
4 
        <source_id><source><shortname>CVS</shortname></source></source_id>
5 
        <path>
6 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <locationevent>
11 
                            <taxonoccurrence>
12 
                                <aggregateoccurrence>
13 
                                    <count>$stemCount</count>
14 
                                    <cover_fraction><_percent_to_fraction><value>$cover</value></_percent_to_fraction></cover_fraction>
15 
                                    <plantobservation>
16 
                                        <stemobservation>
17 
                                            <diameterbreastheight_m><_cm_to_m><value>$stemDiameter</value></_cm_to_m></diameterbreastheight_m>
18 
                                            <height_m>$stemHeight</height_m>
19 
                                        </stemobservation>
20 
                                    </plantobservation>
21 
                                    <sourceaccessioncode>$STEMCOUNT_ID</sourceaccessioncode>
22 
                                </aggregateoccurrence>
23 
                                <sourceaccessioncode>$taxonObservation_ID</sourceaccessioncode>
24 
                            </taxonoccurrence>
25 
                        </locationevent>
26 
                    </location>
27 
                </path>
28 
            </_simplifyPath>
29 
        </path>
30 
    </_setDefault>
31 
</VegBIEN>
32 
Inserted 8 new rows into database
inputs/CVS/stemCount_/new_terms.csv
1 
taxonImportance_ID,OMIT,,Omitted because STEMCOUNT_ID is more specific
2 
taxonObservation_ID,taxonOccurrenceID,,
3 
cover,coverPercent,,
4 
STEMCOUNT_ID,aggregateOccurrenceID,,
5 
stemDiameter,diameterBreastHeight_cm,,
6 
stemHeight,height_m,,
inputs/CVS/stemCount_/unmapped_terms.csv
1 
*stratum_id
2 
*basalarea
3 
*biomass
4 
*inferencearea
5 
*cust_cvs_StemFrequency
6 
*taxonImportance_dba_src_ID
7 
*taxonImportance_entry_herbLineID
8 
*taxonImportance_entry_treeLineID
9 
*cust_cvs_corner1Presence
10 
*cust_cvs_corner2Presence
11 
*cust_cvs_corner3Presence
12 
*cust_cvs_corner4Presence
13 
*cust_cvs_corner5Presence
14 
*cust_cvs_originalCoverCode
15 
*stemdiameteraccuracy
16 
*stemheightaccuracy
17 
*stemtaxonarea
18 
*stemCount_dba_src_ID
19 
*cust_cvs_ddh
20 
*cust_cvs_ddhAccuracy
21 
*cust_cvs_isPlanted
22 
*cust_cvs_subsamplingFactor
23 
*stemCount_entry_herbLineID
24 
*stemCount_entry_treeLineID
25 
*entry_recordCount
26 
*entry_sortOrder
inputs/CVS/import_order.txt
2 2 
plot_
3 3 
observation_
4 4 
taxonObservation_
5 
taxonImportance
6 
stemCount
5 
stemCount_
7 6 
stemLocation
inputs/CVS/cvs.~.clean_up.sql
1 
-- Ensure column names have the same capitalization everywhere
2 
ALTER TABLE "stemCount" RENAME "TAXONIMPORTANCE_ID" TO "taxonImportance_ID";
3 

  		




  1
  4
  
    
-- Prevent "column name specified more than once" errors when tables are joined


  		




  2
  5
  
    
ALTER TABLE "soilObs" RENAME "dba_src_ID" TO "soilObs_dba_src_ID";


  		




  3
  6
  
    
ALTER TABLE "taxonObservation" RENAME "reference_ID" TO "taxonObservation_reference_ID";


  		




  4
  7
  
    
ALTER TABLE "taxonObservation" RENAME "accessionCode" TO "taxonObservation_accessionCode";


  		




  5
  8
  
    
ALTER TABLE "taxonObservation" RENAME "dba_src_ID" TO "taxonObservation_dba_src_ID";


  		




  6
  9
  
    
ALTER TABLE "taxonObservation" RENAME "entry_sppID" TO "taxonObservation_entry_sppID";


  		




  
  10
  
    
ALTER TABLE "taxonImportance" RENAME "dba_src_ID" TO "taxonImportance_dba_src_ID";


  		




  
  11
  
    
ALTER TABLE "taxonImportance" RENAME "entry_herbLineID" TO "taxonImportance_entry_herbLineID";


  		




  
  12
  
    
ALTER TABLE "taxonImportance" RENAME "entry_treeLineID" TO "taxonImportance_entry_treeLineID";


  		




  
  13
  
    
ALTER TABLE "stemCount" RENAME "dba_src_ID" TO "stemCount_dba_src_ID";


  		




  
  14
  
    
ALTER TABLE "stemCount" RENAME "entry_herbLineID" TO "stemCount_entry_herbLineID";


  		




  
  15
  
    
ALTER TABLE "stemCount" RENAME "entry_treeLineID" TO "stemCount_entry_treeLineID";


  		




  7
  16
  
    
ALTER TABLE "taxonInterpretation" RENAME "PARTY_ID" TO "taxonInterpretation_PARTY_ID";


  		




  8
  17
  
    
ALTER TABLE "taxonInterpretation" RENAME "PLANTNAME_ID" TO "taxonInterpretation_PLANTNAME_ID";


  		




  9
  18
  
    
ALTER TABLE "taxonInterpretation" RENAME "dba_src_ID" TO "taxonInterpretation_dba_src_ID";


  		












  

    
      inputs/CVS/stemLocation/map.csv
    
  





  1
  1
  
    
CVS,VegCore,Filter,Comments


  		




  2
  2
  
    
STEMLOCATION_ID,stemID,,


  		




  3
  
  
    
STEMCOUNT_ID,individualID,,


  		




  
  3
  
    
STEMLOCATION_ID,individualID,,


  		




  
  4
  
    
STEMCOUNT_ID,aggregateOccurrenceID,,


  		




  4
  5
  
    
stemCode,authorStemCode,,


  		




  5
  6
  
    
stemXPosition,organismX_m,,


  		




  6
  7
  
    
stemYPosition,organismY_m,,


  		












  

    
      inputs/CVS/stemLocation/VegBIEN.csv
    
  





  1
  1
  
    
CVS,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments


  		




  2
  
  
    
STEMCOUNT_ID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  3
  
  
    
STEMCOUNT_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,


  		




  
  2
  
    
STEMLOCATION_ID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  3
  
    
STEMLOCATION_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,


  		




  4
  4
  
    
stemCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,


  		




  5
  5
  
    
STEMLOCATION_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,


  		




  6
  6
  
    
stemXPosition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,


  		




  7
  7
  
    
stemYPosition,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,


  		




  8
  
  
    
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  9
  
  
    
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",


  		




  
  8
  
    
STEMCOUNT_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,


  		




  
  9
  
    
STEMLOCATION_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  10
  
    
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",


  		




  
  11
  
    
STEMLOCATION_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",


  		




  10
  12
  
    
cust_cvs_resprout,,** No join mapping for *cust_cvs_resprout ** 


  		




  11
  13
  
    
cust_cvs_stemComment,,** No join mapping for *cust_cvs_stemComment ** 


  		




  12
  14
  
    
cust_cvs_stemSource,,** No join mapping for *cust_cvs_stemSource ** 


  		












  

    
      inputs/CVS/stemLocation/test.xml.ref
    
  





  11
  11
  
    
                            <taxonoccurrence>


  		




  12
  12
  
    
                                <aggregateoccurrence>


  		




  13
  13
  
    
                                    <plantobservation>


  		




  14
  
  
    
                                        <sourceaccessioncode>$STEMCOUNT_ID</sourceaccessioncode>


  		




  
  14
  
    
                                        <sourceaccessioncode>$STEMLOCATION_ID</sourceaccessioncode>


  		




  15
  15
  
    
                                        <stemobservation>


  		




  16
  16
  
    
                                            <authorstemcode>$stemCode</authorstemcode>


  		




  17
  17
  
    
                                            <sourceaccessioncode>$STEMLOCATION_ID</sourceaccessioncode>


  		




  ......




  19
  19
  
    
                                            <yposition_m>$stemYPosition</yposition_m>


  		




  20
  20
  
    
                                        </stemobservation>


  		




  21
  21
  
    
                                    </plantobservation>


  		




  
  22
  
    
                                    <sourceaccessioncode>$STEMCOUNT_ID</sourceaccessioncode>


  		




  22
  23
  
    
                                </aggregateoccurrence>


  		




  23
  
  
    
                                <sourceaccessioncode>$STEMCOUNT_ID</sourceaccessioncode>


  		




  24
  24
  
    
                            </taxonoccurrence>


  		




  25
  25
  
    
                        </locationevent>


  		




  26
  26
  
    
                    </location>


  		












  

    
      inputs/CVS/stemLocation/new_terms.csv
    
  





  1
  1
  
    
STEMLOCATION_ID,stemID,,


  		




  2
  
  
    
STEMCOUNT_ID,individualID,,


  		




  
  2
  
    
STEMLOCATION_ID,individualID,,


  		




  
  3
  
    
STEMCOUNT_ID,aggregateOccurrenceID,,


  		




  3
  4
  
    
stemCode,authorStemCode,,


  		




  4
  5
  
    
stemXPosition,organismX_m,,


  		




  5
  6
  
    
stemYPosition,organismY_m,,


  		












Also available in:  Unified diff