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]> on behalf of Bell, Brennan Phillip <[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]> on behalf of Regina Obe <[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_Rasters 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] 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] https://lists.osgeo.org/mailman/listinfo/postgis-users
