Infrastructure Map Server Forum
Welcome to Autodesk’s Infrastructure Map Server Forums. Share your knowledge, ask questions, and explore popular Infrastructure Map Server topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Highlight selected MySQL objects

6 REPLIES 6
Reply
Message 1 of 7
Peter65
352 Views, 6 Replies

Highlight selected MySQL objects

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
6 REPLIES 6
Message 2 of 7
Peter65
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
Message 3 of 7
Anonymous
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
Message 4 of 7
Peter65
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
Message 5 of 7
Anonymous
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
Message 6 of 7
Peter65
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
Message 7 of 7
Reshma
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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report