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); | |
} |
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: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: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: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 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 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 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 problem3.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
WITH states_with_railroads AS ( | |
SELECT DISTINCT s.name | |
FROM geo.states_ne s | |
INNER JOIN geo.railroads_ne r ON ST_Intersects(s.geom, r.geom) | |
WHERE admin='United States of America' | |
) | |
SELECT DISTINCT s.name | |
FROM geo.states_ne s |
View problem4.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
WITH county_hurricanes AS ( | |
SELECT DISTINCT c.name AS county_name, s.name AS state_name, h.serial_num | |
FROM geo.counties_cb c | |
INNER JOIN geo.states_ne s ON c.statefp = right(s.fips, 2) --The FIPS codes in the state table have "US" infront of them, the right() function trims that | |
INNER JOIN weather.hurricane_lines_noaa h ON ST_Intersects(c.geom, h.geom) | |
WHERE s.admin = 'United States of America' | |
) | |
SELECT county_name, state_name, COUNT(*) | |
FROM county_hurricanes |
OlderNewer