[postgis-users] Getting started with PostGIS Raster

[Jorge Gustavo Rocha]

Hi Brennan,

Are you using DB Manager to add the rasters?
Try using DB Manager. Go to the schema and then select the table and
then 'Add to canvas' using the context menu.

Regards,

Jorge

On 24-11-2017 13:21, Bell, Brennan Phillip wrote:
> 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
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 

J. Gustavo
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor