#添加几何对象shape列操作
select addgeometrycolumn('tgpostgissde', 'plat_bas_equipment_install', 'shape', 4326, 'POINT',2)
#合并字段的经纬度
select concat('POINT(',longtitude,',',latitude,')') from plat_bas_equipment_install
#更新对应表的记录
update plat_bas_equipment_install set shape=st_geomfromtext(concat('POINT(',longtitude,' ',latitude,')'),4326) where longtitude is not null
select longtitude from plat_bas_equipment_install where longtitude is not null