Project

General

Profile

« Previous | Next » 

Revision 9639

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.

View differences:

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