I would use OGR connection in this case. Then you can set what fields
will be used for coordinates.
There are an example in http://mapserver.org/input/vector/mysql.html too.
Janeks
On 2011.11.06. 21:08, knasia wrote:
Hi,
I have a problem with points layer displaying.
When I had data like:
id | coor
| type
------+----------------------------------------------------+-----------
60 | 0101000020E61000002F6EA301BCC53340D656EC2FBB074940 | crossroad
61 | 0101000020E61000003C4ED1915CC633406BB75D68AE074940 | crossroad
62 | 0101000020E6100000E8305F5E80C53340FAD51C2098074940 | crossroad
63 | 0101000020E61000004576EFF2BECB3340755204DD03034940 | crossroad
then my data looked like:
DATA 'coor FROM nodes using unique id using srid=4326'
Now my data in table event looks like:
id | lat | lng | t | rad
-----+------------------+------------------+---+-----
90 | 50.0803967590663 | 19.9726295471191 | 1 | 100
91 | 50.0595725313664 | 19.9757194519043 | 2 | 20
99 | 50.0742275601994 | 19.8958969116211 | 2 | 500
100 | 50.067226578069 | 19.9031066894531 | 0 | 500
And I don't know how DATA should looks like.
I have tried:
DATA 'ST_GeogFromText('SRID=4326;POINT(' || lng || ' ' || lat || ')') FROM
event using unique id using srid=4326'
or
DATA 'the_geom FROM (SELECT ST_GeogFromText('SRID=4326;POINT(' || lng || ' '
|| lat || ')') as the_geom FROM event ) as subquery using unique id using
srid=4326'
but none of them worked.
Has anybody an idea how could that work?
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/Points-layer-doesn-t-work-tp6968512p6968512.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
