2010/5/13 Peter Körner osm-lists@mazdermind.de:
Am 13.05.2010 01:07, schrieb Colin Marquardt:
What's a bit special is that I'm using cascadenik for my styles, and in general, that works ok.
I don't really know cascadenik but isn't it generating mapnik xml output? What does it generate in your problematic case?
The generated mapnik xml for /home/cmarqu/tools/mapnik-utils-sandbox/cascadenik/hike_n_bike/lighting.mml is /home/cmarqu/lighting_pre.xml.
The SQL from that file is <Parameter name="table"> (SELECT tags->'lit' AS lit, way FROM planet_polygon WHERE (tags ? 'lit') AND (tags->'lit' IN ('yes', 'no'))) AS areas</Parameter>
So I suppose I need to select * in some way? (I know next to no SQL.)
But even if this example can be made to work, in general this will only work as long as whatever I filter on is not in hstore.
You can get all tags from the hstore and just don't use the classic columns if you don't want to.
This probably comes with a speed penalty, right?
Cheers Colin