[postgis-users] help with spatial query

[Josh Jordan]

I am trying to return a map of the USA with the top 100 cities (point data)
labeled.

SELECT * FROM cities ORDER BY pop_1990 DESC LIMIT 100;

The problem is it returns clusters of cities, for instance 7 dots on Chicago
and 8 dots on Manhattan.  Is there a way to return the top 100 cities
omitting ones that are too close to each other?

-Josh Jordan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110613/b848738e/attachment.html>