[MDEV-5813] Geometry enhancements. Created: 2014-03-11  Updated: 2017-03-22

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Alexey Botchkov Assignee: Alexey Botchkov
Resolution: Unresolved Votes: 6
Labels: gsoc14, gsoc15, gsoc16, gsoc17


 Description   

1. Add altitude coordinate.
That involves adding 3-rd coordinate to the points in geometry and
implementing the set of functions to operate with it.

2. Convertors.
There is a lack of functions in MariaDB to export and import data
from/to various spatial data formats. So we need to implement functions
as
ST_GeomFromEWKB - ST_AsEWKB
ST_GeomFromGML - ST_AsGML
ST_GeomFromGeoJSON - ST_AsGeoJSON
ST_GeomFromKML - ST_AsKML

3. Getting data from SHP format.
It's good to have domesticated shp2sql convertor as
a separate tool and same functionality available inside the server
as the MariaDB SQL command.

 Comments   
Comment by honam bang [ 2014-03-14 ]

Hi !!
I'm a student who will join in GSOC 2014, and I'm interested in this idea. I want to be corrected my draft rather than directly submitting my proposal, so who can I contact with?

Comment by Delveri Chick [ 2015-03-13 ]

Hi
I am Chick Delveri and interested in this task.
Im aware the project requires us to add support for a 3rd coordinate in storage but will this require creating a new Geometry class say GEOMETRY_M or maintain the current class by adding it directly to sql/spatial.** and writing functions to retrieve it like Z(PointFromText('POINT('x y z'))) ?
My worry is we could have a column that contains 2D and 3D data mixed.
Can someone clarify this for me?

Comment by Alexey Botchkov [ 2015-03-17 ]

No, the mixed 2D and 3D points shouldn't be stored in one column.

Comment by Delveri Chick [ 2015-03-17 ]

Hi Alexey
In that case i think a possible implementation could be creating new
Geometry types like Point(x,y,z) from the parent GEOMETRY class to
distinguish it from the current subclass Point(x,Y) and implementing
function like GeomFromEWKT() to operate with it.
or do we redefine a new Geometry hierachy ?

2015-03-17 10:50 GMT+01:00 Alexey Botchkov (JIRA) <

Comment by Josh Racktansky [ 2016-05-14 ]

Hello. Is this going to be implemented in this millenia? It's the main reason why we're stick to the Oracle's MySQL.

Comment by Sergei Golubchik [ 2016-05-16 ]

Yes, in one of the future releases.
But it is not planned for 10.2 at the moment.

Comment by Ryan Kerr [ 2017-03-21 ]

Hi, I am Ryan Kerr a MS Computer Informations Systems student at RWTK University and I wish to work on this project for GSoC 2017. I have studied the current geometry hierarchy in sql/spatial.xx and will write a draft proposal for this project. Are there other students already working on this task?

Comment by Sergei Golubchik [ 2017-03-22 ]

ryankerr, great! No, nobody else at the moment. See the GSoC17 KB page — it lists number of interested students for every task

Generated at Thu Feb 08 07:07:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.