Monday, 12 December 2016

mysql - How to know if a point is inside a rectangle on the map?


I have four points that represent a rectangle (a,b,c,d). I got these points from mobile GPS.


In my database I have this table of business locations:


bussId | longitude | latitude
-----------------------------
.. .. ..

How can I know which businesses are inside the rectangle?


I want to implement this function:


function isInsideRectangle(Point buss,Point a,Point b,Point c,Point d)


where the Point contains longitude and latitude.




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...