Revision 8847
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 3062 | 3062 |
-- |
| 3063 | 3063 |
|
| 3064 | 3064 |
CREATE VIEW geoscrub_input_view AS |
| 3065 |
SELECT DISTINCT place.country, place.stateprovince AS "stateProvince", place.county, coordinates.latitude_deg AS "decimalLatitude", coordinates.longitude_deg AS "decimalLongitude" FROM (place JOIN coordinates USING (coordinates_id)); |
|
| 3065 |
SELECT DISTINCT place.country, place.stateprovince AS "stateProvince", place.county, coordinates.latitude_deg AS "decimalLatitude", coordinates.longitude_deg AS "decimalLongitude" FROM (place JOIN coordinates USING (coordinates_id)) WHERE (place.country IS NOT NULL);
|
|
| 3066 | 3066 |
|
| 3067 | 3067 |
|
| 3068 | 3068 |
-- |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: geoscrub_input_view: only include places whose country is not NULL, because at least the country is required for geoscrubbing