Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
MacFixer, the iPhone, iPod, and iPad specialists
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Txt format DB for Alpine Satnav help please
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Txt format DB for Alpine Satnav help please
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> PocketGPSWorld Speed Camera Database
View previous topic :: View next topic  
Author Message
Antitheft2
Occasional Visitor


Joined: Aug 25, 2009
Posts: 8

PostPosted: Tue Aug 25, 2009 1:57 pm    Post subject: Txt format DB for Alpine Satnav help please Reply with quote

Hi,

Have been hunting for an answer to this for days now and wondering if anyone can help.

I have an Alpine PMD-B200P Satnav unit (hand held unit that docks with the stereo in my car to give in car satnav too).

I love this unit, but the default camera poi is pretty useless and I'm hoping to use the PGPSW database instead.

I've tried the one from your main "competitor" which works perfectly but only lists fixed cameras and doesn't give warnings of possible mobile positions.

Importing the database on the Alpine unit is really straight forward and is done via a specifically formatted text file. I'm hoping that one of the standard text files available through PGPSW is compatible. But as I'm sure you'll understand I don't want to pay my £20 just to find out that none of them are.

So, if possible I'm hoping someone confirm that one of the txt file format databases on PGPSW matches the below format because if they do, then they'll work with the Alpine unit and I'll happily spend my money to get it.

Code:
X, Y, TYPE, SPEED, DIRTYPE, DIRECTION
-1.9092200,52.5159400,1,30,0,0
-0.2354400,51.3451900,1,30,0,0
0.1680300,51.0614700,1,40,0,0


If anyone can help I'd be extremely grateful and will be paying for the full DB straight away.

Thanks in advance.
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: Tue Aug 25, 2009 2:40 pm    Post subject: Reply with quote

I haven't seen one that looks exactly the same as that, usually there is either a single file with all the cameras in, in something like this format

Code:
;Longitude,Latitude,Name
-2.17787,50.68305,"GATSO:1@40"
-2.09933,50.70723,"GATSO:2@30"
-2.08935,53.5027,"GATSO:3@20"


or they are split out into several files, one for each speed and camera type, like this
Code:
;Longitude,Latitude,Name
-2.08935,53.50271,"GATSO:3@20"
-0.13769,51.32807,"GATSO:364@20"
-0.05071,51.453,"GATSO:562@20"


and:
Code:
;Longitude,Latitude,Name
-2.09933,50.70723,"GATSO:2@30"
-2.48385,52.69615,"GATSO:12@30"
-2.07761,53.5114,"GATSO:13@30"


The above is the "Garmin POI Loader" .csv version, but there are many other text-types that are similar but with slight differences to the layout. For example I've just noticed there is no "heading" info in that version. I'll just have a hunt for one of the ones that does....

I suppose what I'm trying to say is that *if* there isn't one ready-made to suit your needs, it shouldn't be too difficult to cut and paste one up from something else in Excel or similar to give you the correct columns, which you could then save out as text.
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: Tue Aug 25, 2009 2:44 pm    Post subject: Reply with quote

Ignore all the above waffle!

Here's the "iGo" format download:

Code:
X,Y,Type,Speed,DirType,Direction
-2.17787,50.68305,1,40,1,268
-2.09933,50.70723,1,30,1,37
-2.08935,53.5027,1,20,1,239


How does that look? Smile
Back to top
View user's profile Send private message
Antitheft2
Occasional Visitor


Joined: Aug 25, 2009
Posts: 8

PostPosted: Tue Aug 25, 2009 2:53 pm    Post subject: Reply with quote

Andy_P wrote:
Ignore all the above waffle!

Here's the "iGo" format download:

Code:
X,Y,Type,Speed,DirType,Direction
-2.17787,50.68305,1,40,1,268
-2.09933,50.70723,1,30,1,37
-2.08935,53.5027,1,20,1,239


How does that look? Smile


That looks pretty much spot on! Smile

I'd heard that the Alpine system was based on the Igo but hadn't been able to confirm it.

Massive thanks for that, am now off to purchase my membership and get my cameras up to date at last.

Thanks again Smile
Back to top
View user's profile Send private message
Antitheft2
Occasional Visitor


Joined: Aug 25, 2009
Posts: 8

PostPosted: Tue Aug 25, 2009 3:30 pm    Post subject: Reply with quote

Membership bought and iGo DB downloaded.

Can confirm this worked first time with no modifications perfectly on the Alpine PMD-B200P have confirmed this by checking multiple locations on the maps where I know cameras are located or used and every single one now shows up correctly (even the mobile ones).

