Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/spatial-types.html
The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications ...This term refers to an SQL environment that has been extended with a set of geometry ...
https://dev.mysql.com/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...The table also has an AUTO_INCREMENT column fid for storing object ID ...
https://dev.mysql.com/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON GEOMETRY can store geometry values of any type. The other spatial data types hold collections of ...The basis for these types is described in Section 11.5.2, “The OpenGIS Geometry ...
https://dev.mysql.com/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/spatial-relation-functions-object-shapes.html
Functions in this section detect arguments in either Cartesian or geographic spatial reference systems (SRSs), and return results appropriate to the SRS. If any geometry argument refers to an undefined spatial reference system (SRS), an ... The ...
https://dev.mysql.com/spatial-reference-systems.html
A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial reference systems: A projected SRS is a projection of a globe onto a flat surface; that is, a flat map.
https://dev.mysql.com/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 11.5.10, “Creating Spatial Indexes”). The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to ...
https://dev.mysql.com/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes about spatial indexes under ...
https://dev.mysql.com/spatial-function-argument-handling.html
Spatial values, or geometries, have the properties described at Section 11.5.2.2, “Geometry Class”. The spatial reference identifier (SRID) of a geometry identifies the coordinate space in which the geometry is defined. Geometry values produced ...Specific functions or groups of functions may have additional argument-handling characteristics, as discussed in the sections where those function descriptions ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-spatial-p-1.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
