官术网_书友最值得收藏!

  • Mastering PostGIS
  • Dominik Mikiewicz Michal Mackiewicz Tomasz Nycz
  • 155字
  • 2021-07-02 22:52:24

Composing and decomposing geometries

One can think of PostGIS geometries as building blocks. The smallest unit, the point, consists of a tuple (in the most common scenario of 2D geometries, a pair) of coordinates. Points can be then used as independent units or arranged into more complex shapes: MultiPoints and LineStrings. LineStrings can constitute a MultiLineString. Closed LineStrings can be treated as rings and form a Polygon. Finally, multiple polygons may form a MultiPolygon. PostGIS is equipped with functions for coupling and decoupling those geometric building blocks, which will be outlined in this section.

Composition and decomposition functions have different names, but in general they follow a similar pattern: composition is done by supplying an array of components or using a PostgreSQL aggregation, and decomposition is done by extracting individual components by their index or by exploding a geometry into multiple rows using a set-returning function. For details of each geometry type, read on.

主站蜘蛛池模板: 萨嘎县| 缙云县| 怀化市| 太仆寺旗| 留坝县| 万宁市| 来宾市| 浦北县| 仁怀市| 梅河口市| 抚松县| 田阳县| 铅山县| 顺平县| 湘乡市| 扬中市| 天等县| 泽库县| 周口市| 英吉沙县| 宁乡县| 黔东| 沾化县| 通州区| 时尚| 金山区| 来凤县| 洪湖市| 磐安县| 宜章县| 自治县| 阿坝| 澳门| 奎屯市| 定陶县| 逊克县| 淳安县| 黑龙江省| 平昌县| 高要市| 东安县|