fitnr

INSERT INTO gtfs.calendar (feed_index, service_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday, start_date, end_date)
SELECT a.feed_index, a.service_id, monday, tuesday, wednesday, thursday, friday, saturday, sunday, start_date, end_date
FROM (
  SELECT feed_index, service_id 
    FROM gtfs.trips a 
      LEFT JOIN gtfs.calendar b using (feed_index, service_id) 
  WHERE COALESCE(b.monday, b.friday) IS NULL 
  GROUP BY feed_index, service_id
  ) a 
  INNER JOIN gtfs.calendar b ON a.feed_index = b.feed_index AND (

fitnr

import sys
import json
from io import BytesIO
import geomet.wkb

def bytes2dict(x):
    '''Decode a dictionary encoded in bytes using the dicAsBytes method.'''
    b = BytesIO(x)
    count = read_int(b)
    result = {}

fitnr

curl http://api.census.gov/data/2014/acs5/variables.json |
  jq -r '[ .variables | to_entries[] | .value.concept ] | unique[]'
  > tables.txt

fitnr

#!/bin/bash
set -e

DIR=$1
SHP=$2
TMP=$(mktemp -d)

export DIR

downsample() {

fitnr

fitnr

-- Load data from a UK-wide GTFS into postgres using https://github.com/fitnr/gtfs-sql-importer
-- Used this GTFS file:
-- https://transitfeeds.com/p/association-of-train-operating-companies/284

with terminals as ( -- ID codes for London terminal stations
   values ('BFR'), ('CST'), ('CHX'), ('CTK'), ('EUS'), ('FST'), ('KGX'), ('LST'), ('LBG'), ('MYB'), ('MOG'), ('OLD'), ('PAD'), ('STP'), ('SPX'), ('VXH'), ('VIC'), ('WAT'), ('WAE')
)
, london_trips as ( -- select trips that include the above codes
	select distinct feed_index, route_id, trip_id
	from gtfs.stops

fitnr

// encoded:
// javascript:(function()%7B$('table').each(function()%7Bvar%20$table=$(this);$('%3Ctextarea%3E').css('width',$table.width()).css('height','400px').html($.map($table.find('tr'),function(tr)%7Breturn%20$.map($(tr).find('th,%20td'),function(e)%7Breturn'%22'+$(e).text().replace('%22','%22%22').replace('%5Cn','%20')+'%22'%7D).join(',')%7D).join('&%2313;&%2310;')).insertAfter($table);%7D)%7D)()
javascript:(function() {
    $('table').each(function() {
        var $table = $(this);
        $('<textarea>').css('width', $table.width())
            .css('height', '400px')
            .html(
                $.map(
                    $table.find('tr'), function(tr) {

fitnr

fitnr

How to

Change the left_domain_name and right_domain_name variables to reflect your project. If your sites have exactly matching URL schemas (where localhost/my/path is always equivalent to production.com/my/path), you can ignore that big comment block. If not, check it out and rewrite the two functions to fit your setup.

Compress the javascript, say with UglifyJS.

Urlencode the result, say with this tool.

Add javascript: to the front and save it as a bookmark. Depending on your browser, the easiest way to do this might be to make a new bookmark for a random page and then edit both the address and name.

fitnr

#!/usr/bin/env python3
import json
import argparse
import s2sphere as s2


def point2coord(point):
    return s2.LatLng.longitude(point).degrees, s2.LatLng.latitude(point).degrees