Al Piszcz
2021-06-01 19:41:07 UTC
Thank you, I am creating a .csvt file now with the column type to work
around this issue.
around this issue.
Send gdal-dev mailing list submissions to
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.osgeo.org/mailman/listinfo/gdal-dev
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gdal-dev digest..."
1. VRT layer definition question (Al Piszcz)
2. Re: VRT layer definition question (jratike80)
----------------------------------------------------------------------
Message: 1
Date: Tue, 1 Jun 2021 02:01:10 -0400
Subject: [gdal-dev] VRT layer definition question
<
Content-Type: text/plain; charset="utf-8"
Thank you, interesting, lat,lon interpreted as string by gdalinfo.
==== Request 1
ogrinfo file1.csv -al -so
INFO: Open of `file1.csv'
using driver `CSV' successful.
Layer name: file1
Geometry: None
Feature Count: 1000
(unknown)
lon: String (0.0)
lat: String (0.0)
id: String (0.0)
field_4: String (0.0)
=== Request 2
::: file1.csv
lon,lat,id,
0.084362378404311,0.08587464990542,"0"
0.090601035370249,0.005574551382458,"1"
0.074081946277276,0.020574321282505,"2"
0.034318505618178,0.034922734033886,"3"
0.008330436091964,0.013543226571866,"4"
Message: 2
Date: Mon, 31 May 2021 13:41:55 -0700 (MST)
Subject: Re: [gdal-dev]
Content-Type: text/plain; charset=us-ascii
Hi,
Please add couple of rows from your CSV file. Maybe the lon and lat fields
are otherwise OK but GDAL does not recognize them to contain numbers but
perhaps text. You can also check what sort of attributes ogrinfo reports
with
ogrinfo file1.csv -al -so
-Jukka Rahkonen-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <
http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210601/46e9d616/attachment-0001.html
------------------------------
Message: 2
Date: Tue, 1 Jun 2021 02:46:57 -0700 (MST)
Subject: Re: [gdal-dev] VRT layer definition question
Content-Type: text/plain; charset=us-ascii
Hi,
ogrinfo csv.csv csv -al -oo autodetect_type=yes
Ogrinfo finds numbers from the .csv file automatically, probably because
the
ogrinfo csv.vrt -al -so
ogrmerge f csv -o merged.csv csv.vrt
Warning 1: The 'lon' and/or 'lat' fields of the source layer are not
declared as numeric fields, so the spatial filter cannot be turned into an
attribute filter on them
Ogrmerge runs when I add a mapping file .csvt
csv.csvt
=====
Real,Real,String
It seems to me that your vrt file is OK but there is some issue in the
ogrmerge.py script that does not get the data type of the field correctly
from vrt. Write the csvt file and you should be fine.
-Jukka Rahkonen-
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
------------------------------
Subject: Digest Footer
_______________________________________________
gdal-dev mailing list
https://lists.osgeo.org/mailman/listinfo/gdal-dev
------------------------------
End of gdal-dev Digest, Vol 205, Issue 1
****************************************
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.osgeo.org/mailman/listinfo/gdal-dev
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gdal-dev digest..."
1. VRT layer definition question (Al Piszcz)
2. Re: VRT layer definition question (jratike80)
----------------------------------------------------------------------
Message: 1
Date: Tue, 1 Jun 2021 02:01:10 -0400
Subject: [gdal-dev] VRT layer definition question
<
Content-Type: text/plain; charset="utf-8"
Thank you, interesting, lat,lon interpreted as string by gdalinfo.
==== Request 1
ogrinfo file1.csv -al -so
INFO: Open of `file1.csv'
using driver `CSV' successful.
Layer name: file1
Geometry: None
Feature Count: 1000
(unknown)
lon: String (0.0)
lat: String (0.0)
id: String (0.0)
field_4: String (0.0)
=== Request 2
::: file1.csv
lon,lat,id,
0.084362378404311,0.08587464990542,"0"
0.090601035370249,0.005574551382458,"1"
0.074081946277276,0.020574321282505,"2"
0.034318505618178,0.034922734033886,"3"
0.008330436091964,0.013543226571866,"4"
Message: 2
Date: Mon, 31 May 2021 13:41:55 -0700 (MST)
Subject: Re: [gdal-dev]
Content-Type: text/plain; charset=us-ascii
Hi,
Please add couple of rows from your CSV file. Maybe the lon and lat fields
are otherwise OK but GDAL does not recognize them to contain numbers but
perhaps text. You can also check what sort of attributes ogrinfo reports
with
ogrinfo file1.csv -al -so
-Jukka Rahkonen-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <
http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210601/46e9d616/attachment-0001.html
------------------------------
Message: 2
Date: Tue, 1 Jun 2021 02:46:57 -0700 (MST)
Subject: Re: [gdal-dev] VRT layer definition question
Content-Type: text/plain; charset=us-ascii
Hi,
ogrinfo csv.csv csv -al -oo autodetect_type=yes
Ogrinfo finds numbers from the .csv file automatically, probably because
the
ogrinfo csv.vrt -al -so
ogrmerge f csv -o merged.csv csv.vrt
Warning 1: The 'lon' and/or 'lat' fields of the source layer are not
declared as numeric fields, so the spatial filter cannot be turned into an
attribute filter on them
Ogrmerge runs when I add a mapping file .csvt
csv.csvt
=====
Real,Real,String
It seems to me that your vrt file is OK but there is some issue in the
ogrmerge.py script that does not get the data type of the field correctly
from vrt. Write the csvt file and you should be fine.
-Jukka Rahkonen-
Thank you, interesting, lat,lon interpreted as string by gdalinfo.
==== Request 1
ogrinfo file1.csv -al -so
INFO: Open of `file1.csv'
using driver `CSV' successful.
Layer name: file1
Geometry: None
Feature Count: 1000
(unknown)
lon: String (0.0)
lat: String (0.0)
id: String (0.0)
field_4: String (0.0)
=== Request 2
::: file1.csv
lon,lat,id,
0.084362378404311,0.08587464990542,"0"
0.090601035370249,0.005574551382458,"1"
0.074081946277276,0.020574321282505,"2"
0.034318505618178,0.034922734033886,"3"
0.008330436091964,0.013543226571866,"4"
Message: 2
Date: Mon, 31 May 2021 13:41:55 -0700 (MST)
From: jratike80 <
>
Subject: Re: [gdal-dev]
Message-ID: <
Content-Type: text/plain; charset=us-ascii
Hi,
Please add couple of rows from your CSV file. Maybe the lon and lat
fields==== Request 1
ogrinfo file1.csv -al -so
INFO: Open of `file1.csv'
using driver `CSV' successful.
Layer name: file1
Geometry: None
Feature Count: 1000
(unknown)
lon: String (0.0)
lat: String (0.0)
id: String (0.0)
field_4: String (0.0)
=== Request 2
::: file1.csv
lon,lat,id,
0.084362378404311,0.08587464990542,"0"
0.090601035370249,0.005574551382458,"1"
0.074081946277276,0.020574321282505,"2"
0.034318505618178,0.034922734033886,"3"
0.008330436091964,0.013543226571866,"4"
Message: 2
Date: Mon, 31 May 2021 13:41:55 -0700 (MST)
From: jratike80 <
>
Subject: Re: [gdal-dev]
Message-ID: <
Content-Type: text/plain; charset=us-ascii
Hi,
Please add couple of rows from your CSV file. Maybe the lon and lat
are otherwise OK but GDAL does not recognize them to contain numbers but
perhaps text. You can also check what sort of attributes ogrinfo reports
with
ogrinfo file1.csv -al -so
-Jukka Rahkonen-
_______________________________________________
gdal-dev mailing list
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--perhaps text. You can also check what sort of attributes ogrinfo reports
with
ogrinfo file1.csv -al -so
-Jukka Rahkonen-
_______________________________________________
gdal-dev mailing list
https://lists.osgeo.org/mailman/listinfo/gdal-dev
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
------------------------------
Subject: Digest Footer
_______________________________________________
gdal-dev mailing list
https://lists.osgeo.org/mailman/listinfo/gdal-dev
------------------------------
End of gdal-dev Digest, Vol 205, Issue 1
****************************************