Performing Multiple Nearest Neighbor Queries with PostgreSQL and PostGIS

How to Write a Postgres Function to Concatenate Array of Arrays into String for Use with PostGIS's LINESTRING Data Type

Optimizing Spatial Joins in PostGIS: A Step-by-Step Guide to Time of Intersection