From: Oleg Bartunov <oleg@sai.msu.su>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Off topic : world database
Date: Tue, 1 Apr 2003 19:26:33 +0400 (MSD)
Message-ID: <Pine.GSO.4.53.0304011924170.27392@ra.sai.msu.su> (raw)
In-Reply-To: <20030331170032.GA2303@wolff.to>
References: <3E824070.7070207@oasis.net.au>
<3E878C84.5030004@oasis.net.au>
<200303311108.48751.mallah@trade-india.com>
<20030331170032.GA2303@wolff.to>
I don't know if it's legal to use data from
http://www.nima.mil/gns/html/index.html
but it's a huge collection of geo data.
Oleg
On Mon, 31 Mar 2003, Bruno Wolff III wrote:
> On Mon, Mar 31, 2003 at 11:08:48 +0530,
> Rajesh Kumar Mallah <mallah@trade-india.com> wrote:
> >
> > I am wanting to make an application similar to you
> > which shud be able to get all the places within certaint
> > radius of the place in question.
>
> If you look at contrib/earthdistance in the 7.4 source tree, there is
> a varient way to use earthdistance based on the cube data type instead
> of point. This varient uses a 3D representation so you don't have to
> worry about issues at the poles or wrap around. You can do indexed
> searches (though I don't really know how well (fast) the indexes work,
> since I haven't tried them with large amounts of data) inside of
> bounding boxes, then double check that the points are really closer
> than the desired distance.
>
> This varient uses a couple of new cube functions and check constraints
> on domains. You can just comment out the check constraints. The 7.4
> contrib/cube might work with 7.3. (If there are problems you should
> be able to compare with the 7.3 version to figure out how to make it
> work.)
>
> P.S.
>
> It would be nice if you eventually summarize your data sources, as I
> would eventually like to get hold of similar data for areas outside of
> the US for my project.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
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: oleg@sai.msu.su, bruno@wolff.to, mallah@trade-india.com, rudi@oasis.net.au
Subject: Re: Off topic : world database
In-Reply-To: <Pine.GSO.4.53.0304011924170.27392@ra.sai.msu.su>
* 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