[postgis-users] Getting started with PostGIS Raster

Bell, Brennan Phillip b.bell at jacobs-university.de
Fri Nov 24 14:02:25 PST 2017


I'm using psql to add the rasters -- I did not realize there would be a difference. Is this the incorrect approach? I'll give the DB Manager a try in QGIS. Thanks!


-Brennan

________________________________
From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of Jorge Gustavo Rocha <jgr at di.uminho.pt>
Sent: Friday, November 24, 2017 5:15:46 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] Getting started with PostGIS Raster

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
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171124/3d178be2/attachment.html>


More information about the postgis-users mailing list