From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>, Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Off topic : world database |
Date: | 2003-04-01 15:26:33 |
Message-ID: | Pine.GSO.4.53.0304011924170.27392@ra.sai.msu.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)trade-india(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-04-01 15:32:14 | Re: Off topic : world database |
Previous Message | Ian Barwick | 2003-04-01 15:15:54 | Re: How can I quit this: "Unique " to my table? |