hmmm, still there seems to be a difference as SpatialDBDS can read those GPKG geometries, that DBQuery fails with
Caused by: com.vividsolutions.jts.io.ParseException: Unknown WKB type 233 at com.vividsolutions.jts.io.WKBReader.readGeometry(WKBReader.java:223) at com.vividsolutions.jts.io.WKBReader.read(WKBReader.java:152) at com.vividsolutions.jts.io.WKBReader.read(WKBReader.java:133) ..ede On 9/29/2020 21:05, Michaud Michael wrote: > Hi Jukka, > > wrt. z/m reading, the patch I had submitted to JTS has been included in > locationtech repo just before the 1.5 release. So you're right, with our 1.14 > vividsolutions version, we probably can't read both forms of WKB. Hopefully, > it > will be easier after our migration to OJ 2.0. > > Michaël > >> envoyé : 29 septembre 2020 à 17:34 >> de : "Rahkonen Jukka (MML)" <jukka.rahko...@maanmittauslaitos.fi> >> à : OpenJump develop and use <jump-pilot-devel@lists.sourceforge.net>, Larry >> Reeder <lnree...@gmail.com> >> objet : Re: [JPP-Devel] Run datastore query too tied to schema with >> Spatialide DS >> >> >> Hi, >> >> Michaël must remember this better, but JTS did not understand the ISO codes >> for 3 and 4 dimensional geometries. This is probably fixed in the >> locationtech >> version. See >> https://lists.osgeo.org/pipermail/geos-devel/2013-December/006757.html >> >> So it may be that once we move to GitHub and to new JTS version, and DB Query >> plugin gets possible fixes needed for the new JTS, it just starts to work >> with >> XYZ(M) geometries. Until that those who know can cast geometries into XY >> with SQL. >> >> -Jukka- >> >> -Jukka Rahkonen- >> >> >> -----Alkuperäinen viesti----- >> Lähettäjä: edgar.sol...@web.de <edgar.sol...@web.de> >> Lähetetty: tiistai 29. syyskuuta 2020 17.36 >> Vastaanottaja: jump-pilot-devel@lists.sourceforge.net; Larry Reeder >> <lnree...@gmail.com> >> Aihe: Re: [JPP-Devel] Run datastore query too tied to schema with Spatialide >> DS >> >> On 28.09.2020 21:46, Rahkonen Jukka (MML) wrote: >> >>> We have the robust DB Query that works fine (despite with XYZ geometries but >>> that's another thing). >>> >> yeah, noticed that DBQuery choked on some geometries from a gpkg test file. >> >> Jukka, would you mind providing some test files for geometry blobs that >> currently don't work with DBQuery so we can ask Larry to enhance the >> extension? i'll cc him, so Larry, if you're not interested to maintain it >> anymore please speak up :) >> >> thx.. ede >> >> >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > > > > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel