Project

General

Profile

« Previous | Next » 

Revision 13147

Added by Aaron Marcuse-Kubitza almost 11 years ago

bugfix: inputs/NY/validations.sql, schemas/vegbien.sql: _specimens_13*: also need to include coordinate pairs which have one of their coordinates NULL, by using OR instead of AND

View differences:

validations.sql
255 255 
CREATE VIEW _specimens_13_count_of_all_verbatim_and_decimal_lat_long AS
256 256 
 SELECT ( SELECT count(DISTINCT ROW("Ecatalog_all"."decimalLatitude", "Ecatalog_all"."decimalLongitude")) AS count
257 257 
           FROM "Ecatalog_all"
258 
          WHERE (("Ecatalog_all"."decimalLatitude" IS NOT NULL) AND ("Ecatalog_all"."decimalLongitude" IS NOT NULL))) AS "allLatLongs",
258 
          WHERE (("Ecatalog_all"."decimalLatitude" IS NOT NULL) OR ("Ecatalog_all"."decimalLongitude" IS NOT NULL))) AS "allLatLongs",
259 259 
    ( SELECT count(DISTINCT ROW("Ecatalog_all"."decimalLatitude", "Ecatalog_all"."decimalLongitude")) AS count
260 260 
           FROM "Ecatalog_all"
261 261 
          WHERE (is_castable("Ecatalog_all"."decimalLatitude", NULL::double precision) AND is_castable("Ecatalog_all"."decimalLongitude", NULL::double precision))) AS "decimalLatLongs";
......
278 278 
 SELECT DISTINCT "Ecatalog_all"."decimalLatitude" AS "verbatimLatitude",
279 279 
    "Ecatalog_all"."decimalLongitude" AS "verbatimLongitude"
280 280 
   FROM "Ecatalog_all"
281 
  WHERE (("Ecatalog_all"."decimalLatitude" IS NOT NULL) AND ("Ecatalog_all"."decimalLongitude" IS NOT NULL));
281 
  WHERE (("Ecatalog_all"."decimalLatitude" IS NOT NULL) OR ("Ecatalog_all"."decimalLongitude" IS NOT NULL));
282 282 

  		




  283
  283
  
    

  		




  284
  284
  
    
--


  		












Also available in:  Unified diff