PostGIS 测试 - 扩展类型（ SQL-MM）

Dear 丶 2022-02-21 09:49 240阅读 0赞

SQL-MM格式定义了一些插值曲线，这些插值曲线和EWKT有点类似，也支持3DZ、3DM、4D坐标，但是不支持嵌入空间参考。

<table> 
 <thead> 
  <tr> 
   <th>几何类型</th> 
   <th>SQL-MM</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>插值圆弧</td> 
   <td>CIRCULARSTRING(0 0, 1 1, 1 0)</td> 
  </tr> 
  <tr> 
   <td>插值复合曲线</td> 
   <td>COMPOUNDCURVE(CIRCULARSTRING(0 0, 1 1, 1 0),(1 0, 0 1))</td> 
  </tr> 
  <tr> 
   <td>曲线多边形</td> 
   <td>CURVEPOLYGON(CIRCULARSTRING(0 0, 4 0, 4 4, 0 4, 0 0),(1 1, 3 3, 3 1, 1 1))</td> 
  </tr> 
  <tr> 
   <td>多曲线</td> 
   <td>MULTICURVE((0 0, 5 5),CIRCULARSTRING(4 0, 4 4, 8 4))</td> 
  </tr> 
  <tr> 
   <td>多曲面</td> 
   <td>MULTISURFACE(CURVEPOLYGON(CIRCULARSTRING(0 0, 4 0, 4 4, 0 4, 0 0),(1 1, 3 3, 3 1, 1 1)),((10 10, 14 12, 11 10, 10 10),(11 11, 11.5 11, 11 11.5, 11 11)))</td> 
  </tr> 
 </tbody> 
</table>

本文通过实例演示几何对象的定义。

## 1.建表 ##

CREATE TABLE postgismm ( 
      id SERIAL PRIMARY KEY,
      name VARCHAR(128),
      geom GEOMETRY
    );

## 2.添加GIST索引 ##

CREATE INDEX postgismm_gix ON postgismm USING GIST (geom);

## 3.插入数据 ##

### 3.1 CIRCULARSTRING ###

INSERT INTO postgismm (name, geom) VALUES ('c1',
      ST_GeomFromText('CIRCULARSTRING(0 0, 1 1, 1 0)', 26910)
    );
     
    INSERT INTO postgismm (name, geom) VALUES ('c2',
      ST_GeomFromText('CIRCULARSTRING(0 0, 4 0, 4 4, 0 4, 0 0)', 26910)
    );

QGIS中显示几何

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70][]

### 3.2 COMPOUNDCURVE ###

INSERT INTO postgismm (name, geom) VALUES ('c1',
      ST_GeomFromText('COMPOUNDCURVE(CIRCULARSTRING(0 0, 1 1, 1 0),(1 0, 0 1))', 26910)
    );
     
    INSERT INTO postgismm (name, geom) VALUES ('c2',
      ST_GeomFromText('COMPOUNDCURVE(CIRCULARSTRING(2 0, 3 3, 3 0),(3 0, 2 0))', 26910)
    );

QGIS中显示几何：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 1][]

### 3.3 CURVEPOLYGON ###

INSERT INTO postgismm (name, geom) VALUES ('p1',
      ST_GeomFromText('CURVEPOLYGON(CIRCULARSTRING(0 0, 4 0, 4 4, 0 4, 0 0),CIRCULARSTRING(0 0, 1 0, 1 1,0 1, 0 0))', 26910)
    );
     
    INSERT INTO postgismm (name, geom) VALUES ('p2',
      ST_GeomFromText('CURVEPOLYGON(CIRCULARSTRING(7 0, 9 0, 9 4, 7 4, 7 0), (7 0, 9 0, 8 2, 7 0))', 26910)
    );

QGIS中显示几何：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 2][]

### 3.4 MULTICURVE ###

INSERT INTO postgismm (name, geom) VALUES ('m1',
      ST_GeomFromText('MULTICURVE((0 0, 5 5),CIRCULARSTRING(4 0, 4 4, 8 4))', 26910)
    );

QGIS中显示几何：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 3][]

### 3.5 MULTISURFACE ###

INSERT INTO postgismm (name, geom) VALUES ('m1',
      ST_GeomFromText('MULTISURFACE(CURVEPOLYGON(CIRCULARSTRING(0 0, 4 0, 4 4, 0 4, 0 0),(1 1, 3 3, 3 1, 1 1)),((7 5, 11 7, 8 5, 7 5),(8 6, 8.5 6, 8 6.5, 8 6)))', 26910)
    );

QGIS中显示几何：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 4][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70]: /images/20220221/f2708c1dd33a4362812a0d53f75a3d86.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 1]: /images/20220221/9c1d53a008dc4954af620d45ef1a3e52.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 2]: /images/20220221/0ff158189f624865a79910c7fb9cbb1c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 3]: /images/20220221/f1ec9f387f2742cca9e2ec4ac8e5e815.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeWF6aGVuMjAxMQ_size_16_color_FFFFFF_t_70 4]: /images/20220221/f07a0eb809ae41948d20295302897f69.png