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

[Janeks Kamerovskis]

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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>