[postgis-users] Mapserver PostGIS Layer returns nothing

[Changqing Zhou]

How do you configure mapserver to print our PSQL? Where is your log file?

I had log file defined in the web tag in the mapfile and it does not give
me the psql.

Thanks,

Changqing

On Wed, 28 Apr 2004, Paul Ramsey wrote:

> Check the mapserver log for the SQL being generated by the postgis layer
> and pump that into psql. The only reason to get a blank map, generally,
> is if your layer is actually not on, there is no data, or your extents
> are outside the area of data. Take the mapfile you know works with your
> demo shape file, and, changing nothing but the connectiontype and
> connection information, try again.
>
> Wesley Dyk wrote:
>
> > Summary: Trying to use a PostGIS layer of POINT geometries within the
> > extent "-108.375280 40.032 -107.95597 40.24679" (from ogrinfo of the
> > dumped shapefile), but get no results.
> >
> > PostgreSQL 7.4.2
> > PostGIS 0.8.1
> > mapserver 4.0.2
> >
> > I have been working with mapserver for a few weeks now and I have been
> > able to create simple mapfiles with several layers.  They all seem to
> > work great, except for PostGIS.    I have messed around with the LAYER
> > definition and I know what changes will generate errors and which ones
> > will just return whitespace (which are the only two results that I can
> > get). I dumped my table to a shapefile.  Creating a layer based on that
> > shapefile works just as the PostGIS layer is supposed to.  I tried
> > reloading the shapefile into a new table, once with SRID=-1 and once
> > with SRID=4269.  I can't get anything but whitespace from the database.
> > I have tried to make the extent to encompass any possible point, with
> > and without projection, but nothing.
> >
> > What could I do to figure out what is going wrong?
> >
> > This is the latest mapfile I have tried (with nothing but the PostGIS
> > layer in question).
> >
> > -----------------------postgis.map--------------------------------
> > SYMBOL
> >  NAME "triangle"
> >  TYPE vector
> >  POINTS
> >   0 4
> >   2 0
> >   4 4
> >   0 4
> >  END
> > END
> >
> > SYMBOL
> >  NAME "circle"
> >  TYPE ellipse
> >  FILLED TRUE
> >  POINTS
> >   1 1
> >  END
> > END
> >
> >
> > MAP
> >  NAME TIMS
> >  IMAGETYPE PNG
> >  EXTENT -108.375280 40.032 -107.95597 40.24679
> >  #EXTENT -111.8 39.0032 -103.002 46.3
> >  SIZE 640 480
> >  SHAPEPATH "data"
> >  IMAGECOLOR 255 255 255
> >  FONTSET "fonts/fonts.list"
> >
> >  WEB
> >    IMAGEPATH "/u01/mapserver/tims/tmp/"
> >    IMAGEURL "/tims/tmp/"
> >    LOG "/u01/mapserver/tims/tims1.log"
> >  END
> >
> >  PROJECTION
> >    "init=EPSG:4269"
> >  END
> >  #PostGIS Well Header
> >  LAYER
> >    NAME wellheader
> >    STATUS DEFAULT
> >    DEBUG ON
> >    CONNECTIONTYPE postgis
> >    CONNECTION "user=aus dbname=TIMS host=denlx02"
> >    DATA "the_geom from wellheader"
> >    TYPE POINT
> >    PROJECTION
> >      "init=EPSG:4269"
> >    END
> >    #When the display works use different classes for certain conditions
> >    CLASS
> >      SYMBOL 'triangle'
> >      OUTLINECOLOR 0 255 0
> >      SIZE 5
> >    END
> >  END
> >
> > END
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> --
>        __
>       /
>       | Paul Ramsey
>       | Refractions Research
>       | Email: pramsey at refractions.net
>       | Phone: (250) 885-0632
>       \_
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>