Home PageFacebookRSS News Feed
PocketGPS
Web
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 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
r4robert
Occasional Visitor


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

PostPosted: Thu Jan 24, 2013 9:55 pm    Post subject: Do We Have a Compatable Alpine database? Reply with quote

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 Very Happy
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Thu Jan 24, 2013 11:36 pm    Post subject: Reply with quote

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" ;-)
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


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

PostPosted: Fri Jan 25, 2013 12:05 am    Post subject: Reply with quote

Thanks for the research and input Very Happy

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 Very Happy
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: Fri Jan 25, 2013 12:18 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


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

PostPosted: Fri Jan 25, 2013 12:16 pm    Post subject: Reply with quote

Thanks M8TJT for your wise words Very Happy

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 Very Happy
-Robert
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Fri Jan 25, 2013 12:38 pm    Post subject: Reply with quote

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

(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! Laughing



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" ;-)


Last edited by Andy_P on Fri Jan 25, 2013 1:08 pm; 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: Fri Jan 25, 2013 1:04 pm    Post subject: Reply with quote

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 Confused

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 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: 7037
Location: Reading

PostPosted: Fri Jan 25, 2013 3:04 pm    Post subject: Reply with quote

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 Sad

hex
binary
decimal
ASCII
_________________
Satnav:
Garmin 2599 LMT-D (Indoor test rig)
DashCam:
Viofo A119 V3
Car Average MPG :
Back to top
View user's profile Send private message
Andy_P
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Jun 04, 2005
Posts: 19991
Location: West and Southwest London

PostPosted: Fri Jan 25, 2013 3:11 pm    Post subject: Reply with quote

r4robert wrote:
Thanks Andy_P

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


That's right. That's the way Google formats it, Latitude first, then Longitude, and it uses minus signs for "south" and "west"
To enter those on a TomTom, you'd just replace the minus sign with "s" if it was a Latitude or "w" on a Longitude.

For some reason, many of the text formats for POIs (like yours) have the order swapped round, so they put the Longitude first, then the Latitude.

r4robert wrote:
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.


No, "0" refers to London's Longitude.... Wink
_________________
"Settling in nicely" ;-)
Back to top
View user's profile Send private message
GerryC
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Mar 01, 2005
Posts: 1513
Location: West Mids

PostPosted: Fri Jan 25, 2013 4:36 pm    Post subject: Reply with quote

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. Very Happy I'm not sure if either are "correct".

Gerry
Back to top
View user's profile Send private message Visit poster's website
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10641
Location: Suffolk, UK

PostPosted: Fri Jan 25, 2013 5:09 pm    Post subject: Reply with quote

GerryC wrote:
... I'm thinking it may be some sort of camera ID and not a direction indicator. Even 360 is only 168 in hex.
From the OP -

Quote:
X,Y,TYPE,SPEED,DIRTYPE,DIRECTION
1.55944,42.52194,1,60,0,9b298

_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
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: Fri Jan 25, 2013 5:15 pm    Post subject: Reply with quote

GerryC wrote:
I'm thinking it may be some sort of camera ID and not a direction indicator.
Providing the legend that ....
Damn, Oldboy beat me t Very Happy o it
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: Fri Jan 25, 2013 5:39 pm    Post subject: Reply with quote

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?


Last edited by M8TJT on Fri Jan 25, 2013 5:44 pm; edited 1 time in total
Back to top
View user's profile Send private message
GerryC
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Mar 01, 2005
Posts: 1513
Location: West Mids

PostPosted: Fri Jan 25, 2013 5:41 pm    Post subject: Reply with quote

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. Wink Smile

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. Confused

Gerry
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: Fri Jan 25, 2013 6:00 pm    Post subject: Reply with quote

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

@Gerry That's why I asked where they came from
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 1, 2, 3, 4, 5, 6, 7, 8, 9  Next
Page 1 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

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
22.034 (27 Mar 24)



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