postgis导入shp数据
最近在学习gis,下载了openStreetMap的地图数据,格式为shp,再用postgis导入时总是提示
Failed in pgui_exec(): ERROR: type "geography" does not exist
在网上也没有找到解决办法, 数据库版本为:PostgreSQL 9.3
最后解决办法是 在 扩展中添加一个postgis,就可以导入数据了
另外:如果要完整的使用postgis:必须添加以下几个扩展:(来自官网)
-- Enable PostGIS (includes raster) CREATE EXTENSION postgis; -- Enable Topology CREATE EXTENSION postgis_topology; -- fuzzy matching needed for Tiger CREATE EXTENSION fuzzystrmatch; -- Enable US Tiger Geocoder CREATE EXTENSION postgis_tiger_geocoder;
相关推荐
yangkang 2020-11-09
lbyd0 2020-11-17
sushuanglei 2020-11-12
85477104 2020-11-17
KANSYOUKYOU 2020-11-16
wushengyong 2020-10-28
lizhengjava 2020-11-13
星月情缘 2020-11-13
huangxiaoyun00 2020-11-13
luyong0 2020-11-08
腾讯soso团队 2020-11-06
Apsaravod 2020-11-05
PeterChangyb 2020-11-05
gaobudong 2020-11-04
wwwjun 2020-11-02
gyunwh 2020-11-02
EchoYY 2020-10-31
dingyahui 2020-10-30