Thread: new to postgreSql
i have got java application and i want to pass lat,long and distance in metres to geoserver in querystring and want to get near by locations within that distance. please guide me what should i do? -- View this message in context: http://postgresql.1045698.n5.nabble.com/new-to-postgreSql-tp3355805p3355805.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
On Tue, Jan 25, 2011 at 12:24 AM, gargdevender74 <gargdevender74@gmail.com> wrote: > i have got java application and i want to pass lat,long and distance in > metres to geoserver in querystring and want to get near by locations within > that distance. please guide me what should i do? I haven't used either of these before, but sounds like a job for either the earthdistance contrib module: http://www.postgresql.org/docs/current/static/earthdistance.html or for PostGIS. Josh
> or for PostGIS. I know nothing about PostGIS, nor your issue, but just in case, about PostGIS… http://postgis.refractions.net/ --- PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables"the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS),much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification forSQL" and has been certified as compliant with the "Types and Functions" profile. --- There were sessions on this at the west coast Postgres conference in San Francisco. I don't know if the sessions tapes areavailable on the web or not. --Basil Bourque