On 24/05/15 10:25, Walter Nordmann wrote:
Hi, tried to get carto 30 running and get errors like

<code>RuntimeError: ERROR:  column "int_wetland" does not exist
LINE 1: SELECT ST_AsBinary("way") AS geom,"int_wetland" FROM (SELECT

Full sql was: 'SELECT ST_AsBinary("way") AS geom,"int_wetland" FROM (SELECT
     way, "natural"
   FROM planet_osm_polygon
   WHERE "natural" IN ('marsh', 'wetland')
     AND building IS NULL
   ORDER BY z_order, way_area DESC
) AS water_areas_overlay WHERE "way" && ST_SetSRID('BOX3D(848559.2696606186
6792939.345929289,849149.7941396218 6793792.409316793)'::box3d, 900913)'
</code>

and i agree: int_wetland is not in the result of that subquery - unless i'm
blind.

True, but that query isn't actually in the stylesheet. The only query using int_wetland is this one:

https://github.com/gravitystorm/openstreetmap-carto/blob/v2.30.0/project.yaml#L254

Which (a) has a case whose result it names int_wetland and (b) selects more things (natural=mud) in the subquery.

So it seems you have somehow lost a level of subquery - the outer query is added by mapnik I believe.

Tom

--
Tom Hughes (t...@compton.nu)
http://compton.nu/

_______________________________________________
talk mailing list
talk@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk

Reply via email to