-- the_geom 自带 投影坐标 4326-- 17.3 图斑数据中的面积 SELECT jcmj FROM "spot_meta_v2" WHERE jcbh = '6209822021062907223962';-- 直接计算面积(平方度、万平方千米)后换算 st_area(the_geom) * 1500 * 10000-- 18.2896541856215 SELECT st_area(the_geom) * 1500 * 10000 FROM "spot_meta_v2" WHERE jcbh = '6209822021062907223962';-- 转换投影坐标后直接计算面积(平方米)并换算 st_area(ST_Transform(the_geom, 26986)) / 666-- 17.3328237816885SELECT st_area(ST_Transform(the_geom, 26986)) / 666.66 FROM "spot_meta_v2" WHERE jcbh = '6209822021062907223962';-- 转换地理坐标后计算面积(平方米)并换算 st_area(the_geom:: geography) / 666.66-- 17.311556754445 SELECT st_area(the_geom:: geography) / 666.66 FROM "spot_meta_v2" WHERE jcbh = '6209822021062907223962';-- 其他投影方式-- SELECT st_area(ST_Transform(the_geom, 2249)) * 0.3048 ^ 2 / 666.66 FROM "spot_meta_v2" WHERE jcbh = '6209822021062907223962';