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

From: <ludwig(at)kni-online(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
Date: 2008-04-16 09:46:24
Message-ID: 13966489.1116581208339184913.JavaMail.servlet@pustefix152.kundenserver.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<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/">http://www.postgis.org/</a></p><p>&nbsp;</p><p>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>

Attachment Content-Type Size
unknown_filename text/html 1.4 KB

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2008-04-16 09:57:33 Re: Not Geography
Previous Message Stefan Sturm 2008-04-16 09:23:42 Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3