# springboot-mvt

**Repository Path**: gis_6/springboot-mvt

## Basic Information

- **Project Name**: springboot-mvt
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-08-08
- **Last Updated**: 2024-08-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

jdk 版本1.8
select *,row_number() OVER (ORDER BY tile DESC ) as num from vector_tile(9,1,1,'gis_osm_roads_free_1')

CREATE OR REPLACE FUNCTION "public"."vector_tile"(IN "z" int4, IN "x" int4, IN "y" int4, IN "tn" text, OUT "tile" bytea)
RETURNS "pg_catalog"."bytea" AS $BODY$
DECLARE
bound geometry;
extent box2d;
sql text;
BEGIN  
--ST_TileEnvelope函数得到的是epsg:3857坐标系，表是4326，需要坐标系转换。
bound:=ST_Transform(ST_TileEnvelope(z,x,y),4326);
extent:=Box2D(bound);
sql:='WITH mvtgeom AS(
SELECT ST_AsMVTGeom(geom, $1) AS geom,name FROM ' || tn || ' WHERE ST_Intersects(geom, $2)
) SELECT ST_AsMVT(mvtgeom.*,$3) FROM mvtgeom';
execute format(sql) using extent,bound,tn into tile;
RETURN;
END;
$BODY$
LANGUAGE plpgsql VOLATILE STRICT
COST 100