Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
От | |
---|---|
Тема | Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3 |
Дата | |
Msg-id | 13966489.1116581208339184913.JavaMail.servlet@pustefix152.kundenserver.de обсуждение исходный текст |
Список | 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 по дате отправления: