DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) mysql-spatial-datatypes

Info Catalog (mysql.info) creating-a-spatially-enabled-mysql-database (mysql.info) creating-a-spatially-enabled-mysql-database (mysql.info) creating-spatial-values
 
 16.4.1 MySQL Spatial Data Types
 -------------------------------
 
 MySQL has data types that correspond to OpenGIS classes. Some of these
 types hold single geometry values:
 
    * `GEOMETRY'
 
    * `POINT'
 
    * `LINESTRING'
 
    * `POLYGON'
 
 `GEOMETRY' can store geometry values of any type. The other
 single-value types (`POINT', `LINESTRING', and `POLYGON') restrict
 their values to a particular geometry type.
 
 The other data types hold collections of values:
 
    * `MULTIPOINT'
 
    * `MULTILINESTRING'
 
    * `MULTIPOLYGON'
 
    * `GEOMETRYCOLLECTION'
 
 `GEOMETRYCOLLECTION' can store a collection of objects of any type. The
 other collection types (`MULTIPOINT', `MULTILINESTRING',
 `MULTIPOLYGON', and `GEOMETRYCOLLECTION') restrict collection members
 to those having a particular geometry type.
 
Info Catalog (mysql.info) creating-a-spatially-enabled-mysql-database (mysql.info) creating-a-spatially-enabled-mysql-database (mysql.info) creating-spatial-values
automatically generated byinfo2html