GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → geocompass → Pg Coordtransform

geocompass / Pg Coordtransform

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

Labels

plpgsql

Projects that are alternatives of or similar to Pg Coordtransform

Wikipedia Mirror
🌐 Guide and tools to run a full offline mirror of Wikipedia.org with three different approaches: Nginx caching proxy, Kimix + ZIM dump, and MediaWiki/XOWA + XML dump
Stars: ✭ 160 (-28.57%)
Mutual labels:  plpgsql
Postgis coordinate transform
一个在postgis中结合中国国情，批量对数据进行加偏到百度坐标，高德谷歌的火星坐标，或者逆向纠偏
Stars: ✭ 182 (-18.75%)
Mutual labels:  plpgsql
Store
PostgreSQL shopping cart
Stars: ✭ 213 (-4.91%)
Mutual labels:  plpgsql
Docker Compose
一些基础服务的docker-compose配置文件，方便在一台新电脑上快速开始工作
Stars: ✭ 163 (-27.23%)
Mutual labels:  plpgsql
Colpivot
Dynamic row to column pivotation/transpose in Postgres made simple.
Stars: ✭ 173 (-22.77%)
Mutual labels:  plpgsql
Amazon Redshift Udfs
A collection of example UDFs for Amazon Redshift.
Stars: ✭ 194 (-13.39%)
Mutual labels:  plpgsql
Cisl
Columnstore Indexes Scripts Library
Stars: ✭ 155 (-30.8%)
Mutual labels:  plpgsql
Postgis Vt Util
postgres helper functions for making vector tiles
Stars: ✭ 216 (-3.57%)
Mutual labels:  plpgsql
Sql Battleships
Play Battleships on PostgreSQL
Stars: ✭ 174 (-22.32%)
Mutual labels:  plpgsql
3dcitydb
3D City Database - The Open Source CityGML Database
Stars: ✭ 210 (-6.25%)
Mutual labels:  plpgsql
Pg rational
Precise fractional arithmetic for PostgreSQL
Stars: ✭ 168 (-25%)
Mutual labels:  plpgsql
Dox
A Document Database API extension for Postgres
Stars: ✭ 168 (-25%)
Mutual labels:  plpgsql
Pgjwt
PostgreSQL implementation of JWT (JSON Web Tokens)
Stars: ✭ 198 (-11.61%)
Mutual labels:  plpgsql
Postgresdbsamples
Sample databases for postgres
Stars: ✭ 161 (-28.12%)
Mutual labels:  plpgsql
Dbt Utils
Utility functions for dbt projects.
Stars: ✭ 212 (-5.36%)
Mutual labels:  plpgsql
Pghero.sql
Postgres insights made easy
Stars: ✭ 155 (-30.8%)
Mutual labels:  plpgsql
Pagila
PostgreSQL Sample Database
Stars: ✭ 190 (-15.18%)
Mutual labels:  plpgsql
Plsm
Generates Ecto models from already existing tables
Stars: ✭ 221 (-1.34%)
Mutual labels:  plpgsql
Freedom
capstone based disassembler for extracting to binnavi
Stars: ✭ 214 (-4.46%)
Mutual labels:  plpgsql
Schemaverse
The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. Compete against other players using raw SQL commands to command your fleet. Or, if your PL/pgSQL-foo is strong, wield it to write AI and have your fleet command itself!
Stars: ✭ 207 (-7.59%)
Mutual labels:  plpgsql
View All Similar Projects ➔

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 geoc_wgs84tobd09(geom) from test_table
BD09转WGS84
select geoc_bd09towgs84(geom) from test_table

CGCS2000转GCJ02
select geoc_cgcs2000togcj02(geom) from test_table
GCJ02转CGCS2000
select geoc_gcj02tocgcs2000(geom) from test_table

CGCS2000转BD09
select geoc_cgcs2000tobd09(geom) from test_table
BD09转CGCS2000
select geoc_bd09tocgcs2000(geom) from test_table

GCJ02转BD09
select geoc_gcj02tobd09(geom) from test_table
BD09转GCJ02
select geoc_bd09togcj02(geom) from test_table

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]

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].