summaryrefslogtreecommitdiff
path: root/databases/postgresql-postgis2
AgeCommit message (Collapse)AuthorFilesLines
2015-12-15Update to 2.2.0gdt6-44/+119
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
2015-11-03Add SHA512 digests for distfiles for databases categoryagc1-1/+2
Problems found with existing distfiles: distfiles/D6.data.ros.gz distfiles/cstore0.2.tar.gz distfiles/data4.tar.gz distfiles/sphinx-2.2.7-release.tar.gz No changes made to the cstore or mariadb55-client distinfo files. Otherwise, existing SHA1 digests verified and found to be the same on the machine holding the existing distfiles (morden). All existing SHA1 digests retained for now as an audit trail.
2015-10-24Drop EOLed PostgreSQL 8.4 and 9.0 from the supported list of PGjoerg2-4/+4
versions.
2015-08-23Use BUILD_DEPENDS instead of including buildlink3.mk for docbook-xsl.wiz1-2/+2
2015-07-07Add a TODO about a build issue.gdt1-1/+4
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.
2015-07-07Fix PLIST for 2.1.8 update.gdt1-1/+8
2015-07-07Update to 2.1.8. Upstream changes:gdt2-7/+6
- #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
2015-06-12Recursive PKGREVISION bump for all packages mentioning 'perl',wiz1-2/+2
having a PKGNAME of p5-*, or depending such a package, for perl-5.22.0.
2015-06-10fix buildlinkwiedi1-3/+3
2015-06-05Update to 2.1.7.gdt3-8/+19
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
2015-03-18Build for PostgreSQL 9.4 too.jperkin2-4/+4
2015-03-14bl3bump from geography/proj ABI changegdt2-3/+4
2014-10-07Revbump after updating libwebp and icuadam1-1/+2
2014-09-15Update to 2.1.4. Upstream changes:gdt3-8/+10
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.)
2014-09-14Import postgresql-postgis-2.1.3 as databases/postgresql-postgis2.gdt5-0/+206
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.