将坐标转为WGS_1984_UTM_Zone_48N(32648)后再计算其面积:
-- 转换坐标系并计算面积(平方米)
SELECT ST_Area(ST_Transform(GeomFromText('POLYGON((106.763 26.653, 106.763 26.626, 106.815 26.625, 106.809 26.666, 106.763 26.653))', 4326), 32648)) AS Area_SquareMeters;
输出结果:
将坐标转为WGS_1984_UTM_Zone_48N(32648)后再计算其面积:
-- 转换坐标系并计算面积(平方米)
SELECT ST_Area(ST_Transform(GeomFromText('POLYGON((106.763 26.653, 106.763 26.626, 106.815 26.625, 106.809 26.666, 106.763 26.653))', 4326), 32648)) AS Area_SquareMeters;
输出结果: