Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Postgis Plugin: PSQL error:
- ERROR: column "height" does not exist
- LINE 1: SELECT ST_AsBinary("way") AS geom,"feature","height","name",...
- ^
- Full sql was: 'SELECT ST_AsBinary("way") AS geom,"feature","height","name","religion","way_pixels","width" FROM (SELECT
- way, name, religion, way_pixels,
- COALESCE(aeroway, amenity, wetland, power, landuse, leisure, military, "natural", tourism, highway, railway) AS feature
- FROM (SELECT
- way, COALESCE(name, '') AS name,
- ('aeroway_' || (CASE WHEN aeroway IN ('apron', 'aerodrome') THEN aeroway ELSE NULL END)) AS aeroway,
- ('amenity_' || (CASE WHEN amenity IN ('parking', 'bicycle_parking', 'motorcycle_parking', 'university', 'college', 'school',
- 'hospital', 'kindergarten', 'grave_yard', 'prison', 'place_of_worship', 'clinic')
- THEN amenity ELSE NULL END)) AS amenity,
- ('landuse_' || (CASE WHEN landuse IN ('quarry', 'vineyard', 'orchard', 'cemetery', 'residential', 'garages', 'meadow', 'grass',
- 'allotments', 'forest', 'farmyard', 'farm', 'farmland', 'greenhouse_horticulture',
- 'recreation_ground', 'village_green', 'retail', 'industrial', 'railway', 'commercial',
- 'brownfield', 'landfill', 'construction') THEN landuse ELSE NULL END)) AS landuse,
- ('leisure_' || (CASE WHEN leisure IN ('swimming_pool', 'playground', 'park', 'recreation_ground', 'common', 'garden',
- 'golf_course', 'miniature_golf', 'picnic_table', 'sports_centre', 'stadium', 'pitch',
- 'track') THEN leisure ELSE NULL END)) AS leisure,
- ('military_' || (CASE WHEN military IN ('danger_area') THEN military ELSE NULL END)) AS military,
- ('natural_' || (CASE WHEN "natural" IN ('beach', 'heath', 'grassland', 'wood', 'sand', 'scree', 'shingle', 'bare_rock', 'scrub') THEN "natural" ELSE NULL END)) AS "natural",
- ('wetland_' || (CASE WHEN "natural" IN ('wetland', 'marsh', 'mud') THEN (CASE WHEN "natural" IN ('marsh', 'mud') THEN "natural" ELSE wetland END) ELSE NULL END)) AS wetland,
- ('power_' || (CASE WHEN power IN ('station', 'sub_station', 'substation', 'generator') THEN power ELSE NULL END)) AS power,
- ('tourism_' || (CASE WHEN tourism IN ('attraction', 'camp_site', 'caravan_site', 'picnic_site') THEN tourism ELSE NULL END)) AS tourism,
- ('highway_' || (CASE WHEN highway IN ('services', 'rest_area') THEN highway ELSE NULL END)) AS highway,
- ('railway_' || (CASE WHEN railway = 'station' THEN railway ELSE NULL END)) AS railway,
- CASE WHEN religion IN ('christian', 'jewish') THEN religion ELSE 'INT-generic'::text END AS religion,
- way_area/NULLIF(2.38866::real*2.38866::real,0) AS way_pixels
- FROM planet_osm_polygon
- WHERE (landuse IS NOT NULL
- OR leisure IS NOT NULL
- OR aeroway IN ('apron', 'aerodrome')
- OR amenity IN ('parking', 'bicycle_parking', 'motorcycle_parking', 'university', 'college', 'school', 'hospital', 'kindergarten',
- 'grave_yard', 'place_of_worship', 'prison', 'clinic')
- OR military IN ('danger_area')
- OR "natural" IN ('beach', 'heath', 'mud', 'marsh', 'wetland', 'grassland', 'wood', 'sand', 'scree', 'shingle', 'bare_rock', 'scrub')
- OR power IN ('station', 'sub_station', 'substation', 'generator')
- OR tourism IN ('attraction', 'camp_site', 'caravan_site', 'picnic_site')
- OR highway IN ('services', 'rest_area')
- OR railway = 'station')
- AND way_area > 0.01*2.38866::real*2.38866::real
- ORDER BY CASE WHEN layer~E'^-?\\d+$' AND length(layer)<10 THEN layer::integer ELSE 0 END, way_area DESC
- ) AS landcover
- ) AS features WHERE "way" && ST_SetSRID('BOX3D(-8720241.934886048 5045761.111161055,-8718407.446207201 5047595.5998399)'::box3d, 900913)'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement