text:
Keenlinks
Spider-view: "The Spectacular Spider-Kid" (Alien Costume Saga, Part 31) A nice palate cleanser, this single story juggles certain elements neatly while fumbling some characterization
(Strand)om Stories: Iron Man Epic Collection: Stark Wars Review "Stark Wars" presents bombastic action and hints at character depth in this 80s installment in Iron Man's Epic Collection line
Spider-view: "Breakin'!" (Alien Costume Saga, Part 30) A long-running subplot culiminates in fascinating fashion in this celebratory 100th issue of Peter Parker, the Spectacular Spider-Man
Spider-view: "Trade Secret" (Alien Costume Saga, Part 29) This standalone narrative wobbles in places, an interesting concept weighed down by mediocre execution
Spider-view: "Such Sweet Sorrow" (Cloak and Dagger, Part 9) Bill Mantlo presents an engaging, somewhat cliche standalone issue, including proper characterizations of Cloak and Dagger
Spider-view: "Spider on the Spot" (Alien Costume Saga, Part 28) As Milgrom builds towards issue 100, he follows a shaky path in a rather unbalanced penultimate issue
(Strand)om Stories: The Uncanny X-Men Omnibus (Vol. 1) Review Chris Claremont's stunning run on Uncanny X-Men begins strong with this wonderfully entertaining tome
Spider-view: "'Tis Better to Give" (Alien Costume Saga, Part 27) Marvel Team-Up comes to a bittersweet ending with a Spidey/X-Men pairing that successfully builds upon the past
(Strand)om Stories: Man-Wolf: The Complete Collection Review An entire collection focused on John Jameson's alter ego can be wonky at times but is ultimately more satisfying than disappointing
Spider-view: "The Scorpion Takes a Bride" (Alien Costume Saga, Part 26) Stan Lee's brief return to Spidey-dom is a celebratory blend of old and new
The 10 Best LEGO Superhero Minifigures of All Time (10-6)
—by Nathan on December 22, 2014—
So I did a couple of blogs detailing my Top 10 favorite action figures, but I realized that if there's one brand of toy that I enjoy more than action figures, it's LEGO. My history with LEGO is a long and happy one, filled with fun memories of building sets, playing with my sisters, and goofing with them while my dad read books to me at night. But for a while, I stopped getting LEGOs. I played with them still, but didn't collect a whole lot. A LEGO Batman run in 2007 boosted my interest, but it wasn't until 2013 that LEGO started delving more into the DC Justice League and Marvel universes. All of a sudden, awesome characters were opened up to me, and the LEGO bug bit hard.
I've always loved minifigures. I've said it a couple times before, but this is real reason I get LEGO sets. The buildings and vehicles can be cool, but who needs an actual supervillain lair when I concoct one in my head? Who needs to stick to the rules? Minifigs inhabit whatever world or plane of existence I want them to. Being the big comic book geek that I am, it all boils down to "Holy cow, THAT guy's in LEGO! That hero, that villain, that character that I've read about it comics and/or seen on the silver screen is now a plastic figure only a few inches tall!" For a geek, it's awesome. To see how the character is depicted, and to imbue him/her with my own personality and bring that character to life is a cool experience. So here's the first of a two part blog, going through my Top 10 favorite superhero LEGO minifigures.
10: General Zod:
Set: SUPERMAN'S METROPOLIS SHOWDOWN (76002)
Why: LEGO put out a couple of Man of Steel sets in 2013, and I really wanted a Superman. I had Batman, I had Aquaman…I was ready to make a Justice League, but I needed everyone's favorite Kryptonian. However, I prefer Zod a lot more over Superman, mostly because he's a cool DC supervillain. Up until now, I only had Batman villains, so getting a guy who could go toe-to-toe with Superman was neat. Plus, it gave me a character capable of tossing around all the vehicles and trashing the buildings I have. What's also nice about Zod is that he has a dual face, a well-detailed frown on one side and laser vision on the other, so you can see him firing lasers at people and debris. Michael Shannon makes a great Zod, so I enjoy having a figure that embodies his anger and wrath, a villain who wants to completely smash everyone to pieces (which I suppose is a really weak attempt at a LEGO pun).
9: Starlord
Set: STARBLASTER SHOWDOWN (76019)
Why: Starlord is the first member of the Guardians of the Galaxy team that I purchased. The Guardians sets allowed for LEGO to introduce a whole new team—a whole new universe—to their existing Marvel sets. Of the team, Starlord's my favorite, mostly because of his relaxed, obnoxious, and all-around fun nature. However, as a minifigure, he's pretty sweet, too. The character has two main selling points: First, his helmet, a unique piece to the character, which looks pretty awesome, is adapted from the comics, and can be removed to show Starlord's dual face. Like the Iron Man helmet, it could be argued that, proportionally, the helmet's too big, but I think it works, and the look of the thing wipes away all doubt. Second are his weapons, laser blasters that are, again, unique to his character. He carries one in each hand, and they're completely different from other guns. The dude can also fly and comes with some very detailed torso and leg printing. LEGO nailed the movie character, making a fun minifig to lead the Guardians.
8: Magneto
Set: WOLVERINE'S CHOPPER SHOWDOWN (6866)
Why: My first Marvel supervillain on this list, Magneto is a fun figure for multiple reasons. First, of course, is his look. The red suit, the purple cape, the purple gloves…totally comic based. For a geek who enjoys seeing various incarnations of his favorite characters, this guy is perfect. Secondly, the power that the Master of Magnetism possesses makes him fun to have fly around on his metal disk and toss all kinds of metal objects at his foes. He's a powerful supervillain with an equally deadly mission. Thirdly, he's a big bad supervillain, and perfect for the Masters of Evil team I was beginning to dream up, also using my own Doctor Octopus and my sister Abby's Loki. He came with Wolverine and Deadpool, so I already had some guys for him to go up against. Ultimately, it comes down to the fact that he's a perfect representation of a major-league supervillain from the comics. He looks cool, and it's fun to play as him.
7: Spider-Man
Set: SPIDER-MAN: DAILY BUGLE SHOWDOWN (76005)
Why: Spider-Man is a lot higher on this list than he was my action figure list, which may seem strange, given the fact that he's my number one favorite superhero. It's just that there are other minifigures I prefer to use. The figure you see above is actually the newest rendition of the hero; I also have versions from Sam Raimi's Spider-Man and Spider-Man 2, but this one's the best. Taken from the Ultimate Spider-Man cartoon, this version looks less serious than the film minifigures, but that's fine with me. His large eyes are expressive, and he looks more like he came from a comic than the other minifigures do. He also comes with a standard web-line, which the other figures came with, but it's an absolutely integral part to who Spider-Man is. Kinda completes the "spider" part. The movie figures are fun, but the look of the character, again, is more inspired by the comics. Though he is missing some leg printing--which the old incarnations have--it's a small price to pay for a cool figure. But a lot of why I like the character is because I just love Spidey. Being able to have him swing around, dodge enemies, and crack jokes makes me bring his character to life in my own unique way. That's what really makes him great.
6: MODOK
Set: HULK'S LAB SMASH (76018)
Why: What isn't there to love about MODOK, everyone's favorite Mental Organism Designed Only for Killing? I don't think I ever reacted as positively as I did when I saw that MODOK would be coming in a set. He's a dude with a huge head who floats around on a hover chair. That fact alone makes him absolutely wonderful to have. Out of all the supervillains who would get a minifigure, MODOK seems like the least likely as well as the most perfect. Super smart and capable of firing mental blasts from his forehead, MODOK is a constantly cranky, annoying, self-centered Mental Organism. The expression on his face is priceless, super-angry and ready to destroy anyone in his way (fulfilling the "Only for Killing" part of his name). And, like Magneto, he is yet another addition to my Masters of Evil roster, though he's definitely the most unique supervillain out there. What's also cool is that he's been an enemy of both the Hulk and Captain America over the years, so I don't just have him hate one hero like the Mandarin hates Iron Man or Doc Ock hates Spider-Man (however, given the fact I already have a Red Skull as Cap's arch-foe, I use MODOK as more of a Hulk enemy, but it's fun to pit him against either hero). The big head molding is brilliant and unique to really only his character. He's one-of-a-kind, and that makes him pretty cool.
That's the first string of characters. I'll try to have another blog up soon detailing the next five. To be honest, these blogs are difficult to write, mostly because of the fact that I have so many wonderful minifigures to choose from. It's hard to select, but it's interesting as well because it allows me to express just why I enjoy LEGO and what aspects of LEGO I like the most.
—Tags: Entertainment, Lists
© 2021 Keenlinks


The bloom is officially off the rose.
It seems Mrs O gave a not-entirely-thoughtful gift to the family of British PM Gordon Brown. The Brits are taking offense.
You can read about it here. Here's an article from a conservative British publication. Do you think she put too little thought into the gifts for the Browns — or not?
The answer partly depends on what a gift should be. To me the best gift is something that I love because of what it is — but also something that shows me the gift-giver gave real thought to what I would like. The best example I have is the necklace my husband gave me for our 10th anniversary. It's a single imperfect but beautiful South Sea pearl strung on a leather cord — very me. It's one of my favorite pieces of jewelry and the best one I've ever gotten from him. (It's from one of my favorite stores, Tabandeh, in Mazza Gallerie, in Washington, DC.
What's the best gift you ever got, and what makes you love it?


