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
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


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

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

M8TJT wrote:
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
I think it only does it if there are letters included, i.e. seen as text.

I Saved As a CSV File and got:

-0.00075,51.42047,1,30
0.00222,51.41831,1,30
-0.00253,51.44506,2,
0.00431,51.49517,4,30
-0.00436,51.46,1,30
-0.00436,51.46008,1,30
0.00436,51.49508,1,30
-0.00439,51.53628,2,
-0.00458,51.43075,1,30
-0.00483,51.57939,1,30
-0.00483,51.5795,1,30
0.00578,51.57906,1,40
0.00611,53.09744,1,40
0.00636,51.57892,1,40
0.00667,51.58639,1,40
-0.00669,51.55622,1,50
-0.00761,51.53356,2,
0.00775,51.56867,1,50
0.00811,51.56886,1,50
-0.00833,51.37414,1,30
-0.00833,51.51408,4,30
-0.00864,51.51539,1,40
-0.00878,51.51522,1,40
-0.00931,51.34764,1,30
0.00944,53.10861,1,60
-0.00958,51.34778,1,30
-0.01031,51.52194,1,40
-0.01053,51.52056,1,40
-0.01061,51.47253,1,30
-0.01067,51.44514,1,30
-0.01081,51.50728,1,40
-0.01111,52.47372,4,50
-0.01114,52.47372,4,50
0.0115,51.57697,1,40
-0.01219,51.52833,1,40
-0.01272,51.55206,1,50
-0.01333,51.50722,1,40
-0.01375,51.51119,2,
0.01394,51.57492,1,40
-0.01408,51.58992,1,30
-0.01433,52.34106,1,60
-0.01472,51.51111,1,30
0.01486,51.51681,4,50
-0.01486,51.57392,1,30

_________________
Richard

TT 910 V7.903 (9183/081205) OS:2344
Europe version 1045.10005
TT Via 135 App 12.075
Western Europe v1082
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 9:17 am    Post subject: Reply with quote

My bad. It was late and I did yet another bit of my not paying enough attention. If you save a file as a .txt it screws up sometimes. But MaFt's implications were save it as a .csv then rename it to .txt. That works just fine and dandy, I do that all the time.
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: Mon Jan 28, 2013 10:12 am    Post subject: Reply with quote

Plan B:

Also try:

X,Y,TYPE,SPEED,DIRTYPE,DIRECTION
-1.76461,53.79522,1,30,0,0

Where all fields are present but the last 2 are just 2 zeroes
_________________
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
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 10:38 am    Post subject: Reply with quote

I think that the thing that we realy need to know is does the SCDB database work on the Alpine , does it show the cams on the map AND is it directional.

It appears that it's not as he said
Quote:
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.
But that of course depends on whether the cams in question are single direction.

If the SCDB database is not directional, then we are all wasting out time trying to work on a conversion from our degrees to something in HEX that doesn't work anyway. Shocked

EDIT:**************************

I have just noticed that the extract from the other site has all the DIRTYPE values at zero. This will mean that the cams are listed as non directional, so it will not be possible to tell if the other database is directional or not unless we just have an unlucky sample. This theory is supported by Robert's post quoted above.
iGO DIRTYPES: 0=nondirectional, 1=one way, 2=2 way (or reversible)
Back to top
View user's profile Send private message
Gmt_Plus1
Lifetime Member


Joined: Jan 24, 2010
Posts: 26

PostPosted: Mon Jan 28, 2013 8:33 pm    Post subject: Reply with quote

I have just downloaded and read the .pdf Operation Manual for the W928R from Alpine's web-site and the only mention of Navigation Instructions is on page 18 and refers you to the "Navigation System OM" on the CD-ROM. Does it mention on the CD how to install 3rd party, directional POI's?.

If not, I'd suggest e-mailing TechSupport at Alpine for an answer.

In the meantime, there are 6 fixed cameras around the Wandsworth area, how about making up a small database containing just these 6 cameras?. Start off with the four columns of Lat,Long,Type,Speed. (This info can be found by clicking on the cameras on the Submissions Page - The big, yellow, pointy finger at the top right of this page)

Go for a small drive around Wandsworth.

