text:
Robotic Process Automation Reducing Error, Saving Time for Businesses
The growth of the robotic process automation (RPA) industry is seeing a number of new product offerings designed to improve productivity, reduce errors, and save money for companies worldwide.
Jim Nash
Robotic process automation software, already growing steadily in terms of sales, is also growing more diversified in its capabilities. RPA can help organizations manage workflow right alongside office workers.
The global market for robotic process automation software and services reach $898 million this year, with an astonishing compound annual growth rate of 54% until 2021 when it will reach a predicted $2.2 valuation. The IT robotics automation market as a whole is predicted to grow at a compound annual growth rate of 43% by 2023 and will reach a $1.5 billion global market value by the end of 2018.
Among the innovators in this new niche are Kryon Systems, a startup, and professional services giant EY. Kryon sells what are essentially back-office cbots; EY sells services based on similar home-grown software.
What's the big deal about robotic process automation?
RPA is precisely the kind of unglamorous, nuts-and-bolts product that edges automation into widespread use. While exotic humanoid robots are exciting in the abstract, the majority of users need business process automation that will deliver a return on their investment.
RPA completes business tasks that people find routine, repetitive, and highly exacting. Unable to lose focus the way most people do, RPA bots can do this work with no errors due to boredom.
Kryon Systems' product, Hybrid RPA, is designed to cure hiccups in automated business processes that are caused when the application has to wait for a person to step in for an action that only humans can take. Hybrid RPA knows the relevant ppeople and figuratively taps them on the shoulder, alerting them of the tasks that await them.
Kyron Systems' hybrid automation task list (Image: Kyron)
Kryon CEO Harel Tayeb said his company's software turns back-office applications into a new sector of a company's workforce. Tasks and information being passed between human and machine the way two office workers might.
Martin Fiore, EY's tax talent leader for the Americas, said the firm has been focusing on collaborative RPA for about two years. Globally, about 1,000 people in EY are working directly with the software daily. There are about 250 cobots supporting services in the tax unit alone, according to Fiore.
It is a logical capability for RPA packages, and begs the question — why has it only been introduced recently?
"The algorithms are super, super hard to get right," Tayeb said.
Fiore said that forward-looking companies are starting to see robotic process automation in general as a way of freeing employees to learn new skills, including strategic management techniques like Six Sigma, from which they and the employer benefit.
RPA adoption worldwide
In a counterintuitive trend, the regional adoption of RPA will grow fastest in the Asia-Pacific region, despite the fact that these applications obviate the need to outsource routine business tasks to the developed nations.
China and India will nevertheless buy packages to retain customers who do not want to buy or build their own. It also bears mentioning that both nations have themselves begun outsourcing services recently as their native labor pools grow more expensive relative to other Asian competitors.
It is perhaps not surprising that the banking, financial-service, and insurance industries are the biggest buyers of RPA products globally. Cutting human error and speeding processes are critical goals for these data-intensive sectors, recently illustrated by Grant Thornton's partnership with Information Services Group to implement robotic process automation systems.
More Machine Learning and AI Applications:
Augmented Reality, Virtual Reality Converge With Robotics
Building a Smart Factory With AI and Robotics
Trends in AI: Solving Business Challenges With Automation
Improving the Effectiveness of IoT Deployments with AI and Machine Learning
'Turing Learning' Promises More Flexible Robots
Robot Investments Weekly: Machine-Learning March Madness, Lyft Gets a Boost
Similarly, the Bank of Tokyo-Mitsubishi UFJ recently announced it will use Kofax's RPA software offerings to automate over 2,000 manual processes within the bank. This will let employees instead focus on their primary role, instead of losing time performing administrative and organizational tasks.
Lastly, the automotive industry is another key user of robotic process automation software, using RPA to solve the challenges of regulatory compliance and sprawling global supply chains, while simultaneously reducing mistakes companywide.
Continued development
What's next in the development of robotic process automation?
EY's Fiore said that even today's RPA software is still just following given instructions. The next developmental step will involve artificial intelligence and cognitive computing, allowing the bots to gradually solve novel situations and unanticipated problems.
RPA offerings are seeing constant updating, as the continuing growth and maturation of the industry is bringing new developments to market.
DXC Technologies recently released an RPA offering integrating AI to highlight business inefficiencies, and other Level 3 cognitive, natural language processing robots are available on the market, with setup times numbering only a few weeks at most.
AI, Financial, News, Service, AI & Software, Management, process automation, Workforce
author Jim Nash
Jim Nash is a business and science writer with bylines in The New York Times, Scientific American, Wired, and Forbes.com.
Infographic: The Evolution of Robotics and Automation
Guest Post: Why 5G is Essential for AI, IoT, and Robotics
The Essential Interview: Hod Lipson on Robot Creativity
How Blockchain and AI Can Help Robotics Technologies


Dispatched during first week of selected month.
The gift that keeps on giving, Japan Centre now offer Gift Pop Culture Snack Boxes for you to send friends, family and loved ones. With this mini edition, your lucky giftee will receive a new selection of 5-6 Japanese snacks every month for 3 months. Just enter in their details above, and select the month that you would like for them to start receiving their box. Then for the next 2 months after that, they will receive another box, for a total of 3 months. Snack boxes are dispatched during the first week of every month.
* Title Mr. Mrs. Miss Ms. Dr. Prof.
Please enter full delivery address. We are unable to deliver to PO Boxes.
Please use a-z, 0-9, comma, dash and space only.
Got the 3-month subscription option as a gift. Really great, and recipient loves it.
It is a lovely box to buy as a treat. A good selection of products although something savoury would be appreciated as well.


