My sample site URL : My working Site URL
I am trying to find a solution that will allow me to plot the GPS coordinates of many moving objects "live" on a Google Map.
The GPS coordinates of each object will constantly be updating into a MySQL database, and I'd like to know whether it is possible to read each updated coordinate, maybe once every couple of seconds, and re-plot the marker coordinates on the Google Map, without the user having to refresh the page. Can this be done,?
would it also be possible to make each marker different, and each marker clickable to get more information on the particular object?
My map based on Jack Dougherty's FusionTable-Map-2-layers Template
and running nicely on my hostgater server.
I have Traccar Open Source GPS Tracking Platform hosted with Amazone AWS and able to get tracker data to the mysql database, this database update every 30 second with live tracker data
# my db name “newTraccar” & all tracker data update for table `positions`
// -------------- Table structure for table `positions` ---------------------//
CREATE TABLE IF NOT EXISTS `positions` (
`id` bigint(20) NOT NULL,
`address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`altitude` double DEFAULT NULL,
`course` double DEFAULT NULL,
`latitude` double DEFAULT NULL,
`longitude` double DEFAULT NULL,