AW: [mapserver-users] PostGis not displayed byMapServer

[DI. Susanne Kallliany]

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: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] Im Auftrag von
Burgholzer,Robert
Gesendet: Donnerstag, 01. Mai 2008 18:57
An: mapserver-users at lists.osgeo.org
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
rwburgholzer at deq.virginia.gov
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of
susanne.kalliany at tefis.at
Sent: Thursday, May 01, 2008 11:25 AM
To: mapserver-users at lists.osgeo.org
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 - susanne.kalliany at tefis.at

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
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users