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 / 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 / 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 / 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 / how-to-change-3-trailing-spaces-2-trailing-spaces.sh
Created July 8, 2021 07:13
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 March 28, 2021 05:36
def read(url)
CSV.new(URI.open(url), :headers => :first_row).each do |line|
ap line
end
end