Revision 9778
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/GBIF/raw_occurrence_record_plants/run | ||
|---|---|---|
| 114 | 114 |
SELECT * FROM $full_table |
| 115 | 115 |
WHERE deleted IS NULL |
| 116 | 116 |
AND institution_code IN (SELECT * FROM herbaria_filter) |
| 117 |
AND ( |
|
| 118 |
family IS NULL |
|
| 119 |
OR (family LIKE '%aceae%' OR family IN ('Compositae','Gramineae','Palmae','Guttiferae','Cruciferae','Labiatae','Umbelliferae','Leguminosae'))
|
|
| 120 |
) |
|
| 117 | 121 |
EOF |
| 118 | 122 |
) || skip_table || return 0 |
| 119 | 123 |
} |
Also available in: Unified diff
bugfix: inputs/GBIF/raw_occurrence_record_plants/run: table/make(): also filter out rows with a non-plant family (as described at http://vegpath.org/wiki/2013-06-06_conference_call#GBIF-subsetting-fix-raw_occurrence_record-filter-formula), since some institutions have both animal and plant rows, even though they are in IH or in the 80% list. (note that NULL families are OK.)