当前位置: 动力学知识库 > 问答 > 编程问答 >

SQL query (in Crystal Reports) to return points in an area using longitude / latitude

问题描述:

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?

分享给朋友:
您可能感兴趣的文章:
随机阅读: