Project

General

Profile

« Previous | Next » 

Revision 13044

Added by Aaron Marcuse-Kubitza over 10 years ago

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

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
86 86 
;
87 87 

  		




  88
  88
  
    
CREATE VIEW _specimens_11_list_of_three_standard_political_divisions AS


  		




  
  89
  
    
SELECT DISTINCT country, stateprovince, county


  		




  
  90
  
    
FROM place


  		




  
  91
  
    
WHERE place.source_id = (SELECT source_by_shortname('NY'))


  		




  89
  92
  
    
;


  		




  90
  93
  
    
COMMENT ON VIEW _specimens_01_count_of_total_records_specimens_in_source_db IS '


  		




  91
  94
  
    
Note: character set issues may cause mis-matches. This query is a good way to reveal character set issues, either in source db or in BIEN


  		












Also available in:  Unified diff