View problem2.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT a.name, ST_Distance(c.geom, a.geom, true) * 0.000621371 AS distance_as_miles | |
FROM geo.cities_ne c | |
CROSS JOIN transport.airports_ne a | |
WHERE c.name = 'Seattle' | |
ORDER BY ST_Distance(c.geom, a.geom, true) ASC | |
LIMIT 1; |
View problem1.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT name, ST_Area(geom, true) * 3.86102e-7 as area_square_miles | |
FROM geo.states_ne | |
WHERE admin='United States of America' | |
ORDER BY ST_Area(geom, true) DESC |
View blahblah.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
say -v Victoria -r 110 'Its so harddd. To say goodbyeee. To yesterday eeee' & | |
sleep 6.2 && say -v Ralph -r 50 'dayyyy' & | |
sleep .7 && say -v fred -r 1 'hardddd' & | |
sleep .6 && say -v Kathy -r 50 'harddddddd' & | |
sleep .5 && say -v Ralph -r 45 'hardddddd' & | |
sleep .8 && say -v Alex -r 50 'hardddddd' & | |
sleep 3 && say -v Victoria -r 50 'byeeee' & | |
sleep 3.1 && say -v Kathy -r 50 'byeeee' & | |
sleep 3.3 && say -v Ralph -r 50 'byeeee' & | |
sleep 3.4 && say -v Alex -r 50 'byeeee' & |
View gist:d6138326884fc84a0caf
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
(Mississippi,0.04510572350527368) | |
(Florida,0.03618771995855893) | |
(Oklahoma,0.02625524553791046) | |
(Texas Tech,0.025387335973875644) | |
(Utah,0.02386222846401559) | |
(Texas,0.022036786026944363) | |
(Oregon State,0.021504590615107053) | |
(Alabama,0.020246765767344792) | |
(Wake Forest,0.020208161774399387) | |
(Virginia Tech,0.01816123098081311) |
View gist:16887e3cae5e20f953f4
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
(Auburn,0.041634392666948954) | |
(Oklahoma,0.02152792418013149) | |
(Wisconsin,0.021470599898437852) | |
(Missouri,0.020336680641426776) | |
(Oregon,0.019774095335338044) | |
(Texas A&M,0.01912296997341011) | |
(Alabama,0.018934941684038607) | |
(Hawaii,0.018587379958978342) | |
(Texas Christian,0.01816383220560018) | |
(Iowa,0.018161368727272965) |
View gist:3d21b02d7e44909e2650
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RESULTS | |
(Ohio State,0.037182229050519294) | |
(Iowa,0.036653244986416554) | |
(Air Force,0.031022404216979858) | |
(Texas Christian,0.02265881489907141) | |
(Wisconsin,0.022231818999934594) | |
(Purdue,0.021753650619968333) | |
(Pittsburgh,0.018589712096517125) | |
(Georgia Tech,0.016042068039864375) | |
(Southern Methodist,0.015804396527202332) |
View gist:7af9215ac6fc7a9efac6
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
void info(Object message) { | |
if(repository.isDisabled(Level.INFO_INT)) | |
return; | |
if(Level.INFO.isGreaterOrEqual(this.getEffectiveLevel())) | |
forcedLog(FQCN, Level.INFO, message, null); | |
} |
View gist:0ee86584d09d75b9082a
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
void info(Object message) { | |
if(repository.isDisabled(Level.INFO_INT)) | |
return; | |
if(Level.INFO.isGreaterOrEqual(this.getEffectiveLevel())) | |
forcedLog(FQCN, Level.INFO, message, null); | |
} |
NewerOlder