Good afternoon. I am trying to figure out how to publish my SQL Server point data in Geoserver as Points, rather than "Other Geometry".
I have tried with many versions of Geoserver (2.15 - 2.22) and a whole variety of options, but I cannot seem to convince Geoserver that the layer contains regular old points. I am working with real data and have done a number of quality checks, but to be sure I came up with a simple test case to confirm what I am seeing. Below is the test case in case anyone is interested in trying it for themselves. I have created a table called singlepoint which contains, as expected, a single record with a Shape column that is a single point. create table singlepoint (ID int, Shape geometry); I then inserted a point and made sure that SQL Server recognizes it as a point with a valid SRID: select Shape.STX, Shape.STY, Shape.STGeometryType(), Shape.STSrid from singlepoint; X Y SType SRID -13754366.933777 6159721.47460994 Point 102100 I inserted a record into the geometry_columns table: f_table_catalog f_table_schema f_table_name f_geometry_column coord_dimension srid geometry_type qgis_pkey myazdb dbo singlepoint Shape 0 102100 POINT ID I created a simple Microsoft SQL Server Store in Geoserver using all of the defaults and specifying "geometry_columns" as the metadata table. When I publish the singlepoint table as a layer, it invariably gets the "Other Geometry" icon in the layer list and layer preview. The default style is the generic style instead of "point". The ramifications of this is that when I try to view the data using the GSR community plugin, it tries to read it as a polygon. Is there any way to explicitly declare this layer as point layer within Geoserver? I believe I have done everything on the SQL Server side to ensure that it is defined as a point layer. Many thanks in advance for your help, Patricia
_______________________________________________ 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