| 1 |
8165
|
aaronmk
|
#!/bin/bash
|
| 2 |
|
|
# :mode=transact-sql:
|
| 3 |
|
|
cd "$(dirname "$0")"
|
| 4 |
|
|
. ../../../lib/import.sh
|
| 5 |
|
|
|
| 6 |
|
|
psql <<'EOF'
|
| 7 |
8322
|
aaronmk
|
SELECT force_update_view('"occurrence_all"', $$
|
| 8 |
8327
|
aaronmk
|
SELECT "TREE-row_num" AS "occurrence_all-row_num", *
|
| 9 |
8317
|
aaronmk
|
/* directional joins ensure that the PostgreSQL query planner always joins
|
| 10 |
|
|
starting with the TREE table */
|
| 11 |
|
|
FROM ("REF_RESEARCH_STATION"
|
| 12 |
|
|
NATURAL RIGHT JOIN ("REF_UNIT"
|
| 13 |
|
|
NATURAL RIGHT JOIN ("COUNTY"
|
| 14 |
|
|
NATURAL RIGHT JOIN ("PLOT"
|
| 15 |
|
|
NATURAL RIGHT JOIN ("COND"
|
| 16 |
|
|
NATURAL LEFT JOIN "REF_HABTYP_DESCRIPTION"
|
| 17 |
|
|
NATURAL RIGHT JOIN ("SUBPLOT"
|
| 18 |
|
|
NATURAL RIGHT JOIN ("TREE"
|
| 19 |
|
|
NATURAL LEFT JOIN "REF_SPECIES"
|
| 20 |
|
|
NATURAL LEFT JOIN "REF_PLANT_DICTIONARY"
|
| 21 |
|
|
)))))))
|
| 22 |
8322
|
aaronmk
|
$$);
|
| 23 |
8332
|
aaronmk
|
|
| 24 |
|
|
SELECT mk_subset_by_row_num_func('"occurrence_all"', 'occurrence_all-row_num');
|
| 25 |
8248
|
aaronmk
|
EOF
|
| 26 |
|
|
|
| 27 |
|
|
remake_VegBIEN_mappings
|
