Do We Have a Compatable Alpine database?

[r4robert]

Hi

I have just had an Alpine W928R Nav/music unit installed in my car.

I appreciate that the only compatible Alpine listed is the PMD-B200P, but I was wondering whether someone had found a database they could 'tweak'? The iGO .txt files are not dissimilar, but obviously don't work with my Alpine 928.

Here are the first few lines of the Alpine text file database:

X,Y,TYPE,SPEED,DIRTYPE,DIRECTION
1.55944,42.52194,1,60,0,9b298
1.48217,42.44667,1,60,0,15001
1.53750,42.50714,1,50,0,8fdc2
1.50833,42.55250,1,50,0,ade8d
1.55439,42.51875,4,,0,d8b9

It's not entirely different to the iGO text downloaded from PGW:

X,Y,Type,Speed,DirType,Direction
-2.17787,50.68304,1,40,1,268
-2.09934,50.70723,1,30,1,37
-2.08935,53.5027,1,20,1,239
-0.11083,52.02668,1,70,1,45
-0.3958,51.52151,1,50,1,40

Although the Alpine data has letters....

So, is there any database that I could use or adapt?

(I might mention that I subscribed to scdb, and after numerous emails with Support, I have asked for a refund. Their 'Installation Instructions' didn't work - I devised my own - and their database only gives me visual warnings not audible ones. Therefore, it's of little use).

This is my first post, and thanks in advance

[Andy_P]

So, at first glance it looks like the camera heading is being described in hex notation somehow,

I tried looking for the first couple of camera locations in your Alpine list and there *is* a 60km/h camera at N42.52194, E1.55944 (in Andorra!) and its heading looks like almost exactly 225 degrees

So how do we get from "225" to "9b298"?

Unfortunately if I repeat the exercise with any of the other sets of coordinates, I don't fond a camera there, either on the PGPSW submission map or on Streetview.

So bang goes that theory so far.

Any chance you could get a few of the UK cameras in your Alpine list?
_________________
"Settling in nicely" ;-)

[r4robert]

Thanks for the research and input

The problem with the database is that you are given "Western Europe" (minus France I might add...), so it's pot luck choosing a coordinate that is in the UK!

I assume that text with letters is a form of 'coding' that is unique to new-ish Alpine Sat Navs? In which case I will have to stick with the Alpine database.

It's not a problem, but I've been using PGW on my TomTom for a while now, and it IS very good, hence my preference for my new Alpine.

Any further ideas?

Thanks

[M8TJT]

Bung them into excel then sort them by longitude and look for some between 0 and 4W, then look for ones above 50N that will give you only UK cams.
Problem will be is finding out how they have converted a decimal degree azimuth to the hexadecimal value in your list.
When you have found a few, post them here and the mathematical geniuses will have a look.

[r4robert]

Thanks M8TJT for your wise words

Here are the first couple of dozen coordinates, hopefully chosen correctly?
The letters baffle me!

3.49361,50.95508,3,70,0,8c399
4.40261,50.86669,3,70,0,1aeb5
4.69578,50.85478,1,50,0,10fca
4.70800,50.88681,3,50,0,136410
4.70844,50.88694,3,50,0,2d54dc
4.82308,50.17625,1,50,0,1b3224
4.46569,50.66994,1,50,0,91a59
3.49403,50.95542,3,70,0,2667a7
3.44414,50.86903,3,90,0,46b72e
3.05550,50.93678,1,50,0,32fa
4.65247,50.93819,1,50,0,310f8f
4.70936,50.88639,3,50,0,136498
4.31239,50.85886,3,50,0,2bf6d7
4.71247,50.78756,1,50,0,1b06ef
4.47719,50.82042,3,70,0,2d96c7
4.61375,50.96433,1,50,0,11b89f
2.74464,50.93322,1,50,0,15bc50
4.38542,50.86639,3,50,0,1c0dce
4.70986,50.95153,1,50,0,3125fa
4.91489,50.84044,1,70,0,46d2d1
4.93389,50.73278,1,50,0,193dd
2.81722,50.88583,3,50,0,87eb2
4.75611,50.95106,1,50,0,21f5cb
4.38186,50.92969,3,50,0,12215a
2.87556,50.78417,1,70,0,9e184

Thanks
-Robert
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx

[Andy_P]

I think M8TJT's geography is a bit out... we are still in Belgium for the first ones I tried!

(EDIT, sorry, not M8's fault at all, you've given us from 0-4 degrees EAST not West.. but never mind, it gives us some good data to go with...)


