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

Pocket GPS World :: View topic - Does anybody understand this CSV format for RAC200 satnav?
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Does anybody understand this CSV format for RAC200 satnav?
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> PocketGPSWorld Speed Camera Database
View previous topic :: View next topic  
Author Message
Mr_Smiley
Occasional Visitor


Joined: Jul 05, 2006
Posts: 14

PostPosted: Sat Jun 09, 2012 5:07 pm    Post subject: Does anybody understand this CSV format for RAC200 satnav? Reply with quote

Hi,

Can anybody explain the layout of the following csv format used by the RAC200 sat nav.

I want to update the safety camera alerts but none of the csv files i have found follow the same format.

If anybody can explain what the * and extra data on the end represent (*65*0) from the first lime, i can probably modify the files from this site.

-2.089444*53.502694*"Broadoak Road "*65*0
-2.102222*53.487389*"Katherine Street "*75*0
-1.461694*53.574639*"Carlton Road "*195*1
-0.13775*51.328028*"Woodcote Grove Road "*355*0
-4.245444*55.844194*"Caledonia Road 305 "*110*0
-4.357278*55.900611*"A82 Great Western Road "*95*0
-2.019306*53.443056*"Mottram Road "*x*0
-2.081444*53.458389*"Old Road "*5*0
-2.063556*53.460778*"Victoria Street "*70*1
-0.052194*51.500417*"A101 Rotherhithe Tunnel "*235*0
-2.874472*54.062861*"Regent Road "*130*1
-0.9625*51.440694*"Northumberland Avenue "*x*0
-2.089444,53.502694,"Broadoak Roa",65,0
-2.102222,53.487389,"Katherine Stree",75,0
-1.461694,53.574639,"Carlton Roa",190,0
-0.137750,51.328028,"Woodcote Grove Roa",175,1
-4.245444,55.844194,"Caledonia Road 30",110,0
-4.357278,55.900611,"A82 Great Western Roa",95,0
-2.019306,53.443056,"Mottram Road",0,1
-2.081444,53.458389,"Old Roa",5,0
-2.063556,53.460778,"Victoria Stree",70,1
-0.053389,51.464250,"Linden Grove 4",50,1
-0.052194,51.500417,"A101 Rotherhithe Tunne",235,0
-3.966861,51.637472,"Gendros Crescent",0,1
0.137750,51.328028,"Woodcote Grove R",175,1
0.113472,51.494667,"Eynsham Dri",0,1
0.053472,51.464222,"Linden Grove ",0,1
0.000000,0.000000,"",0,0

Please note that the top locations with the * instead of the comma are repeated below with the comma and not the *


Many thanks

Mr Smiley :o)
Back to top
View user's profile Send private message
pcaouolte
Frequent Visitor


Joined: Dec 27, 2006
Posts: 998
Location: South Lincs, UK.

PostPosted: Sat Jun 09, 2012 6:56 pm    Post subject: Reply with quote

The 65 in *65*1 looks like directional information but is 180 degrees opposed to the way that PGPSW show the direction info. So for the first camera in your list PGPSW have a heading of 239 (180 degrees opposed to 65 would be 245, which is near enough to make no difference).

I can't work out what the 1 or 0 on the end indicates. Perhaps a trial using your sat nav past two cameras, one with a 1 and another with a 0 would show you the difference?
_________________
Paul
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: Sat Jun 09, 2012 7:35 pm    Post subject: Reply with quote

I agree with the heading idea. The Rotherhyth tunnel one is on the exit of the tunnel southbound and its heading is actually 231. I suspect the last digit is whether its a one way or bi directional cam, but can't really substantiate this.

It appeard from stree view that we have the Victoria Street one around the wrong way as well. (ID 2942) Should be 250 deg Its a Watchman type which surely is a 'when you have pased it' type cam?

The Broadoak Road one (first in list) can also be seen in SV pointing south(ish) Well 243.35 actually, which close enough for government work to 239 that we have.

As to the * and , I'm confused. CSV is the acronym for Comma Separated Values, so I don't know where the * comes in to it.
Back to top
View user's profile Send private message
Mr_Smiley
Occasional Visitor