Cheap Holidays > Help > F.A.Q.
How can I contact CheapHolidays.com?
We can be contacted by post, telephone, email or fax. Details are available on our contact page.
When travelling abroad unforeseen accidents and illnesses can occur. We all hope never to be taken ill or injuried abroad, but sometimes it happens. To protect yourself and your partner or family, you can purchase fully comprehensive travel insurance. You may be refused travel if you cannot produce a valid certificate of insurance. Medical treatment outside of the UK can be very expensive. In many countries you will not get treatment unless you pay before treatment or provide a valid insurance certificate, however serious the condition.
Charter flights are more suited to typical holiday resorts found in a Tour Operator's brochure. They are often cheaper than scheduled flights, but not always. Charter flights don't fly to as many destinations as scheduled flights and they often suffer from flight time changes.
Scheduled Flights are suitable for both holidaymakers and business travellers alike. They tend to be more expensive than charter flights, but cover more destinations. They are regularly scheduled flights, so they suffer less from flight time changes, although flight time changes can still occur.
There was a problem with my holiday, what should I do?
Please contact the operator you booked with and register a complaint. We are not in contact with the travel operators customer service departments.
Can I leave feedback about hotels and resorts?
We welcome all feedback. Please use our feedback form to contact us with suggestions or reviews of the destinations, services and products we advertise. The information you provide, whether positive or negative, will be used to improve our service and for the benefit of our website's visitors.
What are Social Bookmarking links?
The Social Bookmarking links on our website allow you to easily share the pages of our website with your friends and family. We can be found on Facebook, Google Plus and Twitter.
Please fill in the feedback form, which is passed directly to the Webmaster.


