Python code to upload data to Wikispeedia

If you need an easy way to upload or delete some wikispeedia data, consider python.

This is some python code that might help. Try it, its easy to learn and fun.

link

———-make sure you indent it properly. Python needs that!——–

#!/usr/bin/python
# -*- coding: utf-8 -*-

import sqlite3 as lite
import sys
import urllib
import urllib.request
import datetime
from dateutil import parser

con = lite.connect(‘east’)

with con:

cur = con.cursor()
cur.execute(“SELECT * FROM tmp”)

rows = cur.fetchall()

i= len(rows)

for row in rows:
i=i-1
print (str(i))
pointLat =row[0];
pointLon =row[1];
swlat= pointLat-0.00001;
nelat= pointLat+0.00001;
swlng= pointLon-0.00001;
nelng= pointLon+0.00001;
cog=row[2];
mph=row[3];
deletedon=row[4];
submittedon=row[5];
kph=row[6];
sutc=row[7];
dutc=row[8];
tag=row[9];
tagg= urllib.parse.quote(tag);
mph_truck=row[10]
web_local=row[11]
sutcc = parser.parse(sutc)
dutcc=None
if dutc is not None:
dutcc= parser.parse(dutc)
dutccc= urllib.parse.quote(dutc)
if dutcc==None:
url = ‘http://www.wikispeedia.org/a/process_submit_bb3.php?name=all’+’&mlat=’+str(pointLat)+’&mlon=’+str(pointLon)+’&mmph=’+str(mph)+’&mkph=69&mtag=’+tagg+’&mcog=’+str(cog)
urllib.request.urlopen(url).read()
elif dutcc is not None:
url = ‘http://www.wikispeedia.org/a/delete_bb4a.php?nelat=’+str(nelat)+’&swlat=’+str(swlat)+’&nelng=’+str(nelng)+’&swlng=’+str(swlng)+’&mcog=’+str(cog)+’&delmail=’+’gpscruise@gmail.com’+’&mdutc=’+dutccc
urllib.request.urlopen(url).read()

Speed Limit News
Lombard street look out.

Good boy. Who gets a mapping? You do! Lombard Street will get one more mapping for sure.   Who in the world would expect a new mapping company to arise. Today, mapper.ai started hiring uber drivers to make maps. Imagine that. On their off time, they get $3 /mile to drone …

Road Rage Reduction
How I survived Road Rage and the 6 second horn.

We have all heard the 6 second horn. I sure did. But whats important is how I survived this. First tip to get ahead of road rage is this. Turn all your mirrors away so you can’t see who is behind you. That way you won’t see tailgators. They will …

A zoomed in shot of two cars crashed into each other.
Road Rage Reduction
Safe Roads Can Save Lives

We’ve all seen it before. A flood of heavy traffic suddenly stops us in the middle of the highway, and while we’re fumbling for our phones so that Google Maps can lead us out of the madness, we think to ourselves, “Was it another car crash?” Chances are, the answer’s …