Home PageFacebookRSS News Feed
PocketGPS
Web
Read the current newsletter! Weekly
Newsletter
SatNav,GPS,Navigation
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Do We Have a Compatable Alpine database?
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Do We Have a Compatable Alpine database?
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8, 9  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> PocketGPSWorld Speed Camera Database
View previous topic :: View next topic  
Author Message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Sat Jan 26, 2013 10:56 pm    Post subject: Reply with quote

r4robert wrote:
In answer to your first 2 points, please see my earlier post above Smile
Ok, I've waded my way back through your previous posts and can't find where you said that you have tried our iGO database.

Edit. Sorry, yes you did in your first post. In what way does it not work? Does it display cams or does it lock up the device, or what? Honest, I'm trying to help.

The second point was to explain how iGO is directional and what directional means. It does not mean that the cam shows up on the 'correct side' of the road. Shocked Shocked


Last edited by M8TJT on Sun Jan 27, 2013 12:12 am; edited 2 times in total
Back to top
View user's profile Send private message
Anita
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Mar 15, 2006
Posts: 3219
Location: Windlesham, Surrey

PostPosted: Sat Jan 26, 2013 11:30 pm    Post subject: Reply with quote

Andy_P wrote:
r4robert wrote:
Can you put the answer in the FAQ's too, please?

Good idea! Hopefully one of the admin will oblige....

You mean like the sticky How to add images to your posts, the first one under "Forum Use - Help & Guidance" at the top of the Forum Index?
_________________
Anita
TomTom VIA 135 - App 12.075,
UK map 1090.11467
Samsung Galaxy S8
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Sun Jan 27, 2013 12:06 am    Post subject: Reply with quote

MaFt wrote:
Alpine are on the list of 'partners/customers' on the NNG website. So it's probably safe to say that they use iGO
Another clue is that the Alpine map updates are from naviextras.
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


Joined: May 09, 2012
Posts: 46
Location: London, Wandsworth SW17

PostPosted: Sun Jan 27, 2013 1:58 am    Post subject: Reply with quote

Quote:
Ok, I've waded my way back through your previous posts and can't find where you said that you have tried our iGO database.

Edit. Sorry, yes you did in your first post. In what way does it not work? Does it display cams or does it lock up the device, or what? Honest, I'm trying to help.

The second point was to explain how iGO is directional and what directional means. It does not mean that the cam shows up on the 'correct side' of the road. Shocked Shocked


I'm sorry too! A misunderstanding common with 'email'. You are actually being very helpful Smile , and I'm keen to 'crack' this one with your (and all) help!

Here's that screenshot I promised:



To answer your 2 questions:

1. I downloaded and tried to install iGo (for the B200) on my 928 and I did not get very far. Once I pressed 'OK' to confirm that I was sure I wanted to update the database, the unit froze after the button press. I think it looked at the data format and was completely stumped!

2. Could you explain what "Directional" means, I clearly have got it wrong Embarassed

Many thanks Smile
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


Joined: May 09, 2012
Posts: 46
Location: London, Wandsworth SW17

PostPosted: Sun Jan 27, 2013 2:04 am    Post subject: Reply with quote

Quote:
You mean like the sticky How to add images to your posts, the first one under "Forum Use - Help & Guidance" at the top of the Forum Index?

Opps! I should have checked the Stickys too; sorry Embarassed

Anyway, thanks for the advice. I'm up and running on PhotoBucket Very Happy
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 6665
Location: West London & Reading

PostPosted: Sun Jan 27, 2013 7:32 am    Post subject: Reply with quote

"Directional" is slang for the way the camera points. Most SatNavs only allow you to specify where the camera is, not which way it works/points. The result is that you get a warning even if the camera is only active for the opposite direction of travel.

Directional is something the owners of Garmins and TT's would love to crack with third party POI camera databases.
_________________
Satnav:
Garmin DS61 LMT-D (In the car)
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


Joined: May 09, 2012
Posts: 46
Location: London, Wandsworth SW17

PostPosted: Sun Jan 27, 2013 10:42 am    Post subject: Reply with quote

Kremmen wrote:
"Directional" is slang for the way the camera points. Most SatNavs only allow you to specify where the camera is, not which way it works/points. The result is that you get a warning even if the camera is only active for the opposite direction of travel.

