Re: [Geoserver-users] Possible bug rendering postgis data?

[Bernhard Kiselka]

Hi!

Thanks dracic and Andrea for all hints, I finally solved the problem.

It was the PostGIS version 2.1.7 that caused the error.
Obviously in this version the simplification collapsed small lines to points; 
https://trac.osgeo.org/postgis/ticket/2093#comment:32 might be the bugfix.

After updating to 2.2.2 all works fine.

Cheers,
Bernhard

-Ursprüngliche Nachricht-
Von: Bernhard Kiselka 
Gesendet: Donnerstag, 29. Oktober 2015 16:29
An: geoserver-users@lists.sourceforge.net
Betreff: Possible bug rendering postgis data?

Dear list!

I have some lines imported to postgres by osmosis and rendering the data with 
the default line style as wms in geoserver 2.7.1.1 fails for scales more zoomed 
out than 1:70K (though working zoomed more in), failing with the following 
message:

org.geotools.data.DataSourceException: An exception occurred while parsing WKB 
data An exception occurred while parsing WKB data Invalid number of points in 
LineString (found 1 - must be 0 or >= 2)

WFS shows all data (just 3502 geometries) though.
I had a look at the PostgreSQL 9.4.5 database with postgis 2.1.7: ST_IsValid 
returns true for all linestrings; also is the number of points for all lines >= 
2 and the minimum length of all lines is 1.04m


--
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Possible bug rendering postgis data?

[Rahkonen Jukka (MML)]

Hi,

It is in the GUI but I am not sure since which version. In Geoserver 2.8 you 
can find it by opening your PostGIS store and finding "Support on the fly 
geometry simplification" setting which is selected by default.

-Jukka Rahkonen-

dracic wrote:

geowolf wrote
> It's actually a postgis data store option, and can be disabled

I haven't see that in GUI, so i suppose through JAVA_OPTS? Like this:

-Dorg.geotools.data.postgis.setSimplifyEnabled=false



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Possible-bug-rendering-postgis-data-tp5233361p5233639.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Possible bug rendering postgis data?

[dracic]

geowolf wrote
> It's actually a postgis data store option, and can be disabled

I haven't see that in GUI, so i suppose through JAVA_OPTS? Like this:

-Dorg.geotools.data.postgis.setSimplifyEnabled=false



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Possible-bug-rendering-postgis-data-tp5233361p5233639.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Possible bug rendering postgis data?

[Andrea Aime]

On Thu, Oct 29, 2015 at 6:00 PM, dracic  wrote:

> As I'm aware, Geoserver uses ST_Simplify in WMS rendering.


It's actually a postgis data store option, and can be disabled

Cheers
Andrea

-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Possible bug rendering postgis data?

[dracic]

As I'm aware, Geoserver uses ST_Simplify in WMS rendering. So you should do
se your PostgreSQL logs, and see how the query actually looks, and then do
geometry validation with that data. Perhaps small lines are collapsing to
points

https://trac.osgeo.org/postgis/ticket/2093
  



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Possible-bug-rendering-postgis-data-tp5233361p5233386.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users