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<http://dict.leo.org/ende?lp=ende&p=thMx..&search=within>
a <http://dict.leo.org/ende?lp=ende&p=thMx..&search=a>
radius<http://dict.leo.org/ende?lp=ende&p=thMx..&search=radius>
of <http://dict.leo.org/ende?lp=ende&p=thMx..&search=of>
5<http://dict.leo.org/ende?lp=ende&p=thMx..&search=5>
km"... <http://dict.leo.org/ende?lp=ende&p=thMx..&search=km>
Is there a simple way to do something like this?
Thanks for your Help,
Stefan Sturm
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:
Show quoted text
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
Hello,
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