not able to execute query on spatial database.

From: "vamsee movva" <vamseejump(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: not able to execute query on spatial database.
Date: 2006-10-27 14:34:21
Message-ID: be5110d00610270734o3e202cc0o725340d144aff3c2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello all,
I am working with spatial tables. 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 damagedlocations l1,county l2 where (l2.the_geom and
l1.the_geom) and l2.parishid=particular_parishid;

thanks in advance.
vamsee movva

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jon Horsman 2006-10-27 15:12:49 Re: How to query information schema from shell script
Previous Message Jon Horsman 2006-10-27 13:57:27 Re: How to query information schema from shell script