Image

8

GeoJSON

MySQL 5.7 offered several new features in addition to the JSON data type, including a vast improvement in geographic information system (GIS) support. MySQL follows the Open Geospatial Consortium (OGC) OpenGIS Implementation Specification for Geographic information - Simple feature access - Part 2: SQL option, which proposes extending the SQL RDBMS to support spatial data. MySQL also features functions for converting between spatial values and JSON and follows the GeoJSON specification (RFC 7946) located at http://geojson.org. GeoJSON supports the same geometric and geographic data types as MySQL.

ST_GeomFromGeoJSON

The ST_GeomFromGeoJSON ...

Get MySQL and JSON: A Practical Programming Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.