Revision 14524
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 3165 | 3165 |
|
| 3166 | 3166 |
|
| 3167 | 3167 |
-- |
| 3168 |
-- Name: geography(postgis.geometry); Type: FUNCTION; Schema: util; Owner: - |
|
| 3169 |
-- |
|
| 3170 |
|
|
| 3171 |
CREATE FUNCTION geography(geometry postgis.geometry) RETURNS postgis.geography |
|
| 3172 |
LANGUAGE sql IMMUTABLE |
|
| 3173 |
SET client_min_messages TO 'warning' |
|
| 3174 |
AS $$ |
|
| 3175 |
/* `SET client_min_messages = WARNING`: hide "Coordinate values were coerced |
|
| 3176 |
into range [-180 -90, 180 90] for GEOGRAPHY" NOTICEs, which clutter up the view |
|
| 3177 |
export output */ |
|
| 3178 |
SELECT geometry::postgis.geography |
|
| 3179 |
$$; |
|
| 3180 |
|
|
| 3181 |
|
|
| 3182 |
-- |
|
| 3168 | 3183 |
-- Name: geometry(geocoord); Type: FUNCTION; Schema: util; Owner: - |
| 3169 | 3184 |
-- |
| 3170 | 3185 |
|
| 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, true) 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) 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));
|
|
| 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, true) 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) 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));
|
|
| 10655 | 10655 |
|
| 10656 | 10656 |
|
| 10657 | 10657 |
-- |
Also available in: Unified diff
schemas/public_.sql: native_status_resolver: removed rows with is_geovalid NULL, at Brad's request. note that this removes valid rows with standardized country names.