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