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
What is Charity?

what is charity

Road Rage Reduction
List of people removed from social media specifically related to the 2020 US Election

Tracy Beans. Paypal. Dr Patrick Byrne. Twitter Dr Shiva Ayyadurai. Twitter. Jordan Peterson. Patreon. Donald Trump. Facebook.

Road Rage Reduction
Artificial Intelligence Is On Your Side

A wedding anniversary was turned upside down when Julie Eberly was headed towards the beach with her husband, Ryan Eberly (Sederstrom). Not seeing the car behind him, Ryan switched lanes and accidentally pushed another driver, Dejywan Floyd, off the road (“Arrest Made in Lumberton”). Upon getting back on the highway, …