I have tracking device on our company vehicles. It records and track all vehicles movements.
Also for every stops for more than 5 minutes it record the current location Lat, Long as "stop" the problem is that the even for 1 place (eg. our company) the Lat,Long of the stop is different because of place of vehicle parking spot changes
Also if there is a car traffic on the road it'll record a lot of locations
Now I have a record of almost 5000 stops locations that are duplicated but with little difference on lat and long (within 1 year)
This an example of one place (our warehouse)
and this is an example of parking the car around office building
Now that I have clustered the points using Google Maps API, (still I need to modify the cluster to include many near points)
My Question:
What I need to do is to clean my data so all clustered points (Lat, Long) with have the same values.
How can I do that with my large set of data?
I should have at least about 400 client and company locations that are duplicated in the same location with the same Lat and Long.
Plus random traffic location on the road.
It doesn't matter what programming language or software I use just guide me to the point and I will continue the job.
Actually I have tested QGIS Software before (simple quick use)
this is the main request for my question
My current HTML JS Google maps script:
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
<meta charset="utf-8">
<title>locations</title>
<style>
/* Always set the map height explicitly to define the size of the div
* element that contains the map. */
#map {
height: 100%;
}
/* Optional: Makes the sample page fill the window. */
html, body {
height: 100%;
margin: 0;
padding: 0;
}
</style>
</head>
<body>
<div id="map"></div>
<script>
function initMap() {
var map = new google.maps.Map(document.getElementById('map'), {
zoom: 3,
center: {lat: 21.46213, lng: 39.18646}
});
// Create an array of alphabetical characters used to label the markers.
var labels = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
// Add some markers to the map.
// Note: The code uses the JavaScript Array.prototype.map() method to
// create an array of markers based on a given "locations" array.
// The map() method here has nothing to do with the Google Maps API.
var markers = locations.map(function(location, i) {
return new google.maps.Marker({
position: location,
label: labels[i % labels.length],
title: locations[i].info + ", lat: " + locations[i].lat + ", lng: " + locations[i].lng
}) ;
});
// Add a marker clusterer to manage the markers.
var markerCluster = new MarkerClusterer(map, markers,
{imagePath: 'https://developers.google.com/maps/documentation/javascript/examples/markerclusterer/m'});
}
var locations = [
{
lat: 21.46213,
lng: 39.18646,
info: "Jiddah, Umm Al Quraa, Saudi Arabia"
},
{
lat: 21.4621,
lng: 39.18647,
info: "Jiddah, Umm Al Quraa, Saudi Arabia"
}
// List Of Locations
]
</script>
<script src="https://developers.google.com/maps/documentation/javascript/examples/markerclusterer/markerclusterer.js">
</script>
<script async defer
src="https://maps.googleapis.com/maps/api/js?key=_APIKEY_&callback=initMap">
</script>
</body>
</html>