Translation TOP10 to GeoGraphics requires a template database where all relationships between feature geometry and attributes are predefined. They are kept in the UGJOIN_CAT table and called long-term table joins. The rest of the GeoGraphics projects should be set up as usually. Then we run the workspace gml2ggAll.fmw, which creates a dgn file and two tables within the database for each feature type, which may have more than one geometry per feature type. Tables directly connected to features contain only gml_id and gml_geometry_property, and separate tables contain all the attributes.

User-added image

In order to get these attributes while reviewing features, we have to do the following - after the project is opened, we go to the menu 'Database'-> 'SQL Query Builder'. In the 'Visual SQL Query Builder' menu we call 'Tables' -> 'Read Join Table', 'Select Join Table' appears. There we pick a join (for example, 'wegdeel.gml_id - wegdeeldata.gml_id'). This will bring a query to the 'SQL Select Statement' text box of the 'Visual SQL Query Builder' dialog. We should add an asterisk (*) after Select in order to get the following statement:

SELECT *
FROM WEGDEEL,WEGDEELDATA
WHERE WEGDEEL.gml_id = WEGDEELDATA.gml_id
And press 'Execute'.

This will call a form ('Wegdeel' in our example) with all the attributes from two tables. With 'Review' button we can review attributes of all the features. Editing values and pressing 'Update' button will change the record, and this will be reflected on all features with the same gml_id - for example, centerline, road edges and road polygon because they all are pointed to the same record in wegdeeldata table.

User-added image

The workspace gg_mdb2gml.fmw is used for translation back to TOP10.

The workspaces in the attachment section were tested with the build 2576.

Note, that the attached examples will work with the Relay example file. Some of the feature types were not presented in that file, and they didn't get into the gg_mdb2gml.fmw workspace. The attached examples illustrate the technique applied to GeoGraphics, and should be used with care - some modification may be required to work with another datasets and in all cases path information will need to be corrected.