*** AS OF AT LEAST 29th MAY 2018 THE VW SITE LINKED BELOW HAS BEEN REMOVED. THIS GUIDE IS THEREFORE NOW BROKEN. DO NOT FOLLOW THIS GUIDE UNTIL (IF) THIS NOTICE IS REMOVED. ***
It's that time again. Rainmaker's decided to write another guide lol... These days speed cameras are everywhere, and even law abiding motorists will occasionally creep over the limit either through momentary inattention, a limit artificially too low for the road and conditions (making it easy to speed without realising) or for any number of reasons. This guide isn't here to debate the legitimacy or necessity (or lack thereof) of speed cameras and speed enforcement. The author has his own views, but they're irrelevant here. Either way, people on Briskoda often ask about whether it's possible to add speed camera locations to the Columbus unit, and if so - how? Here is your answer.
Acknowledgement and Introduction
First of all, none of this would have been possible without @BillyJim writing his original (wonderful) guide and translating some German for us. Since the time he wrote his original guide, however, several things have changed. You now need to use a different URL (website address) to access VW's POI site, and you also need to substitute their metainfo2.txt file with an older Skoda one for it to work (VW's site updates changed the file and broke compatibility with Skodas). I've tweaked and updated the guide, with step by step screen shots, to hopefully help out the new (or not so new) members who regularly ask about this. Note that although I used Windows to make this guide (we have Windows, Linux, MacOS and BSD machines in our house) the basics are the same across operating systems. If you have any individual queries (eg using Finder instead of Explorer, or using command line on *nix instead of a GUI) just ask away and I'll help you out.
So, without further ado, here we go:
Prerequisites
A Skoda with a Columbus nav unit.
A subscription to PocketGPSWorld (£19.99 a year at the time of writing). Some other providers are available, some even free, but none even close to as good or as comprehensive. If you want to skimp and not do it properly, just use an app on your smartphone and save yourself the hassle.
A computer with a fairly modern(ish) operating system and browser.
A USB drive or SD card.
Terminology
Columbus: A sat nav / infotainment unit on some (higher end) Skoda cars
POI: A 'point of interest'. This is a programmable function on your Columbus which allows you to import marker posts for, well, points of interest. It can be banks, a brand of petrol station, or - helpfully - speed camera locations.
PocketGPSWorld: The best database of speed cameras, updated weekly. Hitherto shorthanded as PGPSW.
Gatso: A stationary speed camera, rear-facing (it snaps the back of your car as you drive away from it). Often - but not always - painted yellow.
Mobile: A classification of camera location on PGPSW. Known and verified 'hot spots' where police are known to site camera vans or traffic cars to use a hand held / mobile speed camera.
pMobile: A classification of camera location on PGPSW. Unverified (by PGPSW) 'hot spots' for mobile camera sites, submitted by the user community as and when they come across them. Due to the nature of 'mobile' it's obviously impossible to retrospectively confirm the sighting, but as mobile camera sites are often (usually?) reused by law enforcement, the community works on trust and adds these sites to the camera database. Subscribers have the option to include this category in their weekly database download, or not, depending on their preference. I recommend you use them.
Red light: A camera at ATS (traffic lights), used to detect people going through the light 'on red'. Nowadays often also combined with a speed camera. These combined red light / speed cameras are often called 'speed on green' cameras, and can be referred to as 'RedSpeed' cameras on PGPSW.
SPECS: Variable speed limit cameras. Contrary to seemingly popular belief, these don't actually snap your speed as you pass them and decide whether or not to issue a ticket. There will be one or more pairs of cameras through a variable speed limit zone (eg roadworks, variable limit 'smart' motorway). Some or all of these pairs will be 'live' and will be the ones doing the actual detection. Basically your reg is snapped at live camera 1, and again at live camera 2. Since speed = distance / time and the distance between the two cameras is known, it's easy to then work out your speed based on the two times you crossed the cameras in question. You can't slow down as you pass each camera and then speed up again, as so many seem to do on the motorways - you will get a ticket.
Getting the database
First go to the PGPSW website and log in. If you don't have a valid subscription create your account and then pay the £19.99 to access the camera database. Go to the blue 'Speed Cameras - Download Now!' tab across the top of the site, and then click 'Download speed cams' under the date at the top of the menu that appears. The date is the last camera database update, and they roll out every week.
You will need to go to the options just below the headers/menus across the top and choose your camera database. Set the 'Sat nav system' option to 'Other - CSV'. Then in the next box choose your camera type. We'll focus on UK here but you can grab whatever you like. Note that the Columbus has a POI limit. You can load as many into the unit as you want, but can only display half a dozen at a time. My preference is to get UK and EU cameras (two separate downloads), sorted ('consolidated by type'). That means you get a database listing gatso, mobile, pmobile, red light, SPECS cameras as separate entries on your Columbus unit, with different icons for each. This makes it easy to drive cross-country on back roads with the sat nav open and zoomed out, and be able to see at a glance what's coming up in the next mile or two camera wise. Because of the Columbus display limit it means you can only display UK -or- EU cameras doing it this way. That's no hardship though as you don't drive in the UK and the EU at the exact same time (yes, I know, but you know what I mean...). Switching them over takes seconds, so no hardship.
Your other option is to take the cameras as a single file. This means you'll get all UK (or EU, etc) camera sites but they aren't sorted by type. You'll simply know there's 'a camera' ahead, but not what it is. Your call. Once you've decided which database type you want, and set the two options, click Download to have your browser download the files to your PC (or Mac, or whatever).
One thing to note - and it's explained on the page at PGPSW - is that in France and Switzerland it's illegal to display 'speed camera locations'. You are allowed to display 'accident hot spots' though. Police do sometimes check, and if they find you with camera alerts, it's an on the spot fine! So for EU cameras, you have a specific tick box to choose to have those countries or not. Personally I tick them, but use a hazard icon instead of a camera icon for them... More on that shortly.
Once you have your file (or files), you need to extract them on your PC. They are in .zip (compressed) format. All modern operating systems understand this natively with no need for extra software. Windows Explorer, macOS Finder etc all understand 'zip'. You may also already have 7Zip, WinZIP, WinRAR or other archive software which does the job. Either way, right click your file(s) from PGPSW and choose 'Extract to [folder name]' and they will unzip into a new folder next to your original zipped download. You will see the new folder contains all the camera database files (CSV files) and some handy icons for the Columbus (BMP files). I've also (13/3/18) added some newer images (see end of post) which look really smart on the Columbus display. You may use either, or a mixture - it's up to you.
Converting the files so the Columbus understands them
Now we need to visit VW's website. Skoda has a POI page but it's very broken, has been forever, and they refuse to acknowledge it. It's German, but don't panic!
You can easily follow this guide as it's actually just a bit of button pushing. Google Chrome browser will actually offer to automatically translate the page for you,
so if you use that you're golden. If not just follow my pictures.
Now to the business end of things. Click the button on the left (Read in other POI categories). It will open a box that allows you to upload your database and image file(s).
Click the top 'Choose File' button and choose your UK camera CSV file. If you have - like me - chosen multiple database files 'consolidated by type' then start with the Gatso file (it's the first one in your file chooser window).
After choosing the CSV file, make sure you tick the box underneath to 'Inform when approaching these POIs' if you want the Columbus to beep as you approach a camera! It's actually a bit useless in a way, as it will beep for a camera on either side of the road (Columbus doesn't support directional functionality) and it can beep rather close to them giving limited - though still very workable - time to slow down on approach. Still, better to have it than not imho. Your call again.
Assign a category name. I use 'Speed cameras (UK or EU) - Gatso (or SPECS etc)'.
Click 'Choose File' under Load map icon' at the bottom of the box, and now choose the right icon file. This will be gatso.bmp for the Gatso database and so on. If you have a single camera database just use the provided camera icon, or else the 'hazard' warning triangle I have attached here (especially for those pesky French and Swiss 'accident blackspots'! ;)). You're done - or at least for this one if you have multiple databases/camera types to add to the list.
Repeat the steps above for any other database files you may have (camera types, different countries etc) until you have all your desired POIs listed on the site, like this:
Now click the orange button on the bottom right to 'Save POI collection'. A box will pop up in German giving you a default file name, and the chance to change the text before you save the file. I just leave it as default but you can change it if you wish. Either way, when you're ready just press the button at the bottom right to proceed.
Another final pop up confirming your file will download. Just click the button on the right to continue to the download.
Now your browser will download the converted Columbus friendly POI files. This only takes a moment or two as they're actually very small files. The format is one text file called metainfo2.txt and a folder called PersonalPOI. You need to delete the metainfo2.txt file, as it's designed for VW cars and won't work on your Columbus. Your attempts to add them would just fail. Once you have deleted that metainfo2 text file, you can substitute the Skoda friendly one at the bottom of this post in its place. Just click it to download, and put it next to (NOT INSIDE!) the PersonalPOI folder. You can now copy these two items (metainfo2.txt and the PersonalPOI folder) to a blank USB drive or SD card, plug them into your car, and upload to the Columbus. Your USB drive or SD Card can be in many formats, but FAT32 and NTFS both work OK.
Adding (or updating) the POI in Columbus
Finally just plug the USB or SD card into the car. Start the Columbus unit (or turn on the ignition). Go to Nav and click the Settings cog.
Go to Version Information and press the Update button.
The car will search and find your files on the USB / SD card and load them onto the unit for you to decide whether to use the update or not. We want to do just that.
Ignore the date (it will quite possibly be wrong sometimes, but it won't affect your POI upload or the fact the camera database is up to date). Just click Next.
Once it's finished (this will take a moment or two) click OK.
You can then go back into the nav settings cog and click Map, and tick the box to show POIs.
Next click 'Select categories for POIs' and tick the relevant camera POIs to be displayed on your Columbus. For example in the UK choose your single UK cameras POI, or all the separate UK camera POIs as necessary. Then you're done!
Use the back arrows to get back to the main nav screen (basically going through the above menu process in reverse). Your POIs may not show immediately - don't worry if that's the case! They will show up shortly, and may even need the ignition cycling and a short wait before they're all parsed and loaded. They will load though, as long as you've followed the above steps.
Please note that if you also use other custom POI categories (a favourite fuel brand not already included in Columbus' defaults, camp sites / caravan parks, a supermarket chain, whatever) then these will need to be re-added with each update, as well as the speed camera POI files. Essentially, Columbus wipes the entire custom POI dataset and overwrites it with your 'new' data each time you run an update. So, you can't just update the speed cameras as you'll 'lose' the other POIs when you do. As such you'd need to also re-add your other POI category/categories in with your weekly camera update files.
That's about it. If you have any questions or problems, just post below. Have fun, and drive safe!
ADDENDUM (21/3/18): User @wombatek has requested that I add a link to an alternative (free) service aimed specifically at Columbus/Discover users; the Radar Database. The website is again European based, and allows visitors to download a ready-formatted set of POI files. As with the VW site listed in the guide above, you may wish to visit this site in Google's Chrome browser to take advantage of the auto-translate option. The site is straightforward to operate without this, however. The cameras in the provided database are mostly static and from European sources, but surely better than nothing if you don't wish to - or can't - pay for a PGPSW subscription at the moment. Simply tick the box next to the Union flag, tick the box at the bottom (to enable warning sounds on approach), and then click the left-most of the two big download buttons to get your files in .zip format. Unzipping this archive gives the usual folder and metainfo2.txt ready to go onto a USB or SD card to update your Columbus unit as per the guide above. I haven't yet tested this so don't know whether you'll need to replace the metainfo2.txt file with the one attached to this post. If you test it before I do, please drop a reply at the end of this thread. Untested and unverified, so as always YMMV.
CLICK THE BELOW METAINFO2.TXT LINK TO GET THE NECESSARY REPLACEMENT TEXT FILE, AND THE HAZARD WARNING ICON IF YOU WANT FRENCH AND SWISS CAMERAS FOR EU DRIVING.
metainfo2.txt