Project

General

Profile

« Previous | Next » 

Revision 10338

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/REMIB/Specimen/postprocess.sql: remove frameshifted rows: also filter out non-numbers for long_sec, lat_min, lat_sec

View differences:

inputs/REMIB/Specimen/postprocess.sql
9 9 
DELETE FROM :table WHERE country ~ '\d';
10 10 
DELETE FROM :table WHERE long_deg ~ '[[:alpha:]]' AND long_deg NOT IN ('RESTRINGIDO');
11 11 
DELETE FROM :table WHERE long_min !~ '^\d*$';
12 
DELETE FROM :table WHERE long_sec !~ '^\d*$';
13 
DELETE FROM :table WHERE lat_min  !~ '^\d*$';
14 
DELETE FROM :table WHERE lat_sec  !~ '^\d*$';
12 15 

  		




  13
  16
  
    
-- Remove institutions that we have direct data for


  		




  14
  17
  
    
DELETE FROM :table


  		












Also available in:  Unified diff