[postgis-users] How to reproject postgis layers in mapserver

[Obe, Regina DND\MIS]

I'm using mapserver 4.4.2 and PostGIS 8.0.2/1.0.0/proj 4.4.9.  I have aerial
tiles of MrSID files in NAD 83 meters  and my postgis layers in NAD 83 ft.
If I have my map in NAD 83 ft most works fine - I can zoom in out etc. and
its fairly fast.  My aerial reprojects correctly to NAD 83 ft.  

If I perform a query something like
qstring=parcel_id=blahblahblah&qlayer=parcels in my htm file 
 - then my aerial layer gets all screwed up - it doesn't seem to reproject
correctly. It takes a long time to run and then the whole aerial seems to
get squashed at the center of the zoomed in parcel.  If I leave the aerial
out - the query works fine.

If I switch my map projection to NAD 83 meters, then the postgis layers
don't seem to reproject so they just don't show or show in very weird
places.

I'm assuming this is something wrong I'm doing with the postgis layers
because if I swap these with map info tab files or shape files of NAD 83 ft,
those seem to work fine and project if I put in a PROJECT END clause.  I
tried putting in a PROJECT  END .. in the postgis layers, but that didn't
seem to make a difference.  I verified that my spatial fields are in the
geometry_columns table.

Below is a snippet of some of my mapfile
 CONFIG PROJ_LIB "E:\DNDIntranet\mapserv\scripts\proj\"
 CONFIG GDAL_DRIVER_PATH "E:\DNDIntranet\mapserv\scripts\fw\gdal_plugins\"
 NAME REMSPROP
 #meters EXTENT  225033.887 885954.489 245303.531 905462.069
 EXTENT  738152.213543900 2907686.126484261 797440.9488538101
2970773.30444638
 SIZE 500 500
 SHAPEPATH "F:\Mapservdata"
 UNITS feet
 SYMBOLSET symbols/symbols35.sym
 FONTSET symbols/fonts/font.lst
 IMAGETYPE jpeg
 TEMPLATEPATTERN "printable.html|loader.html|blankloader.htm"
 PROJECTION
  "init=epsg:2249"
  #"init=epsg:26986"
 END

 LAYER
  NAME "bosaerial2001"
  STATUS DEFAULT
  TILEINDEX "bostonsidtiles.shp"
  TILEITEM "Location"
  MINSCALE 300
  MAXSCALE 5000
  TYPE RASTER
  PROJECTION
    "init=epsg:26986"
  END
  PROCESSING "COLOR_MATCH_THRESHOLD=6"
  PROCESSING "SCALE_1=0,255"
  PROCESSING "SCALE_2=0,255"
  PROCESSING "SCALE_3=0,255"
 END

	LAYER
		NAME "neighborhoods"
		CONNECTIONTYPE postgis
		DATA "the_geom from neighborhoods"
		CONNECTION "user=propuser dbname=dnddts host=localhost"
		# PROJECTION
			#AUTO
		# 	"init=epsg:2249"
		# END
		TYPE POLYGON
		STATUS default
		CLASS
			OUTLINECOLOR 30 0 0
		END
	END
	
	LAYER
	  NAME "parcels"
	  CONNECTIONTYPE postgis
	  DATA "the_geom from landparcels USING UNIQUE parcel_id"
	  CONNECTION "user=propuser dbname=dnddts host=localhost"
	  STATUS DEFAULT
	  TYPE POLYGON
	  MAXSCALE 5000
	  CLASS
		NAME "Parcel Footprint"
		OUTLINECOLOR 100 100 200
		LABEL
		  POSITION CL
		  SIZE MEDIUM
		  COLOR 0 150 0
		END
	  END
	  TEMPLATE loader.html
	END