Revision 9639
Added by Aaron Marcuse-Kubitza over 11 years ago
inputs/GBIF/raw_occurrence_record/run | ||
---|---|---|
46 | 46 |
table=plant_fraction table_esc= mysql_seal_table |
47 | 47 |
} |
48 | 48 |
|
49 |
plant_fraction_for_herbaria_filter/make() |
|
50 |
{ |
|
51 |
echo_func; set_make_vars; mk_table_esc |
|
52 |
|
|
53 |
use_local_remote |
|
54 |
if remaking; then |
|
55 |
table=plant_fraction_for_herbaria_filter table_esc= mk_drop|mysql_ANSI |
|
56 |
fi |
|
57 |
(benign_error=1 mysql <<'EOF' |
|
58 |
CREATE VIEW `plant_fraction_for_herbaria_filter` AS |
|
59 |
SELECT * FROM `plant_fraction` |
|
60 |
WHERE plant_fraction >= 0.8 |
|
61 |
EOF |
|
62 |
) || table=plant_fraction_for_herbaria_filter skip_table || return 0 |
|
63 |
} |
|
64 |
|
|
49 | 65 |
herbaria_filter.plant_fraction.csv_/make() |
50 | 66 |
{ |
51 | 67 |
echo_func; set_make_vars; check_target_exists |
Also available in: Unified diff
inputs/GBIF/raw_occurrence_record/run: added plant_fraction_for_herbaria_filter/make(). note that for simplicity, plant_fraction_for_herbaria_filter is a view instead of a table.