1

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?


Solved

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

closed as off-topic by AndreJ, mgri, PolyGeo Sep 11 '17 at 6:21

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This problem cannot or can no longer be reproduced. Changes to the system or to the asker's circumstances may have rendered the question obsolete, or the question does not include a procedure to enable potential answerers to reproduce the same symptoms. Such questions are off-topic as they are unlikely to help future readers, but editing them to include more details can lead to re-opening." – AndreJ, mgri, PolyGeo
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Please Edit the question to specify the software you are using. – Vince Sep 10 '17 at 21:02
  • I'm guessing you're using Qgis? Anyhow, I'd double check your input lat/lon coordinates. If I'm reading that error correctly, a point at (0 917, -2.248) would be outside the bounds of EPSG3005. It'd be very far away from BC or western Canada. – scabecks Sep 10 '17 at 21:04
  • All of my points are something like 52.28350, -128.30752, and only the decimals change. There is nothing even remotely close to the point described in the error message – CEdwards Sep 11 '17 at 1:31

Browse other questions tagged or ask your own question.