Overbey, Strigel, Boyd & Westbrook, PLC is a law firm dedicated to professional excellence and committed to providing personal legal service for our clients. We are proud of our Arkansas heritage and our size: small enough to provide sustained personalized attention and large enough to meet sophisticated tax planning needs. Our achievements are evidenced by the national recognition, appointments, awards, and honors of our attorneys, many of whom are consistently listed in Best Lawyers in America. Our firm is ranked in Best Lawyers "Best Law Firms" in the categories of Employee Benefits (ERISA) Law, Tax Law, and Trusts and Estates Law in the 2015, 2016, 2017, 2018, and 2019 editions.


text:
Post Captain close
NZ's Favourite Online Store
Fiction Books:
Thriller & Adventure
Historical adventure
Post Captain
Explore more by Patrick O'Brian
Men-of-War
Pre-order - out 5 May 2021
MASTER AND COMMANDER [Special edition including bonus book:...
The Yellow Admiral
Patrick O'Brian's Aubrey-Maturin tales are widely acknowledged to be the greatest series of historical novels ever written. Now these evocative stories are being re-issued in paperback by Harper Perennial with stunning new jackets. Post Captain, the second novel in Patrick O'Brian's remarkable Aubrey/Maturin series, led Mary Renault to write: 'Master and Commander raised dangerously high expectations; Post Captain triumphantly surpasses them.' Jack Aubrey arrives home from his exploits in the Mediterranean to find England at peace following the Treaty of Amiens. He and his friend Stephen Maturin, surgeon and secret agent, begin to live the lives of country gentlemen, hunting, entertaining and enjoying more amorous adventures. But their comfortable existence is cut short when, seemingly overnight, Jack is reduced to a pauper with enough debts to keep him in prison for life. He flees to the continent to seek refuge, but instead finds himself a hunted fugitive because Napoleon has ordered the internment of all Englishmen in France. Aubrey's adventures in escaping from France and the debtors' prison will grip the reader as fast as his unequalled actions at sea.
Patrick O'Brian, until his death in 2000, was one of our greatest contemporary novelists. He is the author of the acclaimed 'Aubrey--Maturin' tales and the biographer of Joseph Banks and Picasso. He is the author of many other books including 'Testimonies', and his 'Collected Short Stories'. In 1995 he was the first recipient of the Heywood Hill Prize for a lifetime's contribution to literature. In the same year he was awarded the CBE. In 1997 he received an honorary doctorate of letters from Trinity College, Dublin. He lived for many years in South West France and he died in Dublin in January 2000.
Illustrations, map
HarperPerennial
Fiction >
Thriller & Adventure >

redpajama_set_name: RedPajamaCommonCrawl


jack's mannequin | Press Play.
– A guide to the Wizarding World of Harry Potter. As if I didn't already want to go badly enough?!
– The easiest, yummiest dessert I've seen in a while. Nutella Mug Cake. Om noms.
– Someone is trying to tempt my *healthier* eating habits. Another super easy dessert, cinnamon toast&rolls. What?! Looks delicious!
– The song in the video below. It is so beautiful, the more I listen to it the more I love.
– I love this how-to on building characters for your novel. Will definitely come in handy when I start writing MY book!
– Why it's OK to stay in tonight. Sometimes, Friday nights at home are just the right medicine after a long week!
– Really interesting article on what foods to combine together… I'm down for some tomatoes and avocado! Yum!
– The optical illusion below is such a neat way to show you HOW COOL our eyes are.
That's all I've got for you for this week… There are tons more things that I'd love to link to but I just DON'T HAVE TIME! It's been a busy week and weekend, and now I really have to do some homework.
I thought I'd take the weekend to catch up on some good stuff worth sharing, and after writing the post about books yesterday I thought it would be only fair to give new music it's own day too! Here are a few albums I've been listening to that came out recently, all worth checking out, I think!
It's no secret that this is my favorite band and that I'd been anxiously waiting for this record to come out ever since it was first announced, but that doesn't change the fact that it's quite amazing. I'll admit it might be my least favorite of the Jack's records, but it tells it's very own story like the other two. I'm pretty sure almost no album beats their last one, 'Glass Passenger', but what I love about this one is how upbeat it is. It makes me think of lovely summer days spent reading by the beach.
This album, even though it's brand new, makes me think of high school and growing up, and basically all those things that Blink-182 make most of us think about. It's pretty classic Blink music. I mean, if you like their old stuff you'll love this. The first song on the CD 'Ghost on the Dance Floor' is so far my favorite. It sets the tone for the whole record and makes the entire thing an easy listen.
I'm a bit torn about this album. I've listened to it a few times now, and I have to admit it's growing on me. The first time I heard it I didn't feel like very much stood out about it. I figured I needed to give it a good chance, so I sat myself down and really paid attention to the songs and now I'm a much bigger fan of it. It's not anything SPECIAL, and Lights isn't exactly breaking out of her usual stuff to show fans anything new, but maybe that's a good thing for now.
It's basically impossible to dislike Feist. I mean, her music is so calming, soothing, relaxing. You name it. I'm not usually a huge fan of music like this, but I make an exception for artists like Feist. This album got me in a good study groove this week and I listened to it several times without getting remotely tired of it. Easily something I could put on after a stressful day to just decompose.
Such a catchy album! It kind of had me thinking of Good Charlotte mixed with a little bit more heavy punk, and maybe a touch of pop. I'm in love with the opening track, 'Radiosurgery', which similarly to Blink-182 sets the vibe for the rest of the record which has the same feeling to it. The great about this CD? I didn't feel like I was listening to the same song for 45 minutes.
-Cartel's new EP 'In Stereo', love that band, love the EP! Good alternative/pop music. I've loved this band ever since late high school, they're just constantly awesome. Check them out!
It's no secret that the love of my life comes in the form of a band called Jack's Mannequin, but maybe more specifically a musician in particular called Andrew McMahon. His natural talent has had me swooning over his music (and maybe him, yeah, I know he's married!) ever since I was 14 years old, and I haven't looked back.
So naturally any weekend of mine that includes even just a little bit of him from a distance is considered to be pretty fantastic, thank you very much.
You see, Andrew and his bands (Something Corporate, Jack's Mannequin) did not come to Montreal before July 2008. That was the first time I saw him, and then I saw him again in August 2008 and then again in November 2008. He was obviously making up for lost time.
Last summer, I saw him perform with Something Corporate… A teenage dream of mine come true.
And last night I got to see him perform as Jack's Mannequin again for the first time since November 2008. It was short, and it was the 2nd furthest I've ever been from him while he performed on stage. All I wanted to do was jump over the seats and sing my heart out front row with my best friends. But instead we were all separated in the stadiums' seats.
I always feel like when I see him play live, there isn't enough time for me to soak up his energy, his music, his talent. I am constantly trying to get closer, make my brain take in every little detail of what he does at that piano of his. The way his seat always falls backwards when he gets up for a really intense part, the way he dances around during two or three of the songs and jumps all over the keys.
The show was expensive, it was short, and I got the wrong side to see him play, but it was somehow still just what I needed. I've said this for other bands but I don't think I understood it until I saw Jack's Mannequin live back in July 2008. Every time I see them play, it's like falling in love all over again. I can't stop listening to the music now, even though every song has been drastically overplayed on my iTunes. But I don't care. Love is love, no matter what shape it comes in, right?
I can't wait to get my tattoo to prove it forever. But that's for another post.
Hanging out at dinner, taking weird pictures. That's just what we do.
We were fifth row in a stadium that fits just over 21,000 people. Pretty close, considering! I seriously missed seeing this band.
Hanging out on his piano!
And how was your weekend? Any fun July 1st or July 4th celebrations?!
As if I haven't blogged enough music in the last month and a half, I had to share these videos that I've come across in the last couple days. There is honestly nothing better to me than browsing youtube and discovering amazing videos of favorite artists.
Seriously, Mumford & Sons has to be my favorite break out band of the year. When this kind of music makes it big, it renews my faith in the world. This video is an acoustic version of one of my favorite songs by them, and it just might be better than the real version. Every time I listen to this it practically moves me to tears.
I've loved Fall Out Boy ever since I can remember, and I'm just as supportive of Patrick Stump's (the lead singer of FOB) solo stuff. He recently released this music video for his single, and I just love it. Plus I love this song!!
I just adore Ben Lee. He's so darn cute, and I love his cover of the song Kids by MGMT. It's quite different, but it gives me goosebumps every time I hear it.
Of course, the love of my life (Andrew McMahon/Jack's Mannequin) played at Coachella this weekend and played a new song called My Racing Thoughts that's going to be on the new album. I physically don't know if I can WAIT for the album, I'm already so much in love with this song.
What music are you addicted to these days?
Since the only instruments I can play are the saxophone, the clarinet, the flute, the recorder and other various random high school things, I never learned any GOOD songs (it was always up to my music teacher and obviously in high school you didn't play anything besides classics) so instead of putting a video of twinkle twinkle little star, I thought I might share a song that I've always WISHED I could play… on the piano.
Around 40 seconds in the piano kicks in, and then at the second chorus, well that's basically the reason I wish I could play piano.


Tanzania's President, John Mafuguli is set to inaugurate the Tazara Flyover, 12 days since the overpass was opened for use. According to Dar es Salaam Regional Commissioner, Mr. Paul Makonda, all is set for the official inauguration of the US $45m facility.
"We call on Dar es Salaam residents to be at the Tazara junction on inauguration day, so they can witness the launch of the historic infrastructure project in Tanzania's history," he said.
Last month Prime Minister Kassimu Majaliwa visited the site where he said the current government's plans was to construct seven other flyovers in the city, reiterating the government's commitment in addressing traffic congestion.
The number includes the Ubungo interchange which is being built as part of the World Bank's IDA US $225m loan for the Dar es Salaam Urban Transport Improvement Project.
The road, which is expected to reduce traffic by up to 80% as well as numerous accidents, consists of four lanes and includes a 425 meter bridge. It is also expected to increase productivity thus, boosting the country's economy.
"The construction of Tazara flyover was done with the Dar es Salaam Rapid Transit (Dart) project to Gongo la Mboto from the City Center in mind. The contractor has left enough space that will be used for Dart project which is expected to kick off soon," he added.
Construction of the flyover commenced in October 2016. The project was fully funded by the Government of Japan through its Japan International Cooperation Agency (JICA).


text:
Q: How to return percentage in PostgreSQL? CREATE TEMPORARY TABLE
CREATE TEMP TABLE percentage(
  gid SERIAL,
  zoom smallint NOT NULL,
  x smallint NOT NULL,
  y smallint NOT NULL
);

INSERT DATA
INSERT INTO percentage(zoom, x, y) VALUES
(0,5,20),
(0,5,21), (0,5,21),
(0,5,22), (0,5,22), (0,5,22),
(0,5,23), (0,5,23), (0,5,23), (0,5,23),
(0,5,24), (0,5,24), (0,5,24), (0,5,24), (0,5,24),
(1,5,20),
(1,5,21), (1,5,21),
(1,5,22), (1,5,22), (1,5,22),
(1,5,23), (1,5,23), (1,5,23), (1,5,23),
(1,5,24), (1,5,24), (1,5,24), (1,5,24), (1,5,24);

How many times certain tile shows up (tile is represented by x and y)
SELECT zoom, x, y, count(*) AS amount
FROM percentage
GROUP BY zoom,x,y
ORDER BY zoom, amount;

Result:
 zoom | x | y  | amount
------+---+----+--------
    0 | 5 | 20 |      1
    0 | 5 | 21 |      2
    0 | 5 | 22 |      3
    0 | 5 | 23 |      4
    0 | 5 | 24 |      5
    1 | 5 | 20 |      1
    1 | 5 | 21 |      2
    1 | 5 | 22 |      3
    1 | 5 | 23 |      4
    1 | 5 | 24 |      5
(10 rows)

Question
How to get back percentage of each tile (x and y) for certain zoom, or in other words, how many times have the certain tile showed up for certain zoom?
Wanted result:
 zoom | x | y  | amount | percentage
------+---+----+--------+-----------
    0 | 5 | 20 |      1 |     6.667
    0 | 5 | 21 |      2 |    13.333
    0 | 5 | 22 |      3 |        20
    0 | 5 | 23 |      4 |    26.667
    0 | 5 | 24 |      5 |    33.333
    1 | 5 | 20 |      1 |     6.667
    1 | 5 | 21 |      2 |    13.333
    1 | 5 | 22 |      3 |        20
    1 | 5 | 23 |      4 |    26.667
    1 | 5 | 24 |      5 |    33.333
(10 rows)

*This is just a sample data, percentages are not supposed to be the same, except as a pure coincidence!

A: If am not wrong you are looking for this
SELECT zoom,x,y,
       amount,
       ( amount / Cast(Sum(amount) OVER(partition BY zoom) AS FLOAT) ) * 100 as amt_percentage
FROM   (SELECT zoom,x, y,
               Count(*) AS amount
        FROM   percentage
        GROUP  BY zoom,x,y) a

Or even
SELECT zoom,x,y,
       Count(*) AS amount,
       ( Count(*) / Cast(Sum(Count(*))OVER(partition BY zoom) AS FLOAT) ) * 100 AS amt_percentage
FROM   percentage
GROUP  BY zoom,x,y

Casting the denominator to FLOAT is avoid the Integer division

redpajama_set_name: RedPajamaStackExchange