Need help with pg-coordtransform?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

geocompass
267 Stars 98 Forks MIT License 33 Commits 0 Opened issues

Description

基于PostgreSQL+PostGIS的火星坐标系、百度坐标系、WGS84坐标系、CGCS2000坐标系的转换函数

Services available

!
?

Need anything else?

Contributors list

# 142,731
Less
vue3
Vue.js
ant-des...
23 commits

Welcome to pg-coordtransform 👋

Version

基于PostgreSQL和PostGIS的坐标转换函数,支持点、线、面的WGS84和CGCS2000与GCJ02和BD09坐标系与之间互转。

Example

-- 如果转换后结果为null,查看geom的srid是否为4326或者4490
WGS84转GCJ02
select geoc_wgs84togcj02(geom) from test_table
GCJ02转WGS84
select geoc_gcj02towgs84(geom) from test_table

WGS84转BD09 select geocwgs84tobd09(geom) from testtable BD09转WGS84 select geocbd09towgs84(geom) from testtable

CGCS2000转GCJ02 select geoccgcs2000togcj02(geom) from testtable GCJ02转CGCS2000 select geocgcj02tocgcs2000(geom) from testtable

CGCS2000转BD09 select geoccgcs2000tobd09(geom) from testtable BD09转CGCS2000 select geocbd09tocgcs2000(geom) from testtable

GCJ02转BD09 select geocgcj02tobd09(geom) from testtable BD09转GCJ02 select geocbd09togcj02(geom) from testtable ```

How to use

PostgreSQL安装PostGIS扩展
复制geoc-pg-coordtansform.sql中代码,在数据库执行

Who use/Who star

  • 阿里巴巴(digoal,德哥)

  • 国信司南(北京)地理信息技术有限公司(本库作者)

  • CTOLib码库

  • 九天气象(lzuniujp08)

  • 深圳普天宜通股份有限公司(ShareQiu1994)

  • 中原百科(zhongyuanbaike)

  • MonsterBOBO(hanrea)

  • nocode(sanford)

Author

👤 LH QQ:1016817543

👤 Wangsb QQ:1017218804

🤝 Contributing

Contributions, issues and feature requests are welcome!
Feel free to check issues page.

开发

修改src下的文件,使用linux相关命令将文件合并为一个

find src/ -name "*.sql" | xargs sed 'a\' > geoc-pg-coordtransform.sql

长期招聘

  • 岗位1:WebGIS开发工程师
  • 岗位2:Node.js后端开发工程师
  • 岗位3:前端开发工程师

GIS专业背景或地图开发经验优先

联系方式:

qq/微信:1016817543

简历投递邮箱:[email protected]


We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.