If that works, add the column for DirType (all 0's I think) and if that works next add a column for Direction, at this point all you can do is input the compass bearing and hope that AlpineTechSupport give you the conversion formula if the compass bearing does not work.

EDIT - I've just re-read M8TJT's own EDIT above and realised my mistake. Where I said
Quote:
If that works, add the column for DirType (all 0's I think).....
they should all be 1's not 0's.
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 10:36 pm    Post subject: Reply with quote

But it would appear that the OP knows how to load them, but wants to use the PGPSW database which is apparently not compatible in the Direction column.
Back to top
View user's profile Send private message
Gmt_Plus1
Lifetime Member


Joined: Jan 24, 2010
Posts: 26

PostPosted: Tue Jan 29, 2013 12:03 am    Post subject: Reply with quote

Agreed, ....to a point.

I believe, though admittedly I am getting a tad confused with this thread, that the OP has said that he subscribed to scdb and has asked for a re-fund because they are not compatible with his Alpine unit.

The scdb db includes a direction in Hex, or someother. People here are trying to find a formula to convert from compass bearings into Hex. But the scdb db does not work with the unit so why try to copy it?.

When he loads the PgpsW db, the Alpine unit locks up at times, presumably dependent upon which version he loads.

There is no mention of Navigation functions in the down-loadable manual but refers the user to a separate CD.

The Op appears to be having problems with his N,S,E & Wests, Lat/Long formats and, dare I say it, data management generally.

My suggestion, based solely on the way I would tackle it, is to -

1) RTF(CD)M
2) Contact the manufactures to see if it possible and, if so, what is the correct format (for a 1100 unit it should be and they should be forthcoming!)
3) In the meantime, start over again, loading just a few local cameras so that they can be easily managed and tested, gradually adding data to them to establish at what point the system falls over.

Sorry, if I have got it wrong, but it's the way I would go about it.

EDITED 2wce for readability.


Last edited by Gmt_Plus1 on Tue Jan 29, 2013 12:47 am; edited 2 times 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: Tue Jan 29, 2013 12:18 am    Post subject: Reply with quote

MaFt wrote:
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
I'm on that now.

However, presumably I need to uninstall the scdb database first, otherwise the unit will get confused or double its alerts?

To "uninstall" the scdb database, do I 'doctor' the .txt file by erasing all the coordinates and then uploading it.
In this way the scdb database effectively has nothing to act on?

I've been slow to reply to posts because I'm having difficulty with "Download the configuration" from the 928 (To recover my north Alert points for example). I thought it was a problem with the make or size of the SD card, but I have tried several different ones, and still get an error message to the affect that 'the download was corrupted'.

In actual fact, when I put the SD card in my PC there is no camera data on it at all, so the Download didn't work. I'm sure this is a problem Alpine Support can help with.

Anyway, it's been a tad distracting.. Smile

Let me know about 'uninstalling', and then I'll try the iGO database, as directed
_________________
"Anyone who says he can see through women is missing a lot." - Groucho Marx
Back to top
View user's profile Send private message
Gmt_Plus1
Lifetime Member


Joined: Jan 24, 2010
Posts: 26

PostPosted: Tue Jan 29, 2013 9:04 am    Post subject: Reply with quote

Are you able to connect your Alpine to a PC or laptop in anyway? If yes, can you see the Folders and Files on the unit when using Windows Explorer or similar (not NaviExtras)? If yes, enable "see hidden files" and take a back up of the Alpines data onto the PC before you start deleting stuff.
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


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

PostPosted: Tue Jan 29, 2013 8:46 pm    Post subject: Reply with quote

Gmt_Plus1 wrote:
Are you able to connect your Alpine to a PC or laptop in anyway? If yes, can you see the Folders and Files on the unit when using Windows Explorer or similar (not NaviExtras)? If yes, enable "see hidden files" and take a back up of the Alpines data onto the PC before you start deleting stuff.
Yes I can plug in to a PC as the In-Car 928 uses an SD card for its updates. So no prob!

I assume from your mention of backing up before deleting things means I've got the right method to remove the scdb database, prior to installing the modified iGO from PGPSW?

Sorry I've been so busy lately, but I'm taking this Thursday off work so I can catch up on this important project, do some more posting, and go out in the car and collect the coordinates of half a dozen local cameras, so we have something to test with Smile

Cheers,
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
M8TJT
The Other Tired Old Man
The Other Tired Old Man


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

PostPosted: Tue Jan 29, 2013 8:59 pm    Post subject: Reply with quote

r4robert wrote:
and go out in the car and collect the coordinates of half a dozen local cameras, so we have something to test with
You could get the co-ordinates etc. of some of your 'local' cams from the submission map, accessed via the big yellow pointy 'WE NEED YOU' finger in the right hand sidebar.

I think that GMT+1 means can you connect the Alpine directly to a PC via a lead Y/N?

How do you get the SCDB database from your computer to the Alpine?
Back to top
View user's profile Send private message
Gmt_Plus1
Lifetime Member


Joined: Jan 24, 2010
Posts: 26

PostPosted: Tue Jan 29, 2013 10:57 pm    Post subject: Reply with quote

