Monday, December 28, 2009

POI for Dummies

source: POI Factory

Speed Camera loading for Dummies
How many would like to know how to set speed alerts to only alert if you are going to fast!!!!
Well I have searched on this site and read all the threads and even the help section in the poi loader and it was not clear to me on how this works. I have been watching and reading all this stuff and I see there are a lot of us that can’t understand a lot of this lingo.
So I started to play with all the info from this site and my GPS and have figured it out,, some of you might already know this, but it is hard to ask a question on how to do this stuff on these web sites (it’s easier to talk on the phone or in person to get information).
So here it is as per my findings on how to set the speed alerts to only alert you if you are going faster than the posted speed.
1rst you need to go into the speed camera cvs file and add the @ sign before the speed in all the line (this is on the threads here and in the help section on the poi loader), this will take some time but it is worth it. I only did this for my state at this time.
Example: speed camera @65mph
By doing this it will also turn the grey bar to red and won’t stop alerting till you slow down.
Next on the same file increase the speed by 7 to 10 mph I have mine set at 10mph above the posted speed. (AZ cameras will flash at 11mph over).
Example: 65 + 8 =73mph
Speed camera @73 mph
What this will do is alert you only if the difference is greater than 7 mph. So you can cruise at 65 to 66 mph with out an alert just the icon will appear.
Now when you load this file after you made all the changes go into the poi loader and when you come to speed camera file select the distance at the bottom and enter 0 not the 1985 change to 0.
I hope this will make it easier to understand on how this file will work. I was getting tiered of every mile and a half of beep, beep, beep, caution approaching speed camera.
AZ has or will have over a 100 + speed cameras and I drive all over the valley and it gets annoying at times to have the alert always sounding. Now I set the cruise control and I still see the Icon but no beeping unless I am going to fast then it lets me know.
‹ Chicago area red light cameras San Diego redlight camera's multipying? ›

4-Garmin Nuvi 760>>>> Owner: Sunrise Mechanical A/C & Heating,, Peoria, Arizona



Tue, 12/16/2008 - 9:00pm
Felix Krull's picture

Felix Krull
general maintainerpoi contributoractive user
An Excel formula to automate changing the camera data

I've worked up an Excel formula that will insert the @ sign in the right place and let you specify an adjustment value to the speed limit as ramcruzer described in his original post. I've also written up a few steps to help you use it in the red light camera file. Hopefully, it won't be too hard to follow, even if you don't use Excel very often.

