I've got two data sets with some commonality in length data, one coming from KMZ (S1) and one a csv with no spatial data (S2). I would like to merge the datasets.
S1 stores lengths as stationing with start and stop (St. 0, End 100)
S2 stores lengths as stationing but more granular (St 0, End 25 etc)
My first thought is to try and split stationing from S1 to match S2 then merge the geometry to S2 since that has the data I want to keep but I'm wondering if there is a way to do this I haven't come across yet.
Any Ideas?