M8TJT wrote:
...I think that GMT+1 means can you connect the Alpine directly to a PC via a lead Y/N?
I have had another read of the manual and it appears that the only way to transfer data is through USB memory stick or SD card, so there may not be a way to back up the Alpine system.

To expand on M8TJT's question
M8TJT wrote:
How do you get the SCDB database from your computer to the Alpine?
and what happens to the data? i.e. does it get transfered to the Alpine's memory/folders and you can then remove the SD card or does it remain on the SD card and get used from there?

Please answer these questions BEFORE you delete anything.
Back to top
View user's profile Send private message
r4robert
Occasional Visitor


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

PostPosted: Wed Jan 30, 2013 7:52 pm    Post subject: Reply with quote

Gmt_Plus1 wrote:
I believe, though admittedly I am getting a tad confused with this thread, that the OP has said that he subscribed to scdb and has asked for a re-fund because they are not compatible with his Alpine unit.


The Op appears to be having problems with his N,S,E & Wests, Lat/Long formats and, dare I say it, data management generally.

Thanks for your comments Smile

The scdb database has its shortcomings, the main one 'was' the lack of an audible warning.

I'm embarrassed to say that I found a 'mute' button hidden deep in a sub-menu on the 928 that has since solved the problem, but not before I wrote a snotty email to scdb Exclamation

As far as your second paragraph is concerned, your are broadly correct. I am a tad confused with GPS matters (although I am learning fast!), and hence the reason why I have turned to the experienced folk on this forum to help me, (which of course is what forums are all about - as you well know Smile )

So please bear with me. The completion of a working Alpine database for today's modern units would be good for me, and for PGPSW's membership subscription numbers generally, and therefore I have 2 good reasons to be the 'guinea pig' and do some testing of peoples suggestions etc. (I also like the idea of 'giving back' what I can Smile )

Tomorrow's my planned day-off, so I'll be in and out of the car trying stuff, and driving round Wandsworth to record half a dozen camera site coordinates so 'we' can make heads and tails of the exhaustive databases that need 'amending'.

Best wishes,
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
r4robert
Occasional Visitor


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

PostPosted: Wed Jan 30, 2013 8:10 pm    Post subject: Reply with quote

Gmt_Plus1 wrote:
M8TJT wrote:
...I think that GMT+1 means can you connect the Alpine directly to a PC via a lead Y/N?
I have had another read of the manual and it appears that the only way to transfer data is through USB memory stick or SD card, so there may not be a way to back up the Alpine system.

To expand on M8TJT's question
M8TJT wrote:
How do you get the SCDB database from your computer to the Alpine?
and what happens to the data? i.e. does it get transfered to the Alpine's memory/folders and you can then remove the SD card or does it remain on the SD card and get used from there?

Please answer these questions BEFORE you delete anything.

Yes, you are correct. A SD card is the only way to transfer information between the 928 and one's PC.

The operation involves sticking the prepared SD card in the 928's card slot, at which point the unit automatically reads the card, lanuches the "Collect device information" / "Copy updates to your device" page, where you then choose.



Once its finished, you remove the SD card, to answer your question.

Therefore, it seems to me that I can continuely "Copy updates" to the 928, with only a small risk of 'bricking' it. (A previous attempt to update with the PGPSW Alpine B200 database, simply froze the unit, but did no harm).

Can you think of a reason way I shouldn't update(upload) an empty scdb database to effectively erase it and make way for another (probably an amended iGO database).

Thanks for your help 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
AliOnHols
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Oct 15, 2008
Posts: 1930

PostPosted: Wed Jan 30, 2013 8:10 pm    Post subject: Reply with quote

Hi r4robert, GMT_plus1 and M8TJT have both mentioned previously that you do not need to drive around Wandsworth to get the locations of your local cameras, they are already in the PgpsW database.

Just go to the Big, pointy Yellow finger which says "We Need You" at the top and to the right of this page and click on the cameras in Wandswoth on the map and copy their details.

But, what are you going to do with that data?

At the moment I'm confused as to the origin of the cameras you have loaded (i.e scdb or pgpsw), which cameras you actually have loaded, what the file name is, what format it is in and where on your satnav they are stored.

People on this forum are very helpful and shall bend over backwards to assist but you need to start answering some questions. As you say, you are a "guinea pig" thats because only you have this satnav and only you can answer the questions. We can only offer general ideas and await your responses and take it one step at a time.

So, you have tomorrow off to get your Alpine unit working. How are you planning to sort this problem out? Please give us a clue!
_________________
Garmin Nuvi 2599
Android with CamerAlert, OsmAnd+, Waze & TT Europe.
TomTom GO 730, GO 930, GO 940 & Rider2.
SatMap Active 10 & 12.
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 4 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