It shouldn't matter.
The only time it matters is when loading rasters if you use out-db with R QGIS can't view outdb rasters. From: postgis-users [mailto:[email protected]] On Behalf Of Bell, Brennan Phillip Sent: Friday, November 24, 2017 5:02 PM To: [email protected] Subject: Re: [postgis-users] Getting started with PostGIS Raster 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 <[email protected] <mailto:[email protected]> > on behalf of Jorge Gustavo Rocha <[email protected] <mailto:[email protected]> > Sent: Friday, November 24, 2017 5:15:46 PM To: [email protected] <mailto:[email protected]> 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 <[email protected] <mailto:[email protected]> > on behalf > of Bell, Brennan Phillip <[email protected] <mailto:[email protected]> > > *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 <[email protected] <mailto:[email protected]> > on behalf > of Regina Obe <[email protected] <mailto:[email protected]> > > *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_Rast ers > > > > > > Hope that helps, > > Regina > > http://postgis.us > > > > > > > > *From:*postgis-users [mailto:[email protected]] *On > Behalf Of *Bell, Brennan Phillip > *Sent:* Thursday, November 23, 2017 4:43 AM > *To:* [email protected] <mailto:[email protected]> > *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 > [email protected] <mailto:[email protected]> > 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 [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
