Redlight Camera File Suggestion

Did you just volunteer?

Aren't State Highways properly named SR or State Route?

One Line 1971 of the Beta File you will find this:
STATE HIGHWAY 161 & STATE HIGHWAY 114
It actually could look like this below:
ST Hwy 161 & ST Hwy 114

Other than that nit, what you propose is good and reasonable.

I saw a Beta file when going to d/l the latest red light camera file and wasn't sure which to choose. I was wondering what the difference btw. the Beta file and the regular file is?

I have to make changes like this to the file. Right now it is low priority. I will eventually get to it.

Miss POI

Isn't it easier to open them up and check out the difference? Or better yet, load the Beta and do a test run thru an intersection with RLC. Notice anything different?

Just loaded the beta version last night. I will be testing it today. I'll see if I have the same issue with the display.

I believe all of your suggestions make sense, not only for size, but it will probably be easier to read.

PS I really like the concept of this beta.

Here is a possible fix for those who have Excel:

1) open the beta version in Excel
2) Insert a new column (D?)
3) Enter In the new column cell D1: =proper(C1)
4) Copy this function to D2 thru D???
5) Use copy/paste special to convert formula to text (select Values on Paste special box)
6) Use copy/replace to convert Rlc to RLC (select Match case check box)
7) Delete column C
8) Save file

Let me know if you need more details

This will covert all CAPS to Normal text

Before:

RLC - HWY 99 & 196TH
RLC - BROADWAY & STAPLEY
RLC - BROWN & HIGLEY
RLC - BROWN & MESA
RLC - UNIVERSITY & MESA
RLC - UNIVERSITY & STAPLEY
RLC - COUNTRY CLUB & UNIVERSITY
RLC - GILBERT & MCKELLIPS
RLC - GREENFIELD & MAIN
RLC - HIGLEY & MCKELLIPS
RLC - LINDSAY & UNIVERSITY
RLC - POWER & MCKELLIPS
RLC - ALMA SCHOOL & GUADALUPE
RLC - ALMA SCHOOL & SOUTHERN

After:

RLC - Hwy 99 & 196Th
RLC - Broadway & Stapley
RLC - Brown & Higley
RLC - Brown & Mesa
RLC - University & Mesa
RLC - University & Stapley
RLC - Country Club & University
RLC - Gilbert & Mckellips
RLC - Greenfield & Main
RLC - Higley & Mckellips
RLC - Lindsay & University
RLC - Power & Mckellips
RLC - Alma School & Guadalupe
RLC - Alma School & Southern

Not sure if it matters, the double quotes are gone after saving the file. Here's how it looks (coordinates omitted):

Before
"RLC - HWY 99 & 196TH","WA Lynnwood poi-factory Jul08 09"

After
RLC - Hwy 99 & 196Th,WA Lynnwood poi-factory Jul08 09

Do we need the double quotes?

I believe the double quotes are not needed unless you have a comma in the description. The double quotes are usually there to avoid breaking a field into another column when a comma is present.

Thanks DRMCMTR. I wonder how to leave those double quotes intact if we use Excel to modify and save.

How did the test go and did you have the same issues?
Also, I agree, reading would be easier.

Sorry for being so slow with my results.

Well, I haven't run into a redlight that did not fit on my screen, but could see that combinations of long names will be puching the boundaries of my Nuvi 760. I think abbreviations and first letter captialization will be easier to read.

Wow, that looks relatively easy to at least get rid of the ALL CAPS aspect of the file.
I guess I'll give it a try soon.

Thanks DRMCMTR...

I'll be giving that Excel trick a go too. We'll see how it turns out. Thanks for the tip.

Let me know if you run into any problems.

Please read your mail and reply. I was waiting to see if the file had been changed to contain both Caps and small letters this week but unfortunately it remains in its ALL CAPS FORMAT because of its low priority.

Lets talk in Email.
Thanks

Did you want help doing this? or is it already done?

I have a bunch of utilities that could help CamelCase the data and abbreviate the terms.

I can also tell what entries would go over a certain limit, say like 40 characters?

