0

I'm trying to upload a CSV-file with coordinates of about 80,000 lines, when ever I uploading the file to QGIS, for some reason, the coordinates don't display right and spreading equally. But when I upload one by one (for testing) the position is correct.

enter image description here

enter image description here

It does not matter from me the map I just want use intersection with polygons and points in order to get values ​​for points.

8
  • 4
    Can you share a sample of the data? It's hard to know why anything might be happening when we can't see the data, even a screenshot of the first few rows would help. Can you also tell us what version of QGIS you are using. – TeddyTedTed Nov 9 '20 at 15:24
  • its is working when i upload one but not all, – David Hoffman Nov 9 '20 at 15:33
  • 1
    It would be important to see how the data is structured exactly - just coordinates does not help so much. Just press the screenshot button on your keyboard and paste (CTRL-V) in the text field where you insert your question here on StackExchange. – Babel Nov 9 '20 at 15:46
  • 1
    Or upload the file someplace like Google Drive or the like and put the link here.Make sure you set the file to public sharing – Llaves Nov 9 '20 at 15:48
  • 1
    How exactly do you "upload" it! Please share a screenshot of the dialog. – bugmenot123 Nov 9 '20 at 18:04
2

The grid you see when you add your CSV to QGIS is caused by the precision of your coordinates. They only have two (sometimes only one or none at all) decimals. See this OSM wiki for an explanation of precision of coordinates: https://wiki.openstreetmap.org/wiki/Precision_of_coordinates

So from QGIS side, everything looks just fine. The error is caused earlier, maybe within Excel or wherever your data comes from. E.g. some MS Office products like access use the Windows OS settings for decimals which is two by default.

As a conclusion you need to fix your data acquisition.

2
  • so why its working fine when I upload a small sample – David Hoffman Nov 10 '20 at 6:11
  • 1
    Please show a good import. Which column of your csv contains the right coordinates? e.g. I see a coordinate pair in column E which has rounded values in columns F and G. – Hans Erren Nov 10 '20 at 7:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.