text:
Food|Drink
Artist in Profile
Film Beat
History Channeled
Know your Neighbor
Astute Observations
East of Normal
East Side Buzz
ESB Online Edition
ESB Print Edition
Matters of Development
HomeMatters of DevelopmentMoD March|April '18
MoD March|April '18
March 8, 2018 Nicole Keiper Matters of Development
The year kicked off with some major changes — longtime restaurant closures and lots of new concepts in the works — plus some really cool projects at historic East Nashville properties.
POP Nashville went and POPped back up: The onetime restaurant incubator-and-more, which closed in late 2016, reopened in February in the same location — 604 Gallatin Ave., #202 — with a slightly different thrust, at least to start.
POP To Go is now up and running there, at press time offering takeout/delivery eats from POP owners Sarah and Brad Gavigan's Otaku Ramen (which is now in The Gulch, but once operated out of POP).
An announcement from the Gavigans said they expect to offer multiple menus there. As the Otaku to-go effort was ramping up at press time, they were serving Wednesdays, Thursdays, and Sundays 5 to 10 p.m., Fridays and Saturdays 5 p.m. to midnight. A release noted that "extended hours and additional menus" would follow shortly.
POP originally opened in that Gallatin Avenue space in 2014, and in its first few years there, it helped spur both Otaku and Little Octopus (which also now has its own space in The Gulch).
To keep up with POP To Go and the "ever changing hospitality group" behind it, visit popnashville.com.
The old East Nashville Walmart spot? It's not empty anymore either.
In February, the newly renovated Space-Max storage facility opened its doors where the Wal once was, offering lots of options for locking down your extra stuff, from lockers to 300-square-foot climate- and humidity-controlled spaces.
That isn't the end of the build project over at 1216 Gallatin Ave. — along with overhauling the Walmart space for Space- Max, a new retail building is nearing completion on the property, too. At press time, Nashville SpaceMax property manager Ray Peng told us that part was likely weeks away from wrapping.
We reached out to Southeast Venture about potential tenants for the 15,000 square feet of Class A retail space, but didn't get a reply. We'll keep digging; look out for updates on our blog at theeastnashvillian.com.
That former Walmart Neighborhood Market closed in early 2016, as part of a nationwide store shuttering, alongside more than 150 other locations.
White we wait for word on that retail hub, the Porter East retail hub has a tasty new tenant: KOKOS Ice Cream opened their KOKOS To-Go Shop in January at 729 Porter Road, offering dairy- and nut-free, vegan artisan ice cream, built on a coconut milk base.
The inspiration came via co-founder Sam Brooker's own dairy intolerance — left with an ice cream-shaped void, his now-KOKOS partner/bandmate Jerusa van Lith encouraged him to try out the already available coconut-based stuff.
"We went to the grocery store to get some," he told us, "and it felt really good to eat ice cream. But it wasn't that great. So we got to talking. . . . "
After months of experimentation, the two landed on a non-dairy formula informed by gelato techniques Amsterdam native van Lith got familiar with in Europe, and hard ice cream techniques we're used to here in the States.
The brand initially launched on the road — Brooker and van Lith kicked things off with a cute, sweet ice cream bike that made its way around Nashville, including lots of East Side spots. After setting the stage and building a fanbase, they moved to their first brick-andmortar, which is still a trimmed-down version of their ultimate plans.
At KOKOS To-Go, folks can grab cups of various rotating KOKOS flavors (some winter ones included Orange Ginger Snap and Vanilla Cherry Bomb), along with chocolate-robed KOKOS pops. Pints on the way, too.
Down the line, Brooker and van Lith are hoping to launch a sit-down Nashville scoop shop, along with a sister location in Amsterdam.
More immediately, though, they're planning to expand flavors and hours at the To-Go shop, and get the bike out four days a week as the weather warms up.
Initial winter hours were 1 to 4 p.m., Friday, Saturday, and Sunday, but check kokosicecream.com — with spring springing, they might already have expanded KOKOS' times.
Now open at 715 Main St.: kitchen/ lounge/curated wine shop Nashville Urban Winery.
They're serving pizza and snacks from the kitchen, and lots of grape-based beverages from the bar, including reds/whites/roses and sparkling wines, along with mixed drinks like house-made sangria. (Beer and craft cocktails are on offer, too.)
Hours are 4 p.m. to midnight Mondays through Wednesdays, 4 p.m. to 1 a.m. Thursdays to Saturdays, 4-10 p.m. Sundays. More at nashvilleurbanwinery.com.
A different kind of kitchen: East Side books/music/art shop Atomic Nashville recently added The Kitchen, a low-key acoustic listening room inside the actual kitchen in their historic building, at 118 S. 11th St.
The thrust is "no microphones, no speakers, no Internet," meant to keep the focus on what's actually happening in the room.
Shows are rolling regularly now (Grammy-winning songwriter, children's book author, and filmmaker Scot Sax is booking them), and you can keep up at facebook.com/thekitchenatatomic.
CrossFit East Nashville celebrated their grand opening in early February at 400 Davidson St., Suite 410, and they're now offering group classes, community workout sessions and open gym hours six days a week, with classes starting as early as 5:30 a.m. and as late as 6:30 p.m.
For schedule/membership info and more, head to crossfiteastnashville.com.
CLOSINGS AND MOVES
A big bummer for East Nashville diners in February: After almost a decade at 1601 Riverside Drive, neighborhood diner Pied Piper Eatery closed its doors.
Owner Becky Piper set the eatery stage in late 2008, creating a fun, family-friendly, music-themed hangout that offer comforting American staples, from big burgers to bacon and eggs and apple pie. After her death to cancer in 2015, Piper's family forged forward with the diner, but as 2018 kicked off, they announced that the time had come to move forward, and on.
"As her family, we have done our best to honor her vision for her creation, but it was her heart that beat for this diner, this work," a closure announcement posted on Facebook said. "We've decided it's truly time to let her rest, and to honor her by following our own creative visions."
The Pipers also launched and run East Nashville ice cream favorite Pied Piper Creamery, and that business will keep scooping at 114 S. 11th St.
Another bummer closure: Gerst Haus, the stalwart German restaurant near the stadium at 301 Woodland St., closed its doors in February.
They'd been dishing up Rindergulasch and Kartoffelpfannkuchen and steaming hot pig knuckles in Nashville since the '50s in various locations, though East Nashville (again, at various addresses) had been home for decades.
DCXV — best known for the selfie-siren "I Believe in Nashville" murals — also closed its East Nashville storefront at the end of January, though owner/designer Adrien Saporiti noted that it's not a shuttering of the T-shirt/ apparel brand, just the brick and mortar at 727 Porter Road.
DCXV continues as an online entity, but Saporiti said in his goodbye message late last year that, "the focus going forward will be on periodic limited releases."
Saporiti rose to Nashville design prominence when the bold but simple "Believe" design hit the scene in 2012, and since, he and his team have worked diligently toward the DCXV goal of sharing art and representing Nashville (he's a native — and the name's "615" in Roman numerals).
"Through DCXV I received an education, a lifetime of experiences, and made friends from all over the world that I will cherish for the rest of my life," Saporiti said. "Thank you to everyone who has supported DCXV (especially those of you who got the logo tattooed . . . I mean, come on!)."
If you'd like to stay up with those limited releases/DCXV projects going forward, keep tabs on dcxvindustries.com.
Also moving to an online-only brand: Steluta, the fashion/gifts/home goods shop launched by Fort Louise owner Jessica Bower at 1601 B Riverside Drive a little over a year ago.
"We are astronomically grateful for the community we have met and grown to love," said an announcement from Bower. ". . . As with all celestial bodies, we look forward to continuing a long life orbiting through these beautiful skies together."
If you loved Bower's taste, keep up with shopsteluta.com, which remains stocked with women's clothing, jewelry and more.
Not closing but ramping down some: longtime 5 Points-area fixture Wonders on Woodland. Late last year, owners Wayne and Debbie Goodwyn announced that the longloved vintage/antiques shop would be moving toward a "seasonal approach," shutting the doors at 1110 Woodland St. for the winter, reopening for a few weeks in the spring and mid-summer, then again around the holidays.
"For some time now we have struggled with balancing our love for our shop with the desire to enjoy some of life's other adventures," their announcement said. ". . . The commitment to present interesting and unique finds in a pleasant setting is one we've taken on with pride and pleasure. However, that commitment leaves time for little else."
If they've been your go-to for furnishings and vintage trinkets, you'll still be able to schedule by-appointment visits, and you may see the shop open on "random days by chance."
Wonders has been open in that spot for nearly 11 years, and even with the maelstrom of change around it, it looks like it'll remain a steadying sight (if one with more frequently locked doors). For the latest, follow them at facebook.com/WondersOnWoodland.
Another non-closure closure that may be a lapsed closure by the time you read this: In early February, restaurant/venue/cafe The Family Wash/Garage Coffee unexpectedly and abruptly closed its doors at 626A Main St.
Repeated word received from owner/operator Mitchell Fox is that the temporary closure would come to an end inside of a month, after some upgrades were finished.
Time being what it is, there's a chance you might be reading this in a fresh new Wash; if not, keep an eye on our blog at theeastnashvillian.com for the latest.
After about two years in East Nashville, Memphis-bred chapeau shop Mister Hats has opted to close its local doors, at 921 Gallatin Ave. (At press time, they were gearing up for an end-of-February end, so by the time this is in your hands, things should be wrapped, barring any unexpected changes.)
Its flagship in Memphis remains, slinging all manner of caps, bowlers, homburgs, pork pies and the like. No word yet on what might take over the East Nashville space.
Furniture/decor/gift shop Rustique also shut its doors early in the year, after more than four years at 700 Fatherland St.
In announcing the shuttering, mother- daughter owner team Erica Howard and Karin Farr noted that, "retail has been great … but we are ready to have our weekends back."
Both have plenty with which to fill those weekends: Howard is running letterpress/ lettering/design business Ruthie & Oliver Letterpress; Farr is running event/wedding venue the Barn on Willis Branch, in Goodlettsville.
Cloud IX, a hookah bar/lounge in business at 3807 Gallatin Pike since 2016, has closed.
The lounge's future seemed uncertain in the wake of two shooting deaths on the premises inside of a year, particularly after news hit that eviction proceedings had begun, with the property's owners citing more than $175,000 in overdue rent.
In February, District 8 Metro Nashville councilmember Nancy VanReece updated us, noting that the club owners had lost a court case related to that claim, and that as a result, the space was to be vacated by Feb. 17.
The business' Facebook page and Instagram feed both appeared to be down, and no updates were available at cloudixnashville.com (the club's online calendar was empty).
For more on the issues at Cloud IX, visit theeastnashvillian.com — our January/ February issue had a primer.
A double-shot for food lovers from the folks behind downtown coffee haunt Slow Hand Coffee: Come spring, owner Nick Guidry told us, he'll have two new East Nashville concepts going under one roof, at 1012 Gallatin Ave.
The first will be familiar: Slow Hand is moving East, but broadening and morphing into Slow Hand Coffee + Bakeshop.
With the "+ Bakeshop," we can expect an even more specialized version of artisan coffee service, with about triple the house-made pastry selection, plus lots of grab-and-go options, like quick-service coffee and wraps, biscuits, and sandwiches.
The second, which'll be settled in the center unit of the building (to the left of Slow Hand): Pelican & Pig, a full-service restaurant with a live wood/ember fire cooking bent, facilitated by an onsite raised-brick grill.
"Live fire will be utilized at its various stages from smoking and grilling meats over embers, to ash roasting vegetables and hearth-baking breads," Guidry told us.
Approaches the neighborhood tends to love — locally sourced, seasonal produce and proteins, and baked goods made in house — are also in the works, along with a "small and specialized" cocktail/beer and wine menu, and desserts, concocted by pastry pro Audra Guidry, that'll lean toward "comforting classics and fun twists on old favorites."
Plans are for dinner six nights a week, plus weekend brunch.
The Guidrys and their team started working on both projects simultaneously; the best place for regular updates (and appetite-whetting food photos): facebook.com/SlowHandCoffee.
A mile up the road in Inglewood, at the old Hop Stop space, new bar concept Walden is taking shape.
Owners Robyn Donnelly and Katie MacLachlan shared details about the new project in late January, noting that they're aiming for "a place that feels as familiar and accessible as a dive bar, while having the service and selection of a high-end spot."
The menu will have a focus on affordability, the partners said, with lots of on-tap beers, wines, and cocktails priced under $10, and a food menu with a mix of shareable options; late-night and brunch will be added later.
The décor will draw from the name, with murals designed and painted by local artist Tarabella Aversa, inspired by Walden Pond plants described by Henry David Thoreau in his famous book.
Key bonus for East Nashville's many dog lovers: A pet-friendly patio with seating is in the planning too.
Walden is expected to open in the spring. For more: waldenbar.com.
Craft beer haunt The Hop Stop closed in November, after four years in that space.
Another East Nashville haunt getting new life: The former Holland House space at 935 W. Eastland Ave. is set to house Lyra, a Middle Eastern restaurant led by onetime Holland House chef Hrant Arakelian.
The Nashville Business Journal dropped that scoop just before the New Year rolled in, noting that Arakelian and his wife, Elizabeth Endicott, were hoping to get Lyra open in late spring.
Holland House closed over the summer after seven years.
By the time these pages hit stands, you may already be able to check out Rolf and Daughters chef Philip Krajeck's new East Nashville place: Folk, a pizza-centric restaurant bar, was due to open in March at 823 Meridian St., according to a report from Eater Nashville.
Krajeck told Eater we should expect "authentic," "wood-fired," "flavorful" food that's "easy for people to digest" at the new location, starting with dinner, then later, brunch. Along with pizza, we should see seafood and house-cured meats, plus a classic cocktails/wine program led by Rolf alum Shane O'Brien.
Expected in March — although at press time the project has been delayed: a new East Nashville location from Urgent Team, a large Southeast urgent/family care center brand.
They're set to open at 3024 Gallatin Pike (the former 615 Ave. space), where you'll be able to walk in for urgent, primary, and wellness care, along with school/sports physicals.
Announced hours: 7 a.m. to 7 p.m. Monday through Friday, 9 a.m. to 5 p.m. on Saturdays, and 1-5 p.m. on Sundays. More at urgentteam.com.
A big addition to the ongoing revitalization of Dickerson Pike on the way: A team of investors that includes Lyon Porter, of Urban Cowboy B&B and Urban Cowboy Public House, has plans to overhaul the historic Key Motel at 1414 Dickerson Pike, turning it into affordable but stylish lodging.
While Porter's other East Nashville lodging space is a high-end, boutique stay, with suites starting at $295 a night, he expects this reinvigorated hotel to offer single and double-bed rooms in the $100 to $150 range, but without sacrificing the style-forward aesthetics that have made Urban Cowboy such a draw.
The space currently has 26 rooms, and when it reopens (ideally around summer, Lyon said), it'll likely be around the same number, depending on how lobby designs shake out.
That said, while the Key is getting turned around in a significant way, Porter was clear that their effort would be far from a teardown/ rebuild.
"We're not changing it," he said, "we're just breathing some life back into a property that's not seen any TLC in a while."
That'll include nods to the building's midcentury beginnings, Porter said, along with "thematic and cinematic" elements, and "a lot of whimsy."
Beyond, a lot's yet to be announced — including whether Porter and his partners (including Elliott Kyle and Talbott Ottinger) will keep the Key name.
But overall, Porter said, "My goal is to make it the most approachably affordable, highly designed hotel in the city."
Another exciting renovation of a historic building: Nashville music scene stalwarts Chark Kinsolving and Jamie Rubin — founders of Mercy Lounge and The Family Wash, respectively — are working on overhauling the long-shuttered Madison Bowl, at 517 Gallatin Pike N. in Madison, and turning it into combination bar/restaurant/bowling alley/venue, kind of in the spirit of New York's throwback-cool Brooklyn Bowl, just with a Nashville edge.
The project was very much in its nascent stages at press time, but the partners did have a well-sketched-out vision.
Once renovations get under way, they'll be working on building out two bar areas (one a quieter lounge, set behind windows/doors), adding a performance stage and freshening up an adjacent dancefloor/dining and games space. Bowling will happen on about two dozen lanes (traditional bowling is likely, though the duo was also exploring other options, like candlepin and duckpin bowling).
Both food and programming will echo a bit of the early Family Wash spirit, with booking focused almost entirely on local musicians, and the bar and kitchen staying simple and honed-down but not run-of-the-mill.
"All that we'll work out later," Rubin told us. "It'll be basic, but like nothing else you can get up in Madison."
And while the renovation will be significant, Kinsolving and Rubin were clear that they're hewing to the property's history, clipping out some of the '80s additions that made the place feel overwhelmingly "Miami Vice," and bringing back as much of the 1960 aesthetic as possible — including refreshing the iconic sign out front.
"The idea is to keep everything pretty simple but comfortable," Rubin said. "A good hang."
Hopes are to get the new Madison Bowl open around August.
An in-the-works addition to the Wabash building at 901 Woodland St.: Sips n Strokes Nashville, a kind of hangout/ art class provider for painters of all ages and experience levels.
The brand is a growing Southeast chain, and this East Nashville location, owner/ manager Emily Krenkel Bussman told us, will bring a similar experience to other Sips n Strokes studios: Creatively inclined patrons can bring their own sips, and work on a pre-planned painting with step-by-step help from instructors.
It's a "fun, laid-back atmosphere," she said, that can offer a low-key night with friends and give budding artists a chance to discover hidden talents.
For news, follow Sips n Strokes Nashville at facebook.com/sipsnstrokesnashville.
Vol. VIII Issue 4
Oh, for the Love of Moloch!
The World According to Margo Price
Of Royalties and a Stiff Upper Lip
March 8, 2018 Tommy Womack East of Normal
Stuck for a topic, I asked my editor, Moloch, what I should write about. "Write about your favorite band," he suggested. That'll work, I thought. … more
Eastside Murals
March 8, 2018 Brittney McKenna Artist in Profile
Cultural influence, one spray can at a time … more
March 8, 2018 Michael DeVault Features
At first, he thinks his ears must be deceiving him, because only a few hours ago, he was roused from bed by armed soldiers, demanding … more
East Side Buzz: Music City Roots and Yazoo Go Mad – Dickerson Road, Check Out Their Pads
East Side Buzz: 3rth of July Party Moves to Bongo Java East Lot, Art and Invention Property Sold, 14th Annual Hot Chicken Festival at East Park, and more
East Side Buzz: 31st Annual Pride Parade and Festival, Poster Ban Enforced, Fieldhouse Jones Boutique Hotel, and more
Seven Non-Lonely Days With Chuck Mead
East Side Buzz: Tomato Art Fest Issue, Edgefield Sports Bar & Grill to Reopen, Radio Cafe Signs Off, Boutique Hotels Coming to East Nashville, Dickerson Corridor Makeover, General Elections, and more
Archives Select Month July 2019 (1) June 2019 (11) May 2019 (20) April 2019 (13) March 2019 (23) February 2019 (12) January 2019 (25) November 2018 (19) September 2018 (25) July 2018 (15) May 2018 (13) March 2018 (14) January 2018 (15) November 2017 (15) September 2017 (33) July 2017 (17) May 2017 (14) March 2017 (15) November 2016 (10) September 2016 (23) July 2016 (17) May 2016 (13) March 2016 (19) January 2016 (17) November 2015 (17) September 2015 (29) July 2015 (17) May 2015 (19) March 2015 (11) January 2015 (18) November 2014 (19) September 2014 (28) July 2014 (16) May 2014 (16) March 2014 (13) January 2014 (15) November 2013 (13) September 2013 (10) July 2013 (8) May 2013 (1) March 2013 (1) January 2013 (1) November 2012 (1) September 2012 (1) July 2012 (1) May 2012 (1) March 2012 (1) January 2012 (1) November 2011 (1) September 2011 (1) July 2011 (1) May 2011 (1) March 2011 (1) January 2011 (1) October 2010 (1) August 2010 (1)
We are a bi-monthly magazine dedicated to the uniqueness of East Nashville & Inglewood with a focus on events, charities, businesses and people in the local area. Written by East Nashvillians, for East Nashvillians! Read more . . .
For advertising inquiries, please contact Lisa:
sales@theeastnashvillian.com
For questions or comments about editorial content:
editor@theeastnashvillian.com
Have East Nashville news tips? Please contact Liz:
liz@theeastnashvillian.com
If you would like to submit an event for the print edition of our calendar, please contact Emma:
calendar@theeastnashvillian.com
Copyright © 2019 The East Nashvillian

