[gdal-dev] gdal-dev Digest, Vol 205, Issue 1

Tue Jun 1 12:41:07 PDT 2021

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 <gdal-dev-request at lists.osgeo.org> wrote:

> Send gdal-dev mailing list submissions to
>         gdal-dev at lists.osgeo.org
>
> 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
>         gdal-dev-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         gdal-dev-owner at lists.osgeo.org
>
> 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 <ap at solarrain.com>
> To: gdal-dev at lists.osgeo.org
> Subject: [gdal-dev] VRT layer definition question
> Message-ID:
>         <
> CADqLV_4WU0TVx9uuh3B8i3_msFXbVKGkY-iFYpReBx-zmbmb-g at 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 <jukka.rahkonen at maanmittauslaitos.fi>
> To: gdal-dev at lists.osgeo.org
> Subject: Re: [gdal-dev]
> Message-ID: <1622493715145-0.post at n6.nabble.com>
> 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 <jukka.rahkonen at maanmittauslaitos.fi>
> To: gdal-dev at lists.osgeo.org
> Subject: Re: [gdal-dev] VRT layer definition question
> Message-ID: <1622540817868-0.post at n6.nabble.com>
> 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:
>
> > gdal-dev at .osgeo
>
> > Subject: Re: [gdal-dev]
> > Message-ID: <
>
> > 1622493715145-0.post at .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 at .osgeo
>
> > 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
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
> ------------------------------
>
> End of gdal-dev Digest, Vol 205, Issue 1
> ****************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210601/1a050d98/attachment.html>