[Qgis-user] CSV Import records missing on map

Peter Devanney peter at devanney.ca
Mon Sep 27 11:32:06 PDT 2021


Nicolas

Thanks for the tip. I did check in Textedit and only see commas as
separator values and the DMS all look formatted the same.

This is also my first time having to use DMS - I usually use D.D without
any issues.

Peter

On Sun, Sep 26, 2021 at 8:39 PM Nicolas Cadieux <njacadieux.gitlab at gmail.com>
wrote:

> Hi,
>
> I have never used DMS, but rather Degrees in Decimals so perhaps that is
> the problem.  Make sure what is currently imported is actually in the
> correct place in DMS.
>
> Normally, problems with csv is related to empty field or extra
> separators.  Look at the file in notepad or notepad ++ and eliminate to
> problematic characters to make sure columns are Perfectly aligned. This can
> be hard to find if the separator is a space character.
>
> Nicolas Cadieux
> https://gitlab.com/njacadieux
>
> Le 26 sept. 2021 à 16:48, Peter Devanney <peter at devanney.ca> a écrit :
>
> 
> Hello
>
> I have an issue I have never run into before.
>
> I am adding a delimited text (CSV) layer and only some of the records
> appear on the map. 36/118 records show. The rest do not show but are still
> in the attribute table.
>
> When I run add geometry attributes or do an export to .shp I only see the
> 36 records that showed up on the map.
>
> All records look identical in the source CSV. I cannot see any difference
> that would explain why one record imported successfully with geometry
> attributes and the others didn't.
>
> The CSV file has separate Lat and Long columns with coordinates in DMS
> Latitude Longitude
> N45 45 56.1 W075 27 51.3
>
> I am running 3.16.8 on OS X Big Sur 11.5.2
>
> Scratching my head as to why some records import ok and the others do not,
> even though all show up in the attribute table.
>
> thanks
>
> Peter Devanney
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210927/b54777ce/attachment-0001.html>


More information about the Qgis-user mailing list