Visualize GPS locations stored in mySQL DB on Google maps
Project details
I have a MySQL database which stores metadata including GPS locations of bioacoustic recorders which are set up in the jungle.
Now i need a map which shows each device with a marker and when i click on it the metadata should show up. This should be helpful:
It would be cool if my life location would be on that map as well.
The GPS location from the database is stored in the Plus_code format which (i think) needs to be converted to Lat / long. For that i found these solutions:
1
2.
Of course solution number 1 is preferred 🙂
If you have done that already. This should not take too much of your time.
I have:
– Google maps Javascript API key
– Geocoding api
– webserver (mySQL, PHP, …)
– SSH to the DigitalOcean Droplet where everything is stored
Awarded to:
Despot A.
(5.0)
Project budget: $20 USD
budget limits: $10-30 USD
number of bids: 11
average bids: $38
Awarded to:
Despot A.
(5.0)
Project budget: $20 USD
budget limits: $10-30 USD
number of bids: 11
average bids: $38
Project details
I have a MySQL database which stores metadata including GPS locations of bioacoustic recorders which are set up in the jungle.
Now i need a map which shows each device with a marker and when i click on it the metadata should show up. This should be helpful:
It would be cool if my life location would be on that map as well.
The GPS location from the database is stored in the Plus_code format which (i think) needs to be converted to Lat / long. For that i found these solutions:
1
2.
Of course solution number 1 is preferred :)
If you have done that already. This should not take too much of your time.
I have:
– Google maps Javascript API key
– Geocoding api
– webserver (mySQL, PHP, …)
– SSH to the DigitalOcean Droplet where everything is stored
Now i need a map which shows each device with a marker and when i click on it the metadata should show up. This should be helpful:
It would be cool if my life location would be on that map as well.
The GPS location from the database is stored in the Plus_code format which (i think) needs to be converted to Lat / long. For that i found these solutions:
1
2.
Of course solution number 1 is preferred :)
If you have done that already. This should not take too much of your time.
I have:
– Google maps Javascript API key
– Geocoding api
– webserver (mySQL, PHP, …)
– SSH to the DigitalOcean Droplet where everything is stored
Skills: Google Maps APIJavaScriptMySQLPHP