Joined: Jul 05, 2006
Posts: 14

PostPosted: Sat Jun 09, 2012 9:12 pm    Post subject: Reply with quote

Can i log

-2.063556,53.460778 "Victoria Street"

as a direction mistake in your data base and claim a free subscription.

Mr Smiley Very Happy
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: Sat Jun 09, 2012 9:50 pm    Post subject: Reply with quote

Probably not, as I've already done that. Sorry Wink
Back to top
View user's profile Send private message
Mr_Smiley
Occasional Visitor


Joined: Jul 05, 2006
Posts: 14

PostPosted: Sun Jun 10, 2012 4:12 am    Post subject: Reply with quote

Hi,

Well there's no harm in asking ( not even a year for pointing you in the right direction Smile

Anyway.

As to the direction, checking the first of the last two numbers on OsCompass.com with several locations from the RAC200 csv files and showing compass, it appears that this is the angle that the Camera is pointing, not the direction of traffic flow.

What started all this off was coming from flint to Manchester on the A494 i get an over-speed warning of 40mph, when it's a dual carriage way, looking either side there are no apparent roads running parallel, so i thought it was possible from a previous roadworks and well out of date. This lead to two different maps being shown in StreetMap, if you go to (http://www.streetmap.co.uk/map.srf?x=335397&y=371707&z=0&sv=53.238444,-2.969417&st=7&mapp=map.srf&searchp=ids.srf) and select the second zoom level from the bottom it shows the A5117 and the A494 running next to each other, now if you select the very bottom zoom level it show just the A5117 with no A494 in sight ( an out of date map), this location is show in the RAC200 csv file as

-2.969417,53.238444,"A511",265,0

which had me totally confused because i was searching the csv for A494. On my road atlas and google maps there is no road marked as A5117 next to the A494. so i went through the csv co-ordinates till i came to one sitting on the A494 and found that RAC had given the wrong road name, by missing off the 7.

Do your safety camera poi's give direction as well in the csv files you provide, i assume from what's been said above you supply the angles as direction of travel and not direction the camera is pointing.


Can anybody confirm that the 1/0 is bi/single directional and what the * represents and why all the * separated fields are replicated in the bottom half of the file as comma separated.

Many thanks

ps, just noticed something interesting, because it looks like the top half of the file uses * and the bottom is copied but using commas, i thought, wrongly that the bottom was an exact copy of the top. BUT looking at the A494 location shown above does not contain *, it was a copy and paste from the original, so i looked for the * version,,,,, there isn't one!!!

so possible they have been changed to * by a previous free update to invalidate these fields, rather than just overwrite the whole original file.

I could be wrong


pps, the A494 data is taken from a different file than that posted in my first post.

Many thanks

Mr Smiley :o)
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: Sun Jun 10, 2012 9:59 am    Post subject: Reply with quote

