PostGIS 计算长度和面积

最新推荐文章于 2023-10-14 14:30:06 发布

原创

最新推荐文章于 2023-10-14 14:30:06 发布 · 6.6k 阅读

11 ·

CC 4.0 BY-SA版权

文章标签：

#sql #gis

本文介绍了PostGIS中地理（Geography）和几何（Geometry）类型的区别，强调了在球面上进行距离计算、查询空间交集以及面积分析时的差异。内容包括创建表、查看SRID、选择投影坐标系的方法，并提供了计算距离、查询空间关系及计算面积的SQL示例。此外，还讨论了不同投影坐标系对结果的影响，如3857和4547投影坐标系在计算面积时的差异。

参考官网：http://postgis.net/docs/manual-3.0/using_postgis_dbmanagement.html

The basis for the PostGIS geometry type is a plane. 
The shortest path between two points on the plane is a straight line. 
That means calculations on geometries (areas, distances, lengths, intersections, etc) 
can be calculated using cartesian mathematics and straight line vectors.

The basis for the PostGIS geographic type is a sphere. 
The shortest path between two points on the sphere is a great circle arc. 
That means that calculations on geographies (areas, distances, lengths, intersections, etc) 
must be calculated on the sphere, using more complicated mathematics. 
For more

最低0.47元/天解锁文章