Imagine that a national body recommends the minimal staffing…
1. Imagine that a national body recommends the minimal staffing levels for a police district as one officer for every 1000 people and one officer for every 25 miles of road. The police department has asked you to calculate the minimum recommended staffing levels for each district. Use the data in the mgisdata8eAustinAustin geodatabase to perform the following tasks.
Task:
· Create a table showing the top 10 districts (with the greatest number of officers), the district name, the population, the miles of road and the number of officers. (10 pts)
