How to get a snapshot of the entire database.

Wikispeedia wasn’t meant to be a service, but people query us like we are Google and we want to throttle that back. To do that we will offer a snapshot of the 20M+ signs in a single  sqlite3 db file. The file will have things like lat,lon,cog,mph,kph,tag,date, but it will not have things like BTC, email, deleted signs. We want it to be useful for your cruise control or gizmo, but it is up to you to merge in daily changes using the SINCE command.  You must still follow the terms.

Now, people will say this is too hard to obtain, so let me elaborate. I have logged 10k signs, Andy has logged 5K signs and Tommy has logged 1k signs. You can easily log 100 signs in 1 hour of driving. Any company wanting speed limit signs could easily get 10 employees or Facebook friends to log and over a month or two could easily come up with the sign requirement. We want partners and this should burn it in stone. Even if you don’t want a snapshot, please log some signs. Or if you won’t, tell me candidly why you think we suck? @cellurl

Get entire db link



No Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Road Rage Reduction

Recent data suggests that 94% of all traffic accidents are caused by motorist error. 33% of these accidents are related to behaviors due to road rage, such as illegal steering or misunderstanding the intent of another motorist. The following data offers a variety of statistics that may blow your mind. …

Road Rage Reduction
Reality of Road Rage

Road rage is a leading cause of accidents. Road rage occurs due to aggressive driving methods. This term was first applied to a road incident that happned in Los Angeles after a chain of shootings that happened over there. Road rage is the main factor for even accidents that do …

Road Rage Reduction

When you are calmly riding your car and a jerk cuts you off without any signals. You are very likely to say something out of anger like “How dare you?!” This may lead to you getting out of the car to give the person a piece of your mind, or …