Is their any document or link which can help us understand intergraph gtech electric data model.
Question
Is their any document or link which can help us understand intergraph gtech electric data model.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+8Hi @sandeepchettu, would this help for you, which is for me the base of the Intergraph component model:
select g3e_feature.g3e_fno
, g3e_feature.g3e_username
, g3e_feature.g3e_tooltip
, g3e_component.g3e_cno
, g3e_component.g3e_username
, g3e_component.g3e_table
, g3e_component.g3e_tooltip
, g3e_component.g3e_lrno
, g3e_component.g3e_type
from g3e_featurecomponent
inner join g3e_feature on g3e_feature.g3e_fno = g3e_featurecomponent.g3e_fno
inner join g3e_component on g3e_component.g3e_cno = g3e_featurecomponent.g3e_cno
order by g3e_component.g3e_cno;You might find more on this subject on this location.
Hi @sandeepchettu, would this help for you, which is for me the base of the Intergraph component model:
select g3e_feature.g3e_fno
, g3e_feature.g3e_username
, g3e_feature.g3e_tooltip
, g3e_component.g3e_cno
, g3e_component.g3e_username
, g3e_component.g3e_table
, g3e_component.g3e_tooltip
, g3e_component.g3e_lrno
, g3e_component.g3e_type
from g3e_featurecomponent
inner join g3e_feature on g3e_feature.g3e_fno = g3e_featurecomponent.g3e_fno
inner join g3e_component on g3e_component.g3e_cno = g3e_featurecomponent.g3e_cno
order by g3e_component.g3e_cno;You might find more on this subject on this location.
I need to migrate data from integraph gtech to fgdb using FME,here using above query provided can i map feature to feature respectively.
+8Hi, that's An impressive job. You will probably start reading Oracle spatial and using g3e_geometry as geometry. You will need every component of the query above and translate it to fgdb feature. A SchemaMapper may come in handy for this, I suppose there is a large number of features to migrate? You could throw in another join to the g3e_attribute table to see field properties. Older versions use Oracle spatial relational. That is, IF your customer is using Oracle.