Hello all,<br>
I am
working with spatial tables in postgresql with postgis support. i have two spatial data tables, one
represents the whole state and another table represents the damaged
locations in the state. My aim is to find number of damaged locations
in every county or parish.<br>
Here i am giving the query i used to do this, could you please tell me whether i am doing right thing or not.<span style="font-weight: bold;"><span style="font-weight: bold;"><span style="font-weight: bold;"><br>
</span></span></span><span style="font-weight: bold;"><br>
"select count(*) from locations
l1,county l2 where l1.the_geom && l2.the_geom and
intersects(l2.the_geom,l1.the_geom) and l2.countyid= some particular ID"<br>
<span style="font-weight: bold;"><br>
</span></span>It gave some results, but i am not sure whether the query is correct or not,<br>
I have one more problem with this query, this query taking lot of time when <span style="font-weight: bold;">some particular ID </span>ends with 9999(ex:220750501002999
<div id="mb_0">,xxxxxxx9999), do u have any idea about this strange situation.
<br>
<br>
excuse my english and method of requesting for help if there are any errors.<br>
Thanks in advance.<br>
have a nice day<br>
cheers<br><span class="sg">
vamsee </span></div>
<br><br><div><span class="gmail_quote">On 10/30/06, <b class="gmail_sendername"><a href="mailto:strk@refractions.net">strk@refractions.net</a></b> <<a href="mailto:strk@refractions.net">strk@refractions.net</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 Mon, Oct 30, 2006 at 11:50:04AM -0600, vamsee movva wrote:<br>> Hello all,<br>>
I am using postgresql database with postgis support, i<br>> understand postgis uses geos for geometrical calculations like contains(),<br>> within() etc..<br>> I am faced some problems when i used these functions,
<br>> can i ask for a help about them here?<br><br>Don't ask to ask, just ask :)<br>--strk;<br>_______________________________________________<br>geos-devel mailing list<br><a href="mailto:geos-devel@geos.refractions.net">
geos-devel@geos.refractions.net</a><br><a href="http://geos.refractions.net/mailman/listinfo/geos-devel">http://geos.refractions.net/mailman/listinfo/geos-devel</a><br></blockquote></div><br>