PostGIS新建geom类型,创建扇区sql

2020-07-03  本文已影响0人  不玩了啊

SELECT AddGeometryColumn ('public','ods_ne_cell_ng','geom',4326,'POLYGON',2);

create index ods_ne_cell_ng_index on public.ods_ne_cell_ng using gist (geom)

update sector_4g set geom= ST_SetSRID(ST_GeomFromEWKT(createSector(longitude,latitude,azimuth,0.12,0.06,50,'室外')),4326)

update ods_ne_cell_ng set geom= ST_SetSRID(ST_GeomFromEWKT(createSector(cast(longitude as numeric),cast(latitude as numeric),cast (azimuth as numeric) ,0.03,0.01,30,scene_type)),4326)

上一篇下一篇

猜你喜欢

热点阅读