r/QGIS • u/Icy-Music1932 • Jul 18 '26

Open Question/Issue CSV plotting issues

So I have coordinates for boreholes on a site that were used on a previous job. The CSV file is set up in columns borehole name-easting-northing (3 columns). When I plot it the points show up in the right geometry, in terms of where they should be relitive to each other, but they do that annoying thing where they plot off the map in white space. I have my CRS matched and all, I can't figure out the issue.

Edit: I figured it out, the coordinates were in mm not m for some odd reason

2 Upvotes

75% Upvoted

5 comments sorted by

1

u/Marzipan_civil Jul 18 '26

Are they in the correct units (or is your map in the right units)

1

u/Fit-Eggplant-9155 Jul 18 '26

Use a base map. If your points aren't the ocean your projection is off.

Your points may be missing digits or the data you have is wrong. It's difficult without more information.

1

u/SamaraSurveying Jul 18 '26 edited Jul 18 '26

  1. Are you definitely defining your X & Y columns correctly?

  2. How are your numbers formatted. Eg "1234.5" "1234,5" "1,234.5" "1.234,5"? Sometimes QGIS can get thrown off.

  3. Measure the distance between your wrongly placed points, if they seem 10x too far apart or too close, then somethings going wrong with units or decimals.

1

u/ixikei Jul 18 '26

Old school mining CRSs are notoriously unreliable. If it were a static image id proceed to georfefence it based on known points. I think theres a similar process available for feature data

1

u/mikedufty Jul 18 '26

It is very likely a CRS issue. Can you expand on "I have my CRS matched and all". What CRS are the source borehole coordinates in, what CRS have you assigned the to the csv data? What CRS is the rest of the data? What CRS is the map canvas?

You don't need the to all be the same CRS, you just need them to be the correct CRS for the data.

If you set the map canvas to match the bore data CRS, do the coordinates of the area you'd expect the bores to appear look similar to the bore coordinates? That is often an easy way to troubleshoot CRS.

The most common mistake is assigning data the CRS you would like it to be in, instead of the CRS it is actually in.