redpajama_set_name: RedPajamaCommonCrawl


text:
Conditions favourable for monsoon to advance into M.P., U.P.
The low-pressure area over West Bengal has started interacting with the western disturbance to bring monsoon rains over the hills in North-West India and parts of adjoining plains.
The India Met Department said that rain has occurred at most places over Himachal Pradesh and Uttarakhand in North-West India and Bihar, Jharkhand, West Bengal and Sikkim in East India.
Northern limit
But the northern limit of monsoon failed to make further progress after it broke the 15-day jinx to get a peep into parts of the North-West.
Conditions are favourable for its advance into some more parts of Madhya Pradesh, remaining parts of Uttar Pradesh, Haryana (including Delhi), Punjab and some parts of north Rajasthan during the next two days.
Many places over Jammu and Kashmir, east Uttar Pradesh, Assam, Meghalaya, Odisha, Konkan, Goa, and coastal Karnataka received heavy overnight rainfall on Wednesday.
But the rain was confined to few places over west Uttar Pradesh, Nagaland, Manipur, Mizoram, Tripura, Tamil Nadu and Lakshadweep.
Pacific churn
Isolated places over Haryana, Delhi, east Madhya Pradesh, Gujarat, coastal Andhra Pradesh and north interior Karnataka witnessed passing showers.
Global models suggested that the 'low' over East India may continue to be active until the weekend before weakening over Odisha.
This is also the time around when the ground will have been prepared for the initiation of a cyclone/typhoon in the north-west Pacific, east of the Philippines. These models hinted that a preparatory low-pressure area may take shape by the weekend. It would go on to become a strong typhoon in the East China Sea. The system would concurrently become the prominent feature in the entire Asian monsoon system and would start pulling in flows from the Arabian Sea.
These flows would be dragged into place over the West Coast first, before residual flows are hauled over peninsula, south Bay of Bengal, and onward into South China Sea/north-west Pacific.
Heavy to very heavy rain is likely over the West Coast right from Konkan-Mumbai down to north Kerala during the next week, according to a US Climate Prediction Centre.
Labels: Commodities = Agricultural
Anju Shukla September 6, 2018 at 4:38 PM
#Rupee at record low of 72/$ Free Commodity tips


text:
Jose Holguin-Veras
William H. Hart Chair Professor
holguj2@rpi.edu
http://transp.rpi.edu/~jhvweb/index.shtml
Dr. José Holguín-Veras is the William H. Hart Professor, and Director of the Center for Infrastructure, Transportation, and the Environment; and the Volvo Research and Educational Foundations (VREF) Center of Excellence on Sustainable Urban Freight Systems at the Rensselaer Polytechnic Institute. He received his B.Sc. in Civil Engineering, Magna Cum Laude, from the Universidad Autónoma de Santo Domingo, Dominican Republic, in 1981; his M.Sc. from the Universidad Central de Venezuela in 1984; and his Ph.D. from The University of Texas at Austin in 1996. He has been a faculty at California Polytechnic State University at San Luis Obispo, City College of New York (1997-2002), and Rensselaer Polytechnic Institute (2002-present). His work has received numerous awards, including the 2013 White House Champion of Change Award for his contributions to freight transportation and disaster response. His research emphasizes the integration, synthesis, and projection of the knowledge that exist in multiple disciplines to produce solutions to the complex and multifaceted problems—which have proven to be too complex to be solved by single-disciplinary approaches—that impact freight transportation and humanitarian logistics. His research taps into the knowledge of social sciences to build more realistic mathematical models of humanitarian logistics, and integrate cutting edge economic principles into freight transportation modeling, so that a complete picture could be developed on the broader impacts of transportation activity on the economy and the environment; and on the most effective ways to conduct post-disaster humanitarian logistics. His research blends field research and measurements, applied and basic research to ensure that theory relates to reality; and, ultimately, to a set of actionable policy recommendations that contribute to the betterment of the economy and society. Current research activities focus on three major areas: freight transportation demand modeling, sustainable freight policy, and humanitarian logistics. His work on freight demand modeling focuses on enhancing the realism of spatial price equilibrium (SPE) models, and development of simplified modeling techniques. His work on sustainable freight policy studies the interactions between the agents (e.g., shippers, carriers, receivers) involved in freight activity, to define ways to exploit these interactions to foster sustainable development and operations. An important third area, of profound human impact, focuses on the development of novel forms of humanitarian logistics. His research group has pioneered the multidisciplinary study of post-disaster humanitarian logistic operations. His research has: identified the key lessons learned from the response to the largest disasters of recent times; translated these lessons into actionable policy recommendations; and shared these suggestions with disaster response agencies. As part of the field work, his research group has conducted detailed analyses of the most prominent disasters of recent times, including: Hurricane Katrina, the Port-au-Prince earthquake, the tornadoes in Joplin and Alabama, Hurricane Irene, and the Tohoku disasters in Japan. His contributions to the solution of regional and national problems are numerous as they span modeling, policy, and research. In particular, his ability to transition research into practice—navigating complex implementation environments—has been recognized with appointments to prestigious positions. As a member of the Board of the New York State Thruway Authority—as the only researcher and Hispanic American in the board's history—he helps oversee toll policy and the replacement of the $4 billion Tappan Zee Bridge, one of the largest construction projects in the US. He is overseeing all-electronic-toll-collection, toll setting, financing, asset management, and helps the agency reach a higher level of efficiency. His policy contributions also cover disaster response; as a member of the National Academy of Sciences' Disaster Research Roundtable, he advises the federal government in disaster response on the basis of his field research after large disasters and catastrophic events. He has been member of numerous panels for the National Academy of Sciences' Transportation Research Board, the Federal Emergency Management Agency, and other agencies. His research, routinely implemented by practitioners, has been impactful. His work on freight generation and freight trip generation has led to the development of freight trip generation models—to be incorporated in the next edition of the ITE Trip Generation Manual—that are more accurate than any currently available. Equally transformative has been his research on freight tour models, freight origin-destination estimation, and others that are being incorporated into transportation modeling packages such as TRANSCAD, TRANUS, among others. One of his most visible contributions is the NYC off-hour-delivery project, which is having a transformative effect on urban freight policy. This project has blossomed into a potent freight demand management tool that has won the enthusiastic support of the private sector. It is estimated to lead to economic savings of 100-200/million dollars per year, and reductions of: 202.7 metric tons (t)/year of CO, 40t/year of HC, 11.8t/year of NOx, and 69.9 kg/year of PM10). Recognizing these significant impacts, the City of New York adopted OHD as part of its sustainability plan, and the Federal Highway Administration created a program to foster OHD, based on the one pioneered in NYC, and to replicate it in other US cities. Because of its impacts, TIME magazine identified off-hour deliveries as one of the "10 Ideas that Make a Difference" in traffic congestion. His leadership positions include: President of the Scientific Committee of the Pan-American Conferences of Traffic and Transportation Engineering, member of the Scientific Committee of the World Conference of Transport Research, Elected Member of the Council for the Association for European Transport, member of the International Organizing Committee of the City Logistics Conferences, member of technical committees at numerous professional organizations, and member of the editorial boards of the leading journals. He has led dozens of technical sessions, and has participated in numerous technical committees at the Transportation Research Board (e.g., Intermodal Freight, Urban Freight, Freight Economics, Freight Planning and Logistics, Road Pricing, Task Force of Freight Demand Modeling), European Transport Conference, World Conference of Transport Research, Pan-American Conference of Transport and Traffic Engineering, and others. He is a member of a number of high level public sector committees and boards. His current appointments include: United States Department of Transportation's National Freight Advisory Committee (2013-2015), Board of the New York State Thruway Authority (2010-present), National Academy of Sciences' Disaster Research Roundtable, National Academy of Sciences' Committee for Review of USDOT Truck Size and Weight Study (2013-2014), Federal Emergency Management Agency's Core Group on Community Engagement (June 2011-present), Advisory Panel for the NY-NJ-CT-PA Regional Catastrophic Planning Group (March 2010-2013), and Advisory Panel of the Mohawk Corridor Multimodal Transportation Study (2010-2012). The list of awards he has received includes: the 2013 White House Champion of Change Award, CAREER Award from the National Science Foundation (2001-2006); the Milton Pikarsky Memorial Award in 1996, from the Council on University Transportation Centers, the Salute to the Scholars Award from the City University of New York (in 2000 and 2001); the 2006 Robert E. Kerker Research Award in recognition of Excellence in Research of Special Importance to Practitioners and Scholars of Public Administration and Policy in New York State; the 2007 School of Engineering Research Award; and a Proclamation from the Council of the City of New York (2001). He is a fellow of: State Academy of Public Administration (2006), International Road Federation (1991), Japanese International Cooperation Agency (1989), and the Organization of American States (1982-1984). According to Google Scholar, he is the most widely published and cited freight researcher in the world. He has more than 150 technical publications in the most prestigious venues, and, reflecting his influence, his work has been cited more than 1,300 times by his peers. He has given 15 plenaries, 40 invited lectures, and hundreds of presentations in professional conferences. As a Principal Investigator (PI), he has managed about $13.4 million in competitively awarded contracts from the most prestigious funding agencies: USDOT ($8.2 million), NSF ($3.9 million), New York and New Jersey State Departments of Transportation ($1.3 million), among others. These projects have focused on freight research ($8.4 million), disaster research ($2.8 million), road pricing ($1.2 million), and others ($1.0 million). As a Co-PI, he has worked on about $10 million in projects. He has extensive professional experience in both developing and developed countries. His professional experience includes the analysis of the intermodal alternatives for the trans-isthmian corridor that runs parallel to the Panama Canal, and the development of numerous national and regional transportation plans in Venezuela, Dominican Republic, Guatemala, and other countries. He has been consultant in transportation planning, modeling, and economics for international companies and financial institutions, such as The World Bank, United Nations, Inter-American Development Bank, among many others.
Ph.D., University of Texas at Austin Transportation M.S., Universidad Central de Venezuala Transportation B.S., Universidad Autonoma de Santo Domingo Civil Engineering
Decision Support Systems, Operations Research, Transportation


