On Friday 28 Aug 2009 12:08:37 am Jon Burgess wrote:
> 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.

that did the trick - thanks
-- 
regards
Kenneth Gonsalves
Associate
NRC-FOSS
http://nrcfosshelpline.in/web/

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

Reply via email to