You are not logged in.

#1 2018-01-23 14:53:31

didou90
New Member
Registered: 2018-01-23
Posts: 2

OSM - MySQL

Hello,

I have a database that contains coordinates (location_id, location, log, lat) and I want to display all these points on openstreetmap

thank you for orienting me

Offline

#2 2018-01-23 16:23:30

TZorn
Member
From: Leverkusen
Registered: 2015-06-02
Posts: 700

Re: OSM - MySQL

Please check if uMap suits your needs.

Offline

#3 2018-01-23 20:54:09

alester
Member
Registered: 2011-09-21
Posts: 269

Re: OSM - MySQL

Offline

#4 2018-01-24 10:26:53

didou90
New Member
Registered: 2018-01-23
Posts: 2

Re: OSM - MySQL

Hello,

Also, I would like to add some SQL queries and show the results on the map ( not only show data on the map)

thanks in advance


Example :

http://map.datafrance.info/population

Offline

#5 2018-01-24 13:28:07

muralito
Member
Registered: 2012-09-04
Posts: 1,803

Re: OSM - MySQL

Hello didou90.

In the example map you linked, there is a link in the lower right corner "leaflet" that links to leaflet project.
In leaflet project search for the tutorial "Interactive Choropleth Map"

Offline

#6 2018-01-24 13:31:14

escada
Moderator
Registered: 2011-08-13
Posts: 1,684

Re: OSM - MySQL

You cannot show the result of an SQL directly on a map.
You will need to use a framework such as Leaflet do display map tiles with our own content.

Your content can be retrieved with e.g. a Ajax call to your server. There you will have Java / PHP / C .. programming running that respond to the Ajax call with the answer of your SQL query. The program could e.g. transform the SQL result in geoJson.

Sorry that I do not give you links to all those technologies, but it depends on your knowledge.

Offline

Board footer

Powered by FluxBB