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
Get FedEx off my sidewalk.

Coming soon is legistation to allow motorized vehicles on YOUR sidewalk. In 2019, Fedex has a robot sidewalk trial in New Hampshire. They had to go that far away to get anyone to let them put motors on sidewalks!  link. Shame on you “the free state”.   Most people have …

Road Rage Reduction
National Dashcam Safety Portal prosecuted 1200 idiot drivers with your help.

More than 1,200 drivers have been prosecuted using a new database where fellow motorists can upload incriminating footage captured on dashcams, This is Money and MailOnline can exclusively reveal.                    You can submit your own dashcam evidence here:         …

Road Rage Reduction
Make your own wikispeedia. Repl.it

Wikispeedia was designed so everyone could do their daily query to update their own database. Please follow the wikispeedia.org/terms . With that goal in mind, I found a possible tool. If you code, you should try it out. Its online shared python. https://repl.it/talk/share/speed-limit-database/16584   Step 1: Get Data Step 2: …