[OSM-talk] my flag is not showing on the green

[Jon Burgess]

On Thu, 2009-08-27 at 16:29 +0530, Kenneth Gonsalves wrote:
>       <Parameter name="table">select node from planet_osm_point where 
> golf='green' as golfmarkers</Parameter>

Try:

 select way,golf from planet_osm_point where golf='green' as golfmarkers

* way is required for Mapnik to know where the point is located. 
* golf is required for your filter. 

If you want to optimize things, the filter in the style is redundant
since the SQL select is only going to return points with golf='green'
anyway.

Alternatively you could replace you select with just "planet_osm_point"
and leave the filter in place.

	Jon