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

栏目: 软件资讯 · 发布时间: 8年前

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

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

新特性

  • 3822, Have postgisfullversion() 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 addressalphanumeric as attributes to normaddy tiger_geocoder type.

  • 3748, addressstandardizer lookup tables update so pagcnormalize_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 lwgeomtopoints

  • 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

下载地址:

http://download.osgeo.org/postgis/source/postgis-2.4.0.tar.gz


【声明】文章转载自:开源中国社区 [http://www.oschina.net]


以上所述就是小编给大家介绍的《PostGIS 2.4.0 发布,PG 的空间数据存储扩展》,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对 码农网 的支持!

查看所有标签

猜你喜欢:

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

算法之美

算法之美

左飞 / 电子工业出版社 / 2016-3 / 79.00元

《算法之美——隐匿在数据结构背后的原理(C++版)》围绕算法与数据结构这个话题,循序渐进、深入浅出地介绍了现代计算机技术中常用的40 余个经典算法,以及回溯法、分治法、贪婪法和动态规划等算法设计思想。在此过程中,《算法之美——隐匿在数据结构背后的原理(C++版)》也系统地讲解了链表(包括单向链表、单向循环链表和双向循环链表)、栈、队列(包括普通队列和优先级队列)、树(包括二叉树、哈夫曼树、堆、红黑......一起来看看 《算法之美》 这本书的介绍吧!

图片转BASE64编码
图片转BASE64编码

在线图片转Base64编码工具

SHA 加密
SHA 加密

SHA 加密工具

HSV CMYK 转换工具
HSV CMYK 转换工具

HSV CMYK互换工具