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