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.

Search Discussions

  • Josh Kupershmidt at Jan 27, 2011 at 4:11 am

    On Tue, Jan 25, 2011 at 12:24 AM, gargdevender74 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
  • Basil Bourque at Jan 28, 2011 at 4:06 am
    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 for SQL" 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 are available on the web or not.

    --Basil Bourque

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJan 25, '11 at 5:25a
activeJan 28, '11 at 4:06a
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase