<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<meta content="text/html; charset=UTF-8">
<style type="text/css" style="">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<p>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!<br>
</p>
<p><br>
</p>
<p>-Brennan</p>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Jorge Gustavo Rocha <jgr@di.uminho.pt><br>
<b>Sent:</b> Friday, November 24, 2017 5:15:46 PM<br>
<b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [postgis-users] Getting started with PostGIS Raster</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">Hi Brennan,<br>
<br>
Are you using DB Manager to add the rasters?<br>
Try using DB Manager. Go to the schema and then select the table and<br>
then 'Add to canvas' using the context menu.<br>
<br>
Regards,<br>
<br>
Jorge<br>
<br>
On 24-11-2017 13:21, Bell, Brennan Phillip wrote:<br>
> Just a follow up question -- so, going through the first few examples,<br>
> where I added the clip, intersect, and union tables to schema_name from<br>
> the tutorial in your first link, here:<br>
> <br>
> <br>
> <a href="https://github.com/lcalisto/workshop-postgis-raster">https://github.com/lcalisto/workshop-postgis-raster</a><br>
> <br>
> <<a href="https://github.com/lcalisto/workshop-postgis-raster">https://github.com/lcalisto/workshop-postgis-raster</a>><br>
> I am unable to view them in QGIS for some reason. So, I see<br>
> "schema_name" under my PostGIS_Raster database; however, it has no<br>
> dropdown like "vectors" from the original database recovery. When I look<br>
> more closely at schema_name, I can see that, as expected, there are 3<br>
> rasters named clip, intersect, and union. Now, this exercise clearly<br>
> states that I should be able to view these in QGIS, so what am I<br>
> missing/overlooking?<br>
> <br>
> <br>
> Regards,<br>
> <br>
> Brennan<br>
> <br>
> ------------------------------------------------------------------------<br>
> *From:* postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf<br>
> of Bell, Brennan Phillip <b.bell@jacobs-university.de><br>
> *Sent:* Friday, November 24, 2017 2:22:59 AM<br>
> *To:* 'PostGIS Users Discussion'<br>
> *Subject:* Re: [postgis-users] Getting started with PostGIS Raster<br>
> <br>
> <br>
> Thanks a bunch! The first link is great, and pretty much exactly what<br>
> I've been looking for - an up-to-date, clear set of examples for<br>
> ingesting data and processing it.<br>
> <br>
> I have already installed PostGIS 2.4 on a Debian 9 VM with postgresql<br>
> 9.6. I was able to create a database using PGAdmin3 and successfully<br>
> added the postgis and its topology extensions via psql. My original<br>
> issue was that I did not have a database -- I guess I was expecting some<br>
> sample database to be set up automatically, with some examples to get me<br>
> started, but I only found the Boundless intro to PostGIS, for which I<br>
> was unable to acquire the prerequisite software -- doesn't matter<br>
> anymore as you have given me a more recent introduction in any case.<br>
> <br>
> I'll go through the workshop tutorial and ask again here if I have any<br>
> more questions. Thanks, again, for your help so far!<br>
> <br>
> <br>
> Cheers,<br>
> <br>
> Brennan<br>
> <br>
> ------------------------------------------------------------------------<br>
> *From:* postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf<br>
> of Regina Obe <lr@pcorp.us><br>
> *Sent:* Friday, November 24, 2017 2:02:55 AM<br>
> *To:* 'PostGIS Users Discussion'<br>
> *Subject:* Re: [postgis-users] Getting started with PostGIS Raster<br>
> <br>
> <br>
> Brennan,<br>
> <br>
> <br>
> <br>
> This workshop that came out recently is a pretty good primer for PostGIS<br>
> raster:<br>
> <br>
> <br>
> <br>
> <a href="https://github.com/lcalisto/workshop-postgis-raster">https://github.com/lcalisto/workshop-postgis-raster</a><br>
> <br>
> <br>
> <br>
> <br>
> <br>
> Do you have postgis installed? If you do<br>
> <br>
> <br>
> <br>
> CREATE EXTENSION postgis;<br>
> <br>
> <br>
> <br>
> Will give you postgis raster functionality.<br>
> <br>
> <br>
> <br>
> If you don't have it installed already – this page has some binary<br>
> installers for various OS and links to some instructions -<br>
> <a href="http://postgis.net/install/">http://postgis.net/install/</a><br>
> <br>
> <br>
> <br>
> <br>
> <br>
> Once you have PostGIS installed, and run CREATE EXTENSION postgis; in<br>
> your database.<br>
> <br>
> <br>
> <br>
> Do<br>
> <br>
> <br>
> <br>
> SELECT postgis_full_version();<br>
> <br>
> <br>
> <br>
> You should see something like this: (note latest version is 2.4.2, I'm<br>
> one micro-behind<br>
> <br>
> <br>
> <br>
> POSTGIS="2.4.1 r16012" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d"<br>
> PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.2, released 2017/09/15"<br>
> LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER<br>
> <br>
> <br>
> <br>
> <br>
> <br>
> Once you have PostGIS installed, to load raster data in your database,<br>
> use raster2pgsql – covered here (depending on your OS, the raster2pgsql<br>
> might be in a separate package from the PostGIS server stuff)<br>
> <br>
> <br>
> <br>
> <a href="http://postgis.net/docs/manual-2.4/using_raster_dataman.html#RT_Loading_Rasters">
http://postgis.net/docs/manual-2.4/using_raster_dataman.html#RT_Loading_Rasters</a><br>
> <br>
> <br>
> <br>
> <br>
> <br>
> Hope that helps,<br>
> <br>
> Regina<br>
> <br>
> <a href="http://postgis.us">http://postgis.us</a><br>
> <br>
> <br>
> <br>
> <br>
> <br>
> <br>
> <br>
> *From:*postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] *On<br>
> Behalf Of *Bell, Brennan Phillip<br>
> *Sent:* Thursday, November 23, 2017 4:43 AM<br>
> *To:* postgis-users@lists.osgeo.org<br>
> *Subject:* [postgis-users] Getting started with PostGIS Raster<br>
> <br>
> <br>
> <br>
> Greetings,<br>
> <br>
> <br>
> <br>
> I am trying to set up the most recent version of PostGIS raster, and I<br>
> am looking for some help in getting started. I found the wiki links link<br>
> below helpful, but as I am not a postgresql expert, I have had some<br>
> trouble getting everything<br>
> running: <a href="http://trac.osgeo.org/postgis/wiki/UsersWikiInstall">http://trac.osgeo.org/postgis/wiki/UsersWikiInstall</a> <br>
> <br>
> <br>
> <br>
> Do you have a guide for getting the spatial DB set up, and populating it<br>
> with some data to help get me started?<br>
> <br>
> <br>
> <br>
> Thanks,<br>
> <br>
> Brennan<br>
> <br>
> <br>
> <br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> postgis-users@lists.osgeo.org<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
> <br>
<br>
J. Gustavo<br>
-- <br>
Jorge Gustavo Rocha<br>
Departamento de Informática<br>
Universidade do Minho<br>
4710-057 Braga<br>
Tel: +351 253604480<br>
Fax: +351 253604471<br>
Móvel: +351 910333888<br>
skype: nabocudnosor<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@lists.osgeo.org<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</span></font>
</body>
</html>