Visualize GPS locations stored in mySQL DB on Google maps
Budget: $10 – $30 USD
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: https://developers.google.com/maps/documentation/javascript/adding-a-google-map
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 https://github.com/google/open-location-code
2. https://developers.google.com/maps/documentation/geocoding/overview
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: https://developers.google.com/maps/documentation/javascript/adding-a-google-map
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 https://github.com/google/open-location-code
2. https://developers.google.com/maps/documentation/geocoding/overview
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