Yes, I understand that MVT is 2D-only and that SRID can be important
but my data has no explicit SRID
Sample data can be any 3D Autocad DXF or any 3d model (Sketchup for ex)
imported into postgis (no coord sys)
My query is
WITH cte AS
(
SELECT
id
, original_feature_id
, layer_id
, ST_FORCE2D(geometry) AS geometry
FROM {0}.{1}
)
SELECT
id
, ST_ASMVTGEOM(
geometry
,
ST_MAKEENVELOPE(:min_x, :min_y, :max_x, :max_y),
:tile_size, 0, true) geometry
FROM cte
WHERE layer_id = :layer_id
AND
geometry && ST_MAKEENVELOPE(:min_x, :min_y, :max_x, :max_y)
AND
ST_INTERSECTS(geometry, ST_MAKEENVELOPE(:min_x, :min_y, :max_x, :max_y))
ORDER BY
id
) q
As far as I understand grid tiles schema should be used to determine
"simplification level" while preparing vector tile. PostGIS functions have
no sufficient params to provide this schema information (resolution-extent
mapping). GDAL supports this but it is hard to use it for this (mostly file
based, CLI-oriented, undocumented features of c# bindings)
--
Sent from: http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
