Maps for Dogs, or Lamp Posts in chains

Wet Lamp Post, photo by Don3rdSE (all rights reserved)

Not more stuff on street lights, 'fraid so.

In my earlier post I mentioned that it would be nice to see if it was possible to find the location of streets simply by linking together all the lamp posts on the same street. This is a (technical) account of how I achieved this using PostGIS.