Re: [gdal-dev] [OSGeo-Standards] CSV spatial data on the web

2016-02-17 Thread Stefan Keller
2016-02-17 14:02 GMT+01:00 Oliver Tonnhofer : > RFC4180 allows newlines as long as they are inside of double quotes. This is > at least supported by the Python and Go standard libraries, not sure how > other software handles this. Thanks, Oliver. That's correct. I have to be more specific: The A

Re: [gdal-dev] [OSGeo-Standards] CSV spatial data on the web

2016-02-17 Thread Stefan Keller
Jeremy, 2016-02-17 11:48 GMT+01:00 Jeremy Palmer : >> Allowing non-printable control-characters in strings makes it very >> complicated and disables mainly all existing CSV software. > > Yes but Excel handles it. So does OGR and QGIS Delimited Text Provider. > From memory the Microsoft ODBC CSV dr

Re: [gdal-dev] [OSGeo-Standards] CSV spatial data on the web

2016-02-17 Thread Jeremy Palmer
We have all sorts or data within our fields, including pipe - think free description text field where users cut and paste all sorts of stuff! Cheers Jeremy > On 17/02/2016, at 11:58 PM, Johan Van de Wauw > wrote: > > On Wed, Feb 17, 2016 at 11:31 AM, Stefan Keller wrote: >> Hi Jeremy >> >>>

Re: [gdal-dev] [OSGeo-Standards] CSV spatial data on the web

2016-02-17 Thread Jeremy Palmer
Hi Sfefan, > On 17/02/2016, at 11:31 PM, Stefan Keller wrote: > > Hi Jeremy > > Semicolon is well supported in software. > Tab is poorly supported in some text editors. > Comma is heavy used in number values in european countries. > What delimiter do you prefer and why? > Comma because it’s a we

Re: [gdal-dev] [OSGeo-Standards] CSV spatial data on the web

2016-02-17 Thread Stefan Keller
Hi Jeremy > However looking at the GeoCSV specification it would be a step > backwards for our users due to the field delimiter being semicolon. Semicolon is well supported in software. Tab is poorly supported in some text editors. Comma is heavy used in number values in european countries. What

Re: [gdal-dev] [OSGeo-Standards] CSV spatial data on the web

2016-02-17 Thread Jeremy Palmer
Hi Stefan, Yes I’m aware of the GeoCSV specific and the implementation within OGR. We actually support CSV+VRT from the NZ land data service: https://data.linz.govt.nz/. When we did the implementation about 4 years ago I don’t think your specification was around. I do like the simple approach o

Re: [gdal-dev] [OSGeo-Standards] CSV spatial data on the web

2016-02-16 Thread Stefan Keller
Hi Jeremy Thanks for the info. I assume you are aware of GeoCSV and related software like the well-known OGR (and the #TheShapefileChallenge ): http://giswiki.hsr.ch/GeoCSV :Stefan 2016-02-16 19:40 GMT+01:00 Jeremy Palmer : > For forks that are interested W3C has setup a CSV on the Web Working