[mapserver-users] Problems rendering postgis points layer

[Stephen Woodbridge]

On 1/21/2012 8:00 AM, Rahkonen Jukka wrote:
> Hi,
>
> Perhaps this CLASS that is not ended can make some trouble.
>
>    		CLASS
>             		EXPRESSION "cnt>=2"

Also this is not a valid expression. So no point will match if unless 
you have a CLASSITEM set and the text in that field is "cnt>=2". If you 
column name is "cnt" then you probably want an expression like"

EXPRESSION ([cnt] >= 2)

-Steve W

>            		STYLE
>              			SYMBOL "circle"
>              			SIZE 5
>              			COLOR 0 255 0
>            		END
>      		CLASS
>
> -Jukka Rahkonen-
> ________________________________________
> Dave Potts wrote:
>
>> Hi
>
>> I am having problems getting Mapserv 6.0.1 to render a points layer from a
> postgres 8.4.10 database.  The same table renders correctly in qgis.
>
>> Mapserv can load and render a data of type 'LINE' from a postgis table.
>
>> It just seems to have problems with the 'POINT' data.
>
>> Turning the debug information on, its possible to mapserv loading my
> layers streets and  one_way_from, but there is not trace of an attempt to
> points layer.
>> So mapserver can see postgis, the post gis has the right data in, does
> anybody have any idea what the problem is?
> ------------------------------------------------------
> [Sat Jan 21 09:25:53 2012].480878 msPostGISLayerOpen called: the_geom from
> (select route_id, the_geom from route_table) as foo using SRID=3857 using
> unique route_id
> [Sat Jan 21 09:25:53 2012].480885 msPostGISLayerOpen: No connection in
> pool, creating a fresh one.
> [Sat Jan 21 09:25:53 2012].491702 msConnPoolRegister(streets,user=demo
> dbname=route-example host=127.0.0.1 port=5432,0x21364a0)
> [Sat Jan 21 09:25:53 2012].498141 msPostGISLayerOpen: Got PostGIS version
> 10500.
> [Sat Jan 21 09:25:53 2012].498163 msPostGISLayerFreeItemInfo called.
>
>
>
> --
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users