0

I have a database(PostgreSQL) with coordinates of lightning bolts. I want coordinates inside a circumference sector(SQL Query). I have the radius, angle(Z) and point A of circumference, and coordinates of extremal points([lat1,lng1], [lat2, lng2]).

enter image description here

Thanks a lot!

Tisp
  • 436
  • 2
  • 15
  • Have you coordinates of point A & radius? – david strachan Dec 12 '13 at 17:00
  • Yes! i have coordinates of point A and radious of circumference – Tisp Dec 12 '13 at 17:29
  • Have a look at my [**Answer**](http://stackoverflow.com/questions/20538063/how-to-find-exactly-data-between-selected-diagonal-area-in-mysql-query/20563777#20563777) to a similar Question. I will get back to you shortly with an answer. – david strachan Dec 13 '13 at 11:52
  • [**See**](http://daviestrachan.co.uk/polygon/MapPolygonArc.html) for implementation using Spherical Law of Cosines Query and Point in Polygon Algorithm with php/MySQL – david strachan Dec 15 '13 at 18:09

0 Answers0