Database format

B2BLX · Occasional Visitor Joined: Mar 21, 2015 Posts: 1

Hi I have managed to get my hands on a Koonlung HD dash cam with built in speed camera detection/ warning. It uses A Navitel database at present

To load the database, the data has to be stored in .txt format in the following format

IDX, X, Y, TYPE, SPEED, DIRTYPE, DIRECTION

My question before subscribing, is what database formats are available that closely resemble the format above. It would preferably be .CSV and I could then save as .TXT

the main items being X, Y, TYPE, SPEED

DIRTYPE and DIRECTION would be good but not essential.

IDX - I can add this so not really an issue.

Any help would be most appreciated.

M8TJT · Posted: Sun Mar 22, 2015 9:55 am Post subject:

The PGPSW iGO database is a .txt file in the format

X,Y,Type,Speed,DirType,Direction

It sounds like your device uses the directional data that PGPSW provides. In iGO, the dirtype is one way, reversible or Omni and the direction is the direction you are travelling to get caught. The Type is a number describing the type of cam such as fixed, moblile, redlight etc. It doesn't alert for cams on the other side of the road.
So it seems like you could use the iGO data with a bit of data field manipulation to bin the unwanted idx data column.

TerryReilly · Occasional Visitor Joined: Mar 02, 2006 Posts: 2

Be interested to know whether this worked?

M8TJT · Posted: Sun May 31, 2015 4:59 pm Post subject:

Try it and let us know. Very Happy

The OP either hasn't tried, or can't be bothered to post his thanks Rolling Eyes

If you need further info, just post again.

matkinson · Posted: Thu Aug 13, 2015 3:14 pm Post subject: K1S Speed camera database

I'm not the OP ;-)

Unfortunately this didn't work for me with my K1S (V3 firmware). Before parting with me subscription cash I created a gpsdb.txt file in the root directory with content as follows:

M8TJT · Posted: Thu Aug 13, 2015 3:31 pm Post subject:

Try loosing the idx column and just leave the X,Y,TYPE,SPEED,DIRTYPE,DIRECTION columns and try again.

matkinson · Posted: Thu Aug 13, 2015 5:48 pm Post subject:

Thanks for a prompt - and unexpected! - response. Just tried that - no difference. The file is still not read.

M8TJT · Posted: Thu Aug 13, 2015 7:31 pm Post subject:

Where did you find the info as to how to do it. I've Googled around and can't find much.

Pocketgps · Posted: Wed Aug 26, 2015 1:25 am Post subject:

Just as a matter of interest, when you download the files off the sd card to view them, is there a separate gps file generated so when viewing on RegistratorViewer to play back the gps track.

Pocketgps · Posted: Wed Aug 26, 2015 1:27 am Post subject:

M8TJT · Posted: Wed Aug 26, 2015 9:04 am Post subject:

Apart from the IDX field, this is exactly the same format that is required for iGO speed cams. I wonder if the OP is using the .csv extension rather than .txt. There is a possibility that he is not showing extensions in windows so is generating a filename such as camersa.txt.txt which his system does not like.
According to his last post he has given up, so hey ho.

What is interesting is that the cam he shows in his post is in in Abingdon, but is a fixed cam not a mobile as indicated in his extract and should have the following entry

IDX,X,Y,TYPE,SPEED,DIRTYPE,DIRECTION
1,-1.2872200,51.6772500,1,30,1,180

This should make it directional southbound on his device

matkinson · Posted: Thu Aug 27, 2015 9:23 am Post subject:

I'm the poster from Abingdon - but not the OP - and appreciate the responses. I've been on holiday, so please excuse any assumed rudeness! I'll endeavour to find time over the weekend to see if I can progress.
Answering one question - these forums and the Techmoan review (and associated comments) on this webcam were my sources of information. See http://www.techmoan.com/blog/2015/3/1/k1s-the-first-front-rear-hidden-1080p-dash-camera.html?currentPage=11#comments.
Answering another... I need to confirm (am meant to be working right now) but I don't recall any separate gps track with the cam files. RegistratorViewer is on the root directory, then there are two folders, one for regular files (containing a series for both the front and rear cams), the others for "locked" files. But the gps location is definitely correctly shown on playback.
Regards
Mike

[EDIT] No, I was using a txt extension. It's also interesting that in the referenced format the example given doesn't conform to the ddd.dddddd format required. I recall I used both dd.ddddddd and ddd.dddddd. Also I tried with and without a header line.
Also I now find some correspondence with the local seller (JooVuu):

M8TJT · Posted: Thu Aug 27, 2015 9:38 am Post subject:

My sincere apologies for calling you the OP, but I was using it as a wotsit for 'Other Person' as it is much shorter to type than 'matkinson'. Anyway, for future reference I shall refer to you as mat, as it's only a bit longer than OP' Very Happy

Look forward to hearing the results of your further camera checks.

Kremmen · Posted: Thu Aug 27, 2015 10:48 am Post subject:

If you can get and analyse an original file that may help.

Check not only the format but also the first and last lines as they may contain some opening and closing statements. Hopefully no last line encrypted checksum.
_________________
DashCam:
Viofo A119 V3

matkinson · Posted: Thu Aug 27, 2015 11:06 am Post subject:

The YouTube video linked above does clarify a header line is required and the filename I used. But it's worth trying other options. Need to find a card adapter for my laptop - walking the from my car to/from my PC at the the other end of the house each time is not productive.

	PocketGPS
	Web