I want to import GeoJSON data into MySQL to compare performance with other databases. Is there any way I can import following data into MySQL. And if it possible, how to create table for such records.
{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Point","coordinates":[-122.085823,37.386337]},"properties":{"id":"1","name":"Frankie Johnnie & Luigo Too","address":"939 W El Camino Real, Mountain View, CA"}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-122.083237,37.387138]},"properties":{"id":"2","name":"Amici's East Coast Pizzeria","address":"790 Castro St, Mountain View, CA"}},{"type":"Feature","geometry":{},"properties":{"id":""}},{"type":"Feature","geometry":{},"properties":{"id":""}}]}
أكثر...
{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Point","coordinates":[-122.085823,37.386337]},"properties":{"id":"1","name":"Frankie Johnnie & Luigo Too","address":"939 W El Camino Real, Mountain View, CA"}},{"type":"Feature","geometry":{"type":"Point","coordinates":[-122.083237,37.387138]},"properties":{"id":"2","name":"Amici's East Coast Pizzeria","address":"790 Castro St, Mountain View, CA"}},{"type":"Feature","geometry":{},"properties":{"id":""}},{"type":"Feature","geometry":{},"properties":{"id":""}}]}
أكثر...