This similar, but not quite the same as this question.

I need to pick, regardless of distance, the closest 'n' points to a given point in another table, using postGIS.

Imagine a table with city names, state names, and a centroid for the city itself, and another table with point information on various weather radar sites. Both tables re postGIS enabled.

PostGIS-2 has me confused; it's been awhile since I had to do something line this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.