Project

General

Profile

« Previous | Next » 

Revision 12965

Added by Aaron Marcuse-Kubitza over 10 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: use taxonoccurrence instead of location as the table that all specimens should have, as decided in the 2014-03-27 conference call (wiki.vegpath.org/2014-03-27_conference_call#aggregating-validations)

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
15 15 

  		




  16
  16
  
    
CREATE VIEW _specimens_01_count_of_total_records_specimens_in_source_db AS


  		




  17
  17
  
    
SELECT count(*) AS "totalSpecimenRecords"


  		




  18
  
  
    
FROM location


  		




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


  		




  
  18
  
    
FROM taxonoccurrence


  		




  
  19
  
    
WHERE taxonoccurrence.source_id = (SELECT source_by_shortname('NY'))


  		




  20
  20
  
    
;


  		




  21
  21
  
    

  		




  22
  22
  
    
CREATE VIEW _specimens_02_count_of_unique_verbatim_families AS


  		












Also available in:  Unified diff