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

Reply via email to