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

Paul Ramsey pramsey at refractions.net
Mon Oct 30 14:59:35 EST 2006


Vamsee, this is more a PostGIS question than GEOS question so follow- 
up on postgis-users.

The query looks correct to me, what makes you think it is wrong?

The 9999 issue is certainly a symptom of something else, you might  
want to post the results of EXPLAIN ANALYZE on that query.

P

On 30-Oct-06, at 11:33 AM, vamsee movva wrote:

> 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
> cheers
> vamsee
>
>
> 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
>
> _______________________________________________
> 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/d8a47fdb/attachment.html


More information about the geos-devel mailing list