Re: [Geoserver-users] Layer preview error

[Russ H. <ru...@ru...>]

You can update the Geom column to set an SRID.

Under Postgis it is ST_SetSRID(Geom,srid). Not sure about SQLServer

Russ

> On 20 Jun 2024, at 11:15, Cristian Apostol <a.c...@gm...> wrote:
> 
> Hello,
> 
> I have a layer that is coming from a SQL Server Database, the database has been linked to GeoServer and I can import all the layers from database in my GeoServer.
> 
> When I publish a layer and I'm trying to preview it, i receive the error message that is displayed in the image (geoserver1.png).
> 
> I made some research and I came to conclusion that the GeoServer is not able to display my layer because the layers doesn't have the SRID (projection defined) inside of the SQL Server Database. I will attach an image of the records that of the layer (sql_data.png).
> 
> Is there a solution to this problem? 
> 
> 
> <geoserver1.PNG><sql_data.PNG>_______________________________________________
> Geoserver-users mailing list
> 
> Please make sure you read the following two resources before posting to this list:
> - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html
> 
> 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
> 
> 
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users