[postgis-users] Getting started with PostGIS Raster

Bell, Brennan Phillip b.bell at jacobs-university.de
Fri Nov 24 05:21:45 PST 2017

Just a follow up question -- so, going through the first few examples, where I added the clip, intersect, and union tables to schema_name from the tutorial in your first link, here:


I am unable to view them in QGIS for some reason. So, I see "schema_name" under my PostGIS_Raster database; however, it has no dropdown like "vectors" from the original database recovery. When I look more closely at schema_name, I can see that, as expected, there are 3 rasters named clip, intersect, and union. Now, this exercise clearly states that I should be able to view these in QGIS, so what am I missing/overlooking?



From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of Bell, Brennan Phillip <b.bell at jacobs-university.de>
Sent: Friday, November 24, 2017 2:22:59 AM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Getting started with PostGIS Raster

Thanks a bunch! The first link is great, and pretty much exactly what I've been looking for - an up-to-date, clear set of examples for ingesting data and processing it.

I have already installed PostGIS 2.4 on a Debian 9 VM with postgresql 9.6. I was able to create a database using PGAdmin3 and successfully added the postgis and its topology extensions via psql. My original issue was that I did not have a database -- I guess I was expecting some sample database to be set up automatically, with some examples to get me started, but I only found the Boundless intro to PostGIS, for which I was unable to acquire the prerequisite software -- doesn't matter anymore as you have given me a more recent introduction in any case.

I'll go through the workshop tutorial and ask again here if I have any more questions. Thanks, again, for your help so far!



From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of Regina Obe <lr at pcorp.us>
Sent: Friday, November 24, 2017 2:02:55 AM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Getting started with PostGIS Raster


This workshop that came out recently is a pretty good primer for PostGIS raster:


Do you have postgis installed?  If you do


Will give you postgis raster functionality.

If you don't have it installed already – this page has some binary installers for various OS and links to some instructions - http://postgis.net/install/

Once you have PostGIS installed, and run CREATE EXTENSION postgis;  in your database.


SELECT postgis_full_version();

You should see something like this:  (note latest version is 2.4.2, I'm one micro-behind

POSTGIS="2.4.1 r16012" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.2, released 2017/09/15" LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER

Once you have PostGIS installed, to load raster data in your database, use raster2pgsql – covered here (depending on your OS, the raster2pgsql might be in a separate package from the PostGIS server stuff)


Hope that helps,

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Bell, Brennan Phillip
Sent: Thursday, November 23, 2017 4:43 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Getting started with PostGIS Raster


I am trying to set up the most recent version of PostGIS raster, and I am looking for some help in getting started. I found the wiki links link below helpful, but as I am not a postgresql expert, I have had some trouble getting everything running: http://trac.osgeo.org/postgis/wiki/UsersWikiInstall

Do you have a guide for getting the spatial DB set up, and populating it with some data to help get me started?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171124/40843000/attachment.html>

More information about the postgis-users mailing list