11.5 Analysing Spatial Information

After populating spatial columns with values, you are ready to query and analyse them. MySQL provides a set of functions to perform various operations on spatial data. These functions can be grouped into four major categories according to the type of operation they perform:

• Functions that convert geometries between various formats
• Functions that provide access to qualitative or quantitative properties of a geometry
• Functions that describe relations between two geometries
• Functions that create new geometries from existing ones

Spatial analysis functions can be used in many contexts, such as:

• Any interactive SQL program, like mysql or MySQLCC
• Application programs written in any language that supports a MySQL client API

Subsections

• 11.5.1 Functions To Convert Geometries Between Formats
• 11.5.2 Geometry Property Analysis Functions
• 11.5.2.1 General Geometry Property Analysis Functions
• 11.5.2.2 Point Property Analysis Functions
• 11.5.2.3 LineString Property Analysis Functions
• 11.5.2.4 MultiLineString Property Analysis Functions
• 11.5.2.5 Polygon Property Analysis Functions
• 11.5.2.6 MultiPolygon Property Analysis Functions
• 11.5.2.7 GeometryCollection Property Analysis Functions
• 11.5.3 Functions That Create New Geometries From Existing Ones
• 11.5.3.1 Geometry Functions That Produce New Geometries
• 11.5.3.2 Spatial Operators
• 11.5.4 Functions For Testing Spatial Relations Between Geometric Objects
• 11.5.5 Relations On Geometry Minimal Bounding Rectangles (MBRs)
• 11.5.6 Functions That Test Spatial Relationships Between Geometries

User Comments

Add your own comment.