[postgis-users] on-the-fly MMS reprojection with PostGIS?

[Chris G. Nicholas]

greetings - I am trying to use Minn Map Server to specify an output file in one projection, and add PostGIS layers that may exist in another (mostly EPSG id 4326). I'd like to simply tweek the EXTENT and the PROJECTION tags of the overall map to change the outputs. 

A simple mapfile (derived from the itasca demo) I am trying is below; but unfortunately this doesn't seem to work properly...

What's the proper way to change output projection, if the PostGIS tables are in various projections, and properly loaded into the geometry_columns table?

thanks in advance!

Chris Nicholas
GlobeXplorer

----------------------------------------------
NAME DEMO
STATUS ON
SIZE 600 600
EXTENT 388107.634400379 5203120.88405952 500896.339019834 5310243.30613897
UNITS METERS

IMAGECOLOR 255 255 255
                                                                                                                                      
IMAGETYPE png
#
#
PROJECTION
  "proj=utm"
  "ellps=GRS80"
  "zone=15"
  "north"
  "no_defs"
#
#  OR:
#
#  "init=epsg:26915"
END
                                                                                                                                                                                                                                                                            
 LAYER
     CONNECTIONTYPE postgis
     NAME "geoassets"
     MAXSCALE 6000000
     CONNECTION "user=johnqpublic dbname=gextest host=pogo password=foo"
     DATA "the_geom from streets USING SRID=4326"
     STATUS ON
     TYPE LINE
     CLASS
      # All the rest are darker and only 1 pixel wide
       COLOR 205 92 82
     END
   END
  
END # Map File