It is very easy to also use MySQL Workbench and the new GeoJSON support to actually show the features.
My query:
SELECT ST_GeomFromGeoJSON(feature->"$.geometry",2) AS feature
FROM test_features WHERE street='BEACH' ;
The result:
Saturday, March 12, 2016
Re: JSON document fast lookup with MySQL 5.7
This is a response to the JSON document fast lookup with MySQL 5.7 article by Frederic Descamp.
It is very easy to also use MySQL Workbench and the new GeoJSON support to actually show the features.
My query:
SELECT ST_GeomFromGeoJSON(feature->"$.geometry",2) AS feature
FROM test_features WHERE street='BEACH' ;
The result:
It is very easy to also use MySQL Workbench and the new GeoJSON support to actually show the features.
My query:
SELECT ST_GeomFromGeoJSON(feature->"$.geometry",2) AS feature
FROM test_features WHERE street='BEACH' ;
The result:
Subscribe to:
Post Comments (Atom)
This is extremely helpful info!! Very good work. Best Dishwasher Under 400
ReplyDeleteThis article was written by a real thinking writer without a doubt. I agree many of the with the solid points made by the writer. I’ll be back day in and day for further new updates. 토토
ReplyDelete