<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>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 FACE="Tahoma">I don</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">’</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">t know if I</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">’</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">m brain dead or just tired, but I am trying to create a table with the number of points from a p</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">oint 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</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">Drycleaning Program sites (a</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">DEP</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">point shapefile) are</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">with</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">in each city. The output table should just have the name of the city and number of sites</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma"> (outer joins are not necessary)</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">.</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma"> I also need this to do similar summaries for State Hazardous Waste Sites and Superfund Sites by political entity (e.g., by city, county,</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">DEP district,</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">etc.).</FONT></SPAN><SPAN LANG="en-us"></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</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma"> count</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Tahoma">. Eventually, I might want a list of sites by county, city, etc. but for now, just a</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">raw</FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Tahoma">count will suffice.</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 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></P>
<P DIR=LTR><SPAN LANG="en-us"></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"></DIV>
</DIV></BODY></HTML>