Home » Ticket cameras

Extract certain Red Light Cameras from CSV file

 
Sun, 04/08/2007 - 1:39pm

I created a simple Excel VBA module that asks the user for the lat, long of a map area (the upper left and lower right corners of a rectangle), and extracts only red light cameras from the master red light file that fall within this map area.

Then, it uses jpbrannigan's GPX file converter and builds a RedLightCameraExtract.gpx file which can be imported into MapSource.

This makes the file size manageable and loads only those cameras that are of current interest.

Is there a place on POI Factory where we can upload utilities like this - glad to share and make it available.

And thanks for jpbrannigan for sharing his GPX file converter which my simple program calls.

Other pages

‹ Bolingbrook IL Speed Cameras ›
--
___________________ Garmin 2455, 855, Oregon 550t
Sun, 04/08/2007 - 2:42pm

Rigel, Send me a copy and I

Rigel,
Send me a copy and I will have JM look at it. Thanks for creating this, we really appreciate all the help that we continue to get from everyone in the effort to make this the best POI site in the US.

Miss Poi

Wed, 04/11/2007 - 4:34pm

Added a download page

I've added a page to download rigel / jpbrannigan's Excel file. See the related link at the top of this page.

If feedback is generally positive, I'll also add a link from the FAQ section.

JM

Tue, 05/15/2007 - 3:47pm

Excel Macro

has this been posted anywhere...i can manually remove the locations that i know i'll never be but a macro would make it much much easier

thanks

Tue, 05/15/2007 - 4:47pm

Follow the link

higasan - there is a link at the bottom of the first note in the section which takes you to a download page.

Try it, and let me know if you like it.

--
___________________ Garmin 2455, 855, Oregon 550t
Tue, 05/15/2007 - 4:52pm

thanks

thanks..sorry bout that...i hit the link but obviously didn't go far enough down..

Wed, 05/16/2007 - 11:29am

Red Light Camera Extraction Tool

higasan wrote:

...i can manually remove the locations that i know i'll never be but a macro would make it much much easier

If you're wanting to pull out certain red light camera locations, POI Verifier will do this by entering state abbreviations.

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."