Postgres Pro
Downloads
Home   >   mailing lists

Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3 - Mailing list pgsql-general

From Stefan Sturm
Subject Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
Date
Msg-id 6316bee0804160223i12e1f64bobf00bb2ab35a6749@mail.gmail.com
Whole thread Raw
Responses Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Not Geography
Next
From:
Date:
Subject: Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3