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=’+’yourmail@gmail.com’+’&mdutc=’+dutccc
urllib.request.urlopen(url).read()

No Comments

Leave a Reply

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

Road Rage Reduction
Excellent Schools

People who are active, find things to do during Covid. Some go to volunteermatch.org or quora.com and ask “how do I do community service hours online”. Then they find wikispeedia.org. Over 100 students have come our way this past 2 years. We had so many requests that we automated the …

Road Rage Reduction
How to defeat automatic license plate readers?

Covid, Layoffs, whats next? ALPRs. Automatic License Plate Readers! They are coming to my small town. What exactly are they? They are $2k toys reserved for Police in every state from Maine to California. link Wikispeedia was formed when I was sick and tired of Bubba giving out tickets for …

Road Rage Reduction
Daylight savings time is to drivers as y2k was to pilots.

Céline Vetter, a circadian sleep scientist [hmmmm, circadiummmm…] at the University of Colorado, Boulder, and senior author of the study, says that this research data paints a clear picture on the very tangible dangers of daylight saving time. “The acute adverse effects of DST on fatal traffic accident risk are real …