[postgis-users] Getting started with PostGIS Raster

[Bell, Brennan Phillip]

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:


https://github.com/lcalisto/workshop-postgis-raster

<https://github.com/lcalisto/workshop-postgis-raster>
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?


Regards,

Brennan

________________________________
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!


Cheers,

Brennan

________________________________
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

Brennan,

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

https://github.com/lcalisto/workshop-postgis-raster


Do you have postgis installed?  If you do

CREATE EXTENSION postgis;

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.

Do

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)

http://postgis.net/docs/manual-2.4/using_raster_dataman.html#RT_Loading_Rasters


Hope that helps,
Regina
http://postgis.us



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


Greetings,



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?



Thanks,

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