I have two large CSV files, one that defines the location of each point as:
And another that has data on what lines exist between them
|point A||point B||attribute 2||attribute 3|
Since the second CSV does not have lat/lon coordinates, I cannot map them. I've considered using
LINESTRING, but the dataset is too big to manually compute the linestring between 2 points.
Is there any way to 'assign' the coordinates from the first CSV to the second?