Which camera database do i need to subscribe to

limoncello1002 · Occasional Visitor Joined: Jun 26, 2011 Posts: 4

Im using an app called gpsexec in a Riderunner frontend car computer, It can take a variety of files, csv, ov2 etc, as i have to convert the data anyway, but i cant see anywhere on the site that tells me the contents of the individual camera db's. What i need is Lat, Long (obviously), speed, type, and if possible heading information (i can do without this)

As i can only select up to 3 different files on pocketgps once i subsrbe which one is suitable for me?

mikealder · Posted: Fri Jul 22, 2011 10:42 am Post subject:

Welcome to the forum, the limitation is that you can install the database to three devices, there is no actual limit to the number of different download types you can make.

ov2 is the TomTom data type, this doesn't contain heading data.
csv is used for Garmin devices, this doesn't contain heading data.

Consider the IGo version of the PGPSW database as that does contain the heading data but you will need to check the format for compatibility with your system - Mike

limoncello1002 · Occasional Visitor Joined: Jun 26, 2011 Posts: 4

Thanks Mike, thats useful , i will sign up and have a look throughto find the right one

MaFt · Posted: Fri Jul 22, 2011 10:52 am Post subject:

the iGO 'txt' format uses the following:

Lon,Lat,Type,Speed,DirType,Direction

'Type' is:
Fixed = 1
Redlight AND speed = 2
Redlight = 3
Average speed = 4
Mobile = 5

'DirType' is:
1 = one way
2 = reversible

'Direction' is the heading data (1-360 degrees)

If that matches what you need then you should download the iGO (txt) files and you can always change the extension from .txt. to .csv as it is, technically, a csv (comma separated values) file.

MaFt

limoncello1002 · Occasional Visitor Joined: Jun 26, 2011 Posts: 4

great thanks for the info

M8TJT · Posted: Fri Jul 22, 2011 4:28 pm Post subject:

My friend Google says that the file format is

44.812837,-0.555668,,,600,M,"RADAR_FIXE_130"
44.814602,-0.572405,,,550,M,"RADAR_MOBILE_030"
44.844612,-0.598927,,,540,M,"RADAR_FIXE_060"
44.869191,-0.567771,,,530,M,"RADAR_MOBILE_090"
44.872417,-0.565367,,,520,M,"RADAR_FIXE_070"
44.883789,-0.560132,,,510,M,"RADAR_MOBILE_050"

Seems to be lon,lat,?,?,distance,units(meter)Message.

The two parameters between the comma separators in the middle are not obvious

limoncello1002 · Occasional Visitor Joined: Jun 26, 2011 Posts: 4

yes the missing ?? are min and max heading, these are calculated by use of another app which takes a csv etc and makes it in to the format you have described (as long as you have heading information.

Andy_P · Posted: Fri Jul 22, 2011 5:28 pm Post subject:

M8TJT · Posted: Fri Jul 22, 2011 5:58 pm Post subject:

	PocketGPS
	Web