carlo cancellieri ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5e410b8f4298990c97dd9a9b ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiMWYxNGUxN2Y5YTc2NGEwZThmZjQwODQxZjNiNDUyMWMiLCJwIjoiaiJ9 ) / Bug ( https://osgeo-org.atlassian.net/browse/GEOS-9633?atlOrigin=eyJpIjoiMWYxNGUxN2Y5YTc2NGEwZThmZjQwODQxZjNiNDUyMWMiLCJwIjoiaiJ9 ) GEOS-9633 ( https://osgeo-org.atlassian.net/browse/GEOS-9633?atlOrigin=eyJpIjoiMWYxNGUxN2Y5YTc2NGEwZThmZjQwODQxZjNiNDUyMWMiLCJwIjoiaiJ9 ) Pregeneralized DataStore and Vector-tyle ( https://osgeo-org.atlassian.net/browse/GEOS-9633?atlOrigin=eyJpIjoiMWYxNGUxN2Y5YTc2NGEwZThmZjQwODQxZjNiNDUyMWMiLCJwIjoiaiJ9 ) Issue Type: Bug Affects Versions: 2.17.0 Assignee: Unassigned Attachments: 3_edited.png Components: Features pregeneralized, Vector Tiles Created: 28/May/20 2:30 PM Environment: Windows 10 openjdk 11 Geoserver-2.17.0 or master Priority: Medium Reporter: carlo cancellieri ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5e410b8f4298990c97dd9a9b ) Dear list, we're trying to configure a pregeneralized datastore to speedup the vector tyles cache generation with no luck. Actually asking in layerpreview for a simple application/openlayer everything works very well. ------- 14 May 20:45:36 DEBUG [renderer.lite] - Computed scale denominator: 2.7922819993363017E8 14 May 20:45:36 DEBUG [renderer.lite] - creating rules for scale denominator - 279,228,199.934 14 May 20:45:36 DEBUG [data.util] - CRSConverterFactory can be applied from Strings to CRS only. 14 May 20:45:36 DEBUG [data.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 14 May 20:45:36 DEBUG [renderer.lite] - Processing 1 stylers for n50:gadm36_0_3857_gen 14 May 20:45:36 DEBUG [renderer.lite] - Expanding rendering area by 2 pixels to consider stroke width 14 May 20:45:36 WARN [operation.projection] - Possible use of "Popular Visualisation Pseudo Mercator" projection outside its valid area. Longitude 2147483287░00.0'W is out of range (▒180░). 14 May 20:45:36 DEBUG [renderer.lite] - Querying layer n50:gadm36_0_3857_gen with bbox: ReferencedEnvelope [-2.4862478922090434E7 : 2.4862478922090434E7, -3.604277604743299E7 : 2.4315191650220517E7] 14 May 20:45:36 TRACE [util.factory] - ENTRY (GeometryFactory, JTS_GEOMETRY_FACTORY) 14 May 20:45:36 TRACE [util.factory] - RETURN (GeometryFactory, JTS_GEOMETRY_FACTORY): found implementation Optional. 14 May 20:45:36 DEBUG [data.gen] - Hint geometry distance: 62547.11678513289 14 May 20:45:36 DEBUG [data.gen] - Hint geometry distance: 62547.11678513289 14 May 20:45:36 INFO [data.gen] - Using generalizsation: postgis_n50 gadm36_0_3857 geom500 500.0 14 May 20:45:36 DEBUG [geotools.jdbc] - CREATE CONNECTION 14 May 20:45:36 DEBUG [data.jdbc] - exporting PropertyName 14 May 20:45:36 DEBUG [data.util] - CRSConverterFactory can be applied from Strings to CRS only. 14 May 20:45:36 DEBUG [data.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 14 May 20:45:36 DEBUG [geotools.jdbc] - SELECT "gid",ST_AsBinary("geom500") as "geom500" FROM "public"."gadm36_0_3857" WHERE "geom" && ST_GeomFromWKB(?, 3857) 14 May 20:45:36 DEBUG [geotools.jdbc] - 1 = POLYGON ((-24862478.922090434 -19971868.88040857, 24862478.922090434 -19971868.88040857, 24862478.922090434 19971868.880408563, -24862478.922090434 19971868.880408563, -24862478.922090434 -19971868.88040857)) 14 May 20:45:48 DEBUG [geotools.jdbc] - CLOSE CONNECTION Once we try to ask for a mapbox vector tile (or geoJson) to WMS using the layerpreview page, seems that the hint for the geometry distance is not used as well. 14 May 20:49:34 DEBUG [geoserver.wms] - setting up map 14 May 20:49:34 DEBUG [data.gen] - Hint for geometry simplification in query, fallback to base feature 14 May 20:49:34 DEBUG [data.gen] - No hint for geometry distance in query, fallback to base feature 14 May 20:49:34 DEBUG [data.gen] - Hint for geometry simplification in query, fallback to base feature 14 May 20:49:34 DEBUG [data.gen] - No hint for geometry distance in query, fallback to base feature 14 May 20:49:34 DEBUG [geotools.jdbc] - CREATE CONNECTION 14 May 20:49:34 DEBUG [data.jdbc] - exporting PropertyName 14 May 20:49:34 DEBUG [data.util] - CRSConverterFactory can be applied from Strings to CRS only. 14 May 20:49:34 DEBUG [data.util] - InterpolationConverterFactory can be applied from Strings to Interpolation only. 14 May 20:49:34 DEBUG [geotools.jdbc] - SELECT "gid","gid_0","name_0",ST_AsBinary("geom") as "geom","fid" FROM "public"."gadm36_0_3857" WHERE "geom" && ST_GeomFromWKB(?, 3857) 14 May 20:49:34 DEBUG [geotools.jdbc] - 1 = POLYGON ((-20100916.899652816 -30304381.79087722, 20100916.899652816 -30304381.79087722, 20100916.899652816 18516704.85076622, -20100916.899652816 18516704.85076622, -20100916.899652816 -30304381.79087722)) 14 May 20:52:01 DEBUG [geotools.jdbc] - CLOSE CONNECTION4 ------ I think that having PreGeneralized Datastore as backend for the Vector Tile (supporting GEOMETRY_DISTANCE and GEOMETRY_SIMPLIFICATION may help to speedup a lot seeding big source of data: ( https://osgeo-org.atlassian.net/secure/attachment/33498/33498_3_edited.png ) ( https://osgeo-org.atlassian.net/browse/GEOS-9633#add-comment?atlOrigin=eyJpIjoiMWYxNGUxN2Y5YTc2NGEwZThmZjQwODQxZjNiNDUyMWMiLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-9633#add-comment?atlOrigin=eyJpIjoiMWYxNGUxN2Y5YTc2NGEwZThmZjQwODQxZjNiNDUyMWMiLCJwIjoiaiJ9 ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100127- sha1:33b9894 )
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
