;
Or create a new table with these aggregated data & query from that directly.
HTH,
Brent Wood
--- On Tue, 6/14/11, Josh Jordan wrote:
From: Josh Jordan
Subject: [postgis-users] help with spatial query
To: postgis-users@postgis.refractions.net
Date: Tuesday, June 14, 2011, 2:03 AM
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 o
sers] Help with spatial query
Dear Regina,
Thank you so much for the quick response.
best regards,
surya
- Original Message -
From: "Obe, Regina"
To: "PostGIS Users Discussion"
Sent: Thursday, January 08, 2009 2:22 AM
Subject: RE: [postgis-users] Help with spa
Dear Regina,
Thank you so much for the quick response.
best regards,
surya
- Original Message -
From: "Obe, Regina"
To: "PostGIS Users Discussion"
Sent: Thursday, January 08, 2009 2:22 AM
Subject: RE: [postgis-users] Help with spatial query
Surya,
Not
tgis.refractions.net
Subject: [postgis-users] Help with spatial query
Dear List,
Since the (planned) Postgis book is not yet available, I still
have to ask List for the following simple SQL.
I have two tables:
1) One table consist of 150 watershed polygons
2) Second table consista of 500 district po
Dear List,
Since the (planned) Postgis book is not yet available, I still
have to ask List for the following simple SQL.
I have two tables:
1) One table consist of 150 watershed polygons
2) Second table consista of 500 district polygons.
Some of the districts are completely whithin one certain
w