Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No SRID support #2815

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

No SRID support #2815

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2011-05-23 11:30:19 +0200
From: George Garbis <>
To: SQL devs <>
Version: -- development
CC: charnik, @yzchang

Last updated: 2016-06-23 10:24:08 +0200

Comment 15829

Date: 2011-05-23 11:30:19 +0200
From: George Garbis <>

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
Build Identifier:

I create a table with geometries and insert 2 points with different SRID.
When i ask for these SRID i get the same (0) for every point.
Also, if i ask whether these points overlap i don't get the right result.
I get 'true' while the points are totally different, considering their reference systems.

Reproducible: Always

Steps to Reproduce:

  1. sql>create table geom(id int, g geometry);
  2. sql>insert into geom values(1, GeomFromText('POINT(100 100)', 4326));
  3. sql>insert into geom values(2, GeomFromText('POINT(100 100)', 27700));
  4. sql>select id, srid(g) from geom;
  5. sql>select equals(g1.g, g2.g) from geom g1, geom g2 where g1.id=1 and g2.id=2;

Actual Results:

Results of steps 4 and 5 are:
4.
+------+--------+
| id | srid_g |
+======+========+
| 2 | 0 |
| 1 | 0 |
+------+--------+
5.
+-----------------+
| overlaps_g |
+============+
| true |
+------------+

Expected Results:

Results of steps 4 and 5 are supposed to be:
4.
4.
+------+--------+
| id | srid_g |
+======+========+
| 2 | 27700 |
| 1 | 4326 |
+------+--------+
5.
+-----------------+
| overlaps_g |
+============+
| false |
+------------+

I have noticed that function wkbFromText (in file geom/monetdb5/geom.mx), which is used in SQL functions GeomFromText, PointFromText e.t.c., returns a wkb datatype (defined in geom/lib/libgeom.mx) which has not any field for srid.

Is srid stored somewhere else (e.g. as metadata of a geometry collumn)?

Comment 15866

Date: 2011-07-01 09:56:41 +0200
From: @sjoerdmullender

It seems there is no support for storing the SRID into the database. For some reason the GET function was implemented, but since no value is stored, it always returns 0.

Comment 16041

Date: 2011-07-29 11:00:06 +0200
From: @sjoerdmullender

Apr2011-SP2 has been released.

Comment 16280

Date: 2011-09-16 15:10:40 +0200
From: @sjoerdmullender

The Aug2011 version has been released.

Comment 17684

Date: 2012-08-24 14:56:00 +0200
From: @sjoerdmullender

Jul2012-SP1 has been released.

Comment 18121

Date: 2012-11-27 15:30:20 +0100
From: @yzchang

No test for feature request

Comment 22028

Date: 2016-04-11 12:24:34 +0200
From: @sjoerdmullender

The upcoming Jun2016 release (whether or not it'll arrive in June 2016) will have support for SRID.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant