[geos-devel] can i ask questions related to postgresql spatial queries

vamsee movva vamseejump at gmail.com
Mon Oct 30 14:33:20 EST 2006

Hello all,
           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.
Here i am giving the query i used to do this, could you please tell me
whether i am doing right thing or not.

"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"

It gave some results, but i am not sure whether the query is correct or not,
I have one more problem with this query, this query taking lot of time
when some
particular ID ends with 9999(ex:220750501002999 ,xxxxxxx9999), do u have any
idea about this strange situation.

excuse my english and method of requesting for help if there are any errors.
Thanks in advance.
have a nice day

On 10/30/06, strk at refractions.net <strk at refractions.net> wrote:
> On Mon, Oct 30, 2006 at 11:50:04AM -0600, vamsee movva wrote:
> > Hello all,
> >             I am using postgresql database with postgis support, i
> > understand postgis uses geos for geometrical calculations like
> contains(),
> > within() etc..
> >           I am faced some problems when i used these functions,
> > can i  ask for a help about them here?
> Don't ask to ask, just ask  :)
> --strk;
> _______________________________________________
> geos-devel mailing list
> geos-devel at geos.refractions.net
> http://geos.refractions.net/mailman/listinfo/geos-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geos-devel/attachments/20061030/73266b9e/attachment.html

More information about the geos-devel mailing list