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: > gdal-dev@.osgeo > Subject: Re: [gdal-dev] > Message-ID: < > 1622493715145-0.post@.nabble >> > 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 > gdal-dev@.osgeo > https://lists.osgeo.org/mailman/listinfo/gdal-dev -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev