[mapserver-users] RE: making POINT with SQL

[Lime, Steve D (DNR)]

What does "not working" mean? Steve

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Juan Carlos Monestel
Sent: Thursday, April 07, 2011 12:04 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] making POINT with SQL


Hello
I'm trying to make an POINT in the map but it's not working

this is my Layer
layer
        name "ponto"
        connectiontype POSTGIS
        connection "dbname=xxxx user=xxxxx host=xxxxx port=xxxxx"
        data "geo_info from table"
        type point
        status on
        metadata
                tile_source "nocache"
        end
        maxscale 3000001
        class
                style
                        size 4
                        symbol "circulo"
                        color 0 0 0
                end
                style
                        size 1
                        symbol "circulo"
                        color 255 255 255
                end
        end
end


The SQL brings me an geo info ("0101000020E610000079E9263108DC42C08716D9CEF75338C0") that in text is = "POINT(-37.719 -24.328)"


Any Ideas ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110407/3f9fc30e/attachment.html