Mr_Smiley wrote:
it appears that this is the angle that the Camera is pointing, not the direction of traffic flow.
If the warning system is directional, i.e. warns only if you are travelling in the direction in which you will be caught and using the data in your file, then this would be about as good as a chocolate teapot.
Quote:
-2.969417,53.238444,"A511",265,0
We don't have a camera anywhere near this
Quote:
Do your safety camera poi's give direction as well in the csv files you provide
Only some of them as a number as in your file. Notably the ones for iGO or MioMapCE do. They give the direction of travel to get caught and whether the cam is one way or reversible. The direction in which the cam 'points' depends on the type of cam. The direcvtion you will be caught in remains constant (unless it's reversible)
Quote:
Can anybody confirm that the 1/0 is bi/single directional and what the * represents and why all the * separated fields are replicated in the bottom half of the file as comma separated.
1/0. Not without quite a bit more investigating. Can you plot a simulated route past some of some known ones to find out. They may have one way cams flagged as two way and vice versa so it won't be easy to find out. As for the *s and repeated comma data, I havnt a clue. Try removing one set and see if the alerts still work.
Quote:

flint to Manchester on the A494 i get an over-speed warning of 40mph,
Presumably by 'overspeed' you mean a cam alert rather than exceding the local speed limit?
Quote:
because it looks like the top half of the file uses * and the bottom is copied but using commas, i thought, wrongly that the bottom was an exact copy of the top. BUT looking at the A494 location shown above does not contain *, it was a copy and paste from the original, so i looked for the * version,,,,, there isn't one!!!
I noticed that too.

Just checked all yours against our map. The hdg figure is from our db, and checked against streetview. One way unless specified reversible

-2.089444*53.502694*"Broadoak Road "*65*0 One way hdg 243
-2.102222*53.487389*"Katherine Street "*75*0 one way hdg 245
-1.461694*53.574639*"Carlton Road "*195*1 hdg about 20
-0.13775*51.328028*"Woodcote Grove Road "*355*0 hdg 166
-4.245444*55.844194*"Caledonia Road 305 "*110*0 hdg 303
-4.357278*55.900611*"A82 Great Western Road "*95*0 hdg 270
-2.019306,53.443056,"Mottram Road",0,1 hdg 207
-2.081444*53.458389*"Old Road "*5*0 hdg 4
-2.063556*53.460778*"Victoria Street "*70*1 hdg 248
-0.052194*51.500417*"A101 Rotherhithe Tunnel "*235*0 hdg 232 2 reversible?
-2.874472*54.062861*"Regent Road "*130*1 hdg 311
-0.9625*51.440694*"Northumberland Avenue "*x*0 hdg 180
-0.053389,51.464250,"Linden Grove 4",50,1 hdg 44 reversible
3.966861,51.637472,"Gendros Crescent",0,1 hdg 67
0.113472,51.494667,"Eynsham Dri",0,1 hdg 231


-2.969417,53.238444,"A511",265,0 Nothing there

So there seems to be no obvious tie up between the 1/0 and cam direction.

All the cams in your list are 'get you from behind' (Street view, but couldn't check the one in the tunnel) so the headings in your list are, as you discovered, mainly 180 degrees out compared with ours, with a couple of exceptions and these are not two way cams Shocked

And WTF are you doing up at 4AM? Shocked
Back to top
View user's profile Send private message
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK

PostPosted: Sun Jun 10, 2012 5:29 pm    Post subject: Reply with quote

M8TJT wrote:
So there seems to be no obvious tie up between the 1/0 and cam direction.
Could it be camera type perhaps. Fixed or Mobile.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
M8TJT
The Other Tired Old Man
The Other Tired Old Man


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

PostPosted: Sun Jun 10, 2012 5:50 pm    Post subject: Reply with quote

None of the cams in the sample are mobiles. Good try, but no cigar Very Happy
Back to top
View user's profile Send private message
Mr_Smiley
Occasional Visitor


Joined: Jul 05, 2006
Posts: 14

PostPosted: Sun Jun 10, 2012 6:49 pm    Post subject: Reply with quote

Hi,

The locations i gave in the original post were all from the RAC200

Speed limit, speed 20.csv

file, so they should all be 20mph, i chose that file because it was the smallest in content.

Below is a small sample from the

Speed limit, speed 40.csv

file.


-1.160972,52.932111,"Queens Driv",0,1
-1.161083,52.932111,"Queens Driv",220,0
-2.042861,52.509361,"A4123 New Birmingham Roa",305,0
-2.037778,52.506694,"A4123 New Birmingham Roa",130,1
-2.008278,52.477194,"A4123 Wolverhampton Roa",320,0
-2.002583,52.473806,"A4123 Wolverhampton Roa",125,0
-2.049611,52.511222,"A4123 New Birmingham Roa",285,0
-2.046917,52.510583,"A4123 New Birmingham Roa",105,0

0.064167,51.639278,"A10 Great Cambridge Ro",0,1
0.063917,51.639278,"A10 Great Cambridge Ro",0,1
0.059722,51.654528,"A10 Great Cambridge Ro",0,1
0.059583,51.655833,"A10 Great Cambridge Ro",0,1
0.053611,51.672667,"A10 Great Cambridge Ro",0,1

0.292333,51.527111,"A406 North Circular Ro",0,1
0.291639,51.522778,"A406 North Circular Ro",0,1
0.291583,51.521833,"A406 North Circular Ro",0,1
0.257333,51.552500,"A406 North Circular Ro",0,1
0.253500,51.557917,"A406 North Circular Ro",0,1
0.245278,51.567028,"A406 North Circular Ro",0,1
0.245500,51.567083,"A406 North Circular Ro",0,1
0.219806,51.575806,"A406 North Circular Ro",0,1
0.216222,51.577667,"A406 North Circular Ro",0,1
0.102222,51.614250,"A406 North Circular Ro",0,1
0.102083,51.614472,"A406 North Circular Ro",0,1

-1.688639*53.218389*"A6 Buxton Road "*290*0
-1.678972*53.216806*"A6 Buxton Road "*130*1

-1.800583*53.029972*"A52 Swinscoe Hill "*310*0
-1.796583*53.027889*"A52 Swinscoe Hill "*x*0

-1.330167*53.271389*"A619 Worksop Road "*250*0
-1.321028*53.275306*"A619 Worksop Road "*55*1

-1.556222*52.396667*"A45 Fletchamstead Highway "*140*0
-1.546417*52.390222*"A45 Fletchamstead Highway "*295*0
-1.541417*52.388583*"A45 Fletchamstead Highway "*115*1

-1.433111*52.894306*"A5111 Harvey Road "*75*0
-1.449167*52.891889*"A5111 Harvey Road "*85*1
-1.441583*52.892583*"A5111 Harvey Road "*260*0
-1.437556*52.893333*"A5111 Harvey Road "*80*0

-2.222639*51.855917*"Eastern Avenue "*215*0
-2.214778*51.862361*"Eastern Avenue "*220*1

-0.234333*51.49125*"A4 Great West Road "*275*0
-0.246278*51.489667*"A4 Great West Road "*60*1

-0.045667*51.619056*"Meridian Way "*205*0
-0.044028*51.622361*"Meridian Way "*20*1

There a selection of the same named road, the last lot are the same road but with a 0 and a 1 on the end.

Maybe somebody can see a pattern

4am,, I loose time trying to find answers when something bugs me :o(

Many thanks

Mr Smiley :o)
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: Sun Jun 10, 2012 6:50 pm    Post subject: Reply with quote

Well there you go then, as some of the cams in your first lot were not 20MPH cams Shocked

The ones with zeros in above are in gardens and fields etc. The ones with a heading are about 180 degrees out and they are all one way in our database.
Back to top
View user's profile Send private message
Kremmen
Pocket GPS Verifier
Pocket GPS Verifier


Joined: Mar 03, 2006
Posts: 7046
Location: Reading

PostPosted: Mon Jun 11, 2012 6:44 am    Post subject: Reply with quote

I took the A406 group and imported them into MapPoint.

The Pushpins ended up near Havering, nowhere near the A406 !
_________________
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
Mr_Smiley
Occasional Visitor


Joined: Jul 05, 2006
Posts: 14

PostPosted: Wed Jun 13, 2012 1:13 am    Post subject: Reply with quote

Hi All,


EARTHQUAKE!!!!!!! Sub Plate movement shifted the cameras,,,,

Explains everything :o)

Now you know why you have to wait so long for a RAC recovery man, shortest I've waited is 3 hours, longest,,,, well.


Well yesterday was a trip from Manchester to Prestatyn.

Now (please) don't shout at me :o(


I got some free speed camera files from xxxxxxx just to play with till i know what i need (and they are just to play with). At the moment subscription is out of reach :o( unless you do a short term option :o). That's why I'm trying to use what already works instead of buying a new one.

I used the original RAC200 file names and replaced the original contents with the files from above. I read somewhere the names are hard coded into the software, so to make the first test easier i used the original RAC file names. next test will be an extra none standard name to see what happens.

format

-3.15784,55.95605,"F-40, GB-Edinburgh"
-2.98133,53.44699,"F-40, GB-Liverpool-Bootle, Balliol Road"
-0.91684,51.43943,"F-40, GB-Reading"


I didn't get any bus lane or section control files, in the RAC they have seperate 'section control' and 'end section control' files. They had 'section cameras' but no 'end' files.

On the section control do you provide start and end as separate files or are they combined?

With regards the Bus lane control, i edited the originals and removed all lines that had a *. No bus control lanes on route Sad

I borrowed an updated GPSRider to compare.

Starting from Alexander Park on Princess road in Manchester, it warned me about all the cameras on route, both sides of the road, did it's distance count down, and they all lined up with me on the screen, i couldn't deliberately go over-speed just to check the constant over-speed warning when approaching a camera because of traffic flow, which was an advantage because i could watch more of what was happening.

There and back it spotted all the cameras, on one occasion two next to each other, showing the problem with free files ( they were just to play with and understand how things work Smile) Also it showed the ghost camera on the A5117 on the way there but didn't sound an alarm, it was ghostly on the other side of the road. On the way back i had the nav on satellite info ready to capture the gps location but it didn't give any warning/alarm, i'm not sure if the alarms are disables in sat view.


I'm wondering if i need directional camera alerts, are current sat navs directional, you say you only provide direction in the mio files, I've read somewhere that the mio poi's use less precision than others, is that true.

Also had a thought, could the 1 and 0 represent this side of the road or the other.

How do the mobile camera poi's work, do they have a start and end location or just a start location with distance. Will try them on the RAC.


I'm hoping all this will be useful for others.

I'll go measure some angles for my next trip to Prestatyn and let you know

Many thanks again :o)

