<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><br>
<font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt">Hi Olivier, <br>
<br>
For your resample problem, I will suggest you to resample your
image by calling SAGA with PL/R or in command line.<br>
<br>
saga_cmd grid_tools "Resampling" -INPUT=</span></font><font
color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt">YourPathto\GridToResample.sgrd</span></font><font
color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt">.sgrd -INPUT_ADD=</span></font><font
color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt">YourPathto\OtherGrids1.sgrd</span></font><font
color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt">;</span></font><font color="black"
face="Times New Roman" size="3"><span style="font-size:12.0pt">YourPathto\OtherGrids2.sgrd</span></font><font
color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt">;YourPathto\OtherGrids3.sgrd
-KEEP_TYPE -TARGET=1 -SCALE_UP_METHOD=6 -SCALE_DOWN_METHOD=4
-USER_GRID=YourPathTo\MasterGrid <br>
<br>
I'm not really sure that your problem is related to your
installation but if you want to assure you that your set-up is
ok follow those instructions .<br>
<br>
This is a great tutorial;<br>
<br>
<a
href="http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/"
target="_blank">http://gis4free.wordpress.com/<wbr>2011/03/10/how-to-install-and-<wbr>configure-<span
class="il">postgis</span>-raster-on-<wbr>windows/</a><br>
<br>
You can find bindings for GDAL on this site.<br>
<br>
<a href="http://www.gisinternals.com/sdk/" target="_blank">http://www.gisinternals.com/<wbr>sdk/</a>
<br>
<br>
You have to install the core of gdal before (gdalxxx-core.msi)
the bindings </span></font><font color="black" face="Times
New Roman" size="3"><span style="font-size:12.0pt">(gdalxxx-core-pyxx.msi)</span></font><br>
<font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt"><br>
For the more recent binaries go to... <br>
<br>
<a
href="http://postgis.refractions.net/download/windows/experimental.php"
target="_blank">http://<span class="il">postgis</span>.refractions.<wbr>net/download/windows/<wbr>experimental.php</a><br>
<br>
Cheers,<br>
<br>
Jean-Daniel <br>
</span></font><br>
<br>
Le 2012-08-15 15:00, <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net</a>
a écrit :<br>
</div>
<blockquote
cite="mid:mailman.1.1345057201.8986.postgis-users@postgis.refractions.net"
type="cite">
<pre wrap="">Send postgis-users mailing list submissions to
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
To subscribe or unsubscribe via the World Wide Web, visit
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
or, via email, send a message with subject or body 'help' to
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net</a>
You can reach the person managing the list at
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users-owner@postgis.refractions.net">postgis-users-owner@postgis.refractions.net</a>
When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."
Today's Topics:
1. Could not add all rasters to a table (Melpati, Muni)
2. Could not add all rasters to a table (Olivier Courtin)
3. Re: Could not add all rasters to a table (Bborie Park)
4. Merge rectangles (DrYSG)
----------------------------------------------------------------------
Message: 1
Date: Wed, 15 Aug 2012 09:57:42 -0400
From: "Melpati, Muni" <a class="moz-txt-link-rfc2396E" href="mailto:Muni.Melpati@dot.state.fl.us"><Muni.Melpati@dot.state.fl.us></a>
Subject: [postgis-users] Could not add all rasters to a table
To: <a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net">"postgis-users@postgis.refractions.net"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net"><postgis-users@postgis.refractions.net></a>
Message-ID:
<a class="moz-txt-link-rfc2396E" href="mailto:6B4ADBB05BCAAB43923FC67066D38F5468B83B9F5C@DOTSCOEXMAIL01.fdot.dot.state.fl.us"><6B4ADBB05BCAAB43923FC67066D38F5468B83B9F5C@DOTSCOEXMAIL01.fdot.dot.state.fl.us></a>
Content-Type: text/plain; charset="us-ascii"
Hi Park,
I could not find gdalinfo.exe on my windows machine. I have installed postgis 2.0. Should I install gdalinfo separately? I could not google to the application download. Where should I find it?
I could not find scale x/y values for the raster files. Moreover, I do not see any problem in viewing them in ArcMap. They might overlap little bit on the edges. But that is usually the case with raster images.
Any help to sort of the problem. Thanks.
Date: Tue, 14 Aug 2012 11:43:51 -0700
From: Bborie Park <<a class="moz-txt-link-abbreviated" href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a><a class="moz-txt-link-rfc2396E" href="mailto:bkpark@ucdavis.edu"><mailto:bkpark@ucdavis.edu></a>>
Subject: Re: [postgis-users] Could not add all rasters to a table.
To: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net"><mailto:postgis-users@postgis.refractions.net></a>
Message-ID: <<a class="moz-txt-link-abbreviated" href="mailto:502A9C67.5040901@ucdavis.edu">502A9C67.5040901@ucdavis.edu</a><a class="moz-txt-link-rfc2396E" href="mailto:502A9C67.5040901@ucdavis.edu"><mailto:502A9C67.5040901@ucdavis.edu></a>>
Content-Type: text/plain; charset=ISO-8859-1
The error is just that: at least one raster isn't aligned with the other rasters being added to that table. One way to see what could be going on is to use gdalinfo on the four rasters. Check the values for the upper-left corner, scale and skew. The scale and skew should be the same while the upper-left corners should be divisible without a remainder...
(rast1X - rast2X) / scaleX = whole number
(rast1Y - rast2Y) / scaleY = whole number
If all that looks good, post the outputs from gdalinfo for all four rasters so that I can take a look and see if there are strange floating point issues...
-bborie
On 08/14/2012 11:32 AM, Melpati, Muni wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">I am getting this error "raster with different alignment found in the set of rasters being converted to postgis raster" while I load all four jpg files into a new table. When I view them ArcMap they just seems to align well.
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">What must be going wrong?
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">Here is the text in the bat file:
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">path=%path%;"E:\PostgreSQL\8.4\bin
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">cd /D "%~dp0"
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">raster2pgsql -I -C -e -Y -F -s 26986 -t 300x300 -l 2,4
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">F:\PostGIS\raster\*.jpg private_schema.rasterly1 | psql -h localhost
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">-U postgres -d gis_raster -p 5433
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">pause
</pre>
</blockquote>
<pre wrap="">
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20120815/a97eeaab/attachment-0001.html"><http://postgis.refractions.net/pipermail/postgis-users/attachments/20120815/a97eeaab/attachment-0001.html></a>
------------------------------
Message: 2
Date: Wed, 15 Aug 2012 16:47:59 +0200
From: Olivier Courtin <a class="moz-txt-link-rfc2396E" href="mailto:olivier.courtin@oslandia.com"><olivier.courtin@oslandia.com></a>
Subject: [postgis-users] Could not add all rasters to a table
To: <a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net">"postgis-users@postgis.refractions.net"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net"><postgis-users@postgis.refractions.net></a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:31C5FA74-CBEE-45F1-B7CA-19386DB02D48@oslandia.com"><31C5FA74-CBEE-45F1-B7CA-19386DB02D48@oslandia.com></a>
Content-Type: text/plain; charset="us-ascii"
Hi Park,
I could not find gdalinfo.exe on my windows machine. I have installed postgis 2.0. Should I install gdalinfo separately? I could not google to the application download. Where should I find it?
I could not find scale x/y values for the raster files. Moreover, I do not see any problem in viewing them in ArcMap. They might overlap little bit on the edges. But that is usually the case with raster images.
Any help to sort of the problem. Thanks.
Date: Tue, 14 Aug 2012 11:43:51 -0700
From: Bborie Park <a class="moz-txt-link-rfc2396E" href="mailto:bkpark@ucdavis.edu"><bkpark@ucdavis.edu></a>
Subject: Re: [postgis-users] Could not add all rasters to a table.
To: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:502A9C67.5040901@ucdavis.edu"><502A9C67.5040901@ucdavis.edu></a>
Content-Type: text/plain; charset=ISO-8859-1
The error is just that: at least one raster isn't aligned with the other rasters being added to that table. One way to see what could be going on is to use gdalinfo on the four rasters. Check the values for the upper-left corner, scale and skew. The scale and skew should be the same while the upper-left corners should be divisible without a remainder...
(rast1X - rast2X) / scaleX = whole number
(rast1Y - rast2Y) / scaleY = whole number
If all that looks good, post the outputs from gdalinfo for all four rasters so that I can take a look and see if there are strange floating point issues...
-bborie
On 08/14/2012 11:32 AM, Melpati, Muni wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,
I am getting this error "raster with different alignment found in the set of rasters being converted to postgis raster" while I load all four jpg files into a new table. When I view them ArcMap they just seems to align well.
What must be going wrong?
Here is the text in the bat file:
path=%path%;"E:\PostgreSQL\8.4\bin
cd /D "%~dp0"
raster2pgsql -I -C -e -Y -F -s 26986 -t 300x300 -l 2,4
F:\PostGIS\raster\*.jpg private_schema.rasterly1 | psql -h localhost
-U postgres -d gis_raster -p 5433
pause
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20120815/1988e576/attachment-0001.html"><http://postgis.refractions.net/pipermail/postgis-users/attachments/20120815/1988e576/attachment-0001.html></a>
------------------------------
Message: 3
Date: Wed, 15 Aug 2012 10:18:36 -0700
From: Bborie Park <a class="moz-txt-link-rfc2396E" href="mailto:bkpark@ucdavis.edu"><bkpark@ucdavis.edu></a>
Subject: Re: [postgis-users] Could not add all rasters to a table
To: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:502BD9EC.2010308@ucdavis.edu"><502BD9EC.2010308@ucdavis.edu></a>
Content-Type: text/plain; charset=ISO-8859-1
Ah. I see that the Windows installation doesn't come with the gdal
utilities. You can install GDAL using the OSGeo4W installer.
<a class="moz-txt-link-freetext" href="http://trac.osgeo.org/osgeo4w/">http://trac.osgeo.org/osgeo4w/</a>
Once GDAL is installed, you should be able to call gdalinfo on the
raster files and get a dump of the raster metadata.
Overlap isn't a problem. The problem is that one of the rasters is not
on the same "grid" as the other rasters.
-bborie
On 08/15/2012 06:57 AM, Melpati, Muni wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Park,
I could not find gdalinfo.exe on my windows machine. I have installed postgis 2.0. Should I install gdalinfo separately? I could not google to the application download. Where should I find it?
I could not find scale x/y values for the raster files. Moreover, I do not see any problem in viewing them in ArcMap. They might overlap little bit on the edges. But that is usually the case with raster images.
Any help to sort of the problem. Thanks.
Date: Tue, 14 Aug 2012 11:43:51 -0700
From: Bborie Park <<a class="moz-txt-link-abbreviated" href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a><a class="moz-txt-link-rfc2396E" href="mailto:bkpark@ucdavis.edu"><mailto:bkpark@ucdavis.edu></a>>
Subject: Re: [postgis-users] Could not add all rasters to a table.
To: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net"><mailto:postgis-users@postgis.refractions.net></a>
Message-ID: <<a class="moz-txt-link-abbreviated" href="mailto:502A9C67.5040901@ucdavis.edu">502A9C67.5040901@ucdavis.edu</a><a class="moz-txt-link-rfc2396E" href="mailto:502A9C67.5040901@ucdavis.edu"><mailto:502A9C67.5040901@ucdavis.edu></a>>
Content-Type: text/plain; charset=ISO-8859-1
The error is just that: at least one raster isn't aligned with the other rasters being added to that table. One way to see what could be going on is to use gdalinfo on the four rasters. Check the values for the upper-left corner, scale and skew. The scale and skew should be the same while the upper-left corners should be divisible without a remainder...
(rast1X - rast2X) / scaleX = whole number
(rast1Y - rast2Y) / scaleY = whole number
If all that looks good, post the outputs from gdalinfo for all four rasters so that I can take a look and see if there are strange floating point issues...
-bborie
On 08/14/2012 11:32 AM, Melpati, Muni wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">I am getting this error "raster with different alignment found in the set of rasters being converted to postgis raster" while I load all four jpg files into a new table. When I view them ArcMap they just seems to align well.
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">What must be going wrong?
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">Here is the text in the bat file:
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">path=%path%;"E:\PostgreSQL\8.4\bin
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">cd /D "%~dp0"
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">raster2pgsql -I -C -e -Y -F -s 26986 -t 300x300 -l 2,4
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">F:\PostGIS\raster\*.jpg private_schema.rasterly1 | psql -h localhost
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">-U postgres -d gis_raster -p 5433
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">pause
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Jean-Daniel Sylvain, Géographe, M. Sc.
Chercheur spécialisé en géomatique et analyse spatiale
Direction de la recherche forestière, Ministère des Ressources naturelles et de la Faune
2700, rue Einstein, bureau C.RC.335, Québec (Québec) G1P 3W8
Téléphone : +1-418 643-7994, poste 6515, Télécopieur : +1-418 643-2165
Courriel : <a class="moz-txt-link-abbreviated" href="mailto:jean-daniel.sylvain@mrnf.gouv.qc.ca">jean-daniel.sylvain@mrnf.gouv.qc.ca</a>
Site Internet : <a class="moz-txt-link-abbreviated" href="http://www.mrnf.gouv.qc.ca/drf">www.mrnf.gouv.qc.ca/drf</a>
Ce message est confidentiel et ne s'adresse qu'au destinataire.
S'il vous a été transmis par mégarde, veuillez le détruire et nous en aviser aussitôt. Merci de votre compréhension</pre>
</body>
</html>