I also have a SHAPEFILES of Canadian Federal Election Ridings
I wish to update the EXCEL such that it would identify the Federal riding of the city based upon the Latitude-longitude coordinates Example of update below.
I suspect that QGIS would have the algorithm to identify federal ridings
The EXCEL has over 30,000 locations.... so automation is a must.
I'm getting BLANK returns. See below I'm getting: Major city latitude longitude FED_NUM NID FEDNUM ENNAME.. .etc but no mapping of a city to a Federal riding.
When I import the CITY EXCEL file and the Federal riding SHAPEFILE.. i can see the City dots over the various SHAPEFILEs... but it does not connect the City to the riding.