Excel Macro to Extract Local Red Light Cameras to GPX

 

This nice little tool was created by rigel and jpbrannigan.

It's an Excel file that contains two VBA modules that enable you to extract a subset of locations from the redlight-cameras.csv file and save them in GPX format.

rigel's module prompts for the extract coordinates and finds the locations in the subset area.

jpbrannigan's module handles the conversion from CSV to GPX.

To use this macro:

  1. open the "gpx macro.xls" file
  2. open the "redlight-cameras.csv" file
  3. press crtl+e to start the extract process

The tool creates a new file called RedLightCameraExtract.gpx, which imports nicely into MapSource or Garmin's new POI Loader (v2.4.0).

This is not an official POI Factory tool, so please post any questions or feedback in the discussion areas.

Discussion Topics