3.49361,50.95508,3,70,0,8c399 - REDSPEED:109653@70 Heading:45
4.40261,50.86669,3,70,0,1aeb5 - REDSPEED:99711@70 Heading:5
4.69578,50.85478,1,50,0,10fca - No cam. visible on our map or Streetview
4.70800,50.88681,3,50,0,136410 - REDSPEED:101353@50 Heading:125
4.70834,50.88691,3,50,0,2d54dc - REDSPEED:101354@50 Heading:202
4.82308,50.17625,1,50,0,1b3224 - GATSO:74677@50 Heading:180
4.46569,50.66994,1,50,0,91a59 - pGATSO:117204@50 Heading:45
3.49403,50.95542,3,70,0,2667a7 - REDSPEED:109652@70 Heading:225
3.44414,50.86903,3,90,0,46b72e - REDSPEED:111141@70 Heading:348
3.05550,50.93678,1,50,0,32fa - GATSO:112553@50 Heading:22
4.65247,50.93819,1,50,0,310f8f - GATSO:101357@50 Heading:315


Someone else fancy doing some more? Work from the bottom up and we'll meet in the middle!



4.70936,50.88639,3,50,0,136498
4.31239,50.85886,3,50,0,2bf6d7
4.71247,50.78756,1,50,0,1b06ef
4.47719,50.82042,3,70,0,2d96c7
4.61375,50.96433,1,50,0,11b89f
2.74464,50.93322,1,50,0,15bc50
4.38542,50.86639,3,50,0,1c0dce
4.70986,50.95153,1,50,0,3125fa
4.91489,50.84044,1,70,0,46d2d1
4.93389,50.73278,1,50,0,193dd
2.81722,50.88583,3,50,0,87eb2
4.75611,50.95106,1,50,0,21f5cb
4.38186,50.92969,3,50,0,12215a
2.87556,50.78417,1,70,0,9e184

But I'm afraid so far I'm not seeing any pattern to the Heading info.

I suppose at a pinch you could just ignore it and put dummy values in for the heading and have a non-directional system?
_________________
"Settling in nicely" ;-)

[r4robert]

Thanks Andy_P

The GPS coordinates for, say, Buckingham Palace London are:
51.501356,-0.141985

So I've selected coordinates with '51'.

I am still deeply puzzled by the total absence of a '0' in the entire database (!), which of course corresponds to London's latitude.

Anyway, what do I know

Here are the cherry picked coordinates:

2.71381,51.13411,3,70,0,10e2f9
2.88317,51.08606,1,90,0,7a6a9
4.41203,51.19322,3,50,0,1987f3
3.00083,51.12064,3,70,0,153eff
4.11653,51.01222,1,50,0,3389f5
4.92767,51.13633,1,70,0,41b1d7
4.44294,51.08686,1,120,0,7fad86
2.94114,51.22708,1,70,0,14807e
2.94161,51.22647,1,70,0,16fd1
4.40086,51.26492,3,70,0,3943b6
4.41444,51.22639,3,50,0,1a501c
4.41489,51.22594,3,50,0,365429
3.31097,51.31517,3,70,0,288347
4.41542,51.22422,3,50,0,36545e
4.45947,51.26817,1,120,0,658e3b
4.56917,51.06986,1,50,0,96dbd
4.48556,51.24972,3,50,0,d312c
3.42639,51.14239,3,90,0,4da57
4.55028,51.14194,3,50,0,2f8814
2.95386,51.14931,3,50,0,42dde
3.31044,51.31469,3,70,0,b189a
3.27489,51.20719,1,70,0,ff1cb
3.23472,51.22083,3,70,0,35785e
4.57667,51.00206,1,50,0,120013
4.60369,51.04497,1,70,0,ce7c9

Thanks
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx

[Kremmen]

That directional stuff is a mystery to me as well.

I've tried all the converters I know to give any form of compass bearing and I can't find one

hex
binary
decimal
ASCII
_________________
DashCam:
Viofo A119 V3

[Andy_P]

[GerryC]

Out of interest, where does the other list come from? - I'm thinking it may be some sort of camera ID and not a direction indicator. Even 360 is only 168 in hex.

Is it possible to make new POIs on the unit itself and if so, can you export it and see what format it uses? Even better would be if it lets you enter the direction so you can see what it gives for eg 0,90,180,270,360.


For some reason, some of the formats for POIs (eg Google) have the order swapped round, so they put the Latitude first, then the Longitude. I'm not sure if either are "correct".

Gerry

[Oldboy]

[M8TJT]

[M8TJT]

converting the hex to decimal and then dividing by 10,000 gives a fair approximation with one exception.
cams in order as per Andy_P corrolation is like this:
Andy's heading = the hex number/10000
45=57
5=11
No cam
125=127
202=297
180=178
45=59
225=251
348=463
22=1.3
315=321

But of course, this is all totally academic as we don't know whether the Alpine is directional. If not, who cares what's in the last column.
Where did the OP's list come from, the Alpine database of the other speed cam site?

[GerryC]

Yes, I saw that but thought it may not be what a bit of text at the top of the file says it should be. If you are sure it's the direction, you'll be able to say what format it's in.

Working out what the bit of code at the end means is the point of the thread. I'm just thinking that it isn't what it says it is.

Gerry

[M8TJT]

Divide by 13,000 gives an even better correlation on most of them.

@Gerry That's why I asked where they came from

We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?.
Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!