Revision 13785
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 5494 | 5494 |
analytical_stem.scrubbed_species_binomial AS "speciesBinomial", |
| 5495 | 5495 |
analytical_stem.scrubbed_taxon_name_with_author AS "scientificName" |
| 5496 | 5496 |
FROM analytical_stem |
| 5497 |
WHERE ((((((COALESCE((analytical_stem.geovalid_bien)::boolean, false) AND COALESCE((analytical_stem."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem.scrubbed_family IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL)) AND COALESCE((analytical_stem."coordinateUncertaintyInMeters" <= _km_to_m((10)::double precision)), true));
|
|
| 5497 |
WHERE ((((((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND COALESCE((analytical_stem."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem.scrubbed_family IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL)) AND COALESCE((analytical_stem."coordinateUncertaintyInMeters" <= _km_to_m((10)::double precision)), true));
|
|
| 5498 | 5498 |
|
| 5499 | 5499 |
|
| 5500 | 5500 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 5494 | 5494 |
analytical_stem.scrubbed_species_binomial AS "speciesBinomial", |
| 5495 | 5495 |
analytical_stem.scrubbed_taxon_name_with_author AS "scientificName" |
| 5496 | 5496 |
FROM analytical_stem |
| 5497 |
WHERE ((((((COALESCE((analytical_stem.geovalid_bien)::boolean, false) AND COALESCE((analytical_stem."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem.scrubbed_family IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL)) AND COALESCE((analytical_stem."coordinateUncertaintyInMeters" <= _km_to_m((10)::double precision)), true));
|
|
| 5497 |
WHERE ((((((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND COALESCE((analytical_stem."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem.scrubbed_family IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL)) AND COALESCE((analytical_stem."coordinateUncertaintyInMeters" <= _km_to_m((10)::double precision)), true));
|
|
| 5498 | 5498 |
|
| 5499 | 5499 |
|
| 5500 | 5500 |
-- |
Also available in: Unified diff
schemas/public_.sql: 2014-6-12.Jeff_Ott.climatic_range_determinants: allow geovalid_bien = NULL to enable filtering New World status by coordinates rather than country