GeoLocation Data Processing
I am working on application related to GeoFencing software.I am recieiving realtime location Coordinates data from mobile GPS,which I am processing in Backend server and storing in Database server.I am categorizing a location point into 2 types.one is “Geofence” Point which is inside a geofence and other one is “ExtraLocation” point.So,for Extralocation points ,I am finding address and storing in database table named locations_raw and for points within Geofence,I am storing activity_id.Need help in writing a sql query to find locations where user has stopped for more than 3 minutes outside of Geofence?