[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] postgis raster export problem in using gdal_translate
From:       mahavir trivedi <mahavir.trivedi () gmail ! com>
Date:       2012-03-28 4:37:02
Message-ID: CAK9do=yn7T54wr5A-FLVZrZFP=U7x9qncL1gDh537pxoNmKXmg () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


On Tue, Mar 27, 2012 at 7:10 PM, Pierre Racine
<Pierre.Racine@sbf.ulaval.ca>wrote:

> Please send the complete raster2pgsql and gdal_translate command you used.
>
> Pierre
>
> > -----Original Message-----
> > From: postgis-users-bounces@postgis.refractions.net [mailto:
> postgis-users-
> > bounces@postgis.refractions.net] On Behalf Of mahavir trivedi
> > Sent: Tuesday, March 27, 2012 4:28 AM
> > To: postgis-users@postgis.refractions.net
> > Subject: [postgis-users] postgis raster export problem in using
> gdal_translate
> >
> > dear
> >
> >
> > i have 7053x6078 pixel  georeferrance  tiff image.
> >
> > it is import using raster2pgsql  ok
> >
> > but export it using gdal_translate command output is uncleard(Strange)
> not as
> > original input.    my out put format is same Tiff input
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

[Attachment #5 (text/html)]

<br><br><div class="gmail_quote">On Tue, Mar 27, 2012 at 7:10 PM, Pierre Racine <span \
dir="ltr">&lt;<a href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"> Please send the complete raster2pgsql and \
gdal_translate command you used.<br> <br>
Pierre<br>
<div><div class="h5"><br>
&gt; -----Original Message-----<br>
&gt; From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> \
[mailto:<a href="mailto:postgis-users-">postgis-users-</a><br> &gt; <a \
href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On \
Behalf Of mahavir trivedi<br> &gt; Sent: Tuesday, March 27, 2012 4:28 AM<br>
&gt; To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
 &gt; Subject: [postgis-users] postgis raster export problem in using \
gdal_translate<br> &gt;<br>
&gt; dear<br>
&gt;<br>
&gt;<br>
&gt; i have 7053x6078 pixel  georeferrance  tiff image.<br>
&gt;<br>
&gt; it is import using raster2pgsql  ok<br>
&gt;<br>
&gt; but export it using gdal_translate command output is uncleard(Strange) not \
as<br> &gt; original input.    my out put format is same Tiff input<br>
</div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
 <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
</blockquote></div><br>

--00151740169cb9d28404bc45fd1d--


["export_GTiff_Problem.txt" (text/plain)]

raster2pgsql -s 4236 -I -C -M BAND2.tif -F -t 100x100 public.demelevation > elev.sql

psql -d gisdb -f elev.sql

gdal_translate -of GTiff PG:"host=localhost dbname=gisdb user=postgres \
password=postgres123 table=band mode=2" D:\test.tif

--------------------------------------------------------------------------------------------------------------------------------------


Configuration detail

postgis 2.0
gdl core 1.9
RAM 4 GB
if i set shared_buffer set to more than 1 GB then postgressqlserver  will not \
started.

work_mem= 2000MB
checkpoint_segment= 20

image raster size : 94 MB 7053x6067 pixel
-----------------------------------------------------------------------------------------------------------------------------------------
 Problem

output is not same as input means output image disorted
 



_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]