Having successfully supported the hiring process for Tom and the Distinctly team over the years, we're delighted to have watched the business flourish into the award-winning agency it is today.
Tom founded Distinctly in 2009 with a clear belief that the substantial shift in marketing from existing traditional spend to digital spend was a trend that would continue for the long term… and how right he was!
Writing this article made me appreciate just how many tools I rely on, on a daily basis. The best of which I've used for years, but at any one time there is something that I am testing/trialling to ensure my current toolset can't be bettered!
We recently moved from Office 365 to GSuite and haven't looked back. I love the simplicity of it and its collaborative nature which makes it so easy for the teams here to work together, simultaneously. Never having to worry about deleting a doc or whether you have edited the most updated version makes life considerably less stressful.
Whilst on the subject of Google, I couldn't live without Google Analytics. Whilst it's one of the more basic tools, we use it to track and report on the success of almost all the campaigns we run. Despite its widespread use, most clients only scratch the service with what it can do.
I'm not sure if this is technically a 'tool', but WordPress is a fantastic product and one that we all use on a daily basis – whether it be on our own sites or client sites. I love the community that surrounds WordPress, constantly making it better for all those that use it.
Sistrix is really useful for quickly gauging the health of a website as well as possible algorithm updates that may be affecting this (for better or worse!). It is one of the first tools that I'll fire up when we start talking to a potential new client.
Assessing the quality of a website's link profile is as important as ever. I use two – Ahrefs and Majestic – although I'm more comfortable with the metrics within Majestic. I'm using Ahrefs more and more for keyword research and a range of other small tasks – it's the most improved tool over the last 12 months.
We've recently started working with SharpSpring on both client activity and our own marketing and I absolutely love it. So much functionality; the beauty of it is that it makes all of the campaigns we run so much more effective.
Moving away from SEO, FreeAgent and Appogee HR are cloud software that takes away some of the hassle from more mundane, but also important, tasks involved in running a business allowing me to spend more time doing what I enjoy.
Screencast by TechSmith is something I use all day every day to share annotated captions that help explain a point I'm trying to get across. If an image is worth a thousand words, this must be saving me a huge amount of writing time!
Thank you, Tom, for sharing your Top 10 tools and for offering a bit of insight into which tools you find useful for running a business.


Casting a whitespace trimmed string to a decimal loses all precision after the decimal point.
But, combining the two don't work.
I would expect the queries above to return 20.06 instead.
Since you can cast properly without trimming this is a minor issue, but it's still unexpected behavior.
Noted in 5.0.21, 5.1.10 changelogs.


I just linked to your other request-answer, seams to be important to know your router2.
Was reading, that other persons had proplems with Microtik 2. And the other answer was with a other firmware.
Did someone of you Microtik users already do a systematic check of possibilities?
I mean, create a virtual wifi network beside the existing, just let access mac addresses from omega (to make it more secure, if you stop publish the address on pics & logs).
Then test without encryption & pw and go up all the steps ... maybe somehow you will be able to connect, just not found the right protocol/encryption settings jet?!
I have similar problems. I am suspecting that this might have something to do with the WPA2 key. Would you mind telling me, how long your key is, and if it does contain any special characters, or only digits and letters?
I've also had no end of complications getting my wireless to work.
Connecting to my mobile (Nexus 6P) works perfectly with a password, but my Mikrotik (CRS125 + 2011) units just don't play ball.
I've tried turning the security on for every protocol and nothing seems to help.
I can access the unit itself on it's own AP address which allows SSH access and then I've changed settings, including setting the country code, setting AES, etc.
I haven't tried allowing purely MAC only with no password yet, will try that when I get home and see how it goes.


Yes, she is generally not afraid and also stubborn or very insisting if she want something. As heavy as it is for us, i think it will help her in life. And sometimes it is heavy for us: at the moment e.g. she has a new favorite game: she wants to be wrapped in a blanket and carried and swirled around in the apartment. The poor person who has to do that is me. She LOVES is…absolutely loves it. We have to play it non-stop. And since it is physically demanding, i am not too happy about playing endlessly. I am already hiding this blanket when i come home, but she tries to find it everywhere. She even learned the German word "Decke" extra for that. And would cry bitterly when not found….well in the end usually we play endlessly. Yes, i think it will help her in life, this stubbornness, so I accept.


Set your business on a path for success with the DBS Entrepreneur's Account for Start-Ups. This customised package is designed specifically for start-ups to provide affordable and convenient banking services that help you grow. You will also receive a wide range of value-added benefits including fee waivers and complimentary add-ons.
New! 1-Day Express account opening* for Single Director Companies or Sole Proprietors with DBS/POSB personal account - no signature or documents needed!
Lower rates on Accounting, Mobile plans and HR solutions. Plus waiver of one-time setup fee (worth up to S$800) for credit card acceptance service.
This service is currently only applicable to Singapore registered Sole Proprietorships owned by an individual or Singapore incorporated companies with one director who is also the only shareholder and authorised signatory. This individual must be a Singapore citizen or Singapore permanent resident and have an existing active DBS/POSB personal bank account.
The details of the company must be retrieved from ACRA on step 2 of the application.
Accounts will be opened the next working day (Monday to Friday, excluding public holidays) for applications submitted before 2pm on a working day.
Applications made through this service are subject to approval by DBS.
DBS offers one of the most value-for-money business accounts with total fees as low as SGD 40 per year! Find out how we stack up against other business accounts in Singapore. Read more here.
For social enterprises, please call DBS BusinessCare at 1800 222 2200 to make an appointment with our branches.
1. I am unable to find my company on the '2. ACRA Details' step in the online application form. Why?
Try keying in your company name without 'Pte Ltd', etc. and you should be able to locate your company. Please note that if the company is newly registered, it will take 2 working days before your company details can be retrieved.
2. What documents am I required to submit and when do I need to submit them?
No documents are needed for applicants who meet our 1-Day Express account opening criteria.
3. How do I switch from my existing bank to DBS?
You may also contact our cash management specialist at gtssales@dbs.com for assistance.
4. What currencies are available for the DBS Educator's Account?
We offer the DBS Educator's Account in SGD only. However, we also offer SGD plus up to 12 other foreign currencies in the DBS Corporate Multi-Currency Account. Please click here for more details.
Because with Asia's leading SME bank, that spark in you can take on whatever you choose. That same spark to excel drives us to deliver better insights, innovation and performance. It made us the best SME bank in Asia, so that you can live more, bank less.
How to choose the best SME account?
The Vulcan Post breaks it down for you – read their analysis of top SME banks to make sure you're getting the most value for money.


text:
NewsEnvironment
Worm moon set to delight skygazers
The second supermoon of the year is set to light up the night sky and delight skygazers on Monday evening.
Updated Sunday, 8th March 2020, 7:52 am
A super worm moon, occurring on the same day as the equinox, is seen through passing clouds in March 2019 (Picture:SAUL LOEB/AFP via Getty Images)
Known as the "worm moon", the celestial event is expected to be visible from 5.35pm after sunset as the moon rises in the east.
Royal Observatory astronomer Emily Drabek-Maunder said: "The March full moon is known as the worm moon, named after earthworms that emerge towards the beginning of spring as the ground thaws.
"Traditionally, monthly full moons are named from Native American tradition, but many also have Anglo-Saxon and Germanic origins.
"From those different origins, the March full moon has also been called the chaste moon, death moon, crust moon and even the sap moon after sap flowing from sugar maple trees."
This full moon will also be a supermoon, meaning it will appear about 14% bigger and 30% brighter in the sky as it reaches its closest point to Earth.
Ms Drabek-Maunder told PA: "It will be slightly bigger in the sky, though this will not be easily noticeable by eye."
The moon will set in the west at sunrise on Tuesday morning around 7.13am, Ms Drabek-Maunder said.
The first supermoon event of 2020 occurred last month and the next one will take place on April 8.


