1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
MAP
    NAME TEST
    STATUS ON
    IMAGECOLOR 255 255 255
    IMAGETYPE PNG
  PROJECTION
    "proj=utm"
    "ellps=WGS84"
    "datum=WGS84"
  END


  LAYER
          NAME "ROUTE"
          STATUS DEFAULT
          TYPE LINE
          CONNECTIONTYPE postgis
          CONNECTION "user=user password=user dbname=indoorpositioning host=localhost port=5432"
          #DATA "the_geom from (SELECT the_geom, gid from dijkstra_sp('ways', 4378, 370)) AS foo using unique gid using srid=4326"

    DATA "the_geom from (SELECT buildingroute.the_geom,buildingroute.gid FROM routetest INNER JOIN buildingroute ON routetest.toid=buildingroute.gid ORDER BY routetest.id ASC) AS foo using unique gid using srid=32709"
          
    CLASS
            STYLE
                    COLOR 0 0 0
                    WIDTH 3
              END
    END
    PROJECTION
      "init=epsg:32709"
    END
        END
END