Dear Robert, (and also "hello" to all others who helped with their advice !)
It is a shame that I did not know how to activate the debugging mode. (And that feature also will assist me a lot with my next MapServer programming and configuration activities ! ) With DEBUG ON, CONFIG "MS_ERRORFILE" "C:\Temp\mapserver.log", I got this message: > Postgresql reports the error as 'ERROR: column "oid" does not exist > LINE 1: ...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... Thus, after creating a new table with oids, now everything is working !! Thanks a lot to all of you, who did reply immediatley on my question. It is great to get support by such a helpful community; I appreciate it a lot ! Many dear thanks and greetings from he city of Graz in Austria (at the "heart of Europe") Susanne 2008-05-01, 19:27 UTC -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Burgholzer,Robert Gesendet: Donnerstag, 01. Mai 2008 18:57 An: [email protected] Betreff: RE: [mapserver-users] PostGis not displayed byMapServer Susanne, Many things can go wrong with your postgis layer, I have two suggestions that may get you moving on your way though: 1) Turn on the DEBUG and look at the PostGIS call on your layer. In MS5+ this is done by including the following in your MAP definition (top of mapfile, you choose the logfile name of course): DEBUG ON CONFIG "MS_ERRORFILE" "C:\Temp\mapserver.log" And then "DEBUG ON" in your layer. 2) I notice there is no projection info on your MAP or your LAYER, I always have that as an explicit declaration. i.e.: PROJECTION "init=epsg:4326" END Entries in both the MAP block and in the LAYER, where the epsg corresponds to your projections. HTH, Robert W. Burgholzer Surface Water Modeler Office of Water Supply and Planning Virginia Department of Environmental Quality [EMAIL PROTECTED] 804-698-4405 Open Source Modeling Tools: http://sourceforge.net/projects/npsource/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 01, 2008 11:25 AM To: [email protected] Subject: [mapserver-users] PostGis not displayed byMapServer Hello to everyone, I have an (already mentioned but - as it seems to me - not yet solved) problem concerning PostGis used with MapServer. My application can show shape files but not postgis-files. There are no output files (png) generated for this layer. Below is my mapfile. I would be very pleased if anyone can give me some usefull hint. Thanks a lot, Susanne Kalliany ------------------------------ MAP NAME global_map STATUS ON SIZE 1000 700 EXTENT -100300 260500 -99100 261600 UNITS meters IMAGECOLOR 255 255 255 IMAGETYPE png24 WEB IMAGEPATH "C:\ms4w\Apache\htdocs\tmp" IMAGEURL "/tmp/" END LAYER NAME Ortho GROUP Ortho DATA "C:\ms4w\Apache\htdocs\ortho\alle_e_50cm.tif" projection "AUTO" end TYPE RASTER MINSCALE 10 MAXSCALE 10001 STATUS ON DUMP TRUE END LAYER CONNECTIONTYPE postgis NAME UAbt GROUP UAbt CONNECTION "user=postgres password=xxxxxxxx dbname=tefisdb host=localhost port=5432" STATUS ON TYPE line DATA "roads_geom from roads" CLASS SIZE 16 COLOR 0 0 255 END DUMP TRUE END END UAbt with or without projection "AUTO" -- DI. Susanne KALLIANY - [EMAIL PROTECTED] TeFiS - www.tefis.at Technische und forstliche Informationssysteme (Forstliche Software und GIS) Mobiltelephon: +43 664 1424269 Telephon: +43 316 931746-0, Fax: -15 A-8010 Graz, Schillerstrasse 58 A-1040 Wien, Schaumburgergasse 11/13 _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
