Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql-postgis2
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
*: recursive bump for icu 79
databases/postgresql-postgis2: Update to 3.7.0
Packaging changes:
- Accomodate upstream's removal of address standardizer.
- Accomodate upstream's removal of TIGER geocoder.
Upstream NEWS:
PostGIS 3.7.0
2026/10/29
This version requires GEOS 3.10+, PostgreSQL 14-19beta3, Proj 6.1+, and libgmp.
To take advantage of all postgis extension features, GEOS 3.15+ is needed.
To take advantage of all postgis_sfcgal extension features SFCGAL 2.3+ is needed.
Python 3 is a new requirement to build the documentation.
Visual examples in the docs are off by default. To build docs with them,
configure with `--with-visual-examples` and make sure you have a running
PostgreSQL instance; they are then generated automatically when building
the docs (or explicitly with `make -C regress visual-examples`).
* Breaking Changes *
- #5688, [topology] topology building functions now interpret tolerance 0
(old default) to really mean 0 and want -1 (new default) to mean
"use topology precision" (Sandro Santilli)
- #6024, Remove support for PostgreSQL 12 and 13 (Regina Obe)
- #6040, ST_GeoHash round trip through ST_GeomFromGeoHash (Paul Ramsey)
- #6053, [address_standardizer] Extension removed and moved to
https://github.com/postgis/address_standardizer (Paul Ramsey)
- #6052, [tiger_geocoder] Extension removed and moved to
https://git.osgeo.org/postgis/postgis_tiger_geocoder (Regina Obe)
- #6079, Remove support for GEOS < 3.10 (Sandro Santilli)
- #1793, Remove ST_MemCollect aggregate (Darafei Praliaskouski)
- GH-848, CG_AlphaShape now returns a MultiPolygon (Jean Felder)
- [docs] Python 3 and an SVG rasterizer (rsvg-convert preferred,
GraphicsMagick or ImageMagick supported) now required for doc
dynamic image rendering (Darafei Praliaskouski)
* New Features *
- #6132, ST_IsSimpleDetail (Sandro Santilli)
- #1124, #2935, #3033, #4658, #4659, [loader] Rework loader arguments:
shp2pgsql can create UNLOGGED tables and choose the feature id column
name, shp2pgsql --drop-table can emit DROP TABLE before prepare
output, raster2pgsql/shp2pgsql expose loader actions as long options,
both loaders accept long aliases for existing options, and
--if-not-exists makes creation actions idempotent
(Darafei Praliaskouski)
- #4208, Add single-geometry variants of ST_MaxDistance and ST_LongestLine
(Darafei Praliaskouski)
- [topology] FindVertexSegmentPairsBelowDistance function (Sandro Santilli)
- ST_CoverageEdges, returns MultiLinestring of distinct shared edges in
polygonal coverage (Paul Ramsey)
- ST_MinimumSpanningTree, window function to calculate MST (Paul Ramsey)
- #5993, [topology] Add max_edges parameter to TopoGeo_AddLinestring
(Sandro Santilli)
- #6001, support MultiLineString in ST_MakeLine (Paul Ramsey)
- #2858, ST_MMin and ST_MMax (Paul Ramsey)
- #5941, [raster] Support GDT_Float16 pixel type (Darafei Praliaskouski)
- #5992, Optimize GiST index for repeated edge subdivision in topology (Darafei Praliaskouski)
- #5702, Allow the compiler to detect the parallelism -flto=auto (Darafei Praliaskouski)
- #4798, ST_AsGeoJSON warns about duplicate property keys (Darafei Praliaskouski)
- #4222, [raster] ST_DumpAsPolygons honours PostgreSQL interrupts (Darafei Praliaskouski)
- #5889, [topology] Include representative locations in topology build errors (Darafei Praliaskouski)
- #2614, Use GEOSPreparedDistance and caching to accelerate ST_DWithin (Paul Ramsey)
- GH-839, ST_Multi support for TIN and surfaces (Loïc Bartoletti)
- #4398, Add ST_CatmullSmoothing smoothes but retains original vertices (Paul Ramsey)
- #4560, ST_3DInterpolatePoint for M interpolation from XYZ inputs (Paul Ramsey)
- #1291, ST_MakePolygon support for curved rings (Darafei Praliaskouski)
- GT-270, Add NURBSCurve (Loïc Bartoletti)
- #2863, Add ST_XSize, ST_YSize, ST_ZSize, and ST_MSize dimension helpers
(Darafei Praliaskouski)
- GH-870, CG_ApproximateMedialAxis: Add an overload to project the medial
axis to the boundary. (Loïc Bartoletti)
- GH-871, Add CG_PolygonRepair (Loïc Bartoletti)
- GH-872, SFCGAL roof generation algorithms (Loïc Bartoletti)
- GT-806, #6124 --with-visual-examples opt-in
configure switch to build dynamic images (Regina Obe)
databases/postgresql-postgis2: Drop explicit ACCEPTED postgis builds with all versions in the default value of PGSQL_VERSIONS_ACCEPTED. It's generally not difficult about pgsql versions, and likely to continue to work with all pkgsrc versions. Drop the explicit redundant setting as unnecessary, as well as confounding for those adjusting mk/pgsql.mk to only build one version.
*: recursive bump for pcre2 10.49
*: revbump for pcre2 symbol versioning change
*: recursive bump for OpenJPH
*: recursive bump for new protobuf shlib major changed
*: recursive bump for pcre2 10.48
Revision bump after abseil update
*: recursive bump for OpenJPH
*: recursive bump for OpenJPH
*: bump for abseil May 20260526.0 shlib version bump
*: recursive bump for OpenJPH 0.28 The upgrade only bumped the shlib minor but there is no symlink for the major so this version is recorded.
postgis: Drop MAINTAINERship Upstream has suddenly become very LLM. I'll probably still do updates, but I don't want to be viewed as having any responsibility for this.
databases/postgresql-postgis2: Accept pgsql 18
PostgreSQL 18 is ok, per upstream's README.postgis ("and above") (and
if it didn't work I'd be hearing about it on postgis-devel@).
In PR pkg/60316, Jim Spath reports that adding 18 and testing with
qgis was successful (and also that pgsql 14 is still ok, not related
to this commit but good to know).
*: Recursive revbump from security/nettle-4.0
databases/postgresql-postgis2: Update to 3.6.3 Upstream NEWS: micro release
revbump for x265
*: remove 13 from postgresql versions
databases/postgresql-postgis2: Update to 3.6.2 Upstream NEWS: micro release
*: recursive bump for nettle 4.0 shlib major bump
*: recursive bump for abseil-20260107.0 shlib version bump
*: recursive bump for icu 78.1
databases/postgresql-postgis2: Reset PKGREVISION from previous update
databases/postgresql-postgis2: Adjust ordering and whitespace per pkglint. NFCI.
databases/postgresql-postgis2: Update to 3.6.1
PostGIS 3.6.1
2025/11/13
If you are upgrading postgis_topology and have topogeometry columns, make sure to run
after the upgrade to fix topogeometry corruption:
SELECT topology.FixCorruptTopoGeometryColumn(schema_name, table_name, feature_column)
FROM topology.layer;
*: recursive bump for pcre2 Running an old binary against the new pcre doesn't work: /usr/pkg/lib/libpcre2-8.so.0: version PCRE2_10.47 required by /usr/pkg/lib/libglib-2.0.so.0 not defined
*: rev bump for curl
*: recursive bump for openexr 3.4.0
postgis: Reset PKGREVISION after update
postgresql-postgis2: Update to 3.6.0
Upstream NEWS:
PostGIS 3.6.0
2025/09/02
This version requires PostgreSQL 12-18beta3, GEOS 3.8 or higher, and Proj 6.1+.
To take advantage of all features, GEOS 3.14+ is needed.
To take advantage of all SFCGAL features, SFCGAL 2.2+ is needed.
Many thanks to our translation teams, in particular:
Teramoto Ikuhiro (Japanese Team)
Daniel Nylander (Swedish Team)
Dapeng Wang, Zuo Chenwei from HighGo (Chinese Team)
* Breaking Changes *
- #5799, make ST_TileEnvelope clips envelopes to tile plane extent (Paul Ramsey)
- #5829, remove constraint checking from geometry_columns view (Paul Ramsey)
- #3373, GT-255, [topology] Support for upgrading domains (Ayo Adesugba, U.S. Census Bureau)
- GT-252, ST_NumGeometries/ST_GeometryN treat TIN and PolyhedralSurface as unitary geometries,
use ST_NumPatches/ST_PatchN for patch access (Loïc Bartoletti)
- #3110, GT-242 [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
- #5359, #5897, GT-260 [tiger_geocoder] Use @extschema:extension@ for PG >= 16
to schema qualify dependent extensions, switch to use typmod for tiger tables
(Regina Obe)
* Deprecated / Removed signatures *
- #3110, GT-242, [topology] numerous topology functions that accepted integer
replaced with bigint versions to support both integer and bigint inputs
(Ayo Adesugba, U.S. Census Bureau)
- #5498 Drop st_approxquantile(raster, double precision), wasn't usable as it triggered
is not unique error when used (Regina Obe)
* New Features *
- GH-803, [sfcgal] ADD CG_Simplify function (Loïc Bartoletti)
- GH-805, [sfcgal] Add M support for SFCGAL >= 1.5.0 (Loïc Bartoletti)
- GH-801, [sfcgal] ADD CG_3DAlphaWrapping function (Jean Felder)
- #5894, [topology] TotalTopologySize (Sandro Santilli)
- #5890, [topology] ValidateTopologyPrecision, MakeTopologyPrecise (Sandro Santilli)
- #5861, [topology] Add --drop-topology switch to pgtopo_import (Sandro Santilli)
- #1247, [raster] ST_AsRasterAgg (Sandro Santilli)
- #5784, GT-223 Export circ_tree_distance_tree_internal for mobilitydb use
(Maxime Schoemans)
- GT-228, [sfcgal] Add new functions (Scale, Translate, Rotate, Buffer 3D and
Straight Skeleton Partition) from SFCGAL 2 (Loïc Bartoletti)
- [raster] New GUC postgis.gdal_cpl_debug, enables GDAL debugging messages
and routes them into the PostgreSQL logging system. (Paul Ramsey)
- #5841, Change interrupt handling to remove use of pqsignal to support PG 18 (Paul Ramsey)
- Add ST_CoverageClean to edge match and gap remove polygonal
coverages (Paul Ramsey) from GEOS 3.14 (Martin Davis)
- #3110, GT-242 [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
- [raster] Add ST_ReclassExact to quickly remap values in raster (Paul Ramsey)
- #5963, [raster] add ST_IntersectionFractions - Requires GEOS 3.14 (Paul Ramsey)
*: recursive bump for tiff growing lerc dependency
*: recursive bump for abseil 20250814.0
*: recursive bump for imath 3.2.0
*: recursive bump for abseil shlib major change
databases/postgresql-postgis2: Update to 3.5.3 Upstream changes are bugfixes, plus initial support for pgsql 18.
*: gdal-lib has switched to pcre2 adapt buildlink3.mk: depend on pcre2 and bump ABI version recursively bump users
*: recursive bump for jpeg -> libjpeg-turbo switch
*: recursive bump for default Kerberos implementation switch
*: recursive bump for icu 77 and libxml2 2.14
*: Assume that the user has a C99-capable compiler. A compiler that supports -std=c99 is required for bootstrap, so it doesn't make sense to specify a c99 compiler everywhere in package makefiles. At any rate, I would bet my entire life's savings that this is a small fraction of the total number of packages requiring c99. Note that compilers that default to c89 but support c99 are still supported...
*: recursive bump for openh264
*: recursive bump for abseil 20250127.0
databases/postgresql-postgis2: Update to 3.5.2 Upstream NEWS: micro release / bugfixes
revbump after devel/protobuf update
postgresql-postgis2: reset PKGREVISION after update
databases/postgresql-postgis2: Update to 3.5.1
Upstream NEWS, less bugfixes and minor improvements.
PostGIS 3.5.1
2024/12/22
* Bug fixes *
- #5823, Build support for Pg18 (Paul Ramsey)
* Enhancements *
- #5782, Improve robustness of min distance calculation (Sandro Santilli)
- [topology] Speedup topology building when closing large rings with many
holes (Björn Harrtell)
- #5810, [tiger_geocoder] Update tiger geocoder to handle TIGER 2024 data (Regina Obe)
* Breaking Changes *
- #5799, make ST_TileEnvelope clip envelopes to tile plane
extent (Paul Ramsey)
databases/postgresql-postgis2: Alow pg17 The README does not say, but the release announcement for 3.5.0 says "best served with PostgreSQL 17 RC1". While it's ridiculous for a release to recommend using a non-release, it's a clue that 17 should be ok.
*: remove references to pgsql 12
revbump for x265
*: recursive bump for icu 76 shlib major version bump
*: revbump for gdal
*: revbump for icu downgrade
*: recursive bump for icu 76.1 shlib bump
*: recursive bump for openexr shlib major bump
databases/postgresql-postgis2: Update to 3.5.0
* Breaking Changes *
- #5546, TopoGeometry <> TopoGeometry is now ambiguous, to get
the old behaviour, assuming your TopoGeometry objects
are named tg1 and tg2, use: (
id(tg1) <> id(tg2) OR
topology_id(tg1) <> topology_id(tg2) OR
layer_id(tg1) <> layer_id(tg2) OR
type(tg1) <> type(tg2)
) (Sandro Santilli)
- #5536, comments are not anymore included in PostGIS extensions
(Sandro Santilli)
- DocBook5 XSL is now required to build html (Sandro Santilli)
- #5571, Improve ST_GeneratePoints performance, but old
seeded pseudo random points will need to be regenerated.
- #5596, GH-749, Allow promoting column as an id
in ST_AsGeoJson(record,..).
Views and materialized views that use the ST_AsGeoJSON(record ..)
will need rebuilding to upgrade to new signature
(Jan Tojnar)
- #5496, ST_Clip all variants replaced, will require
rebuilding of materialized views that use them (Regina Obe)
- #5659, ST_DFullyWithin behaviour has changed to
be ST_Contains(ST_Buffer(A, R), B) (Paul Ramsey)
- Remove the WFS_locks extra package. (Paul Ramsey)
* Deprecated signatures *
- GH-761, ST_StraightSkeleton => CG_StraightSkeleton (Loïc Bartoletti)
- GT-189, All SFCGAL functions now use the prefix CG_, with the old onesusing
ST_ being deprecated. (Loïc Bartoletti)
* New Features *
- Improvements in the 'postgis' script:
- new command list-enabled
- new command list-all
- command upgrade upgrades all databases that need to be
- command status reports status of all databases
(Sandro Santilli)
- #5742, expose version of PROJ at compile time (Sandro Santilli)
- #5721, postgis_topology: Allow sharing sequences between different topologies (Lars Opsahl)
- #5667, postgis_topology: TopoGeo_LoadGeometry (Sandro Santilli)
- #5055, add explicit <> geometry operator to prevent non-unique
error with <> and != (Paul Ramsey)
- Add ST_HasZ/ST_HasM (Loïc Bartoletti)
- GT-123, postgis_sfcgal: CG_YMonotonePartition, CG_ApproxConvexPartition,
CG_GreeneApproxConvexPartition and CG_OptimalConvexPartition
(Loïc Bartoletti)
- GT-156, postgis_sfcgal: CG_Visibility (Loïc Bartoletti)
- GT-157, postgis_sfcgal: Add ST_ExtrudeStraightSkeleton (Loïc Bartoletti)
- #5496, postgis_raster: ST_Clip support for touched (Regina Obe)
- GH-760, postgis_sfcgal: CG_Intersection, CG_3DIntersects, CG_Intersects,
CG_Difference, CG_Union (and aggregate), CG_Triangulate, CG_Area,
CG_3DDistance, CG_Distance (Loïc Bartoletti)
- #5705, GH-767, ST_RemoveIrrelevantPointsForView (Sam Peters)
- #5706, GH-768, ST_RemoveSmallParts (Sam Peters)
* Enhancements *
- #5531, documentation format upgraded to DocBook 5 (Sandro Santilli)
- #5543, allow building without documentation (Sandro Santilli)
- GH-761, postgis_sfcgal: Add an optional parameter to CG_StraightSkeleton
(was ST_StraightSkeleton) to use m as a distance in result (Hannes Janetzek, Loïc Bartoletti)
*: recursive bump for protobuf 28.2 two static library became shared libraries - bump to be on the safe side
Revbump for x265
geography/postgresql-postgis2: Update to 3.4.3 Packaging changes: Allow pgsql 16. Support for 16 is not new in 3.4.3, but the previous 3.4.x packages incorrectly ommitted it. Upstream changes: bugfixes
*: bump for raqm option in gd & ImageMagick to be on the safe side
revbump after icu and protobuf updates
*: revbump for gdal-lib
*: revbump for proj
*: recursive bump for gnutls p11-kit option (existing installations need the bl3.mk included, but it's now only optionally included)
*: bump for x265 API change Reported by Marc Baudoin
*: recursive bump for protobuf 26.1
databases/postgresql-postgis2: Update to 3.4.2 Upstream NEWS: bugfixes
revbump for devel/abseil
databases/postgresql-postgis2: Update to 3.4.1 upstream NEWS: bugfixes and minor improvements
*: bump for openexr 3.2.1
*: bump for protobuf 25
*: revebump for new brotli option for freetype2 Addresses PR 57693
*: recursive bump for icu 74.1
*: recursive bump for protobuf
*: bump for openssl 3
*: recursive bump for dav1d 1.3
databases/postgresql-postgis2: Update to 3.4.0
Packaging changes:
- Accept pgsql 15.
- No longer accept pgsql 11.
- use gsed as tool (something in the build wanted it)
Selected upstream NEWS:
PostGIS 3.4.0
2023/08/xx
There are 2 new ./configure switches:
- --disable-extension-upgrades-install, will skip installing all the extension upgrade scripts except for the ANY--currentversion. If you use this, you can install select upgrades using the postgis commandline tool
- --without-pgconfig, will build just the commandline tools
raster2pgsql and shp2pgsql even if PostgreSQL is not installed
* New Features *
- #5052, target version support in postgis_extensions_upgrade
(Sandro Santilli)
- New install-extension-upgrades command in postgis script (Sandro Santilli)
- #5006, GH705, ST_Transform: Support PROJ pipelines (Robert Coup, Koordinates)
- #5283, [postgis_topology] RenameTopology (Sandro Santilli)
- #5286, [postgis_topology] RenameTopoGeometryColumn (Sandro Santilli)
- GH703, [postgis_raster] Add min/max resampling as options (Christian Schroeder)
- #5336, [postgis_topology] topogeometry cast to topoelement support (Regina Obe)
- Allow singleton geometry to be inserted into Geometry(Multi*) columns (Paul Ramsey)
- GH721, New window-based ST_ClusterWithinWin and ST_ClusterIntersectingWin (Paul Ramsey)
- #5267, ST_Project signature for geometry, and two-point signature (Paul Ramsey)
- #5267, ST_LineExtend for extending linestrings (Paul Ramsey)
- New coverage functions ST_CoverageInvalidEdges, ST_CoverageSimplify, ST_CoverageUnion (Paul Ramsey)
* Enhancements *
- #5092, reduce number of upgrade paths installed on system,
by providing an ANY intermediary path that all upgrades will
go thru (Sandro Santilli)
* Breaking Changes *
- #5306, GH734, postgis_full_version() and postgis_proj_version()
now output more information about proj network configuration
and data paths. GEOS compile-time version
also shown if different from run-time
(Paul Ramsey, Sandro Santilli)
- #5447, postgis_restore.pl renamed to postgis_restore
(Sandro Santilli)
- Utilities now installed in OS bin or
user specified --bindir and --prefix
instead of postgresql bin
and extension stripped except on windows
(postgis, postgis_restore, shp2pgsql, raster2pgsql, pgsql2shp,
pgtopo_import, pgtopo_export)
postgresql-postgis2: reset PKGREVISION after update
databases/postgresql-postgis2: Update to 3.3.4
Upstream changes are bug fixes and minor enhancements, and:
- #5385, Take out interruptability of ST_AsMVT
as it causes backend crash under intense conditions
(Regina Obe, Paul Ramsey)
Mass-change BUILD_DEPENDS to TOOL_DEPENDS outside mk/. Almost all uses, if not all of them, are wrong, according to the semantics of BUILD_DEPENDS (packages built for target available for use _by_ tools at build-time) and TOOL_DEPEPNDS (packages built for host available for use _as_ tools at build-time). No change to BUILD_DEPENDS as used correctly inside buildlink3. As proposed on tech-pkg: https://mail-index.netbsd.org/tech-pkg/2023/06/03/msg027632.html
*: recursive bump for math/imath shlib version change
databases/postgresql-postgis2: Update to 3.3.3
Packaging changes:
- Clean up bl3, and bump API to 3.0 from 2.0, just because it seems
ridiculous to build against postgis 2 and likely won't work.
- Adjust indentation because pkglint says so, but NFC.
Upstream NEWS: bugfixes
*: recursive bump for imath shared library major version bump
*: recursive bumpf ro math/imath shlib bump
revbump after textproc/icu update
libheif: add dav1d to bl3.mk file pkg-config fails otherwise Bump all dependencies
*: Recursive revbup from graphics/freetype2
*: recursive bump for tiff shlib major bump
geography/proj: recursive revbump
massive revision bump after textproc/icu update
databases/postgresql-postgis2: Update to 3.3.2 This is a micro-update with bugfixes.
*: bump PKGREVISION for libunistring shlib major bump
databases/postgresql-postgis2: Update to 3.3.1 This is a micro release; upstream changes are bugfixes and minor improvements.
databases/postgresql-postgis2: Update to 3.3.0
packaging changes:
- require pgsql >= 11, per upstream
- enable address standardizer module
PostGIS 3.3.0
2022/08/26
This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
Additional features are enabled if you are running GEOS 3.9+
ST_MakeValid enhancements with 3.10+, ST_ConcaveHull and several other enhancements with GEOS 3.11+.
Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
The new --enable-lto flag improves math computations. This new feature is disabled by default
because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)
Use below to enable it.
./configure --enable-lto flag
* New features *
- #5116, Topology export/import scripts (Sandro Santilli)
- ST_Letters creates geometries that look like letters (Paul Ramsey)
- #5037, postgis_sfcgal: ST_3DConvexHull (Loïc Bartoletti)
- postgis_sfcgal: sfcgal_full_version - reports BOOST and CGAL version
(Loïc Bartoletti)
- GH659, MARC21/XML, ST_GeomFromMARC21, ST_AsMARC21 (Jim Jones)
- #5132, GH683, sfcgal: ST_3DUnion aggregate function (Sergei Shoulbakov)
- #5143, SFCGAL ST_AlphaShape and ST_OptimalAlphaShape
Requires SFCGAL 1.4.1+ (Loïc Bartoletti)
- #5162, ST_TriangulatePolygon with GEOS 3.11+ (Paul Ramsey, Martin Davis)
- #5162, ST_SimplifyPolygonHull with GEOS 3.11+ (Paul Ramsey, Martin Davis)
- #5183, topology.RemoveUnusedPrimitives (Sandro Santilli)
* Breaking changes *
- Drop support for PostgreSQL 9.6 and 10 (Regina Obe)
- Change output for WKT MULTIPOINT. All points now
wrapped in parens. (Even Roualt)
- GH674, geometry validation and fixing is disabled
for ST_DumpAsPolygons and ST_Polygon so it works faster
but might produce invalid polygons. (Aliaksandr Kalenik)
* Enhancements *
- #2861, Add index on topology.node(containing_face) speeding up
splitting and merging of faces (Sandro Santilli)
- #2083, Speed up ST_RemEdge topology functions adding index on
relation(element_id) and edge_data(abs_next*) (Sandro Santilli)
- #5118, Allow dropping topologies with missing topogeometry sequences
(Sandro Santilli)
- #5111, faster topology face MBR computation (Sandro Santilli)
- postgis_extensions_upgrade() support for upgrades from any PostGIS
version, including yet to be released ones (Sandro Santilli)
- #5040, add postgis_sfcgal_full_version (Loïc Bartoletti)
- GH655, GiST: balance the tree splits better in recursive calls (Darafei Praliaskouski)
- GH657, GiST: do not call no-op decompress function (Aliaksandr Kalenik)
- #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
- ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
- ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul Ramsey, Martin Davis)
- #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)
- GH676, faster ST_Clip (Aliaksandr Kalenik)
- #5135, Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
- #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
- #5158, pgtopo_import / pgtopo_export manpages (Sandro Santilli)
- #5170, add a optional max_rows_per_copy to -Y option to raster2pgsql to
control number of rows per copy statement.
Default to 50 when not specified (Regina Obe)
- GH698, support parallel aggregate for ST_Union (Sergei Shoulbakov)
- #5024, Update spatial_ref_sys as part of ALTER EXTENSION update postgis (Paul Ramsey)
* Bug Fixe *
*: recursive bump for perl 5.36
revbump for gdal-lib update
*: remove some references to postgresql 9.6
revbump for textproc/icu update
revbump for devel/protobuf
databases/postgresql-postgis2: Update to 3.2.1 upstream changes: bugfixes
*: revbump for gdal-lib update
postgresql-postgis2: Add 14 as acceptable pgsql version
pkgsrc changes:
---------------
* Add 14 to PGSQL_VERSION_ACCEPTABLE to fix a dependency failure of
geography/mapserver with PostgreSQL 14.
* Fix BUILDLINK_ABI_DEPENDS that contained a hardcoded dependency.
* Bump revision.
postgresql-postgis2: Update to 3.2.0
See NEWS in sources for details. A summary of upstream NEWS:
* Enhancements and bugfixes
PostGIS 3.2.0 (Olivier Courtin Edition)
2021/12/17
This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher
, and Proj 4.9+.
Additional features are enabled if you are running GEOS 3.9+
(and ST_MakeValid enhancements with 3.10+),
Proj 6.1+, and PostgreSQL 14+.
Due to some query performance degradation
with the new fast index build that requires PG14,
we have decided to disable the feature by default
until we get more user testing
as to the true impact of real-world queries.
If you are running PG14+, you can reenable it by doing
ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
ADD FUNCTION 11 (geometry)
geometry_gist_sortsupport_2d (internal);
and then reindex your gist indexes.
To revert back to the old index behavior:
ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
DROP FUNCTION 11 (geometry);
and then reindex your gist indexes.
* Breaking changes *
- #5008, Empty geometries are not reported as being within Infinite
distance by ST_DWithin (Sandro Santilli)
- #4824, Removed `--without-wagyu` build option. Using Wagyu is now mandatory to build with MVT support.
- #4933, topology.GetFaceByPoint will not work with topologies having invalid edge linking.
- #4981, ST_StartPoint support any geometry. No longer returns null for non-linestrings.
- #4149, ST_AsMVTGeom now preserves more of original geometry's details at scale close to target extent.
If you need previous simplifying behaviour, you can ST_Simplify the geometry in advance.
(Darafei Praliaskouski)
- Proj 4.9 or higher is required
- #5000, Turn off Window support in ST_AsMVT aggregate
as no real use-case for it and it crashes with random input
(Paul Ramsey)
* New features*
- #4923, topology.ValidateTopologyRelation (Sandro Santilli)
- #4933, topology.GetFaceContainingPoint (Sandro Santilli)
- #2175, ST_Scroll (Sandro Santilli)
- #4841, FindTopology to quickly get a topology record (Sandro Santilli)
- #4869, FindLayer to quickly get a layer record (Sandro Santilli)
- #4851, TopoGeom_addTopoGeom function (Sandro Santilli)
- ST_MakeValid(geometry, options) allows alternative validity building
algorithms with GEOS 3.10 (Paul Ramsey)
- ST_InterpolateRaster() fills in raster cells between sample points
using one of a number of algorithms (inverse weighted distance, average, etc)
using algorithms from GDAL
(Paul Ramsey)
- ST_Contour() generates contour lines from raster values
using algorithms from GDAL (Paul Ramsey)
- ST_SetZ()/ST_SetM() fills in z/m coordinates of a geometry using data read
from a raster (Paul Ramsey)
- New postgis.gdal_vsi_options GUC allows out-db rasters on VSI network
services to be accessed with authentication keys, etc. (Paul Ramsey)
- ST_DumpSegments returns a set of segments of input geometry (Aliaksandr Kalenik)
- #4859, ST_Point, ST_PointZ, ST_PointM, ST_PointZM, constructors
with SRID parameter (Paul Ramsey)
- #4808, ST_ClusterKMeans now supports max_radius argument. Use it when you're not sure what is
the number of clusters but you know what the size of clusters should be. (Darafei Praliaskouski)
postgis: Add coment about running gdb on postgres during tests
revbump for icu and libffi
*: Revbump for protobuf-3.19.0 Fix for: Shared object "libprotobuf.so.29" not found
postgis: Respect LDFLAGS in shp2pgsql build Resolves RELRO check failure. Filed upstream.
*: Revbump for protobuf-3.18.0 Fix for: Shared object "libprotobuf.so.28" not found
Recursive revbump for multimedia/libaom
revbump for boost-libs
databases/postgresql-postgis2: Update to 3.1.4 Upstream changes: bug fixes
*: recursive bump for openexr 3.1
databases/postgresql-postgis2: Update to 3.1.3 Upstream changes: accomodate a breaking change in PostgreSQL 14 betas
databases/postgresql-postgis2: Upgrade to 3.1.2 Upstream changes: bugfixes
*: recursive bump for perl 5.34
revbump for gdal-lib udpate
revbump for boost-libs
revbump for textproc/icu
Revbump for multimedia/x265 update
revbump for gdal-lib update
databases/postgresql-postgis2: revbump for geos update
databases/postgresql-postgis2: Update to 3.1.1 Upstream changes: bugfixes
postgis: Revbump for geos update
postgresql-postgis2: Update to 3.1.0
packaging changes: PostgresQL 9.5 is no longer supported.
Upstream NEWS:
PostGIS 3.1.0
2020/12/18
This version requires PostgreSQL 9.6 or higher and GEOS 3.6 or higher
Additional features are enabled if you are running GEOS 3.9.
* Breaking changes *
- #4737, Bump minimum protobuf-c requirement to 1.1.0 (Raúl Marín)
The configure step will now fail if the requirement isn't
met or explicitly disabled (--without-protobuf)
- #4258, Separated postgis_sfcgal from postgis
into its own lib file and extension (Regina Obe)
- #4577, Drop support for PostgreSQL 9.5 (Raúl Marín)
- #4601, ST_TileEnvelope signature changed.
- #3057, ST_Force3D, ST_Force3DZ, ST_Force3DM and ST_Force4D signatures changed.
* Deprecated signatures *
- Function postgis_svn_version() replaced by postgis_lib_revision()
(Sandro Santilli)
- #4214, Deprecated ST_Count(tablename,...), ST_ApproxCount(tablename, ...)
ST_SummaryStats(tablename, ..),
ST_Histogram(tablename, ...), ST_ApproxHistogram(tablename, ...),
ST_Quantile(tablename, ...), ST_ApproxQuantile(tablename, ...) removed.
(Darafei Praliaskouski)
* New features*
- #4687, (GEOS 3.9+) MaximumInscribedCircle (Paul Ramsey)
- (GEOS 3.9+) Optional gridSize parameter to ST_Union, ST_UnaryUnion,
ST_Difference, ST_Intersection, ST_SymDifference, ST_Subdivide
for overlay with exact tolerance (Sandro Santilli)
- #4624, ST_HexagonGrid and ST_SquareGrid, set returning functions to
generate tilings of the plane (Paul Ramsey)
- #4624, ST_Hexagon and ST_Square, shape generators (Paul Ramsey)
- #4804, (GEOS 3.9+) ST_ReducePrecision allows valid precision reduction
(Paul Ramsey)
- #4710, ST_ClusterKMeans now works with 3D geometries (Darafei Praliaskouski)
- #4801, ST_ClusterKMeans supports weights in POINT[Z]M geometries
(Darafei Praliaskouski)
- #4805, _ST_SortableHash exposed to work around parallel soring performance issue
in Postgres. If your table is huge, use ORDER BY _ST_SortableHash(geom)
instead of ORDER BY geom to make parallel sort faster (Darafei Praliaskouski)
- #4625, Correlation statistics now calculated.
Run ANALYZE for BRIN indexes to start kicking in.
(Darafei Praliaskouski)
- #4698, Add a precision parameter to ST_AsEWKT (Raúl Marín)
* Enhancements *
- #4789, Sped up TopoJSON output for areal TopoGeometry with
many holes (Sandro Santilli)
- #4758, Improved topology noding robustness (Sandro Santilli)
- Make ST_Subdivide interruptable (Sandro Santilli)
- #4660, Changes in double / coordinate printing (Raúl Marín)
- Use the shortest representation (enough to guarantee roundtrip).
- Uses scientific notation for absolute numbers smaller than 1e-8.
The previous behaviour was to output 0 for absolute values smaller than
1e-12 and fixed notation for anything bigger than that.
- Uses scientific notation for absolute numbers greater than 1e+15
(same behaviour).
- The precision parameter now also affects the scientific notation
(before it was fixed [5-8]).
- All output functions now respect the requested precision (without
any limits).
- The default precision is the same (9 for GeoJSON, 15 for everything else).
- #4746, Micro optimizations to the serialization process (Raúl Marín)
- #4623, Optimize varlena returning functions (Raúl Marín)
- #4615, Speed up geojson output (Raúl Marín)
- #4737, Improve performance and reduce memory usage in ST_AsMVT, especially in
queries involving parallelism (Raúl Marín)
- #4719, Fail fast when srids don't match ST_Intersection(geometry,raster)
Also schema qualify calls in function. (Regina Obe)
- #4784, Add ST_CollectionExtract(geometry) with default behaviour of
extracting the components of highest coordinate dimension. (Paul Ramsey)
- #4675, topology.GetRingEdges now implemented in C (Sandro Santilli)
- #4672, Cache getSRSbySRID and getSRIDbySRS for better performance (Raúl Marín)
- #4676, #4657 Avoid decompressing toasted geometries to read only the header
(Raúl Marín)
- #4677, Share gserialized objects between different cache types (Raúl Marín)
- #4601, Add ST_TileEnvelope margin argument (Yuri Astrakhan)
- #2972, Add quiet mode (-q) to pgsql2shp (Kristian Thy)
- #3057, Optional value params for Force3D*, Force4D functions (Kristian Thy)
- #4569, Allow unknown SRID geometry insertion into typmod SRID column (Paul Ramsey)
- #4149, ST_Simplify(geom, 0) is now O(N).
ST_Affine (ST_Translate, ST_TransScale, ST_Rotate) optimized.
ST_SnapToGrid optimized. (Darafei Praliaskouski)
- #4656, Cast a geojson_text::geometry for implicit GeoJSON ingestion (Raúl Marín)
Revbump for openpam cppflags change months ago, belatedly.
postgis: Update to 3.0.3 Packaging changes: make bl3 refer to PGSQL_VERSION, not 12, reverting an earlier change labeled "revbump" which does not make sense for such a change. Upstream changes: bugfixes
*: Recursive revbump from textproc/icu-68.1
postgis: Update to 3.0.2 pkgsrc changes: Adjust API_DEPENDS to 2.0. I don't have a specific reason, but the previous 1.4 is so ancient that accepting it defies the Principle of Least Astonishment. Note that regression tests crash, but in the same way as 3.0.1. 3.0.1, when committed, passed, and I believe this is about proj. Upstream changes: Bug fixes
*: bump PKGREVISION for perl-5.32.
*: revbump after fontconfig bl3 changes (libuuid removal)
database/postgresql-postgis2: Update to 3.0.1
Packaging changes: depend on protobuf-c and json-c
PostGIS 3.0.1
2020/02/20
* Breaking Changes *
- #4637 svn number replaced by git hash in version output
(Sandro Santilli, Regina Obe, Bas Couwenberg)
* New Features *
- #4617, Add configure switch `--without-phony-revision` (Raúl Marín)
Use to prevent postgis_revision.h from rebuilding
(when building from tar ball) and building in a gitted folder.
* Bug Fixes and Enhancements *
[many, see NEWS]
PostGIS 3.0.0
2019/10/20
This version requires PostgreSQL 9.5+-12 and GEOS >= 3.6+
Additional features enabled if you are running Proj6+, PostgreSQL 12
and GEOS 3.8.0
* Breaking Changes *
- #4267, Bump minimum GEOS version to 3.6 (Regina Obe, Darafei Praliaskouski)
- #3888, Raster support now available as a separate extension
(Sandro Santilli)
- #3807, Extension library files no longer include the minor version.
Use New configure switch --with-library-minor-version
if you need the old behavior (Regina Obe)
- #4230, ND box operators (overlaps, contains, within, equals) now
don't look on dimensions that aren't present in both operands.
Please REINDEX your ND indexes after upgrade. (Darafei Praliaskouski)
- #4229, Dropped support for PostgreSQL < 9.5. (Darafei Praliaskouski)
- #4260, liblwgeom headers are not installed anymore.
If your project depends on them available, please use
librttopo instead. (Darafei Praliaskouski)
- #4258, Remove SFCGAL support for ST_Area, ST_Distance, ST_Intersection,
ST_Difference, ST_Union, ST_Intersects, ST_3DIntersects, ST_3DDistance
and postgis.backend switch (Darafei Praliaskouski)
- #4267, Enable Proj 6 deprecated APIs (Darafei Praliaskouski, Raúl Marín)
- #4268, Bump minimum SFCGAL version to 1.3.1 (Darafei Praliaskouski)
- #4331, ST_3DMakeBox now returns error instead of a miniscule box (Regina Obe)
- #4342, Removed "versioned" variants of ST_AsGeoJSON and ST_AsKML (Paul Ramsey)
- #4356, ST_Accum removed. Use array_agg instead. (Darafei Praliaskouski)
- #4414, Include version number in address_standardizer lib (Raúl Marín)
- #4334, Fix upgrade issues related to renamed function parameters (Raúl Marín)
- #4442, raster2pgsql now skips NODATA tiles. Use -k option if you still want
them in database for some reason. (Darafei Praliaskouski)
- #4433, 32-bit hash fix (requires reindexing hash(geometry) indexes) (Raúl Marín)
- #3383, Sorting now uses Hilbert curve and Postgres Abbreviated Compare.
You need to REINDEX your btree indexes if you had them.
(Darafei Praliaskouski)
* New Features *
- #2902, postgis_geos_noop (Sandro Santilli)
- #4128, ST_AsMVT support for Feature ID (Stepan Kuzmin)
- #4230, SP-GiST and GiST support for ND box operators overlaps, contains,
within, equals (Esteban Zimányi and Arthur Lesuisse from Université
Libre de Bruxelles (ULB), Darafei Praliaskouski)
- #4171, ST_3DLineInterpolatePoint (Julien Cabieces, Vincent Mora)
- #4311, Introduce WAGYU to validate MVT polygons. This option requires a C++11
compiler and will use CXXFLAGS (not CFLAGS). Add `--without-wagyu`
to disable this option and keep the behaviour from 2.5 (Raúl Marín)
- #1833, ST_AsGeoJSON(row) generates full GeoJSON Features (Joe Conway)
- #3687, Casts json(geometry) and jsonb(geometry) for implicit GeoJSON
generation (Paul Ramsey)
- #4198, Add ST_ConstrainedDelaunayTriangles SFCGAL function (Darafei
Praliaskouski)
* Enhancements *
- #4322, Support for Proj 6+ API, bringing more accurate datum transforms
and support for WKT projections
[many more; see NEWS]
*: Apply revbump for graphics/giflib API change.
Revbump for icu
revbump after updating security/nettle
databases/postgresql-postgis2: remove no-op SUBST block The mentioned files don't contain any placeholder, and they are not installed either.
databases/postgresql-postgis2: remove outdated PGSQL_VERSIONS_ACCEPTED This should have been PGSQL_VERSIONS_INCOMPATIBLE from the beginning, as the comment above that line clearly said.
revbump after boost update
Revbump for gdal-lib
Recursive revision bump after textproc/icu update
revbump to work around libtool bug triggered by geos update
librsvg: update bl3.mk to remove libcroco in rust case recursive bump for the dependency change
*: recursive bump for libffi
all: migrate homepages from http to https pkglint -r --network --only "migrate" As a side-effect of migrating the homepages, pkglint also fixed a few indentations in unrelated lines. These and the new homepages have been checked manually.
*: Recursive revision bump for openssl 1.1.1.
*: Recursive revbump from devel/boost-libs
Recursive revbump from boost-1.71.0
postgresql-postgis2: Update to 2.5.3 (bug fixes) PostGIS 2.5.3 2019/08/11 * Bug fixes * - #4348, ST_AsMVTGeom (GEOS): Enforce validation at all times (Raúl Marín) - #4361, Fix postgis_type_name with (GEOMETRYM,3) (Matt Bretl) - #4326, Fix circular arc distance calculation (Paul Ramsey) - #4380, Simple TIN support to allow viz in QGIS (Paul Ramsey) - #4388, AddRasterConstraints: Ignore NULLs when generating constraints (Raúl Marín) - #4327, Avoid pfree'ing the result of getenv (Raúl Marín) - #4406, Throw on invalid characters when decoding geohash (Raúl Marín) - #4440, Internal type lookups fail over FDW (Paul Ramsey) - #4445, Fix bug in lwgeom_le (Raúl Marín) - #4466, Fix undefined behaviour in _postgis_gserialized_stats (Raúl Marín) - #4209, Handle NULL geometry values in pgsql2shp (Paul Ramsey) - #4419, Use protobuf version to enable/disable mvt/geobuf (Paul Ramsey) - #4437, Handle POINT EMPTY in shape loader/dumper (Paul Ramsey) - #4461, ST_AsTWKB doesn't always remove duplicate points (Nicklas Avén) - #4459, Fix ST_Subdivide crash on intermediate EMPTY (Darafei Praliaskouski) - #4470, ST_GeomFromGeoJSON crash on empty rings (Darafei Praliaskouski) - #4420, update path does not exists for address_standardizer extension (Regina Obe)
Bump PKGREVISIONs for perl 5.30.0
*: recursive bump for gdk-pixbuf2-2.38.1
*: recursive bump for nettle 3.5.1
Recursive revbump from boost-1.70.0
Recursive bump for ghostscript default change
databases/postgresql-postgis2: Update to 2.5.2
PostGIS 2.5.2
2019/03/11
* Bug fixes *
- #4231, Support for PostgreSQL 12dev (remove use of pg_constraint.consrc)
(Regina Obe, Laurenz Albe)
- #4247, Avoid undefined behaviour in next_float functions (Raúl Marín)
- #4249, Fix undefined behaviour in raster intersection (Raúl Marín)
- #4246, Fix undefined behaviour in ST_3DDistance (Raúl Marín)
- #4244, Avoid unaligned memory access in BOX2D_out (Raúl Marín)
- #4139, Make mixed-dimension ND index build tree correctly.
WARNING: REINDEX your ND index on tables that have records with different M/Z
dimensions for &&& operator to work predictably.
(Darafei Praliaskouski, Arthur Lesuisse, Andrew Gierth, Raúl Marín)
- #4262, Document MULTISURFACE compatibility of ST_LineToCurve (Steven Ottens)
- #4267, Enable Proj 6 deprecated APIs (Darafei Praliaskouski, Raúl Marín)
- #4276, ST_AsGeoJSON documentation refresh (Darafei Praliaskouski)
- #4273, Tighter parsing of WKT (Paul Ramsey)
- #4292, ST_AsMVT: parse JSON numeric values with decimals as doubles (Raúl Marín)
- #4300, ST_AsMVTGeom: Always return the simplest geometry (Raúl Marín)
- #4301, ST_Subdivide: fix endless loop on coordinates near coincident to bounds
(Darafei Praliaskouski)
- #4261, Use AccessShareLock in spatial_index_read_extent (Paul Ramsey)
- #4289, ST_AsMVTGeom: Transform coordinates space before clipping (Raúl Marín)
- #4275, Avoid passing a NULL pointer to GEOSisEmpty (Raúl Marín)
- #4296, Use `server_version_num` instead of parsing `version()` (Raúl Marín)
- #4290, More robust geography distance (Paul Ramsey)
- #4283, Avoid final point duplicates for circle stroking (Paul Ramsey)
- #4314, ST_ClipByBox2D: Do not throw when the geometry is invalid (Raúl Marín)
- #4313, #4307, PostgreSQL 12 compatibility (Laurenz Albe, Raúl Marín)
- #4290, Schema qualify geometry casts in raster functions (Regina Obe)
- #4086, Constraint violation loading tiger_data (zcta5 geometry type) (Regina Obe)
revbump for boost 1.69.0
revbump for geos update (This revbump should not be necessary, because goes's public ABI did not change. Due to a misfeature/bug in libtool, linking against the stable geos C API results in a directed NEEDED entry on the unstable C++ library.)
postgresql-postgis2: update to 2.5.1 upstream NEWS is: bug fixes
Revbump after cairo 1.16.0 update.
Recursive revbump from hardbuzz-2.1.1
postgresql-postgis2: does not support 9.3
postgresql-postgis: Update to 2.5.0
(Upstream also has news for beta and rc, and it's not clear if those
are additional or folded into the following.)
PostGIS 2.5.0
2018/09/23
WARNING: If compiling with PostgreSQL+JIT, LLVM >= 6 is required
Supported PostgreSQL versions for this release are:
PostgreSQL 9.4 - PostgreSQL 12 (in development)
GEOS >= 3.5
* New Features *
- #1847, spgist 2d and 3d support for PG 11+
(Esteban Zimányi and Arthur Lesuisse from Université Libre de Bruxelles (ULB),
Darafei Praliaskouski)
- #4056, ST_FilterByM (Nicklas Avén)
- #4050, ST_ChaikinSmoothing (Nicklas Avén)
- #3989, ST_Buffer single sided option (Stephen Knox)
- #3876, ST_Angle function (Rémi Cura)
- #3564, ST_LineInterpolatePoints (Dan Baston)
- #3896, PostGIS_Extensions_Upgrade() (Regina Obe)
- #3913, Upgrade when creating extension from unpackaged (Sandro Santilli)
- #2256, _postgis_index_extent() for extent from index (Paul Ramsey)
- #3176, Add ST_OrientedEnvelope (Dan Baston)
- #4029, Add ST_QuantizeCoordinates (Dan Baston)
- #4063, Optional false origin point for ST_Scale (Paul Ramsey)
- #4082, Add ST_BandFileSize and ST_BandFileTimestamp,
extend ST_BandMetadata (Even Rouault)
- #2597, Add ST_Grayscale (Bborie Park)
- #4007, Add ST_SetBandPath (Bborie Park)
- #4008, Add ST_SetBandIndex (Bborie Park)
* Breaking Changes *
- #4054, ST_SimplifyVW changed from > tolerance to >= tolerance
- #3885, version number removed from address_standardize lib file
(Regina Obe)
- #3893, raster support functions can only be loaded in the same schema
with core PostGIS functions. (Sandro Santilli)
- #4035, remove dummy pgis_abs type from aggregate/collect routines.
(Paul Ramsey)
- #4069, drop support for GEOS < 3.5 and PostgreSQL < 9.4 (Regina Obe)
- #4082, ST_BandMetaData extended to include filesize, timestamp (Even Rouault)
* Enhancements and Fixes*
- Upgrade scripts from multiple old versions are now all symlinks
to a single upgrade script (Sandro Santilli)
- #3944, Update to EPSG register v9.2 (Even Rouault)
- #3927, Parallel implementation of ST_AsMVT
- #3925, Simplify geometry using map grid cell size before generating MVT
- #3899, BTree sort order is now defined on collections of EMPTY and
same-prefix geometries (Darafei Praliaskouski)
- #3864, Performance improvement for sorting POINT geometries
(Darafei Praliaskouski)
- #3900, GCC warnings fixed, make -j is now working (Darafei Praliaskouski)
- TopoGeo_addLinestring robustness improvements (Sandro Santilli)
#1855, #1946, #3718, #3838
- #3234, Do not accept EMPTY points as topology nodes (Sandro Santilli)
- #1014, Hashable geometry, allowing direct use in CTE signatures (Paul Ramsey)
- #3097, Really allow MULTILINESTRING blades in ST_Split() (Paul Ramsey)
- #3942, geojson: Do not include private header for json-c >= 0.13 (Björn Esser)
- #3954, ST_GeometricMedian now supports point weights (Darafei Praliaskouski)
- #3965, #3971, #3977, #4071 ST_ClusterKMeans rewritten: better initialization,
faster convergence, K=2 even faster (Darafei Praliaskouski)
- #3982, ST_AsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT EMPTY
(Darafei Praliaskouski)
- #3986, ST_AsText now has second argument to limit decimal digits
(Marc Ducobu, Darafei Praliaskouski)
- #4020, Casting from box3d to geometry now returns correctly connected
PolyhedralSurface (Matthias Bay)
- #2508, ST_OffsetCurve now works with collections (Darafei Praliaskouski)
- #4006, ST_GeomFromGeoJSON support for json and jsonb as input
(Paul Ramsey, Regina Obe)
- #4038, ST_Subdivide now selects pivot for geometry split that reuses input
vertices. (Darafei Praliaskouski)
- #4025, #4032 Fixed precision issue in ST_ClosestPointOfApproach,
ST_DistanceCPA, and ST_CPAWithin (Paul Ramsey, Darafei Praliaskouski)
- #4076, Reduce use of GEOS in topology implementation (Björn Harrtell)
- #4080, Add external raster band index to ST_BandMetaData
- Add Raster Tips section to Documentation for information about
Raster behavior (e.g. Out-DB performance, maximum open files)
- #4084: Fixed wrong code-comment regarding front/back of BOX3D (Matthias Bay)
- #4060, #4094, PostgreSQL JIT support (Raúl Marín, Laurenz Albe)
- #3960, ST_Centroid now uses lwgeom_centroid (Darafei Praliaskouski)
- #4027, Remove duplicated code in lwgeom_geos (Darafei Praliaskouski,
Daniel Baston)
- #4115, Fix a bug that created MVTs with incorrect property values under
parallel plans (Raúl Marín).
- #4120, ST_AsMVTGeom: Clip using tile coordinates (Raúl Marín).
- #4132, ST_Intersection on Raster now works without throwing TopologyException
(Vinícius A.B. Schmidt, Darafei Praliaskouski)
- #4177, #4180 Support for PostgreSQL 12 dev branch (Laurenz Albe, Raúl Marín)
- #4156, ST_ChaikinSmoothing: also smooth start/end point of
polygon by default (Darafei Praliaskouski)
postgresql-postgis2: Drop PGSQL_VERSIONS_ACCEPTED Currently, this package builds with all versions of postgreqsl in pkgsrc, and it is likely to do so in the future, so there is no need for an explicit list.
postgresql-postgis2: revbump due to geos/libtool
Recursive bump for perl5-5.28.0
revbump after boost-libs update
postresql-postgis2: Substitute major version in PLIST
Add a variable MAJOR, currently 2.4, and instead of open-coding 2.4 in
PLIST, use ${MAJOR}, and teach print-PLIST how to invert that in only
the right places.
No functional change; this just reduces work on updating.
Update to 2.4.4
PostGIS 2.4.4
2018/04/08
* Bug fixes *
- #3055, [raster] ST_Clip() on a raster without band crashes the server
(Regina Obe)
- #3942, geojson: Do not include private header for json-c >= 0.13
(Björn Esser)
- #3952, ST_Transform fails in parallel mode (Paul Ramsey)
- #3978, Fix KNN when upgrading from 2.1 or older (Sandro Santilli)
- #4003, lwpoly_construct_circle: Avoid division by zero (Raúl Marín Rodríguez)
- #4004, Avoid memory exhaustion when building a btree index (Edmund Horner)
- #4016, proj 5.0.0 support (Raúl Marín Rodríguez)
- #4017, lwgeom lexer memory corruption (Peter E)
- #4020, Casting from box3d to geometry now returns correctly connected
PolyhedralSurface (Matthias Bay)
- #4025, #4032 Incorrect answers for temporally "almost overlapping" ranges
(Paul Ramsey, Darafei Praliaskouski)
- #4052, schema qualify several functions in geography (Regina Obe)
- #4055, ST_ClusterIntersecting drops SRID (Daniel Baston)
* Enhancements *
- #3946, Compile support for PgSQL 11 (Paul Ramsey)
- #3992, Use PKG_PROG_PKG_CONFIG macro from pkg.m4 to detect pkg-config
(Bas Couwenberg)
- #4044, Upgrade support for PgSQL 11 (Regina Obe)
Removed 92 from PGSQL_VERSIONS_ACCEPTED
revbump for boost-libs update
Add p11-kit to gnutls/bl3.mk and bump dependencies.
Recursive bump for new fribidi dependency in pango.
postgresql-postgis2: Update todo list (This does not change any code.)
Recursive bumps for fontconfig and libzip dependency changes.
Update to 2.4.3
* O.k. by gdt@
Changelog:
PostGIS 2.4.3
2018/01/17
* Bug fixes *
- #3713, Support encodings that happen to output a '\' character
- #3827, Set configure default to not do interrupt testing,
was causing false negatives for many people (Regina Obe)
revised to be standards compliant in #3988 (Greg Troxel)
- #3930, Minimum bounding circle issues on 32-bit platforms
- #3965, ST_ClusterKMeans used to lose some clusters on initialization
(Darafei Praliaskouski)
- #3956, Brin opclass object does not upgrade properly (Sandro Santilli)
- #3982, ST_AsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT EMPTY
(Darafei Praliaskouski)
- #3975, ST_Transform runs query on spatial_ref_sys without schema
qualification. Was causing restore issues. (Paul Ramsey)
* Enhancements *
- #3944, Update to EPSG register v9.2 (Even Rouault)
postgresql-postgis2: revbump for proj
Bump PKGREVISION for gdbm shlib major bump
Revbump after boost update
Update to 2.4.2 This is a micro update. Relative to 2.4.0, upstream NEWS has bugfixes and: - #3815, Tiger 2017 data support and option to load zcta5
recursive bump for libxkbcommon removal from at-spi2-core
postgresql-postgis2: Update to 2.4.0
PostGIS 2.4.0
2017/09/30
* New Features *
- #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 / CartoDB)
- #3689, Add orientation checking and forcing functions (Dan Baston)
- #3753, Gist penalty speed improvements for 2D and ND points
(Darafei Praliaskouski, Andrey Borodin)
- #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)
* Enhancements and Fixes*
- Many corrections to docs and several translations almost complete.
Andreas Schild who provided many corrections to core docs.
PostGIS Japanese translation team first to reach completion of translation.
- Support for PostgreSQL 10
- Preliminary support for PostgreSQL 11
- #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
* Breaking Changes *
- 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
- #3578, ST_NumInteriorRings(POLYGON EMPTY) now returns 0 instead of NULL
- _ST_DumpPoints removed, was no longer needed after PostGIS 2.1.0
when ST_DumpPoints got reimplemented in C
- B-Tree index operators < = > changed to provide better spatial locality on sorting
and have expected behavior on GROUP BY.
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
PostGIS 2.4.0rc3
2017/09/27
* Fixes and Enhancements since PostGIS 2.4.0rc2 *
- #3781 st_contains cannot handle curvepolygon / compoundcurve
consisting of only straight lines
- #3866 server crashing from large values in ST_AsTWKB
- #3818 Allow triangles unclosed in M to be WKT parsed
- several packaging changes regarding checking trailing blanks
PostGIS 2.4.0rc2
2017/09/24
* Fixes and Enhancements since PostGIS 2.4.0rc1 *
- Numerous fixes to ST_AsMVT, ST_AsGeoBuf
- ST_AsTWKB speed and memory performance enhancments
- ST_RepeatedPoints speed improvements
- ST_ConcaveHull bug fix
See PostGIS 2.4.0 section for details of
new features and enhancements in this release.
PostGIS 2.4.0rc1
2017/09/13
Note possible breaking changes since 2.4.0 beta1 release are:
* Breaking Changes *
- B-Tree index operators < = > changed to provide better spatial locality on sorting
and have expected behavior on GROUP BY.
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_AsMVT aggregate now overloaded and arg order changed.
Check your code if you are already using this function.
- _ST_DumpPoints removed, was no longer needed after PostGIS 2.1.0
when ST_DumpPoints got reimplemented in C
postgresql-postgis2: Work around an upstream configure bug Upstream has very complicated ifdefs that try to define UNIX everywhere but windows, except that it fails to include NetBSD. Then, it uses UNIX to avoid using the non-standard stricmp and instead use the POSIX-conforming strcasecmp. For pkgsrc, rip out an entire screenful of complexity and just define UNIX if not defined. Resolves build on NetBSD 7, and probably other places.
Update to 2.3.3 Upstream changes: bug fixes
Revbump for boost update
Recursive revbump from boost update
Recursive revbump from graphics/libwebp
Postgis no longer supports PostgreSQL < 9.2.
Support postgresql96.
Revbump after boost update
Update to 2.3.1
Drop build patch incorporated upstream.
Upstream changes:
PostGIS 2.3.1 (2016/11/28)
* Bug fixes
PostGIS 2.3.0 (2016/09/26)
* Important / Breaking Changes
- #3466, Casting from box3d to geometry now returns a 3D
geometry (Julien Rouhaud of Dalibo)
- #3604, pgcommon/Makefile.in orders CFLAGS incorrectly leading to
wrong liblwgeom.h (Greg Troxel)
- #3396, ST_EstimatedExtent, throw WARNING instead of ERROR
(Regina Obe)
* New Features
- Add support for custom TOC in postgis_restore.pl
(Christoph Moench-Tegeder)
- Add support for negative indexing in ST_PointN and ST_SetPoint
(Rémi Cura)
- Add parameters for geography ST_Buffer (Thomas Bonfort)
- TopoGeom_addElement, TopoGeom_remElement (Sandro Santilli)
- populate_topology_layer (Sandro Santilli)
- #454, ST_WrapX and lwgeom_wrapx (Sandro Santilli)
- #1758, ST_Normalize (Sandro Santilli)
- #2236, shp2pgsql -d now emits "DROP TABLE IF EXISTS"
- #2259, ST_VoronoiPolygons and ST_VoronoiLines (Dan Baston)
- #2841 and #2996, ST_MinimumBoundingRadius and new ST_MinimumBoundingCircle
implementation using Welzl's algorithm (Dan Baston)
- #2991, Enable ST_Transform to use PROJ.4 text (Mike Toews)
- #3059, Allow passing per-dimension parameters in ST_Expand (Dan Baston)
- #3339, ST_GeneratePoints (Paul Ramsey)
- #3362, ST_ClusterDBSCAN (Dan Baston)
- #3364, ST_GeometricMedian (Dan Baston)
- #3391, Add table inheritance support in ST_EstimatedExtent
(Alessandro Pasotti)
- #3424, ST_MinimumClearance (Dan Baston)
- #3428, ST_Points (Dan Baston)
- #3465, ST_ClusterKMeans (Paul Ramsey)
- #3469, ST_MakeLine with MULTIPOINTs (Paul Norman)
- #3549, Support PgSQL 9.6 parallel query mode, as far as possible
(Paul Ramsey, Regina Obe)
- #3557, Geometry function costs based on query stats (Paul Norman)
- #3591, Add support for BRIN indexes. PostgreSQL 9.4+ required.
(Giuseppe Broccolo of 2nd Quadrant, Julien Rouhaud
and Ronan Dunklau of Dalibo)
- #3496, Make postgis non-relocateable for extension install,
schema qualify calls in functions (Regina Obe)
Should resolve once and for all for extensions #3494, #3486, #3076
- #3547, Update tiger geocoder to support TIGER 2016
and to support both http and ftp.
- #3613, Segmentize geography using equal length segments
(Hugo Mercier of Oslandia)
* Bug Fixes
* Performance Enhancements
- #75, Enhancement to PIP short circuit (Dan Baston)
- #3383, Avoid deserializing small geometries during index operations
(Dan Baston)
- #3400, Minor optimization of PIP routines (Dan Baston)
- Make adding a line to topology interruptible (Sandro Santilli)
Recursive bump for all users of pgsql now that the default is 95.
Revbump post boost update
Bump PKGREVISION for perl-5.24.0 for everything mentioning perl.
Update to 2.2.2.
PostGIS 2.2.2
2016/03/22
* Bug Fixes *
- #3463, Fix crash on face-collapsing edge change
- #3422, Improve ST_Split robustness on standard precision double
systems (arm64, ppc64el, s390c, powerpc, ...)
- #3427, Update spatial_ref_sys to EPSG version 8.8
- #3433, ST_ClusterIntersecting incorrect for MultiPoints
- #3435, ST_AsX3D fix rendering of concave geometries
- #3436, memory handling mistake in ptarray_clone_deep
- #3437, ST_ClusterIntersecting incorrect for MultiPoints
- #3461, ST_GeomFromKML crashes Postgres when there are
innerBoundaryIs and no outerBoundaryIs
- #3429, upgrading to 2.3 or from 2.1 can cause loop/hang on some
platforms
- #3460, ST_ClusterWithin 'Tolerance not defined' error after upgrade
- #3490, Raster data restore issues, materialized views
Scripts postgis_proc_set_search_path.sql, rtpostgis_proc_set_search_path.sql
refere to http://postgis.net/docs/manual-2.2/RT_FAQ.html#faq_raster_data_not_restore
- #3426, failing POINT EMPTY tests on fun architectures
Enable postgresql-postgis2 for PostgreSQL 9.5
Bump PKGREVISION for security/openssl ABI bump.
Belatedly clear PKGREVISION The previous upgrade should have cleared it; use the 5-minute rule for dropped food.
Update to 2.2.1.
(Passes make check on netbsd-6 i386 with pgsql 9.3.)
PostGIS 2.2.1
2016/01/06
* Bug Fixes *
- #2232, avoid accumulated error in SVG rounding
- #3321, Fix performance regression in topology loading
- #3329, Fix robustness regression in TopoGeo_addPoint
- #3349, Fix installation path of postgis_topology scripts
- #3351, set endnodes isolation on ST_RemoveIsoEdge
(and lwt_RemIsoEdge)
- #3355, geography ST_Segmentize has geometry bbox
- #3359, Fix toTopoGeom loss of low-id primitives from
TopoGeometry definition
- #3360, _raster_constraint_info_scale invalid input syntax
- #3375, crash in repeated point removal for collection(point)
- #3378, Fix handling of hierarchical TopoGeometries
in presence of multiple topologies
- #3380, #3402, Decimate lines on topology load
- #3388, #3410, Fix missing end-points in ST_Removepoints
- #3389, Buffer overflow in lwgeom_to_geojson
- #3390, Compilation under Alpine Linux 3.2
gives an error when compiling the postgis and postgis_topology extension
- #3393, ST_Area NaN for some polygons
- #3401, Improve ST_Split robustness on 32bit systems
- #3404, ST_ClusterWithin crashes backend
- #3407, Fix crash on splitting a face or an edge
defining multiple TopoGeometry objects
- #3411, Clustering functions not using spatial index
- #3412, Improve robustness of snapping step in TopoGeo_addLinestring
- #3415, Fix OSX 10.9 build under pkgsrc
- Fix memory leak in lwt_ChangeEdgeGeom [liblwgeom]
Revbump after updating graphics/libwebp
Update to 2.2.0
Disable address standardizer, which seems to build if some of what it
requires (pcre) happens to be installed, until I figure out if it should
be built and require the dependencies.
Add patches (already reported upstream) to work around upstream using
PERL from pgxs, which is "missing" in pkgsrc, because the
postgresql-client build didn't require perl, and to use @PERL@, found
by postgis configure instead.
Passes tests on NetBSD-6 i386 with postgresql93.
PostGIS 2.2.0
2015/10/07
* Important / Breaking Changes *
- PROJ4 4.6 and higher only
- #2703, KNN <-> operator now returns the correct distance ordering
for all geometry types, not just for points. Code that expects
the looser "centroid distance" ordering should be updated.
- #3022, ValidateTopology swapped meaning of id1 and id2 for the
'edge crosses node' error (now edge_id,node_id)
- #2565, ST_SummaryStats(tablename, rastercolumn, ...) uses
ST_SummaryStatsAgg()
- #2567, ST_Count(tablename, rastercolumn, ...) uses ST_CountAgg()
- #2842, raster - Hide unselectable tables from raster_overview
and raster_columns
- By default, PostGIS raster disables all GDAL drivers affecting
out-db rasters, ST_FromGDALRaster() and ST_AsGDALRaster() variants
- #3181, POINT EMPTY is now stored as POINT(NaN NaN) in WKB, instead of as MULTIPOINT EMPTY
- Java binding moved to separate repository:
https://github.com/postgis/postgis-java
* Deprecated signatures *
- #2748, ST_Shift_Longitude renamed to ST_ShiftLongitude,
ST_Find_Extent renamed to ST_FindExtent,
ST_Combine_BBox renamed to ST_CombineBbox,
ST_Length_Spheroid renamed to ST_LengthSpheroid,
ST_Distance_Spheroid renamed to ST_DistanceSpheroid,
ST_Distance_Sphere renamed to ST_DistanceSphere,
ST_3DLength_Spheroid deprecated (use ST_LengthSpheroid)
- #2769, ST_Mem_Size renamed to ST_MemSize
- #2565, ST_SummaryStats(tablename, rastercolumn, ...)
- #2567, ST_Count(tablename, rastercolumn, ...)
* New Features *
- Topology API in liblwgeom
(Sandro Santilli / Regione Toscana - SITA)
- New lwgeom_version method in liblwgeom
- New lwgeom_unaryunion method in liblwgeom
- New lwgeom_linemerge method in liblwgeom
- New lwgeom_is_simple method in liblwgeom
- #3117, Add SFCGAL 1.1 support: add ST_3DDifference, ST_3DUnion,
ST_Volume, ST_MakeSolid, ST_IsSolid (Vincent Mora / Oslandia)
- #3169, ST_ApproximateMedialAxis (Sandro Santilli)
- ST_CPAWithin (Sandro Santilli / Boundless)
- Add |=| operator with CPA semantic and KNN support with PgSQL 9.5+
(Sandro Santilli / Boundless)
- #3131, KNN support for the geography type (Paul Ramsey / CartoDB)
- #3023, ST_ClusterIntersecting / ST_ClusterWithin (Dan Baston)
- #2703, Exact KNN results for all geometry types, aka "KNN re-check" (Paul Ramsey / CartoDB)
- #1137, Allow a tolerance value in ST_RemoveRepeatedPoints (Paul Ramsey / CartoDB)
- #3062, Allow passing M factor to ST_Scale (Sandro Santilli / Boundless)
- #3139, ST_BoundingDiagonal (Sandro Santilli / Boundless)
- #3129, ST_IsValidTrajectory (Sandro Santilli / Boundless)
- #3128, ST_ClosestPointOfApproach (Sandro Santilli / Boundless)
- #3152, ST_DistanceCPA (Sandro Santilli / Boundless)
- Canonical output for index key types
- ST_SwapOrdinates (Sandro Santilli / Boundless)
- #2918, Use GeographicLib functions for geodetics (Mike Toews)
- #3074, ST_Subdivide to break up large geometry (Paul Ramsey / CartoDB)
- #3040, KNN GiST index based centroid (<<->>)
n-D distance operators (Sandro Santilli / Boundless)
- Interruptibility API for liblwgeom (Sandro Santilli / CartoDB)
- #2939, ST_ClipByBox2D (Sandro Santilli / CartoDB)
- #2247, ST_Retile and ST_CreateOverview: in-db raster overviews creation
(Sandro Santilli / Vizzuality)
- #899, -m shp2pgsql attribute names mapping -m switch
(Regina Obe / Sandro Santilli)
- #1678, Added GUC postgis.gdal_datapath to specify GDAL config
variable GDAL_DATA
- #2843, Support reprojection on raster import
(Sandro Santilli / Vizzuality)
- #2349, Support for encoded_polyline input/output (Kashif Rasul)
- #2159, report libjson version from postgis_full_version()
- #2770, ST_MemSize(raster)
- Add postgis_noop(raster)
- Added missing variants of ST_TPI(), ST_TRI() and ST_Roughness()
- Added GUC postgis.gdal_enabled_drivers to specify GDAL config
variable GDAL_SKIP
- Added GUC postgis.enable_outdb_rasters to enable access to
rasters with out-db bands
- #2387, address_standardizer extension as part of PostGIS
Stephen Woodbridge (imaptools.com), Walter Sinclair, Regina Obe
- #2816, address_standardizer_data_us extension
provides reference lex,gaz,rules for address_standardizer
Stephen Woodbridge (imaptools.com), Walter Sinclair, Regina Obe
- #2341, New mask parameter for ST_MapAlgebra
- #2397, read encoding info automatically in shapefile loader
- #2430, ST_ForceCurve
- #2565, ST_SummaryStatsAgg()
- #2567, ST_CountAgg()
- #2632, ST_AsGML() support for curved features
- #2652, Add --upgrade-path switch to run_test.pl
- #2754, sfcgal wrapped as an extension
- #2227, Simplification with Visvalingam-Whyatt algorithm
ST_SimplifyVW, ST_SetEffectiveArea (Nicklas Avén)
- Functions to encode and decode TWKB
ST_AsTWKB, ST_GeomFromTWKB (Paul Ramsey / Nicklas Avén / CartoDB)
* Enhancements *
- #3223, Add memcmp short-circuit to ST_Equals (Daniel Baston)
- #3227, Tiger geocoder upgraded to support Tiger 2015 census
- #2278, Make liblwgeom compatible between minor releases
- #897, ST_AsX3D support for GeoCoordinates and systems "GD" "WE"
ability to flip x/y axis (use option = 2, 3)
- ST_Split: allow splitting lines by multilines, multipoints
and (multi)polygon boundaries
- #3070, Simplify geometry type constraint
- #2839, Implement selectivity estimator for functional indexes,
speeding up spatial queries on raster tables.
(Sandro Santilli / Vizzuality)
- #2361, Added spatial_index column to raster_columns view
- #2390, Testsuite for pgsql2shp
- #2527, Added -k flag to raster2pgsql to skip checking that
band is NODATA
- #2616, Reduce text casts during topology building and export
- #2717, support startpoint, endpoint, pointn, numpoints for compoundcurve
- #2747, Add support for GDAL 2.0
- #2754, SFCGAL can now be installed with CREATE EXTENSION
Vincent Mora (Oslandia)
- #2828, Convert ST_Envelope(raster) from SQL to C
- #2829, Shortcut ST_Clip(raster) if geometry fully contains the raster
and no NODATA specified
- #2906, Update tiger geocoder to handle tiger 2014 data
- #3048, Speed up geometry simplification (J.Santana @ CartoDB)
- #3092, Slow performance of geometry_columns with many tables
* Bug Fixes *
- #2893, Allow interruptibility of ST_Segmentize(geometry)
(Sandro Santilli / CartoDB)
- #2540, Change GUC name for GDAL_DATA to postgis.gdal_datapath
- #2777, Raster max extent constraint based upon envelope to behave
like geometry extent
- #2822, Use @ operator instead of ST_CoveredBy() for raster
max extent constraint
- #3018, GROUP BY geography sometimes returns duplicate rows
- #3020, ST_AddBand out-db bug where height using width value
- #3048, shp2pgsql - illegal number format when specific system locale set
- #3061, Allow duplicate points in JSON, GML, GML ST_GeomFrom* functions
- #3086, ST_DumpValues() crashes backend on cleanup with invalid
band indexes
Drop EOLed PostgreSQL 8.4 and 9.0 from the supported list of PG versions.
Use BUILD_DEPENDS instead of including buildlink3.mk for docbook-xsl.
Add a TODO about a build issue. When postgis is built as a non-root user, but postgresql was built as root, postgis's use of pgxs.mk leads to install -o root, which fails.
Update to 2.1.8. Upstream changes: - #3159, do not force a bbox cache on ST_Affine - #3018, GROUP BY geography sometimes returns duplicate rows - #3048, shp2pgsql - illegal number format when specific system locale set - #3094, Malformed GeoJSON inputs crash backend - #3104, st_asgml introduces random characters in ID field - #3155, Remove liblwgeom.h on make uninstall - #3177, gserialized_is_empty cannot handle nested empty cases - Fix crash in ST_LineLocatePoint
Recursive PKGREVISION bump for all packages mentioning 'perl', having a PKGNAME of p5-*, or depending such a package, for perl-5.22.0.
Update to 2.1.7. Upstream changes (plus many bug fixes): PostGIS 2.1.7 2015/03/30 PostGIS 2.1.6 2015/03/20 - #3000, Ensure edge splitting and healing algorithms use indexes - #3048, Speed up geometry simplification (J.Santana @ CartoDB) - #3050, Speep up geometry type reading (J.Santana @ CartoDB) PostGIS 2.1.5 2014/12/18 - #2933, Speedup construction of large multi-geometry objects
Build for PostgreSQL 9.4 too.
bl3bump from geography/proj ABI change
Revbump after updating libwebp and icu
Update to 2.1.4. Upstream changes:
Enhancements
#2745, Speedup ST_Simplify calls against points
#2747, Support for GDAL 2.0
#2749, Make rtpostgisupgrade20_21.sql ACID
#2811, Do not specify index names when loading shapefiles/rasters
#2829, Shortcut ST_Clip(raster) if geometry fully contains the raster
and no NODATA specified
#2895, Raise cost of ST_ConvexHull(raster) to 300 for better query plans
[Many bugfixes omitted]
(This is minor update and a leaf package.)
Import postgresql-postgis-2.1.3 as databases/postgresql-postgis2. PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile. PostGIS/PostgreSQL includes the following functionality: * Simple Features as defined by the OpenGIS Consortium (OGC) * Support for Well-Known Text and Well-Known Binary representations of GIS objects * Fast spatial indexing using GiST * Geospatial analysis functions * PostgreSQL JDBC extension objects corresponding to the geometries * Support for OGC access functions as defined by the Simple Features Specification This is postgis 2.x, the currently-maintained and recommended version.