Huge thanks for your help. You may want to arrange for that unit to be listed as compatible with the iGo database, I can provide installation instructions if needed.

Cheers

One happy customer Smile
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: Tue Aug 25, 2009 3:39 pm    Post subject: Reply with quote

Antitheft2 wrote:

Huge thanks for your help. You may want to arrange for that unit to be listed as compatible with the iGo database, I can provide installation instructions if needed.


Not something I can do personally, but I'm sure the admin will be interested to know!

Glad it all worked out fine! Smile
Back to top
View user's profile Send private message
MaFt
Pocket GPS Staff
Pocket GPS Staff


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

PostPosted: Thu Aug 27, 2009 4:57 pm    Post subject: Reply with quote

can you let me know if any of these are what you did: http://www.pocketgpsworld.com/uksafetycameras-igo-myguide-oncourse_navigator.php

thanks

MaFt
Back to top
View user's profile Send private message Visit poster's website
Antitheft2
Occasional Visitor


Joined: Aug 25, 2009
Posts: 8

PostPosted: Thu Aug 27, 2009 5:27 pm    Post subject: Reply with quote

Forgive me for posting a link to something on one of your rival's sites but it's the easiest way to show the exact process as it's written for the Alpine device in question.

I simply deleted the original files and copied the files from the iGO download I bought from you over to the location mentioned in this and reset the device and it worked perfectly.

CLICK HERE

Please remove the link once you've viewed it if you aren't happy for it to be there, I'm simply posting it for pure convenience to save writing it all out.

Cheers Smile
Back to top
View user's profile Send private message
MaFt
Pocket GPS Staff
Pocket GPS Staff


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

PostPosted: Thu Aug 27, 2009 6:36 pm    Post subject: Reply with quote

tried that link earlier (you sent it via support ticket) but still can't view it...

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


Joined: Jan 04, 2006
Posts: 9323
Location: Durham, UK

PostPosted: Thu Aug 27, 2009 6:38 pm    Post subject: Reply with quote

Can't seem to access http://www.scdb.info either.... Suggests website is down...
Back to top
View user's profile Send private message
Antitheft2
Occasional Visitor


Joined: Aug 25, 2009
Posts: 8

PostPosted: Thu Aug 27, 2009 6:40 pm    Post subject: Reply with quote

Heh, at least I know the support ticket got through ;) the site was working fine when I posted it, looks like that site is having "issues" at the moment.

Go to their main site (if you can get it to open, seems intermittent at best today). Click on Alpine on the left and then choose "Blackbird 2", the link to the installation instructions is at the bottom.
Back to top
View user's profile Send private message
AliOnHols
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Oct 15, 2008
Posts: 1936

PostPosted: Thu Aug 27, 2009 6:44 pm    Post subject: Reply with quote

I can confirm that the link as provided by Antitheft2 worked when it was originally posted.
_________________
Garmin Nuvi 2599
Android with CamerAlert, OsmAnd+, Waze & TT Europe.
TomTom GO 730, GO 930, GO 940 & Rider2.
SatMap Active 10 & 20.
Back to top
View user's profile Send private message
Antitheft2
Occasional Visitor


Joined: Aug 25, 2009
Posts: 8

PostPosted: Thu Aug 27, 2009 6:47 pm    Post subject: Reply with quote

Heh, at least I know I'm not going insane. Thanks for that Smile
Back to top
View user's profile Send private message
MaFt
Pocket GPS Staff
Pocket GPS Staff


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

PostPosted: Thu Aug 27, 2009 8:29 pm    Post subject: Reply with quote

Antitheft2 wrote:
Heh, at least I know the support ticket got through ;) the site was working fine when I posted it, looks like that site is having "issues" at the moment.


2 of us have replied to the ticket today... did you receive either?!

MaFt
Back to top
View user's profile Send private message Visit poster's website
Antitheft2
Occasional Visitor


Joined: Aug 25, 2009
Posts: 8

PostPosted: Thu Aug 27, 2009 8:32 pm    Post subject: Reply with quote

MaFt wrote:
Antitheft2 wrote:
Heh, at least I know the support ticket got through ;) the site was working fine when I posted it, looks like that site is having "issues" at the moment.


2 of us have replied to the ticket today... did you receive either?!

MaFt


I've had no email notifications at all other than the forum topic replies because I subscribed to the thread.
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  Next
Page 1 of 2

 
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.061 (05 Jun 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