text:
The Southside of Richmond is an area of the Metropolitan Statistical Area surrounding Richmond, Virginia. It generally includes all portions of the City of Richmond that lie south of the James River, and includes all of the former city of Manchester. Depending on context, the term "Southside of Richmond" can include some northern areas of adjacent Chesterfield County, Virginia in the Richmond-Petersburg region. With minor exceptions near Bon Air, VA, the Chippenham Parkway forms the border between Chesterfield County and the City of Richmond portions of Southside, with some news agencies using the term "South Richmond" to refer to the locations in Southside located in the city proper.

Definition
Since there is no one municipal organization that represents this specific region, the boundaries are loosely defined as being south of the James River and west of Interstate 95 (formerly Richmond-Petersburg Turnpike) with a southern border extending approximately to Chester, Virginia and extending west along Virginia State Route 288 beltway. Some portions of the Southside of Richmond closest to the downtown area north of the river are also considered part of Downtown Richmond.

North Chesterfield

Several ZIP codes on the Southside have a preferred place name of "Richmond Virginia" even though in some cases that land falls under the completely separate municipal authority of Chesterfield County. For example, the 23235 ZIP code (Bon Air) straddles the city-county boundary.

In 2011, the U.S. Postal Service approved Chesterfield County's request to refer to ZIP codes 23224, 23225, 23234, 23235, 23236 and 23237 as "North Chesterfield, VA," when they are in Chesterfield county, even though the Post Office's preferred place name for the entire ZIP code remains as "Richmond Virginia." The rationale for this change was that some Chesterfield County residents were confused, and paying taxes to the City of Richmond given their street address included a Richmond ZIP code.

Chesterfield residents in the 23235 ZIP code continue to have the option of using "Bon Air" as their preferred place name, although they can also use "North Chesterfield 23235" or "Richmond, Virginia 23235."

History

Early settlements along the river
A primary feature defining the Southside of Richmond is the James River and the limited means to cross it to get to other parts of metro Richmond. The oldest bridge across the James River in Richmond was Mayo Bridge (1788). Before that, commerce was limited to individual enterprises passing their goods in boats, bateau, and ferries over the James River as well as to fixed port areas with tobacco inspection warehouses established north of the river at Shockoe's and south of the river at Warwick.

1600s: Conflicts between English settlements and Native tribes
When the English arrived, there were two main groups of natives occupying Central Virginia, separated by the Fall Line of the James: (1) the Manakins controlled the southern Virginia Piedmont west of the fall line  from Richmond to the Blue Ridge Mountains; and (2) the Powhatan Confederacy (led by leader named Wahunsonacock) who controlled land in the Richmond area below the Fall Line towards the Virginia Tidewater region.

The earliest European settlement in the Central Virginia area was in 1611 at Henricus, where the Falling Creek empties into the James River. In 1619, early Virginia Company settlers struggling to establish viable moneymaking industries established the Falling Creek Ironworks. Between 1622 and 1646, a series of generational Anglo-Powhatan Wars resulted in the death of Opchanacanough and the established boundaries on the Powhatan Confederacy. After Bacon's Rebellionin 1676, Cockacoeske signed the Treaty of 1677, and several central Virginia tribes accepted their de facto position as subjects of the British Crown, and gave up their remaining claims to their ancestral land, in return for protection from the remaining hostile tribes and a guarantee of a limited amount of reserved land. The Powhatan Confederacy effectively ended. By 1699, the Manakins/Monacans had abandoned their settlements, and English freely settled land claims in the entire Richmond area. In part to serve as a buffer, the English allotted a large portion of land for French Huguenot refugees to settle in the old Manakin village on the south side of the James River.

1700s: Warwick and River Commerce
After completing prominent construction jobs at the state capitol in Williamsburg, Henry Cary built Ampthill plantation in 1730 near Warwick. From 1750 to 1781, his son Archibald operated Falling Creek Ironworks at Warwick. Owing to port traffic, Warwick Road became a major thoroughfare through Southside for the next two centuries, especially as it enabled passage around the falls at the James.

On the part of the James River west of the Fall Line, the descendants of the 1700 Huguenot refugee settlement in Manakintown began to intermingle with the English and settle across Powhatan and western Chesterfield county. They established family coal mining enterprises such as Black Heath. One of these Huguenot descendants, Abraham Salle, built Salisbury Plantation and, in 1777, sold it to the Randoph Family who lived across the river at Tuckahoe and used Salisbury as a hunting grounds. Patrick Henry rented Salisbury and lived there with his family during his second term as governor in 1786.

Early 1800s: The Rise of Manchester and Rail Lines to the Coal Mines

After the port of Warwick was destroyed by Benedict Arnold in the Revolutionary War, Warwick Road continued in use, but the port of Manchester took over Warwick's role as a major port. Further, water navigation to estates above the falls of the James River was enabled by the 1790 opening of the James River and Kanawha Canal that stretched from Richmond, Virginia to Westham, Virginia on the north side of the river and paralleling the James for .

In 1804, Virginia built the precursor to the Midlothian Turnpike from the port of Manchester headed westward to the mouth of the Falling Creek to access the coal mines at Midlothian. This enabled industrial sites such as the Black Heath coal mines and Bellona Arsenal to ship goods down the James river without having to go through Warwick.

Rail enabled the rapid export of coal from the coal mines in western Chesterfield County.  The Clover Hill Railroad Company was chartered in 1841 by the Virginia General Assembly, enabling the Clover Hill Railroad to open in 1845 between Chester and the Clover Hill Pits near Winterpock.

Late 1800s: Development along the rail lines

During the Civil War, the Confederacy was generally able to keep the Union troops west of the Richmond and Petersburg Railroad, with the main exception being the Bermuda Hundred Campaign. Until the end of the war,  Drewry's Bluff prevented the Union army from accessing Richmond over water.

While the Clover Hill Railroad went bankrupt in 1877, it was reconstituted in 1881 as the Brighthope Railway and operated until World War I when it was disassembled and sent to France for the World War I effort.

The city of Manchester rose to prominence through its 1831 Chesterfield Railroad and its 1853 successor the Richmond and Danville Railroad.

Suburban rail stations along the R&D led to development in Granite, Virginia (a mining quarry whose post office opened in 1872), Bon Air (the resort colony established 1877), Robious and Midlothian. These stops became industrial and residential centers in otherwise rural areas that often moved people and goods through Manchester and Richmond.

Manchester also benefited from being a station along the North-South Richmond and Petersburg Railroad. Manchester briefly served as the seat of Chesterfield County after the Civil War, from 1870 to 1876. In 1874, Manchester voted to become an independent City. In 1876, the Chesterfield County seat was moved to Chesterfield Courthouse.

1900s: Development and Annexation in the Automobile Era

1910 Annexation of Manchester
From its founding in 1750s to the late 19th century, Chesterfield County had been the municipal authority for all of what is today considered Southside. Manchester became an independent city in 1876 and then in 1910, Manchester agreed to be annexed by the City of Richmond. During annexation negotiation, Manchester demanded the condition that a free bridge be built to allow Manchesterians access to Richmond. This became known as the Manchester Bridge. Soon, as the automobile era began, other bridges were built to include Westham Bridge (1911), the Nickel Bridge (1925—a toll bridge) and the Lee Bridge (1933—also a toll bridge).

Automobile-based Development and 1942 Annexation of Jeff Davis Corridor

In 1922, Chesterfield annexed the Henricus site from Henrico County.

In 1927, after a decade of road improvements, the Jefferson Davis Highway officially opened as a major automobile thoroughfare

These auto corridors attracted development. The DuPont Spruance plant opened in 1929 along the Jefferson Davis Highway and manufactured rayon, Cordura , and cellophane on the former site of the Ampthill Plantation.

Inter-state traffic along Jefferson Davis Highway and its James River toll bridge led to Belt Boulevard by 1933 that bypassed downtown and directed some traffic to the Nickel Bridge. This easier automobile access spurred development in Southside. By 1940, a Works Projects Administration guide to Virginia announced "South of Richmond U.S. 1 is lined with tourist cabins, garages, and lunchrooms swathed in neon lights that at night convert the road as far as Petersburg into a glittering midway."

During annexations in 1914 and 1942, Richmond appropriated more and more land from Chesterfield County to include Westover Hills and Forest Hill to the west, and The Port of Richmond (Built 1940) to the south.

Postwar growth: Bellwood, Southside Plaza, I-95 and Chippenham Pkwy
After WWII, Southside experienced a decade of massive growth. A large military supply center had been built for WWII in 1942 on the Bellwood property. The Bellwood Drive-In opened outside the city limits along the Jeff Davis corridor in 1948 and billed itself as the "largest and finest" drive-in theater in the South.

The Southside Plaza opened up in 1957-58 outside the city limits on Belt Boulevard in what was then Chesterfield County.

In 1958, after three years of construction, the limited access Richmond–Petersburg Turnpike tollway opened between Richmond and Petersburg.
The Chippenham Parkway was built in 1967 and connected much of Southside from the Midlothian Turnpike to the Defense Supply Center, Richmond.

Prior to the construction of I-95, the Route 1/Jefferson Davis Highway corridor was the county's main thoroughfare. I-95 and Chippenham Pkwy siphoned traffic off both the Jeff Davis Corridor and the Belt Boulevard.

1970 Annexation of Midlo Tpke out to Chippenham Pkwy
During another annexation in 1970, Richmond took an additional 23 square miles from Chesterfield County all the way out to the Chippenham Parkway. The racial motivations behind this expansion led to a Supreme Court case City of Richmond v. United States and a moratorium on further annexations. As a part of the negotiations over the precise annexation, much of Bon Air to the west and the Ampthill property to the south (owned by DuPont) remained in Chesterfield County.