Directional is something the owners of Garmins and TT's would love to crack with third party POI camera databases.

Rrrright!
Thanks for explaining that, I'll keep my eyes open... Smile
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx
Back to top
View user's profile Send private message
Anita
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Mar 15, 2006
Posts: 3219
Location: Windlesham, Surrey

PostPosted: Sun Jan 27, 2013 10:47 am    Post subject: Reply with quote

r4robert wrote:
Quote:
You mean like the sticky How to add images to your posts, the first one under "Forum Use - Help & Guidance" at the top of the Forum Index?

Opps! I should have checked the Stickys too; sorry Embarassed

My comment was really aimed more at Andy_P than you, Robert, since he seems to have forgotten that he wrote the sticky. Smile
_________________
Anita
TomTom VIA 135 - App 12.075,
UK map 1090.11467
Samsung Galaxy S8
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Sun Jan 27, 2013 10:48 am    Post subject: Reply with quote

r4robert wrote:

I'm sorry too! A misunderstanding common with 'email'. You are actually being very helpful Smile , and I'm keen to 'crack' this one with your (and all) help!
This often happens on forums Very Happy But now we're square
Quote:
Here's that screenshot I promised
thanks, but it doesn't help a lot. I was hoping thet the 'look and feel' might identify it. I have found the blurb about it on the internet with more pictures ans that does'nt realy help either.
Quote:
2. Could you explain what "Directional" means, I clearly have got it wrong Embarassed
Let me have another go. Supposing a road is running due east/west and a Gatso type camera is on it with its camera face pointing to the west. Because it's a Gatso, it traps you from behind when travelling in a westerly direction (heading). It won't trap you if you are travelling east.

A non directional system will give an audible alert to you the cam regardless of whether you are traveling in an easterly or westerly direction.
A directional system, such as iGO will only audio alert you to the cam if you are travelling in a westerly direction.

To do this, iGO needs to know the direction in which the cam traps (not pointing, because Gatsos trap from behind as you have passed them and Truvelos normally trap as you are approaching them)

The 'normal' iGO database has the direction of the cam in decimal degrees such as (for our westerly trap above) 270. If you are not travelling within about 45 degrees of 270, then it will not alert. However, 'your' version of iGO (if that's what it is, and I'm pretty certain that it is) seems to have the direction encoded in hexadecimal (hence the letters in the number) and in most instances of the sample that you have given us a conversion correlates reasonably accurately between what you have given us and cams in our database.

Can you connect your computer to the Alpine and show its filing system? If so we can tell you what an iGO file layout looks like. If our suspicions are correct, it would not be difficult to convert the decimal heading in the present iGO database to the format required for your version of the Alpine.

The only problem here is that we need to know if a database so modified actually works on your system and the only way of doing this is to produce the values for a couple of your 'local' cams and you see if these (a) load OK and (b)road test them to see if they are working correctly. You can't do a simulated route because iGO does not alert for cameras on a sim route (they always show on the map though)

EDIT:
Quote:
I downloaded and tried to install iGo (for the B200) on my 928 and I did not get very far
From where did you download it? I can't find a ref to this on our list of downloads, but perhaps I am missing something as I often do.
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


Joined: May 09, 2012
Posts: 46
Location: London, Wandsworth SW17

PostPosted: Sun Jan 27, 2013 10:50 pm    Post subject: Reply with quote

I've been out and about in the car today trying to asnswer some of the questions.

First, the scdb camera database does not seem to be directional, because I passed the same camera in Balham High Road both ways and it bleeped at me on both occasions.

