Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Active Member
Peter65
Posts: 8
Registered: ‎08-10-2006
Message 1 of 7 (134 Views)

Highlight selected MySQL objects

134 Views, 6 Replies
10-01-2006 12:21 PM
Hi @all,

and thanks for creating this group :-).

Here my first question. Sorry for cross post (OSGeo) but the following problem is unsolved:

I've loaded geometry objects from MySQL database. The connection to the database is possible. Also the geometry is shown. But when I select one line, all lines of the layer are highlighted. Interesting is, that the tooltip works correctly.

Here is a code example for inserting the lines into MySQL:

insert into tra_strasse_geometrie(strageo_geo, strageo_name_id) Values (geomfromtext('linestring(4531094.71 5686671.65,4531027.17 5686674.21)'), 7);

The table "tra_strasse_geometrie" is of MyISAM type and the row "strageo_geo" is of type GEOMTERY with index.

I'm using MySQL 5.0.24, MGOS 1.0.1, MG Studio 1.0.0, AJAX viewer.

Sorry, but I'm new with MGE and MySQL too.

Thanks in advance.

Regards - Peter
Active Member
Peter65
Posts: 8
Registered: ‎08-10-2006
Message 2 of 7 (134 Views)

Re: Highlight selected MySQL objects

11-27-2006 05:07 AM in reply to: Peter65
Hi @all,

after installing SP1 for the studio and using MGOS 1.0.2, a part of the problem is solved. But only a part: selecting an object leads to highlighting it.

But now I have an other problem. The selection is sometimes not correct. I want say, moving the cursor over one object, the tool shows the information of an other object an select and highlight the other object.

Can anybody help?

Thanks in advance - Peter
*James Card
Message 3 of 7 (134 Views)

Re: Highlight selected MySQL objects

11-27-2006 10:55 AM in reply to: Peter65
On Mon, 27 Nov 2006 05:07:05 -0800, Peter65 wrote:

> But now I have an other problem. The selection is sometimes not correct.
> I want say, moving the cursor over one object, the tool shows the
> information of an other object an select and highlight the other object.

Probably not much help, but we have a dataset that exhibits similar
behavior. The zoom-to function zooms to and selects the correct feature,
but the report in the Properties pane displays data for an adjacent
feature (which always has a key value that is one greater or less than the
key for the selected object).

This can be seen at < ="">, do an address
search (for "1040" as an example) and then zoom to various parcels in the
result set. For example, zooming to 1040 Monterra Ln produces a report for
1119 DeMoll Dr.

--
James Card
Active Member
Peter65
Posts: 8
Registered: ‎08-10-2006
Message 4 of 7 (134 Views)

Re: Highlight selected MySQL objects

11-28-2006 12:28 AM in reply to: Peter65
Thanks for reply. What FDO are you using. I ask, because I have this behavior with MySQL. When I use the same geometry from shape-files, then it works fine.

Best regards - Peter
*James Card
Message 5 of 7 (134 Views)

Re: Highlight selected MySQL objects

11-28-2006 08:58 AM in reply to: Peter65
On Tue, 28 Nov 2006 00:28:51 -0800, Peter65 wrote:

> Thanks for reply. What FDO are you using. I ask, because I have this
> behavior with MySQL. When I use the same geometry from shape-files, then
> it works fine.

Data was originally shapefiles, but we had MapGuide Studio convert it to
SDF when it was loaded into the repository.

--
James Card
Active Member
Peter65
Posts: 8
Registered: ‎08-10-2006
Message 6 of 7 (134 Views)

Re: Highlight selected MySQL objects

11-29-2006 12:32 AM in reply to: Peter65
With shapefiles I had no problems (exported from Autodesk MAP). Only with MySQL.

However I found a first solution :-). Yesterday I installed the dwf-viewer and it works fine :-)!!! Perhaps this could help you too?

Best regards - Peter
Contributor
Reshma
Posts: 12
Registered: ‎02-17-2008
Message 7 of 7 (134 Views)

Re: Highlight selected MySQL objects

02-20-2008 03:08 AM in reply to: Peter65
i think till now you will beccome master in mysql and mapguide studio and data connectivity bt i don't know anything about connectivity ,please guide me .what is procedure of data connection
thanks
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.