From OpenStreetMap Wiki
Jump to: navigation, search
Available languages — Columbus
Afrikaans Alemannisch aragonés asturianu azərbaycanca Bahasa Indonesia Bahasa Melayu Bân-lâm-gú Basa Jawa Baso Minangkabau bosanski brezhoneg català čeština dansk Deutsch eesti English español Esperanto estremeñu euskara français Frysk Gaeilge Gàidhlig galego Hausa hrvatski Igbo interlingua Interlingue isiXhosa isiZulu íslenska italiano Kiswahili Kreyòl ayisyen kréyòl gwadloupéyen Kurdî latviešu Lëtzebuergesch lietuvių magyar Malagasy Malti Nederlands Nedersaksies norsk bokmål norsk nynorsk occitan Oromoo oʻzbekcha/ўзбекча Plattdüütsch polski português português do Brasil română shqip slovenčina slovenščina Soomaaliga suomi svenska Tiếng Việt Türkçe Vahcuengh vèneto Wolof Yorùbá Zazaki српски / srpski беларуская български қазақша македонски монгол русский тоҷикӣ українська Ελληνικά Հայերեն ქართული नेपाली मराठी हिन्दी অসমীয়া বাংলা ਪੰਜਾਬੀ ગુજરાતી ଓଡ଼ିଆ தமிழ் తెలుగు ಕನ್ನಡ മലയാളം සිංහල ไทย မြန်မာဘာသာ ລາວ ភាសាខ្មែរ ⵜⴰⵎⴰⵣⵉⵖⵜ አማርኛ 한국어 日本語 中文(简体)‎ 吴语 粵語 中文(繁體)‎ ייִדיש עברית اردو العربية پښتو سنڌي فارسی ދިވެހިބަސް

Columbus V-900

The Columbus V-900 is a GPS receiver and logger with voice recording function. It is also known as Visiontac VGPS-900.

Logs are stored on Secure Digital microSD cards with a capacity of up to 2GB. Format of the track logs is a kind of comma-separated value (CSV) text file with fixed-length \x0-terminated fields. Audio recordings are stored as WAV files.


GPS unit: Columbus V-900

  • £55
  • Logger; Receiver (Navigation: )
  • CPU: (OS: ), Flash:32MB (external: microSD (2GB))
  • GPS: 51 channels, ( WAAS;egnos, hdop;vdop;pdop )
  • Display: , Connectivity: Bluetooth
  • Internal: Microphone Batteries:
Addresses POIs
Mass Storage mode ? Waterproof


  • Tagging with voice recordings is unusual
  • Small and neat device
  • Storage on microSD card
  • JOSM plugin that puts the track and Audio recording on the map


  • Accuracy with marginal reception is not optimal, e.g., when carried in pocket while walking
  • USB is only used for charging/power supply, not data transfer

Notes: Bugs: In the southern hemisphere the device fails to find a GPS position. In reality, it makes a fix, logs a few points but then throws away the solution to start over. The bug is recognized by the manufacturer and units delivered after August 2009 should not have this problem any more.



TimeAlbum, the software supplied by the manufacturer is written in Java and should at least run on Linux, Microsoft Windows and Mac OS X. It features export of logs to KMZ (zipped KML) format.


BT747 is able to read and convert this CSV dialect to GPX, KML/KMZ and other formats, including a neat and efficient HTML format that shows your track fast on Google Maps (and OSM data) in any browser? The fastest way is to drag and drop your CSV files to BT747 and a few clicks further your data is exported into a GPX format that is optimized for OSM.


While gpsbabel is able to convert CSV files to GPX and other formats, it is convenient to do some preprocessing of the CSV log. is s script which does this:

# Convert Visiontac VGPS-900 log file to GPX
# 2009-02-08


for FILE in $* ; do
    if [ -f "${FILE}" ] ; then

        OUTFILE=`echo ${FILE} | ${SED} -e 's/\.csv/.gpx/i'`

        # Reformat CSV into something understandable by gpsbabel unicsv
        # moving E/W,N/S from lon/lat fields into separate ones,
        # renaming of audio references to proper file names,
        # reformatting of date and time fields
        ${SED} -n -e ' s/\x0//g;
                    1s# N/S#,N/S#;1s# E/W#,E/W#;
                    s/ ,/,/g;
                    s/,\([VCT]\{1,1\}\),\([0-9]\{2,2\}\)\([0-9]\{2,2\}\)\([0-9]\{2,2\}\),\([0-9]\{2,2\}\)\([0-9]\{2,2\}\)\([0-9]\{2,2\}\)/,\1,20\2-\3-\4,\5:\6:\7/p' \
                    "${FILE}" > ${TMPFILE1}

        # Get trackpoints and convert to gpx
        ${GREP} -E ',T,|URL' ${TMPFILE1} | ${GPSBABEL} -i unicsv -f - -x transform,trk=wpt,del -o gpx -F ${TMPFILE2}

        # Get waypoints and convert to gpx
        ${GREP} -v ',T,' ${TMPFILE1} | ${GPSBABEL} -i unicsv -f - -o gpx -F ${TMPFILE3}

        # Merge track and waypoints into single gpx, substituting url tag with link tag as known by JOSM 
        ${GPSBABEL} -i gpx -f ${TMPFILE2} -i gpx -f ${TMPFILE3} -o gpx -F - | ${SED} -e 's#<\(/\{0,1\}\)url>#<\1link>#g;' > "${OUTFILE}"
        rm -f ${TMPFILE1}
        rm -f ${TMPFILE2}
        rm -f ${TMPFILE3}

JOSM Plugin

Oliver Wieland wrote a JOSM plugin to import CSV files.

Columbus to GPX

Russ Nelson's Python program to turn a Columbus pseudo-CSV into a GPX file is in OSM's SVN:


Wang Chun wrote a simple Perl utility to convert from CSV to GPX format:

Ludo released VGPS-900toGPX which runs on Mac OS X.

Istap built a nice application using Nokia's Qt SDK called v900togpx (runs on Windows/Linux and Mac OS X). This tool stores the lon and lat in the GPX output in reverse order for V990 CSV files.

Columbus V-990

Columbus V-990 is the next generation of the V-900.