Skip to content

Instantly share code, notes, and snippets.

View rtanglao's full-sized avatar
😃
you rock :-)

Roland Tanglao rtanglao

😃
you rock :-)
91 followers · 164 following
View GitHub Profile
@rtanglao
rtanglao / unicode-sparkline.md
Last active December 11, 2023 08:44

min: 22.000000; max: 52.000000 ▇█▅█▄▁▃

@rtanglao
rtanglao / testable.md
Last active December 7, 2023 18:49
id           Title                                                                                                      O T M A U Tags
  1: [1432854](https://supp
@rtanglao
rtanglao / something.md
Last active November 21, 2023 05:40
testing markdown
@rtanglao
rtanglao / tooltiptest.md
Last active November 20, 2023 04:59
testing tool tips
@rtanglao
rtanglao / 2023-02-15-image-from-emoji.rb
Last active September 17, 2023 20:51
# convert pango:'a🤳Hello! 😀How are you?' example.png # Selfie emoji is Unicdode Hex 1F933
require 'rmagick'
image = Magick::Image.read('pango:&#x1F933;The <b>bold</b> and <i>beautiful</i>').first
image.write('pango.png')
@rtanglao
rtanglao / issue-3686-still-fails.md
Last active April 12, 2023 02:29

April 11, 2023: ./testAPI-issue-3686.rb issue 3686 still fails i.e. the time on the website is Pacific but the time returned from the API says Z i.e. UTC but is actually PST

./testAPI-issue-3686.rb 
{
                "answers" => [
        [ 0] 1222018,
        [ 1] 1222044,
        [ 2] 1222056,
@rtanglao
rtanglao / b-chaan.md
Last active October 8, 2022 01:23

The following translation is courtesy of Gary Kwong. Thanks Gary!

English:

I would like a B meal with cold milk tea with sweet condensed milk. By the way, I’m sorry, I don’t speak Chinese. I am a Canadian of Filipino heritage.

Cantonese:

唔該，我想要個B餐，要杯凍奶茶（煉奶）。唔好意思，我唔識講中文，我係菲律賓裔加拿大人。

@rtanglao
rtanglao / vancouver-accident-location-data-full-data.csv
Created May 11, 2022 17:36
Vancouver location data
We can't make this file beautiful and searchable because it's too large.
Location,Crash Type,Municipality,Year,Crash Count,Latitude,Longitude
GRANDVIEW HWY S & TEMPLETON DR,Property damage only,VANCOUVER,2017,1,49.25909,-123.060191
BOUNDARY RD & REGENT ST,Property damage only,VANCOUVER,2017,1,49.259109,-123.023633
VINE ST & W 14TH AVE,Property damage only,VANCOUVER,2017,1,49.259265,-123.157816
E 13TH AVE & WATSON ST,Property damage only,VANCOUVER,2017,1,49.259302,-123.100497
ASH ST & W 13TH AVE,Property damage only,VANCOUVER,2017,3,49.259493,-123.117658
MACDONALD ST & W 14TH AVE,Property damage only,VANCOUVER,2017,3,49.259579,-123.168318
BALACLAVA ST & W 14TH AVE,Property damage only,VANCOUVER,2017,1,49.259663,-123.174155
FIR ST & W 13TH AVE,Property damage only,VANCOUVER,2017,1,49.259853,-123.141183
E 12TH AVE & KINGSWAY & MILLTOWN PL,Property damage only,VANCOUVER,2017,44,49.259878,-123.096571
@rtanglao
rtanglao / query.sql
Last active March 29, 2022 18:23
get-county-by-date-2021-firefox-sumo-questions.db
SELECT strftime('%Y-%m-%d', created) AS yyyymmdd, count (*) as 'num_SUMO_questions'
FROM "2021-yearly-ff-questions-en-us"
WHERE created >= date('2021-01-01', 'localtime')
AND created < date('2022-01-01', 'localtime')
GROUP BY yyyymmdd
@rtanglao
rtanglao / getGastownPhotos.rb
Created September 9, 2010 04:02
get Roland's Gastown's photos
#!/usr/bin/env ruby
require 'json'
require 'net/http'
require 'pp'
require 'Time'
require 'uri'
require 'parseconfig'
flickr_config = ParseConfig.new('flickr.conf').params
api_key = flickr_config['api_key']