Project

General

Profile

« Previous | Next » 

Revision 12941

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: implemented _specimens_15_list_distinct_locality_descriptions

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
88 88 
;
89 89 

  		




  90
  90
  
    
CREATE VIEW _specimens_15_list_distinct_locality_descriptions AS


  		




  
  91
  
    
SELECT DISTINCT locationnarrative AS "localityDescription"


  		




  
  92
  
    
FROM location


  		




  
  93
  
    
WHERE location.source_id = (SELECT source_by_shortname('NY'))


  		




  
  94
  
    
AND locationnarrative IS NOT NULL


  		




  91
  95
  
    
;


  		




  92
  96
  
    

  		




  93
  97
  
    
CREATE VIEW _specimens_16_list_distinct_specimen_descriptions AS


  		












Also available in:  Unified diff