17.基于java+postgis的矢量瓦片

postgres12.0+postgis3.0以上版本

1.传入参数

layerName表名
zoom 级别
row 行号
col 列号

2.sql源码

 SELECT
        ST_AsMVT (tile,#{layerName},4096,'geom') tile
        FROM
        (
        SELECT
        st_asmvtgeom (geom,
        ST_TileEnvelope(${zoom}, ${
  
  row}, ${col},st_makeenvelope (-180,-270,180,90, 4326)),
        4096,
        0,
        TRUE
        ) AS geom
 		<if test="cols != null and cols != ''">
           ,${cols}
        </if>
        FROM
        ${layerName} 
        ) AS tile
        WHERE
        tile.geom IS NOT NULL;

3.调用

List<Map