Mr Smiley
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: Wed Jun 13, 2012 8:50 am    Post subject: Reply with quote

Mr_Smiley wrote:
I'm wondering if i need directional camera alerts, are current sat navs directional, you say you only provide direction in the mio files, I've read somewhere that the mio poi's use less precision than others, is that true.
It's not the database that's directional, it's the device. PGPSW provide the directional info in some downloads for the device to interpret. Are we talking about the PGPSW camera database here. If so, the locations for mio are exactly the same as for other cams from here. It's the same database, just a different output format.
Mr_Smiley wrote:

Also had a thought, could the 1 and 0 represent this side of the road or the other.
Think about what you have said for a while

Mr_Smiley wrote:
How do the mobile camera poi's work, do they have a start and end location or just a start location with distance. Will try them on the RAC.
They all work the same way. The location of the camera is in the database, warnings and 'count down' etc is done by the satnav device.

Quote:
I got some free speed camera files from xxxxxxx just to play with till i know what i need (and they are just to play with). At the moment subscription is out of reach :o( unless you do a short term option :o). That's why I'm trying to use what already works instead of buying a new one.
I hope that you are not talking about a pirated copy of the PGPSW database here. Subscriprion gets totally out of reach for the person who lets our database escape to be downloaded illegaly because the get a lifetime ban. If so, i'm sure tha 'management' would be interested in from where you got them. From download page:

