[mapserver-users] Points layer doesn't work.
Janeks Kamerovskis
janeks.kamerovskis at silvita.lv
Sun Nov 6 22:00:02 PST 2011
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
>
>
More information about the MapServer-users
mailing list