Page 1 of 1

Creation of Highways - Broken Routes

Posted: Mon 13 Nov 2023 10:00 pm
by Rejsyg
After following the guide on highway creation. I have noticed my highways are broken at certain intersections:
Image
Image

What could be causing this? I did create new intersections with the SQL statements afterwards.

Image
Image

Re: Creation of Highways - Broken Routes

Posted: Tue 14 Nov 2023 8:59 pm
by IV/JG7_4Shades
Hmm, curious. Well, anyway, if your routes don't overlap you can always edit the corresponding data in the Highways table and correct any glitches (then re-run the Highway_Intersections SQL query).

Are you capturing data for a new map?

Cheers
4S

Re: Creation of Highways - Broken Routes

Posted: Tue 28 Nov 2023 8:10 pm
by Rejsyg
I think I may have found the issue with the broken highways, the spreadsheet was not converting waypoints that I placed, but kept the lines ending either 20 and 120. Used some regex to remove that unnecessary data after the Z coordinate.
Image

But now the intersections are still sending my units in the complete opposite direction, all converging on one point. I need to take another look at the intersection SQL and re-run it.
Image

IV/JG7_4Shades wrote: Tue 14 Nov 2023 8:59 pm Are you capturing data for a new map?
I am capturing data for the Philippines map V2 by Delvpier. The map had some existing highways from the provided template in the SEDB75.zip but it was missing several roads and had no bridges. I decided to overhaul the map, including recreate all the ACHS for dogfight mode and add a new airfield as well as other industrial installations.

Re: Creation of Highways - Broken Routes

Posted: Wed 29 Nov 2023 9:29 am
by IV/JG7_4Shades
The way I do it is to start each route either at a road terminus (rare) or at a junction, then end the route at the next junction or terminus.
Using the snap feature in FMB helps to put your waypoints onto the 100 m grid, but this can be done in a spreadsheet or sql anyway.

Without seeing all your data it is hard to comment. My best guess based on experience is that perhaps you have defined a route that passes through a junction without stopping. That is definitely forbidden. Of course there may be other explanations for your symptoms.

Cheers
4S