基于postgres空间至属性转换

update  gis_inspfeature iu  set  y=to_number(iss.y,'999999999.9999999999') 

from (SELECT eventid,

split_part(split_part(split_part(ST_AsText(geom),'(',2),')',1),' ',1) as x

,split_part(split_part(split_part(ST_AsText(geom),'(',2),')',1),' ',2) as y FROM gis_inspfeature) 

iss where iu.eventid=iss.eventid;