MySQL™: The World’s Most Popular Open Source Database 166 4.1: GIS / Geometric Data • OpenGIS: New data type ”Geometry” • CREATE TABLE geom (g Geometry, SPATIAL INDEX(g)); • INSERT INTO geom VALUES (GeomFromText( ’POINT(1 1)’)), (GeomFromText( ’POLYGON(0 0,10 0,10 10, 0 10, 0 0)’)); • New functions, e.g. AsText, IsClosed, Length, Area, Intersection, Intersects, Within • Red-black index trees: Indexes for Within Copyright 2003 MySQL AB