<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span>Hello,</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">Sorry, there are a lot of things i don't understand like :</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span class="Apple-tab-span" style="white-space:pre"> </span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span class="Apple-tab-span" style="white-space:pre"> </span>1) how can i use ST_AsText, ST_AsEWKT, or ST_AsEWKB to get the geometry colum for raster column ?</div><div style="font-family: 'times new roman',
'new york', times, serif; font-size: 12pt; "><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span class="Apple-tab-span" style="white-space:pre"> </span>2) what are the leading blank spaces ? because after i remove the blanks and create a raster column which this command :</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div><div>INSERT INTO dummy_rast(rid, rast)</div><div>postgisdata-# VALUES (1,('01'||'0000'||'0000'||'0000000000000040'||'0000000000000840'||'000000000000E03F'||'000000000000E03F'||'0000000000000000'||'0000000000000000'||'00000000'||'0A00'||'1400')::raster),</div><div>postgisdata-#
(2,('01000003009A9999999999A93F9A9999999999A9BF000000E02B274A'||'41000000007719564100000000000000000000000000000000FFFFFFFF050005000400FDFEFDFEFEFDFEFEFDF9FAFEF'||'EFCF9FBFDFEFEFDFCFAFEFEFE04004E627AADD16076B4F9FE6370A9F5FE59637AB0E54F58617087040046566487A1506CA2E3FA5A6CAFFBFE4D566DA4CB3E454C5665')::raster);</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">i have no error ! good , but if i run : </div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span class="Apple-tab-span" style="white-space:pre"> </span>SELECT rid, Box2D(rast) As rastbox FROM dummyrast;</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">i got : </div></div><div><span class="Apple-tab-span" style="font-family: 'times new roman', 'new york', times,
serif; font-size: 12pt; white-space: pre; "> </span>NOTICE: compute_serialized_box3d called on unknown type 0 </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>ERROR: lwgeom_size called with unknown-typed serialized geometry</div> <div><span class="Apple-tab-span" style="white-space:pre"> </span>3) i tried to run the commannd using pgAdmin Query Tool,, but i also got :</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-style-span" style="color: rgb(69, 69, 69); font-family: Arial, Helvetica, sans-serif; font-size: 12px; "> rid | rastbox <br> -----+---------<br> 1 | <br> 2 | <br> (2 rows)</span><br></div><div><span class="Apple-style-span" style="color: rgb(69, 69, 69); font-family: Arial, Helvetica, sans-serif; font-size: 12px; "><br></span></div><div><font
class="Apple-style-span" color="#454545"><span class="Apple-tab-span" style="white-space:pre"> </span>i think is there anything wrong or missed while i make the installation ! </font></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><br><div><br><div style="font-family: 'times new roman', 'new york', times, serif; "><div style="font-family: 'times new roman', 'new york', times, serif; "><font><hr size="1"><b style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span style="font-weight:bold;">From:</span></b><font class="Apple-style-span" size="3"> Cliff Inbau <colo14ers9@gmail.com></font><br><b style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span style="font-weight: bold;">To:</span></b><font class="Apple-style-span" size="3"> postgis-users@postgis.refractions.net</font><br><b style="font-family: 'times new roman', 'new york', times,
serif; font-size: 12pt; "><span style="font-weight: bold;">Sent:</span></b><font class="Apple-style-span" size="3"> Monday, October 10, 2011 5:37 AM</font><br><b style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><span style="font-weight: bold;">Subject:</span></b><font class="Apple-style-span" size="3"> [postgis-users] Large leading blanks spaces in geometry column</font><br></font><br>
<div id="yiv713885283" style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "><div>When I query (using the pgAdmim Query Tool) the geometry column for some polygon tables, using , I am seeing "blank" values returned for many rows. If I perform the query via SQL, there are large leading blank spaces before the actual values appear. If I copy/paste the field value into a text editor the geometry values are actually there. Likewise, if I display the table in Quantum GIS, the features display fine. The geometry seems to be valid. </div>
<div><br></div>I used the pgShapeFile Loader (GUI) to load the shapefiles, and no errors were displayed.<div><br></div><div>What would cause the geometry column to have these large leading blank spaces before the actual values?<br>
<div><br></div><div>Using PostGIS 1.5.3 with PostgreSQL 9.0 on Windows 7 machine. </div></div><div><br></div><div>Thanks,</div><div><br></div><div>Cliff Inbau</div><div><a rel="nofollow" ymailto="mailto:colo14ers9@gmail.com" target="_blank" href="mailto:colo14ers9@gmail.com">colo14ers9@gmail.com</a></div>
</div><br><font class="Apple-style-span" size="3">_______________________________________________</font><br><font class="Apple-style-span" size="3">postgis-users mailing list</font><br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net" style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank" style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; ">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br></div></div></div></div></div></body></html>