Any suggestions to save time with Red Light Camera Files

You can use POI Verifier to extract entries for a specific state.

RT

While it might not be "economical", these files aren't really that big. Since you are storing them from the SD card, I'm sure you have a lot of room. The entire file is only 188k.

"In the past I have had to look up all the coordinates in Map Source and write down the intersections on paper, then open the file in Excel so that I can edit the file."

Excel can be used to sort on multiple columns. I sort by city, then long.(descending)/lat.(ascending). Comparing the sorted city files to my sorted "edited" list I can see if there are more entries in the newly downloaded files for a city, and copy/insert a new entry into the "edited" list, or delete entries as appropriate.
Using POIEDIT, I convert the newly "edited" files to .gpx, then open them in mapsource. Newly added entries are easily spotted in mapsource, and can be doubleclicked to take you to the intersection for transcribing to the "edited" list. Yes it is still manual, but the intersection information can be retained.

Nevermind, that was something else.

I believe Rayzers would like to edit the redlight file to display the actual street names, ie

Smith and Jones St or First Av and Central Dr

Instead of

Red Light Camera .01w5w

I don't think his main problem is getting the entire file down to one state.

It's matching the coordinates to the proper street names.

But then again, I've been wrong before.

I hear what you are saying mkahn, but what Im really asking for in the end result is instead of just a city name, I'd much rather have the intersecting streets shown on my GPS, so that I can learn as I drive. Im wondering if there is an easier way to get this done without going to all the trouble of editing each location after having to look it up in Map Source to find out where the dang red light is. In trying to keep this all sorted out I have WAY too many folders and files to manage and Im just frustrated. Seems to me it could be done with a lot fewer steps, I just dont know what those steps would be.

I think I got it right that time...

Rayzers,
I tend to agree with you, I too would prefer to see the street names.

How about if you have a custom icon for the red light file, browse about town (browse map mode) find the icons, and intersection names and match with appropriate lat/lon.

Does the 680 allow you to see the lat and lon for each poi? If so, you should be able to match them as described above without the computer or driving.

This is how I'd do it.
Open the file in mapsource and find the intersections and enter the street names in the comments or Name field, then re-save the file...First you'd have to convert the csv file to gpx file which is no problem. (google "gpxtopoi")

yeah, thats how I'd do it.

Just a thought

Yes, you sure do have it right Ismonop, but what you have suggested is exactly what Im now doing, but it takes so long to do... Im hoping someday the files we download will contain the streets in another column. This would save tons of research time, at least for me and I could move the info to a columm that would show on my screen and then not see "Red Light Camera .01w5w". Problem is when I download the updated file, all the work I did for adding street names will be overwritten by the new file.

Bewildered in Bolingbrook