[Geoserver-users] Adding PostGIS layers with no attributes (except ID field) gives no Native SRS

GeoServer GeoServer User
1

I just discovered (a bug/feature?) that if you create a PostGIS layer that only has an ID field, something odd happens in Geoserver when you try to add the layer from the PostGIS store. Unless primary keys are exposed for the PostGIS store, any layer added that only has an ID field (and geom field, of course) will show a blank Native SRS when setting up layers. The only way to show the Native SRS is to expose primary keys. This was tested on Geoserver 2.15.2.

Steps to replicate:

!) Create a point PostGIS layer that only has an id field (serial) and a geometry field (type point).

  1. Create a store in Geoserver and DO NOT expose primary keys.

  2. Attempt to publish the newly created point layer in geoserver and note that there is no defined Native SRS.

Is this a known Geoserver issue/bug?

Cheers

Cliff

···

Cliff Patterson Ph.D.

PSD | Senior GIS Consultant
P: 519-690-2565 ext. 2616
www.psdrcs.com
London | 148 Fullarton St. 9th Floor

2

Can’t reproduce that on GS 2.15.3
But have you set srid on the postgis column and populate geometry columns?

Cliff Patterson <cpatterson@anonymised.com> escreveu no dia segunda, 11/11/2019 à(s) 17:19:

···

www.vfonsecaz.pt

3

Yes, srid was defined and populated. Perhaps it was a minor bug that was fixed in 2.15.3.

Cliff

On Tue., Nov. 12, 2019, 7:33 a.m. Vitor Fonseca, <vfonsecaz@anonymised.com> wrote:

Can’t reproduce that on GS 2.15.3
But have you set srid on the postgis column and populate geometry columns?

Cliff Patterson <cpatterson@anonymised.com> escreveu no dia segunda, 11/11/2019 à(s) 17:19:

I just discovered (a bug/feature?) that if you create a PostGIS layer that only has an ID field, something odd happens in Geoserver when you try to add the layer from the PostGIS store. Unless primary keys are exposed for the PostGIS store, any layer added that only has an ID field (and geom field, of course) will show a blank Native SRS when setting up layers. The only way to show the Native SRS is to expose primary keys. This was tested on Geoserver 2.15.2.

Steps to replicate:

!) Create a point PostGIS layer that only has an id field (serial) and a geometry field (type point).

  1. Create a store in Geoserver and DO NOT expose primary keys.

  2. Attempt to publish the newly created point layer in geoserver and note that there is no defined Native SRS.

Is this a known Geoserver issue/bug?

Cheers

Cliff

–

Cliff Patterson Ph.D.

PSD | Senior GIS Consultant
P: 519-690-2565 ext. 2616
www.psdrcs.com
London | 148 Fullarton St. 9th Floor

Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

www.vfonsecaz.pt