I have sifted through all the help files I can find, and nothing seems to fix my problem. I am using Qgis. I want to go from an excel file of lat/long to points, and then re-project those points from ESPG4326,WGS84 to ESPG3005,NAD83/BCAlbers
My data is 3 columns: ID LAT LONG. I exported it as a .csv file and set the CRS to ESPG4326,WGS84. The csv file imports fine. I saved the points as a new shapefile. Then when I try to "save-as" and set the CRS to ESPG3005,NAD83/BCAlbers I get an error code (see below). If I "save as" and set the extent to "current layer" it creates a new shp file but when I load it nothing appears on the map. If I try "reproject" from the processing toolbox I get a unhelpful error code (while in the log window it just says "See log for more details").
I do not understand why it will not reproject to BCAlbers
[Export to vector file failed. Error: Failed to transform a point while drawing a feature with ID '0'. Writing stopped. (Exception: forward transform of (0.916998, -2.248506) PROJ.4: +proj=longlat +datum=WGS84 +no_defs +ellps=WGS84 +towgs84=0,0,0 +to +proj=aea +lat_1=50 +lat_2=58.5 +lat_0=45 +lon_0=-126 +x_0=1000000 +y_0=0 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs Error: latitude or longitude exceeded limits)]
My basemap is in NAD83/BCAlbers. If I set the project properties to OTF BCALbers it opens fine, but when I add in the WGS84 point file it is not visible. If I open the basemap without setting the project properties it is shown as WGS84 (and looks really wonky) and the point file opens but is way far away. If I then set the project properties to BCAlbers the basemap reprojects fine but the point file disappears.
How do I reproject the original WGS84 point file so it will display on my basemap?
For the sake of someone else doing this stupid mistake. It has to do with the difference in the ordering of LAT LONG and X Y
When we write latitude and longitude we always do it in that order. But when you import a CSV file into qGIS it asks for the header name to assign to X and Y. Which means that you just put longitude in the X drop down menu, and latitude in the Y drop down menu. If you mix them up because you are not paying attention, then a series of unfortunate events ensues