I have 2 csv files both with 3 columns: variable, lat, lon.
Let's call them file A and file B. File A has 100 values for variable (in this case city), File B has 100,000 values for variable (station numbers in this case).
The goal is to assign a city (from file A) to every station number (from file B). So for each city, I will have a station number which is the closest station number to that city (by euclidian distance using latitude longitude).
Does anyone know how I can do this? I've looked at using Nearest but that doesn't seem like what I'm looking for.
I can use ArcPy also if that helps, but I'm not too experienced in ArcGIS.