Give an example of a GIS Enabled DBMS application where you

Give an example of a GIS Enabled DBMS application where you input coordinates to find how to go from one point to another in MySQL.

Solution

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 that manage spatial data.

Following the OGC specification, MySQL implements spatial extensions as a subset of the SQL with Geometry Types environment. This term refers to an SQL environment that has been extended with a set of geometry types. A geometry-valued SQL column is implemented as a column that has a geometry type. The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values.

MySQL spatial extensions enable the generation, storage, and analysis of geographic features:

The data types and functions are available for MyISAM, InnoDB, NDB, and ARCHIVE tables.

A geographic feature is anything in the world that has a location. A feature can be:

Geometry is another word that denotes a geographic feature. Originally the word geometry meant measurement of the earth. Another meaning comes from cartography, referring to the geometric features that cartographers use to map the world.

MySQL GIS Conformance and Compatibility

MySQL has data types that correspond to OpenGIS classes. Some of these types hold single geometry values:

A MultiPoint is a geometry collection composed of Point elements. The points are not connected or ordered in any way.

MultiPoint Examples

MultiPoint Properties

Consider the following example;

We have a database of houses that have geolocation data (longitude & latitude).

We want to do is find the best way to store the locational data in my MySQL.

Right now, database schema is;

---------------------

Homes  

---------------------

geolat - Float (10,6)

geolng - Float (10,6)

---------------------

And query is:

SELECT ...

WHERE geolat BETWEEN x1 AND x2

AND geolng BETWEEN y1 AND y2

Thank you.