Re: [Geoserver-users] Layer preview error
In MS SQL, you can set the SRID with something along the lines of UPDATE MyTable SET geom.STSrid = 4326 (or whatever your SRID is). If you have already published the layer in Geoserver, you will likely want to delete and republish it to make sure it picks up the SRID correctly. Alternatively, I believe you should be able to set a Declared SRS when publishing the layer and set "Force Declared" as the SRS handling. But getting the SRID into the geometry in the database would seem like your best move to me. Matt From: Russ Hore Sent: Thursday, June 20, 2024 7:35 AM To: Cristian Apostol Cc: geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] Layer preview error 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 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? > > > ___ > 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 > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users ___ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users ___ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Layer preview error
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 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? > > > ___ > 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 > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users ___ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Layer preview error
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? ___ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] layer preview error in geo server
Is your layer from PostGIS? it looks like a data error: http://www.postgis.org/pipermail/postgis-devel/2010-February/008673.html http://www.mail-archive.com/postgis-users@postgis.refractions.net/msg09100.html On Fri, 2010-12-24 at 18:37 +0530, Jaishankar Madamshetty wrote: Hello All, On clicking the layer preview (open layers) in geo server admin page, I am getting the error. Please see the attached screenshot. Please can anybody help me on this? Thanks, Jaishankar __ DISCLAIMER: This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or mail.ad...@infotech-enterprises.com and delete the original message. -- Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Gabriel Roldan grol...@opengeo.org Expert service straight from the developers -- Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
