[postgis-users] Could not add all rasters to a table

[Paragon Corporation]

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-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Olivier
Courtin
Sent: Wednesday, August 15, 2012 10:48 AM
To: postgis-users at 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 <bkpark at ucdavis.edu>

Subject: Re: [postgis-users] Could not add all rasters to a table.

To: postgis-users at postgis.refractions.net

Message-ID: <502A9C67.5040901 at 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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120815/3c870cfa/attachment.html>