shrug-l: FW: Number of points from one layer in a polygon layer

[Sykes, John]

Let me clarify.  I can't use mailing addresses for the sites, because the
physical location is often NOT within the city limits.  That is why I am
using a shapefile of 417 City Limits Polygons.  I have 1,423 drycleaner
locations (points), so need a shotgun process to handle it all in one shot
(1,423 sites and 417 cities is too much to do on a site by site or city by
city basis).

-- John 






The Department of Environmental 

Protection values your feedback as a customer. DEP Secretary Michael W. Sole is committed to continuously assessing and 

improving the level and quality of services provided to you. Please take a few minutes to comment on the quality of 

service you received. Copy the url below to a web browser to complete the DEP 

survey: http://survey.dep.state.fl.us/?refemail=John.Sykes@dep.state.fl.us Thank you in advance for completing the survey.


From: Sykes, John 
Sent: Tuesday, December 18, 2007 1:35 PM
To: SHRUG-L at lists.dep.state.fl.us
Subject: Number of points from one layer in a polygon layer


I don't know if I'm brain dead or just tired, but I am trying to create a
table with the number of points from a point shapefile that fall within the
individual polygons of another shapefile, specifically:

For each city in Florida (from the GeoData City Limits polygon layer) how
many Drycleaning Program sites (a DEP point shapefile) are within each city.
The output table should just have the name of the city and number of sites
(outer joins are not necessary).  I also need this to do similar summaries
for State Hazardous Waste Sites and Superfund Sites by political entity
(e.g., by city, county, DEP district, etc.).

I know how to select the sites using a polygon buffer, but just want a
summary count.  Eventually, I might want a list of sites by county, city,
etc.  but for now, just a raw count will suffice.

-- John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20071218/c7b053fe/attachment.htm