[mapguide-users] MGOS 3.1.1 - SQL Spatial Layers - Cannot select point layers by click on it or see the tooltip

[Jose M. C. Marques]

Hi,

I've upgraded to version 3.1.1 and notice a problem in ajax viewer.
I cannot select any point layers element just by clicking on it, the only way is to draw a rectangle, but in this way I'm selecting all the objects and not the one I want.
I also cannot see any tooltip on point layers, even if I turn off all the layers below this one.
I have no problem with polygon layers.

Anyone with this problem? Is there a fix?

Thanks,
Jose

[Benoit Begin]

Hi Jose,

The one thing I can think of is if the point layer stores data in geography
columns versus geometry. That is one of the reason I have had issues with
Mapguide on SQL Server.

Basically the directionality of the selection matters and it has to be
counter-clockwise. When the selection is drawn clockwise, it appears to
count as the "hole" in a "donut" polygon. Sorry for the weird description,
it'd be easier to draw it out!

So if you use a geometry type, that shouldn't be a problem.

The second possible issue would be not having a properly defined primary
key, such as going against a view. That is one way SQL Server can prove a
bit difficult to deal with in Mapguide sometimes. However, since selection
works sometimes in your case, that is likely not the reason.

Hopefully it's simply a matter of switching the data type on your spatial
column.

Regards,

Ben



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html

[Jose M. C. Marques]

Hi Ben,

Thanks for your suggestions, but all my layers have a primary key and I use geometry column.

I've found the problem, I create a new map and saw what was automatically filled and then when I checked my updated map I noticed that all the Map Advanced Settings fields was empty ("Selection Color", "Point Selection Buffer", "Map Image Format" and "Selection Image Format").
I put the values in that fields and everything is working as expected now.
I think that the empty "Point Selection Buffer" was the problem.

Thanks,
Jose

-----Original Message-----
From: mapguide-users <mapguide-users-***@lists.osgeo.org> On Behalf Of Benoit Begin
Sent: 19 de setembro de 2018 20:06
To: mapguide-***@lists.osgeo.org
Subject: Re: [mapguide-users] MGOS 3.1.1 - SQL Spatial Layers - Cannot select point layers by click on it or see the tooltip

Hi Jose,

The one thing I can think of is if the point layer stores data in geography columns versus geometry. That is one of the reason I have had issues with Mapguide on SQL Server.

Basically the directionality of the selection matters and it has to be counter-clockwise. When the selection is drawn clockwise, it appears to count as the "hole" in a "donut" polygon. Sorry for the weird description, it'd be easier to draw it out!

So if you use a geometry type, that shouldn't be a problem.

The second possible issue would be not having a properly defined primary key, such as going against a view. That is one way SQL Server can prove a bit difficult to deal with in Mapguide sometimes. However, since selection works sometimes in your case, that is likely not the reason.

Hopefully it's simply a matter of switching the data type on your spatial column.

Regards,

Ben

[Jose M. C. Marques]

Just to clarify, the Advanced Settings that was missing is located in the Web Layout and not in the Map as I mentioned before.

Thanks,
Jose

-----Original Message-----
From: Jose M. C. Marques
Sent: 20 de setembro de 2018 11:41
To: 'MapGuide Users Mail List' <mapguide-***@lists.osgeo.org>
Subject: RE: [mapguide-users] MGOS 3.1.1 - SQL Spatial Layers - Cannot select point layers by click on it or see the tooltip

Hi Ben,

Thanks for your suggestions, but all my layers have a primary key and I use geometry column.

I've found the problem, I create a new map and saw what was automatically filled and then when I checked my updated map I noticed that all the Map Advanced Settings fields was empty ("Selection Color", "Point Selection Buffer", "Map Image Format" and "Selection Image Format").
I put the values in that fields and everything is working as expected now.
I think that the empty "Point Selection Buffer" was the problem.

Thanks,
Jose

-----Original Message-----
From: mapguide-users <mapguide-users-***@lists.osgeo.org> On Behalf Of Benoit Begin
Sent: 19 de setembro de 2018 20:06
To: mapguide-***@lists.osgeo.org
Subject: Re: [mapguide-users] MGOS 3.1.1 - SQL Spatial Layers - Cannot select point layers by click on it or see the tooltip

Hi Jose,

The one thing I can think of is if the point layer stores data in geography columns versus geometry. That is one of the reason I have had issues with Mapguide on SQL Server.

Basically the directionality of the selection matters and it has to be counter-clockwise. When the selection is drawn clockwise, it appears to count as the "hole" in a "donut" polygon. Sorry for the weird description, it'd be easier to draw it out!

So if you use a geometry type, that shouldn't be a problem.

The second possible issue would be not having a properly defined primary key, such as going against a view. That is one way SQL Server can prove a bit difficult to deal with in Mapguide sometimes. However, since selection works sometimes in your case, that is likely not the reason.

Hopefully it's simply a matter of switching the data type on your spatial column.

Regards,

Ben