Bad Alternator or Voltage Regulator?
Went out for some runs with a few buddies the other night.
Ran my friend's FBO E60 M5. He just recently installed his headers.
Car has amazing top end. I need a pulley upgrade to have a chance.
Then I ran a 2012 C63 P31 with 2nd cat delete... walked all over him. Good 3 cars I'd pull everytime.
I was a little nervous about the brakes giving up on me... being electric and all. As I made the turn to the street where the shop is located, lost power steering and all brake feel.... used the E-brake to be able to turn into the garage.... man was I lucky.... timing is everything.
Been doing a bit of reading... and some say voltage regulator solves their issue. I noticed a plastic burning smell though... so I'm thinking my alternator is just shot. Any insight?
This happened to me about a year ago. I pulled the alternator and took it to a repair shop. They reported that the internals were good, but the rectifier had shorted out. This is what caused the burning smell. They suggested replacing the bearings as long as the alternator was out of the car. Total cost for rectifier and bearings (part and labor) was $130.
Last edited by atxE55K; 09-02-2015 at 02:29 PM.
Plastic burning smell is the alternator. was such a pain to replace. Take the fan shroud out and disconnect all the radiator lines on the front passenger side.
I have a new OEM Bosch voltage regulator I can sell you that I bought as a back up a few months ago. Let me know if you want it.
I took out the radiator lines (the big hoses). Also the double pulley came out. Made it much easier to get the alternator out without puncturing a radiator line. I heard you could squeeze it through the lines but I wasn't able to do so.
has your alternator been replaced or is it the original?
front battery and rear battery original or been replaced?
is this it? how do i test if this works or not ?
thats it under the passenger side windshield.
Since the light came on while you were driving, it's likely the alternator. Change the VR first, you can get to it underneath the car. You just need to remove the plastic and there are like 6 screws/nuts that hold it on. The parts only like $50-60 so it's worth a shot before taking out the alt.
try replacing voltage regulator. If it doesnt work then the alternator for sure.
you DON'T need to test that relays if your main battery is good.
the K57 relais kicks in only in that case (besides for charging the Aux battery).
both bolts (#2 in the pic) are Positive, and you have a lot of chances to make a short . so, just stay away from it. Warned .
i had a similar warning light, ended up being an alternator.
I dnt think it's your alternator or battery giving you the problems...it might be your cranksharft pulley is slipping...( in begining stage) pls inspect the crank pulley..
I want to thank TalonP for post # 76, excellent descriptions and pictures.
After going through steps described by TalonP on post #76, my steering wheel column still would NOT move up or down. I gave up and put everthing back together, resigned of spending $1500 to $1800 at the dealership.
However, I keep on searching for other posts and there was one where they talking about door being open vs closed ignition being on vs off. To satisfy my curiosity, I went back to my car, sat on driver seat, closed the door, removed the on/off button of the ignition so I could turn ignition switch with the key, turned ignition one step before engine would start, push lever down while hitting steering wheel on top, followed by pushing lever up while hitting steering wheel at the bottom towards the ceiling, and then ... the column started to move!
It now moves up and down. However, since I do not know why it stop working, other than something got stuck somewhere, and I do not want to pay the dealership $1500 to $1800 to fix it; I positioned the steering wheel the way I like it, and then I disabled the "Easy on/off" feature so the steering wheel will not move up/down in/out when I get in or out of the car.
TalonP - Thank you so much for your pictures and detailed description.
Basically in a nutshell, if you are seeking just best bang for the buck in a serious upgrade without a lot of hassles then you could use just these front S55 calipers along with an R500 13.8" front rotor and it will bolt on fine and need nothing custom and nothing else. you may need a 5mm washer at the caliper mounts but I don't remember for sure and will check to confirm this. that is really all you'd need to do to upgradeHello turbocad, I just wanted to confirm as I have an early 06 R500 with the solid rotors on rear and 13" front brake rotors and stopping acts like front drum brakes! I am very interested in going with S55 from calipers and 13.8" rotors on the front of these will bolt on with a 5mm washer at the caliper mounts. Thank you for all the R&D you have done with these R class brakes! I do only have 17" R350 wheels on my R500 at the moment (bought the car like that) so will S55 calipers clear the 17" wheels?
Quick Reply: Bad Alternator or Voltage Regulator?


On April 13, Zhang Ping, Vice Chairman of the Standing Committee of the National People's Congress and President of CCA, made an inspection to CCA, accompanied by Zhang Mao, Direct-General of State Administration of Industry and Commerce (SAIC) and Executive Vice President of CCA, and Ma Zhengqi, Deputy Director-General of SAIC and Vice President of CCA.
Zhang Ping pointed out that there is a need to give full play to the role of social organizations as China deepens its reform and social development. He also noted that social governance should be strengthened through self-governance and shared governance. As a connecter between the market and the masses, consumption represents a major driver for economic development and has a direct bearing on the immediate interests of the ordinary people. Consumer associations at all levels have the closest connection with the 1.3 billion consumers, and will play more important role in the future with increasing burdens on their shoulders and higher requirements for their works.
Zhang Ping required consumer associations to keep strengthening their sense of mission, responsibility and accomplishment in works. Consumer associations should act by law and truly work for the interests of the ordinary people based on their positions and responsibilities bestowed by the law. Consumer's associations should intensify capacity building of their teams, improve their political quality, professional competence and moral integrity, and adapt to the new situation, new requirements and new tasks. Consumer associations should do a solid job, withstand legal inspections and social supervisions, and constantly enhance their credibility, influence and authority. As such, consumer associations could better play their role in creating a good consumption environment and practically safeguarding consumers' legitimate rights and interests.
Zhang Ping also noted that examinations of law enforcement regarding the newly revised Law on Protection of Consumer Rights and Interests would be carried out in the latter half of the year according to this year's supervision work plan of the Standing Committee of the National People's Congress. He also expressed his wishes that consumer associations at all levels could seriously summarize the development and issues relating to their implementation of the Consumer Protection Law over the year and actively coordinate the examination works to facilitate the further improvement and implementation of the new Consumer Protection Law.
Ma Zhengqi, Deputy Director-General of State Administration of Industry and Commerce and Vice President of CCA, reported the basic situation and consumers' rights protection of consumer associations nationwide to Zhang Ping in the inspection. Chang Yu, Secretary-General of CAA reported all works of CCA since the implementation of the new Consumer Protection Law.


text:
Stronger than we were; unapologetically
Logs » Stronger than we were; unapologetically
Summer - ?
Late afternoon finds the heat and brightness of summer still a little too much for Xyvette's liking, and, though she's opted to remain outside nevertheless, she's retreated to the quiet of the rooftop garden, a sun chair safely in the shade selected as the perfect spot in which to check over straps that undoubtedly fit Nehehkath, yet have seen next to no use in recent months. She sits with one leg out straight before her, foot minus any shoe, with the other bent at the knee, lengths of leather laid out across her lap as she methodically goes through each section bit by bit, checking for damage and rust that might have appeared when she isn't looking.
Fresh air and sunshine. Two things that S'van probably gets plenty of to begin with, though it does not stop him from using it as an excuse to escape indoor spaces. And while there was probably a task or two that would have likely benefited from his attention, it is the area over the living caverns that he seeks out. There's a pause on the patio, a twitch to the corner of his mouth for a private thought, and then he is into the lush green and soft grass of the gardens. A pause, a quick removal of boots and socks and the rolling up of his pants, and then he is walking through the lush vegetation towards Xyvette. Though it is unlikely he knew he would find her here, that doesn't stop the very purposeful stride that carries him toward her. He also seems to care not whether he is interrupting something; he drops down within her space quickly, decidedly closer than someone who just 'happens' to be here. No. This is more or less an invasion of her personal bubble. "Hey." Eyes to the straps. "Nice work."
Though Xyvette observes S'van's approach without truly lifting her gaze to track and follow, watching his progress in her peripheral vision, she chooses not to acknowledge him until he's right there in her space, perhaps growing accustomed to such occurrences, for she doesn't move away or react in a manner that would suggest it is anything out of the ordinary. If anything, she wordlessly accepts that he's there, darting a brief look up from her work and to S'van before refocusing. "Maybe there will still be a day reached when they can be more than aesthetically pleasing," she utters dryly, turning a buckle over to inspect its back. Since he's there, she moves to drape those straps over him too, just so that she can get a better look at them. Such is the risk of being so near.
"Don't see why not," is S'van's quick reply, though he has no basis on which to stake that claim. The draping of straps is met with nonchalance, though he's settling back onto his hands and disinclined to partake in the study of them beyond his first cursory glance and initial remark. He looks out, over the garden and toward the Bowl, gaze distant in a way that says he is thinking to himself rather than conversing with his draconic half. A long stretch of this silence, perhaps companionable, before he can't help but to say, "You know. J'en has nothing to do with the fact that you're being held back. He really didn't deserve to get his head bit off because he was selected to teach a dancing lesson."
Xyvette arches a brow, yet remains silent for a moment or so after S'van has made that comment, pretending to focus on a speck of rust that has the buckle not moving as well as it ought to. As she pulls a length of red ribbon from a pile at her hip and ties it where she's found that 'damage', she questions, "And does J'en need you to come and talk to me about it because he can't handle the matter himself? Is he incapable of having the conversation, if he requires it to occur at all?" The knot is tied a little too aggressively, but her expression remains unreadable, for the most part. "What I said had nothing to do with being held back. I will not be made to stand there like a fool for the amusement of others, pandering to the whims of people far less qualified to instruct in dance than I am. If any of them had been prepared for the lesson, they should have known enough about us to realise that not all of us were beginners." Of all of it, she insists, "It was not done professionally. Any of it. We were toys for amusement."
"Of course not," followed by a snort from the weyrling bronzerider. "But he is…" a quick sideways glance at Xyvette and a brief pause as he seems to decide how best to explain. "He is important to me. And he was just as much a 'toy' in that lesson as we were," he states firmly, his amusement dying off into a much harder expression. There's a glance down, an idle watching of her progress through the straps and the tying of that red ribbon. "We're weyrlings," he notes, as if that explains everything.
"It wasn't my intention to be rude to him, but whether he's important to you or not shouldn't have mattered in the capacity he was supposed to function in at the time." Xyvette tilts her head slightly, a deep breath taken as she passes the ribbon through her hands and moves onto the next section of her straps. "If you want me to… like him, or you want to defend him, or you want me to treat him differently for your sake, then knowing him outside that experience wouldn't be objectionable." It's S'van's noting of their rank that makes her pause and truly stare at him in a fashion that makes it plain she's trying to work out whether he's serious or not. "We're people. That's like saying I could belittle a twelve turn old apprentice and have it be right."
There is an idle shrug of his shoulders that speaks to ease and relaxation, even if the emotion is not mirrored in his expression. "My point was simply that it was unfair to unleash your anger on someone who was not responsible for the decision, or had any say in the matter whatsoever. Just because he got tagged with the role of 'teacher'-" but he just stops, presses his lips together and decides not to continue that line of thinking. "Whatever. Forget I said anything about it. I'm really not someone who should be trying to give advice about the appropriate way to respond to decisions you disagree with. But I will say this. From practical experience. Lashing out usually isn't the best way to get what you want. Maybe it was embarrassing. Maybe it was meant to humiliate us, I dunno. But it's not like our lives were in danger. There are worse things."
"If he expected everything to go exactly as he wished it and nothing more, he shouldn't have agreed to take the class, regardless of the how or why he ended up in that position." Xyvette focuses for a moment on some fraying stitching that doesn't really need fixing or that much attention, but it gives her something to stare at that isn't S'van. "And truly, if I had spoken so to anyone else, would you be here telling me that I was wrong?" It's not an effort for her to concede, "He's not a bad person. It was just, collectively, a poor decision. Perhaps on my part too." She lets silence fall for a while, then leans back a little more in her chair and lets her grip on those straps loosen. "…I've spent my whole life adhering to the wishes of others, often in ways I'm beginning to realise weren't acceptable," she says more quietly. "And I think I'm done with it. Perhaps I could have stood up for myself in a more productive way, but I don't take it back." And such, it would seem, may well be her final word on the subject.
"That's my point, Xyvette. HE didn't agree to anything. He was made to do it." How does S'van know this? He is apparently disinclined to say. But his utmost belief that his words are true is written into the expression on his face and the firmness of his tone of voice. "And if I knew with absolute certainty that they were innocent? Yes," he decides, just as resolute and ready to defend another in the Wingleader's stead. "It is only because I know him so well that I can say, without being told, that he neither chose, nor even wanted, to take part in that little exercise." But he's said his piece. Probably more than he meant to, and there's a hard look toward the distance for the entire subject. That silence will stretch as each keep to their own thoughts, before the slight tilt of his head and brief flick of his gaze betrays that he is listening when she speaks once more. There is not much he can say that has not already been said. Loath to repeat himself again, or perhaps just acknowledging the finality in her tone of voice, S'van decides not to push the subject further. "Are you getting better?" which may not be any safer of a subject, though he still boldly broaches it. "Have you forgiven your weyrmate?"
"You're in love with him." It's not an accusation, even as bluntly as Xyvette makes that statement, but an almost all too clinical observation. She makes little of it, not concerned that she should look at S'van as she reaches that conclusion and watch for what reaction she can discern, leaving confirmation of whether she is right or wrong entirely up to him to provide or sidestep. There's no needling at him; no smirking or intent to tease, her attention on one distant cloud or another. It takes her longer to drag together a response to his first enquiry, summoning courage with another deep breath taken and held. "Some things hurt less and others hurt more," she summarises. "I'm stronger than I was, but my legs remain a problem. It seems every time I get one joint steady, another has its own crisis." Has she forgiven her weyrmate? "…He was right to act as he did, for the reasons he did. He may not have had the right of it, but the fact is that I didn't care enough and he did. No matter how I feel, objectively, he was correct."
Confirmation comes swiftly, a resounding, "I am," without any hint of hesitation or defense. It is no secret, S'van's feelings for the Archipelago Wingleader, despite the nature of the knots each happens to bare on their shoulders. Neither does the weyrling seem to be particularly apologetic for such a thing, powering through the moment with quiet ease. But he does not offer further explanation, for the relationship or his participation as leader of that atrocious dance lesson. Instead, it is swept aside with a casual shrug of his shoulders and a shifting of position that lands his back against something firm; probably a tree. A nod of his head, indication of his acceptance of her answer regarding the state of her health. "That's why you were limping," is noted, as though to himself. The question of weyrmates earns a longer glance, a little furrowing of dark brows, and a quick, "That wasn't really an answer." A beat. "Have you apologized to him?"
Xyvette lets that silence define her again, though whether she is lacking in an answer or simply reluctant to supply it is not so clear. Yet another audible breath, then she opens her mouth as if to speak, her gaze taking on a sharper, potentially argumentative edge, yet she promptly shuts herself up before a single word can escape and must choose not to be as pedantic as she might wish. More silence. She sighs, though ultimately concedes, "Yes." In-case what she is confirming isn't clear, she enunciates a clear and deliberate, "I've forgiven him," that sounds a little more for her benefit than for S'van's. Perhaps because some form of turnabout is fair play, she asks, "Have you mended matters with Catwin?"
S'van is no stranger to pregnant silences, and so the one that stretches out is friendly enough for the weyrling bronzer, who takes once more to looking across the garden as if in idle curiosity. The twitch to the corner of his mouth for her eventual answer is short lived, as the question is quickly posed to him and he must choose how to answer. His silence is not as lengthy, and it's purpose seems to be altogether different as grey eyes roll toward the sky and his head tips just slightly to the side, considering how best to respond. "I've forgiven her," he answers finally, though there is a hesitation before he continues with, "I haven't tried to speak with her, though," other than when necessary for lessons. "There are things she just… is not going to understand and I don't want to fight with her." Another small curl to the side of his mouth, and a soft noise is made, something like dry laughter that doesn't quite make it out into the world. "I've accepted that she didn't know what she was doing. Or, rather, that she thought she was helping when in reality, she was doing the opposite."
"That seems the wisest course of action if you want to salvage your friendship, eventually." Xyvette turns one of the leather lengths of her straps over to check for damage, then continues studying along that line to the next buckle. "Sometimes, I find that writing things down helps. If you still want to express how you feel about the situation and don't wish to get into an argument with her, give her the information in a way that doesn't give her the opportunity to immediately state her case in return. You would both have to think before speaking, as it were." She allows herself a tiny smile, sliding a look towards S'van. "We both know that you could write her a much neater letter than before." Back to those straps. "People are complicated. There's always so much more going on than any of us realise."
"Maybe," is all S'van says about letter writing, though there is enough drag and hesitation in the word as to suggest he is likely not to do any such thing. The press of his lips into a thin line, the way grey eyes harden as he considers the distance, may very well suggest there are things he's not ready to say on the subject; on paper or aloud. "S'good enough I've lost the anger. And I'll tell her I'm sorry when I can, for my part of it. It's her choice then, whether she's going to accept it." A longer sigh as arms unwind and he moves to push himself to his feet in purposeful movements, even if he's taking his time about it. Complicated. That gets a downright laugh, though it's dry and ironic in nature. "Ain't that the truth."
"Next time, let J'en come to me and fight his own battle," does not contain the chill of before, something softer in Xyvette's tone that's a little closer to humour, dry though it may be. "You can referee if you like." An offer to try and make amends or true interest in finding out who the other bronzerider is outside the context she could not bear, maybe it doesn't matter, especially since it doesn't sound as though she has any real intention of fighting. Content to leave that with S'van, she picks up another red ribbon and begins to tie it in place, as comfortable with silence in parting as she has been with much of the rest of it, a thoughtful glance given him only when there's enough distance between them that the next moment will carry him out of sight and she must give her full attention to her work.
2017_auglogs_s'van_xyvette

redpajama_set_name: RedPajamaCommonCrawl


text:
Spider-Man: Far from Home (2019): Our hero saves Europe from evil Elementals...or someone else. European city backgrounds were my favorite part of movie. Also, the usual Marvel humor. And I guess the teen love story adds human interest. Full of plot holes. Overdone CGI. C+
POTD: Nikolsky Cathedral Bell Tower
From 2018 08 19 Uglich
Today's photo-of-the-day is from the Volga River in Russia. When the Baltic-Volga Waterway was constructed, the network of dams, reservoirs, and locks connecting a two-thousand mile long waterway sometimes drowned villages and towns. The bell tower is all that remains of the Nikolsky Cathedral.
Blocked on Twitter
The 2nd US Circuit Court of Appeals upheld a New York judge's ruling and found that [President Donald] Trump "engaged in unconstitutional viewpoint discrimination by utilizing Twitter's 'blocking' function to limit certain users' access to his social media account, which is otherwise open to the public at large, because he disagrees with their speech." ... The judges on the appeals court concluded that "the First Amendment does not permit a public official who utilizes a social media account for all manner of official purposes to exclude persons from an otherwise-open online dialogue because they expressed views with which the official disagrees."
Source: CNN .
After the jump, my own experiences being blocked on Twitter.
Labels: NationalPolitics
POTD: Cruising the Volga
Today's photo-of-the-day is from the Uglich Reservoir lock on the Volga River in Russia. The bow of our cruise ship is just visible as we enter the lock behind another cruise ship. The Baltic-Volga Waterway is a network of dams, reservoirs, and locks connecting a two-thousand mile long waterway. The whole is an amazing feat of engineering.
POTD: My Uglich Watch
Today's photo-of-the-day is from Uglich, Russia. There's a story behind it. I haven't worn a wrist watch in years. But I was in Uglich. How could I resist buying a watch in Uglich? Uglich was known as a watch-making center in Russia. Nikita Khrushchev, while attending the 1955 Geneva Summit, bragged that Uglich watches were better than Swiss watches because, as the joke goes, Russian watches run faster. So I decided I'd buy an Uglich watch, as long as the price was cheap. I found the perfect watch at this souvenir stand. It featured "President of Russia" on the face, along with a tsarist double-headed eagle and Vladimir Putin's signature. And it was cheap. Later that day, Ellen said it was time for dinner. I said we still had an hour. She said no we didn't. I double checked my new watch and noticed it had stopped running. So much for my Uglich watch.
Close-up after the jump.
Review: The Soul of America
From The Soul of America, by Jon Meacham:
For many, the fact that we have arrived at a place in the life of the nation where a grand wizard of the KKK can claim, all too plausibly, that he is at one with the will of the president of the United States seems an unprecedented moment. History, however, shows us that we are frequently vulnerable to fear, bitterness, and strife. The good news is that we have come through such darkness before."
The bad news is that the same shit keeps happening, generation after generation. It's not Meacham's thesis, but like playing Russian roulette, eventually the bad shit is going to kill us.
An Ad that Didn't Age Well
Younger readers may need an explanation. It used to be that to make a long-distance telephone call, you'd have to use an operator. (And if you're too young even to know what long-distance means, or what an operator is, use Google.) It was an exciting innovation when direct long-distance dialing was introduced. In the UK and Australia, the feature was called "subscriber trunk dialing," abbreviated STD. STD was still a big thing in telephone service when this ad appeared in Australia in 1976. Now you know. Hopefully, I don't have to explain the other meaning of STD.
The Time to Travel is NOW
POTD: House Hunting in Uglich
POTD: Grace
POTD: Church of Tsarevich Dimitri On the Blood
POTD: Sunset on the Volga
POTD: Yaroslavl Festival
Idle Thoughts: Only One Item on the Ballot


