PostGIS
open-menu closeme
Home
Download
Documentation
Development
Sponsor
Support
rss
  • 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
  • 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
  • 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

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