Database format

Pocketgps · Posted: Sat Aug 29, 2015 2:01 pm Post subject:

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.

matkinson · Posted: Fri Sep 04, 2015 9:47 am Post subject:

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.

matkinson · Posted: Mon Sep 07, 2015 11:15 am Post subject:

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:

M8TJT · Posted: Mon Sep 07, 2015 6:26 pm Post subject:

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

Kremmen · Posted: Mon Sep 07, 2015 6:37 pm Post subject:

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

Sorted
_________________
DashCam:
Viofo A119 V3

M8TJT · Posted: Mon Sep 07, 2015 6:40 pm Post subject:

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.

matkinson · Posted: Mon Sep 07, 2015 9:13 pm Post subject:

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.

M8TJT · Posted: Mon Sep 07, 2015 10:29 pm Post subject:

No Prob.

matkinson · Posted: Tue Sep 08, 2015 9:20 pm Post subject:

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:

matkinson · Posted: Wed Sep 23, 2015 9:59 am Post subject:

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.

	PocketGPS
	Web