Revision 14525
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 10651 | 10651 |
view_full_occurrence_individual.state_province AS "stateProvince", |
| 10652 | 10652 |
view_full_occurrence_individual.county |
| 10653 | 10653 |
FROM view_full_occurrence_individual |
| 10654 |
WHERE (((COALESCE((view_full_occurrence_individual.is_geovalid)::boolean, false) AND (COALESCE((view_full_occurrence_individual.is_new_world)::boolean, false) OR in_new_world(view_full_occurrence_individual.latitude, view_full_occurrence_individual.longitude))) AND (view_full_occurrence_individual.scrubbed_species_binomial IS NOT NULL)) AND (view_full_occurrence_individual.country IS NOT NULL));
|
|
| 10654 |
WHERE (((COALESCE((view_full_occurrence_individual.is_geovalid)::boolean, false) AND COALESCE((view_full_occurrence_individual.is_new_world)::boolean, false)) AND (view_full_occurrence_individual.scrubbed_species_binomial IS NOT NULL)) AND (view_full_occurrence_individual.country IS NOT NULL));
|
|
| 10655 | 10655 |
|
| 10656 | 10656 |
|
| 10657 | 10657 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 10651 | 10651 |
view_full_occurrence_individual.state_province AS "stateProvince", |
| 10652 | 10652 |
view_full_occurrence_individual.county |
| 10653 | 10653 |
FROM view_full_occurrence_individual |
| 10654 |
WHERE (((COALESCE((view_full_occurrence_individual.is_geovalid)::boolean, false) AND (COALESCE((view_full_occurrence_individual.is_new_world)::boolean, false) OR in_new_world(view_full_occurrence_individual.latitude, view_full_occurrence_individual.longitude))) AND (view_full_occurrence_individual.scrubbed_species_binomial IS NOT NULL)) AND (view_full_occurrence_individual.country IS NOT NULL));
|
|
| 10654 |
WHERE (((COALESCE((view_full_occurrence_individual.is_geovalid)::boolean, false) AND COALESCE((view_full_occurrence_individual.is_new_world)::boolean, false)) AND (view_full_occurrence_individual.scrubbed_species_binomial IS NOT NULL)) AND (view_full_occurrence_individual.country IS NOT NULL));
|
|
| 10655 | 10655 |
|
| 10656 | 10656 |
|
| 10657 | 10657 |
-- |
Also available in: Unified diff
fix: schemas/public_.sql: native_status_resolver: don't include rows with New World coordinates that don't also have New World country names, since the NSR only uses the country name