[MDEV-4045] Missing OGC Spatial functions Created: 2013-01-15  Updated: 2015-01-27  Due: 2014-11-26  Resolved: 2014-11-28

Status: Closed
Project: MariaDB Server
Component/s: GIS
Fix Version/s: 10.1.2

Type: Task Priority: Critical
Reporter: Friedhold Matz Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: gis

Issue Links:
Relates
relates to MDEV-7509 Testing for GIS extensions Closed

 Description   

Hi,
I've tried the OGC Spatial demos today in '10.0.0-MariaDB' and
got some missing functions:

FUNCTION ogcdemo.IsRing
FUNCTION ogcdemo.PointOnSurface
FUNCTION ogcdemo.NumInteriorRing
FUNCTION ogcdemo.Relate
FUNCTION ogcdemo.Distance
FUNCTION ogcdemo.Intersection
FUNCTION ogcdemo.ConvexHull

I used the demo data and function checks from:
06-104r4_Implementation_Specification_for_Geographic_Information_Simple_feature_access_Part_2_SQL_option_v1.2.1

Does this functions not exist in MariaDB ?

Thanks
Friedhold

 Comments   
Comment by Alexey Botchkov [ 2013-01-16 ]

Some of these functions exist with SQL_MM names only:
ST_Distance()
ST_Intersection()

We have NumInteriorRings instead of NumInteriorRing, that's a bug.

Some are not in the 10.0 code yet, but ready to be pushed. These are:
ST_IsRing
ST_NumInteriorRing
ST_Relate
ST_ConvexHull

And finally PointOnSurface - doesn't exist and no plans at the moment to implement the Surface-related functions.

Comment by Friedhold Matz [ 2013-01-16 ]

Many thanks Alexey.

I've not checked the result yet: Does MariaDB handle the shapes and not
only the bounding boxes?

Friedhold.

2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>

Comment by Alexey Botchkov [ 2013-01-16 ]

New functions in MariaDB handle shapes, not the bounding boxes.
The limitation at the moment - it only handles plain coordinate system. Can't handle geodetic coordinates properly.(MDEV-60)

Comment by Friedhold Matz [ 2013-01-16 ]

Good News!!

Many thanks
Friedhold.

2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>

Comment by Friedhold Matz [ 2013-01-18 ]

Good News!

I will check and verify the spatial results.

So long,
Friedhold

2013/1/16 Alexey Botchkov (JIRA) <jira@mariadb.atlassian.net>

Comment by Sergei Golubchik [ 2014-04-17 ]

hf said it's almost ready to be pushed

Comment by Friedhold Matz [ 2014-04-18 ]

Hi Sergey,

many thanks.
Where can I find the download link for 10.1.0 ?

Best,
Friedhold.

Comment by Sergei Golubchik [ 2014-04-18 ]

10.1.0 is not released yet. We're discussing now what tasks will be in 10.1 and what tasks will be postponed to 10.2. But it looks like this task will be in 10.1, give it few more months, please, and you'll have a download link.

Comment by Friedhold Matz [ 2014-04-18 ]

Hi Sergei,

many thanks for your answer and let me know it.

2014-04-18 13:35 GMT+02:00 Sergei Golubchik (JIRA) <

Comment by Alexey Botchkov [ 2014-11-28 ]

Patch :
http://lists.askmonty.org/pipermail/commits/2014-November/007081.html

Generated at Thu Feb 08 06:53:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.