Datasette DEMO for CozyConf 2020
Download data
https://qri.cloud/mfdz/stuttgart_gelbekarten – needs login :(
https://qri.cloud/mfdz/stuttgart_gelbekarten – needs login :(
# needs: Python 3.6, requests, tqdm | |
import asyncio | |
import csv | |
import requests | |
from concurrent.futures import ThreadPoolExecutor | |
from tqdm import tqdm | |
def get_token(): |
# Python 3.6+ | |
import pynmea2 | |
import serial | |
s = serial.Serial("/dev/ttyAMA0", 9600, timeout=0.5) | |
line = "" | |
while True: | |
try: | |
line = s.readline().decode() | |
except UnicodeDecodeError: |
## Böblinger-Strasse | |
curl -X POST "http://www.eco-public.com/ParcPublic/CounterData?table=ecobdd.%60Z_100034894%60&idOrganisme=607&idPdc=100034894&fin=09%2F06%2F2017&debut=01%2F01%2F2017&interval=4&pratiques=101034894%3B102034894%3B103034894%3B104034894" | |
## König-Karls-Brücke | |
curl -X POST "http://www.eco-public.com/ParcPublic/CounterData?table=ecobdd.%60Z_100037170%60&idOrganisme=607&idPdc=100037170&fin=09%2F06%2F2017&debut=01%2F01%2F2017&interval=4&pratiques=" | |
delete FROM "schemaorg_jsonthing" WHERE UPPER("schemaorg_jsonthing"."pure_data"::text) LIKE UPPER('%nan,%'); |
#!/usr/bin/env python | |
# -*- coding: utf-8 -*- # | |
from __future__ import unicode_literals | |
AUTHOR = u'FIXME' | |
SITENAME = u'FIXME' | |
SITEURL = 'http://example.org' | |
TIMEZONE = 'Europe/Berlin' |
I hereby claim:
To claim this, I am signing this object:
import sys | |
import locale | |
if sys.stdout.isatty(): | |
default_encoding = sys.stdout.encoding | |
else: | |
default_encoding = locale.getpreferredencoding() |
# -*- coding: utf-8 -*- | |
# | |
# frwd to other interested parties at the institute | |
# | |
import datetime, time, sys | |
leave_at = datetime.datetime(2012, 12, 13, 12, 00) | |
first = True | |
while True: | |
delta = leave_at - datetime.datetime.now() |