Hi! We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
But as we’re losing ad-revenue from this then why not make a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
Joined: Apr 05, 2006 Posts: 61 Location: Stafford, UK
Posted: Tue Jun 06, 2006 12:09 am Post subject: Database formats
Just a request -- if the good people who put the databases together have the time and the inclination? Please don't see this as a criticism -- it is absolutely not that at all. The people who put it all together do a sterling job and I'm most grateful to them.
Would it be possible (or sensible?) to have a fourth format, where the files are grouped by speed only (5-ish files?), and not by camera type as well?
I ask because:
(a) when I'm driving I'm really more interested in the speed I shoud be below, than the mechanics of the camera that will nail me, and
(b) I don't always want the icons cluttering up the display (we have a LOT of cameras in Staffs!), and I turn them off when I need to see more map in a zoomed-out view, and 23 POIs take a while to turn off and then on again.
I know I'm probably just lazy, but if it would be a simple process to re-order the database into a smaller set of files defined by speed only, I for one would be most grateful. _________________ Anton
Joined: Jan 10, 2004 Posts: 2777 Location: Bonnie Scotland (West Central)
Posted: Tue Jun 06, 2006 1:49 am Post subject: Re: Database formats
AntonM wrote:
Would it be possible (or sensible?) to have a fourth format, where the files are grouped by speed only (5-ish files?), and not by camera type as well?
I ask because:
(a) when I'm driving I'm really more interested in the speed I shoud be below, than the mechanics of the camera that will nail me, and
Its generally considered a good idea to know which camera type you are approaching, because of the varying ranges that the cameras have, 2km for mobiles down to a few yards for Truvelos.
BUT, its relatively easy to do a DIY job, if you download the single file as a CSV or XLS. Open it in Excel, extract the speed from the camera names, sort by that and then split into separate files.
OK, that does sound a bit complcated , but it isn't, honestly
The CSV should have 3 columns, the third being the name. If you paste the following formula into the fourth, that will extract the speed.
Code:
=MID(C2,FIND("@",C2,1),99)
You'll get a #VALUE! error for those cameras that don't have a speed, but that won't affect the sort. I'm sure that somebody will post a tidier method, that checks whether the @ exists.
Joined: Apr 05, 2006 Posts: 61 Location: Stafford, UK
Posted: Tue Jun 06, 2006 11:36 pm Post subject:
Thanks Oldboy.
I notice that one needs a qtXLS (?) licence to be able to export to Excel, which I don't seem to have, although I have a legit copy of Excel.
That's just a minor curiosity, as one can export to .ASC, which is (it seems) more or less the same as CSV, and simply rename the exported file from "filename.asc" to "filename.csv", which Excel happily accepts.
I would expect (but haven't tried) that Excel will export it as a CSV file again, as no doubt the qtXLS licence will prevent an XLS file from being converted back to an OV2 file. _________________ Anton
Posted: Wed Jun 07, 2006 10:05 am Post subject: Re: Database formats
AntonM wrote:
(a) when I'm driving I'm really more interested in the speed I shoud be below, than the mechanics of the camera that will nail me, and
I know I'm probably just lazy, but if it would be a simple process to re-order the database into a smaller set of files defined by speed only, I for one would be most grateful.
We all use the database in different ways and in different units.
So I followed up this suggestion for Garmin.
Using the single file .GPX file for Garmin opened in MapSource, it takes me 3 minutes to create 8 new groups of SpeedCamera and saved as 8 new files sorted by speed [0,20,30,40,50,60,70,?]
Quote:
when I'm driving I'm really more interested in the speed I shoud be below, than the mechanics of the camera that will nail me, and...
Again this is a good sugestion as on the Garmin POI 'overlay' the cameras could show less clutter if
Quote:
MOBILE:9999@40
was replaced by 40M
On the main Garmin database do we all want to know the camera ID as we drive
Quote:
20-G-16027
could be replaced by 20G.
Less clutter visually on the screen, but I have not managed to find a way to rename 9000 cameras in Garmin yet, but perhaps taking these new Garmin speed files into Excel will provide a method???
Joined: Feb 24, 2006 Posts: 80 Location: Littlehampton UK/Antibes France
Posted: Sun Jun 11, 2006 9:50 pm Post subject: Database Formats
If you dowwnload the Destinator database it is already in .csv format, you just need to put the columns in the correct order. _________________ Charlie Gregory
iPaq 2210, Velcro mount, Viking 1GB SD, 2GB Microdrive,
4GB Kingston Elite Pro CF,TomTom 5 v5.21, Maps of Europe,
Dest 6, Maps of Europe, Memory Map Navigator (Europe Edition)
GlobalSat SDI0 SD-501 GPS, BT GPS
TT BT GPS, Inforad
Posted: Today Post subject: Pocket GPS Advertising
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
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
Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
Hi! We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
But as we’re losing ad-revenue from this then why not make a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!