Skip to content

Instantly share code, notes, and snippets.

you rock :-)

Roland Tanglao rtanglao

you rock :-)
View GitHub Profile

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

                "answers" => [
        [ 0] 1222018,
        [ 1] 1222044,
        [ 2] 1222056,
View 2023-02-15-image-from-emoji.rb
# convert pango:'a🤳Hello! 😀How are you?' example.png # Selfie emoji is Unicdode Hex 1F933
require 'rmagick'
image ='pango:&#x1F933;The <b>bold</b> and <i>beautiful</i>').first
View vancouver-accident-location-data-full-data.csv
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 / query.sql
Last active March 29, 2022 18:23
View query.sql
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
View 1-using-csv-new-read-remote-csv.rb
def read(url), :headers => :first_row).each do |line|
ap line
rtanglao /
Last active November 2, 2020 02:21
how to get covid 19 html using curl, jq and the ontario unofficial API that @roryrooster on twitter discovered
# use sed on WSL and linux instead of gsed
curl ",field_body_beta,body" | jq ".body.und[0].value" | gsed 's/\\n/\n/g; s/\\t/\t/g' >cleaned2-ontario-COVID-19-daily-summary.html
curl "" | \
pup '#kb-overview-table tbody tr td:nth-child(1) a[href*="/en-US/kb/"]' | head -1   
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  320k  100  320k    0     0  89264      0  0:00:03  0:00:03 --:--:-- 89240
<a href="/en-US/kb/get-started-firefox-overview-main-features">

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


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.