Centering the 'map' component on the user's GPS position

[tomtomkratos]

Hi,

Is it possible to center the 'map' component on the user's GPS position, specifically on their Android device ? Ideally, I'd love to add a marker that says "You are here!!!"—if you know what i mean.

I’ve tried using JavaScript to retrieve the latitude and longitude values from the browser, but without success. I’m not sure if there’s a solution for this.

Thanks for your help!

[lovasoa]

Hi !
There is nothing built into sqlpage for that, but you could do it yourself in javascript. For instance:

select 'shell' as component, 'geo.js' as javascript;

select 
    'map' as component;
select 
    'You are here' as title,
    $lat  as latitude,
    $lng  as longitude;

geo.js

navigator.geolocation.getCurrentPosition((position) => {
  const s = new URLSearchParams(window.location.search);
  if (s.has("lat")) return;
  s.set("lat", position.coords.latitude);
  s.set("lng", position.coords.longitude);
  window.location.search = s;
});

[lovasoa]

Screencast.From.2025-10-20.23-39-46.mp4

[tomtomkratos]

Hello, and thank you so much for your help!
Indeed, it works, and it’s great!

However, I get the impression that it only works on the PC where SQLpage is running. Is that possible?
On another PC, when connecting via the correct URL, it doesn’t work.
Nor does it work on an Android device.
I’ll check if there are any security settings to enable in the browsers on these machines.

If you have any ideas, I’d love to hear them. And thank you again for your invaluable help!

[lovasoa]

Hi !

I suppose you are connecting from another device over an unencrypted http connection. Browsers refuse to give geolocation access to pages served over an unencrypted connection. See https://developer.mozilla.org/en-US/docs/Web/API/Geolocation_API#security_considerations and https://developer.mozilla.org/en-US/docs/Web/Security/Secure_Contexts

If you connect from another device over https, it should work. If you deploy to your datapage.app instance, it will work, since we handle https for you.

[tomtomkratos]

Ok, I understand better now, thank you.
SQLPage is connected to a Spatialite database. So I’d need to configure HTTPS on my SQLPage server. But I have to admit, it doesn’t look easy."

[lovasoa]

It's easy if you do it on datapage.app ! You just put your code on the server and you're done.