Sam Leach samuelleach

My goal here was the create a routable graph for Chicago.

I used Ubuntu 12.04LTS on an m2.4xlarge just to be sure memory wasn't too much of an issue.

Install

Start a screen session and start downloading an OSM extract (I used this extract of Illinois). In another screen I did the following:

  sudo apt-get update && sudo apt-get upgrade -y

sudo apt-get -y install git make cmake build-essential \

	const SECRET_KEY = ENTER YOUR SECRET KEY HERE;
	const MAX_TOKENS = 200;

	// For more cool AI snippets and demos, follow me on Twitter: https://twitter.com/_abi_

	/**
	* Completes your prompt with GPT-3
	*
	* @param {string} prompt Prompt
	* @param {number} temperature (Optional) Temperature. 1 is super creative while 0 is very exact and precise. Defaults to 0.4.

	with events as (
	select
	anonymous_id,
	user_id,
	cast(null as string) as name,
	cast(null as string) as email,
	timestamp,
	'page_view' as event_type,
	concat(split(context_ip,'.')[safe_offset(0)],'.*.*.',split(context_ip,'.')[safe_offset(3)]) as context_ip,
	context_page_path,

	with events as (
	select
	anonymous_id,
	user_id,
	cast(null as string) as name,
	cast(null as string) as email,
	timestamp,
	'page_view' as event_type,
	concat(split(context_ip,'.')[safe_offset(0)],'.*.*.',split(context_ip,'.')[safe_offset(3)]) as context_ip,
	context_page_path,

	/*
	This query creates a combined view of tracks and pages from segment data.
	Sessions are computed by finding the any session start timestamp denoted by an activity gap of 30 minutes.
	Session IDs are assigned to each track or page record using a combination of the session index, user ID, and date.
	*/
	WITH
	with_session_starts AS (
	SELECT
	*,
	COALESCE( (UNIX_MILLIS(timestamp) - UNIX_MILLIS(LAG(timestamp) OVER (PARTITION BY user_id ORDER BY timestamp ASC)))/(1000*60) >= 30,

	#!/usr/bin/env python

	import base64

	from Crypto import Random
	from Crypto.Cipher import AES

	BS = 16
	pad = lambda s: s + (BS - len(s) % BS) * chr(BS - len(s) % BS)
	unpad = lambda s : s[0:-s[-1]]

	var tileReduce = require('tile-reduce');
	var path = require('path');

	tileReduce({
	zoom: 14,
	map: path.join(__dirname, '/process.js'),
	sources: [
	{name: 'ways', mbtiles: 'ways.mbtiles')}
	]
	});

	# Server
	apt-get update
	apt-get install -y python-software-properties
	add-apt-repository -y ppa:webupd8team/java
	apt-get update
	apt-get install -y oracle-java7-installer sysstat convmv ruby1.9.3
	wget http://bretth.dev.openstreetmap.org/osmosis-build/osmosis-latest.tgz
	mkdir osmosis
	tar -xvzf osmosis-latest.tgz -C osmosis
	chmod a+x osmosis/bin/osmosis

	"""Reads a har file from the filesystem, converts to CSV, then dumps to
	stdout.
	"""
	import argparse
	import json
	from urlparse import urlparse


	def main(harfile_path):
	"""Reads a har file from the filesystem, converts to CSV, then dumps to