Strangely, the option "When Approaching" for Speed Alerts has dissapeared (not greyed out, but Gone! This change happened when I found the audible alerts had were muted, so I un-muted them and lost the option. (Re-muting did nothing). I therefore have, with the scdb database a choice of visual or visual &audible, but only with "When Speeding".

I know the 928 is a complicated piece of kit (though easy to use), but I'm puzelled all the same.

I took some photos as requested, but I don't know they will help at all:








The last pic is from an ,exefile and shows waht many have suspected all along. Namely my Alpine uses iGo, "Primo" version, and therefore of NNG origin.

I downloaded the UK cameras only from the scdb database in an attempt to make things easier? -:

X,Y,TYPE,SPEED,DIRTYPE,DIRECTION
-1.76461,53.79522,1,30,0,130e3
0.21183,51.40644,1,,0,52f2
-1.90922,52.51594,1,30,0,7b202
-0.23544,51.34519,1,30,0,6e568
0.11528,51.53267,4,40,0,8bc70
0.09933,51.53114,4,40,0,7eefd
-1.71583,53.68142,1,40,0,57597
0.16794,51.06142,1,40,0,29742
-1.47117,50.99811,1,40,0,2daed
-1.18464,53.00872,4,40,0,59e88
-1.17900,52.99703,4,40,0,5d3cc
-0.18531,51.48314,3,30,0,7c0e3
-2.97231,53.40381,2,,0,1edad
-2.15169,52.50833,1,30,0,c9c01
-2.58986,54.19722,1,40,0,12b2aa
-0.06808,51.59839,3,30,0,387a
-0.08358,51.49250,1,30,0,75d62
-0.16183,51.41653,1,30,0,4551d
-0.17631,51.40431,1,30,0,4011f
-3.02278,50.91333,1,50,0,6e6b6
-2.75731,51.60992,1,50,0,17558f
-0.20806,51.45508,2,,0,5d3a
-2.62300,53.80517,1,30,0,51338
-1.76642,53.80767,1,30,0,13198
-0.41125,51.78297,1,,0,a1a4
-0.39286,51.73519,1,,0,dd32
0.45528,51.57167,2,,0,e4a5
0.15550,51.45028,1,30,0,36394
-4.43861,57.59908,2,,0,1d5b1
-1.24492,53.02050,1,,0,5fe1
-0.73547,51.10950,4,,0,12b3f
-0.71617,51.12242,4,,0,117f4
0.13722,51.47828,1,30,0,60bbe
0.15117,51.52419,4,50,0,b201d
0.14114,51.52847,4,50,0,caaa2


I also created two Alert Points and travelled between them, but I have failed to download the database. I get a blank SD card. I've formatted, and prepared it, but still no success.

I will post again shortly, hopefully with the coordinates of a local camera.
Got PC problems so need to re-boot...

Thanks Smile
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Sun Jan 27, 2013 11:25 pm    Post subject: Reply with quote

The last screenshot gives it away a bit Very Happy Our iGO database should run ok on it. I have tested it on Primo and it works just fine. I have sent you a Private Message.

You say that the PGPSW database locks it up, but does the SCDB database actually work on your device or not?


Last edited by M8TJT on Mon Jan 28, 2013 1:00 am; edited 1 time in total
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


Joined: May 09, 2012
Posts: 46
Location: London, Wandsworth SW17

PostPosted: Mon Jan 28, 2013 12:12 am    Post subject: Reply with quote

M8TJT wrote:
The last screenshot gives it away a bit Very Happy Out iGO database should run ok on it. I have tested it on Primo and it works just fine. I have sent you a Private Message.

You say that the PGPSW database locks it up, but does the SCDB database actually work on your device or not?
Yes it certainly looks that way.

I will need to test the PGPSW Alpine database tomorrow.

In the meanwhile I've been out in my car again and here are the coordinates of a camera in Upper Tooting Park Road London SW17
N51 26.344' W0 9.378. I parked the car by it!. Problem is that the person recording the position was probably 50 yards away? Anyway, the best I can do.

I have also put the scdb UK database (all 5711 lines of it) in to Excel and sorted it in accending numbers. Here's a taste:

X,Y,TYPE,SPEED,DIRTYPE,DIRECTION
-0.01442,51.26881,4,50,0,a5548

-0.00075,51.42047,1,30,0,75ae9
0.00222,51.41831,1,30,0,327b4
-0.00253,51.44506,2,,0,12eb
0.00431,51.49517,4,30,0,75c4d
-0.00436,51.46000,1,30,0,7208e
-0.00436,51.46008,1,30,0,3288a
0.00436,51.49508,1,30,0,73e70
-0.00439,51.53628,2,,0,aae
-0.00458,51.43075,1,30,0,1c208
-0.00483,51.57939,1,30,0,5ba25
-0.00483,51.57950,1,30,0,12cb7
0.00578,51.57906,1,40,0,9310a
0.00611,53.09744,1,40,0,6a40b
0.00636,51.57892,1,40,0,3bebc
0.00667,51.58639,1,40,0,61483
-0.00669,51.55622,1,50,0,12d71
-0.00761,51.53356,2,,0,2ecd
0.00775,51.56867,1,50,0,fc0d
0.00811,51.56886,1,50,0,860c5
-0.00833,51.37414,1,30,0,70439
-0.00833,51.51408,4,30,0,8112b
-0.00864,51.51539,1,40,0,52638
-0.00878,51.51522,1,40,0,a98ce
-0.00931,51.34764,1,30,0,7049b
0.00944,53.10861,1,60,0,a7264
-0.00958,51.34778,1,30,0,27748
-0.01031,51.52194,1,40,0,5768f
-0.01053,51.52056,1,40,0,ae92d
-0.01061,51.47253,1,30,0,6160d
-0.01067,51.44514,1,30,0,23bf1
-0.01081,51.50728,1,40,0,843f1
-0.01111,52.47372,4,50,0,a54f7
-0.01114,52.47372,4,50,0,330da
0.01150,51.57697,1,40,0,3c0be
-0.01219,51.52833,1,40,0,46063
-0.01272,51.55206,1,50,0,9bf34
-0.01333,51.50722,1,40,0,2fa3d
-0.01375,51.51119,2,,0,174d
0.01394,51.57492,1,40,0,9fb72
-0.01408,51.58992,1,30,0,6354a
-0.01433,52.34106,1,60,0,baf89
-0.01472,51.51111,1,30,0,6358a
0.01486,51.51681,4,50,0,322ae
-0.01486,51.57392,1,30,0,5646a


I've put the best match I could find at the top. But it's still way out Sad

I'll have another go at driving between 2 Alert Points (that are in a northerly direction) tomorrow. I seem to have had some 'SD card trouble' today. Seems the 928 is picky about its cards Shocked

Thanks Smile
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx
Back to top
View user's profile Send private message
MaFt
Pocket GPS Staff
Pocket GPS Staff


Joined: Aug 31, 2005
Posts: 14794
Location: Bradford, West Yorkshire

PostPosted: Mon Jan 28, 2013 12:42 am    Post subject: Reply with quote

Can you try something for me...

Import the file into Excel (or equivalent) - you may need to rename it as a CSV first.

The empty the last 2 columns for dirtype and direction.

Export it to a new file and rename it back to a .txt file.

Install this file.

I want to see if the freeze you mentioned was caused by the file as a whole or just by the presence of numerical direction values.

MaFt
Back to top
View user's profile Send private message Visit poster's website
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Mon Jan 28, 2013 12:47 am    Post subject: Reply with quote

r4robert wrote:
In the meanwhile I've been out in my car again and here are the coordinates of a camera in Upper Tooting Park Road London SW17
N51 26.344' W0 9.378. I parked the car by it!. Problem is that the person recording the position was probably 50 yards away? Anyway, the best I can do.
The top one in your list is not it. There are cams closer to that. You have got Degrees, mins mixed up with decimal degrees.
The correct decimal conversion to your cam above is 51.43918,-0.15618.
Do you mean Tooting Bec Road? If so, we don't have a cam on that road. The nearest one is on Balham High Road at Latitude: 51.43920 Longitude: -0.15622, single direction trapping travelling North
Back to top
View user's profile Send private message
M8TJT
The Other Tired Old Man
The Other Tired Old Man


Joined: Apr 04, 2006
Posts: 10118
Location: Bexhill, South Sussex, UK

PostPosted: Mon Jan 28, 2013 12:49 am    Post subject: Reply with quote

MaFt wrote:
Export it to a new file and rename it back to a .txt file.
In my experience, if you do that, Excel puts "" around everything and it doesn't work Sad Geez, the site is slow tonight.
Back to top
View user's profile Send private message







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> PocketGPSWorld Speed Camera Database All times are GMT + 1 Hour
Goto page Previous  1, 2, 3, 4, 5, 6, 7, 8, 9  Next
Page 3 of 9

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB 2.0.11 © 2001 phpBB Group
phpBB port v2.1 based on Tom Nitzschner's phpbb2.0.6 upgraded to phpBB 2.0.4 standalone was developed and tested by:
ArtificialIntel, ChatServ, mikem,
sixonetonoffun and Paul Laudanski (aka Zhen-Xjell).

Version 2.1 by Nuke Cops 2003 http://www.nukecops.com

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
20.064 (22 Jun 22)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







Terms & Privacy


GPS Shopping