[mapserver-users] Points layer doesn't work.

[knasia]

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.