-- 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.3328237816885
SELECT 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';