Hello, i'm trying to publish a WMS Layer from a SQL View. The geodata is in
a geometry column in a Microsoft SQL Server. The created view only has two
columns: ID and geometry, and only two entries, where both are simple
linestrings.
I can add the view as Layer, but if i try to view it in the layer preview,
i just get an empty white rectangle. Both with OpenLayers and the WMS image
options. The wfs options at least return something.
I can preview the lines directly from the View in SSMS, as shown in the
attached image, but after adding it in GeoServer as Layer from SQL View,
the WMS PNG option returns this empty rectangle. which is also attached.
I use the default line style which works perfectly for the sample line
layers.
What could cause this to happen?
The two geometry entries within the View are:
0x00000000010414000000948BF792E41D5CC05C33EE7D2BE8734050A0846E32265CC05C33EE7D2BE87340948BF792E41D5CC0D1FE5BCF08ED7340948BF792E41D5CC07C237AF479FE73402591E2A2A9315CC041EE796EF6F97340C5C68FC4895B5DC041EE796EF6F97340580354DAFE695DC04C2CE4CE51FE7340580354DAFE695DC0D1FE5BCF08ED7340E0912AD7E95E5DC05C33EE7D2BE87340580354DAFE695DC05C33EE7D2BE87340580354DAFE695DC016B1601D40B673400A158B6DD6625DC03D07F7F058B47340580354DAFE695DC0765D8DC471B27340580354DAFE695DC076F1B44C9C1C73402E840265A0275CC076F1B44C9C1C7340948BF792E41D5CC039D30FC7C01F7340948BF792E41D5CC0765D8DC471B27340E179C0FF0C255CC03D07F7F058B47340948BF792E41D5CC016B1601D40B67340948BF792E41D5CC05C33EE7D2BE8734001000000010000000001000000FFFFFFFF0000000002
0x00000000010413000000583D8A66C9A15CC0B2C78CACD3217440583D8A66C9A15CC0A3998C3BCA2774403CE8272D26975CC0A3998C3BCA277440675FA51FEF9F5CC0BD97CFBA682C7440580354DAFE695DC0BD97CFBA682C7440580354DAFE695DC0F0F027675D1B7440580354DAFE695DC004DF32F4C6127440CC72AD7936685DC0B74DDB44D10E7440580354DAFE695DC0B74DDB44D10E7440580354DAFE695DC04C2CE4CE51FE7340C5C68FC4895B5DC041EE796EF6F973402591E2A2A9315CC041EE796EF6F97340948BF792E41D5CC07C237AF479FE7340BBDDD3F715195CC0B99829EC92FF7340A2955F788E0B5CC09E4A22B2A90274400A36B82DB01A5CC09E4A22B2A90274400A36B82DB01A5CC0E75E49324107744097BEF5E5100A5CC0E75E493241077440583D8A66C9A15CC0B2C78CACD321744001000000010000000001000000FFFFFFFF0000000002
I can get WFS formats from the layer preview. For example GeoJSON:
{"type":"FeatureCollection","features":[{"type":"Feature","id":"Testview.DDBF6CB6-753B-E011-B376-001AA0D73D69","geometry":{"type":"LineString","coordinates":[[-112.46707606,318.51061814],[-112.59682811,318.51061814],[-112.46707606,318.81465088],[-112.46707606,319.90477417],[-112.77597878,319.62266395],[-117.43028368,319.62266395],[-117.65617998,319.8949727],[-117.65617998,318.81465088],[-117.48302249,318.51061814],[-117.65617998,318.51061814],[-117.65617998,315.39065302],[-117.54433764,315.27171418],[-117.65617998,315.15277534],[-117.65617998,305.78815909],[-112.61916471,305.78815909],[-112.46707606,305.98456484],[-112.46707606,315.15277534],[-112.5789184,315.27171418],[-112.46707606,315.39065302],[-112.46707606,318.51061814]]},"geometry_name":"GeoData","properties":{}},{"type":"Feature","id":"Testview.DEBF6CB6-753B-E011-B376-001AA0D73D69","geometry":{"type":"LineString","coordinates":[[-114.52791751,322.11417823],[-114.52791751,322.4868732],[-114.3617051,322.4868732],[-114.49896995,322.77556878],[-117.65617998,322.77556878],[-117.65617998,321.71030346],[-117.65617998,321.17357273],[-117.62832491,320.92609106],[-117.65617998,320.92609106],[-117.65617998,319.8949727],[-117.43028368,319.62266395],[-112.77597878,319.62266395],[-112.46707606,319.90477417],[-112.39196582,319.97336975],[-112.18057069,320.16642965],[-112.41700309,320.16642965],[-112.41700309,320.4534171],[-112.15728139,320.4534171],[-114.52791751,322.11417823]]},"geometry_name":"GeoData","properties":{}}],"totalFeatures":2,"numberMatched":2,"numberReturned":2,"timeStamp":"2020-08-19T16:35:00.494Z","crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}}}
Best regards
Jonas
_______________________________________________
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
