pgsql2shp 导出.shp文件

- 日理万妓 2022-02-21 16:28 401阅读 0赞

### 1.工具pgsql2shp.exe ###

安装PostGIS时，会在其安装目录下生成shp2pgsql.exe。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70][]

### 2.导出命令 ###

pgsql2shp [<options>] <database> [<schema>.]<table>

pgsql2shp [<options>] <database> <query>

命令中的参数含义如下：

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td>参数</td> 
   <td>含义</td> 
  </tr> 
  <tr> 
   <td>-f &lt;filename&gt;</td> 
   <td>导出的shp文件名称</td> 
  </tr> 
  <tr> 
   <td>-h &lt;host&gt;</td> 
   <td>主机地址</td> 
  </tr> 
  <tr> 
   <td>-p &lt;port&gt;</td> 
   <td>端口号</td> 
  </tr> 
  <tr> 
   <td>-u &lt;user&gt;</td> 
   <td>用户名</td> 
  </tr> 
  <tr> 
   <td>-P &lt;password&gt;</td> 
   <td>密码</td> 
  </tr> 
  <tr> 
   <td>-g &lt;geometry column&gt;</td> 
   <td>In the case of tables with multiple geometry columns, the geometry column to use when writing the shape file.</td> 
  </tr> 
  <tr> 
   <td>-b</td> 
   <td>Use a binary cursor. This will make the operation faster, but will not work if any NON-geometry attribute in the table lacks a cast to text.</td> 
  </tr> 
  <tr> 
   <td>-r</td> 
   <td>Raw mode. Do not drop the&nbsp;<code>gid</code>&nbsp;field, or escape column names.</td> 
  </tr> 
  <tr> 
   <td>-m&nbsp;<font>filename</font></td> 
   <td>Remap identifiers to ten character names. The content of the file is lines of two symbols separated by a single white space and no trailing or leading space.</td> 
  </tr> 
 </tbody> 
</table>

### 3.导出实例 ###

将数据库Testpg中的表nyc\_streets导出，导出后文件的位置是E:/shp/。

pgsql2shp -f E:/shp/nyc_streets.shp -h localhost -u postgres -P 123456 -p 5433 Testpg  public.nyc_streets;

或

pgsql2shp -f E:/shp/nyc_streets.shp -h localhost -u postgres -P 123456 -p 5433 Testpg  "SELECT * from  nyc_streets";

默认情况下生成 nyc\_streets.shp文件，以及另外4个附属文件。 导出结果如下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70]: /images/20220221/6eaa2739a17c425d811e06860bb9145b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 1]: /images/20220221/c34e30e3e0c34a888ebae4ef54142525.png