[postgis-users] Could not add all rasters to a table
Hi Olivier, For your resample problem, I will suggest you to resample your image by calling SAGA with PL/R or in command line. saga_cmd grid_tools Resampling -INPUT=YourPathto\GridToResample.sgrd.sgrd -INPUT_ADD=YourPathto\OtherGrids1.sgrd;YourPathto\OtherGrids2.sgrd;YourPathto\OtherGrids3.sgrd -KEEP_TYPE -TARGET=1 -SCALE_UP_METHOD=6 -SCALE_DOWN_METHOD=4 -USER_GRID=YourPathTo\MasterGrid 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 . This is a great tutorial; http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/ http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/ You can find bindings for GDAL on this site. http://www.gisinternals.com/sdk/ http://www.gisinternals.com/sdk/ You have to install the core of gdal before (gdalxxx-core.msi) the bindings (gdalxxx-core-pyxx.msi) For the more recent binaries go to... http://postgis.refractions.net/download/windows/experimental.php http://postgis.refractions.net/download/windows/experimental.php Cheers, Jean-Daniel Le 2012-08-15 15:00, postgis-users-requ...@postgis.refractions.net a écrit : Send postgis-users mailing list submissions to postgis-users@postgis.refractions.net To subscribe or unsubscribe via the World Wide Web, visit http://postgis.refractions.net/mailman/listinfo/postgis-users or, via email, send a message with subject or body 'help' to postgis-users-requ...@postgis.refractions.net You can reach the person managing the list at postgis-users-ow...@postgis.refractions.net 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 muni.melp...@dot.state.fl.us Subject: [postgis-users] Could not add all rasters to a table To: postgis-users@postgis.refractions.net postgis-users@postgis.refractions.net Message-ID: 6b4adbb05bcaab43923fc67066d38f5468b83b9...@dotscoexmail01.fdot.dot.state.fl.us 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 bkp...@ucdavis.edumailto:bkp...@ucdavis.edu Subject: Re: [postgis-users] Could not add all rasters to a table. To: postgis-users@postgis.refractions.netmailto:postgis-users@postgis.refractions.net Message-ID: 502a9c67.5040...@ucdavis.edumailto:502a9c67.5040...@ucdavis.edu 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: 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 -- next part -- An HTML attachment was scrubbed... URL: http://postgis.refractions.net/pipermail/postgis-users/attachments/20120815/a97eeaab/attachment-0001.html -- Message: 2 Date: Wed, 15 Aug 2012 16:47:59 +0200 From: Olivier Courtin olivier.cour...@oslandia.com Subject: [postgis-users] Could not add all rasters to a table To: postgis-users@postgis.refractions.net postgis
[postgis-users] Could not add all rasters to a table
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 bkp...@ucdavis.edumailto:bkp...@ucdavis.edu Subject: Re: [postgis-users] Could not add all rasters to a table. To: postgis-users@postgis.refractions.netmailto:postgis-users@postgis.refractions.net Message-ID: 502a9c67.5040...@ucdavis.edumailto:502a9c67.5040...@ucdavis.edu 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: 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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Could not add all rasters to a table
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 bkp...@ucdavis.edu Subject: Re: [postgis-users] Could not add all rasters to a table. To: postgis-users@postgis.refractions.net Message-ID: 502a9c67.5040...@ucdavis.edu 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: 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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Could not add all rasters to a table
Ah. I see that the Windows installation doesn't come with the gdal utilities. You can install GDAL using the OSGeo4W installer. http://trac.osgeo.org/osgeo4w/ 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: 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 bkp...@ucdavis.edumailto:bkp...@ucdavis.edu Subject: Re: [postgis-users] Could not add all rasters to a table. To: postgis-users@postgis.refractions.netmailto:postgis-users@postgis.refractions.net Message-ID: 502a9c67.5040...@ucdavis.edumailto:502a9c67.5040...@ucdavis.edu 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: 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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Could not add all rasters to a table
Olivier, You can use FWTools or Tamas nightly builds. http://www.postgis.org/documentation/manual-2.0/RT_FAQ.html#id2979398 Both have gdalinfo.exe. Tamas always has the latest and greatest. Hope that helps, Regina h http://www.postgis.us ttp://www.postgis.us _ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Olivier Courtin Sent: Wednesday, August 15, 2012 10:48 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Could not add all rasters to a table 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 bkp...@ucdavis.edu Subject: Re: [postgis-users] Could not add all rasters to a table. To: postgis-users@postgis.refractions.net Message-ID: 502a9c67.5040...@ucdavis.edu 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: 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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Could not add all rasters to a table.
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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Could not add all rasters to a table.
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: 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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
