shp数据导入postgis

た入场券 2021-07-25 22:08 564阅读 0赞

下载各地区geojson数据：[http://datav.aliyun.com/tools/atlas/\#&lat=30.332329214580188&lng=106.72278672066881&zoom=3.5][http_datav.aliyun.com_tools_atlas_lat_30.332329214580188_lng_106.72278672066881_zoom_3.5]

geojson和shp数据互转： [https://mapshaper.org/][https_mapshaper.org]

可以使用安装postgis时自带的工具

![20200825184222705.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 3][]

### **注意：一定不要有中文路径，否则会导入失败！！** ###

如果shp数据量较小的话，可以导入postgis中，如果shp文件比较大，内容比较多的话，那么就可以考虑将shp数据通过geoserver发布成地图服务，wms，geojson都可以。

**注意**：如果本地安装了postgis，并想在普通postgreSQL数据库中添加postgis模块，可以新建查询，用以下命令创建postgis

![20210401112335590.png][]

CREATE EXTENSION postgis;

刷新数据库，如果出现了名为“spatial\_ref\_sys”的表，表示postgis模块加载成功

[http_datav.aliyun.com_tools_atlas_lat_30.332329214580188_lng_106.72278672066881_zoom_3.5]: http://datav.aliyun.com/tools/atlas/#&lat=30.332329214580188&lng=106.72278672066881&zoom=3.5
[https_mapshaper.org]: https://mapshaper.org/
[20200825184222705.png]: /images/20210725/1d5838396507424f9175a5a82b475b6f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200825184419705.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200825184444847.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 2]: /images/20210725/fd3d72de0a8e4c3da28baea9b0dca461.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMzIzMjU2_size_16_color_FFFFFF_t_70 3]: /images/20210725/7c2d04a9740f4c59aef0e1359f4cec27.png
[20210401112335590.png]: /images/20210725/c373217ba1894cb9abc7ad20bfd081c6.png