<div dir="ltr"><div><div>Thanks,<br></div>Following you advice I'm in the process of upgrading gdal,<br></div>no success yet .<br><br>Cheers,<br><br>Rémi-C<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2014-03-07 17:06 GMT+01:00 Bborie Park <span dir="ltr"><<a href="mailto:dustymugs@gmail.com" target="_blank">dustymugs@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">It sounds like it might be a problem with the GDAL PostGIS Raster driver. From the GDAL driver page, it looks like they recommend 1.10.1...<div><br></div><div><a href="http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html" target="_blank">http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html</a><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Fri, Mar 7, 2014 at 7:42 AM, Rémi Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><div><div><div><div><div><div><div><div><div>Hey,<br></div>I am faced with a problem I can't solve :<br>
<br></div>I have a raster obtained by using st_setvalues and several points.<br><br></div>The raster has 2 bands, half of the pixel being set.<br>
</div><br></div>Using the st_pixelaspolygons and the ST_SummaryStats I am sure that some of the pixels of the raster are set.<br><br></div>Now when I use gdalinfo or gdal_translate on this in-base raster, it gives the correct information about the raster (size, position, band type, etc),<br>
</div><b>but the raster has no pixel set!</b><br><br></div>I tried several combination of parameters with non luck.<br><br><br></div><div>postgis version :<br><br>--POSTGIS="2.1.0 r11822" GEOS="3.5.0dev-CAPI-1.9.0 r3963" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.8.0" RASTER<br>
<br></div><div>postgres version : 9.3.3<br><br><br></div>Summary :<br><div style="margin-left:40px">Raster of 50x50 pixels has 2 bands and extent of BOX<a href="tel:%281913.5%2020887.5" value="+19135208875" target="_blank">(1913.5 20887.5</a>,<a href="tel:1914.5%2020888.5" value="+19145208885" target="_blank">1914.5 20888.5</a>)<br>
band 1 of pixtype 32BSI is in-db with NODATA value of -100000<br>
band 2 of pixtype 32BSI is in-db with NODATA value of -100000<br><br></div>Band 1 contains(histogram, excluding null values):<br><div style="margin-left:40px"><a href="tel:41660%C2%A0%C2%A0%C2%A0%2041666" value="+14166041666" target="_blank">41660 41666</a>.6666666667 32 0.039360393603936<br>
41666.6666666667 41673.3333333333 0 0<br>
41673.3333333333 41680 0 0<br><a href="tel:41680%C2%A0%C2%A0%C2%A0%2041686" value="+14168041686" target="_blank">41680 41686</a>.6666666667 656 0.806888068880689<br>41686.6666666667 41693.3333333333 0 0<br>
41693.3333333333 41700 125 0.153751537515375<br><br></div><div><div>
<div>gdalinfo :<br><div style="margin-left:40px"> gdalinfo "PG:host=localhost port=5433 dbname='test_pointcloud' user='postgres' password='youguess' schema='test_raster' table='patch_to_raster'" -stats<br>
Driver: PostGISRaster/PostGIS Raster driver<br>Files: none associated<br>Size is 50, 50<br>Coordinate System is:<br></div><div style="margin-left:40px"><i> CORRECT</i><br></div><div style="margin-left:40px">Origin = (1913.500000000000000,20887.500000000000000)<br>
Pixel Size = (0.020000000000000,0.020000000000000)<br>Corner Coordinates:<br>Upper Left ( 1913.500, 20887.500) ( 1d21'30.09"W, 5d51'10.78"S)<br>Lower Left ( 1913.500, 20888.500) ( 1d21'30.09"W, 5d51'10.75"S)<br>
Upper Right ( 1914.500, 20887.500) ( 1d21'30.06"W, 5d51'10.78"S)<br>Lower Right ( 1914.500, 20888.500) ( 1d21'30.07"W, 5d51'10.75"S)<br>Center ( 1914.000, 20888.000) ( 1d21'30.08"W, 5d51'10.76"S)<br>
Band 1 Block=50x50 Type=Int32, ColorInterp=Undefined<br> Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000<br> NoData Value=-100000<br> Metadata:<br> STATISTICS_MAXIMUM=0<br> STATISTICS_MEAN=0<br> STATISTICS_MINIMUM=0<br>
STATISTICS_STDDEV=0<br>Band 2 Block=50x50 Type=Int32, ColorInterp=Undefined<br> Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000<br> NoData Value=-100000<br> Metadata:<br> STATISTICS_MAXIMUM=0<br> STATISTICS_MEAN=0<br>
STATISTICS_MINIMUM=0<br> STATISTICS_STDDEV=0<br>remi@RemiCura-VirtualUbuntu:/media/sf_E_RemiCura/PROJETS/PC_in_DB/Raster/exported$ <br></div><br></div></div></div></div>
<br></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>