Hi Community,

I have a road network where roads are defined in road classes (1-5). While comparing the road from two different geometries(local and client), I need to upgrade my road network on the basis of client's road class.

In the image attached, the yellow lines are road class 4 and grey ones are road class 5. So, I need to upgrade road class 5 to class 4.

In the image shared, the one selected road element (in cyan), needs to be upgraded from the top (hanging geometry) to till the yellow line in the down south, and rest all data remains same.

In other situations, one side of the road can be a hanging geometry, so the road selection can be unidirectional to bidirectional. But, the upgradations has to be limited to only one road class update (4 to 3, 3 to 2 etc.,) This is because road class 1 (road of international importance) can directly only be connected to class 2(national/regional importance) and so on.

So there has to be a chaining logic where I can select the road elements of same road class that needs to be upgraded to a higher one.

I've tried recursive python scripts to perform this but no luck.

Any idea of how can we do this with FME/SQL/Python. Sharing a sample dataset.

Thanks.