Create a "Common Spatial Queries" page

[rmloveland]

Richard Loveland (rmloveland) commented:

We should make users' lives easier by providing example queries that show how to do common tasks.

Example queries include (but are not limited to):

• Find nearest N objects to some object O / point P, aka narrow search results to within some distance of point P - "Find N closest space shuttle launch pads to my location"

  • Make sure to preference STDWithin over STDistance for narrowing search results, since the former exits early if it finds any edge with a distance less than d.

• Update a projection

• Given a set of paths, find the longest (or shortest) over some time period

• See also:

  • PostGIS manual 4.7.2 Examples of Spatial SQL)
  • Paul Ramsey's talk "Everything about PostGIS", which has some great examples (on YouTube)
  • Note: the above are for inspiration, not transcription :-)

Jira Issue: DOC-617