Re: [postgis-users] How do I get 'n' points nearest another point?

Mon, 22 Jun 2015 12:42:40 -0700

Hello,

I think using order by desc + limit close with st_distance could do what toi need.

Hug

Le 22 juin 2015 9:30 PM, Gerry Creager - NOAA Affiliate <gerry.crea...@noaa.gov> a écrit :

I've two tables, one with a set of city centroids, and one with radar locations. I need to select the 4 (or maybe 5) closes radars to a given city point. 

I know I've done something similar, but that was 2 or 3 major releases ago, and the syntax is now foreign to me!

Thanks in advance,
gerry
--
Gerry Creager
NSSL/CIMMS
405.325.6371
++++++++++++++++++++++
“Big whorls have little whorls,
That feed on their velocity; 
And little whorls have lesser whorls, 
And so on to viscosity.” 
Lewis Fry Richardson (1881-1953)
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Reply via email to