MySQL Space extension Vspostgis

Source: Internet
Author: User
Tags postgresql postgis

Function

Mysql Spatial Extension

PostGIS

Spatial index

MyISAM only supports R-Tree indexing, InnoDB does not support

Gist Tree Index (variant of R-Tree)

Type of space supported

Only two-D data

Two-dimensional, three-dimensional and curve

Space Operation function

Finite space function

Basic realization of OGC standard defined space operation function

For example: To find points within a blue polygon, the MySQL space extension can only detect points within the smallest outsourced rectangle (red box), and PostGIS can detect points within a freeform polygon.

#FormatImgID_0 #

Space projection

does not support

supports a variety of common projection coordinate systems

For example: To find the distance between two points. MySQL spatial can only compute Euclidean space distances, while PostGIS can calculate real space distances under different projection coordinates.

Transaction support

does not support

PostGIS provides a range of long transaction support that can effectively support complex spatial analysis functions

Query efficiency

Load speed: MySQL > PostGIS (Transaction)

Spatial index creation: MySQL < PostGIS (diff split Algo)

Query: MySQL PostGIS (different nature of the query results, vary)

GIS system use

Use less

Use more, such as OpenStreetMap database background is Postgresql+postgis

Summary: If you only do some simple GIS or lbs application, the spatial extensions provided by MySQL can be basically satisfied. But if the required functionality is more complex, MySQL spatial extensions may not be able to provide enough functionality, and Postgresql+postgis may be more appropriate.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.