Revision 9855
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/GBIF/raw_occurrence_record_plants/postprocess.sql | ||
|---|---|---|
| 3 | 3 |
SELECT create_if_not_exists($$CREATE INDEX raw_occurrence_record_plants_institution_code ON raw_occurrence_record_plants ("specimenHolderInstitutions")$$);
|
| 4 | 4 |
|
| 5 | 5 |
-- Remove institutions that we have direct data for |
| 6 |
-- rerun time: ~0 ("Time: 4.924 ms") thanks to index
|
|
| 6 | 7 |
DELETE FROM :table |
| 7 | 8 |
WHERE "specimenHolderInstitutions" IN ( |
| 8 | 9 |
'ACAD' |
Also available in: Unified diff
inputs/GBIF/raw_occurrence_record_plants/postprocess.sql: Remove institutions that we have direct data for: added rerun time (~0 thanks to index, so no problem doing the DELETE each time postprocess.sql is run)