<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Is there a potential issue with how gdal expects to see the
raster and in particular the metadata it gets from raster_columns?
I've some trouble with GDAL and partitioning that I need to work
through at some point - but that for the moment I'm effectvely
materializing a view ov my underlying tables to subsequently
generate the statistics and constraints that GDAL want to see. <br>
</p>
<br>
<div class="moz-cite-prefix">On 02/05/2017 21:24, Regina Obe wrote:<br>
</div>
<blockquote cite="mid:007801d2c382$1b664e20$5232ea60$@pcorp.us"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<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:Tahoma;
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:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Disregard
what I said. I see that the SQL statements I thought
mistakenly were coming from DbManager are generated by GDAL
(looking at the GDAL postgis raster code).<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">So
the change would need to be done in GDAL driver. I think
having a PostGIS function GDAL can count on calling that
would always return the materialized raster tile would
simplify things though.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">So
I'm thinking strongly of implementing that in PostGIS 2.4.
I think all other calls that GDAL is doing to for example
get meta data and overviews would be the same for out-db as
it is for in-db.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Even,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Any
input you have on the matter would be very welcomed. I
guess this would need to wait for GDAL 2.2 or 2.3 and verify
said helper function exists (or version of PostGIS) before
it can be used.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Regina<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:.5in"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
Regina Obe [<a class="moz-txt-link-freetext" href="mailto:lr@pcorp.us">mailto:lr@pcorp.us</a>] <br>
<b>Sent:</b> Tuesday, May 02, 2017 4:04 PM<br>
<b>To:</b> 'PostGIS Users Discussion'
<a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@lists.osgeo.org"><postgis-users@lists.osgeo.org></a><br>
<b>Cc:</b> 'PostGIS Development Discussion'
<a class="moz-txt-link-rfc2396E" href="mailto:postgis-devel@lists.osgeo.org"><postgis-devel@lists.osgeo.org></a><br>
<b>Subject:</b> RE: [postgis-users] raster2pgsql:
out_db=false with -R flag (And Showing out_db rasters in
QGIS)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Just
to add the bug regarding raster2pgsql will be fixed in
upcoming 2.3.3<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">And
the work-around is to use –Y with –s as detailed in the
ticket.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a
moz-do-not-send="true"
href="https://trac.osgeo.org/postgis/ticket/3738">https://trac.osgeo.org/postgis/ticket/3738</a><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Regarding
the QGIS issue with GDAL not supporting out-db. I've been
thinking that the easier fix might be to make the change in
QGIS DbManager instead of PostGIS.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The
ultimate problem is that PostGIS is feeding an out-db raster
instead of the raster bytes. QGIS just makes queries to the
PostGIS database and uses GDAL to consume the raw bytes.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">If
QGIS dbmanager were to instead of doing SELECT rast … did
something like SELECT ST_Materialize(rast) AS rast …. FROM
somerast table …<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Where
yet to be implemented PostGIS function ST_Materialize or
whatever we decide to call it does nothing with in-db, but
returns the raster bytes of out-db, then QGIS DbManager can
treat out-db like any in-db raster.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I'm
thinking this would be a faster fix than mucking with
PostGIS GDAL driver and in the end might help simplify the
PostGIS GDAL driver handling of out-db since it can use the
same function.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">strk,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I
think you are familiar with the internal workings of QGIS
Db Manager. You think this proposed option is feasible and
less taxing or we'd still need to do something on the GDAL
end to make this work?<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Regina<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
postgis-users [<a moz-do-not-send="true"
href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Tumasgiu Rossini<br>
<b>Sent:</b> Tuesday, May 02, 2017 8:26 AM<br>
<b>To:</b> PostGIS Users Discussion <<a
moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: [postgis-users] raster2pgsql:
out_db=false with -R flag (And Showing out_db rasters in
QGIS)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">I think
that raster2pgsql is indeed a mature tool, but it is the
out-db feature of postgis<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:1.0in">which is
maybe not widely used, and so the bugs takes more time to
appear because<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:1.0in">of the fewer
users.<o:p></o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:1.0in">2017-05-02
12:18 GMT+02:00 <<a moz-do-not-send="true"
href="mailto:Michael.Haertel@t-systems.com"
target="_blank">Michael.Haertel@t-systems.com</a>>:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0in 0in 0in
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hello
Tumasgiu Rossini,</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">thank
you very much for your fast and
comprehensive response. I was not aware of
that bug yet but found so many references
to raster2pgsql that I just assumed that
it was a mature tool already. </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">(And
noted that I gave wrong parameter in the
subject line of my mail, should have been
R and not F).</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Good
luck with your programming efforts. I
guess it’s somewhat complex since you have
to deal with the real pixel data. </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Regards,</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Michael</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span
lang="DE"><o:p></o:p></span></p>
<div style="border:none;border-top:solid
#B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><b><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif">Von:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif">
postgis-users [mailto:<a
moz-do-not-send="true"
href="mailto:postgis-users-bounces@lists.osgeo.org"
target="_blank">postgis-users-bounces@lists.osgeo.org</a>]
<b>Im Auftrag von </b>Tuma</span><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif"
lang="DE">sgiu Rossini<br>
<b>Gesendet:</b> Dienstag, 2. Mai 2017
12:08<br>
<b>An:</b> PostGIS Users Discussion<br>
<b>Betreff:</b> Re: [postgis-users]
raster2pgsql: out_db=false with -F flag
(And Showing out_db rasters in QGIS)</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE"> <o:p></o:p></span></p>
<div>
<div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:1.0in"><span
lang="DE">Hi,<o:p></o:p></span></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">To answer your first
question : <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">the combination of the -s
and -R options actually transforms
out-db raster into in-db,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:1.0in"><span
lang="DE">it is a recent known bug,
see <a moz-do-not-send="true"
href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042003.html"
target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042003.html</a>
<br>
for more information.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">For the latter question,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">Qgis uses gdal to fetch
raster data from postgis and the
out-db support is not implemented.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">You can though maybe use
workarounds, more info here :<br>
<a moz-do-not-send="true"
href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042077.html"
target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042077.html</a><br>
<a moz-do-not-send="true"
href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042053.html"
target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042053.html</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">Using out-db rasters and
Qgis at my company, I am facing myself
this problem and<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">I am trying to implement
out-db support in gdal, though I am no
gdal developer<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">and it is not a high
priority feature.<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE"> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE">2017-05-02 11:37 GMT+02:00
<<a moz-do-not-send="true"
href="mailto:Michael.Haertel@t-systems.com"
target="_blank">Michael.Haertel@t-systems.com</a>>:<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Dear users,</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">I hope that somebody can
tell me if I found a bug or simply
don’t use the command correctly.</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Given:</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:10.0pt;font-family:Symbol" lang="DE">·</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">A directory with four
GeoTIFF files </span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:10.0pt;font-family:Symbol" lang="DE">·</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">PostgreSQL 9.6.1, compiled
by Visual C++ build 1800, 64-bit</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:10.0pt;font-family:Symbol" lang="DE">·</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">POSTGIS="2.3.1 r15264"
GEOS="3.6.0-CAPI-1.10.0 r4265"
SFCGAL="1.3.0" PROJ="Rel. 4.9.1, 04
March 2015" GDAL="GDAL 2.1.1,
released 2016/07/07" LIBXML="2.7.8"
LIBJSON="0.12" RASTER</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:10.0pt;font-family:Symbol" lang="DE">·</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">OS is Windows 7</span><span
lang="DE"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">I try to import the Tiff
files as OUT_DB raster files using
this command:</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Courier New"" lang="DE">1.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Courier
New"" lang="DE">raster2pgsql.exe
-s 25832 -I -R -n myFilename -C -M
-F C:\_GEODATA_\*.tif raster2x2 >
t:\DTK10.sql<br>
<br>
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Output:</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">a.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Processing 1/4:
C:\_GEODATA_\24_dtk10_32356_5608_2_nw_col.tif</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">b.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Processing 2/4:
C:\_GEODATA_\25_dtk10_32356_5610_2_nw_col.tif</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">c.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Processing 3/4:
C:\_GEODATA_\34_dtk10_32358_5608_2_nw_col.tif</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">d.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Processing 4/4:
C:\_GEODATA_\35_dtk10_32358_5610_2_nw_col.tif</span><span
lang="DE"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Courier New"" lang="DE">2.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Courier
New"" lang="DE">psql.exe
--host=localhost --port=5432
--username=xxx --dbname=xxx -f
t:\DTK10.sql</span><span lang="DE"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"><br>
Output:</span><span lang="DE"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">a.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">BEGIN</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">b.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">CREATE TABLE</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">c.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">INSERT 0 1</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">d.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">INSERT 0 1</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">e.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">INSERT 0 1</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">f.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">INSERT 0 1</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">g.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">CREATE INDEX</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">h.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">ANALYZE</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">i.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding SRID constraint</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">j.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding scale-X constraint</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">k.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding scale-Y constraint</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">l.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding blocksize-X
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">m.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding blocksize-Y
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">n.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding alignment
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">o.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding number of bands
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">p.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding pixel type
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">q.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding nodata value
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">r.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding out-of-database
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">s.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">psql:t:/DTK10.sql:9:
HINWEIS: Adding maximum extent
constraint</span><span lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">t.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">addrasterconstraints</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">u.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">----------------------</span><span
lang="DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">v.</span><span
style="font-size:7.0pt" lang="DE">
</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">t</span><span lang="DE"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Problem is that the view
“raster_columns” always shows
FALSE for out_db, even though I
used the F flag:</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<table class="MsoNormalTable"
style="width:408.0pt;margin-left:1.0in"
border="0" cellpadding="0" width="544">
<tbody>
<tr>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"r_table_catalog"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"r_table_schema"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"r_table_name"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"r_raster_column"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"srid"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"scale_x"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"scale_y"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"blocksize_x"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"blocksize_y"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"same_alignment"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"regular_blocking"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"num_bands"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"pixel_types"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"nodata_values"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"out_db"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"extent"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"spatial_index"<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"gismobile"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"public"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"raster2x2
"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"rast"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">25832<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0.5<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">-0.5<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">4000<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">4000<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">true<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">false<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">1<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">{8BUI}<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">{NULL}<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">{f}<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0103000020E864000001000000050000000000000080BA154100000000906455410000000080BA154100000000786855410000000000F9154100000000786855410000000000F9154100000000906455410000000080BA15410000000090645541<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">true<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<table class="MsoNormalTable"
style="width:1.0in;margin-left:1.0in"
border="0" cellpadding="0" width="96">
<tbody>
<tr>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"rid"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"rast"<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"filename"<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">1<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0100000100000000000000E03F000000000000E0BF0000000080BA1541000000008466554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C32345F64746B31305F33323335365F353630385F325F6E775F636F6C2E74696600<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"24_dtk10_32356_5608_2_nw_col.tif"<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">2<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0100000100000000000000E03F000000000000E0BF0000000080BA1541000000007868554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C32355F64746B31305F33323335365F353631305F325F6E775F636F6C2E74696600<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"25_dtk10_32356_5610_2_nw_col.tif"<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">3<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0100000100000000000000E03F000000000000E0BF00000000C0D91541000000008466554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C33345F64746B31305F33323335385F353630385F325F6E775F636F6C2E74696600<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"34_dtk10_32358_5608_2_nw_col.tif"<o:p></o:p></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">4<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">0100000100000000000000E03F000000000000E0BF00000000C0D91541000000007868554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C33355F64746B31305F33323335385F353631305F325F6E775F636F6C2E74696600<o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt
.75pt .75pt">
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">"35_dtk10_32358_5610_2_nw_col.tif"<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">What I found out: As
soon as I omit the s flag (to
provide a SRS) the column shows
TRUE.</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">I guess that this is not
the intended behaviour is it?</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">My QGIS 2.18 only shows
black boxes for out_db rasters,
the rasters themselves (pixel
values) only appear for “in-DB”
rasters. Did anybody succeed in
showing out_db rasters in QGIS?</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Interestiung is also
that gdalinfo is not showing any
extents although it shows correct
SRS and the “extent” column is
populated (see above):</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Courier New"" lang="DE">C:\_PortableApps_\pgsql\bin>"c:\QGIS\bin\gdalinfo.exe"
PG:"dbname='xxx' host='localhost'
port='5432' user='mhaerte2'
password='xxx' table='raster2x2'"</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Driver:
PostGISRaster/PostGIS Raster
driver</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Files: none associated</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Size is 0, 0</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Coordinate System is:</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">PROJCS["ETRS89 / UTM
zone 32N",</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> GEOGCS["ETRS89",</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
DATUM["European_Terrestrial_Reference_System_1989",</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
SPHEROID["GRS
1980",6378137,298.257222101,</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AUTHORITY["EPSG","7019"]],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
TOWGS84[0,0,0,0,0,0,0],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AUTHORITY["EPSG","6258"]],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
PRIMEM["Greenwich",0,</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AUTHORITY["EPSG","8901"]],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
UNIT["degree",0.0174532925199433,</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AUTHORITY["EPSG","9122"]],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AUTHORITY["EPSG","4258"]],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
PROJECTION["Transverse_Mercator"],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
PARAMETER["latitude_of_origin",0],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
PARAMETER["central_meridian",9],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
PARAMETER["scale_factor",0.9996],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
PARAMETER["false_easting",500000],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
PARAMETER["false_northing",0],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> UNIT["metre",1,</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AUTHORITY["EPSG","9001"]],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AXIS["Easting",EAST],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AXIS["Northing",NORTH],</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">
AUTHORITY["EPSG","25832"]]</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Subdatasets:</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> --- snip! --</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Corner Coordinates:</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Upper Left ( 0.0,
0.0)</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Lower Left ( 0.0,
0.0)</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Upper Right ( 0.0,
0.0)</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Lower Right ( 0.0,
0.0)</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Center ( 0.0,
0.0)</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Does anyone have a clue?
</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Thank you for your
comments,</span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE">Michael</span><span
lang="DE"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif"
lang="DE"> </span><span lang="DE"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE"><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org"
target="_blank">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in"><span
lang="DE"> <o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:1.0in"><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal" style="margin-left:1.0in"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-devel">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a></pre>
</blockquote>
<br>
</body>
</html>