美文网首页
PostGIS新建geom类型,创建扇区sql

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

作者: 不玩了啊 | 来源:发表于2020-07-03 10:55 被阅读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)

    相关文章

      网友评论

          本文标题:PostGIS新建geom类型,创建扇区sql

          本文链接:https://www.haomeiwen.com/subject/vrajqktx.html