DS Database

wetdogleader · Posted: Mon Feb 11, 2008 6:45 pm Post subject: DS Database

Yes I'm the one still using the DS and ugrading it every month. I use it in conjunction with a 910 but have noticed especially in the East London/Essex area a lot of the directions for the camera are giving false alarms. I have looked at the data for the cameras and the Tomtom but they seem to be in different formats. Can you explain what is what and I can do some editing of the ones in my area myself then feed it back to you if you want it. (or am I the only one)

Darren · Posted: Mon Feb 11, 2008 6:52 pm Post subject:

What does the 910 show at the same location?
_________________
Darren Griffin

MaFt · Posted: Tue Feb 12, 2008 9:34 am Post subject:

you will need to open up the DS 'csv' file in notepad as ti is not a true CSv. DS uses what i call scsv (semi-colon separated values) so excel etc will not open it correctly as a comma is used as a decimal point...

open up the ov2 file in something like poi edit then match up the coords so you can get the id number.

an easier way would be to locate the cameras on the google map and resubmit correct heading data!

MaFt

wetdogleader · Posted: Tue Feb 12, 2008 1:21 pm Post subject: DS Database

OK The problem hear is that most of the cameras do have headings in the OV2 file but not in the DS. As a for instance GATSO 889@50 Heading 80 Single Direction. The DS always picks this up when going in the opposite direction. I can't quite work out how to find it in the DS file as it does not use camera nos. If I put the cross hairs ove it on the map I get a reading of 51.61477225871961 and -0.07143259048461914. How are these refs. interpretted in the DS data? I did a search for 51614 in Excel with no result. I did 61477;51 with no result also 61477 brings no result. I know you said to open with notepad but there is no search facility with that. So how do I find the camera in question.

MaFt · Posted: Tue Feb 12, 2008 6:41 pm Post subject: Re: DS Database

MaFt · Posted: Tue Feb 12, 2008 6:51 pm Post subject:

me again,

this line: -0,07142;51,61478;50;1;1;80

relates to Gatso 889

longitude; latitude; speed value; mph; camera type; heading

maybe it would be better at 85 for heading? i've no idea how accurate the heading value needs to be, i know the range for mio satnav is 25 degrees either way - no idea on the DS though.

MaFt

wetdogleader · Posted: Wed Feb 13, 2008 6:43 am Post subject: DS Database

Thanks for the info. The ov2 file thing was an assumption on my part. I just assumed that because the data was there it would be included. I have checked 5 of the cameras in my area only to find that only 1 (GATSO 2043) has a heading of 0. Does this mean that it is North or unclassified? I estimate from the Google map a heading of about 22 would be right. The others prove to be a bit of a mystery as they all have headings included. You state on the last part of your message that the ;1;1; is the camera type. Would this denote whether it is reversible or single direction as this is the only other possiblity that I can think of. The Delta angle on the DS is variable I have mine set to about 10deg.

MaFt · Posted: Wed Feb 13, 2008 6:24 pm Post subject:

the '1;1;' part is mph;camera type.

if it was 0;1; it would be kph;gatso

0;9; = kph mobile
1;9; = mph mobile

there is no setting in the DS csv data for single direction or reversible.

MaFt

wetdogleader · Posted: Wed Feb 13, 2008 6:31 pm Post subject: DS Database

I don't understand why I am picking up the cameras for the opposite direction. If the camera is reversible does this mean it would have two entries with different headings?

MaFt · Posted: Thu Feb 14, 2008 9:52 am Post subject: Re: DS Database

wetdogleader · Posted: Thu Feb 14, 2008 11:23 am Post subject: DS Database

Here are a couple for you to look at. Both of these face East but activate the DS when travelling West. GAT 889 & GAT 419.

MaFt · Posted: Thu Feb 14, 2008 12:02 pm Post subject: Re: DS Database

wetdogleader · Posted: Thu Feb 21, 2008 8:53 am Post subject: DS Database

Me Again. The plot thickens with this one! I have deleted 419 & 889 from my database however I am still getting the alerts from these two cameras going in the opposite direction. When I return through them the DS does not light up (as you would expect). I have tried the 3 figures that you suggested but this does not seem to have any effect.
One of the other alerts that I get is on the A406 near the start of the M11. There are two cameras here (Monitron 17732 & 17733) however lerking underneath them on the map is the old Gatso 17655 which is no longer there. Doesn't explain the alert though as all of them have headings.

MaFt · Posted: Thu Feb 21, 2008 11:46 am Post subject:

so, you've deleted the data yet you still get alerted on the DS? are you sure you don't also have the DS database installed too?

MaFt

wetdogleader · Posted: Thu Feb 21, 2008 2:23 pm Post subject: DS Database

Now that's a thought. How would I know and how can I remove it if it is there?

	PocketGPS
	Web