First of all, let me state that I am brand new to PostGIS and don't know
much about what I'm doing with it. That being said, I am having trouble
displaying a PostGIS layer through MapServer.
Right now I'm just experimenting with PostGIS and simply trying to get a
layer to display. I
Bob,
Typical problems are
- the connecting user (postgisuser) does not have privilege to
access the table
- coordinate system is not specified in data (SRID=-1) and not
in the mapfile either
- and others
Turn on the layer debug logging by adding
DEBUG 5
to your
: [mapserver-users] Trouble connecting to PostGIS
Bob,
Typical problems are
- the connecting user (postgisuser) does not have privilege to
access the table
- coordinate system is not specified in data (SRID=-1) and not
in the mapfile either
- and others
Turn
I'd use Brent's advice of always specifying a projection when loading
the data into PG. Then make sure your DATA statement uses that SRID:
DATA the_geom from test using SRID=4326 using unique id
or
DATA the_geom from test using SRID=-1 using unique id
I try to document my usual steps
, 2/14/12, Bistrais, Bob bob.bistr...@maine.gov wrote:
From: Bistrais, Bob bob.bistr...@maine.gov
Subject: [mapserver-users] Trouble connecting to PostGIS
To: mapserver-users@lists.osgeo.org
Date: Tuesday, February 14, 2012, 10:11 AM
First of all, let me state that I am brand new
On Feb 13, 2012, at 3:35 PM, Bistrais, Bob wrote:
Thanks Brent. The postgis user SHOULD have access to the table, as that
is the table's owner. Coordinate system is in the map file under
Projection.
Here is what the debug log showed me (Metwp100Poly is the actual name of
the table,
On 12-02-13 6:05 PM, Puneet Kishor wrote:
The error above is telling you that it can't even find the said table.
Can you SELECT from this table successfully in PgAdmin?
Is it in a different schema than public, and perhaps that schema is not in the
searchpath?
Does the postgisuser have access
And I seem to recall needing to give some privileges on the
spatial_ref_sys and geometry_columns tables to the user.
Best Regards,
Brent Fraser
On 2/13/2012 3:05 PM, Puneet Kishor wrote:
On Feb 13, 2012, at 3:35 PM, Bistrais, Bob wrote:
Thanks Brent. The postgis user SHOULD have access
@lists.osgeo.org; Bistrais, Bob
Subject: Re: [mapserver-users] Trouble connecting to PostGIS
Hi Bob,
I suggest you try testing with QGIS.
Easy to open the native postgis table a mapserver WFS/WMS layer
concurrently to ensure it is all working as it should.
Also ensure you have configured your
...@pcreso.com]
Sent: Monday, February 13, 2012 5:01 PM
To: mapserver-users@lists.osgeo.org; Bistrais, Bob
Subject: Re: [mapserver-users] Trouble connecting to PostGIS
Hi Bob,
I suggest you try testing with QGIS.
Easy to open the native postgis table a mapserver WFS/WMS layer
concurrently to ensure
10 matches
Mail list logo