Thread: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
Hello,
I have a lot of GeoData( Latitude and Longitude ) in my PostgreSQL Database. Is store them as numeric at this time.
But now I want to access the data and want to have all Datasets around a Geographic point. eg: "within a radius of 5 km"...
Is there a simple way to do something like this?
Thanks for your Help,
Stefan Sturm
I have a lot of GeoData( Latitude and Longitude ) in my PostgreSQL Database. Is store them as numeric at this time.
But now I want to access the data and want to have all Datasets around a Geographic point. eg: "within a radius of 5 km"...
Is there a simple way to do something like this?
Thanks for your Help,
Stefan Sturm
Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
From
"Ivan Zolotukhin"
Date:
Hello, You may want to have a look also at PgSphere (http://pgfoundry.org/projects/pgsphere) and Q3C (http://q3c.sf.net) which is actually a spherical indexing solution built specially for PostgreSQL with the best performance among all other methods (even within other databases). Regards, Ivan On Wed, Apr 16, 2008 at 1:23 PM, Stefan Sturm <stefan.s.sturm@googlemail.com> wrote: > Hello, > > I have a lot of GeoData( Latitude and Longitude ) in my PostgreSQL Database. > Is store them as numeric at this time. > But now I want to access the data and want to have all Datasets around a > Geographic point. eg: "within a radius of 5 km"... > > Is there a simple way to do something like this? > > Thanks for your Help, > Stefan Sturm >
Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
From
"Stefan Sturm"
Date:
Hello,
thanks for your ansers.
I think this look most promising. Is here someone using it and can give me some tipps?
Thanks and greetings,
Stefan Sturm
thanks for your ansers.
PgSphere (http://pgfoundry.org/projects/pgsphere)
I think this look most promising. Is here someone using it and can give me some tipps?
Thanks and greetings,
Stefan Sturm