So far, by shortforming the following I've got the file down to only 28 entries over 40 characters long:
Highway - Hwy
Northbound - NB
Southbound - SB
Eastbound - EB
Westbound - WB
Route - Rte

Sample data:

-75.77608,39.66557,"RLC - Christina & Elkton","De Newark Poi-Factory Jul22 09"
-75.74103,39.60568,"RLC - Pulaski Hwy & Summit Bridge","De Newark Poi-Factory Jul22 09"
-75.72636,39.66262,"RLC - Sr-4 & Marrows","De Newark Poi-Factory Jul22 09"
-75.75159,39.65866,"RLC - Sr-896 & Sr-4","De Newark Poi-Factory Jul22 09"
-75.59409,38.66073,"RLC - Us-13 & Tharp","De Seaford Poi-Factory Jul22 09"
-75.63057,39.73611,"RLC - Robert Kirkwood Hwy & Newport Gap Pike","De Wilmington Poi-Factory Jul22 09"
-75.58946,39.73933,"RLC - Sr-2 & Dupont","De Wilmington Poi-Factory Jul22 09"
-75.65821,39.72388,"RLC - Sr-2 & Sr-7","De Wilmington Poi-Factory Jul22 09"
-75.54442,39.82875,"RLC - Us-202 & Sr-92","De Wilmington Poi-Factory Jul22 09"
-93.83358,41.61473,"RLC - Hickman & 156th","Ia Clive Poi-Factory Jul22 09"
-93.79152,41.61491,"RLC - Hickman & 128th","Ia Clive Poi-Factory Jul22 09"
-93.81432,41.61483,"RLC - Hickman & 142nd","Ia Clive Poi-Factory Jul22 09"
-93.75594,41.61475,"RLC - 100th & Hickman","Ia Clive Poi-Factory Jul22 09"


Let me know

Wow, that was quick:))) If you needed to, you could also delete the space & the - right after RLC too. Maybe that would save some more screen real estate. Would you mind sending me the file in that format if you've already done it? I'd suggest sending it also to Jon and Miss Poi, as they might find that would save them some "maintenance time" too.

Thanks for your interest.
Rayzers

Email sent.

OK got it down to 20 that are over 40 characters.

I've also been cleaning up some odd looking entries, going to maps.google to get the right street names.

when I'm done, where would you like me to post it.

Question, is there a different between US-Hwy xx and US-Rte xx? I've seen this in a couple of places...
e.g.

-94.35002,32.5517,"RLC-US-Hwy-59 East End & Texas 4","Tx Marshall Poi-Factory Jul22 09"
-94.35182,32.5269,"RLC-US-Rte-59 & Pinecrest","Tx Marshall Poi-Factory Jul22 09"


edit: sent Miss POI e-mail about new file
By removing changing "RLC - " to "RLC-" got it down to 11 > 40 char

OK I've gone through the whole file and corrected a bunch of naming errors and also standardized things like Rt to Rte and put a - between things like Hwy-99 and Rte-45 and I-209.

I've been able to get all lines to less then 40 Chars.

The file that I converted was from today, OK yesterday now

Miss POI - Let me know where I can load it for your review.

If you need it I can also send you the list of differences between my edited file and the original.

Oh, and just in case it wasn't obvious, I'm open to any change requests.

A funny thing happened last night. I tried searching for this thread about 5 times and it seemed to have disappeared. I searched under unread, new and also under my profile/track... It was MIA. Now today, it's Back. Well, no matter, it looks great on my Nuvi screen and I tip my hat to you sjohnson. Tanks again.

Rayzers

Jon is going to change the file so that it shows up as all lower case. The other items will be addressed at a later date.

We have a very huge project going on right now that is going to greatly improve the way files are updated and managed.

Miss POI

Is there anything we can do to help?

Dom

We have some other new tools we are working on right now;) I have started to roll them out to some users and later we will introduce them to the whole community.

We are in beta test mode right now and finding issues that need to be resolved.

Miss POI

If I can be of any help, you have my contact info.

Dom

Is there anyway a paying person can get the beta file or do I have to wait till that expires?

I answered you in an email.

Miss POI