I have a road dataset from WA DOT and the roads are all pointing in the correct direction for mileposts based on my road log. This dataset only contains roads that are maintained by the county.
I have another dataset with all of the roads in the county, including county maintained, city, state and private, but the direction of these roads are all based on addressing and not mileposts.
I need to do a comparison between the two datasets so I can flip all of the roads in the second dataset to match the direction of the first dataset so I can use it for mileposts. (the second dataset has better linework than the first one so I want to use it).
The tables are different and some of the segments are different because the first dataset just has beginning and ending milepost but the second dataset is broken up at administrative boundaries so I cant just compare them all based on road number because the number of segments will be different.