<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi, i get it & thank for help.</span></div><div><br></div><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Cliff Inbau <colo14ers9@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> postgis-users@postgis.refractions.net<br><b><span style="font-weight: bold;">Sent:</span></b> Monday, October 10, 2011 5:37 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [postgis-users] Large leading blanks spaces in geometry column<br></font><br>
<div id="yiv2137335317"><div>When I query (using the pgAdmim Query Tool) the geometry column for some polygon tables, using ST_AsText, ST_AsEWKT, or ST_AsEWKB, 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>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" 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><br><br></div></div></div></body></html>