PostgreSQL教程

postgresql数据库中存储经纬度或电子围栏

本文主要是介绍postgresql数据库中存储经纬度或电子围栏,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

在postgresql数据库中,如果字段类型是geometry或者是(Type),我们要更新该字段为经纬度(坐标),可以尝试采取以下脚本:

1.存经纬度

update device set shape = ST_GeomFromText(‘POINT(108.658463 34.1437)’, 4610) where id=‘a6a2c56a-5f7d-48a9-a213-f2c4360e4f3b’

如需展示轮廓,则获取一组几何坐标

update building set shape = ST_GeomFromText(‘POLYGON((121.415703 31.172893,121.415805 31.172664,121.416127 31.172751,121.41603 31.172976,121.415703 31.172893))’,4610) where objectid = 81

2.存空间信息

update device set shape = st_GeomFromText('[["13540590.2738545,3488536.66830615","13540666.5189164,3488577.10006504","13540730.989878,3488491.09500687","13540637.9626006,3488450.56659938","13540630.8489416,3488453.01866445","13540590.2738545,3488536.66830615"]',3857) where id=‘a6a2c56a-5f7d-48a9-a213-f2c4360e4f3b’

存储后:0106000020110F00000100000001030000000100000005000000226078DDA33B6841D2E096074D674441141DEA27765B6841418B152B406544413F4E50775F5E6841F78D4FC2C54C44410B5670C6EB3968410BEC19DB343D4441226078DDA33B6841D2E096074D674441

页面展现:

 

 

3.查看

 select id,st_astext(shape ) from  device  

参考文章:https://blog.csdn.net/rosejeck/article/details/82962511

这篇关于postgresql数据库中存储经纬度或电子围栏的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!