[mapserver-users] query in mapfile
hosain mohammadi
hosain.moh00 at gmail.com
Thu Jun 18 06:23:54 PDT 2015
the code below is a layer in map file in this code i want create a query
in postgis for shortestpath but a the number 77 and 388 is the source and
target and the result create successfully but my problem is how insert
the number ( 77, 388) in template file or insert by user
how insert from html file
LAYER
CONNECTION "host=localhost dbname=network user=postgres
password=021555 port=5432"
CONNECTIONTYPE POSTGIS
DATA "geom from (SELECT * from pgr_dijkstra(
'SELECT gid as id , source , target , cost FROM tehran' , 77, 388, false
, false ) a LEFT JOIN tehran b ON (a.id2 = b.gid)) AS foo using unique gid
using srid=4326"
NAME "shortestpath"
PROJECTION
"proj=utm"
"zone=39"
"datum=WGS84"
"units=m"
"no_defs"
END # PROJECTION
STATUS ON
TEMPLATE "query"
TILEITEM "location"
TYPE LINE
UNITS METERS
CLASS
NAME "Class (0)"
STYLE
COLOR 255 128 64
SIZE 8
WIDTH 10
END # STYLE
END # CLASS
END # LAYER
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150618/64dc63d0/attachment.htm>
More information about the MapServer-users
mailing list