例如查询表tdzc1中ZDTZM各类型面积为多少:
WITH Polygon AS (
SELECT GeomFromText('POLYGON((106.763 26.653, 106.763 26.626, 106.815 26.625, 106.809 26.666, 106.763 26.653))', 4326) AS geom
)
SELECT ZDTZM, SUM(ST_Area(ST_Transform(ST_Intersection(tdzc1.Geometry, Polygon.geom), 32648))) AS Area_SquareMeters
FROM tdzc1, Polygon
WHERE ST_Intersects(tdzc1.Geometry, Polygon.geom)
GROUP BY ZDTZM;
结果: