MySQLSpatial

Introduction

MySQL is most popular open source relational database. Starting with MySQL 4.1, the database supports the generation, storage, and analysis of geographic features. MySQL implements (spatial extensions)[https://dev.mysql.com/doc/refman/4.1/en/spatial-extensions.html] following the specification of the Open Geospatial Consortium (OGC).

Configuration

This section describes configuration parameters used in MySQLSpatial data source provider. They are:

Parameter NameValue TypeDescriptionRequired
ConnectionStringDefines the string used to open a MySQL Server database.Yes
GeometryColumn (or GeometryField)StringDetermines a spatial column that contains data of a spatial data type (e.g., geometry or geography).Yes
QueryStringThe query used to select data from a database.Yes
ExtentStringSets the extent of spatial data in a table. It is used by MapSurfer.NET Studio to speed up Zoom To Layer function.No

NOTE

OGR is another data source provider that can access spatial data from MySQL Server.