PostGIS新建geom類型，創建扇區sql

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)

上一篇:Android開發EditText時間問題

下一篇:源代碼的兩倍。