Database Piracy
We will award One Free Month's subscription to the first person who reports a website offering our database where we are subsequently able to identify the originator.
Back to top
View user's profile Send private message
Mr_Smiley
Occasional Visitor


Joined: Jul 05, 2006
Posts: 14

PostPosted: Wed Jun 13, 2012 2:05 pm    Post subject: Reply with quote

EXCUSE ME!!!!

Do you really think i'd use a pirated database from here and then ask for help and advice. a short subscription and one for helping you notice an error in your own database ---- Nope i think NOT.

It was a free selection from POIPlaza.com, i put the xxxxx's so others not in the know wouldn't go there instead of here. Once you see where they were from please delete and replace with the xxxxx's

And it's quite clear that they are not up to date, some being dated as 2009, don't include camera direction and other bits missing, like less than 12 entries for bus lanes, and no road descriptions

Just because a handful of camera sites were correct doe's not indicate a copy or piracy.

It's also quite clear from around the web that this is the place to be :o)

I got them because they were there and i was going out the next day, I have to live two weeks on one years sub and It was quite clear from people who are helping here that the RAC one's were taken from a lucky bag and randomly placed in various files.

If you want what i found to check, give me an email and i'll send them but there not what you think. There out of date and just used at short notice.

Such an accusation should be merited with a weeks sub :o)



Mr Smiley :o(
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 1, 2  Next
Page 1 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.053 (15 May 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