[Geoserver-users] retrieving wms map from a postgis table with srid 26331 ?

GeoServer GeoServer User
1

Hi,


Sorry but i don’t undertand what u mean by change geometry_columns ? Is this a setting in geoserver or postgis ? where can it be changed ? the geometry column in my postgis table is named " the_geom ".


Thanks,


Roman.



— On Mon, 5/25/09, Andrea Aime aaime@anonymised.com wrote:


> From: Andrea Aime aaime@anonymised.com
> Subject: Re: [Geoserver-users] retrieving wms map from a postgis table with srid 26331
> To: “Roman Isitua” romanisitua@anonymised.com
> Cc: “Justin Deoliveira” jdeolive@anonymised.com, “geoserver users” geoserver-users@anonymised.com.net
> Date: Monday, May 25, 2009, 1:40 AM
>
> Roman Isitua ha scritto:
> > Justin,
> >
> > The answers to your question are as follows:
> >
> > - The srid of my table is 26331.
> > - There is a geometry column for it. The column name is (the_geom).
> > - The srid I specified on the feature type editor was 26331.
> > - The srs handling mode was " Force declared SRS (native will be ignored) ". (by the way, whats the difference between the different srs handling modes ?)
>
> GeoServer has to use a double standard when dealing with postgis.
> What you set in the GeoServer UI influences the results you get out
> of the OGC services.
> What you set in the geometry_columns table influences what SRS will
> be used for queries instead, the datastore (rightfully imho) assumes
> you setup postgis properly and that your geometries srid and
> whatever you declared in geometry_columns is consistent.
> In your case I guess you have 4326 in geometry columns by 26331 in
> the geometries stored in your database. Change geometry_columns,
> force a reload in GeoServer and you should be good.
>
> Cheers
> Andrea
>
> – Andrea Aime
> OpenGeo - http://opengeo.org
> Expert service straight from the developers.
2

Roman Isitua ha scritto:

Hi,

Sorry but i don't undertand what u mean by change geometry_columns ? Is this a setting in geoserver or postgis ? where can it be changed ? the geometry column in my postgis table is named " the_geom ".

The geometry_columns table is a postgis geographic metadata table.
You need it to be properly setup for the datastore to work.
http://www.postgis.org/documentation/manual-1.3/ch04.html#id2571510

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.