#34 identify tool with landmarks

[sammer]

Hello,

When using the identify tool to identify a landmark
some of the landmarks are beening identify correctly
but most of them are not, the first landmark in the
landmark table /landmark with the id=0/ is identifed
instead of the selected landmark, even that the
boundary of the wanted landmark is selected the identfy
table shows the first landmark.

[sammer]

Logged In: YES
user_id=1251979

This bug is caused because that the id field in the Landmark
table is not equal to GID field, it has NULL value.

The following SQL statement to update the id field should be
executed for the landmark table:

----------------------------
update landmark set id = gid
----------------------------

This SQL will fix the problem for the already existing
landmarks, but when new landmarks are added the id field is
NULL for them, so we will have the same bug again.

when inserting new landmark the id field should set to the
same value as gid field of the landmark.

[Maher Abdel Karim]

Logged In: YES
user_id=695149

Samer,
I think you should change the id field to be a serial
instead of integer. then the new records will be handaled.

[Steffen Macke]

Logged In: YES
user_id=30248

I hope that we can agree that the proper solution is to only
use either the gid field or the id field.

I don't think that changing the type of the ID field is
practical because the table is frequently loaded via the
shapefile loader.

[sammer]

Logged In: YES
user_id=1251979

Currently the ID field should have the same value as GID
field is the system to work probably, because as steffen
mentioned the id field is used some time and the gid is used
other times, only one of them should be used.

I think we should use GID field only.

[Steffen Macke]

Logged In: YES
user_id=30248

Looks reasonably to me.
Please perform a code review and also change the
data model.

[Steffen Macke]

Logged In: YES
user_id=30248

Any news regarding this issue?
Could you test again using version 1.1.1?

[Steffen Macke]

Logged In: YES
user_id=30248

I think that this is a mapfile problem and therefore change
this to a support request.
Please check that you use a data statement like the following
in the map files:

DATA "the_geom from landmarkview using unique gid using SRID=-1"

and a result fields statement like the following:

"RESULT_FIELDS" "gid type name"

You may have to change from id to gid if id is used
in one of the statements.