Christopher Baker bakercp

Happy Valentine's Day

GRANT ALL PRIVILEGES ON divvy_2013.* TO 'divvy@localhost';

NOTE, LOAD DATA INFILE requires that the csv file be in the same directory as the database. strange. very strange.

Steps to pre-process Divvy Data
There are some instances of #N/A in the station ids - search for all and replace with -1 (about 1900 of them)
In the trip duration column, there are occasionally values with commas and quotes - e.g. "1,123" representing 1123.
- These are converted to a single number in excel.
Remove the text name columns for the station names. we'll use the databased to join that data on the other table.
All dates are converted to mysql format using the format yyyy-mm-dd hh:mm:ss

	/// 1. Download the zip file here: https://github.com/obviousjim/ofxDelaunay
	/// 2. Extract it into your data/openFrameworks/addons folder of ofSketch.
	/// 3. Make sure that the folder is called ofxDelaunay, not ofxDelaunay-master or something.
	/// 4. Open ofSketch and paste the following code into a new sketch.
	/// 5. Using the "Addons" button (+ in a circle next to the paperclip), scroll down and make sure ofxDelaunay is checked.
	/// 6. Run!

	#include "ofxDelaunay.h"

	ofxDelaunay triangulation;


	color[] colors = new color[4];
	PVector[] vertices = new PVector[4];


	int colorIndexOffset = 0;

	long lastTime = 0;

	void setup()

	To Install:

	- Download 0.8.3 or use the 0.8.3 tag on master.
	- Install dependencies.
	- Copy config.linuxarmv7l.udoo.mk into $OF_ROOT/libs/openFrameworksCompiled/project/linuxarmv7l
	- Go to example project.


	To Prep:
	$ export MAKEFLAGS="-j4 -s PLATFORM_VARIANT=udoo"

	// =============================================================================
	//
	// Copyright (c) 2009-2013 Christopher Baker <http://christopherbaker.net>
	//
	// Permission is hereby granted, free of charge, to any person obtaining a copy
	// of this software and associated documentation files (the "Software"), to deal
	// in the Software without restriction, including without limitation the rights
	// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
	// copies of the Software, and to permit persons to whom the Software is
	// furnished to do so, subject to the following conditions:

	void setup() {
	}

	void draw() {
	ofDrawBitmapStringHighlight("Hello Gist!", 105, 120, ofColor::white, ofColor::black);
	}

	0.997446] Advanced Linux Sound Architecture Driver Version 1.0.24.
	[ 1.004682] Bluetooth: Core ver 2.16
	[ 1.008388] NET: Registered protocol family 31
	[ 1.012858] Bluetooth: HCI device and connection manager initialized
	[ 1.019233] Bluetooth: HCI socket layer initialized
	[ 1.024132] Bluetooth: L2CAP socket layer initialized
	[ 1.029259] Bluetooth: SCO socket layer initialized
	[ 1.034600] cfg80211: Calling CRDA to update world regulatory domain
	[ 1.042032] i2c-core: driver [max17135] using legacy suspend method
	[ 1.048319] i2c-core: driver [max17135] using legacy resume method

	// Get the most popular routes

	SELECT count(*) AS CNT, from_station_id, to_station_id FROM `Divvy_Trips_2013` GROUP BY from_station_id, to_station_id ORDER BY CNT DESC


	//
	SELECT COUNT(*) AS CNT, from_station_id FROM `Divvy_Trips_2013` WHERE gender = 'F' AND birth_year > 1994 GROUP BY from_station_id ORDER BY CNT DESC