Jump to content
Wikibooks The Free Textbook Project

MySQL/Language/Spatial databases

From Wikibooks, open books for an open world

Principle

[edit | edit source ]

When typing the fields, some of them represent graphical objects, and so are considered like as "Spatial". Consequently, they are manipulated by some different request than for the text.

We distinguish eight fields types[1] :

  • Geometry
  • Point
  • LineString
  • Polygon
  • MultiPoint
  • MultiLineString
  • MultiPolygon
  • GeometryCollection

And six relations between them[2] :

  • Contains
  • Disjoint
  • Equals
  • Intersects
  • Overlaps
  • Within

Requests

[edit | edit source ]
This section is a stub.
You can help Wikibooks by expanding it.


References

[edit | edit source ]
  1. http://dev.mysql.com/doc/refman/5.0/en/spatial-datatypes.html
  2. http://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html

AltStyle によって変換されたページ (->オリジナル) /