Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
SurfShark Antivirus
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Database format
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Database format
Goto page Previous  1, 2
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> PocketGPSWorld Speed Camera Database
View previous topic :: View next topic  
Author Message
Pocketgps
Lifetime Member


Joined: Nov 16, 2004
Posts: 2145
Location: Midlands, UK

PostPosted: Sat Aug 29, 2015 2:01 pm    Post subject: Reply with quote

Have looked hard to find anyone selling this unit, but it would seem that any available are from the original batch, so is there a problem with some aspect of the unit or firmware that they are trying to correct before releasing any more.

Downloaded the user manual from their website, it says that the warning is given 500M from the camera, that's a long way.

I would like to purchase one of these when they release the next batch, not bothered about the cam warnings as I use an old TT ONE for cams only, this TT unit mounted in my roof console.

Techmoan and Dashcamtalk are good sites for information on Car dvr units for anybody else interested in them.

Mat, hope you can get the cam warnings sorted, try sending email to Koonlung.
Back to top
View user's profile Send private message
matkinson
Occasional Visitor


Joined: Apr 10, 2007
Posts: 9
Location: Abingdon, U.K.

PostPosted: Fri Sep 04, 2015 9:47 am    Post subject: Reply with quote

I'm sending my "database" file to Koonlung via JooVuu, my local supplier. If I get a working (single camera!) database back I'll let you all know via this forum.
500m is clearly too far! Let's see if that is the case. But first I have to get a camera file read...

BTW - having used this unit for some time now, I'd agree that the ability to read number plates is restricted. In daytime you can, as long as the vehicle is not at the side of the picture. But this may take a few frames forward/backward to confirm. At night, if moving, you cannot. That said, I'm glad I fitted the unit, it gives me a little reassurance that I'll have video evidence - or at least backup - of any incidents.
Back to top
View user's profile Send private message
matkinson
Occasional Visitor


Joined: Apr 10, 2007
Posts: 9
Location: Abingdon, U.K.

PostPosted: Mon Sep 07, 2015 11:15 am    Post subject: Reply with quote

Update...
JooVuu have been very responsive and helpful (thanks Emma!), to the extent that I have demonstrated that the K1S will produce speed camera warnings. But I need to play a little more before I declare success. There are worrying indications that this functionality destabilises the standard - and fundamental - recording mechanism. I need to play a little longer.
For the record, this format works:
Code:

1,-1.28717,51.67729,1,48,1,180

No header, with less decimal places than was shown either in the manual and on Koonlung's YouTube video.
I'll post back with my conclusions soon, but will probably now splash out on a subscription - I'm guessing I can coerce one CSV variant to that which is needed.
Mike
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 Sep 07, 2015 6:26 pm    Post subject: Reply with quote

The iGO UK - Single file with all cameras has this format which seems correct apart from having no first data (ID?) field.

X,Y,Type,Speed,DirType,Direction
-2.17787,50.68305,1,40,1,268
-2.09934,50.70722,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
-2.48386,52.69615,1,30,1,91
-2.74783,53.3244,1,60,1,340
-0.76297,51.98999,1,30,1,80
-0.24593,52.58496,1,30,1,348
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: Mon Sep 07, 2015 6:37 pm    Post subject: Reply with quote

= a simple program to add the first field to every line.

Sorted
_________________
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
M8TJT
The Other Tired Old Man
The Other Tired Old Man


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

PostPosted: Mon Sep 07, 2015 6:40 pm    Post subject: Reply with quote

Excel ~Insert Column ~ 1, 2 drag down. I'd do it with a simple macro though to make it easier to repeat weekl.
I'll write one for mat if he has excel.

PS. 500m is not too far for a mobile cam.
Back to top
View user's profile Send private message
matkinson
Occasional Visitor


Joined: Apr 10, 2007
Posts: 9
Location: Abingdon, U.K.

PostPosted: Mon Sep 07, 2015 9:13 pm    Post subject: Reply with quote

Thanks for the offer, but last week I retaught myself named dynamic ranges and array formulae in Excel. I don't mean to blow my own trumpet, but I reckon I can add the index column! Razz Although I might see if I can find an updated version of awk...
Frankly I'm far more concerned about possible stopping recordings, which I'll spend the next 30 mins looking into.
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 Sep 07, 2015 10:29 pm    Post subject: Reply with quote

No Prob.
Back to top
View user's profile Send private message
matkinson
Occasional Visitor


Joined: Apr 10, 2007
Posts: 9
Location: Abingdon, U.K.

PostPosted: Tue Sep 08, 2015 9:20 pm    Post subject: Reply with quote

Update....

I've now purchased the database and downloaded in the iGo format. Having also downloaded gawk for Windows I processed this file to add an index column:
Code:
gawk "{printf \"%d,%s\r\n\", NR, $0}" input

redirecting to an output file (can't seem to post a redirection character!) As has been pointed out, this could easily be added in Excel too.

The processed database file was accepted and after a drive past a camera I confirm I'm getting warnings. I'm hearing "speed control" (fixed camera) and "mobile camera" warnings so far.

Thanks for everyone's help!

Note, as stated yesterday I’m seeing similar issues to some other users - the camera stops recording for ~7 seconds at random times. There was a little evidence that this occurs immediately after a speed camera warning, but it does it at other times too. I note that these problems were occurring before I loaded any database onto the device, so it’s a separate problem! As I don’t recall this happening in the early days of the camera, I’ve reformatted my card. I've also just flashed the latest Firmware, as supplied by JooVuu. If that doesn’t improve things I’ll turn down the resolution of the rear feed, etc to see if that helps. I'm using a genuine Samsung 32GB Pro Class 10 card, so hopefully that's not relevant. As robust recording is essential for a dashcam I'm holding off recommendations for the K1S right now. Let's see if the new firmware helps. I'll report back.

Mike
Back to top
View user's profile Send private message
matkinson
Occasional Visitor


Joined: Apr 10, 2007
Posts: 9
Location: Abingdon, U.K.

PostPosted: Wed Sep 23, 2015 9:59 am    Post subject: Reply with quote

Just to state that since my firmware update and card reformat I've not experienced any of the intermittent "recording starting" messages I had been hearing. Maybe a card reformat is anyway advised on a firmware update?
The K1S, with this database, now is useful for fixed cameras. But most of the (voice - can't currently be changed) warning are intrusive, which is annoying with some cameras - for instance the M42 managed section seems to have fixed cameras on nearly every gantry. At each the K1S report "fixed camera" followed by three loud beeps - three times. Also, the voice warning at SPECS cameras appears to be "offline control", which makes little sense to me! As I'm manipulating the database before loading I guess I could cut out or change the camera types of these devices.
Finally, despite others concerns, I note the warnings at mobile cameras are probable too late - the warning seems to be associated with the location rather than up the road.
But, again, I didn't buy this for a speed camera warning, and as a dashcam it meets my needs. The ability to warn of cameras when I'm not using TomTom is a boon.
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
Page 2 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.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