Powhite Parkway and Powhite Parkway Extension to outer beltway (288)
{ "type": "FeatureCollection", "features":  [
 { "type": "Feature",
      "properties": {"title": "Southside Plaza (1958)", "marker-symbol": "-letter-see"},
      "geometry": {"type": "Point", "coordinates": [-77.47655153274536, 37.50216800393298]}
    },
 { "type": "Feature",
      "properties": {"title": "Cloverleaf Mall (1972)", "marker-symbol": "-letter-see"},
      "geometry": {"type": "Point", "coordinates": [-77.52811431884766, 37.49896760729101]}
    },
 { "type": "Feature",
      "properties": {"title": "Chesterfield Mall (1978)", "marker-symbol": "-letter-see"},
      "geometry": {"type": "Point", "coordinates": [-77.60866641998291, 37.507853476646744]}
    },
 { "type": "Feature",
      "properties": {"title": "Stony Point Fashion Park (2003)", "marker-symbol": "-letter-see"},
      "geometry": {"type": "Point", "coordinates": [-77.56935596466064, 37.5499873691089]}
    },
 { "type": "Feature",
      "properties": {"title": "Brandermill(1977)", "marker-symbol": "-letter-see"},
      "geometry": {"type": "Point", "coordinates": [-77.65548706054686, 37.45714557062557]}
    },
 { "type": "Feature",
      "properties": {"title": "SR-288 bridge (2004)", "marker-symbol": "-letter-see"},
      "geometry": {"type": "Point", "coordinates": [-77.6846694946289, 37.57750788488201]}
    },
 {  "type": "Feature",
      "properties": {"title": "Powhite Parkway extension (1988)" },
      "geometry": { "type": "LineString",
        "coordinates": [   [-77.52777099609375, 37.52606450059144],
          [-77.56210327148436, 37.49447320172351],
          [-77.59265899658202, 37.46477609130588],
          [-77.63729095458984, 37.46096092829945]          ]}
      }
]}

The Powhite Parkway opened in 1973, connecting downtown to the Chippenham Parkway. With newfound highway access, the Southside suburban population continued to explode. New shopping malls were built outside the city limits (Cloverleaf Mall in 1972 and Chesterfield Mall in 1978) as well as Brandermill residential development in 1977 along the Swift Creek Reservoir. Plans were drawn up to create a Powhite Parkway Extension that would extend the road from Chippenham out to Virginia State Route 288, which was completed in 1988. In 1973, Philip Morris USA opened a cigarette manufacturing plant along I-95 at Commerce Road. The McGuire VA Hospital opened in 1983.

1988-2004: New bridges connect West End and Southside
Before 1988, the main way to get from the Southside to the West End was via the Huguenot Bridge or by crossing the James River inside the Richmond city limits. This led to a minor rivalry in the 1980s where the West End had a bumper sticker that said "West End -- For Members Only" and the Southside had a bumper sticker that said "South of the James -- By Invitation Only." This separation began to change as road infrastructure improved. In 1988, Southside was connected to Parham Road in the west end via a Chippenham extension and the new Edward E. Willey Bridge. In 1992, the state removed toll-booths on the I-95 Richmond–Petersburg Turnpike. In 1996, state leaders announced that the Chippenham Parkeway would be extended eastward in a bridge across the James river to enable faster access to Interstate 295 (Virginia) and the Richmond International Airport. The bridge and limited access toll highway opened in 2002 as Virginia State Route 895, aka the "Pocahontas Parkway."

Southside developments 2000 to present
In 2004, 288 was extended northwards from Brandermill through Powhatan and Goochland Counties, to cross the river at the World War II Veterans Memorial Bridge (Virginia) and complete the beltway around Richmond. This  led to residential developments along a swath across Chesterfield County such as The Grove near Midlothian Mines Park, Winterfield, as well as a commercial development called Westchester Commons at Midlothian Turnpike and 288. Developments near Route 288 bridge include the Tarrington housing development near James River High School and the widening of the Robious Road Corridor.

Closer in towards Richmond, the Stony Point Fashion Park opened in 2003 (the same year as a similar outdoor mall concept called Short Pump Town Center opened in the West End of Richmond). Along the James River, Forest Hill Avenue has seen its own renaissance as some residents have preferred to stay in the city rather than move to the suburbs. Phenomena such as the South of the James farmer's market attract crowds every weekend in Forest Hill Park.

Farther west along the I-95 / Route 1 Corridor, city and county officials have contemplated how to revive the Jefferson Davis Corridor. While economically challenged, it has a robust immigrant population, particularly Latino. As Manchester has seen recent influx of historic tax credits used to redevelop old properties, the historically black Swansboro and Blackwell neighborhoods are now the subject of fierce debates about gentrification.

Unincorporated towns and neighborhoods
 Adams Park
 Beaufont
 Bellemeade
 Belmont Woods
 Belt Center
 Blackwell
 Bon Air
 British Camp Farms
 Broad Rock
 Brookbury
 Brookhaven Farms
 Cedarhurst
 Cherry Gardens
 Chippenham Forest
 Cofer
 Cottrell Farms
 Cullenwood
 Davee Gardens
 Deerbourne
 Elkhardt
 Fawnbrook
 Forest Hill / Gravel Hill
 Forest Hill Park
 Forest Hill Terrace
 Forest View
 Granite
 Hickory Hill
 Hillside Court
 Hioaks
 Huguenot
 Jahnke
 Jeff Davis
 Old Town Manchester
 Maury
 McGuire
 McGuire Manor
 Meadowbrook
 Midlothian
 Murchies Mill
 Northrop
 Oak Grove
 Oxford
 Piney Knolls
 Pocoshock
 Powhite Park
 Reedy Creek
 Reservoir Heights
 South Garden
 Southampton
 Southwood
 Springhill
 Stony Point
 Stratford Hills
 Swansboro
 Swansboro West
 Swanson
 Walmsley
 Warwick
 Westlake Hills
 Westover
 Westover Hills
 Westover Hills West
 Willow Oaks
 Windsor
 Woodhaven
 Woodland Heights
 Worthington

Industrial and commercial sites
 Defense Supply Center, Richmond (DSCR)
 Philip Morris USA manufacturing center
 Overnite Transportation (recently bought out by United Parcel Service)
 Deepwater Terminal (Port of Richmond)
 Chippenham Johnston Willis (CJW) Medical Center

Commercial districts
 Stonebridge Shopping Center (formerly Cloverleaf Mall) and Spring Rock Green (Formerly Beaufont Plaza)
 Old Manchester
 Hull Street Corridor
 Midlothian Turnpike
 Westover Hills
 Stratford Hills
 Stony Point Fashion Park
 The Arboretum
 Bellwood flea market
 Bermuda Square
 Sycamore Square
 Oxbridge Square
 Chesterfield Meadows

Parks and recreation
 James River Park System
 Forest Hill Park
 Canoe Run Park
 Powhite Park

Transportation

Major streets and roads
 Interstate 95 (formerly Richmond-Petersburg Turnpike)
 Jefferson Davis Highway (U.S. Route 1 and U.S. Route 301)
 Forest Hill Avenue (short portion is U.S. Route 60)
 Semmes Avenue (U.S. Route 60)
 Belt Boulevard (State Route 161)
 Iron Bridge Road (State Route 10)
 Broad Rock Road (State Route 10)
 Huguenot Road (State Route 147)
 Courthouse Road (State Route 653)
 Hull Street (U.S. Route 360)
 Midlothian Turnpike (U.S. Route 60)
 Chippenham Parkway (State Route 150)
 Pocahontas Parkway (State Route 895)
 Powhite Parkway (State Route 76)
 State Route 288

Bridges over James River
 James River Bridge (Interstate 95)
 Mayo Bridge (U.S. Route 360)
 Manchester Bridge (U.S. Route 60)
 Robert E. Lee Memorial Bridge (U.S. Route 1 and U.S. Route 301)
 Boulevard Bridge (State Route 161)
 Powhite Parkway James River Bridge (State Route 76)
 Huguenot Memorial Bridge (State Route 147)
 Edward E. Willey Bridge (State Route 150)
 World War II Veterans Memorial Bridge (State Route 288)

See also
 Neighborhoods of Richmond, Virginia
 Richmond, Virginia
 Manchester, Virginia
 Chesterfield Railroad
 Richmond and Danville Railroad
 Richmond and Petersburg Railroad

References

Neighborhoods in Richmond, Virginia

redpajama_set_name: RedPajamaWikipedia


On this website we recommend many pictures abaout how much does a shipping container weigh that we have collected from various sites mujerpresente.com, and of course what we recommend is the most excellent of picture for how much does a shipping container weigh. If you like the picture on our website, please do not hesitate to visit again and get inspiration from our website.
And if you want to see more images more we recommend the gallery below, you can see the picture as a reference design from your how much does a shipping container weigh.
Thank you for seeing gallery of how much does a shipping container weigh, we would be very happy if you come back.
Similar Keyword how much does a shipping container weigh : 20ft shipping container weight capacity, 40 shipping container weight limit, 40ft shipping container weight limit, international shipping container weight limits, iso shipping container weight capacity, shipping container sizes and dimensions, shipping container specifications and measurements, shipping container weight, shipping container weight capacity, shipping container weight declaration, shipping container weight lbs, shipping container weight limit, shipping container weight limit usa, shipping container weight limits australia, shipping container weight restrictions, shipping container weights and measurements, shipping container weights and sizes, and more.


text:
Q: Entity Framework: Call a function after an object is removed from the database I'm currently working on an ASP.NET MVC project that allows the user to upload files to the server, and associate them with another object
public class FileAttachment
{
    [Key]
    public int Id { get; set; }

    public string Title { get; set; }
    public string ContentType { get; set; }
    public string Extension { get; set; }

    [ForeignKey("Donor")]
    public int DonorId { get; set; }
    public virtual Donor Donor { get; set; }
}

public class Donor
{
    [Key]
    public int Id { get; set; }

    // .....

    public virtual List<FileAttachment> Attachments { get; set; }
}

What I'm wondering is if there's a way to specify a function for Entity Framework to execute when a Donor or FileAttachment object is removed from the DbSet, because the attachments are stored in the file system so I need to make sure the file gets deleted.

A: Databases don't typically call applications to notify when their data changes. It would be much easier if you design your database so it is managing the attachment files, not your application.
I'm not sure what database you're using, but if you're using Microsoft SQL Server, you should look into using the FileStream data type.

