你好,游客 登录
背景:
阅读新闻

PostGIS 2.4.0 发布,PG 的空间数据存储扩展

[日期:2017-10-09] 来源:开源中国   作者: [字体: ]

  PostGIS 2.4.0 已发布,PostGIS 在对象关系型数据库PostgreSQL上增加了存储管理空间数据的能力,相当于 Oracle 的 spatial 部分。PostGIS 最大的特点是符合并且实现了 OpenGIS 的一些规范,是最著名的开源GIS数据库。

  新特性

  3822, Have postgis full version() also show and check version of PostgreSQL the scripts were built against (Sandro Santilli)

  2411, curves support in ST_Reverse (Sandro Santilli)

  2951, ST_Centroid for geography (Danny Götte)

  3788, Allow postgis_restore.pl to work on directory-style (-Fd) dumps (Roger Crew)

  3772, Direction agnostic ST_CurveToLine output (Sandro Santilli / KKGeo)

  2464, ST_CurveToLine with MaxError tolerance (Sandro Santilli / KKGeo)

  3599, Geobuf output support via ST_AsGeobuf (Björn Harrtell)

  3661, Mapbox vector tile output support via ST_AsMVT (Björn Harrtell / Carto)

  3689, Add orientation checking and forcing functions (Dan Baston)

  3753, Gist penalty speed improvements for 2d and nd points (Darafei Praliaskouski)

  3677, ST_FrechetDistance (Shinichi Sugiyama)

  Most aggregates (raster and geometry), and all stable / immutable (raster and geometry) marked as parallel safe

  2249, ST_MakeEmptyCoverage for raster (David Zwarg, ainomieli)

  3709, Allow signed distance for ST_Project (Darafei Praliaskouski)

  524, Covers support for Polygon-on-polygon, line on line, point on line for geography (Danny Götte)

  改进

  Support for PostgreSQL 10

  3645, Avoid loading logically deleted records from shapefiles

  3747, Add zip4 and address alphanumeric as attributes to norm addy tiger_geocoder type.

  3748, address standardizer lookup tables update so pagc normalize_address better standardizes abbreviations

  3647, better handling of noding in ST_Node using GEOSNode (Wouter Geraedts)

  3684, Update to EPSG register v9 (Even Rouault)

  3830, Fix initialization of incompatible type (>=9.6) address_standardizer

  3662, Make shp2pgsql work in debug mode by sending debug to stderr

  3405, Fixed memory leak in lwgeom to points

  3832, Support wide integer fields as int8 in shp2pgsql

  3841, Deterministic sorting support for empty geometries in btree geography

  3844, Make = operator a strict equality test, and < > to rough “spatial sorting”

  3855, ST_AsTWKB memory and speed improvements

  重要改变

  Dropped support for PostgreSQL 9.2.

  3810, GEOS 3.4.0 or above minimum required to compile

  Most aggregates now marked as parallel safe, which means most aggs have to be dropped / recreated. If you have views that utilize PostGIS aggs, you’ll need to drop before upgrade and recreate after upgrade

  B-Tree index operators < = > changed to provide better spatial locality on sorting and have expected behavior on GROUP BY. It now works on exact geometry instead of bounding box. If you have btree index for geometry or geography, you need to REINDEX it, or review if it was created by accident and needs to be replaced with GiST index. If your code relies on old left-to-right box compare ordering, update it to use << >> operators.

  _ST_DumpPoints removed, was no longer needed after PostGIS 2.1.0 when ST_DumpPoints got reimplemented in C

收藏 推荐 打印 | 录入:Cstor | 阅读:
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数
点评:
       
评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款
热门评论