CSV on the web: question re null / missing values

Does this working group intend to publish anything (e.g. advice) on how to handle null values in CSV data? Perhaps as part of the metadata work, given that current usage varies. I would like to see some guidance covering:

* 'the meaning of null' - i.e. recognition of the range of possibilities. OGC's gml:nilReasonType (http://www.opengeospatial.org/standards/gml) extends the idea of xsi:nil (http://www.w3.org/TR/xmlschema-1/#xsi_nil; http://www.w3.org/TR/2001/REC-xmlschema-0-20010502/#Nils)

* Giving null values in columns of different data types

* Any interaction with whether strings are quoted or not

Thanks

Yours

Peter


Peter Parslow
Principal Geographic Information Architect
Content & Data Products, Ordnance Survey
Adanac Drive, SOUTHAMPTON, United Kingdom, SO16 0AS
Linked data / map: http://data.ordnancesurvey.co.uk/id/postcodeunit/SO160AS
Phone: +44 23 8005 5341
Mobile: +44 7796 610020
www.ordnancesurvey.co.uk | Peter.Parslow@ordnancesurvey.co.uk

Please consider your environmental responsibility before printing this email.




This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person.

Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Adanac Drive
Southampton SO16 0AS
Tel: 08456 050505
http://www.ordnancesurvey.co.uk

Received on Wednesday, 6 August 2014 10:16:56 UTC