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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to