PostGIS Development Blog http://postgis.net/ 2016-02-06T13:05:05+00:00 PieCrust 1.2.0 PostGIS 2.2.1 Released 2016-01-06T00:00:00+00:00 2016-01-06T00:00:00+00:00 http://postgis.net/2016/01/06/postgis-2.2.1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is happy to release patch for PostGIS 2.2, the 2.2.1 release. As befits a patch release, the focus is on bugs, breakages, and performance issues. This release includes many fixes for topology, so topology users should give this release special focus.</p> <p><strong>Bug Fixes and Improvements</strong></p> <ul> <li>#2232, avoid accumulated error in SVG rounding</li> <li>#3321, Fix performance regression in topology loading</li> <li>#3329, Fix robustness regression in TopoGeo_addPoint</li> <li>#3349, Fix installation path of <code>postgis_topology</code> scripts</li> <li>#3351, set endnodes isolation on <code>ST_RemoveIsoEdge</code> (and <code>lwt_RemIsoEdge</code>)</li> <li>#3355, geography <code>ST_Segmentize</code> has geometry bbox </li> <li>#3359, Fix toTopoGeom loss of low-id primitives from TopoGeometry definition</li> <li>#3360, <code>_raster_constraint_info_scale</code> invalid input syntax</li> <li>#3375, crash in repeated point removal for collection(point)</li> <li>#3378, Fix handling of hierarchical TopoGeometries in presence of multiple topologies</li> <li>#3380, #3402, Decimate lines on topology load</li> <li>#3388, #3410, Fix missing end-points in <code>ST_RemoveRepeatedPoints</code></li> <li>#3389, Buffer overflow in <code>lwgeom_to_geojson</code></li> <li>#3390, Compilation under Alpine Linux 3.2 gives an error when compiling the postgis and <code>postgis_topology</code> extension</li> <li>#3393, ST_Area NaN for some polygons</li> <li>#3401, Improve <code>ST_Split</code> robustness on 32bit systems</li> <li>#3404, <code>ST_ClusterWithin</code> crashes backend</li> <li>#3407, Fix crash on splitting a face or an edge defining multiple TopoGeometry objects</li> <li>#3411, Clustering functions not using spatial index</li> <li>#3412, Improve robustness of snapping step in <code>TopoGeo_addLinestring</code></li> <li>#3415, Fix OSX 10.9 build under pkgsrc</li> <li>Fix memory leak in <code>lwt_ChangeEdgeGeom</code> [liblwgeom]</li> </ul> <p>See the full list of changes in the <a href="http://svn.osgeo.org/postgis/tags/2.2.1/NEWS">news file</a> and please <a href="https://trac.osgeo.org/postgis">report bugs</a> that you find in the release.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.2.1.tar.gz">postgis-2.2.1.tar.gz</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.1/ChangeLog">ChangeLog</a></li> </ul> <p>Binary packages will appear in <a href="http://postgis.net/install">repositories</a> over the coming weeks as packagers roll out builds.</p> <p>View all <a href="http://trac.osgeo.org/postgis/query?status=closed&amp;groupdesc=1&amp;group=priority&amp;milestone=PostGIS+2.2.1&amp;order=priority">closed tickets for 2.2.1</a>.</p> Why can't I do CREATE EXTENSION postgis_sfcgal 2015-10-25T00:00:00+00:00 2015-10-25T00:00:00+00:00 http://postgis.net/2015/10/25/postgis_sfcgal_extension Regina Obe Regina Obehttp://postgis.net <p>PostGIS 2.2.0 came out this month, and the SFCGAL extension that offers advanced 3D and volumetric support, in addition to some extended 2D functions like <a href="/docs/manual-2.2/ST_ApproximateMedialAxis.html"><code>ST_ApproximateMedialAxis</code></a> became a standard PostgreSQL extension and seems to be a fairly popular extension. </p> <p>I&#8217;ve seen several reports on GIS Stack Exchange of people trying to install PostGIS SFCGAL and getting things such as</p> <p>ERROR: could not open extension control file /Applications/Postgres.app/Contents/Versions/9.5/share/postgresql/extension/postgis_sfcgal.control</p> <p>as in this question: <a href="http://gis.stackexchange.com/questions/167687/sfcgal-in-postgis-problem" target="_blank">SFCGAL in PostGIS problem</a>.</p> <p>There are two main causes for this:</p> Continue Reading by clicking title hyperlink .. 2.2.0 Released! 2015-10-07T00:00:00+00:00 2015-10-07T00:00:00+00:00 http://postgis.net/2015/10/07/postgis-2.2.0 Paul Ramsey Paul Ramseyhttp://postgis.net <p>PostGIS 2.2.0 is released! Over the last two years a number of interesting new features have been added, such as:</p> <ul> <li>True nearest-neighbor searching for all geometry and geography types</li> <li>New volumetric geometry support, including <a href="http://postgis.net/docs/manual-2.2/ST_3DDifference.html">ST&#95;3DDifference</a>, <a href="http://postgis.net/docs/manual-2.2/ST_3DUnion.html">ST&#95;3DUnion</a> and more</li> <li>Temporal data model support and functions like <a href="http://postgis.net/docs/manual-2.2/ST_ClosestPointOfApproach.html">ST&#95;ClosestPointOfApproach</a> to support temporal query</li> <li>Spatial clustering functions <a href="http://postgis.net/docs/manual-2.2/ST_ClusterIntersecting.html">ST&#95;ClusterIntersecting</a> and <a href="http://postgis.net/docs/manual-2.2/ST_ClusterWithin.html">ST&#95;ClusterWithin</a></li> <li>Subdividing large geometries with <a href="http://postgis.net/docs/manual-2.2/ST_Subdivide.html">ST&#95;Subdivide</a></li> <li>Fast box clipping with <a href="http://postgis.net/docs/manual-2.2/ST_ClipByBox2D.html">ST&#95;ClipByBox2D</a></li> <li>In-database raster processing with <a href="http://postgis.net/docs/manual-2.2/RT_Retile.html">ST&#95;Retile</a> and <a href="http://postgis.net/docs/manual-2.2/RT_CreateOverview.html">ST&#95;CreateOverview.html</a></li> <li>New high-speed native code address standardizer</li> <li>Visvalingam-Whyatt geometry simplification with <a href="http://postgis.net/docs/manual-2.2/ST_SimplifyVW.html">ST&#95;SimplifyVW</a></li> <li>Support for compressed &#8220;tiny well-known binary&#8221; format with <a href="http://postgis.net/docs/manual-2.2/ST_AsTWKB.html">ST&#95;AsTWKB</a> and <a href="http://postgis.net/docs/manual-2.2/ST_GeomFromTWKB.html">ST&#95;GeomFromTWKB</a></li> </ul> <p>See the full list of changes in the <a href="http://svn.osgeo.org/postgis/tags/2.2.0/NEWS">news file</a> and please <a href="https://trac.osgeo.org/postgis">report bugs</a> that you find in the release.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.2.0.tar.gz">postgis-2.2.0.tar.gz</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.0/ChangeLog">ChangeLog</a></li> </ul> <p>Binary packages will appear in <a href="http://postgis.net/install">repositories</a> over the coming weeks as packagers roll out builds.</p> <p>View all <a href="http://trac.osgeo.org/postgis/query?status=closed&amp;groupdesc=1&amp;group=priority&amp;milestone=PostGIS+2.2.0&amp;order=priority">closed tickets for 2.2.0</a>.</p> 2.2.0rc1 Available 2015-09-24T00:00:00+00:00 2015-09-24T00:00:00+00:00 http://postgis.net/2015/09/24/postgis-2.2.0rc1 Paul Ramsey Paul Ramseyhttp://postgis.net <p>This is it, PostGIS 2.2 is almost out the door, so we&#8217;re looking for testing and feedback! Please give the release candidate a try and report back any issues you encounter. </p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.2.0rc1.tar.gz">Download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.0rc1/ChangeLog">Changelog</a></li> </ul> <p>View all <a href="http://trac.osgeo.org/postgis/query?status=closed&amp;groupdesc=1&amp;group=priority&amp;milestone=PostGIS+2.2.0&amp;order=priority">closed tickets for 2.2.0</a>.</p> 2.1.8 Released 2015-07-07T00:00:00+00:00 2015-07-07T00:00:00+00:00 http://postgis.net/2015/07/07/postgis-2.1.8 Paul Ramsey Paul Ramseyhttp://postgis.net <p>Due to a number of bugs capable of crashing a back-end, we have released 2.1.8. If you are running an earlier version on a public site, we recommend that you update as soon as possible.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.1.8.tar.gz">Download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.1.8/ChangeLog">Changelog</a></li> </ul> <p>View all <a href="http://trac.osgeo.org/postgis/query?status=closed&amp;groupdesc=1&amp;group=priority&amp;milestone=PostGIS+2.1.8&amp;order=priority">closed tickets for 2.1.8</a>.</p> Enabling PostGIS raster drivers and out-of-db raster support 2015-05-02T00:00:00+00:00 2015-05-02T00:00:00+00:00 http://postgis.net/2015/05/02/tip_enable_raster_drivers Regina Obe Regina Obehttp://postgis.net <p>I&#8217;ve been asked this question in some shape or form at least 3 times, mostly from people puzzled why they get this error. The last iteration went something like this:</p> <p><em>I can&#8217;t use <code>ST_AsPNG</code> when doing something like</em></p> <pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">SELECT</span> ST_AsPNG<span style="color: #66cc66;">&#40;</span>rast<span style="color: #66cc66;">&#41;</span> <span style="color: #993333; font-weight: bold;">FROM</span> sometable;</pre> <p>Gives error: Warning: pg_query(): Query failed: ERROR: rt&#95;raster&#95;to&#95;gdal: Could not load the output GDAL driver.</p> Continue Reading by clicking title hyperlink .. PostGIS 2.0.7 and 2.1.7 Released 2015-04-06T00:00:00+00:00 2015-04-06T00:00:00+00:00 http://postgis.net/2015/04/06/postgis-2.1.7 Paul Ramsey Paul Ramseyhttp://postgis.net <p>Due to a critical bug in GeoJSON ingestion we have made an early release of versions 2.0.7 and 2.1.7. If you are running an earlier version on a public site and accepting incoming GeoJSON, we recommend that you update as soon as possible.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.1.7.tar.gz">Download 2.1.7</a></li> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.0.7.tar.gz">Download 2.0.7</a></li> </ul> <p>View all <a href="http://trac.osgeo.org/postgis/query?status=closed&amp;groupdesc=1&amp;group=priority&amp;milestone=PostGIS+2.0.7&amp;order=priority">closed tickets for 2.0.7</a>.</p> PostGIS 2.1.6 Released 2015-03-20T00:00:00+00:00 2015-03-20T00:00:00+00:00 http://postgis.net/2015/03/20/postgis-2.1.6 Paul Ramsey Paul Ramseyhttp://postgis.net <p>The 2.1.6 release of PostGIS is <a href="http://download.osgeo.org/postgis/source/postgis-2.1.6.tar.gz">now available</a>.</p> <p>The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.6 release. As befits a patch release, the focus is on bugs, breakages, and performance issues. Users with large tables of points will want to priorize this patch, for substantial (~50%) disk space savings.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.1.6.tar.gz">Download 2.1.6</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.1.6/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. Foreign Data Wrappers for PostGIS 2014-12-19T00:00:00+00:00 2014-12-19T00:00:00+00:00 http://postgis.net/2014/12/19/postgis_fdw Paul Ramsey Paul Ramseyhttp://postgis.net <p>The last couple weeks have seen two interesting updates in the world of PostgreSQL &#8220;<a href="https://wiki.postgresql.org/wiki/Foreign_data_wrappers">foreign data wrappers</a>&#8221; (FDW). Foreign data wrappers allow you to access remote data inside your database, exactly like other tables. PostgreSQL ships with two example implementations, one for accessing text files, and the other for accessing remote PostgreSQL servers.</p> <p>The two updates of interest to PostGIS users are:</p> <ul> <li>The <a href="http://laurenz.github.io/oracle_fdw/">Oracle FDW</a> implementation was recently enhanced to support spatial columns, so an Oracle table with SDO_GEOMETRY columns can be exposed in PostgreSQL as a table with PostGIS geometry columns.</li> <li>A new <a href="https://github.com/pramsey/pgsql-ogr-fdw">OGR FDW</a> implementation <a href="http://boundlessgeo.com/2014/12/ogr-fdw-ftw/">was released</a> that supports exposing any OGR data source as a table with PostGIS geometry columns.</li> </ul> <p>Now you can access your PostGIS data without even going to the trouble of importing it first!</p> PostGIS 2.1.5 Released 2014-12-18T00:00:00+00:00 2014-12-18T00:00:00+00:00 http://postgis.net/2014/12/18/postgis-2.1.5 Paul Ramsey Paul Ramseyhttp://postgis.net <p>The 2.1.5 release of PostGIS is <a href="http://download.osgeo.org/postgis/source/postgis-2.1.5.tar.gz">now available</a>.</p> <p>The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.5 release. As befits a patch release, the focus is on bugs, breakages, and performance issues</p> <p><a href="http://download.osgeo.org/postgis/source/postgis-2.1.5.tar.gz">http://download.osgeo.org/postgis/source/postgis-2.1.5.tar.gz</a></p> Continue Reading by clicking title hyperlink ..