[postgis-tickets] [PostGIS] #4289: A multipolygon is inverted in ST_AsMVTGeom in some cases

[PostGIS]

#4289: A multipolygon is inverted in ST_AsMVTGeom in some cases
----------------------+-------------------------
  Reporter:  ajolma   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:  vector tile
----------------------+-------------------------

Comment (by Algunenano):

 Can you make sure you are using that dev release and also the latest GEOS?

 I'm getting correct results:
 {{{
 crap=# Select postgis_full_version();
 NOTICE:  Function postgis_gdal_version() not found.  Is raster support
 enabled and rtpostgis.sql installed?
 NOTICE:  Function postgis_raster_scripts_installed() not found. Is raster
 support enabled and rtpostgis.sql installed?
 NOTICE:  Function postgis_raster_lib_version() not found. Is raster
 support enabled and rtpostgis.sql installed?
 postgis_full_version
 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.0.0dev r17118" [EXTENSION] PGSQL="110" GEOS="3.8.0dev-
 CAPI-1.12.0 d037cb23" SFCGAL="1.3.6" PROJ="Rel. 5.2.0, September 15th,
 2018" LIBXML="2.9.8" LIBJSON="0.13.1" LIBPROTOBUF="1.3.1" (sfcgal procs
 from "3.0.0dev r17113" need upgrade)
 (1 row)

 crap=#           SELECT ST_AsText(ST_AsMVTGeom(ST_Transform(problem.geom,
 3857), TileBBox(12, 2358, 1093, 3857), 256, 10, TRUE)) geom
 FROM problem
 WHERE ST_Intersects(TileBBox(12, 2358, 1093, 3857), problem.geom);
 geom
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  MULTIPOLYGON(((217 220,253 198,249 166,266 163,266 254,256 262,255
 257,254 255,253 250,249 246,247 241,243 236,242 235,241 236,239 236,238
 233,217 220)),((158 225,177 202,194 216,172 242,166 241,158 225)))
 (1 row)
 }}}


 Can you share also the output for this query (the one with ST_AsText),
 please?

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4289#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.