Skip to content

Instantly share code, notes, and snippets.

@parkercoleman
parkercoleman / problem2.sql
Created Dec 9, 2015
Maptime Seattle Postgis - Problem 2
View problem2.sql
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;
@parkercoleman
parkercoleman / problem1.sql
Last active Dec 9, 2015
Maptime Seattle Postgis - Problem 1
View problem1.sql
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
@parkercoleman
parkercoleman / blahblah.sh
Created Aug 3, 2015
So hard to say goodbye...
View blahblah.sh
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
(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
(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)
@parkercoleman
parkercoleman / gist:3d21b02d7e44909e2650
Created Jul 25, 2015
1958 college football winners according to page rank
View gist:3d21b02d7e44909e2650
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
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
void info(Object message) {
if(repository.isDisabled(Level.INFO_INT))
return;
if(Level.INFO.isGreaterOrEqual(this.getEffectiveLevel()))
forcedLog(FQCN, Level.INFO, message, null);
}