Thank you, I am creating a .csvt file now with the column type to work around this issue.
On Tue, Jun 1, 2021 at 3:00 PM <[email protected]> wrote: > Send gdal-dev mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gdal-dev digest..." > > > Today's Topics: > > 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 > From: Al Piszcz <[email protected]> > To: [email protected] > Subject: [gdal-dev] VRT layer definition question > Message-ID: > < > cadqlv_4wu0tvx9uuh3b8i3_msfxbvkgky-ifyprebx-zmbm...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Jukka: > 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 > Layer SRS WKT: > (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 <[email protected]> > To: [email protected] > Subject: Re: [gdal-dev] > Message-ID: <[email protected]> > 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) > From: jratike80 <[email protected]> > To: [email protected] > Subject: Re: [gdal-dev] VRT layer definition question > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > Hi, > > Ogrinfo finds numbers from the .csv file with a little help: > ogrinfo csv.csv csv -al -oo autodetect_type=yes > > Ogrinfo finds numbers from the .csv file automatically, probably because > the > fields are mapped into real in the vrt file: > ogrinfo csv.vrt -al -so > > But ogrmerge.py does have a problem: > 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- > > > > Al Piszcz wrote > > Jukka: > > 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 > > Layer SRS WKT: > > (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 < > > > jukka.rahkonen@ > > > > > > To: > > > [email protected] > > > Subject: Re: [gdal-dev] > > Message-ID: < > > > [email protected] > > >> > > 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- > > > > _______________________________________________ > > gdal-dev mailing list > > > [email protected] > > > 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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/gdal-dev > > > ------------------------------ > > End of gdal-dev Digest, Vol 205, Issue 1 > **************************************** >
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