redpajama_set_name: RedPajamaStackExchange


text:
MJ Sports Show
Important Numbers to Know
Registration Timeline
Contact The MJ
Join the MJ
Dearborn, US
The Michigan Journal
Home Entertainment Must Watch Korean Dramas Part 2
Must Watch Korean Dramas Part 2
Aubree Stamper
By Aubree Stamper, Photo Editor
Marriage, Not Dating
Photo Courtesy of Pinterest.com
This drama was hilarious through and through, and revolves around my favorite type of plot: the fake marriage. Gong Gi-tae (Yeon Woo-jin) doesn't want to get married, so to get his family off his back he brings home the wild, scene-making but very kind-hearted Joo Jang-mi (Han Groo) and they fake being in a relationship. But it soon turns into a battle between the couple and Gi-tae's mother who is suspicious and won't oppose the marriage to end the scheme. Along the way though, fake emotions become genuine and the two find it difficult to call it off and tell the truth after taking it too far. This drama has some crazy and ridiculous scenes I've never seen in K-dramas before and I loved every minute of it from beginning to end!
Photo Courtesy of AllKpop.com
It's no question that Ji Chang Wook is one of the industry's hottest actors (literally and metaphorically) but this is probably his best role yet. His character Je Ah is a highly trained, highly dangerous ex-special forces soldier who gets recruited by the terrifying Choi Yoo Jin (whose husband Jang Se Joon is running for President)–but only after she fails to capture and kill him several times and he blackmails her. Je Ah and Choi Yoo Jin then team up in order to take out a common enemy; Je Ah needs Yoo Jin's resources while she needs his skills. But while protecting Jang Se Joon's daughter Anna (played by Girls Generation's Yoona), whom he had with his mistress, Je Ah falls in love with her and will do anything protect her from Choi Yoo Jin's wrath while also attempting to get his revenge. This drama was thrilling the entire way through and had tons of crazy action scenes!
Photo Courtesy of WordPress.com
I've been saying lately that I wanted to watch a K-drama where the male lead wasn't a perfect, rich CEO. A drama where the couple are both young, don't have much, and come from not so well-off families–which is actually realistic–and this one is it. Gang Doo and Moon Soo are both survivors of a tragic disaster that occurred when they were younger, and both lost family members because of it. Fate brings them together 10 years later and they're able to help each other deal with what happened and heal. As a result of the incident, Moon Soo becomes an architect but Gang Doo falls into debt trying to take care of his sister and must do whatever lowly jobs come his way in order to make ends meet–which makes him feel like he's not good enough for Moon Soo. This is a beautiful drama with great acting by 2pm's Junho and actress Won Ji Ah even though this is her first drama. It instantly became one of my favorites!
Photo Courtesy of Dramabeans.com
This drama is really unique and has a plot that I've never seen before, which is why I enjoyed it so much. Kim Min-kyu (Yoo Seung-ho) is the CEO of a large company and develops a life-threatening allergy to other humans after his parents' death. This causes him to live in solidarity for 15 years while his doctor tries to find a cure. In the meantime, he secretly tests out an extremely realistic human-looking robot that was created within his company. But little does he know, the real robot is under construction and the research team sends in the real-life woman that the robot was modeled after: Jo Ji Ah (Chae Soo-bin) a.k.a the lead scientists ex-girlfriend. The CEO falls for the woman who he thinks is a robot after she cures his disease and gives him the ability to live a normal life again–and then madness ensues. This drama is super cute and hilarious, one of the best of 2017!
Because This is my First Life
This drama also deals with the fake marriage plot but in a different way. Se-hee (Lee Min-ki) doesn't want to get married and by accident, the quiet and cute writer Ji-ho (Jung So-min) becomes his roommate. As an extremely cold and nit-picky person, no roommate can live up to his standards until Ji-ho moves in who he believes is the perfect roommate. Eventually they decide to fake a marriage to please their families, and plan to get a divorce after 2 years. Along the way as they learn about each other and spend time with each other's families, the two grow attached and fall in love, but face some unexpected obstacles.
Let's Fight Ghost
Photo Courtesy of YouTube.com
This horror-thriller drama had an ending that for once I could not predict and did not see coming at all! Bong-pal (played by 2pm's Taecyeon), a college student who sees ghosts, uses his power to fight them off and get rid of them for people in exchange for large sums of money. One day while working, he comes across a pretty young ghost (Kim So-hyun) who he cannot defeat. She does not remember who she is or how she died, and she ends up following around the only human who can see her, Bong-pal. Eventually he agrees to help her discover who she is in exchange for her helping him fight evil ghosts. It seems like there is no happy way for the drama to end since she is already a ghost, until the plot takes an unexpected turn!
You can watch all of these dramas on DramaFever and Viki!
2pm junho
2pm taecyeon
chae soo bin
han groo
ji chang wook
jung so min
lee min ki
marriage not dating
snsd yoona
won ji ah
yeon woo jin
Previous articleArtist Attention: J. Cole
Next articleMcSweeney's shootout goal leads UM-Dearborn past Davenport
http://michiganjournal.org
Aubree Stamper is a senior at UM-Dearborn where she studies journalism and screen studies. She is in her third year as the photo editor and first year as the A&E editor of The Michigan Journal. Aubree is also a photographer and videographer, and enjoys covering alternative rock music and Korean entertainment.
Review of the 2010s
The best holiday makeup looks
REVIEW: 'Your Name' aka Kimi no Na wa
Iconic moments from the 2020 Golden Globes Awards
'Glow Up' comes to Netflix
REVIEW: Star Wars Episode 9: The Rise of Skywalker
The Michigan Journal is the weekly student publication at the University of Michigan-Dearborn. The paper is published weekly during the fall and winter terms by and for the students.
2018 Winter Olympics in South Korea: A guide to all things...
Border Patrol has called campus: Know your rights with ICE
Artist Attention: Hyuna
AandE
Abby Massucci
Amber Ainsworth
Andrew Hanania
Austin Vicars
Alexander Woodliff
Brighid Driscoll
Corey Lewerenz
Chanel Stitt
Chris Cheetam
Claire Kowalec
Daniel Vijayasegar
Drew Dykowski
Dylan Siwicki
Erick Lehman
Erica Turnbull
Franz Knight
Hannah Genig
Jack VanAssche
Jasmine Sizemore
Jeramy Stover
Jessica Atanasovski
Jordan Wohl
Katy Pentiuk
Kyla Bazzy
Kiel Watson
Kinsey Burnett
Kristin Orr
Kylar Daniels
Leah Higgins
Miraaj al-Haque
Mustafa Al-Asadi
Nathan Lawrence
Nicole Losek
Phillip Lutz
Rayvon Delmonta
Ryan Houlihan
Terry Lakins
Xiulan Li
Zeena Whayeb
Ziad Buchh
Student Life484
Campus News353
Michigan Football353
Search The MJ
Articles by Month Select Month January 2020 December 2019 November 2019 October 2019 September 2019 August 2019 July 2019 June 2019 April 2019 March 2019 February 2019 January 2019 December 2018 November 2018 October 2018 May 2018 April 2018 March 2018 February 2018 January 2018 December 2017 November 2017 October 2017 September 2017 May 2017 April 2017 March 2017 February 2017 January 2017 December 2016 November 2016 October 2016 September 2016 August 2016 July 2016 June 2016 May 2016 April 2016 March 2016 February 2016 January 2016 December 2015 November 2015 October 2015 September 2015 August 2015 July 2015 June 2015 May 2015 April 2015 March 2015 February 2015 January 2015 December 2014 November 2014 October 2014 September 2014 August 2014 July 2014 June 2014 May 2014 April 2014 March 2014 February 2014 January 2014 December 2013 November 2013 October 2013 September 2013 August 2013 June 2013 May 2013 April 2013 March 2013 February 2013 January 2013 December 2012 November 2012 October 2012 September 2012 August 2012 July 2012 June 2012 May 2012 April 2012 March 2012 February 2012 January 2012 December 2011 November 2011 October 2011 September 2011


text:
Q: How to grep the rows with same column in different files and print specific column and add onto the original file? Here is the text files we have:
file1.txt
A B C D
4 9
5 8

file2.txt:
H I J K L M N O P Q R
1 2 3 5 8 9 5 3 3 2 4
4 7 8 9 5 6 8 9 0 8 7
7 8 0 7 4 7 7 9 0 6 7
2 7 9 5 7 9 0 7 6 5 4

I want extract the two columns (H and N) from file2.txt when A column in file1.txt matches with the L column in file2.txt, and the output text file to be shown should be like this:
output.txt
A B C D
4 9 7 7
5 8 4 8

How can I do that?

A: I would go with a step by step approach, to explain

*

*Sort the file 1
sort file1.txt > file1.sorted.txt

*Take the interesting portion out from file2 (and sort it too)
awk '{print $5,$1,$7}' file2.txt  | sort > file2_of_interest.txt

*Join the two outputs based on the key, which is column 1 in both the files
join file1.sorted.txt file2_of_interest.txt -1 1 -2 1
You can combine the three steps using indirection  - but in the end you would need to complete parse at least one file.  There would also be concerns on cases where column L in file2.txt is not unique and/or column 1 in file1.txt is not unique - you would need to resolve those by putting in your business logic to make the key unique.

A: Not possible using grep, but doable using awk:
$ awk 'NR==1   {print $0;next}              # Print header
       NR==FNR {a[$1]=$2;next}              # collect data from file1.txt
               { if($5 in a)                # If column L match
                 { print($5,a[$5],$1,$7) }  # print columns (H and N)
               }
      ' file1.txt file2.txt

As a one-liner:
$ awk 'NR==1{print $0;next} NR==FNR{a[$1]=$2;next} {if($5 in a){print($5,a[$5],$1,$7)}}' file1.txt file2.txt

A B C D
5 8 4 8
4 9 7 7

The order is as the fields appear in the file2.txt.
If you need that sorted, then add a sort step.