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