Revision 10337
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/REMIB/Specimen/postprocess.sql | ||
|---|---|---|
| 8 | 8 |
DELETE FROM :table WHERE coll_year !~ '^(?:1[7-9]|20)\d{2}$';
|
| 9 | 9 |
DELETE FROM :table WHERE country ~ '\d'; |
| 10 | 10 |
DELETE FROM :table WHERE long_deg ~ '[[:alpha:]]' AND long_deg NOT IN ('RESTRINGIDO');
|
| 11 |
DELETE FROM :table WHERE long_min !~ '^\d*$'; |
|
| 11 | 12 |
|
| 12 | 13 |
-- Remove institutions that we have direct data for |
| 13 | 14 |
DELETE FROM :table |
Also available in: Unified diff
inputs/REMIB/Specimen/postprocess.sql: remove frameshifted rows: remove rows where long_min is not a number