I work for a small police department and we use crystal reports to build reports from our database. Our department has four patrol districts (the city divided into four parts). I am trying to build a query that will return incidents that occurred in one of the four districts. Currently our database has all the locations in a table with each location having a longitude / latitude.
I was wondering if there was a way to build a query using longitude / latitude to query locations only in one of the districts (areas)? Unfortunately the districts are not perfect squares. Any ideas?