type: PIN
Consumer key: 3nVuSoBZnx6U4vzUxf5w
Consumer secret: Bcs59EFbbsdF6Sl9Ng71smgStWEGwXXKSjYvPVt7qys
type: PIN
Consumer key: IQKbtAYlXLripLGPWd0HUA
CREATE TABLE trips_mergetree | |
ENGINE = MergeTree(pickup_date, pickup_datetime, 8192) | |
AS SELECT | |
trip_id, | |
CAST(if(vendor_id='\\N', '', vendor_id) AS Enum8('' = 0, '1' = 1, '2' = 2, 'CMT' = 3, 'VTS' = 4, 'DDS' = 5, 'B02512' = 10, 'B02598' = 11, 'B02617' = 12, 'B02682' = 13, 'B02764' = 14)) AS vendor_id, | |
toDate(pickup_datetime) AS pickup_date, | |
ifNull(pickup_datetime, toDateTime(0)) AS pickup_datetime, | |
toDate(dropoff_datetime) AS dropoff_date, | |
ifNull(dropoff_datetime, toDateTime(0)) AS dropoff_datetime, |
COPY ( | |
SELECT trips.id, | |
trips.vendor_id, | |
trips.pickup_datetime, | |
trips.dropoff_datetime, | |
trips.store_and_fwd_flag, | |
trips.rate_code_id, | |
trips.pickup_longitude, | |
trips.pickup_latitude, | |
trips.dropoff_longitude, |
from fontTools.ttLib import TTFont | |
import random | |
import string | |
ORIGINAL_FONT_PATH = "path/to/Helvetica.ttc" | |
GLORIOUS_FONT_PATH = "path/to/Schmelvetica.ttc" | |
NEW_FONTNAME = b"Schmelvetica" | |
# Load the font |
// | |
// FireworksEffect - Free for all use from Davepl | |
// | |
// Fireworks Effect for Fourth of July | |
public class FireworksEffect : LEDEffect | |
{ | |
// Each particle in the particle system remembers its color, | |
// birth time, postion, velocity, etc. If you are not using DateTime, | |
// all you need in its place is a fractional number of seconds elapsed, which is |
I hereby claim:
To claim this, I am signing this object:
/** | |
* Circular Tooltip (SO) | |
* http://stackoverflow.com/q/13132864/1397351 | |
*/ | |
* { margin: 0; padding: 0; } | |
body { | |
overflow: hidden; | |
background: url(http://theearlcarlson.com/experiments/amTooltip/img/bg.jpg); | |
} | |
/* generic styles for button & circular menu */ |