Project

General

Profile

« Previous | Next » 

Revision 8847

bugfix: schemas/vegbien.sql: geoscrub_input_view: only include places whose country is not NULL, because at least the country is required for geoscrubbing

View differences:

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