<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6619.12">
<TITLE>FW: Number of points from one layer in a polygon layer</TITLE>
</HEAD>
<BODY >
<DIV>
<DIV>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma">Let me clarify. I can</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma">’</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma">t use mailing addresses</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma"> for the sites</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma">, because the physical location is often NOT</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#0000FF" FACE="Tahoma">with</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma">in the city limits. That is why I am using a shapefile of 417 City</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#0000FF" FACE="Tahoma">Limits Polygons.</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma"> I have 1,423 drycleaner locations</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma"> (points)</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Tahoma">, so need a shotgun process to handle it all in one shot (1,423 sites and 417 cities is too much to do</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#0000FF" FACE="Tahoma">on a site by site or city by city basis).</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"></SPAN></B><B><SPAN LANG="en-us"><FONT COLOR="#0000FF" SIZE=6 FACE="Brush Script MT">-- John</FONT></SPAN></B><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" SIZE=6 FACE="Calibri"> </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"></FONT></SPAN></P></DIV>
<DIV><BR><BR></DIV>
<DIV STYLE="FONT-SIZE: 9pt; FONT-FAMILY: Courier New"><EM><FONT FACE="Arial" SIZE="2">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. <eXclaimer:HTML_ONLY>Simply click on <A TARGET="_blank" HREF="http://survey.dep.state.fl.us/?refemail=John.Sykes@dep.state.fl.us">this link to the DEP Customer
Survey</A>.</eXclaimer:HTML_ONLY> Thank you in advance for completing the survey.</FONT></EM></DIV>
<DIV STYLE="FONT-SIZE: 9pt; FONT-FAMILY: Courier New"><EM><FONT FACE="Arial" SIZE="2">
</FONT></EM> </DIV>
<DIV STYLE="FONT-SIZE: 9pt; FONT-FAMILY: Courier New"><P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"><BR>
</FONT></SPAN><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Tahoma">From:</FONT></B></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> Sykes, John<BR>
</FONT></SPAN><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Tahoma">Sent:</FONT></B></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> Tuesday, December 18, 2007 1:35 PM<BR>
</FONT></SPAN><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Tahoma">To:</FONT></B></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> SHRUG-L@lists.dep.state.fl.us<BR>
</FONT></SPAN><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Tahoma">Subject:</FONT></B></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Tahoma"> Number of points from one layer in a polygon layer</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Tahoma">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:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Tahoma">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.).</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Tahoma">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.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B></B></SPAN><B><SPAN LANG="en-us"><FONT SIZE=6 FACE="Brush Script MT">-- John</FONT></SPAN></B><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=6 FACE="Calibri"> </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
</DIV>
</DIV></BODY></HTML>