Skip to main content
Question

How can I make relation among smallworld circuits in FME

  • December 11, 2018
  • 2 replies
  • 14 views
esaka
Participant
Forum|alt.badge.img
  • esakaParticipant
  • Participant
  • 15 replies

Hi everyone,

I have a good question that I tried to achieved but this is very difficult for me.

I have circuits in the smallworld database. This circuits have got a simple parent-child relationship. There are many circuits like this but there is no relation first circuit with 3th circuit. If I accept the first circuit is a parent, this parent related downstream circuit mean that its own child circuit. However this parent circuit doesn't have relation with its own child's downstream circuits.

I would like to make a relation among from first circuit to end....

 

I have got circuit_line as shape format and the related internal table as excel in the attached

You can consider and start from this parent id 46598749 circuit id =5018-OG-6002

 

Your browser does not support HTML5 video.

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.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • December 11, 2018

Could you use the PathBuilder (and generate a list from circuits it finds) or the ShortestPathFinder transformers?

Not sure, but we usually use Magik code in Smallworld for this kind of calculations.

esaka
Participant
Forum|alt.badge.img
  • esakaParticipant
  • Author
  • Participant
  • 15 replies
  • December 12, 2018

Thanks for suggestion @erik_jan.

Actually I tried to go with geometric approach but I realized that the Smallworld internal tables already keep the relation. I would like to use this internal tables and make a tree model like below image. All the circuits are connected as parent-child to the end.. By the way I replicated the smallworld database to postgis. what I want to do I will do in postgis. I am not sure, can I make a relationship without spatial functions.

 

Community Stats

32,083
Posts
121,831
Replies
39,718
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.