Where to get red light and speed camera GPX or CSV?

kioolt
Posts: 11
Joined: 28 Apr 2018 01:40
United States of America

Where to get red light and speed camera GPX or CSV?

Post by kioolt »

I've been using POI Factory's camera database for several years now. Is there another good source for a database of red light and speed cameras?
User avatar
dave726
Posts: 94
Joined: 25 Apr 2018 11:06
Location: St Charles, IL, USA
Has liked: 5 times
Been liked: 8 times
United States of America

Re: Where to get red light and speed camera GPX or CSV?

Post by dave726 »

I use the ones from poi-factory. But I run them through a couple edits before using. If you are familiar with Gvim editor, I've got scripts that clean them up a little and convert metric Canadian speeds to English units. Then I import the csv files into ExtraPOIEditor and end up with a clean gpx file. Since those files from poi-editor are subscription/participation files, I can't upload them. I can give you my edit scripts and EPE M-column import parameters if you are interested.
kioolt
Posts: 11
Joined: 28 Apr 2018 01:40
United States of America

Re: Where to get red light and speed camera GPX or CSV?

Post by kioolt »

I've never heard of GVIM. Where can I get it?
User avatar
dave726
Posts: 94
Joined: 25 Apr 2018 11:06
Location: St Charles, IL, USA
Has liked: 5 times
Been liked: 8 times
United States of America

Re: Where to get red light and speed camera GPX or CSV?

Post by dave726 »

https://www.vim.org/download.php#pc and run the gvim80.exe to install on a PC.
(you can find the vim.org link from a Google search)
Edit vim scripts and bmp files:
RedlightViScriptsandBMP.zip
(1.08 KiB) Downloaded 2567 times
Conversion of speed camera.csv:
1.Edit with Cream/Vim. Settings>Preferences>Behavior>Vim and run vim script to add @ and edit KM/H, etc. Save and exit.
2.Open EPE and select M-column CSV import for Speed Camera format.
2a.Set CSV profile: Longitude,Latitude,POI Name,State,City,Description
3.Replace field Symbol with Custom 5 and Display with SymbolOnly.
4.Save speed camera.gpx.

Conversion of redlight.csv:
1.Edit with Cream/Vim. Settings>Preferences>Behavior>Vim and run vim script to change Red Light Camera text to RLC:. Save and exit.
2.Open EPE and select M-column CSV import for RLC format.
2a.Set CSV profile: Longitude,Latitude,POI Name,Address,State,City,Description
3.Replace field Symbol with Custom 4 and Display with SymbolOnly.
4.Save redlight.gpx.

Sounds complicated, but I can do it in 15 minutes with any new RLC and Speed camera csv files from poi-factory now.