On Sept. 17, the one-year anniversary of the Occupy Wall Street movement, some 180 were arrested in Lower Manhattan trying to, once again, occupy Wall Street. As usual, the famous street was cordoned off behind police barricades, with only ID-carrying employees allowed through, so most of the "occupations" were actually on the surrounding blocks. Even converging before dawn was insufficient to avoid this fate. With protesters scattered in clusters throughout the area it was difficult to judge numbers, but mainstream sources (WSJ, Reuters, Al Jazeera) put it at a probably low-balled 1,000. Reporter Colin Moynihan in the New York Times has a video feed from the scene which shows some of the predictable instances of police thuggery, including a rather futile effort to bar journalists from filming the man-handling of protesters. Other such images are online at Gothamist.
By the time this blogger arrived by bicycle in the afternoon (having been up all night blogging, as usual), the old focal point of Zuccotti Park was packed with crunchy kids making a racket with their human microphone routine and drum circles as if they'd never left. But it was surrounded by metal police barricades, with access and egress permitted only through a few small choke-points watched over closely by cops and private security. The politics on display were generally pretty good, although still suffering from the vague populism that has always been a weak point of the movement. There was a refreshing absence of sectarian-left parasites, Ron Pauli zealots or simple wingnuts.
Banners ranged from the astute (BIG BUSINESS: "YOU DIDN'T BUILD THAT!" THOUSANDS OF WORKERS + SLAVERY BUILT THAT) to the borderline jingoistic (THERE'S NOTHING AMERICAN ABOUT "CORPORATE AMERICA"; END CORPORATE GREED!—with the word "AMERICAN" in star-spangled red, white and blue, no less). One particularly creative prop depicted Bain Capital as a giant anime-style killer robot labelled "JOB DESTROYER"—certainly an image we like much better than the overdone vampire squid. Also falling into the stupid jingoism category was a decal with a portrait of ethnic cleanser George Washington and the phrase "I FATHERED A COUNTRY AND ALL I GOT WAS THIS LOUSY POLICE STATE." (Yuck yuck.) A most welcome sight was the pithy phrase chalked on a sidewalk: "AYN RAND WAS WRONG ABOUT EVERYTHING"—accompanied by an anarchist symbol, which is really good since anarchists have a special responsibility to call out the appropriation of the libertarian tradition by the free-market right. Although it must be said that Ayn Rand was right about secularism and reproductive freedom, which makes her more progressive than the Republican nimrods who today tout her otherwise barbaric ideology!
Another astute slogan was "A BETTER WORLD IS ALREADY HERE, IT JUST ISN'T EVENLY DISTRIBUTED"—which keeps the focus on the class struggle that should be what the Occupy movement is all about, and is also an answer to the Malthusian scarcity-mongers. The closest this blogger saw to the demoralizingly stupid pro-capitalist politics of the Paulistas who were omnipresent at Zuccotti last fall was the inevitable "END THE FED" banner.
Unfortunately, even after everything it has accomplished, Occupy still hedges on what should be the fundamental principle of anti-capitalism. The front page of the Occupy Wall Street website does prominently feature the slogan: "the only solution is World Revolution." But even the muddle-headed Paulistas cluelessly bandy about the word "revolution." We have happily noted the existence of an "Occupy Wall Street Class War Camp"—but it still seems to be a minority current.
The Occupy movement isn't going to truly rise to the historic opportunity represented by the current crisis of capitalism unless it gets over this squeamish hedging. Andrew Ross Sorkin of the New York Times' "Dealbook" financial column noted the anniversary by declaring Occupy Wall Street "a Frenzy That Fizzled," and gloating: "It will be an asterisk in the history books, if it gets a mention at all."
Let's see if we can prove the fucker wrong, eh? But we aren't going to do that through fuzzy populism that shirks from inevitable realities. If the doctrinal orthodoxy of the boring old sectarian left is a trap to be avoided, so too is the anything-goes anti-intellectualism that continues to characterize Occupy. Let's have the discussion that needs to be had already.
thanks. i couldn't go this year. i expected it would be smaller and ignored by mainstream media as the frenzy that fizzled. left establishment is afraid of obama being associated with class war so close to the elections. left is genuinely afraid of what should be their fundamental principle. can you imagine the world in which democrat candidates would quote karl marx with the same ease and frequency as republicans quote ayn rand? balance to the force bring that would, as Yoda would say.
For the most part you very clear thoughtful about what OWS was doing, what their mission should be and what OWS needs to avoid. Thanks for the clear thinking.You having studied music and revolution may be able to answer the one question I have about OWS is why the incessant drums circles?
The issue of class is still a taboo word in the liberal left and even the radical left when workers and marginalized workers are only good when they illustrate the current party cause of the moment. If the said worker is just merely an unschooled oppressed laborer that doesn't fit the socialist realism model the laborer is of no use and is ridiculed. Many an erstwhile "lefty" will use their class privilege to avoid the working stiff who is down in their luck and clueless as to how to remedy their life. Treat your custodian well.
Your quote "Another astute slogan was "A BETTER WORLD IS ALREADY HERE, IT JUST ISN'T EVENLY DISTRIBUTED"—which keeps the focus on the class struggle that should be what the Occupy movement is all about, and is also an answer to the Malthusian scarcity-mongers." contains great reporting and sloppy acounting. "Malthusian scarcity-mongers" is one, imprecise in who you are referring to and two, ignores the fact that there is a limit as to how many people can live sustainably on Earth. That number varies depending on the definition sustainable and varies from 1 billion to several billion. Most people who recognize the impact of human population on the environment agree that we are well beyond anything that could be considered sustainable.
That said the quote A BETTER WORLD IS ALREADY HERE, IT JUST ISN'T EVENLY DISTRIBUTED" is the heart of almost every struggle in human historyand should be the focus of OWS.
If you follow the links for that phrase back, it will immediately become clear who I am referring to. Nobody is denying that the planet has a carrying capacity, but scarcity is not the cause of poverty and privation. Capitalism is. I don't see any "impact of human population on the environment" whatsoever. I have seen peasant communities living sustainably on their lands from Chiapas to Cajamarca to Catalonia to Calabria. And I see lands that could provide for people everywhere being plundered by timber and mineral and oil and real estate interests. Nothing will convince me that "scarcity" is in any way a problem as long as this wealth iniquity persists. Sorry.
I'm also anti-capitalist but have studied ecology, agroecology and agroforestry. Scarcity is currently primarily created by capitalism. "And I see lands that could provide for people everywhere being plundered by timber and mineral and oil and real estate interests." You wouldn't have destruction of landscapes and natural resources if the combination of capitalism, resource depletion and urban populations disconnect from the realities and limits of these natural systems. The oceans have become depleted fish because the over consumption, misuse of resources (chicken, pet food) and of course capitilism. Yes peasant /indigenous communites do thrive when disconnected from the larger market.
Your viewpoint "Nothing will convince me that "scarcity" is in any way a problem as long as this wealth iniquity persists. " is rather utopian and would urge you to be more open to the science. It seems as though you may have been swayed by the current belief that permaculture systems (PS) in temporate climates will provide an abundant future. PS while efficient and very practical in tropic areas tend to obscure the real problems of food production, crop failures and resource use in the colder temperate zones.
Most projections of yields are based on good harvests not the mean or average harvests which are much lower. Here is an example of the problem. J. Russell Smith "Tree Crops: A Permanent Agriculture"-1929, 1953 was an economic geographer who popularized Tree Crops, an early version of agroforestry and Permaculture. Smith, whose works I have studied could get the crops yields incorrect because of his ignornce of biology and ecosytems. He noted that oaks could produce about 400 #'s per year in Spain. The tree was old, very large and open grown.You can't extrapolate that number on a per acre basis to to represent world production of acorns. That number was based on one tree in one year. Oaks tend to bear a "heavy" crop once in 5 years.
Spare me. You yourself point to "overconsumption" and the "larger market" to explain resource depletion. These are functions of capitalism, not human numbers. Barry Commoner is a scientist and he deftly demolished the Malthusian claptrap in The Closing Circle. Read that one?
Years ago and Barry Commoner was wrong in the larger issues since he was unaware of sustainability as I recall. Please spare me your ideological blinders. Refusing to face the facts and deny science really doesn't solve the problem of too many people extracting resources which we are rapidly running out of.
Just try to feed NYC when fossil fuels run out. Most cities are abyssmal for food production and are parasites on the land. How many of NYC people would be willing to work in the fields like the Chinese in years past?
Yes, capitalism exacerbates the problem as does civilization. I spoke with a sorghum pathologist/breeder in 84 and he said that there was no food shoratage in India. What? asked Lew. He said it was economic. The Soviet Union (OK a state capitalist country) destroyed the established agriculture systems. Resource depletion is a matter of numbers and poor technology which can ameliorate the problem but certainly never makes it go away.
I'll look for worthwhile material for you to think about. May take some time to find it since I don't wharehouse information.
Read Derrick Jensen. I do have trouble with wome of his premises/analogies about men who have battered women and children can never change. He's just playing the victim and building a causeon a false premise.
What are you talking about? You have yet to back up your accusations that I am denying science. I am doing no such thing. I never said New York City was a sustainable entity; I said the roots of privation are wealth iniquities and institutionalized waste (upon which capitalism is predicated), not "overpopulation" or "scarcity."
What I've read of Derrick Jensen doesn't impress me. I suggest you read Food First: Beyond the Myth of Scarcity by Lappé & Collins (yeah, another classic from the '70s, but with an analysis no less timely), Reproductive Rights and Wrongs: The Global Politics of Population Control by Betsy Hartmann, the brilliant introduction to Eduardo Galeano's Open Veins of Latin America (which exposes the fallacy of "poverty as a result of the children that the poor don't avoid having"), and, if I may toot my own horn, the chapter "Overpopulation as a Propaganda Device" in my own book War on the Land: Ecology and Politics in Central America.
And if you really wanna hit the classics, don't forget Marx's definitive critique of Malthus in the Grundrisse. Just as valid today as it was in 1858.
That was the context for the rift between Dr. Commoner and advocates of population control, who saw environmental degradation as a byproduct of overpopulation. They had become a force on the strength of Paul R. Ehrlich's huge best seller "The Population Bomb." Conservationist groups like the Sierra Club and the National Wildlife Federation were strong supporters of Dr. Ehrlich's views.
Dr. Commoner took aim at the "neo-Malthusians," as he called those who, like the English scholar Thomas Malthus, foresaw perils in population growth. In a panel discussion with Dr. Ehrlich in 1970, he said it was "a cop-out of the worst kind" to say that "none of our pollution problems can be solved without getting at population first."
He elaborated in his best-known book, "The Closing Circle," published the next year. Reducing population, Dr. Commoner wrote, was "equivalent to attempting to save a leaking ship by lightening the load and forcing passengers overboard."
"One is constrained to ask if there isn't something radically wrong with the ship."
[A]lthough Dr. Commoner had a record of achievement as a cellular biologist and founding director of the government-financed Center for the Biology of Natural Systems, he was seen primarily as the advocate for a politics that relatively few considered practicable or even desirable. Among other positions, he advocated forgiveness of all third world debt, which he said would decrease poverty and despair and thus act as a natural curb on population growth.


text:
Q: Converting csv to xml using Python I have a csv file which resembles the format below:
===============================================================
#Type 1 Definition
#============================================================================
#TYPE, <name>
#Some tag for type------------------------------------------------------
#TYPESomeTag, <id>, <name>, <param>
#Another tag for type----------------------------------------------
#TYPEAnothertag, <param_1>, <param_2>, <param_3>
TYPE, Name_1
TYPESomeTag, 1, 2, 3
TYPESomeTag, 4, 2, 5
TYPEAnothertag, a, b, c

TYPE, Name_2
TYPESomeTag, 1, 2, 3
TYPESomeTag, 4, 2, 5
TYPEAnothertag, a, b, c

#===============================================================================
#Type 2 Definition
#===============================================================================
#TYPE2, <name>
#Some tag for type------------------------------------------------------
#TYPE2SomeTag, <id>, <name>, <param>
#Another tag for type----------------------------------------------
#TYPE2Anothertag, <param_1>, <param_2>, <param_3>
TYPE2, Name_1
TYPE2SomeTag, 1, 2, 3
TYPE2SomeTag, 4, 2, 5
TYPE2Anothertag, a, b, c

TYPE2, Name_2
TYPE2SomeTag, 1, 2, 3
TYPE2SomeTag, 4, 2, 5
TYPE2Anothertag, a, b, c

and so on...

My goal is to convert the above csv into xml format and I am using Python for the same.
Here is how I started implementing this
for row in csv.reader(open(csvFile)):
    if(row): #check for blank lines
       if row[0] == 'TYPE':
           xmlData.write('      ' + '<TYPE'+ row[1] + '>'+"\n")
       elif row[0] == 'TYPESomeTag'
            xmlData.write('      ' + '<TYPESomeTag'+ row[2] + '>'+"\n")
       elif
           #write some more tags
       else
         #something else
xmlData.close()

This approach that I follow is pretty shabby since its not easily extendible. I am comparing the first column of each row against a string. Now problem arises if there's another set of type definitions like TYPE2. Then I have to write another set of if..else statements which I think is not really the way to do this efficiently.
Could someone advice how can I do the task of converting the above csv to xml in a better way.
EDIT:
This is the xml that I am aiming for:
<tags>
 <TYPE Name_1>
   <TYPESomeTag>
    <id>1</id>
    <name>2</name>
    <param>3</param>
   </TYPESomeTag>
  <TYPESomeTag>
    <id>4</id>
    <name>2</name>
    <param>5</param>
   </TYPESomeTag>
  <TYPEAnothertag>
    <param_1>a</param_1>
    <param_2>b</param_2>
    <param_3>c</param_3>
   </TYPEAnothertag>
 </TYPE>
 <TYPE2 Name_2>
   <TYPE2SomeTag>
    <id>1</id>
    <name>2</name>
    <param>3</param>
   </TYPE2SomeTag>
  <TYPE2SomeTag>
    <id>4</id>
    <name>2</name>
    <param>5</param>
   </TYPE2SomeTag>
  <TYPE2Anothertag>
    <param_1>a</param_1>
    <param_2>b</param_2>
    <param_3>c</param_3>
   </TYPE2Anothertag>
 </TYPE2>
</tags>

A: Well that's a rather complex question:

*

*you first need to parse the definition comments to determine the tag names that will be used in the xml file

*you need to parse the csv file, skipping the comments and empty lines

*you need to build a XML file (or tree) with the following rules:

*

*root tag is tags

*each line with only 2 element is a top level tag

*each line with more than 2 elements defines a subelement of the current top level element with

*

*the tag name is first element of the line

*every other element defines a subelement where the value gives the text of the xml tag and the tag name comes from the definition comments

*you want the xml file in a pretty print mode

I would use:

*

*a dedicated filter to process the comment lines and remove them before feeding a csv reader

*a csv reader to parse the non comment lines

*xml.etree.ElementTree to build the xml tree with the help of the tag names processed by the custom filter

*xml.dom.minidom to pretty print the xml.

It ends in the following code:
import re
import csv
from xml.etree import ElementTree as ET
import xml.dom.minidom as minidom

class DefFilter:
    def __init__(self, fd, conf = None):
        if conf is None:self.conf = {}
        else: self.conf = conf
        self.fd = fd
        self.line = re.compile(r'#\s*(\w+)\s*((?:,\s*\<\w+\>)+)')
        self.tagname = re.compile(',\s*<(\w*)>((?:,\s*\<\w+\>)*)')
    def _parse_tags(self, line):
        l = []
        while True:
            m = self.tagname.match(line)
            #print('>', m.group(2), '<', sep='')
            l.append(m.group(1))
            if len(m.group(2)) == 0: return l
            line = m.group(2)
    def __iter__(self):
        return self
    def next(self):
        while True:
            line = next(self.fd).strip()
            if not line.startswith('#'): return line
            m = self.line.match(line)
            if m:
                self.conf[m.group(1)] = self._parse_tags(m.group(2))
    def __next__(self):
        return self.next()

class Parser:
    def __init__(self, conf = None):
        self.conf = conf
    def parse(self, fd):
        flt = DefFilter(fd, self.conf)
        rd = csv.reader(flt)
        root = ET.Element('tags')
        for row in rd:
            if len(row) ==2:
                name = 'name'
                tag = row[0].strip()
                try:
                    name = flt.conf[tag][0]
                except:
                    pass
                elt = ET.SubElement(root, tag, { name: row[1].strip() })
            elif len(row) > 2:
                tag = row[0].strip()
                x = ET.SubElement(elt, tag)
                tags = [ 'param_' + str(i+1) for i in range(len(row) - 1)]
                try:
                    tags = flt.conf[tag]
                except:
                    pass
                for i, val in enumerate(row[1:]):
                    y = ET.SubElement(x, tags[i])
                    y.text = val.strip()
        self.root = root
    def parsefile(self, filename):
        with open(filename) as fd:
            self.parse(fd)
    def prettyprint(self, fd, addindent = '  ', newl = '\n'):
        minidom.parseString(ET.tostring(p.root)).writexml(fd, newl = newl,
                                                          addindent=addindent)

You can then use:
with open('in.csv') as in, open('out.xml', 'w') as out:
    p = Parser()
    p.parse(in)
    p.prettyprint(out)

A: Consider using an xml module to build the xml document and not concatenate string representation of elements. In this way, you can read the csv line by line adding children elements and text values conditionally according to line position. Below adds generic <tags> for grandchildren:
import csv
import lxml.etree as ET

# INITIATE TREE
root = ET.Element('tags')

# READ CSV LINE BY LINE
cnt = 0; strtype = ''
with open('Type1.csv', 'r') as f:
    csvr = csv.reader(f)
    for line in csvr:
        # CONDITIONALLY ADD CHILDREN ATTRIB OR ELEMENTS
        if len(line) > 1:
            if cnt==0 or line[0] == strtype:
                strtype = line[0]
                typeNode = ET.SubElement(root, strtype.strip())
                typeNode.set('attr', line[1].strip())

            if cnt >= 1:
                typesomeNode = ET.SubElement(typeNode, line[0].strip())
                ET.SubElement(typesomeNode, 'tag').text = line[1].strip()
                ET.SubElement(typesomeNode, 'tag').text = line[2].strip()
                ET.SubElement(typesomeNode, 'tag').text = line[3].strip()
        else:
            cnt = 0
            continue
        cnt += 1

# CONVERT TREE TO STRING W/ INDENTATION
tree_out = ET.tostring(root, pretty_print=True)
print(tree_out.decode("utf-8"))

To replace generic tags with <id>, <name>, <param>, <param1>... etc., consider XSLT (the transformation language used to redesign/restructure xml documents). And Python's lxml module can run such XSLT 1.0 scripts. This is one approach to avoid the many conditionals on first read above:
xslt_str = '''
            <xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
            <xsl:output version="1.0" encoding="UTF-8" indent="yes" />
            <xsl:strip-space elements="*"/>

              <!-- Identity Transform -->
              <xsl:template match="@*|node()">
                <xsl:copy>
                  <xsl:apply-templates select="@*|node()"/>
                </xsl:copy>
              </xsl:template>

              <xsl:template match="TYPESomeTag|TYPE2SomeTag">
                <xsl:copy>
                  <id><xsl:value-of select="tag[1]"/></id>
                  <name><xsl:value-of select="tag[2]"/></name>
                  <param><xsl:value-of select="tag[3]"/></param>
                </xsl:copy>
              </xsl:template>

              <xsl:template match="TYPEAnothertag|TYPE2Anothertag">
                <xsl:copy>
                  <param_1><xsl:value-of select="tag[1]"/></param_1>
                  <param_2><xsl:value-of select="tag[2]"/></param_2>
                  <param_3><xsl:value-of select="tag[3]"/></param_3>
                </xsl:copy>
              </xsl:template>
            </xsl:transform>
'''
# PARSE XSL STRING (CAN ALSO READ FROM FILE)
xslt = ET.fromstring(xslt_str)
# TRANSFORM SOURCE XML WITH XSLT
transform = ET.XSLT(xslt)
newdom = transform(root)
print(str(newdom))

Output (for TYPE1 but also similar for TYPE2)
<?xml version="1.0"?>
<tags>
  <TYPE attr="Name_1">
    <TYPESomeTag>
      <id>1</id>
      <name>2</name>
      <param>3</param>
    </TYPESomeTag>
    <TYPESomeTag>
      <id>4</id>
      <name>2</name>
      <param>5</param>
    </TYPESomeTag>
    <TYPEAnothertag>
      <param_1>a</param_1>
      <param_2>b</param_2>
      <param_3>c</param_3>
    </TYPEAnothertag>
  </TYPE>
  <TYPE attr="Name_2">
    <TYPESomeTag>
      <id>1</id>
      <name>2</name>
      <param>3</param>
    </TYPESomeTag>
    <TYPESomeTag>
      <id>4</id>
      <name>2</name>
      <param>5</param>
    </TYPESomeTag>
    <TYPEAnothertag>
      <param_1>a</param_1>
      <param_2>b</param_2>
      <param_3>c</param_3>
    </TYPEAnothertag>
  </TYPE>
</tags>

A: You need to store parameters from commented line to dictionary to process
#TYPESomeTag, id, name, param
into
tags = {"TYPESomeTag":["id", "name", "param"]}
this way you can parse every comment line without handcoding parameters list.
Below is sample code to process your given csv.
import csv

csvFile = 'sample.csv'

nextLineIsTagName = False
tags = dict()
tag = None
tagOpened = False

for row in csv.reader(open(csvFile), skipinitialspace=True):
    if not row: #skipping empty lines
        continue

    if row[0][0] == '#': #processing types definition within csv comment block
        if tagOpened: #there is opened tag so we need to close it
            print "</" + tag + ">"
            tags = dict()
            tag = None
            tagOpened = False

        if (len(row) == 1) and 'Definition' in row[0]:
            nextLineIsTagName = True
            continue

        if nextLineIsTagName and len(row) == 2:
            tag = row[0][1:]
            nextLineIsTagName = False
            continue

        if not nextLineIsTagName and len(row) > 1:
            tags[row[0][1:]] = row[1:] #adding 'parameters' to 'tag' dict entry

    else: #processing csv data
        if len(row) < 2:
            continue

        if row[0] == tag: #we need to start new TYPE element
            if tagOpened: #close previous tag before open new one
                print "</" + tag + ">"

            print "<" + tag, row[1] + ">"
            tagOpened = True
        else: #we need to add parameters to open TYPE element
            print "\t<"  + row[0] + ">"
            for i in range(1, len(row)): #iterating over parameters
                print "\t\t<" + tags[row[0]][i-1] + ">" + row[i] + "</" + tags[row[0]][i-1] + ">"
            print "\t</" + row[0] + ">"

if tagOpened: #closing last tag at end of file
    print "</"+ tag + ">"

redpajama_set_name: RedPajamaStackExchange


The airport is located within easy driving distance of all the Sunshine Coast's major towns. Situated in Marcoola, it is 10 minutes drive from Coolum and only 15 minutes from Maroochydore/Mooloolaba. It takes approximately 40 minutes to drive to Caloundra and Noosa, and just over an hour to reach Gympie or Brisbane.
Suncoast Cabs operate out of the Sunshine Coast Airport. If you would like a meet-and-greet, or require a baby capsule or child seat, you will need to contact Suncoast Cabs in advance.
Shuttle services to and from Sunshine Coast Airport are split between Sun-Air and Henry's Airport Shuttle. Sun-Air meets every flight and provides transfers to destinations south of the aiport (from Twin Waters to Pelican Waters). Henry's Airport Shuttle provides shuttle transfers north of the airport to Coolum and Noosa. Visit the Sun-Air and Henry's Airport Shuttle websites for more information and contact details.
Another operator in the area is Con-x-ion Sunshine Coast, offering pre-booked seats on a coach ot tailor made transfers and group tours. Visit the Con-x-ion Sunshine Coast website to find out more.
If your preference is luxury, however, you may be interested in the stylish service offered by Noosa V.I.P. Limousines. They provide chauffeured transport in stretch limos, sedans and luxury cars. Check out the Noosa V.I.P. Limousines website for more information.
Parking facilities are located adjacent to the terminal building. Both short and long term parking available but there is no undercover parking. Both of the long term car parks are fenced and locked overnight after the last departure.
Parking is free up to seven minutes. It will then cost you A$4.00 for up to 2 hours, increasing to A$18.00 for a 12-24 hour period. Rates vary, so it's worth visiting the Sunshine Coast Airport's website for further information.
Please note that parking outside the terminal is not permitted, so a drop-off will cost you the minimum A$4.00 for the short term car park. Passengers may be picked up at the front of the terminal only if they're waiting at the kerbside and ready to depart.


text:
import { Component } from '@angular/core'

@Component({
    template: '<app-root></app-root>',
})
export class RootComponent { } // eslint-disable-line @typescript-eslint/no-extraneous-class

redpajama_set_name: RedPajamaGithub


Today, there is a whole generation of adolescents and teenagers that have never even seen a VHS cassette, let alone could they figure out how to get a VCR to work. For a closer analysis about the history of the VCR and it's impending demise, please see a recent article posted in Forbes.
Is the Death of the VCR Good Riddance or Not?
I'm a little torn on this one because on the one hand, I think it's great to see advances in technology and for the old to give way to the new. But, on the other hand, I grew up as a child during the heyday of VHS. I remember how fun it was to go to the video store with my parents on a Friday or Saturday night to pick up a video cassette and some snacks. And, how exciting it was when the video store called to say the movie we reserved had been returned.
Today, video rental stores have all but disappeared; gone are the trips to the local video store. Now, movie night takes nothing more than a few clicks of the remote control, or brief stop by the kiosk at your grocery store.
DVDs and On Demand have made home entertainment easier and more accessible, and with high definition, the quality is undeniably better. However, I'm not quite ready to say good riddance to the VCR. It played a memorable part of my childhood and I'm not sure that my children will enjoy renting a movie right from our living room as much as I enjoyed a trip to the video store with my parents and siblings. And let's not forget that the patience it took to rewind a VHS is something that is completely lost on many youth today.
Next Next post: Please Watch!!!


text:
Lee Min-ji may refer to:
Lee Min-ji (actress, born 1984)
Lee Min-ji (actress, born 1988)
Lee Min-ji (Miss Korea) (born 1991)
Minjee Lee (born 1996), Australian professional golfer
 Lee Min-ji (weightlifter) (born 1999), South Korean weightlifter

redpajama_set_name: RedPajamaWikipedia


Global automotive fasteners market is segmented on the basis of type, material, distribution channel, end-use, and region. On the basis of type, the market has been segmented as threaded and non-threaded. On the basis of material, the market has been segmented as iron, aluminum, stainless steel, nickel, and others. On the basis of distribution channel, the market has been segmented as OEM and aftermarket. On the basis of end-use, the market has been segmented as removable, semi-permanent, and permanent.
Solar Energy and Battery Storage System Market by Battery Type (Lead-Acid, Li-ion, NaS) End-User (Utility, Industrial & Commercial, Residential) by Solar Technology, Connection Type, Application, & Region – Till 2023.
Solar PV Tracker Market Research Report by Solar Power Type, by Tracking type, Drive system, By End-User, Forecast till 2023.
One of the other main objectives of a solar tracker is to consume less energy and maximize the efficiency of operations. This is mainly because the solar trackers are separate energy consuming entities added to solar panels for increasing their performance. Moreover, it is essential that solar trackers offer reliability of operations under different operational conditions, as any impact on tracker system performance can have a substantial impact on solar panel or power systems performance as a whole.
Drilling Tools Market Research Report by Location, by Type, and by Region – Forecast till 2023.
Enhanced Oil Recovery Market 2018 Global Industry Analysis To 2023 by Technology Type, by Application type, and by Region – Forecast till 2023.
Global Drilling Waste Management Market Research Report: Information by Waste Type (Waste Lubricants, Contaminated water-based muds, Contaminated oil-based muds, Spent Bulk Chemicals), Application type (Onshore, Offshore), Services– Forecast till 2023.
The drilling waste management market is segmented on the basis of waste type as waste lubricants, contaminated water-based muds, contaminated oil-based muds, spent bulk chemicals, and others. Most of these waste types have possible environmentally harmful constituents such as heavy metals, organics, aromatic hydrocarbons, inorganic salts. These materials have the potential to impact the environment negatively.
Global Drilling Waste Management market is projected to witness ~ 5.64% CAGR during the forecast period.
Global Smart Transformers Market Research Report: Information by Type (Power, Distribution, Specialty and Instrument), Component (Converters, Switches, Hardware), Application (Traction Locomotive, Smart Grid, Electric Vehicle Charging) –Forecast till 2023 .
Global Screw Compressor Rental Market by Type (Oil-Injected Screw Compressor, Oil-Free Screw Compressor), Portability (Stationary, Portable), Stage (Single-stage, Multi-stage), End-user and Region – Forecast till 2023.


text:
Miscues hang over Wildcats win
KYLE ST. JEAN
Oct 28, 2012 at 12:01 AM Oct 28, 2012 at 5:18 AM
NFA beats Bacon, 31-6
There was a sense of melancholy as the Norwich Free Academy football team quietly kneeled in a huddle on Bacon Academy's field.
Interim head coach Mike Murphy broke the silence.
"Remember, it's about Griswold now," he told the players. "Put (Saturday's game) behind you and think about (next week against) Griswold."
It was a peculiar sight for a team that had just won, 31-6. The Wildcats knew they had let Bacon (1-5) frustrate them, as the Bobcats held their own throughout the game despite the score. Had Bacon managed to capitalize on a few key plays — and a few key Wildcat mistakes — the Bobcats could have had a larger foot in the door.
Murphy, the NFA defensive coordinator, filled in as head coach for Jemal Davis, after Davis chose to take a one-game suspension for breaking the Connecticut Interscholastic Athletic Conference's 50-point cap. Davis did not attend Saturday's game.
"We made some mistakes, but overall we are looking to improve ourselves," Murphy said. "We always have to move on and look to the next opponent. I take our hats off to (Bacon). They played us tough. They did a great
job against us."
The majority of the Wildcats' scores came off the run. Ramel Williams scored on NFA's first drive of the game, completing a 9-yard rush. Later in the quarter, quarterback Joey Paparelli ran in a 43-yard score, and Marcus Outlow (10 carries, 110 yards) returned a 75-yard punt to make it 21-0 at half. Outlow tacked on another 41-yard touchdown to begin the third quarter, and Elisa Formiglio kicked a 24-yard field goal in the fourth.
At times, NFA (7-0) looked like the undefeated team it is, though it wavered throughout the game. The Bobcats held Paparelli to an 0-for-8 passing day. Additionally, Bacon forced NFA to five 4-and-outs, while holding the Wildcats to 10 points in the second half.
"It wasn't a good win for us," Paparelli said. "We need to play a lot better. We got in a little funk at the beginning of the game. There were a lot of miscues. ... It's not something that champions do."
Bacon Academy coach Brian Enrique had hoped his team could have capitalized better.
"We looked at them on film. They have tremendous athletes, but you can take advantage of some of the things that they do and our gameplan was to do that," he said. "I knew we were going to have to do everything perfectly, and unfortunately we didn't do that. The game was tough and I know a lot closer then a lot of people expected, but if you go back and look at the game, we're a couple big plays and a couple dropped passes from that last possession being meaningful."
In the second quarter, Steve Kardys had a 40-yard rush that brought Bacon five yards from the end zone, but the Bobcats couldn't manage a score. Taylor Boozer intercepted Paparelli in the third quarter and brought the ball to the NFA 26, but again couldn't get anywhere.
Bacon's only score came two minutes into the fourth, after quarterback Nate Kozlowski (6-for-13, 99 yards) found Ryan Duclos with a 73-yard pass, putting the Bobcats on NFA's 2. Two plays later, Aaron Stolzman ran in the 1-yard touchdown. Bacon recovered an onsides kick and again threatened, but was stopped at the 7-yard line.


I know that this forum is Spiritual Pathways which deals with RHP, but some MHP and LHP magick is needed here please admin and mods.
This is one forum that can do with this sort of discussion too.
In the meantime, what I will do is discuss all this in the General Magick board which is open to our members.


text:
Rest of Italy
Michelin Starred
Bar & Bakeries
Ice Cream Shops
Trattorias
Rooftop & Terrace
High-Tech & Mobility
Daniela Sirtori
From the same editor
La Tasteria
Giacomo Tabaccheria
Wooding Bar
The wild philosophy of world's first endemic bar
Via Garigliano 8,
Call + 39 391 4744329
It's clear that we're living in a new golden age of mixology. The old coke & rum in a plastic cup is now a heresy, and we have become accustomed to quality cocktails, with selected ingredients, expertly blended by mixologists who seem more like alchemists than barmen. In the city, there are always new and interesting places that follow the latest trends of late drinking, but the Wooding Bar (or Wood * ing, as its creators stylize it) is definitely the most original, extreme and courageous that we've ever tried.
The minds of Wood * ing Bar are Valeria Mosca Caglio, already known in the world of radical gastronomy and a great expert in foraging, namely the collection, in the absolute respect of the environment, of edible, wild plants, and Stefano Tosoni that aptly curates its concept and developement. After having founded in 2010 the Wood * ing Lab , a laboratory of research and experimentation on wild food, and after writing in 2016 the book "Wild Mixology", a recipe book and a technical manual for creating cocktails with "wild" ingredients, Valeria decided to devote to open her own place devoted to wild mixology.
The bar is located in the Island area, where a former paint factory once was, and is the first endemic bars in the world. In botany, the adjective "endemic" means a typical and exclusive species of a given territory. In fact, the Wood * ing Bar offers drinks made with wild, never grown, ingredients: roots, herbs, algae, moss and bark collected in uncontaminated areas, respecting ecosystems, and worked by hand.
Just step inside to understand that this is an unusual and different bar. Furnishing and interiors perfectly reflect the wild philosophy: simple and essential environment, soft colors, chipped walls, long tables in Lebanon cedar wood, paintings and details from the natural and botanical world. Even before ordering, with a sprig of spruce, it helps to prepare your mouth for the best tasting experience because it cleanses the palate from any other flavors – as they explain – and is also good, considering that the spruce contains eight times more vitamin C than a grown lemon.
The drink list is divided into two sections. The first, classic wild, classic cocktails, from Spirits to Moscow Mules, revisited with wild ingredients. The second, more extreme, is instead dedicated to wild cocktails, which are identified with ingredients and are listed and explained on the menu. Unless you really are a botany scholar, you will be able to discover new plants, herbs and methods of fermentations. We opted for the drink #1, based on mezcal and prepared with kombucha of bramble leaves, dirt of fermented roots and castalda- an extremely pleasant, fresh and delicate cocktail.
The dishes are accompanied by a plate of small snacks – the menu offers both tastings and regular dishes. Of course, the food follows the wild philosophy, too. There is a strong use of wild herbs, subsistence flours and cooking techniques, such as drying and smoking are preferred to the traditional ones.
An unusual cocktail for anyone who wants to try something different and above all, an innovative philosophy for an intelligent drink that supports the environment.
We can't. That's why every week we share the best experiences milan has to offer.
Tuesday 12:30 14:30
Wednesday 12:30 14:30 19:00 0:00
Thursday 12:30 14:30 19:00 0:00
Friday 12:30 14:30 18:00 2:00
Saturday 18:00 2:00
Sunday 11:30 16:30 18:00 00:00
Bombarded daily by information of all kinds, transmitted by an ever-increasing number of communication tools, we sometimes look for a simplification, a reliable source, a guide. Flawless Milano was born from this need, and tells the best experiences to have in Milan with style, precision and personality.
The Editorial Staff


Discussion in 'Development' started by notdrewdev, Mar 21, 2019.
however, when I update the players rank via mysql, their permissions don't reset and I'm not too sure how to do so. What solutions do y'all recommend?
// I'm guessing you are doing this in player class.
And also, kind of off topic, I didn't know you were still in this community, Drew.
How you want the permission to reset? Remove the permissions of previous rank?
Yes, I update the arrays.
I did try that, but the only way it works is if I use a have a delayed task to wait for the mysql task to update, which I'd rather not want to wait for.
Reset permissions as in attachmen->clearPermissions()?


Tolkowsky platinum 1ct diamond solitaire ring, combined with a rare clarity and colour of HI SI2. Each Tolkowsky diamond comes with a gemological certificate. Browse our diamond buyer's guide for more information on diamond quality.


text:
'use strict';
// Refs: https://github.com/nodejs/node/issues/548
require('../common');
const assert = require('assert');
const vm = require('vm');
const context = vm.createContext();

vm.runInContext('function test() { return 0; }', context);
vm.runInContext('function test() { return 1; }', context);
const result = vm.runInContext('test()', context);
assert.strictEqual(result, 1);


A recent amendment to the Real Estate License Law has shortened the period of time within which, by merely paying a fee, you may reinstate an expired license. Now, if you fail to renew your license by June 30 of any year, you only have until the following December 31 (i.e., six months) to reinstate it merely by paying the prescribed fee.
The new reinstatement fee is $55 regardless of how long your license has been expired (whether one day, one year, three years, etc.).
If your license has been expired for more than six months but not more than three years, you must either (1) pass the current license examination; or (2) complete the 67-hour Salesperson Prelicense Course within one year before applying to reinstate a salesperson license (or the 60-hour Broker Prelicense Course to reinstate a broker license); or (3) possess an active real estate license in another state (a broker license to reinstate a North Carolina broker license).
If your license has been expired for more than three years, you must satisfy all prelicense education and examination requirements unless you hold a real estate license in another state (a broker license to reinstate a North Carolina broker license).
Most persons who allow their licenses to expire simply forget to renew them on time. Others think that licenses on inactive status do not require renewal each year. And still others change real estate firms and/or their residence addresses without notifying the Commission. If you place your license on inactive status, you must renew it each year and pay the renewal fee to preserve the right to activate it later (after making up any continuing education deficit). Also, be careful to notify the Commission promptly of any business or residence address change so you will receive your renewal notice. Otherwise, you may find yourself having to repeat a prelicense course and/or retake the license examination.


When being confronted with the diagnosis of renal failure and the need for dialysis, you and your loved ones are faced with a number of questions and life-changing challenges. Thanks to modern medicine and the wide range of options for advice and support you will soon become more secure in your everyday life. Although there will be changes to your daily routine, the quality of your life should not suffer as a result.
We have compiled the most important topics regarding renal failure, treatment options and living with dialysis on our website, to support you and your relatives in all aspects of daily life. This includes helpful information material about diet and nutrition but also other areas such dialysis while being on holiday.


Need to pose a questions, give criticisms and comments on this website? Then contact me.
Obviously we cannot respond to hundreds of questions of a private nature about your own condition, nor is it perhaps sensible but, where pertinent, we may make general suggestions, time permitting! This is best done below, or via the webpages where you'll find a place to pose a question on most pages.
Thousands of people are reading this website. 70 000 per month! I hope you understand!
Shoot! BUT FIRST, please make absolutely sure that your have your email address CORRECT. Check it again! AND AGAIN! And if you have a spam guard, make sure that my email address is white-boarded / enabled.
That means, and this is important, until you've white listed your email address you'll get a reply that it hasn't been delivered. Never fear, just scroll down on that return email and you'll be guided how to white list your address; really, it's simple.
If you still don't get a reply, recheck your email address.
"Please give me exercises to do at home for pinched nerves in the spine."
Please only fill in Contact if you want a reply.
Lower back pain - disc problems or glutes?
Tingling, paresthesias in medical terms, are a common complaint in Chiropractic forums and at the Chiropractic Coalface ... they speak of an irritation of the nervous system. That could be a pinched nerve in the neck, but it could be in the brain, a sign of diabetes which affects the nervous system, and occasionally of serious neurological diseases like MS.
As they old saying goes: if you hear hoofbeats, don't first think of zebras! Think horses. Tingling in arms and hands does not mean you have MS! It's more likely an irritated nerve in the spine.
To go from CONTACT to PAIN SYNDROMES / Chiropractic Conditions treated by Chiropractors on a regular basis.
Pose a question, by all means make a comment.
NOTICE BOARD ... messages from me to you.


text:
News Sports Business Opinion Tribal News Obituaries eNewspaper Legals Life
Selvig proud of women's basketball's fight for women's healthcare
Robin Selvig
For the Tribune
In a historic partnership, the WNBA's Seattle Storm hosted a "Stand with Planned Parenthood" event during their nationally televised game on ESPN 2 on Tuesday. This marks the first time ever, a professional sports franchise partnered with Planned Parenthood.
As a women's basketball coach, I could not be prouder to see our sport take a stand and be a leader in the fight for women's health care.
One in five women in this country have relied on Planned Parenthood for health care. The women who go there don't go to make a political statement; They go for health care. That's why I stand with Planned Parenthood. I want to ensure that everyone has access to the care they need –– and that's what Planned Parenthood does.
But right now, that health care is at risk for millions, including Planned Parenthood patients. Access to birth control, cancer screenings, breast exams, and STI testing and treatment for Montanans and women across this country is at risk.
In communities across the country, including in rural areas in Montana, Planned Parenthood is the only source of contraceptive and reproductive health care for women. Keeping its doors open ensures that access to contraception, that unintended pregnancies are prevented, that planned pregnancies are healthy and that parents in Montana are given the assurance they need in order to raise a family.
Without it, many in Montana would have nowhere else to go.
And it's not just Montana. Planned Parenthood has impacted women's lives around the country. For Seattle Storm Owner Dawn Trudeau, supporting Planned Parenthood is personal –– she is a former Planned Parenthood patient. So is Imani Boyette, a player on the opposing team, Chicago Sky.
End of an era: Robin Selvig announces retirement
I couldn't be prouder to see the owners of the Seattle Storm speak out, to see Sue Bird, Breanna Stewart and other leading players in this sport stand with Planned Parenthood, and to hear that the WNBA president is entirely supportive of this work.
It makes me proud to be a part of women's basketball, and it makes me proud to stand with Planned Parenthood.
While this is just a sport, and this event is just a game, we can make it more than that.
As athletes and coaches, we have the opportunity to steer our elected officials back on track in supporting and advocating for women's health. I hope the Seattle Storm's leadership on this issue encourages other athletes, coaches, sports franchises and teams to join and stand with Planned Parenthood.
RobinSelvig, recently retired, was head coach of the Lady Griz for 38 seasons and is the eighth winningest coach in women's college basketball history.


text:
ACA Consumer Protections
Federal Poverty Level Table
What's New for 2022
On Private Health Insurance Coverage & The Health Insurance Marketplace
Individuals with no coverage
Individuals with coverage
Coverage for small employers
Post enrollment issues
What is "minimum essential coverage" and why do I need it?
Individuals with no coverage | Individual Responsibility Requirement (Individual Mandate)
"Minimum essential coverage" refers to insurance that provides at least the "minimum" level of coverage, as defined by the Affordable Care Act. The ACA's individual mandate requires people to maintain minimum essential coverage. Further, whether you have access to or are enrolled in a plan that qualifies as minimum essential coverage affects your ability to receive premium tax credits and whether or not you may qualify for most special enrollment periods.
The following types of coverage will allow you to comply with the individual mandate and qualify for most special enrollment periods if you lose it.
Employer-sponsored coverage, including COBRA continuation coverage and retiree coverage
Coverage purchased in the individual market, including a plan purchased through a state or the federal health insurance marketplace
Grandfathered health plans, even if they do not cover services like prescription drugs
Medicare Part A coverage and Medicare Advantage plans
Most Medicaid coverage
Most Children's Health Insurance Program coverage
Veterans health coverage administered by the Veterans Administration that are comprehensive
Most types of TRICARE (coverage for members of the military)
Coverage for Peace Corps volunteers
Refugee Medical Assistance from the federal Administration for Children and Families
Department of Defense health benefit program for civilian employees known as "Non Appropriated Fund" personnel
Certain self-funded student health coverage and other coverage may be recognized as minimum essential coverage, see this list
Insurers may provide individuals with a Summary of Benefits and Coverage, which uses a standard format to outline the benefits, cost-sharing and coverage limits of plans. The Summary of Benefits and Coverage must also state whether the plan meets minimum value and counts as minimum essential coverage.
Some types of coverage sold outside a health insurance marketplace do not qualify as minimum essential coverage, such as discount plans, short-term policies, or policies that cover only cancer. These kinds of products are sometimes referred to as "excepted benefits." Coverage under these options will not satisfy the individual mandate or the requirement to have coverage to qualify for most special enrollment periods. Further, you cannot use premium tax credits to purchase these plans.
If you are uncertain whether your plan qualifies as minimum essential coverage, for purposes of complying with the individual mandate, qualifying for a special enrollment period, or receiving premium tax credits, contact your employer's human resources department or your health insurer. (26 U.S.C. § 5000A (f); 45 C.F.R. § 156.602).
minimum essential coverage
600 New Jersey Avenue, NW
Support for this Guide was provided by the Robert Wood Johnson Foundation. The views expressed here do not necessarily reflect the views of the Foundation.


Discussion in 'News' started by HiMyNameIsAJ, Apr 11, 2014.
New post editor with drag and drop and image paste support!
Enjoy this new forum and please report website related bugs to me (@HiMyNameIsAJ) by private message.
Kizkuto, Zackery, MC_Scout and 36 others like this.
Thanks for updating the website.
You are truly out of this website (because that would just be weird if I said out of this world) developer.
YES! I posted on the first page! I'm so happy the site is back up!
Thank for all the hard work guys!
Xenohs, speedcameras24, Brittany and 2 others like this.
Good thing your a pro!
If i was, it wouldn't take 5 hours .-.
TheMint, AbzillaPower_, Brittany and 4 others like this.
How do you edit titles?


text:
Q: BigQuery - Question about retrieving previous value I have one question about how to fill column looking for previous values.
My problem is that the column "abandoned" need to follow some rules to be filled. The rules are:

*

*The column "abandoned" should be filled with "yes" or "no", choosing one value or another. Never i get two "yes" values followed.

*Always **after ** the column "date_hour_canceled_negotiation" is filled, the column "abandoned" should be filled with "yes" and when the column "date_hour_negotiation" or "date_hour_canceled_negotiation" is filled, in same row, the column "abandoned" should be filled with "no".

Could someone help me please? Any help i appreciate a lot.
I would like to do something like this:

contract
date_hour_access
date_hour_negotiation
date_hour_canceled_negotiation
status_negotiation
abandoned

111111
2022-12-01 10:20:00

yes

111111
2022-12-02 10:20:00

no

111111
2022-12-03 10:20:00

yes

111111
2022-12-04 10:20:00
2022-12-04 10:30:00

active
no

111111
2022-12-05 10:20:00

2022-12-05 10:30:00
canceled
no

111111
2022-12-06 10:20:00

yes

111111
2022-12-07 10:20:00

no

A: One way of approaching this problem is to treat it as a gaps and islands:

*

*compute partitions of records till a "canceled" status is encountered, using a running sum

*compute a ranking for each new partition and assign 'yes' and 'no' to values of odd and even ranking numbers

*force 'no' on records with the "canceled" status

WITH cte AS (
    SELECT *, SUM(CASE WHEN status_negotiation = 'canceled' THEN 1 ELSE 0 END) OVER(PARTITION BY contract ORDER BY date_hour_access) AS partitions_,
              CASE WHEN status_negotiation = 'canceled' THEN 1 ELSE 0 END AS canceled
    FROM tab
)
SELECT *, CASE WHEN canceled = 1
                 OR MOD(ROW_NUMBER() OVER(PARTITION BY contract, partitions_, canceled ORDER BY date_hour_access), 2) = 0
               THEN 'no' ELSE 'yes'
          END AS abandoned
FROM cte
ORDER BY contract, date_hour_access


Statistics have shown that their are approximately 42 marijuana users, 18 people abusing prescription drugs, and 6 cocaine addicts that live in Hanna, Wyoming.
When you realize that you require help with a substance abuse problem you have made the first and hardest step toward sobriety, however the next step of finding that help may be a intimidating task if you do not know where to look. This page contains a list of public, private, non-profit, and gay drug rehab programs and intervention specialists near Hanna, Wyoming.
Hanna is located in Carbon County and contains the following zip codes: 82327.


text:
Q: SQL group by is bringing lots of duplicates I'm trying to group my data by OccDate, ParkingContextType, AuthorityId and of course, i would like to measure each sessions for each date/contexttype etc... However, I`m also trying to calculate the sum of sessions between a specific hour 8-18 for each date,ParkingContextType & AuthorityId.
The problem here is that 1 specific date is duplicated a lot and also the authority id etc... Something I'm doing wrong here and I cannot spot the problem,
Any one who can help me please?
Here is the SQL
WITH ParkeonCTE
AS
(
SELECT
    OccDate = CONVERT(DATE, OC.LocalStartTime),
    TotalOccSessions = COUNT(OC.SessionId),
    AuthorityId,
    TotalOccDuration = ISNULL(SUM(OC.DurationMinutes),0),
    TotalNumberOfOverstay = SUM(CAST(OC.IsOverstay AS INT)),
    TotalMinOfOverstays = ISNULL(SUM(OC.OverStayDurationMinutes),0),
    (CASE
        WHEN OC.OspId IS NULL THEN 'OffStreet' ELSE 'OnStreet'
        END
    ) AS ParkingContextType,
    SUM(CASE
        WHEN CAST(OC.LocalStartTime AS TIME) >= '08:00:00'
        AND CAST(OC.LocalStartTime AS TIME) <= '18:00:00'
            THEN 1
            ELSE 0
     END
    ) AS TotalRestrictedSessions
FROM Analytics.OccupancySessions AS OC
WHERE OC.AuthorityId IS NOT NULL
GROUP BY  CONVERT(DATE,OC.LocalStartTime), OC.AuthorityId,OC.OspId
 )
  SELECT OC.OccDate,
   OC.ParkingContextType,
   OC.AuthorityId,
   OC.TotalRestrictedSessions,
   SUM(OC.TotalOccSessions) AS TotalOccSessions,
   AVG(OC.TotalOccDuration) AS AvgOccMinutesDuration, -- wrong
   SUM(OC.TotalOccDuration) AS TotalOccDuration,
   SUM(OC.TotalNumberOfOverstay) AS TotalNumberOfOverstay,
   SUM(OC.TotalMinOfOverstays) AS TotalMinOfOverstays,
   CAST(AVG(OC.TotalMinOfOverstays) AS decimal(10,2)) AS AvgMinOfOverstays -- wrong
  FROM ParkeonCTE AS OC
  GROUP BY OC.OccDate, OC.AuthorityId, OC.ParkingContextType,OC.TotalRestrictedSessions
  ORDER BY OC.OccDate DESC

This is the end result, which is wrong...I should have less OccDate, with Two parkingcontexttype OnStreet/OffStreet for each authority id... But apparently I have loads of them.

And a minimal result it should be:
OccDate    ParkingContextType    AuthorityId .. (All of the calculated columns)
2019/11/18 OnStreet              32432-3424-32423
2019/11/18 OffStreet             32432-3424-32423

A: You should use Aggregated function
Change SUM(OC.TotalRestrictedSessions) in Select and Remove TotalRestrictedSessions From Group By
WITH ParkeonCTE
AS
(
 SELECT
    OccDate = CONVERT(DATE, OC.LocalStartTime),
    TotalOccSessions = COUNT(OC.SessionId),
    AuthorityId,
    TotalOccDuration = ISNULL(SUM(OC.DurationMinutes),0),
    TotalNumberOfOverstay = SUM(CAST(OC.IsOverstay AS INT)),
    TotalMinOfOverstays = ISNULL(SUM(OC.OverStayDurationMinutes),0),
    (CASE
        WHEN OC.OspId IS NULL THEN 'OffStreet' ELSE 'OnStreet'
        END
    ) AS ParkingContextType,
    SUM(CASE
        WHEN CAST(OC.LocalStartTime AS TIME) >= '08:00:00'
        AND CAST(OC.LocalStartTime AS TIME) <= '18:00:00'
            THEN 1
            ELSE 0
     END
    ) AS TotalRestrictedSessions
 FROM Analytics.OccupancySessions AS OC
 WHERE OC.AuthorityId IS NOT NULL
 GROUP BY  CONVERT(DATE,OC.LocalStartTime), OC.AuthorityId,OC.OspId
)
SELECT OC.OccDate,
   OC.ParkingContextType,
   OC.AuthorityId,
   SUM(OC.TotalRestrictedSessions),
   SUM(OC.TotalOccSessions) AS TotalOccSessions,
   AVG(OC.TotalOccDuration) AS AvgOccMinutesDuration,
   SUM(OC.TotalOccDuration) AS TotalOccDuration,
   SUM(OC.TotalNumberOfOverstay) AS TotalNumberOfOverstay,
   SUM(OC.TotalMinOfOverstays) AS TotalMinOfOverstays,
   CAST(AVG(OC.TotalMinOfOverstays) AS decimal(10,2)) AS AvgMinOfOverstays
  FROM ParkeonCTE AS OC
  GROUP BY OC.OccDate, OC.AuthorityId, OC.ParkingContextType
  ORDER BY OC.OccDate DESC


text:
Posts by Month: January 2020
Iconic Acton Scott Shire Horse has sadly passed away
It is with great sadness that we have to announce that our beloved Shire Horse, Charlie, has died. He has been a…
Shropshire Council responds to concerns about county's roads
To help it repair and maintain the county's roads, Shropshire Council is making changes to its highways service, putting additional resources into…
Opportunity for firms to support Shrewsbury Riverside development work
Shropshire Council has published a tender inviting companies to bid to support the development of Shrewsbury's Riverside area. Shropshire Council took the…
One-way closure of London Road in Shrewsbury for BT cable work
A one-way – eastbound – closure of London Road in Shrewsbury is set to be in place from Monday 17 February [2020] …
Shrewsbury's park and ride service to operate every 10 minutes – as plans considered for a new site
Buses serving Shrewsbury's Meole Brace park and ride site will run every 10 minutes on a permanent basis from next Monday [3…
Shropshire Council invests £5m improving more than 30 roads
Twenty six roads across Shropshire are to be resurfaced before the end of March [2020], as part of a £5m package of…
News from our partners: End of Life and palliative care Healthwatch Shropshire report published
News from our partners Healthwatch Shropshire Healthwatch Shropshire has just published a report about how end of life care is working in…
Evolving Shropshire: new exhibition at Shrewsbury Museum & Art Gallery
Shropshire has some the most varied geology in the world. A new exhibition at Shrewsbury Museum & Art Gallery – Evolving Shropshire…
News from our partners: Wuhan novel coronavirus – what you need to know
News from our partners Public Health England For the latest information and advice relating to the Wuhan novel coronavirus (WN-CoV) please visit…
News from our partners: Paul Lindley OBE and local businesspeople lead panel on The Evolution of the Workplace
News from our partners University Centre Shrewsbury Paul Lindley OBE, founder of the hugely successful organic food company, Ella's Kitchen, child welfare…


Make your Kansas City Royals Themed Bedroom complete! Team-Bedding.com has the best selection and lowest prices for Kansas City Royals comforters, pillows, blankets, and sheet sets. We have EVERYTHING you need to transform a boring bedroom, into a Classic Kansas City Royals Baseball Team Room that will be the envy of the neighborhood!