<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri, sans-serif" size="2">
<div>Hi,</div>
<div> </div>
<div>I’m new to this list and also rather new to the work with PostGIS , I used to work with it a couple of years ago and started with it again 2 weeks ago.</div>
<div> </div>
<div>Right now I’m experimenting a little bit with the possibilities to store raster in PostGIS. I have a PostGIS 2.0 installation on top of PostgreSQL 9.1 (Running on Centos 5.7).</div>
<div>What I did is to register 8bit and 16bit GeoTiffs inside postgis, i.e. as out-db raster. This works absolutely fine and when I publish this data via geoserver performance is extremely good!</div>
<div>When I load and store 8bit data inside postgis everything works well, too. But when I try to load 16bit (the same data which I could register as an out-db raster in postgis) data I get an error. The error actually already occurs when I generate the SQL-file
with raster2pgsql. When I execute:</div>
<div>python raster2pgsql.py -r dem_pgin -t public.dem_pgin -s 32632 -k 512x512 -F -I -o dem_pgin.sql</div>
<div> </div>
<div>I get the following error:</div>
<div> </div>
<div>Traceback (most recent call last):</div>
<div> File raster2pgsql.py, line 1040, in ?</div>
<div> main()</div>
<div> File raster2pgsql.py, line 1003, in main</div>
<div> gt = wkblify_raster(opts, filename.replace( '\', '/') , i, gt)</div>
<div> File raster2pgsql.py, line 945, in wkblify_raster</div>
<div> summary = wkblify_raster_level(options, ds, options.overview_level, band_range, infile, i)</div>
<div> File raster2pgsql.py, line 905, in wkblify_raster_level</div>
<div> hexwkb += wkblify_band(options, band, level, xoff, yoff, read_block_size, block_size, infile, b)</div>
<div> File raster2pgsql.py, line 825, in wkblify_band</div>
<div> hexwkb = binascii.hexlify(out_pixels)</div>
<div>TypeError: non-character (or 8-bit) array cannot be interpreted as character buffer</div>
<div> </div>
<div>Is this a general issue with 16bit data or is it maybe an error in raster2pgsql.py (From some searching it seems to be numpy issue)?</div>
<div> </div>
<div>Any help is appreciated, Cheers</div>
<div> </div>
<div>Torsten</div>
<div> </div>
<div>--------------------------------------------------------------------------</div>
<div><font face="Tele-GroteskNor">T-Systems International GmbH <br>
Torsten Drey<br>
Spezialist Geo-Consulting<br>
GeoServices/GIS<font face="Arial, sans-serif"> <br>
</font>Vorgebirgsstraße 49 <br>
D-53119 Bonn<font face="Arial, sans-serif"> <br>
</font><font face="Calibri, sans-serif"> </font><font face="Arial, sans-serif"> <br>
</font>Fon: +49 (0)228 9841 3690<br>
Fax: +49 (0)228 9841 3990<br>
E-Mail: <a href="mailto:rudolf.decker@t-systems.com"><font color="#0000FF"><u>torsten.drey@t-systems.com</u></font></a><font face="Calibri, sans-serif"> </font>
<br>
Internet: <a href="http://www.t-systems.com"><font face="Times New Roman, serif" color="#0000FF"><u>http://www.t-systems.com</u></font></a><font face="Arial, sans-serif"> </font></font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div style="padding-left: 17pt; text-indent: -17pt; "><font face="Arial, sans-serif" size="1">T-Systems International GmbH</font></div>
<div style="padding-left: 17pt; text-indent: -17pt; "><font face="Arial, sans-serif" size="1">Aufsichtsrat: René Obermann (Vorsitzender)</font></div>
<div style="padding-left: 17pt; text-indent: -17pt; "><font face="Arial, sans-serif" size="1">Geschäftsführung: Reinhard Clemens (Vorsitzender), Dr. Ferri Abolhassan,</font></div>
<div style="padding-left: 17pt; text-indent: -17pt; "><font face="Arial, sans-serif" size="1">Olaf Heyden, Georg Pepping, Klaus Werner</font></div>
<div style="padding-left: 17pt; text-indent: -17pt; "><font face="Arial, sans-serif" size="1">Handelsregister: Amtsgericht Frankfurt am Main HRB 55933</font></div>
<div style="padding-left: 17pt; text-indent: -17pt; "><font face="Arial, sans-serif" size="1">Sitz der Gesellschaft: Frankfurt am Main</font></div>
<div> </div>
<div><font face="Arial, sans-serif" size="1">Notice: This transmittal and/or attachments may be privileged or confidential. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination,
or copying is strictly prohibited. If you received this transmittal in error, please notify us immediately by reply and immediately delete this message and all its attachments. Thank you.</font></div>
<div> </div>
<div> </div>
<div> </div>
</font>
</body>
</html>