Converting between GeoJSON documents and spatial values with MySQL 5.7


Need to convert between GeoJSON documents and spatial values? MySQL 5.7 has two functions that do just that. GeoJSON is an open standard for encoding geometric/geographical features. ST_AsGeoJSON generates a GeoJSON object from the geometry while ST_AsText parses a string str representing a GeoJSON object and returns a geometry.

Details at Spatial GeoJSON Functions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s