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@xxxxxxxxxxxxxx> 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 >