Red Light Cameras By Cities

I think could be done with some sort of sorting with "if-then" statements for the latitude & longitudes so the range of the if-then statement covers the state you want, and sorts the file by those parameters and you could then save the records you want.

I did something similar with the Midwest schools file - I wanted to remove the "historical" entries...and I did a conditional format on the "name" field, and if it contained "historical" - give that cell a red background...I then sorted the file so it aggregated all the cells with the red background and was then able to select and delete the "historical" records - as I've found that the "historical" schools, if a building exists there at all, it's not a school.

The method I use is to look up on a map the latitude and longitude boundaries for the area that you want. Then, open the file in Excel(Red Light Cameras in this instance) and sort the data by longitude. Select those greater than the highest longitude border and delete them. Do the same for those less than the lowest longitude border. Then resort the data by column B (latitude) and do the same thing. Finally, save the file with the remaining entries.

Thanks guys. I tried sorting in Excel but didn't have any luck. Guess I could do the chicken dance, just go in a "pick" them out. I just want them for the Dallas area, so it won't be an overly bearing task when I get to it.

Robert660
It is an easy task in excel.
1. Open .csv file in Excel (column A is Longitude)
2. Select All (box between A and 1)
3. Go to Data menu and choose sort
4. Select "Sort by" column A, check ascending and choose NO HEADER at the bottom

That is all.

It would be rather easy to write an Excel VBA module (marco) to do this.

It could ask the user for the east and west boundary longitudes, and the north/south boundary latitudes, the module would grab only POIs within the box and spit it out in a new spreadsheet.

If there is sufficient interest, I would be happy to create such a tool.

Maybe there would be a place here to post/store such tools? I have collected some other excel addins that are useful with geography - great circel distance between two lat/long points, etc

Sorry mkahn, the sorting still didn't work for me. It did work, but Dallas was mixed in with all the other states. Question. If I load all of these on a SD card, and not load into my Nuvi, can I delete what I don't want from the SD card?
I'm not computer savy, and really don't know anything about Macros, or how to use them. Thanks again guys.

Robert,
Do you have MapSource?

I'm a visual person.

For me the easiest thing to do would be to load in MapSource and then visually select and delete the ones you don't want.
.

Robert660

I'm not well versed in the finer points of excel.
So, I start on line 1 and click it to highlight it, then press and HOLD shift, then use cursor down. When I reach a line I want to save I cursor up (if I have to) until only the ones I don't want are highlighted (all the while still pressing the shift key). Then release the shift key, go to edit then delete - this will remove the highlighted lines and renumber the lines. I then continue the procedure until I only have what I want left, then I do a "save as" to keep my new file and keeping the old as well.

It may be a long way, but works and is easier than the chicken dance.

I really should learn the finer points of excel !

No Mama, I don't have MapSource. I can't get Garmin to send me a copy. I tried, but they won't.

If you would like me to talk you through the excel portion, drop me an email and I will provide my telephone number. BTW, I am located in Austin.

Robert, try again.

Email them and state that you would like the MapSource dvd so you can manage your "Favorites". Also point out that since your 660 is capable of utilizing the TourGuide function, and TourGuide files must be saved in .gpx format, you would like the MapSource dvd in order to create your own TourGuide files.

You can also state that you realize that you cannot transfer maps/routes.

Great Idea

Robert, I have had the same problem with Garmin and trying to get MapSource. However the new version of WebUpdater says:

"For some unit updates, this software will clear user memory, including 'Recent Finds' and 'Favorites.' Please back up important data such as routes, tracks, and waypoints to MapSource prior to updating."

So I called Garmin, told them I had a lot of favorites and some recent entries that I did not want to lose. How was I supposed to update my WebUpdater? They are mailing me MapSource today.

Try calling them. If their WebUpdater requires MapSource now, they almost have to send you the software. Alot of it also depends on who you talk to there.