Documentation bug in SQL query example for ST_AsMVTGeom

[azakh]

Currently:

SELECT ST_AsMVTGeom(
            ST_Transform( geom, 3857 ),
            ST_TileEnvelope(12, 513, 412), extent => 4096, buffer => 64) AS geom
  FROM data
  WHERE geom && ST_TileEnvelope(12, 513, 412, margin => (64.0 / 4096))

Should be:

SELECT ST_AsMVTGeom(
            ST_Transform( geom, 3857 ),
            ST_TileEnvelope(12, 513, 412), extent => 4096, buffer => 64) AS geom
  FROM data
  WHERE ST_Transform(geom, 3857) && ST_TileEnvelope(12, 513, 412, margin => (64.0 / 4096))

Namely, the geom column should be transformed both in SELECT and WHERE clauses.

Related issue: ​https://trac.osgeo.org/postgis/ticket/5198

[robe]

I think it's better to transform the ST_TileEnvelope rather than the geom, cause otherwise no index would be used unless there is a functional index on the ST_Transform(geom,3857)

-- this assumes the geom has a 4326 srid
SELECT ST_AsMVTGeom(
            ST_Transform( geom, 3857 ),
            ST_TileEnvelope(12, 513, 412), extent => 4096, buffer => 64) AS geom
  FROM data
  WHERE geom && ST_Transform(ST_TileEnvelope(12, 513, 412, margin => (64.0 / 4096)),4326)

@pramsey @mdavis - you agree?

[Regina Obe <lr@…>]

In 460c1e9/git:

Fix ST_AsMVTGeom example. Closes #5758 for PostGIS 3.5.1

[Regina Obe <lr@…>]

In c9e5e238/git Fix ST_AsMVTGeom example. Closes #5758 for PostGIS 3.6.0