PostGIS
open-menu closeme
Home
Download
Documentation
Development
Sponsor
Support
rss
  • Upgrading postgis_sfcgal to 3.1 or higher

    calendar Aug 25, 2022 tips · 3 min read  Regina Obe · newbie upgrade

    As of PostGIS 3.1, the PostGIS sfcgal support library is no longer part of the postgis core library, but instead spun off into a new library postgis_sfcgal-3.

    This change is not an issue for people doing regular, soft-upgrades from a PostGIS < 3.1 compiled with SFCGAL to a PostGIS >= 3.1 with SFCGAL using ALTER …


    Read More
  • Upgrading raster from 2.* to 3.*

    calendar Jan 14, 2022 tips · 2 min read  Regina Obe · newbie upgrade

    As of PostGIS 3.0, the PostGIS raster support is no longer part of the postgis extension, but instead spun off into a new PostGIS extension called postgis_raster.

    The two main reasons for this break were:

    • Raster functionality in PostGIS is fat with over 150 functions and several types. Wading through these extra …


    Read More
  • Move PostGIS extension to a different schema

    calendar Nov 7, 2017 tips · 2 min read  Regina Obe · newbie upgrade

    As of PostGIS 2.3, the postgis extension was changed to no longer allow relocation. All function calls within the extension are now schema qualified.

    While this change fixed some issues with database restore, it created the issue of if you installed PostGIS in a schema other than the one you wanted to it is not …


    Read More
  • Causes for 'postgis.backend' is already set

    calendar Jun 5, 2017 tips · 3 min read  Regina Obe · newbie upgrade

    The error 'postgis.backend' is already set comes up every so often in PostGIS mailing list. The issue arises often during or after an upgrade. I'll go over causes for this I am aware of and how to fix.

    The question goes something like this

    After upgrading to Postgis 2.3 from 2.1, my server log is filled with these …
    Read More
  • Selecting only pixels of particular range of values with ST_Reclass

    calendar Mar 13, 2016 tips · 2 min read  Regina Obe · newbie raster

    This raster question comes up quite a bit on PostGIS mailing lists and stack overflow and the best answer often involves the often forgotten ST_Reclass function that has existed since PostGIS 2.0. People often resort to the much slower though more flexible ST_MapAlgebra or dumping out their rasters as Pixel valued …


    Read More
  • Why can't I do CREATE EXTENSION postgis_sfcgal

    calendar Oct 25, 2015 tips · 2 min read  Regina Obe · newbie sfcgal 3d

    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 ST_ApproximateMedialAxis became a standard PostgreSQL extension and seems to be a fairly popular extension.

    I've seen several reports on GIS Stack Exchange of people …


    Read More
  • Enabling PostGIS raster drivers and out-of-db raster support

    calendar May 2, 2015 tips · 2 min read  Regina Obe · newbie raster

    I'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:

    I can't use ST_AsPNG when doing something like

    1SELECT ST_AsPNG(rast)
    2    FROM  sometable;
    

    Gives error: Warning: pg_query(): Query failed: ERROR: …


    Read More
  • Getting distinct pixel values and pixel value counts of a raster

    calendar Sep 26, 2014 tips · 2 min read  Regina Obe · newbie raster ST_ValueCount ST_Value

    PostGIS raster has so so many functions and probably at least 10 ways of doing something some much much slower than others. Suppose you have a raster, or you have a raster area of interest -- say elevation raster for example, and you want to know the distinct pixel values in the area. The temptation is to reach for …


    Read More
  • Getting intersections the faster way

    calendar Mar 14, 2014 tips · 2 min read  Regina Obe · newbie geometry ST_Intersects ST_Intersection ST_CoveredBy

    Doing an ST_Intersection is much slower than relation checks such as ST_Intersects , ST_CoveredBy, and , ST_Within . In many situations you know the intersection of 2 geometries without actually computing an intersection. In these cases, you can skip the costly ST_Intersection call. Cases like this:

    1. geometry a is …

    Read More
  • pgAdmin shows no data

    calendar Oct 5, 2013 tips · 2 min read  Regina Obe · newbie geometry geography raster

    Every one or two months, someone asks on the PostGIS users list usually somewhat panicked, My geometry is missing when I look in pgAdmin III

    This is documented in the PostGIS Frequently Asked questions section of the manual I tried to use PgAdmin to view my geometry column and it is blank, what gives?

    Since this …


    Read More
    • ««
    • «
    • 1
    • 2
    • »
    • »»

Recent Posts

  • PostGIS 3.3.2, 3.2.4, 3.1.8, 3.0.8 Patch Releases
  • PostGIS 2.5.9 EOL
  • PostGIS 3.3.1
  • PostGIS 3.3.0 Released

NEWS 199 EVENTS 16 TIPS 13 CASESTUDY 9 RFCS 3

Tags

RELEASE 160 EVENTS 20 2.4 16 3 15 2.1 14 2.3 14 2.5 14 3.1 14 NEWBIE 13 EOL 11 2.2 10 3.2 10 1 9 1.1 8
All Tags
0.11 0.21 0.51 0.63 0.76 0.7.01 0.83 0.93 19 1.04 1.18 1.22 1.36 1.43 1.58 27 2.114 2.210 2.314 2.416 2.514 315 3.01 3.114 3.210 3.38 3D1 ACADEMIC1 AGRICULTURE1 AWARDS1 BIOINFORMATICS1 BRAZIL1 CZ1 DATA-VISUALIZATION1 DECISION-SUPPORT1 DEVELOPERS1 EOL11 EVENTS20 FDW1 FOSS4G5 FRANCE1 GEOCONCEPT1 GEOGRAPHY3 GEOMETRY5 GEOS2 GEOS-2.12 GHANA1 GOVERNMENT1 GSOC1 HANGOUT1 IMAGERY1 NEUROSCIENCE1 NEWBIE13 OGC1 OGR1 ORACLE1 OSDB21 OSGIS1 PGCON2 PGCONEU1 PGOPEN1 PGROUTING1 PGSESSIONS1 PHD1 POSTGISDAY7 POSTGRESVISION2 POWER-USAGE1 PROJ1 PROPERTY-APPRAISAL2 RASTER4 RELEASE160 RESEARCH1 SFCGAL2 SFSQL1 ST_COVEREDBY1 ST_DWITHIN1 ST_FLIPCOORDINATES1 ST_INTERSECTION1 ST_INTERSECTS1 ST_SETSRID1 ST_TRANSFORM1 ST_VALUE1 ST_VALUECOUNT1 TILE-SERVER1 UK1 UNIVERSITY1 UPGRADE4 URBAN-RESEARCH1 US5 WEB-APPS1
[A~Z][0~9]
PostGIS

Copyright  POSTGIS. All Rights Reserved Built with Hugo using Clarity theme

to-top