You are not logged in.

Announcement

*** NOTICE: forum.openstreetmap.org is being retired. Please request a category for your community in the new ones as soon as possible using this process, which will allow you to propose your community moderators.
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***

#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: 295

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,918

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,754

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