new & interesting places for your GPS

Speed Limit Correction file?

 

I remember reading somewhere, the location of speed limit corrections in the Nuvi series. I can't find it now.

Just upgraded to 2013.20 and I want to delete what speed limit corrections I have put in in the past. Where are these files?

Thanks

--
KD5XB in DM84

Found it...

Found it, never mind.

--
KD5XB in DM84

What is

What is it?

--
Nuvi 350, 760, 1695LM, 3790LMT, 2460LMT, 3597LMTHD and TomTom XXL540s

@t923347

.System>SQLLite>SpeedCorrections>speed.mdb

--
Garmin 38 - Magellan Gold - Garmin Yellow eTrex - Nuvi 260 - Nuvi 2460LMT - Google Nexus 7

Thanks

wink

--
Nuvi 350, 760, 1695LM, 3790LMT, 2460LMT, 3597LMTHD and TomTom XXL540s

Is this something extra?

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?

--
Garmin: GPSIII / StreetPilot / StreetPilot Color Map / StreetPilot III / StreetPilot 2610 / GPSMAP60CSx / Nuvi 770 / Nuvi 765T / Nuvi 3490LMT * Pioneer: AVIC-80 / N3 / X950BH

Speed limits

Preroll wrote:

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?

Now I Remember

CraigW wrote:
Preroll wrote:

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?!?!

--
Garmin: GPSIII / StreetPilot / StreetPilot Color Map / StreetPilot III / StreetPilot 2610 / GPSMAP60CSx / Nuvi 770 / Nuvi 765T / Nuvi 3490LMT * Pioneer: AVIC-80 / N3 / X950BH

That's a good question.

That's a good question.

Any one?

--
nightrider --Nuvi's 660 & 680--

Probably not

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

--
KD5XB in DM84

not so

KD5XB wrote:

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.

--
Garmin 38 - Magellan Gold - Garmin Yellow eTrex - Nuvi 260 - Nuvi 2460LMT - Google Nexus 7

Thanks for the info

flaco wrote:
KD5XB wrote:

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.

--
Garmin: GPSIII / StreetPilot / StreetPilot Color Map / StreetPilot III / StreetPilot 2610 / GPSMAP60CSx / Nuvi 770 / Nuvi 765T / Nuvi 3490LMT * Pioneer: AVIC-80 / N3 / X950BH

big brother?

Preroll wrote:

I guess some of the other files would include crash logs and POI's that were searched.

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

--
Garmin 38 - Magellan Gold - Garmin Yellow eTrex - Nuvi 260 - Nuvi 2460LMT - Google Nexus 7

Event & Diag files

flaco wrote:
Preroll wrote:

I guess some of the other files would include crash logs and POI's that were searched.

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

--
NUVI40 Kingsport TN

I Have To Look It Up At Home

flaco wrote:
Preroll wrote:

I guess some of the other files would include crash logs and POI's that were searched.

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

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.

--
Garmin: GPSIII / StreetPilot / StreetPilot Color Map / StreetPilot III / StreetPilot 2610 / GPSMAP60CSx / Nuvi 770 / Nuvi 765T / Nuvi 3490LMT * Pioneer: AVIC-80 / N3 / X950BH

.

.

--
Garmin 38 - Magellan Gold - Garmin Yellow eTrex - Nuvi 260 - Nuvi 2460LMT - Google Nexus 7

SQLite db files explained

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

--
Garmin nüvi 1390LMT(returned) * Garmin 3590LMT(stolen) * Garmin 3590LMT LOH

In addition

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.

--
Garmin: GPSIII / StreetPilot / StreetPilot Color Map / StreetPilot III / StreetPilot 2610 / GPSMAP60CSx / Nuvi 770 / Nuvi 765T / Nuvi 3490LMT * Pioneer: AVIC-80 / N3 / X950BH

thank you

Preroll wrote:
flaco wrote:
Preroll wrote:

I guess some of the other files would include crash logs and POI's that were searched.

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

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.

Thanks!

--
nightrider --Nuvi's 660 & 680--

and...

Preroll wrote:

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

--
nightrider --Nuvi's 660 & 680--

Speaking of which - does it

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.

i thought about that too

ptownoddy wrote:

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.

--
Garmin 38 - Magellan Gold - Garmin Yellow eTrex - Nuvi 260 - Nuvi 2460LMT - Google Nexus 7

Learned something new

Preroll wrote:
CraigW wrote:
Preroll wrote:

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?!?!

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

--
Garmin Nuvi 2595LMT

No Break

flaco wrote:
ptownoddy wrote:

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.

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.

--
Garmin: GPSIII / StreetPilot / StreetPilot Color Map / StreetPilot III / StreetPilot 2610 / GPSMAP60CSx / Nuvi 770 / Nuvi 765T / Nuvi 3490LMT * Pioneer: AVIC-80 / N3 / X950BH

Does not work on a 2595 LMT

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

--
Garmin Nuvi 2595LMT

Didn't know that you can

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 Correction

Garmin Gal wrote:

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

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.

Quote:

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?

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.

--
nüvi 3790T | nüvi 775T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK

Not on 3790

Juggernaut wrote:

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

I didn't even know that feature existed

I'm sure that...

flaco wrote:
ptownoddy wrote:

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.

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

--
nightrider --Nuvi's 660 & 680--

Thank you

Thank you

sponsored links