Hi Michael,<br>
Thank you for your reply.<br>
Here are results of the queries you mentioned.<br>
<span style="font-weight: bold;">AsText() and AsEWKT() <br>
</span>select AsEWKT(the_geom) from la_blocks where stfid='220750501002995';<br>
asewkt <br>
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<br>
MULTIPOLYGON(((-89.826276 29.643064,-89.826879
29.642835,-89.827639 29.642766,-89.828321 29.642949,-89.828609
29.642858,-89.828635 29.641735,-89.82895 29.6413,-89.829579
29.641323,-89.830628 29.641598,-89.831703 29.642079,-89.832384
29.642559,-89.833171 29.643315,-89.833617 29.643452,-89.834429
29.643407,-89.835033 29.643819,-89.835164 29.644093,-89.835111
29.644414,-89.835033 29.644529,-89.834666 29.644712,-89.834456
29.644941,-89.834351 29.645262,-89.834378 29.645743,-89.834719
29.646178,-89.834876 29.646338,-89.834928 29.646636,-89.834719
29.646888,-89.834352 29.646957,-89.833985 29.646865,-89.833617
29.646636,-89.832936 29.646064,-89.832595 29.645835,-89.832018
29.64572,-89.831389 29.64572,-89.830655 29.646064,-89.829763
29.646156,-89.828924 29.645995,-89.828269 29.645583,-89.82743
29.64485,-89.827141 29.644415,-89.826931 29.643911,-89.826722
29.64382,-89.826617 29.643889,-89.826355 29.644324,-89.826302
29.64437,-89.826224 29.644507,-89.826014 29.644622,-89.825725
29.644622,-89.825647 29.644232,-89.825883 29.643751,-89.826066
29.643454,-89.826197 29.643316,-89.826276 29.643064),(-89.831179
29.643567,-89.830287 29.643682,-89.829946 29.643911,-89.82992
29.644026,-89.830182 29.644186,-89.831231 29.644735,-89.831467
29.644644,-89.831546 29.644438,-89.831546 29.64398,-89.831441
29.643773,-89.831179 29.643567)))<br>
(1 row)<br>
<span style="font-weight: bold;"><span style="font-weight: bold;"><br>
(FOR stfid </span></span>220750501002999,It gave a very big set of co-ordinates)<br>
<span style="font-weight: bold;">SELECT stfid, npoints(the_geom), nrings(the_geom) FROM la_blocks ORDER BY nrings DESC LIMIT 10;</span><br style="font-weight: bold;">
stfid | npoints | nrings<br>
-----------------+---------+--------<br>
220750501002999 | 64266 | 2507<br>
220750501002103 | 60919 | 2487<br>
220750508001999 | 19019 | 821<br>
220750508001000 | 16480 | 813<br>
220750501002998 | 45421 | 731<br>
221090013004990 | 34863 | 354<br>
221090011003999 | 17073 | 337<br>
221090012024005 | 13503 | 290<br>
220870301012999 | 44032 | 286<br>
220750501002065 | 12727 | 248<br>
(10 rows)<br>
<br>
These are the points where the query taking too much time to execute.<br>
<br>
<span style="font-weight: bold;">SELECT getbbox(the_geom) FROM la_blocks WHERE stfid = '220750501002999';<br>
</span>
getbbox<br>
----------------------------------------------------------------------------<br>
BOX(-89.5361709594727 28.8551273345947,-88.8792343139648 29.6479110717773)<br>
(1 row)<br>
<br>
I think, the number of rings is the problem<br>
Thanks alot,<br>
have a nice day<br>
vamsee movva<br>
<span style="font-weight: bold;"><br>
</span><br>
<br>
<span style="font-weight: bold;"><span style="font-weight: bold;"></span><br>
</span><br><br><div><span class="gmail_quote">On 11/1/06, <b class="gmail_sendername">Michael Fuhr</b> <<a href="mailto:mike@fuhr.org">mike@fuhr.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Tue, Oct 31, 2006 at 10:47:50AM -0600, vamsee movva wrote:<br>> > What can you tell us about the geometries in la_damage ?<br>><br>> Honestly i don't have any idea about geometries and how to find geometries.
<br>> the geometry in la_blocks for stfid = 220750501002999?<br>> I don't know how to see the geometry of the_geom column.<br><br>You can see a geometry's textual representation with functions like<br>AsText() and AsEWKT() or you could see graphical output with various
<br>visualization tools.<br><br>> > What's the output of the following query?<br>><br>> SELECT summary(the_geom) FROM la_blocks WHERE stfid = '220750501002999';<br>> please find the attached file "stfid.txt
"<br><br>Ouch:<br><br>> MultiPolygon[B] with 1 elements<br>> Polygon[] with 2507 rings<br><br>I count 64266 points altogether. Does this geometry's row in<br>la_blocks contain other columns that explain what it is? Is this
<br>geometry's size an anomaly? The following queries should show<br>the geometries with the most rings and points:<br><br>SELECT stid, npoints(the_geom), nrings(the_geom)<br>FROM la_blocks<br>ORDER BY nrings DESC<br>LIMIT 10;
<br><br>SELECT stid, npoints(the_geom), nrings(the_geom)<br>FROM la_blocks<br>ORDER BY npoints DESC<br>LIMIT 10;<br><br>Examining the geometry's bounding box might also be revealing:<br><br>SELECT getbbox(the_geom)<br>FROM la_blocks
<br>WHERE stfid = '220750501002999';<br><br>I'm wondering if this geometry is representative of the rest of the<br>data or if it's an outlier and possibly bogus.<br><br>--<br>Michael Fuhr<br>_______________________________________________
<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">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br></blockquote></div><br>