Correct labelling of camera sites

bernster · Occasional Visitor Joined: Apr 12, 2007 Posts: 8

I have just downloaded the single file (Excel CSV version) database. I checked one to see if I could find it on a map. This was: GATSO:3014 with lat 50.757770 and long 1.927170, labelled as Broadstone, UK. When I searched this on a map, I found it but it wasn't in Broadstone. Broadstone is in Poole whilst this camera is in Bournemouth in a place called Wallisdown. How reliable are these titles?

Also one has to be careful not to click on one of the column headings in the Excel files (thus re-arranging the data) as, when this is imported, it can be completely wrong!

philpugh · Posted: Fri Apr 13, 2007 5:17 pm Post subject:

I will let the camera database guys defend their own but..

Which file did you download? I just DL'd the single CSV file (for 'Other' system type) and a quick scan didn't reveal any position information other than Lat Long - as I would expect. There may be a file in the camera database for some specific nav system with additional comments - I stand to be educated here Smile

Anyway... although you could use the CSV file for your own purposes - they are intended to be downloaded into a nav system and the methods for doing this don't usually require you to open the file.

Some systems (e.g. GARMIN nuvi) will show the camera 'name' (in your case GATSO:3014@40) when you approach it - other systems don't.

As for Excel - by default clicking on columns shouldn't do anything to the order of the data - you have to select the column then do a sort. At least with Excel 2003 it doesn't do this - in fact if you attempt to sort a single column you get a pop-up warning you that you are about to do something pretty silly.

What application are you using to open the files?
_________________
Phil

PaulB2005 · Posted: Fri Apr 13, 2007 5:43 pm Post subject:

Darren · Posted: Fri Apr 13, 2007 6:40 pm Post subject:

We don't have any such location data in our database, where did you get that from?
Ours have Lat, Lon, CAMERA ID & Speed nothing else.
_________________
Darren Griffin

Andy_P · Posted: Fri Apr 13, 2007 8:22 pm Post subject:

Curiouser and curiouser....

Border_Collie · Posted: Sat Apr 14, 2007 1:43 am Post subject:

Andy_P · Posted: Sat Apr 14, 2007 8:34 am Post subject:

Bored, so I thought I'd have a look at the Excel version of the download.
There isn't a "single file" version, only a "consolidated-by-type" when you select Excel... Confused

DennisN · Posted: Sat Apr 14, 2007 8:37 am Post subject:

Serves you all right for using Excel instead of Lotus 1-2-3. Stop it!

_________________
Dennis

If it tastes good - it's fattening.

Two of them are obesiting!!

bernster · Occasional Visitor Joined: Apr 12, 2007 Posts: 8

Gentlemen,
My apologies for giving you false information. As Darren pointed out the raw data, downloaded from this website, only has lat., long. and a camera name.

When I imported this into CoPilot 4, the desktop software created another table which added a location lable. It is this lable that produces the erroneous location names. Of course it is of no consequence, since this name is redundant.

I thank you all for the time taken to reespond to my query.

Darren · Posted: Sat Apr 14, 2007 9:30 am Post subject:

Thanks for the update, you had a few of us scratching our heads and downloading CSVs to check back there!
_________________
Darren Griffin

DennisN · Posted: Sat Apr 14, 2007 7:36 pm Post subject:

Darren · Posted: Sat Apr 14, 2007 8:24 pm Post subject:

, I bet you still have a 3.5" disc drive too ;)
_________________
Darren Griffin

DennisN · Posted: Sat Apr 14, 2007 8:50 pm Post subject:

	PocketGPS
	Web