From: Aaron Bono <postgresql@aranya.com>
To: vamsee movva <vamseejump@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: not able to execute query on spatial database.
Date: Fri, 27 Oct 2006 10:25:10 -0500
Message-ID: <bf05e51c0610270825s56875682jdc3248f58c3cd0be@mail.gmail.com> (raw)
In-Reply-To: <be5110d00610270734o3e202cc0o725340d144aff3c2@mail.gmail.com>
References: <be5110d00610270734o3e202cc0o725340d144aff3c2@mail.gmail.com>
On 10/27/06, vamsee movva <vamseejump@gmail.com> wrote:
>
> 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
>
What is your table structure? I think you mean (l2.the_geom =
l1.the_geom). If you use
l2.parishid=particular_parishid then you are not going to get EVERY country
or parish.
Have you run this query? If so, what are you getting, is it right and if so
why not?
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, vamseejump@gmail.com
Subject: Re: not able to execute query on spatial database.
In-Reply-To: <bf05e51c0610270825s56875682jdc3248f58c3cd0be@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox