Skip to content

Instantly share code, notes, and snippets.

Avatar
😃
you rock :-)

Roland Tanglao rtanglao

😃
you rock :-)
81 followers · 150 following
View GitHub Profile
@rtanglao
rtanglao / vancouver-accident-location-data-full-data.csv
Created May 11, 2022
Vancouver location data
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
rtanglao / query.sql
Last active Mar 29, 2022
get-county-by-date-2021-firefox-sumo-questions.db
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
@rtanglao
rtanglao / how-to-change-3-trailing-spaces-2-trailing-spaces.sh
Created Jul 8, 2021
View how-to-change-3-trailing-spaces-2-trailing-spaces.sh
find . -name '*-test.md' -exec sed -i -e "s/\s\s\s$/ /g" {} \;
@rtanglao
rtanglao / 1-using-csv-new-read-remote-csv.rb
Last active Mar 28, 2021
View 1-using-csv-new-read-remote-csv.rb
def read(url)
CSV.new(URI.open(url), :headers => :first_row).each do |line|
ap line
end
end
@rtanglao
rtanglao / get-ontario-covid19-update.sh
Last active Nov 2, 2020
how to get covid 19 html using curl, jq and the ontario unofficial API that @roryrooster on twitter discovered
View get-ontario-covid19-update.sh
# use sed on WSL and linux instead of gsed
curl "https://api.ontario.ca/api/drupal/page%2Fhow-ontario-is-responding-covid-19?fields=nid,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
@rtanglao
rtanglao / pup-snippet.md
Last active May 15, 2020
View pup-snippet.md 
curl "https://support.mozilla.org/en-US/contributors/kb-overview?product=firefox" | \
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">
@rtanglao
rtanglao / b-chaan.md
Last active Oct 22, 2019
View b-chaan.md

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 / 00-fxing-jdk-for-1.8.md
Last active Oct 15, 2019
building rstudio on arm
View 00-fxing-jdk-for-1.8.md
@rtanglao
rtanglao / windows10arm64-yoga-c630.md
Last active Sep 12, 2019
wsl1-not-working-windows10-arm64-build-18980-lenovo-yoga-c630
View windows10arm64-yoga-c630.md
@rtanglao
rtanglao / keybase.md
Created Mar 1, 2019
View keybase.md

Keybase proof

I hereby claim:

  • I am rtanglao on github.
  • I am rtanglao (https://keybase.io/rtanglao) on keybase.
  • I have a public key ASCzFDnFUGNiGuQlc4_nYFxszM32BJzpjfAoOeLqasb58Qo

To claim this, I am signing this object: