geoc_bd09towgs84 百度坐标转wgs84

转自：https://zhuanlan.zhihu.com/p/612305027

描述

百度坐标系转wgs84坐标系"geoc_bd09towgs84"("geom" "public"."geometry")

示例

select geoc_bd09towgs84(st_geometryfromtext('POINT (120.23382400080985 30.38137624233871)'));
--return POINT (120.22286989552329 30.377518532797247)
select geoc_bd09towgs84(geometry),geometry from gantry g

• geoc_wgs84tobd09 wgs84坐标转百度。

描述

wgs84转百度坐标系"geoc_wgs84tobd09"("geom" "public"."geometry")

示例

select geoc_wgs84tobd09(st_geometryfromtext('POINT (120.22286189815185 30.37751343583605)'));--return POINT (120.23382400080985 30.38137624233871)
select geoc_wgs84tobd09(geometry),geometry from gantry g

 

获取点的X、Y、Z坐标 ST_X(geometry)、 ST_Y(geometry)、 ST_Z(geometry)

示例

SELECT ST_X(ST_GeomFromEWKT('POINT(1 2 3 4)'));--return 1
SELECT ST_Y(ST_GeomFromEWKT('POINT(1 2 3 4)'));--return 2
SELECT ST_Z(ST_GeomFromEWKT('POINT(1 2 3 4)'));--return 3