Use spatial joins and the data in the mgisdata\Austin Austin geodatabase to answer the following questions. 1. A tennis club is implementing an after school tennis program. Use a spatial join to determine the closest tennis court to each school. What is the average and median distance of schools to tennis courts, in miles? Create a histogram of distances (in miles) and capture it. 2. A study is being done to evaluate staffing levels in the police districts. Determine the number of people (using the blockpop points) living in each district. Map and chart the results and discuss them. Can you explain why some of the districts have such low numbers of people? (Hint: compare the blockpop points to the base map.) pri87339_ch10_309-338.indd 336 Joins and Overlay 337 3. The University of Texas at Austin received a grant for water quality education. Each school will study aspects of the watershed in which it is located. Create a list of schools, each with its designated watershed. Sort the list alphabetically by school name and capture the results for the first 10 schools, with the grade range and watershed name. Which watershed has the most schools, and how many does it have? 4. A runner's club is analyzing access to parks in Austin, assuming that runners will go to the closest park and not run to parks more than one mile away. Determine the potential usage at each park based on the block population closer to that park than any other, but not more than 1 mile away. 5. Determine the number of wells situated in each census tract in Austin. Capture maps showing the wells per 1000 people and the mean well depth in each tract. Use the Austin data and classic overlay (intersect/union) to answer the following questions. 6. Septic systems are commonly used in low density housing areas, but the impacts on aquifers may be of concern. Map the areas in Austin where the census tract population densities are less than 1000 people per square mile and where the geologic unit names contain Limestone or Terrace or alluvium. 1. The clay fraction of soils as well as road use may affect the frequency of street repairs. How many street miles in Austin have more than 50% clay and a road class of 5 or less? Capture a map showing these roads. 8. Water quality and risks of gasoline spills may be affected by the prevalence of road arteries in a watershed. Using the arteries feature class, determine the number of road miles in each watershed. Which three watersheds have the highest mileage? Capture a map showing the mileage for each watershed. 9. Perhaps the total of street miles is a better measure than the arteries. Repeat the watershed analysis using the streets feature class and compare the results. List the three watersheds with the highest mileage, and capture a map showing the mileage of all watersheds. What significant issue impacts the quality of this result? 10. The impact of flooding on Austin would depend on the flood frequency and the density of the population. Use the tracts and soils feature classes to calculate a flood impact index based on the population density times the flood frequency, scaled from 1 to 10. What aspect of the input data most limits the applicability of this map?