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

From
Subject Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
Date
Msg-id 13966489.1116581208339184913.JavaMail.servlet@pustefix152.kundenserver.de
Whole thread Raw
List pgsql-general
<span style="font-family: Verdana"><p>Yes, there is a great solution,  <p>take a look at PostGIS:  <a
href="http://www.postgis.org/">http://www.postgis.org/</a><p> <p>Itshurely will do all you want with geodata, but
perhapsnot as simple as you like...<p> <p>bye...<p>Ludwig <p> <p>Hello,<br /><br />I have a lot of GeoData( Latitude
andLongitude ) in my PostgreSQL Database. Is store them as numeric at this time.<br />But now I want to access the data
andwant to have all Datasets around a Geographic point. eg: "<a
href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dwithin"
target="_blank">within</a><a
href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Da"target="_blank">a</a> <a
href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dradius"
target="_blank">radius</a><a
href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dof"target="_blank">of</a> <a
href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3D5"target="_blank">5</a> <a
href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dkm"
target="_blank">km"...</a><br/><br />Is there a simple way to do something like this?<br /><br />Thanks for your
Help,<br/>Stefan Sturm</span> 

pgsql-general by date:

Previous
From: "Stefan Sturm"
Date:
Subject: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
Next
From: Bob Pawley
Date:
Subject: Re: Not Geography