postgis入库postgresql

update gis_nthtem set geom=st_setsrid(geom,4490);

insert into gis_xmqxx(geom,xmmc,shape_area,xmbh,xzqdm,xzqmc,sxzgbm) select geom,xmmc,st_area(st_transform(geom, 4526)),xmbh,xzqdm,xzqmc,sxzgbm from gis_nthtem;

update n_xmjbxx n set jd=(select st_x(st_centroid(geom)) from gis_xmqxx g where n.xmbh=g.xmbh and g.tbbh is null) where jd is null;

update n_xmjbxx n set wd=(select st_y(st_centroid(geom)) from gis_xmqxx g where n.xmbh=g.xmbh and g.tbbh is null) where wd is null;

update gis_xmqxx set tbbh=xmbh where tbbh is null;