Question

Which classes does spatial data types in MySQL correspond to?

(a) OpenGSS

(b) OpenGIS

(c) ClosedGSS

(d) ClosedGIS

This question was posed to me in a national level competition.

This is a very interesting question from Spatial Data Types topic in portion Data Type Reference, Operators and Functions of MySQL

Answer 1

The correct answer is (b) OpenGIS

To explain I would say: MySQL has spatial data types that correspond to OpenGIS classes. Some of them that hold single geometry values are ‘GEOMETRY’, ‘POINT’, ‘LINESTRING’ and ‘POLYGON’. Some can hold a collection of values.