Revision 11487
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/VegBank/plot_/postprocess.sql | ||
|---|---|---|
| 3 | 3 |
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("locationID")$$); -- runtime: 0.2 s ("Time: 238.474 ms") @starscream
|
| 4 | 4 |
|
| 5 | 5 |
|
| 6 |
-- remove institutions that we have direct data for |
|
| 7 |
|
|
| 8 |
-- CVS |
|
| 9 |
DELETE FROM :table |
|
| 10 |
WHERE "locationName" IN (SELECT "authorPlotCode" FROM "CVS".plot) |
|
| 11 |
-- removes 2323 of 7079 CVS plots (75340 - 73017) |
|
| 12 |
; -- runtime: 0.1 s ("109.790 ms") @starscream
|
|
| 13 |
|
|
| 14 |
|
|
| 6 | 15 |
-- map_*() derived cols |
| 7 | 16 |
-- runtime: 2 s @starscream |
| 8 | 17 |
|
Also available in: Unified diff
inputs/VegBank/plot_/postprocess.sql: remove duplicated CVS plots (2323 of 7079 CVS plots are removed by this)