Speed Limit Correction file?

Found it, never mind.

What is it?

.System>SQLLite>SpeedCorrections>speed.mdb

I don't have that folder in my 3490LMT. I have the SQLite folder but no Speed sub folder (just a temp). I'm obviously missing not only the folder but what it is actually and where to get it.

Anyone?

Is it possible that you need to have saved at least one speed limit correction for the file & folder to be created?

OK ok...I forgot about the +/- correction screen. You're probably right. Once you make a change, it probably gets created then and there. I wonder if this file gets uploaded to Garmin when you do a firmware or map update so that Garmin's database gets updated?!?!

That's a good question.

Any one?

I'd be willing to bet that your corrections just sit in that file and go nowhere.

If you elect to share information with Garmin on my.garmin.com this is one of the files they fetch along with errors generated by your unit.

But you must first agree to share.

Thanks for the info. I guess some of the other files would include crash logs and POI's that were searched. I usually don't share this stuff cause I'm not a big fan of data mining but I could see how the speed correction would be helpful for future updates.

Do you know where those files are located in the unit and what are they called?

On my 40, I see logged event data in Garmin:\.System\Diag

I actually have the file locations listed on my home PC. I'll post 'em when I get a chance. They're all in that subfolder SQLite if I recall. Each POI searched is given a rating. I tend to delete them manually as there is no way to do it with the units UI. I complained to Garmin at CES last year about it and even sent their developers a list of issues which they never responded to. That is a whole other story though.

.

This is C&P from a post at another site. All credit goes to bacevedo for the info below.

I have been playing with the SQLite db files on my 3750 and wanted to share some of the info with you all. I have seen on other forums where people are wondering where the nuTrends and myTrends data is stored - I think I have found their location.

You have to go into the .System\SQLite folder. In this folder are 6 files with .db file extension. The files on my 3750 are listed below. Note: I copied the files over to my computer and used those copies to connect to.

* D232800.db
This appears to be the trafficTrends North America data, according to the garmin_metadata table in the db. It might also be just metadata that the system uses to find the actual data somewhere else on the nuvi. There is a table called SpeedProfile that has the columns SSID, TimeID and SpeedSamples. I don't know what the data means, but there is a lot of if there.

* local_poi.db
I think this one is storing the information when you rate a poi and possibly mark it as not valid, etc.

* mlg_history.db
This appears to store the ecoRoute data for your driving habits. The history table has columns like acceleration score, speed score, deceleration score, etc.

* pre.db
This appears to store the myTrends data and "pre" stands for prediction. There is a table in this db called prediction that contains the stats for its "predicted" routes.

* system.db
This db is used by the system to find the other tables. It has only one table called system, that has two rows. One points to D232800.db and has the description of trafficTrends™ North America. The other one just points to the mlg_history.db file with no description.

* user_strings.db
This is where the predictive text is stored when you enter in addresses or search fields. The table user_string contains the string_data column (i.e. Best Buy, San Diego) and the context column contains a numeric value that matches to whatever screen you were in when you entered the value. There is also a usage_count and time_stamp column, probably so it can remove old and unused values when some pre-determined amount of values are stored.

To view these databases, I downloaded a free SQLite client from www.navicat.com (I downloaded the non-commercial Lite version for Windows, which is free.) In Navicat, you create a new "connection" for SQLite, give the connection a name (I used the name of the db file) and then enter the path of the db file (press the ... button to bring up a file dialog box). Don't change any other settings in any other tab and just press OK. Double click the newly created connection and your database will open, allowing you to see all of the tables and data inside.

I am not sure if these are copies of databases that reside in memory or if these are the actual databases. I haven't tried changing data in them to see if the nuvi detects the changes.

I have some screenshots that I can upload later, but thought I would post this for now.

Have fun!

Bryan
http://forums.gpsreview.net/viewtopic.php?t=20009

Yep...those are some of the files. In addition, there is a folder .System\Logs and it contains a file called Searches.txt. I'm sure that's harvested as well to include your search history in addition to the files under SQLite.

Thanks!

Thanks

Speaking of which - does it report these errors to Garmin / Navteq for correction at an upcoming release? I've always wondered if I'm doing this just for my own benefit or if it flags a road and they can fix it later on. Perhaps after a threshold is hit - i.e. 6 people report the same speed on an road, etc.

It is definitely for your own benefits when you travel the same road again and for others once they incorporate the change to future releases.

They probably don't change it just because one report, it has to come from several sources.

I didn't know about this, I have a Nuvi 2595... thanks!

You know with all the corrections submitted to these companies for maps like NAVTEQ, Garmin, or whatever, you'd think since we've done some of the leg work, we'd get a discount on updates (not lifetime updates of course) but that's a fantasy on my part I guess!

Even better is when I submit a two page list of issues RE: the Nuvi to the product manager (who I met @ CES) and their development team and get no response, that's even worse! The guy gives me his card and asks for the above info and then doesn't even respond! Anyway, just a rant on my part here....sorry.

Tried hitting the speed limit icon on my Nuvi 2595, that only brings up the dashboard... unless I'm missing something.

Didn't know that you can make corrections to the speed limit. How to bring that up? Is it possible to add speed limit to roads that garmin don't have data on?
Thanks.

Speed limit adjustment is only available on the 23x0, 24x0, 34x0 and 35x0 series. I'm not sure if the 22x0 series has it. It is strange that Garmin removed this feature from the 2xx5 series, which is the latest 2012 product line.

It's brought up by touching the speed limit sign. If there is no speed limit data for a road, the speed limit sign is replaced by a + symbol. You can touch this symbol and add a speed limit for that stretch of road. The process is explained here: http://gpstracklog.com/2011/01/nu-feature-speed-limit-adjust...

It's also available on the 3790, IIRC. Haven't used it on mine yet, but as I recall, it's there.

Unfortunately it is not on the 37xx series.

I didn't even know that feature existed

If they do use this feedback, I agree that it probably does need a relative amount of such responses to trigger action by them.

Thank you