https://gitee.com/zjko_0/pg-coordtransform.git
PG 各类纠偏函数
liuhang
f76090708e
修改md
|
6 years ago | |
|---|---|---|
| LICENSE | 6 years ago | |
| README.md | 6 years ago | |
| geoc_delta.sql | 6 years ago | |
| geoc_gcj02_wgs84.sql | 6 years ago | |
| geoc_gcj02towgs84.sql | 6 years ago | |
| geoc_gcj02towgs84_line.sql | 6 years ago | |
| geoc_gcj02towgs84_multiline.sql | 6 years ago | |
| geoc_gcj02towgs84_multipoint.sql | 6 years ago | |
| geoc_gcj02towgs84_multipolygon.sql | 6 years ago | |
| geoc_gcj02towgs84_point.sql | 6 years ago | |
| geoc_gcj02towgs84_polygon.sql | 6 years ago | |
| geoc_is_in_china_bbox.sql | 6 years ago | |
| geoc_transform_lat.sql | 6 years ago | |
| geoc_transform_lon.sql | 6 years ago | |
| geoc_wgs84togcj02.sql | 6 years ago | |
| geoc_wgs84togcj02_line.sql | 6 years ago | |
| geoc_wgs84togcj02_multiline.sql | 6 years ago | |
| geoc_wgs84togcj02_multipoint.sql | 6 years ago | |
| geoc_wgs84togcj02_multipolygon.sql | 6 years ago | |
| geoc_wgs84togcj02_numeric.sql | 6 years ago | |
| geoc_wgs84togcj02_point.sql | 6 years ago | |
| geoc_wgs84togcj02_polygon.sql | 6 years ago | |
| 示例.sql | 6 years ago |
README.md
pg-coordtransform
基于PostgreSQL+PostGIS的坐标转换函数,支持点、线、面的WGS84与GCJ02坐标互转
示例
GCJ02转WGS84
select geoc_gcj02towgs84(geom) from test_table
WGS84转GCJ02
select geoc_wgs84togcj02(geom) from test_table
如何安装
PostgreSQL安装PostGIS扩展
复制geoc_gcj02_wgs84.sql中代码，在数据库执行