Skip to content

Instantly share code, notes, and snippets.

you rock :-)

Roland Tanglao rtanglao

you rock :-)
View GitHub Profile
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
rtanglao / query.sql
Last active Mar 29, 2022
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 Nov 2, 2020
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.



rtanglao /
Last active Sep 12, 2019

Keybase proof

I hereby claim:

  • I am rtanglao on github.
  • I am rtanglao ( on keybase.
  • I have a public key ASCzFDnFUGNiGuQlc4_nYFxszM32BJzpjfAoOeLqasb58Qo

To claim this, I am signing this object: