Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2013
    Posts
    354
    Provided Answers: 1

    Unanswered: I need an example of a geographical query

    I need an example of a geographical query in DB2 dialect for an article. I happen to like the classic “Given a map and my location, find the (n) nearest pubs to me”, but if you have a better one, I would be happy.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

  3. #3
    Join Date
    Jan 2013
    Posts
    354
    Provided Answers: 1

    This is good, but ..

    The link was good and I am catching my reading. But here is my problem. I am writing a book which has a chapter on GIS systems. I want an example of a simple "Nearest Neighbors" problem done in Oracle, DB2 and SQL Server extensions. I get my laugh with a "how to crawl to the nearest pubs" in the narrative, followed by a discussion of the vendor extensions and the Open GIS for SQL standards.

    I am not trying to learn the GIS extensions, just give an over view and some sample code. I have deadlines that are passing. This is such a classic GIS problem, I assumed there would be a page on it somewhere or a library procedure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •