Skip to content

Instantly share code, notes, and snippets.

Robert Forkel xrotwang

Block or report user

Report or block xrotwang

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View rogue_query.sql
2017-11-24 10:43:36,843 INFO [sqlalchemy.engine.base.Engine][waitress] SELECT AS languoid_pk, AS language_pk, language.jsondata AS language_jsondata, language.polymorphic_type AS language_polymorphic_type, AS language_id, AS language_name, language.description AS language_description, language.markup_description AS language_markup_description, language.latitude AS language_latitude, language.longitude AS language_longitude, language.version AS language_version, languoid.hid AS languoid_hid, languoid.father_pk AS languoid_father_pk, languoid.family_pk AS languoid_family_pk, languoid.level AS languoid_level, languoid.status AS languoid_status, languoid.bookkeeping AS languoid_bookkeeping, languoid.newick AS languoid_newick, languoid.child_family_count AS languoid_child_family_count, languoid.child_language_count AS languoid_child_language_count, languoid.child_dialect_count AS languoid_child_dialect_count, AS languoid_1_pk, AS langua
xrotwang /
Created Jan 30, 2015
List an organizations GitHub repositories and their size
import sys
import re
import requests
from hurry.filesize import size
NEXT = re.compile('\<(?P<url>[^\>]+)\>; rel\=\"next\"')
Python 2.7 script to determine WWF Ecoregions in which a given species has been observed.
Assumes you have downloaded the WWF Ecoregions shapefile.
$ python "Ursus maritimus"
PA1101 Arctic desert
NA0616 Southern Hudson Bay taiga
xrotwang /
Created Dec 18, 2014
Get list of phonologies from glottolog
import json
from sqlalchemy import not_
from sqlalchemy.orm import joinedload
from clld.scripts.util import parsed_args
from clld.db.meta import DBSession
from glottolog3.models import Ref, Doctype, Languoid, Provider
You can’t perform that action at this time.