Hi!, i'm working in a project where a i need to store in my mysql database, information about points from routes and other single points of interest.
The number of routes and points could grow faster. In this moment I have a table to store information about points with his corresponding lalitude and longitude in decimal(10,6) format.
The idea is show this information inside a map (OpenStreetMap / Leaflet API) in my portal
I am a novice at Maps topic, i have been reading some information about Mysql geospatial extension, but i don't understand how i can improve my application using this extension. Another alternative, is store routes in GeoJson documents and accesing them directly.