SRID set to 0 for points in MySQL

[spackmat]

Hi,

is it intended, that points are set with a SRID of 0 in MySQL (or maybe not set at all)?

When I save a new Point with a given SRID to the database, the SRID is always 0 afterwards.

Greets,
spackmat

[ddproxy]

@spackmat SRID is default to the specification of the database. There is an optional parameter after these methods (in postgis) that define the SRID if it's not set on the table already. There may also be a parameter to have the database warn/explode if no SRID is defined in the query - but I'm not our database administrator :S good luck

[djlambert]

Currently the MySQL code doesn't use the SRID value. This is something that'll need to be implemented.

[sadortun]

#156

[yurtesen]

Is there any news about if this will ever be implemented for MySQL? I am also interested in this feature.

[sadortun]

@yurtesen Your PR and contribution are most welcome ! The project is well used by many, i am sure many users will be happy to see SRID avalaibility !

[yurtesen]

@sadotun I decided to use postgresql after all. The GIS functions in MySQL were just very limited. I made PR for postgresql. However I am not good at doing the test stuff. I hope somebody completes that part :) works for me...

[holtkamp]

Note that without using proper SRID on columns, spatial indexes will not work on MySQL 8.x:

• https://mysqlserverteam.com/upgrading-to-mysql-8-0-with-spatial-data/
• https://mysqlserverteam.com/geographic-indexes-in-innodb/
• https://mysqlserverteam.com/upgrading-spatial-indexes-to-mysql-8-0/

Added support for ST_SRID() which allows setting the SRID of a Point: ST_SRID(Point(:longitude, :latitude), :srid) to my branch: https://github.com/holtkamp/doctrine2-spatial/tree/mysql-80-support

@djlambert can you consider merging it using #196 ?