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()

No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

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

Road Rage Reduction
5
Snap

Thanos Snaps and all is cut in half. I want to thank everyone involved with Wikispeedia. We are in the seven stages of loss. Here is my confession. We moved off Amazon to save money. [stage 1] I often say that I spent my sons childhood on Wikispeedia. I hope …

Road Rage Reduction
Crossing Fingers

We applied for a Charitable Grant thru FedEx. Amount requested: $2000. Summary: Help reduce habitual speeding of one or more teens. We will install a Speederaser in their car and help them quit speeding so much. The recipient(s) will be referred to us from the traffic court system. This will …

Road Rage Reduction
This is probably the end of Wikispeedia… 

If anyone knows anyone who needs a speed limit database, now is the time to step up! This is probably the end of Wikispeedia. We lost our monthly sponsor, TSO Mobile. They have keep us alive for years and queried us heavily! Without them we would have been gone years …