0

Is there some problem that can make PostGIS point geometry unreadable by GeoServer WMTS? The points are generated with st_makepoint with lon/lat float args.

I'm especially confused because I have other layers that work fine.

java.lang.RuntimeException: org.geotools.data.DataSourceException: An exception occurred while parsing WKB data org.geotools.data.DataSourceException: An exception occurred while parsing WKB data An exception occurred while parsing WKB data Unknown WKB type 77

https://geo.hyphae.design/geoserver/stream/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=stream%3Asbir_sid_f5ck5f8hwjibdgpmuck6&maxFeatures=50&outputFormat=application%2Fjson

pgadmin query result

"0101000020E6100000A59849E0237255C0EB43A5DF7F194340"
"0101000020E610000079686721247255C0968E24FB79194340"
"0101000020E61000003D31E96B247255C0951046B274194340"
"0101000020E6100000360300AA247255C0E7FCE14A70194340"
"0101000020E6100000328F64D3247255C0C8EF495B6D194340"
"0101000020E61000008956934CF37155C019ED4CFCAC194340"
"0101000020E6100000F1FE97ABEE7155C057CF52977C194340"
"0101000020E61000003B2A2E7FF07155C006EAB3A87C194340"
"0101000020E6100000ADCDB51EF47155C09CB92CCB7C194340"
"0101000020E61000001000BADBF77155C09B1B27CF7C194340"

geometry as text

4
  • Geoserver doesn't handle that type of wkb geometry.
    – Ian Turton
    Jan 11, 2021 at 19:36
  • @IanTurton OK so what is type 77 anyway and why is st_makepoint creating that type instead of a simple point? Jan 11, 2021 at 19:50
  • Please post one such WKB string. Jan 11, 2021 at 20:48
  • No idea what type 77 is as far as I know there are only 25 types (en.wikipedia.org/wiki/…) - the link you include works fine for me
    – Ian Turton
    Jan 12, 2021 at 8:34

1 Answer 1

1

I believe I resolved this problem. The issue was that the table was being created without an id primary key. The database was using the geom column as the PK because it was first in the data insert.

The fix was to delete the primary key constraint, add an auto-increment id integer column and make it the primary key. I then updated the layer in geoserver by using the 'reload geometry type' and the data began to be served correctly.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.