PostGIS Development Blog http://postgis.net/ 2016-08-28T17:10:08+00:00 PieCrust 1.2.0 Nautilytics Case Study 2016-04-05T00:00:00+00:00 2016-04-05T00:00:00+00:00 http://postgis.net/2016/04/05/nautilytics Christopher Lanoue Christopher Lanouehttp://postgis.net <p><a href="http://www.nautilytics.com/">Nautilytics</a> is a small data visualization and GIS startup based out of Boston, MA. We use PostGIS and PostgreSQL, among other open-source tools to build powerful web applications for US government organizations, public, and private sector companies.</p> Continue Reading by clicking title hyperlink .. PostGIS for fast prototyping and Research 2016-04-04T00:00:00+00:00 2016-04-04T00:00:00+00:00 http://postgis.net/2016/04/04/remi_cura Rémi Cura Rémi Curahttp://postgis.net <p>I used extensively postgis (+ecosystem) for my phd thesis, in several ways. The first is that PostGIS is a good steady horse (elephant?): a database is the perfect place to store a lot of very different information in the same place and put them in relation. For geospatial data, postgis means you always have a way to put data in relation (are they at the same place?).</p> Continue Reading by clicking title hyperlink .. Plenario (Univeristy of Chicago) 2016-03-29T00:00:00+00:00 2016-03-29T00:00:00+00:00 http://postgis.net/2016/03/29/plenario_uccd William Engler William Englerhttp://postgis.net <p>The <a href="http://www.urbanccd.org/#urbanccd">Urban Center for Computation and Data (UrbanCCD)</a> is a research initiative of Argonne National Laboratory and the Computation Institute of the University of Chicago. We create computational tools to better understand cities. One of these is <a href="http://plenar.io/">Plenario</a>, our hub for open geospatial data. PostGIS makes the spatial operations at the heart of Plenario possible. </p> Continue Reading by clicking title hyperlink .. PostGIS 2.2.2 Released 2016-03-22T00:00:00+00:00 2016-03-22T00:00:00+00:00 http://postgis.net/2016/03/22/postgis-2.2.2 Paul Ramsey Paul Ramseyhttp://postgis.net <p>The PostGIS development team is happy to release patch for PostGIS 2.2, the 2.2.2 release. As befits a patch release, the focus is on bugs and breakages.</p> <p><strong>Bug Fixes and Improvements</strong></p> <ul> <li><a href="http://trac.osgeo.org/postgis/ticket/3463">#3463</a>, Fix crash on face-collapsing edge change</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3422">#3422</a>, Improve <code>ST_Split</code> robustness on standard precision double systems (arm64, ppc64el, s390c, powerpc, &#8230;)</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3427">#3427</a>, Update <code>spatial_ref_sys</code> to EPSG version 8.8</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3433">#3433</a>, <code>ST_ClusterIntersecting</code> incorrect for MultiPoints</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3435">#3435</a>, <code>ST_AsX3D</code> fix rendering of concave geometries</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3436">#3436</a>, memory handling mistake in ptarray<em>clone</em>deep</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3437">#3437</a>, <code>ST_Intersects</code> incorrect for MultiPoints</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3461">#3461</a>, <code>ST_GeomFromKML</code> crashes Postgres when there are innerBoundaryIs and no outerBoundaryIs</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3429">#3429</a>, upgrading to 2.3 or from 2.1 can cause loop/hang on some platforms</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3460">#3460</a>, <code>ST_ClusterWithin</code> &#8220;Tolerance not defined&#8221; error after upgrade</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3490">#3490</a>, Raster <a href="http://postgis.net/docs/manual-2.2/RT_FAQ.html#faq_raster_data_not_restore">data restore</a> issues, materialized views. Added scripts <code>postgis_proc_set_search_path.sql</code>, <code>rtpostgis_proc_set_search_path.sql</code></li> <li><a href="http://trac.osgeo.org/postgis/ticket/3426">#3426</a>, failing <code>POINT EMPTY</code> tests on fun architectures</li> </ul> <p>See the full list of changes in the <a href="http://svn.osgeo.org/postgis/tags/2.2.2/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.2.tar.gz">postgis-2.2.2.tar.gz</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.2/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.2&amp;order=priority">closed tickets for 2.2.2</a>.</p> Clever Maps 2016-03-17T00:00:00+00:00 2016-03-17T00:00:00+00:00 http://postgis.net/2016/03/17/clever_maps Michal Zimmermann Michal Zimmermannhttp://postgis.net <p>Clever°Maps&#8217; is a three years old startup based in the Czech Republic. We create web apps for four distinct market segments:</p> <ol> <li>business/location inteligence - helping companies to make decisions based on data, not on feelings</li> <li>farming - simplifying agenda and everyday work</li> <li>road infrastructure administration - settlement of land property rights, treaty evidence, speeding up the whole administrative process</li> <li>assets administration - treaty management, land purchases</li> </ol> Continue Reading by clicking title hyperlink .. Vanguard Appraisals 2016-03-17T00:00:00+00:00 2016-03-17T00:00:00+00:00 http://postgis.net/2016/03/17/vanguard_appraisals Andy Colson Andy Colsonhttp://postgis.net <p>Vanguard Appraisals is new to the GIS world. In fact, we aren&#8217;t really in the GIS world; we just kind of brush up against it. We do mass property appraisal for entire county and city jurisdictions, and we develop software to collect, price and maintain values. We also host assessment data online so that homeowners can search and find property information much simpler from the comfort of their own home. Our software and websites are used in 7 states (IA, IL, MN, MO, NE, ND, SD).</p> Continue Reading by clicking title hyperlink .. Selecting only pixels of particular range of values with ST_Reclass 2016-03-13T00:00:00+00:00 2016-03-13T00:00:00+00:00 http://postgis.net/2016/03/13/tip_pixels_of_range_value Regina Obe Regina Obehttp://postgis.net <p>This raster question comes up quite a bit on PostGIS mailing lists and stack overflow and the best answer often involves the often forgotten <a href="/docs/RT_ST_Reclass.html" target="_blank"><code>ST_Reclass</code></a> function that has existed since PostGIS 2.0.<br /> People often resort to the much slower though more flexible <code>ST_MapAlgebra</code> or dumping out their rasters as Pixel valued polygons they then filter with WHERE val > 90, where <code>ST_Reclass</code> does the same thing but orders of magnitude faster.</p> Continue Reading by clicking title hyperlink .. 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><a href="http://trac.osgeo.org/postgis/ticket/2232">#2232</a>, avoid accumulated error in SVG rounding</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3321">#3321</a>, Fix performance regression in topology loading</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3329">#3329</a>, Fix robustness regression in TopoGeo_addPoint</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3349">#3349</a>, Fix installation path of <code>postgis_topology</code> scripts</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3351">#3351</a>, set endnodes isolation on <code>ST_RemoveIsoEdge</code> (and <code>lwt_RemIsoEdge</code>)</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3355">#3355</a>, geography <code>ST_Segmentize</code> has geometry bbox </li> <li><a href="http://trac.osgeo.org/postgis/ticket/3359">#3359</a>, Fix toTopoGeom loss of low-id primitives from TopoGeometry definition</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3360">#3360</a>, <code>_raster_constraint_info_scale</code> invalid input syntax</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3375">#3375</a>, crash in repeated point removal for collection(point)</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3378">#3378</a>, Fix handling of hierarchical TopoGeometries in presence of multiple topologies</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3380">#3380</a>, <a href="http://trac.osgeo.org/postgis/ticket/3402">#3402</a>, Decimate lines on topology load</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3388">#3388</a>, <a href="http://trac.osgeo.org/postgis/ticket/3410">#3410</a>, Fix missing end-points in <code>ST_RemoveRepeatedPoints</code></li> <li><a href="http://trac.osgeo.org/postgis/ticket/3389">#3389</a>, Buffer overflow in <code>lwgeom_to_geojson</code></li> <li><a href="http://trac.osgeo.org/postgis/ticket/3390">#3390</a>, Compilation under Alpine Linux 3.2 gives an error when compiling the postgis and <code>postgis_topology</code> extension</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3393">#3393</a>, ST_Area NaN for some polygons</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3401">#3401</a>, Improve <code>ST_Split</code> robustness on 32bit systems</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3404">#3404</a>, <code>ST_ClusterWithin</code> crashes backend</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3407">#3407</a>, Fix crash on splitting a face or an edge defining multiple TopoGeometry objects</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3411">#3411</a>, Clustering functions not using spatial index</li> <li><a href="http://trac.osgeo.org/postgis/ticket/3412">#3412</a>, Improve robustness of snapping step in <code>TopoGeo_addLinestring</code></li> <li><a href="http://trac.osgeo.org/postgis/ticket/3415">#3415</a>, 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>