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.
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.