<div dir="ltr"><div class="gmail_default" style="font-family:courier new,monospace">Thank you, I am creating a .csvt file now with the column type to work around this issue. </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 1, 2021 at 3:00 PM <<a href="mailto:gdal-dev-request@lists.osgeo.org">gdal-dev-request@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send gdal-dev mailing list submissions to<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:gdal-dev-request@lists.osgeo.org" target="_blank">gdal-dev-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:gdal-dev-owner@lists.osgeo.org" target="_blank">gdal-dev-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of gdal-dev digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. VRT layer definition question (Al Piszcz)<br>
2. Re: VRT layer definition question (jratike80)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Tue, 1 Jun 2021 02:01:10 -0400<br>
From: Al Piszcz <<a href="mailto:ap@solarrain.com" target="_blank">ap@solarrain.com</a>><br>
To: <a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
Subject: [gdal-dev] VRT layer definition question<br>
Message-ID:<br>
<<a href="mailto:CADqLV_4WU0TVx9uuh3B8i3_msFXbVKGkY-iFYpReBx-zmbmb-g@mail.gmail.com" target="_blank">CADqLV_4WU0TVx9uuh3B8i3_msFXbVKGkY-iFYpReBx-zmbmb-g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Jukka:<br>
Thank you, interesting, lat,lon interpreted as string by gdalinfo.<br>
<br>
==== Request 1<br>
ogrinfo file1.csv -al -so<br>
INFO: Open of `file1.csv'<br>
using driver `CSV' successful.<br>
<br>
Layer name: file1<br>
Geometry: None<br>
Feature Count: 1000<br>
Layer SRS WKT:<br>
(unknown)<br>
lon: String (0.0)<br>
lat: String (0.0)<br>
id: String (0.0)<br>
field_4: String (0.0)<br>
<br>
=== Request 2<br>
::: file1.csv<br>
lon,lat,id,<br>
0.084362378404311,0.08587464990542,"0"<br>
0.090601035370249,0.005574551382458,"1"<br>
0.074081946277276,0.020574321282505,"2"<br>
0.034318505618178,0.034922734033886,"3"<br>
0.008330436091964,0.013543226571866,"4"<br>
<br>
<br>
<br>
Message: 2<br>
Date: Mon, 31 May 2021 13:41:55 -0700 (MST)<br>
From: jratike80 <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
To: <a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
Subject: Re: [gdal-dev]<br>
Message-ID: <<a href="mailto:1622493715145-0.post@n6.nabble.com" target="_blank">1622493715145-0.post@n6.nabble.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Hi,<br>
<br>
Please add couple of rows from your CSV file. Maybe the lon and lat fields<br>
are otherwise OK but GDAL does not recognize them to contain numbers but<br>
perhaps text. You can also check what sort of attributes ogrinfo reports<br>
with<br>
<br>
ogrinfo file1.csv -al -so<br>
<br>
-Jukka Rahkonen-<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210601/46e9d616/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210601/46e9d616/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Tue, 1 Jun 2021 02:46:57 -0700 (MST)<br>
From: jratike80 <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi" target="_blank">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
To: <a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
Subject: Re: [gdal-dev] VRT layer definition question<br>
Message-ID: <<a href="mailto:1622540817868-0.post@n6.nabble.com" target="_blank">1622540817868-0.post@n6.nabble.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Hi,<br>
<br>
Ogrinfo finds numbers from the .csv file with a little help:<br>
ogrinfo csv.csv csv -al -oo autodetect_type=yes<br>
<br>
Ogrinfo finds numbers from the .csv file automatically, probably because the<br>
fields are mapped into real in the vrt file:<br>
ogrinfo csv.vrt -al -so<br>
<br>
But ogrmerge.py does have a problem:<br>
ogrmerge f csv -o merged.csv csv.vrt<br>
Warning 1: The 'lon' and/or 'lat' fields of the source layer are not<br>
declared as numeric fields, so the spatial filter cannot be turned into an<br>
attribute filter on them<br>
<br>
Ogrmerge runs when I add a mapping file .csvt<br>
<br>
csv.csvt<br>
=====<br>
Real,Real,String<br>
<br>
It seems to me that your vrt file is OK but there is some issue in the<br>
ogrmerge.py script that does not get the data type of the field correctly<br>
from vrt. Write the csvt file and you should be fine.<br>
<br>
-Jukka Rahkonen-<br>
<br>
<br>
<br>
Al Piszcz wrote<br>
> Jukka:<br>
> Thank you, interesting, lat,lon interpreted as string by gdalinfo.<br>
> <br>
> ==== Request 1<br>
> ogrinfo file1.csv -al -so<br>
> INFO: Open of `file1.csv'<br>
> using driver `CSV' successful.<br>
> <br>
> Layer name: file1<br>
> Geometry: None<br>
> Feature Count: 1000<br>
> Layer SRS WKT:<br>
> (unknown)<br>
> lon: String (0.0)<br>
> lat: String (0.0)<br>
> id: String (0.0)<br>
> field_4: String (0.0)<br>
> <br>
> === Request 2<br>
> ::: file1.csv<br>
> lon,lat,id,<br>
> 0.084362378404311,0.08587464990542,"0"<br>
> 0.090601035370249,0.005574551382458,"1"<br>
> 0.074081946277276,0.020574321282505,"2"<br>
> 0.034318505618178,0.034922734033886,"3"<br>
> 0.008330436091964,0.013543226571866,"4"<br>
> <br>
> <br>
> <br>
> Message: 2<br>
> Date: Mon, 31 May 2021 13:41:55 -0700 (MST)<br>
> From: jratike80 <<br>
<br>
> jukka.rahkonen@<br>
<br>
> ><br>
> To: <br>
<br>
> gdal-dev@.osgeo<br>
<br>
> Subject: Re: [gdal-dev]<br>
> Message-ID: <<br>
<br>
> 1622493715145-0.post@.nabble<br>
<br>
>><br>
> Content-Type: text/plain; charset=us-ascii<br>
> <br>
> Hi,<br>
> <br>
> Please add couple of rows from your CSV file. Maybe the lon and lat fields<br>
> are otherwise OK but GDAL does not recognize them to contain numbers but<br>
> perhaps text. You can also check what sort of attributes ogrinfo reports<br>
> with<br>
> <br>
> ogrinfo file1.csv -al -so<br>
> <br>
> -Jukka Rahkonen-<br>
> <br>
> _______________________________________________<br>
> gdal-dev mailing list<br>
<br>
> gdal-dev@.osgeo<br>
<br>
> <a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
<br>
<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html</a><br>
<br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
<br>
<br>
------------------------------<br>
<br>
End of gdal-dev Digest, Vol 205, Issue 1<br>
****************************************<br>
</blockquote></div>