Project

General

Profile

« Previous | Next » 

Revision 10695

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/VegBank/stemcount_/map.csv: aggregateOrganismObservationID: prepend taxonimportance_id so that rows with only a taxonimportance entry (no stemcounts) will also have the required sourceaccessioncode

View differences:

inputs/VegBank/stemcount_/map.csv
1 1 
VegBank,VegCore,Filter,Comments
2 
taxonimportance_id,OMIT#taxonimportance_id,,Omitted because stemcount_id is more specific
2 
taxonimportance_id,aggregateOrganismObservationID,/_join/1,
3 3 
taxonobservation_id,taxonOccurrenceID,,"Note that taxonimportance is not 1:1 with taxonobservation [1].
4 4 

  		




  5
  5
  
    
[1] The following query returns rows:


  		




  ......




  18
  18
  
    
stratumheight,*stratumheight,,


  		




  19
  19
  
    
emb_taxonimportance,*emb_taxonimportance,,


  		




  20
  20
  
    
covercode,*covercode,,


  		




  21
  
  
    
stemcount_id,aggregateOrganismObservationID,,


  		




  
  21
  
    
stemcount_id,aggregateOrganismObservationID,/_join/2,


  		




  22
  22
  
    
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"


  		




  23
  23
  
    
stemdiameteraccuracy,*stemdiameteraccuracy,,


  		




  24
  24
  
    
stemheight,height_m,,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"


  		












  

    
      inputs/VegBank/stemcount_/VegBIEN.csv
    
  





  12
  12
  
    
cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value,


  		




  13
  13
  
    
stemdiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"


  		




  14
  14
  
    
stemheight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"


  		




  15
  
  
    
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode,


  		




  
  15
  
    
taxonimportance_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode/_join/1,


  		




  
  16
  
    
stemcount_id,/location/locationevent/taxonoccurrence/aggregateoccurrence/sourceaccessioncode/_join/2,


  		




  16
  17
  
    
taxonobservation_id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1].


  		




  17
  18
  
    

  		




  18
  19
  
    
[1] The following query returns rows:


  		




  ......




  31
  32
  
    
GROUP BY taxonobservation_id


  		




  32
  33
  
    
HAVING count(distinct taxonimportance_id) > 1


  		




  33
  34
  
    
-----"


  		




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


  		




  
  35
  
    
taxonimportance_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists/_join/1",


  		




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


  		




  35
  37
  
    
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1].


  		




  36
  38
  
    

  		




  37
  39
  
    
[1] The following query returns rows:


  		




  ......




  53
  55
  
    
stratum_id,,** No join mapping for *stratum_id ** 


  		




  54
  56
  
    
stratumbase,,** No join mapping for *stratumbase ** 


  		




  55
  57
  
    
stratumheight,,** No join mapping for *stratumheight ** 


  		




  56
  
  
    
taxonimportance_id,,** No non-empty join mapping for OMIT#taxonimportance_id ** Omitted because stemcount_id is more specific


  		












  

    
      inputs/VegBank/stemcount_/test.xml.ref
    
  





  18
  18
  
    
                                            <height_m>$stemheight</height_m>


  		




  19
  19
  
    
                                        </stemobservation>


  		




  20
  20
  
    
                                    </plantobservation>


  		




  21
  
  
    
                                    <sourceaccessioncode>$stemcount_id</sourceaccessioncode>


  		




  
  21
  
    
                                    <sourceaccessioncode>


  		




  
  22
  
    
                                        <_join>


  		




  
  23
  
    
                                            <1>$taxonimportance_id</1>


  		




  
  24
  
    
                                            <2>$stemcount_id</2>


  		




  
  25
  
    
                                        </_join>


  		




  
  26
  
    
                                    </sourceaccessioncode>


  		




  22
  27
  
    
                                </aggregateoccurrence>


  		




  23
  28
  
    
                                <sourceaccessioncode>$taxonobservation_id</sourceaccessioncode>


  		




  24
  29
  
    
                            </taxonoccurrence>


  		












  

    
      inputs/VegBank/stemcount_/new_terms.csv
    
  





  1
  
  
    
taxonimportance_id,OMIT#taxonimportance_id,,Omitted because stemcount_id is more specific


  		




  
  1
  
    
taxonimportance_id,aggregateOrganismObservationID,/_join/1,


  		




  2
  2
  
    
cover,coverPercent,,


  		




  3
  
  
    
stemcount_id,aggregateOrganismObservationID,,


  		




  
  3
  
    
stemcount_id,aggregateOrganismObservationID,/_join/2,


  		




  4
  4
  
    
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"


  		












Also available in:  Unified diff