Skip navigation links
10.5.3 既存ジオメトリから新規ジオメトリを作成する関数 »
Section Navigation      [Toggle]

10.5.2.7. GeometryCollection プロパティ分析関数

  • NumGeometries(gc)

    GeometryCollection 値 gc におけるジオメトリ数を返す。 

    mysql> SELECT NumGeometries(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))'));
+------------------------------------------------------------------------------------+
| NumGeometries(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))')) |
+------------------------------------------------------------------------------------+
|                                                                                  2 |
+------------------------------------------------------------------------------------+

  • GeometryN(gc,n)

    GeometryCollection 値 gc における n 番目のジオメトリを返す。ジオメトリ番号は 1 から始まる。 

    mysql> SELECT AsText(GeometryN(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))'),1));
+------------------------------------------------------------------------------------------+
| AsText(GeometryN(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))'),1)) |
+------------------------------------------------------------------------------------------+
| POINT(1 1)                                                                               |
+------------------------------------------------------------------------------------------+

This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.