[Openstreetmap-dev] CSV transport encoding scheme
doug+osm at idmf.net
Tue Jan 24 22:46:32 GMT 2006
> I agree, that it is not too clever to have a variable amount of
> entries in a CSV-line, regardless at which position in the line this
> list is.
> CSV is made for static data structures where the meaning and number of
> elements per line is the same for the whole document. My scheme
> sacrifice this big advantage (in performance and simplicity). So does
> OSM has different data structures and I don't see a simple way to
> transfer them in a static length list together without much hassle.
Why not just produce two (or more) delimited files packaged up with
version/generator file in a zip file or some other sort of archive.
The delimited file format would be based on the database schema
so you'd have a 'nodes' file which would be formated like
id,latitude,longitude,timestamp,(etc..if you wanted to include more info)
and 'segments' would just be
I hesitate to suggest this, but you'd also probably want something like
These could then be loaded into any database or spreadsheet for further
More information about the dev