<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Candara;
panose-1:2 14 5 2 3 3 3 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Candara",sans-serif;
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Candara",sans-serif;
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">I am having an issue importing and visualizing PostGIS raster layers in QGIS. When I import the table I get the geometry but not the images. I will describe my process below.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Candara",sans-serif;color:black">Server Side:<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">I downloaded the Global Human Settlement Raster(</span><a href="http://cidportal.jrc.ec.europa.eu/ftp/jrc-opendata/GHSL/GHS_SMOD_POP_GLOBE_R2016A/GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k/V1-0/">http://cidportal.jrc.ec.europa.eu/ftp/jrc-opendata/GHSL/GHS_SMOD_POP_GLOBE_R2016A/GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k/V1-0/</a>
)<span style="font-family:"Candara",sans-serif;color:black"> from </span><a href="https://ghsl.jrc.ec.europa.eu/datasets.php">https://ghsl.jrc.ec.europa.eu/datasets.php</a> onto my
<span style="font-family:"Candara",sans-serif;color:black">Postgres-10/PostGIS-3 Server.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">These are the files in the download:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif.aux.xml<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif.ovr<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif.vat.cpg<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif.vat.dbf<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">I run gdalinfo:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">$ gdalinfo *.tif<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Driver: GTiff/GeoTIFF<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Files: GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif.ovr<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> GHS_SMOD_POP2015_GLOBE_R2016A_54009_1k_v1_0.tif.aux.xml<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Size is 35497, 15236<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Coordinate System is:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">PROJCS["World_Mollweide",<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> GEOGCS["GCS_WGS_1984",<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> DATUM["D_WGS_1984",<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> SPHEROID["WGS_1984",6378137.0,298.257223563]],<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> PRIMEM["Greenwich",0.0],<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> UNIT["Degree",0.017453292519943295]],<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> PROJECTION["Mollweide"],<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> PARAMETER["False_Easting",0.0],<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> PARAMETER["False_Northing",0.0],<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> PARAMETER["Central_Meridian",0.0],<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> UNIT["Meter",1.0]]<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Origin = (-17619594.547443531453609,8751029.461868489161134)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Pixel Size = (1000.000000000000000,-1000.000000000000000)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Metadata:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> AREA_OR_POINT=Area<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Image Structure Metadata:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> COMPRESSION=LZW<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> INTERLEAVE=BAND<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Corner Coordinates:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Upper Left (-17619594.547, 8751029.462)
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Lower Left (-17619594.547,-6484970.538)
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Upper Right (17877405.453, 8751029.462)
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Lower Right (17877405.453,-6484970.538)
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Center ( 128905.453, 1133029.462) ( 1d17'47.25"E, 9d10'43.07"N)<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">Band 1 Block=512x512 Type=Byte, ColorInterp=Gray<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> Min=0.000 Max=3.000
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> Minimum=0.000, Maximum=3.000, Mean=0.055, StdDev=0.249<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> Overviews: 17749x7618, 8875x3809, 4438x1905, 2219x953, 1110x477<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> Metadata:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> STATISTICS_MAXIMUM=3<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> STATISTICS_MEAN=0.054612442564741<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> STATISTICS_MINIMUM=0<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101"> STATISTICS_STDDEV=0.24926505885785<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">Next I imported the data into the database using the raster2pgsql command:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:Consolas;color:#010101">raster2pgsql -s 54009 -d -I -C -M *0.tif -F -R -t 1000x1000 public.smod | psql -U postgres -d trustmap -v ON_ERROR_STOP=1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">This results in a new smod table in the public schema of my_db with columns for rid, rast, and filename and 576 rows.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Candara",sans-serif;color:black">Host Side:<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">On the host I am running Windows 10 with QGIS 3.6.3<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">I can add a connection to db and see the tables.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">And I can open the DB manager and inspect my table.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">Next I load a Query Table with the DB Manager with:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">select rid, rast::geometry from smod and load it. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">The problem is that it looks like I have It all the shapes right but I cannot see the image!!! Only the polygons that represent the rows in my table.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black">Please help me visualize this. I know the raster is good from a direct import of the raster in QGIS but I want to hold all the data on the server.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Candara",sans-serif;color:#2A2A2A">Please Help. Thanks!<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Candara",sans-serif;color:#2A2A2A"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-family:"Candara",sans-serif;color:#2A2A2A">Constant Marks<br>
</span></b><span style="font-size:10.0pt;font-family:"Candara",sans-serif;color:#2A2A2A">Research Assistant | Computer Science and Engineering</span><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#2A2A2A"><br>
</span><span style="font-size:10.0pt;font-family:"Candara",sans-serif;color:#2A2A2A">University of North Texas</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Candara",sans-serif;color:#8C8C8C">Office: Discovery Parks F216 </span><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#8C8C8C"><br>
</span><span style="font-size:10.0pt;font-family:"Candara",sans-serif;color:#8C8C8C">e:
<a href="mailto:constant.marks@unt.edu"><span style="color:blue">c</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:blue">onstant.marks@unt.edu</span></a><br>
t: (303) <a href="tel:482%207292"><span style="color:blue">482 7292</span></a></span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Candara",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
</body>
</html>