POSTGIS LAYER...

[Philippe Gondek]

Here is my mapfile. I want to show the metadata of one of my layers
and perform a queryBy Point. Is my mapfile correct?

MAP

	#####################
	# Start of map file #
	#####################
	
	NAME SIGMA-BELGIUM
	SIZE 640 480
	STATUS ON
	EXTENT  22265.4 21163 295157 295157

	IMAGECOLOR 153 153 153
	IMAGETYPE PNG
	PROJECTION
		"init=epsg:4313"
	END

	
	##################
	# Start of layer #
	##################
	
	LAYER
		NAME communes
		TYPE POLYGON
		CONNECTIONTYPE POSTGIS
		CONNECTION "host=localhost port=5432 dbname=lemiam user=phil
password=1707loulou442"
		DATA "the_geom from communes as foo using unique
geometry_columns.srid using SRID=9803"
		CLASS
			Name 'MesCommunes'
			STYLE
				SIZE 3
				OUTLINECOLOR 0 75 128
				COLOR 119 119 119	
			END
		END
		PROJECTION
			"init=epsg:4313"
		END
	END

	LAYER
		NAME links
		TYPE LINE
		CONNECTIONTYPE POSTGIS
		CONNECTION "host=localhost port=5432 dbname=lemiam user=phil
password=1707loulou442"
		DATA "the_geom from links as foo using unique geometry_columns.srid
using SRID=9803"
		CLASS
			Name 'MesLinks'
			STYLE
				SIZE 3
				COLOR 255 0 0	
			END
		END
		PROJECTION
			"init=epsg:4313"
		END
	END

	LAYER
		NAME centroides
		TYPE POINT
		CONNECTIONTYPE POSTGIS
		CONNECTION "host=localhost port=5432 dbname=lemiam user=phil
password=1707loulou442"
		DATA "the_geom from centroides as foo using unique
geometry_columns.srid using SRID=9803"
		CLASS
			Name 'MesCentroides'
			STYLE
				COLOR 0 255 0
				SYMBOL /var/www/localhost/htdocs/sigma/mojira-star.png
				SIZE 6
			END
		END
		PROJECTION
			"init=epsg:4313"
		END
	END
	

	##########################
	# Start of query map #
	##########################
	
	QUERYMAP
               COLOR 255 255 0
               SIZE -1 -1
               STATUS OFF
               STYLE HILITE
	END
	
	##########################
	# Start of reference map #
	##########################
	
	REFERENCE
	    COLOR 0 0 180
	    EXTENT  22265.4 21163 295157 295157
	    IMAGE "/var/www/localhost/htdocs/sigma/tmp/regions.png"
	    MAXBOXSIZE 240
	    OUTLINECOLOR 255 0 255
	    SIZE 120 149
	    STATUS ON
	END
	
	###################
	# Start of legend #
	###################
	
	LEGEND
	  KEYSIZE 18 12
	  LABEL
	    TYPE BITMAP
	    SIZE MEDIUM
	    COLOR 0 0 89
	  END
	  STATUS ON
	END
	
	#####################
	# Start of scalebar #
	#####################
	
	SCALEBAR
	  LABEL
	    COLOR 0 75 128
	    SIZE MEDIUM    
	  END
	  STYLE 0
	  SIZE 80 2
	  COLOR 0 75 128
	  UNITS KILOMETERS
	  INTERVALS 5
	  TRANSPARENT TRUE
	  STATUS TRUE
	  SIZE 200 3
	END
END