Project

General

Profile

« Previous | Next » 

Revision 13921

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: added is_threatened_iucn

View differences:

trunk/schemas/public_.sql
6160 6160 
    subspecies(analytical_stem.scrubbed_taxon_name_no_author) AS accepted_subspecies,
6161 6161 
    analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" AS dbh_cm,
6162 6162 
    analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" AS height_m,
6163 
    analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" AS lifeform
6163 
    analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" AS lifeform,
6164 
    in_iucn_red_list(analytical_stem.scrubbed_family, analytical_stem.scrubbed_species_binomial) AS is_threatened_iucn
6164 6165 
   FROM analytical_stem
6165 6166 
  WHERE (((((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS NOT NULL)) AND (analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS NOT NULL)) AND in_south_america(ROW(analytical_stem."decimalLatitude__@DwC__@vegpath.org", analytical_stem."decimalLongitude__@DwC__@vegpath.org"))) AND COALESCE((analytical_stem."taxonomicStatus__@DwC__@vegpath.org" = 'accepted'::text), false));
6166 6167 

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  6160
  6160
  
    
    subspecies(analytical_stem.scrubbed_taxon_name_no_author) AS accepted_subspecies,


  		




  6161
  6161
  
    
    analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" AS dbh_cm,


  		




  6162
  6162
  
    
    analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" AS height_m,


  		




  6163
  
  
    
    analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" AS lifeform


  		




  
  6163
  
    
    analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" AS lifeform,


  		




  
  6164
  
    
    in_iucn_red_list(analytical_stem.scrubbed_family, analytical_stem.scrubbed_species_binomial) AS is_threatened_iucn


  		




  6164
  6165
  
    
   FROM analytical_stem


  		




  6165
  6166
  
    
  WHERE (((((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS NOT NULL)) AND (analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS NOT NULL)) AND in_south_america(ROW(analytical_stem."decimalLatitude__@DwC__@vegpath.org", analytical_stem."decimalLongitude__@DwC__@vegpath.org"))) AND COALESCE((analytical_stem."taxonomicStatus__@DwC__@vegpath.org" = 'accepted'::text), false));


  		




  6166
  6167
  
    

  		












Also available in:  Unified diff