What it does: If a camera description contains the characters "MPH", the "@" sign will be inserted in front of the speed limit, the speed limit will have 5 mph added to it, and the result placed in a new cell. (Step 4 tells you how to use a different value than 5 mph if you want to change it. If you're OK with 5 mph, you can skip step 4.) If there is no "MPH" in the description, the contents will be copied unchanged to a new cell. The steps below assume as an example that there are 100 rows of speed camera data in the spreadsheet.

1. Open Speed-Cameras.csv
2. Insert a column between columns C and D. This should become the new, blank column D.
3. Copy the formula below and paste it into cell D1.
4. Look in the formula for the characters "&RIGHT". Immediately to the left of that is "+5". This part of the formula adds 5 mph to whatever the speed limit value is. If you want to use a different adjustment, change it here. (In other words, use "+7" for a 7 mph adjustment, "+0" for no adjustment, etc.).
5. Copy the formula in D1 and paste it into the remaining cells in column D that have data in the corresponding cell in column C. In other words, if there are 100 cameras in the file, copy D1 and paste it into cells D2-D100.
6. Next select all the non-blank cells in column D (D1-D100). Copy the selection. Leave the cells selected; don't click anywhere else on the spreadsheet until you do the next step.
7. On Excel's "Edit" menu, click "Paste Special". In the dialog box that comes up, choose the "Values" button and click "OK".
8. Delete Column C. Your new data will now become Column C.
9. Save the file as a CSV.

Here's the formula. Make sure you copy and paste it with no changes, spaces or line breaks. It should be one long line wherever it appears in your spreadsheet.


I wrote this in Excel 2003 but it should work in Excel 2002 ("Office XP") and up. I hope you find it useful.

Friday, January 2, 2009

Cathedral Lake Lodge

Near Keremeos, which is in the valley bottom on the Similkameen River.

The "camp" and Cathedral Lodge is high, high, high up.

You may have heard about Cathedral, obviously you have, why else would you be going.  Its not like the Rockies (Canadian) where 86% of the visitors barely get out of their vehicles to go for a hike.  They just want to drive through the park, and see its wide valleys to get the views.  14%, make the extra effort, ....... planned effort, and head out for places like Sentinel Pass and leave Morraine Lake or Lake Louise far below.

Ah yes, Sentinel Pass, we did that from the Morraine Lake side and then having made the long climb up, decided NOT to return by the same route.   We went down the opposite side, which was much longer, much more enjoyable (fewer people).  All that was needed later was to catch a ride back up to Morraine Lake where we had left our car.

Cathedral is different, thankfully, because its not a Must see Lake Louise tourist destination, yet.

From Keremeos and the Similkameen Valley, Cathedral's hiking area is not visible at all, and once you're up there, all of the nearby valleys look the same.    Closest thing to Cathedral, not in location, but in sheer enjoyment, is Lake O'Hara in Yoho National Park, right on the western side of the Continental Divide.   O'Hara offers the same two options of getting into the hiking area, by School Bus or hiking, and like Cathedral, stay off of the Road, walk on the hiking trail (which is more difficult and delays, delays, delays....).  My advice, don't waste your time by hiking.  You're going to need every ounce of stamina, and strength, to enjoy the day(s) ahead of you, with of course, relaxing at night as well.


Everyone starts from the same location, the parking lot.   We took the Private four-wheel-drive method, rough ride, not paved, its four wheel territory.  Keep your hands and arms inside the vehicle, the trees are that close to the "road".   And you will get to know your neighbour on the seats!

Still thinking of hiking?   Stay on the trail, don't even think about using the "road".............. and if one or two of your group IS taking the trucks, give them the heavier packs!

Accommodations and Brochures

The Lodge and the Cabins;   electricity (generated on site), beds, wood stoves if needed, FOOD cooked by someone else, sandwiches too for the day hike.  Canoe on THE Lake ..... which is NOT called "Cathedral", its higher up.  Quiniscoe Lake is where the "accommodation" areas are.    The Lodge and the Cabins, along with the Public tenting area, are on Quiniscoe Lake.... and once there, don't forget to ask where the helicopter landing areas are.... NO!!!!  they're not to be used as a short cut In and Out (unless.......)

Don't even think you can buy a flight in or out.   The helicopters are only brought in in an emergency, like forest fire or some other disaster.    There is a "However Clause".

With the exception of winter helicopter and/or snowmobile access to the Resort, and the summer transport service, there will be no mechanized support allowed for commercial recreation use of the Park.  (Page 51)

In 2008, there was a working hot tub, in the Lodge......   its 2012, and hot tub is working just fine and you can thank the Pine Beetle for that luxury.  NB: 2014: no mention of the hot tub, but here are the going Rates....          Contact        &   Mail Too

The Map   at the top of this POST.

Yellow solid line is the Canada - USA border

Yellow PINS are on Hiking trails, it's difficult to say where it really becomes steeper, therefore I didn't mark it on my GPS, but from before #59, its definitely steeper, like in a forty-five degree angle with left and right sides of the spine dropping off steeper than forty-five degrees.  Plenty of rocks to stop you from tumbling.    Breathe......breathe..... the hike is well worth the effort, and if the weather holds, the view is Fantastic, it was for us in September of 2008.

Cathedral Lake Lodge is within Cathedral Park Provincial Park

Here are the Trails and the then "current" conditions for September 18, 2008

Not all trails go straight up, some go DOWN first then STRAIGHT up...... just remember that when planning your return hike.   Typically we saw more people at the Lodge at Supper time than we saw on the trail, which might sound right, but there's a lot of campers at the Lake too.  30 campsites

Sections of the Quiniscoe Lake Campground will be closed for re-construction in 2012, please check back to this website for updated closure information. Lake of the Woods campground will be used as the alternate location for camping when campsites at Quiniscoe Lake are not available.  SOURCE

Once 2012 is over and done with, and left time to Vote in the Provincial Election:

Quiniscoe Lake has 30 sites designated by number posts. The sites are spread out along the southern shore of the lake amongst Engelmann spruce, Lyall's larch and Sub-alpine fir. Boulders and rock outcroppings are strewn about the area, evidence of the area's glacial history. The sites feature framed earth tent pads to minimize the impacts of camping by keeping people in designated areas. The sites are grouped together in clusters of three or four in order to share the 12 picnic tables and 13 fire rings. There are four pit toilets in the campground, one is near the lodge access road, a second is behind the ranger cabin between sites 4 and 7 and the other two are further along the lake beside the trail to sites 21-25. A firewood corral is located near the lodge access road approximately 100m from the campsites. Campers are reminded to conserve firewood. There are four wire mesh food caches on the ground to protect supplies from rodents and birds. They are not bear proof.  SOURCE

The information above, and a map of the area, I photographed to have IN my camera, for use later on.  And yes I have several Back up Batteries as well.
"They", those at the Lodge, said that you wouldn't even have to stand on your tiptoes to see Mount Baker from Scout Mountain, which was true, however, I found that once home, with the use of Google Earth,  I did manage to plant a pole on top of the American focal point.