[Geoserver-users] Operation on mixed SRID geometries

GeoServer GeoServer User
1

Hi,

Ok, so this GeoServer still thinks the srid is 0.
The srid is read the first time GeoServer tries to access that view
(normally, during startup when checking if the feature type can be computed)
and from there on, it won’t consult the geometry_columns anymore.
Well, unless you force it to, by using the “reset” button in the status
page, or by restarting GeoServer fully

I ‘reset’ geoserver and also restart, but it still read the query in the wrong way.

Any other suggestions?

Regards

Eugenio

2

On Thu, Nov 21, 2013 at 10:41 AM, Eugenio Trumpy <frippe12573@anonymised.com>wrote:

So the upgrade is the most quick solution,
I can do it, but have you any hints since I have to change from 2.1.2 to
the stable 2.4...?

Make a backup of your data directory, there has been reports of issues
during the upgrades related
to the security subsystem upgrade

Cheers
Andrea

--

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

3

Hi,
actually the result of that query has srid value = 0

E.

From: stefano.iacovella@anonymised.com
Date: Thu, 21 Nov 2013 10:43:04 +0100
Subject: Re: FW: Operation on mixed SRID geometries
To: frippe12573@anonymised.com
CC: andrea.aime@anonymised.com

2013/11/21 Eugenio Trumpy <frippe12573@anonymised.com>

I ‘reset’ geoserver and also restart, but it still read the query in the wrong way.

Any other suggestions?

Regards

Eugenio

Did you try, as suggested by Andrea, to check what SRID is registered in geometry_columns Postgis metadata view?

select * from public.geometry_columns where f_table_name = ‘<your_view>’;

Stefano

41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

4

Eugenio,

your issue seems very similar to this one:

https://jira.codehaus.org/browse/GEOS-4937

it indeed affected 2.1.3 release but it was fixed in 2.1.4

Stefano

···

41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

2013/11/21 Stefano Iacovella <stefano.iacovella@anonymised.com>

2013/11/21 Eugenio Trumpy <frippe12573@anonymised.com>

I ‘reset’ geoserver and also restart, but it still read the query in the wrong way.

Any other suggestions?

Regards

Eugenio

Did you try, as suggested by Andrea, to check what SRID is registered in geometry_columns Postgis metadata view?

select * from public.geometry_columns where f_table_name = ‘<your_view>’;

Stefano

41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

5

2013/11/21 Eugenio Trumpy <frippe12573@anonymised.com>

Hi,
actually the result of that query has srid value = 0

So GeoServer can't recognize native SRS.

By the way, which version of PostGIS are you using?

Stefano

---------------------------------------------------
41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

6

2.0.3 r11128

From: stefano.iacovella@anonymised.com
Date: Thu, 21 Nov 2013 10:55:55 +0100
Subject: Re: Operation on mixed SRID geometries
To: frippe12573@anonymised.com
CC: andrea.aime@anonymised.com; geoserver-users@anonymised.comourceforge.net

2013/11/21 Eugenio Trumpy <frippe12573@anonymised.com5…>

Hi,
actually the result of that query has srid value = 0

So GeoServer can’t recognize native SRS.

By the way, which version of PostGIS are you using?

Stefano

41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

7

Do you loaded the data contained in the table used from the view with the shp2pgsql utility?

If so it does not use the typmod feature for adding the geometry column to the table, when creating views PostGIS does not populate the geometry_columns unless you perform a cast on the geoemtry column of the view.

You may try dropping your view and recreating using a syntax like this:

create view xxx as

select
…
the_geom::geometry(POLYGON,4326) As the_geom

from
…

Of course change the POLYGON according to your shape type

Stefano

···

41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

2013/11/21 Eugenio Trumpy <frippe12573@anonymised.com>

2.0.3 r11128

From: stefano.iacovella@anonymised.com
Date: Thu, 21 Nov 2013 10:55:55 +0100
Subject: Re: Operation on mixed SRID geometries
To: frippe12573@anonymised.com
CC: andrea.aime@anonymised.com…; geoserver-users@lists.sourceforge.net

2013/11/21 Eugenio Trumpy <frippe12573@anonymised.com>

Hi,
actually the result of that query has srid value = 0

So GeoServer can’t recognize native SRS.

By the way, which version of PostGIS are you using?

Stefano

41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas