[mapserver-users] query in mapfile
thomas bonfort
thomas.bonfort at gmail.com
Thu Jun 18 06:25:42 PDT 2015
http://mapserver.org/cgi/runsub.html
On 18 June 2015 at 15:23, hosain mohammadi <hosain.moh00 at gmail.com> wrote:
> 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
>
>
> _______________________________________________
> 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