在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