ST_DISTANCESPHEROID

📄字数 790

👁️阅读量 加载中...

功能描述

返回给定特定球体的两个经度/纬度几何形状之间的最小距离（以米为单位）。

语法格式

DOUBLE ST_DISTANCESPHEROID(GEOMETRY geomlonlatA, GEOMETRY geomlonlatB, spheroid measurement_spheroid=WGS84);

参数说明

• geomlonlatA：第一个目标 GEOMETRY 对象。
• geomlonlatB：第二个目标 GEOMETRY 对象。
• measurement_spheroid：椭球定义。可选，WGS84。

函数返回类型

DOUBLE 类型

使用说明

1. 此函数不查看几何体的 SRID。 它假设几何坐标基于提供的球体。

示例

SQL> SELECT round(CAST(
                     ST_DistanceSpheroid(ST_Centroid(geom), ST_GeomFromText('POINT(-118 38)',4326), 'SPHEROID["WGS 84",6378137,298.257223563]')
                             As numeric),2) As dist_meters_spheroid,
                     round(CAST(ST_DistanceSphere(ST_Centroid(geom), ST_GeomFromText('POINT(-118 38)',4326)) As numeric),2) As dist_meters_sphere,
     round(CAST(ST_Distance(ST_Transform(ST_Centroid(geom),32611),
                     ST_Transform(ST_GeomFromText('POINT(-118 38)', 4326),32611)) As numeric),2) As dist_utm11_meters
     FROM
             (SELECT ST_GeomFromText('LINESTRING(-118.584 38.374,-118.583 38.5)', 4326) As geom) as foo;

+----------------------+--------------------+-------------------+
| DIST_METERS_SPHEROID | DIST_METERS_SPHERE | DIST_UTM11_METERS |
+----------------------+--------------------+-------------------+
| 70455                | 70425              | 70438             |
+----------------------+--------------------+-------------------+

(1 row)