Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3

<span style="font-family: Verdana"><p>Yes, there is a great solution,&nbsp;&nbsp;</p><p>take a look at PostGIS: &nbsp;<a href="http://www.postgis.org/&quot;&gt;http://www.postgis.org/&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;It shurely will do all you want with geodata, but perhaps not as simple as you like...</p><p>&nbsp;</p><p>bye...</p><p>Ludwig&nbsp;</p><p>&nbsp;</p><p>Hello,<br /><br />I have a lot of GeoData( Latitude and Longitude ) in my PostgreSQL Database. Is store them as numeric at this time.<br />But now I want to access the data and want to have all Datasets around a Geographic point. eg: &quot;<a target="_blank" href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dwithin">within</a> <a target="_blank"
href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Da">a</a> <a target="_blank" href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dradius">radius</a> <a target="_blank" href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dof">of</a> <a target="_blank" href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3D5">5</a> <a target="_blank" href="/xml/deref?link=http%3A%2F%2Fdict.leo.org%2Fende%3Flp%3Dende%26p%3DthMx..%26search%3Dkm">km&quot;...</a><br /><br />Is there a simple way to do something like this?<br /><br />Thanks for your Help,<br />Stefan Sturm</p></span>