<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Did you try to change the color of the layer in the QGIS? Try to change from the grayscale to PseudoColor in the properties of the layer.<br>The raster2pgsql works fine but you can also use the QGIS plugin Postgis Raster. <br>Related with the georeference I don't know if you add the parameter -s when you import the layer but if not, that is important since SRID is required to support coordinate transformations inside the database. <br><br>I hope I helped. <br><br>Best Regards,<br>José Santos<br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: isantiago@ogp.pr.gov<br>To: postgis-users@lists.osgeo.org<br>Date: Fri, 1 Mar 2013 13:41:20 +0000<br>Subject: Re: [postgis-users] How can I optimize a raster in postgis 2 for display?<br><br>
<style><!--
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal {
font-size:12.0pt;
font-family:"Times New Roman","serif";
}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink {
color:blue;
text-decoration:underline;
}
.ExternalClass span.ecxMsoHyperlinkFollowed {
color:purple;
text-decoration:underline;
}
.ExternalClass p {
font-size:12.0pt;
font-family:"Times New Roman","serif";
}
.ExternalClass p.ecxMsoAcetate, .ExternalClass li.ecxMsoAcetate, .ExternalClass div.ecxMsoAcetate {
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
}
.ExternalClass span.ecxEmailStyle18 {
font-family:Consolas;
color:windowtext;
font-weight:normal;
font-style:normal;
}
.ExternalClass span.ecxBalloonTextChar {
font-family:"Tahoma","sans-serif";
}
.ExternalClass .ecxMsoChpDefault {
font-size:10.0pt;
}
.ExternalClass div.ecxWordSection1 {
}
--></style>
<div class="ecxWordSection1">
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">thanks for your interest.</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">as Pierre advised I need to be sure the GDAL version is the latest.</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">I do have QGIS 1.8 but many plugins were not updated due to account privileges limitations. (I think)...</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">100mb... mmm... that would be a problem. many of the images i have in sde/sql server are in the order of hundreds of gigabytes.
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">I was testing on smaller ones (geologic maps).</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">One of the rasters metadata:</span></p>
<p style=""><b><span style="font-size:10.0pt;">ab_geol_20k</span></b><span style="font-size:10.0pt;"></span></p>
<p style="">
<b><span style="font-size:10.0pt;">General info</span></b><span style="font-size:10.0pt;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style="">
<span style="font-size:10.0pt;">Relation type: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Table </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Owner: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">postgres </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Pages: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">96 </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Rows (estimation): </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">10578 </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Rows (counted): </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Unknown (<a target="_blank">find out</a>) </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Privileges: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">select, insert, update, delete </span></p>
</td>
</tr>
</tbody>
</table>
<p style="">
<b><span style="font-size:10.0pt;">PostGIS</span></b><span style="font-size:10.0pt;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style="">
<span style="font-size:10.0pt;">Column: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">rast </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Geometry: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">RASTER </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Spatial ref: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;" lang="ES">NAD83 / Puerto Rico & Virgin Is.
</span><span style="font-size:10.0pt;">(32161) </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">Extent: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p style=""><span style="font-size:10.0pt;">(unknown) (<a target="_blank">find out</a>) </span></p>
</td>
</tr>
</tbody>
</table>
<p style="">
<b><span style="font-size:10.0pt;">Fields</span></b><span style="font-size:10.0pt;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;"># </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Name </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Type </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Length </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Null </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Default </span></b><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">1 </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><u><span style="font-size:10.0pt;background:whitesmoke;">rid </span></u><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">int4 </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">4 </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">N </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">nextval('ab_geol_20k_rid_seq'::regclass) </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">2 </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">raster </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;"> </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Y </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;"> </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">3 </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">filename </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">text </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;"> </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Y </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;"> </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
</tbody>
</table>
<p style="">
<b><span style="font-size:10.0pt;">Constraints</span></b><span style="font-size:10.0pt;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Name </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Type </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Column(s) </span></b><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_max_extent_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_out_db_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_nodata_values_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_pixel_types_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_num_bands_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_same_alignment_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_height_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_width_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_scaley_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_scalex_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">enforce_srid_rast </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Check </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rast </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">ab_geol_20k_pkey </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">Primary key </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">rid </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
</tbody>
</table>
<p style="">
<b><span style="font-size:10.0pt;">Indexes</span></b><span style="font-size:10.0pt;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Name </span></b><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p style="text-align:center;" align="center">
<b><span style="font-size:10.0pt;background:#DDDDDD;">Column(s) </span></b><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">ab_geol_20k_rast_gist </span><span style="font-size:10.0pt;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p style=""><span style="font-size:10.0pt;background:whitesmoke;">??? (#0) </span><span style="font-size:10.0pt;"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="ecxMsoNormal" style=""><span style="font-size:11.0pt;font-family:Consolas;">What does this mean?---->
</span><span style="font-size:10.0pt;background:whitesmoke;">??? (#0) </span><span style="font-size:11.0pt;font-family:Consolas;"></span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">Second one:</span></p>
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;"> ab_ele</span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">General info</span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Relation type: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Table </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Owner: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">postgres </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Pages: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">5 </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Rows (estimation): </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">506 </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Rows (counted): </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Unknown (<a target="_blank">find out</a>) </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Privileges: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">select, insert, update, delete </span></p>
</td>
</tr>
</tbody>
</table>
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">PostGIS</span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Column: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Geometry: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">RASTER </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Spatial ref: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;" lang="ES">NAD83 / Puerto Rico & Virgin Is.
</span><span style="font-size:10.0pt;font-family:Consolas;">(32161) </span></p>
</td>
</tr>
<tr>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Extent: </span></p>
</td>
<td style="padding:0in 13.6pt 0in 0in;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">(unknown) (<a target="_blank">find out</a>) </span></p>
</td>
</tr>
</tbody>
</table>
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Fields</span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;"># </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Name </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Type </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Length </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Null </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Default </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">1 </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><u><span style="font-size:10.0pt;font-family:Consolas;">rid </span></u><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">int4 </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">4 </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">N </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">nextval('ambiental_topografia_rasters_mdt.ab_ele_rid_seq'::regclass) </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">2 </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">raster </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;"> </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Y </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;"> </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">3 </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">filename </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">text </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;"> </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Y </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;"> </span></p>
</td>
</tr>
</tbody>
</table>
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Constraints</span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Name </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Type </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Column(s) </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_max_extent_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_out_db_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_pixel_types_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_num_bands_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_same_alignment_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_height_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_width_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_scaley_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_scalex_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">enforce_srid_rast </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Check </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rast </span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">ab_ele_pkey </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">Primary key </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">rid </span></p>
</td>
</tr>
</tbody>
</table>
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Indexes</span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
<table class="ecxMsoNormalTable" style="" border="0" cellpadding="0">
<tbody>
<tr>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Name </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
<td style="background:#DDDDDD;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:Consolas;">Column(s) </span></b><span style="font-size:10.0pt;font-family:Consolas;"></span></p>
</td>
</tr>
<tr>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">ab_ele_rast_gist </span></p>
</td>
<td style="background:whitesmoke;padding:0in 6.8pt 0in 6.8pt;">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:Consolas;">??? (#0) </span></p>
</td>
</tr>
</tbody>
</table>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">When the raster (finally) appears in QGIS canvas, it is not georeferenced even though spatial reference appears in the metadata, as you can see.</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">This is the command I used to load this raster:</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">raster2pgsql
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-I
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;" lang="ES">-C
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;" lang="ES">-e
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;" lang="ES">-Y
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">E:\0_Postgis_Exports\Ambiental_Geologia_Rasters\ab_ele.img (Erdas img, 32mb)</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-F
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-M
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-s 32161 (PR and USVI, NAD83, State Plane Coord Syst)</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-t 128x128 (maybe this could be less than 100x100)</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-l 6 (I do need to read more about this. I let ArcGIS decide that by default. The sde raster indicated “6” levels and I just used that number here.</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;" lang="ES">ambiental_topografia_rasters_mdt.ab_ele |
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">psql
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-d gisogp
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-h 172.16.110.238
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">-p 5432
</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;" lang="ES">-U postgres</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;" lang="ES"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">This raster (a DEM) appears all gray. Looks like it does not have statistics computed, just like happens in sde when statistics are not calculated.</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">I’d like to know more about how overviews work in PGIS Raster and also about if statistics are needed in PGIS Raster.</span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;">Thanks in advance.
</span></p>
<div>
<p class="ecxMsoNormal"><span style="font-size:9.0pt;font-family:Consolas;">---------------------------<br>
Iván Santiago<br>
GIS Specialist<br>
Information Technologies<br>
</span><span style="font-size:9.0pt;font-family:Consolas;" lang="FR"><a href="https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/" target="_blank"><span style="color:windowtext;text-decoration:none;" lang="EN-US">Office
of Management and Budget</span></a></span><span style="font-size:9.0pt;font-family:Consolas;"><br>
787.725.9420 x 2378<br>
Calle Cruz 254<br>
PO Box 9023228<br>
San Juan, PR 00902-3228</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";"></span></p>
</div>
<p class="ecxMsoNormal"><span style="font-size:11.0pt;font-family:Consolas;"> </span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";"> postgis-users-bounces@lists.osgeo.org [mailto:postgis-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>José Pedro Santos<br>
<b>Sent:</b> Friday, March 01, 2013 5:05 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] How can I optimize a raster in postgis 2 for display?</span></p>
</div>
</div>
<p class="ecxMsoNormal"> </p>
<div>
<p class="ecxMsoNormal" style=""><span style="font-family:"Calibri","sans-serif";">Hi Santiago,
<br>
<br>
Which version of QGIS you are using? I have QGIS 1.8 and works fine for displaying rasters (at 100mb) more than that sometimes I have troubles. See the metadata of the files after import to QGIS to check if everything is OK and try to change the appearance
of the files in the properties (color ramp). <br>
<br>
QGIS 1.7 had some problems with the Postgis 2.0<br>
<br>
Best Regards,<br>
Jose Santos<br>
<br>
</span></p>
<div>
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">> From: <a href="mailto:Pierre.Racine@sbf.ulaval.ca">
Pierre.Racine@sbf.ulaval.ca</a><br>
> To: <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> Date: Thu, 28 Feb 2013 11:22:49 -0500<br>
> Subject: Re: [postgis-users] How can I optimize a raster in postgis 2 for display?<br>
> <br>
> The QGIS PostGIS raster plugin use GDAL to read rasters stored in PostGIS. I guess (but this is still not clear to me as I use OpenJump, not QGIS, to display vectorizations of PostGIS rasters), the last development version of the GDAL driver supports overviews.
So:<br>
> <br>
> 1) Find out which version of GDAL your QGIS installation is using (I have no idea how and it depends on your platform).<br>
> <br>
> 2) Make sure to load your rasters with overviews. There is unfortunately no way yet to build overviews for already loaded raster tables. You will have to reload with the right option.<br>
> <br>
> Pierre<br>
> <br>
> > -----Original Message-----<br>
> > From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> [mailto:postgis-users-<br>
> > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a>] On Behalf Of Ivan Santiago<br>
> > Sent: Thursday, February 28, 2013 11:13 AM<br>
> > To: PostGIS Users Discussion<br>
> > Subject: [postgis-users] How can I optimize a raster in postgis 2 for display?<br>
> > <br>
> > Hello all:<br>
> > <br>
> > <br>
> > <br>
> > I ran rtpostgis.sql to enable postgis raster to our gis db.<br>
> > <br>
> > Thanks for the advice, Pierre.<br>
> > <br>
> > <br>
> > <br>
> > Now...<br>
> > <br>
> > Two rasters were added to the new database<br>
> > <br>
> > but I have problems viewing them in QGIS using the available plugin.<br>
> > <br>
> > plugin: Load Postgis Raster to QGIS Ver 0.0.5.4<br>
> > <br>
> > <br>
> > <br>
> > Original size erdas img files: 32mb, and 379mb<br>
> > <br>
> > raster_columns view:<br>
> > <br>
> > <br>
> > <br>
> > <br>
> > <br>
> > "gisogp";"ambiental_geologia_rasters_cuadrangulos";"o_6_ab_geol_20k";"rast<br>
> > ";32161;6;-6;128;128;t;f;3;"{8BUI,8BUI,8BUI}";"{255,255,255}";"{f,f,f}";<br>
> > <br>
> > "gisogp";"ambiental_topografia_rasters_mdt";"o_6_ab_ele";"rast";32161;6;-<br>
> > 6;128;128;t;f;1;"{32BF}";"";"{f}";<br>
> > "gisogp";"ambiental_topografia_rasters_mdt";"ab_ele";"rast";32161;1;-<br>
> > 1;128;128;t;f;1;"{32BF}";"";"{f}";<br>
> > "gisogp";"ambiental_geologia_rasters_cuadrangulos";"ab_geol_20k";"rast";321<br>
> > 61;1;-1;128;128;t;f;3;"{8BUI,8BUI,8BUI}";"{255,255,255}";"{f,f,f}";<br>
> > <br>
> > <br>
> > <br>
> > The main problem with these rasters is the extremely slow performance in QGIS.<br>
> > <br>
> > Maybe the problem lies in QGIS and not in postgis raster.<br>
> > <br>
> > <br>
> > <br>
> > gvSIG does not support postgis 2.0 as far as I know.<br>
> > <br>
> > <br>
> > <br>
> > Then, how can I optimize a raster in postgis 2 for display?<br>
> > <br>
> > <br>
> > <br>
> > OS: CentOS 5<br>
> > <br>
> > PG version: 2.0.2<br>
> > <br>
> > PSQL vers: 9.2<br>
> > <br>
> > ---------------------------<br>
> > <br>
> > Iván Santiago<br>
> > <br>
> > GIS Specialist<br>
> > <br>
> > Information Technologies<br>
> > <br>
> > Office of Management and Budget<br>
> > <br>
> > 787.725.9420 x 2378<br>
> > <br>
> > Calle Cruz 254<br>
> > <br>
> > PO Box 9023228<br>
> > <br>
> > San Juan, PR 00902-3228<br>
> > <br>
> > <br>
> > <br>
> > -----Original Message-----<br>
> > From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> [mailto:postgis-users-<br>
> > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a>] On Behalf Of Pierre Racine<br>
> > Sent: Monday, February 25, 2013 5:51 PM<br>
> > To: PostGIS Users Discussion<br>
> > Subject: Re: [postgis-users] Postgis raster question: how to enable raster type in<br>
> > 2.0<br>
> > <br>
> > <br>
> > <br>
> > rtpostgis.sql if for loading raster definition and function into the database. Not<br>
> > to upgrade.<br>
> > <br>
> > <br>
> > <br>
> > <a href="http://postgis.net/docs/manual-" target="_blank">http://postgis.net/docs/manual-</a><br>
> > dev/postgis_installation.html#create_new_db_extensions<br>
> > <<a href="http://postgis.net/docs/manual-%0b" target="_blank">http://postgis.net/docs/manual-<br>
</a>> > dev/postgis_installation.html#create_new_db_extensions><br>
> > <br>
> > <br>
> > <br>
> > <a href="http://postgis.net/docs/manual-dev/postgis_installation.html#upgrading" target="_blank">
http://postgis.net/docs/manual-dev/postgis_installation.html#upgrading</a><br>
> > <<a href="http://postgis.net/docs/manual-dev/postgis_installation.html#upgrading" target="_blank">http://postgis.net/docs/manual-dev/postgis_installation.html#upgrading</a>><br>
> > <br>
> > <br>
> > <br>
> > Pierre<br>
> > <br>
> > <br>
> > <br>
> > > -----Original Message-----<br>
> > <br>
> > > From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> <<a href="mailto:postgis-users-%0b">mailto:postgis-users-<br>
</a>> > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a>> [mailto:postgis-users-<br>
> > <br>
> > > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a> <<a href="mailto:bounces@lists.osgeo.org">mailto:bounces@lists.osgeo.org</a>> ] On Behalf Of<br>
> > Ivan Santiago<br>
> > <br>
> > > Sent: Monday, February 25, 2013 3:22 PM<br>
> > <br>
> > > To: PostGIS Users Discussion<br>
> > <br>
> > > Subject: Re: [postgis-users] Postgis raster question: how to enable<br>
> > <br>
> > > raster type in<br>
> > <br>
> > > 2.0<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > Turns out it raster support was installed. I made another DB without<br>
> > <br>
> > > enabling postgis extension which includes raster.<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > I hope that solves the problem. Still need to load a raster to see if this worked.<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > Did you load rtpostgis.sql?<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > It looks like rtpostgis.sql is for upgrading postgis. would you<br>
> > <br>
> > > recommend me to run it?<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > we are on version 2.0.2<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > ---------------------------<br>
> > <br>
> > > Iván Santiago<br>
> > <br>
> > > GIS Specialist<br>
> > <br>
> > > Information Technologies<br>
> > <br>
> > > Office of Management and Budget<br>
> > <br>
> > > <<a href="https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.o%0b" target="_blank">https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.o<br>
</a>> > <br>
> > > gp.go bierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/><br>
> > <br>
> > > 787.725.9420 x 2378<br>
> > <br>
> > > Calle Cruz 254<br>
> > <br>
> > > PO Box 9023228<br>
> > <br>
> > > San Juan, PR 00902-3228<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> <<a href="mailto:postgis-users-%0b">mailto:postgis-users-<br>
</a>> > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a>> [mailto:postgis-users-<br>
> > <br>
> > > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a> <<a href="mailto:bounces@lists.osgeo.org">mailto:bounces@lists.osgeo.org</a>> ] On Behalf Of<br>
> > Pierre Racine<br>
> > <br>
> > > Sent: Monday, February 25, 2013 4:06 PM<br>
> > <br>
> > > To: PostGIS Users Discussion<br>
> > <br>
> > > Subject: Re: [postgis-users] Postgis raster question: how to enable<br>
> > <br>
> > > raster type in<br>
> > <br>
> > > 2.0<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > Did you load rtpostgis.sql?<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > Pierre<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> <<a href="mailto:postgis-users-%0b">mailto:postgis-users-<br>
</a>> > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a>> [mailto:postgis-users-<br>
> > <br>
> > > <a href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a> <<a href="mailto:bounces@lists.osgeo.org">mailto:bounces@lists.osgeo.org</a>> ] On Behalf Of<br>
> > Ivan Santiago<br>
> > <br>
> > > Sent: Monday, February 25, 2013 1:42 PM<br>
> > <br>
> > > To: <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <<a href="mailto:postgis-users@lists.osgeo.org">mailto:postgis-users@lists.osgeo.org</a>><br>
> > <br>
> > > Subject: [postgis-users] Postgis raster question: how to enable raster<br>
> > <br>
> > > type in 2.0<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > Hello all:<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > We installed postgresql 9.2 and postgis 2.0 in a CentOS 5 virtual server.<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > after running:<br>
> > <br>
> > ><br>
> > <br>
> > > select postgis_full_version();<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > I get the following:<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > "POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.8.0, 6<br>
> > <br>
> > ><br>
> > <br>
> > > March 2012" LIBXML="2.7.6" LIBJSON="UNKNOWN""<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > Raster does not appear.<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > How can I enable raster data type?<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > > Thanks in advance.<br>
> > <br>
> > ><br>
> > <br>
> > > ---------------------------<br>
> > <br>
> > > Iván Santiago<br>
> > <br>
> > > GIS Specialist<br>
> > <br>
> > > Information Technologies<br>
> > <br>
> > > Office of Management and Budget<br>
> > <br>
> > > <<a href="https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.o%0b" target="_blank">https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.o<br>
</a>> > <br>
> > > gp.go bierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/><br>
> > <br>
> > > 787.725.9420 x 2378<br>
> > <br>
> > > Calle Cruz 254<br>
> > <br>
> > > PO Box 9023228<br>
> > <br>
> > > San Juan, PR 00902-3228<br>
> > <br>
> > ><br>
> > <br>
> > ><br>
> > <br>
> > <br>
> > <br>
> > _______________________________________________<br>
> > <br>
> > postgis-users mailing list<br>
> > <br>
> > <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <<a href="mailto:postgis-users@lists.osgeo.org">mailto:postgis-users@lists.osgeo.org</a>><br>
> > <br>
> > <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
> > <<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a>><br>
> <br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></span></p>
</div>
</div>
</div>
<br>_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</div> </div></body>
</html>