[mapserver-users] Re: simplify problem

[Puneet Kishor]

On Dec 29, 2011, at 8:14 AM, ahlah <ahti.lahtela at pp.inet.fi> wrote:

> Hi,
> 
>> DATA 'ST_Simplify(geom_3067, 100) geom FROM lines USING srid=3067 USING
>> UNIQUE id' 
> 
> still getting error:
> 
> msDrawMap(): Image handling error. Failed to draw layer named 'grid'.
> msPostGISLayerWhichShapes(): Query error. Error (ERROR:  syntax error at or
> near "geom"
> LINE 1: ...id" from lines where ST_Simplify(geom_3067, 1000) geom && Ge...


Dunno man. Guessing in the wind again... Create a view in Pg using a column alias as above, then use the view in the map file. That should do it. Mind it, I haven't looked at the actual syntax of your query.... I am on an iPad here.


>                                                             ^
> ) executing query: select
> "status",encode(AsBinary(force_collection(force_2d("ST_Simplify(geom_3067,
> 1000) geom")),'NDR'),'hex') as geom,"id" from lines where
> ST_Simplify(geom_3067, 1000) geom && GeomFromText('POLYGON((455103
> 7369428.2777498,455103 7564228.2777498,634903 7564228.2777498,634903
> 7369428.2777498,455103 7369428.2777498))',3067)
> AL
> 
> --
> View this message in context: http://osgeo-org.1803224.n2.nabble.com/simplify-problem-tp7135648p7135710.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users