Hello all.
I guess this question should be addressed to the mapserver
mailing list, but I hope I could find a quick response to this
question.
I have a table in mysql database where the coordinates are stored
as (degree, min, sec) coordinates.
The connection with the database is successfull through the OGR
driver. The problem however is how to configure the layer in
order to display the locations on the map. I have downloaded
the pmapper demo map, and I'm trying to display my data on it.
Bellow is the configuration of the layer:
LAYER
NAME "sites"
TYPE POINT
STATUS ON
CONNECTIONTYPE OGR
CONNECTION "MYSQL:db,user=user,password=pswd"
DATA "select site_name, c1.cord_deg as c1deg, c1.cord_min as c1min,
c1.cord_sec as c1sec,
c2.cord_deg as c2deg, c2.cord_min as c2min, c2.cord_sec as c2sec
from site
inner join coordinate as c1 on c1.coordinate_id = site.coordinate_first
inner join coordinate as c2 on c2.coordinate_id = site.coordinate_second"
LABELITEM site_name #may need to use table.name or just name depending on
your OVF file.
PROJECTION
"init=epsg:4326"
END
CLASS
SYMBOL 1
SIZE 6
COLOR 255 0 0
LABEL
SIZE MEDIUM
TYPE BITMAP
COLOR 0 0 0
END
END
DEBUG ON
END
The intention here is to display the site_name field as a point,
where the coordinates are taken from (c1deg, c1min, c1min) and (c2deg, c2min,
c2sec)
This however does not work.
I get the error message:
Warning: [MapServer Error]: msQueryByPoint(): No matching record(s) found.
My knowledge on Mapserver are really limited and I'm hopping for your help.
Anakreon
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
