1
vote
0answers
24 views

how manage mysql spatial polygons in parent child style

I want to store location-polygon data in a parent-child relation. I am using spatial data in MySQL and Google map for polygon. Eg: World 1.1 US 1.2 China 1.3 Japan 1.4 South Africa 1.4.1 Pretoria ...
2
votes
1answer
221 views

Large loads geojson from mysql to leaflet?

I have a mysql database with +25K rows including geometry and other attributes. Using a mysql2geojson php script I then added it to a leaflet map. It is super slow now, what can I do to boost the ...
4
votes
3answers
2k views

MySQL to GeoJSON - Formatting Issue

I'm trying to make a select on a mysql table and then write it out to a geojson file. I'm getting close but there are a few issues. Here's what I have so far: <?php require("dbinfo.php"); // ...