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

Wed Aug 27 17:27:54 PDT 2003

Added a projection layer for the postgres data and it works like a charm. Sorry to have taken up bandwidth ...

Greg Williamson
DBA GlobeXplorer

-----Original Message-----
From: Chris G. Nicholas 
Sent: Wednesday, August 27, 2003 3:41 PM
To: PostGIS Users Discussion
Subject: [postgis-users] on-the-fly MMS reprojection with PostGIS?

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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users