DENVER -- Almost half of all murders in Colorado are women killed by their husbands.
Many of these women suffer in violent intimate relationships for years, and sometimes they turn to family and friends for help. More often, they turn to court where they file for protection orders.
Every day, at 9:00 a.m. in Denver's City and County Building people anxiously wait. Each has a different story of abuse, and each shares a desperate need for protection.
In April Cynthia Gomez waited in that very hallway outside courtroom 170, a special court room reserved for domestic violence cases and protection order hearings.
"I told (the magistrate) I was threatened and that I had received a message on the 5th of April that he was going to chop me up. His exact words were, 'I'm going to chop her up," said Gomez.
Gomez begged Magistrate Catherine Cary for a protection order after violent threats from her ex-boyfriend Ruben Angel Florez escalated. Instead she watched Magistrate Cary deny request after request for protection from other women who came for help.
We obtained the police report Gomez filed where a police officer backs-up Gomez`s story. In the report the officer writes that she 'heard the voicemail left by the suspect.' The officer even writes she hears the suspect say 'he was going to chop her up' in the voicemail.
Domestic violence victim advocates argue the officer's observations should have been more than sufficient for Magistrate Cary to issue the protection order. But inside courtroom 170 , Magistrate Cary told Cynthia Gomez 'no'.
"(The Magistrate) just seemed like she didn't want to give anybody one. If you weren't getting beaten or you didn't have any marks on you, you weren't going to get one," Gomez said.
We requested several times to speak to Magistrate Cary, but she denied those too. Even when we confronted her in the hallway before court she declined to explain her performance.
Though Cary refused to talk to us, her record speaks for itself. Under Colorado's open records laws we reviewed four months of protection order hearings for magistrate Cary and the two prior years.
In each year, the magistrates heard a similar number of protection order requests, but when you review the percentage of those filings the magistrates denied, a dramatic difference appears.
Cary denied 36% of the cases in front of her. In the two years prior, the other magistrates denied 12% and 16%.
Here's something else we uncovered. For the city attorney to accept a criminal case for filing they must believe they can prove a case beyond a reasonable doubt, the highest burden of law in the country.
Denver's city attorney accepted Cynthia Gomez's case for criminal charges believing they had enough evidence to meet that burden. Magistrate Cary's burden is far less. She must have sufficient evidence to believe the victim is in danger. She needs essentially 51% (probable cause) to meet this standard.
Armed with the same facts as the city attorney, Magistrate Cary still denied Gomez the protection she desperately needed.
"Nine out of ten victim of domestic violence underestimate their risk of being killed so if you have a victim in front of you expressing those concerns, believe them," said Milner.
Magistrate Catherine Cary continues to sit on the bench. Even with a record some call dangerous, she alone decides who deserves protection and who must go without it.
"I felt like (the system) failed me," said Gomez.
Note: Magistrate Catherine Cary is hired by the Chief Judge. Unlike most judges, she is not appointed by the Governor or Mayor. When made aware of our story the Chief Judge declined to be interviewed to defend Magistrate Cary or her record.


text:
We talked to one of the experts who helped convince WHO that the cannabis compound CBD is safe
Raúl Elizalde felt compelled to step in when he learned that WHO was reviewing CBD as a psychoactive substance.
by Amanda Siebert on December 15th, 2017 at 3:14 PM
The World Health Organization (WHO) announced earlier this week that the cannabis compound cannabidiol, or CBD, should not be subject to international drug scheduling.
A report from WHO's Expert Committee on Drug Dependence (ECDD) published last month found that—based on the results of both animal and human studies—CBD "could have some therapeutic value for seizures due to epilepsy and related conditions". It also found that CBD, unlike THC, doesn't create dependence and isn't likely to be abused.
No one is more grateful than Raúl Elizalde, whose impassioned speech to the committee days before the final report helped guide the decision of committee members who had intially considered it to be a potentially psychoactive substance.
"My first thought, reading that, was shock," Elizalde told the Straight by phone from his home in Monterrey, Mexico.
And rightfully so: Elizalde has seen firsthand how CBD can be a safe, effective and nonpsychoactive pediatric medicine. His 10-year-old daughter, Grace, currently uses it to help manage her seizures.
Grace was diagnosed with Lennox-Gastaut syndrome, a severe type of pediatric epilepsy, at birth. Elizalde said she had tried 19 different epilepsy drugs throughout her life, even undergoing brain surgery to try to calm her seizures, but nothing worked.
When he and his wife decided to introduce CBD into her diet, her seizures began to decrease not only in frequency but in intensity. Before CBD, Grace suffered from up to 400 seizures a day; now, Elizalde said, even on the worst days her daughter won't suffer from more than 20 seizures in a 24-hour span.
Most days, she'll have two or three, he says.
Elizalde's experience with CBD led to a change in career for the former electronics specialist, who is now the president of HempMeds Mexico and the founder of Por Grace, an organization in Mexico known for its education and work supporting cannabidiol as a safe therapeutic substance.
Raúl Elizalde, his wife, Mayela Benavides, and their daughter, Grace at a Senate conference in Mexico.
After working closely with the Mexican health regulatory agency, Elizalde was able to convince them that although CBD can be derived from cannabis, the extract and the plant are not one and the same. In 2016, the Mexican government began permitting the import of CBD to Mexico.
Through HempMeds, Elizalde is able to import hemp-derived CBD products from the United States. Since it was established in 2016, Elizalde has imported oils for more than 400 Mexican families.
Knowing how effective CBD could be, Elizalde wrote to the WHO and requested to speak about the benefits of the compound at the 39th meeting of the ECDD in Geneva, Switzerland, where they would be discussing CBD in the context of potentially psychoactive subtances.
Elizalde was invited to speak, and on November 6 he was one of six experts who addressed the ECDD about CBD. Although some experts were more analytical, he spoke on a personal level about his experiene with the compound at home and the impact he's been able to make through HempMeds and Por Grace.
"I'm not here as part of the hemp industry," he said in his speech to the committee. "I'm here as a parent of a 10-year-old girl who suffers from Lennox-Gastaut syndrome."
"My daughter, Grace, has suffered all her life from epilepsy, and, believe me, I know about psychoactive drugs," he told them.
"I have been giving them to her a lot, and I have seen what they do. There's no comparison with CBD, not even close. It will be a huge mistake to consider CBD psychoactive."
Elizalde also mentioned studies that had been conducted by Mexican pediatric neurologists, and he noted that descheduling the drug would allow access to safer products.
"We all spoke to the benefits of CBD. Nobody spoke against it," he said. "There was not a single voice telling the expert comittee, 'Actually, you should schedule CBD.'"
Elizalde is excited about this week's announcement and said he's looking forward to the results of the ECDD's next meeting, in May 2018, which will be a special session dedicated to cannabis and its derivatives.
He's confident that THC will be moved from Schedule 1 to Schedule 2, but for now he's glad the WHO has come to the conclusion that it has.
"The fact that they don't want to schedule CBD is something great," he said. "I think it should be treated the same way as Vitamin C."
Follow Amanda Siebert on Twitter and Facebook.

redpajama_set_name: RedPajamaCommonCrawl


What Does The Economizer Have For The Boiler?
The economizer can be recycled, the boiler feed water in a stagnant state, this time the water in the economizer in the state of non-flow, with the boiler combustion to strengthen the flue gas temperature, the economizer within the water easily produce vaporization , So that the local part of the economizer in the over-temperature state.
We all know that the economizer is an important part of the boiler, it is the use of the boiler through the lower flue gas flue gas heating boiler heating surface, in order to use the boiler to improve the thermal efficiency, so as to achieve the purpose of saving energy.
The economizer can increase the temperature of the water supply, into the drum will reduce the wall temperature, thermal stress corresponding to reduce the extension of the life of the drum; absorb low temperature flue gas heat, reduce the exhaust temperature, reduce smoke loss, Saving fuel; heating water in the economizer before entering the drum, thus reducing the heat of the feed water in the heating surface, you can use the economizer to replace some of the higher cost of the evaporation surface.


text:
export default {
  entry: 'dist/index.js',
  dest: 'dist/bundles/nxan-core.umd.js',
  sourceMap: false,
  format: 'umd',
  moduleName: 'ng.nxancore',
  globals: {
    '@angular/core': 'ng.core',
    'rxjs/Observable': 'Rx',
    'rxjs/ReplaySubject': 'Rx',
    'rxjs/add/operator/map': 'Rx.Observable.prototype',
    'rxjs/add/operator/mergeMap': 'Rx.Observable.prototype',
    'rxjs/add/observable/fromEvent': 'Rx.Observable',
    'rxjs/add/observable/of': 'Rx.Observable'
  }
}

redpajama_set_name: RedPajamaGithub


Water constantly moves through a vast global cycle, in which it evaporates (due to the activity of the sun) from oceans, seas and other water reservoirs, forms clouds, precipitates as rain or snow, then flows back to the ocean. The energy of this water cycle, which is driven by the sun, is tapped most efficiently with hydropower. The use of water to generate mechanical power is a very old practice. A flowing stream can make a paddle turn, but a waterfall can spin a blade fast enough to generate electricity. The real key in the magnitude of waterpower is the physical height difference achieved between source and sink - the distance through which the water falls.
When considered as a whole, the energy locked within the Earth's water cycle and ocean waves is extremely large, but harnessing this energy has proved to be exceedingly difficult. There are many different ways to harness the energy in water. The most common way of capturing this energy is hydroelectric power, electricity created by falling water.
The principal advantages of using hydropower are its large renewable domestic resource base, the absence of polluting emissions during operation, its capability in some cases to respond quickly to utility load demands, and its very low operating costs. Hydroelectric projects also include beneficial effects such as recreation in reservoirs or in tail water below dams. Disadvantages can include high initial capital cost and potential site-specific and cumulative environmental impacts.
Simple water-wheels have been used already in ancient times to relieve man of some forms of hard manual labour. Water power was probably first mentioned by the Greeks, around 4000 B.C. Greeks used hydro power to turn water wheels for grinding wheat into flour as well. Much later, but long before the advent of the steam engine, the art of building large water-wheels and the use of considerable power capacities was highly developed. The use of this natural energy resource became even easier and more widespread with the invention of the water turbine in the early 1800?s and hydro power was quickly adapted from mechanical uses, such as grist mill, to spinning a generator to produce electricity. The first small industries emerged soon after in many regions of Europe and North America, powered by water turbines.
In later years, when cheap oil became available world-wide, interest in hydro power was lost to a great extent in many areas, but today the situation is different again. Governments, policy-makers, funding and lending agencies, institutions and individuals take a growing interest. This led -and still does - to the reassessment of many projects once found not feasible; the identification of new sites and potentials, and a number of other activities related to hydro development.


text:
Lemonade Launches in France
8.12.2020 16:06:00 CET | Business Wire
Lemonade, the insurance company powered by artificial intelligence and behavioral economics, launched in another European market today. Residents of France can now get renters insurance instantly, anytime, and from any device – as well as file claims and get paid in seconds through the Lemonade app.
Today's launch marks the third EU country Lemonade has entered, following the Netherlands' launch earlier this year, and Germany in June 2019.
Unlike the traditional insurance model, Lemonade keeps a flat fee for its operations, and gives unused remaining money to nonprofits, as part of its annual Giveback. The company launched its homeowners and renters insurance in New York in late 2016, and has been one of the fastest growing insurance companies ever since. The company went public on July 2, 2020, and is listed on the New York Stock Exchange under the ticker LMND.
Consumers rate Lemonade #1 for its insurance products across multiple platforms, citing the hassle-free digital experience with lightning-fast claim payments, best-in-class customer service, and an unconflicted business model.
"Home insurance is often legally required in France, which makes it a compelling opportunity for Lemonade's next European country launch," said Daniel Schreiber, Lemonade CEO and co-founder. "While the French insurance market is one of the most developed globally, we believe that Lemonade's unique mix of value, values, and technology will stand out to the French consumer, offering the ability to get fast, personalized, and mission-driven insurance, with a few taps."
The Lemonade product in France is crafted specifically with the French customer in mind, but will also embody what's loved by Lemonade's consumers elsewhere: a simple and delightful experience powered by artificial intelligence, instant claims, and the ability to support local and global charities through the company's annual Giveback. Additionally, and similar to the German and Dutch products, the French product has the added benefit of being based on the company's Policy 2.0, a new kind of insurance policy made for the 21st century.
Policy 2.0, currently available in France, the Netherlands and Germany, is a short, easy-to-understand, and transparent document designed for ordinary people (and not only for lawyers) - a consumer-friendly departure from the dense and dated policies that dominate the market.
Lemonade's renters policy, which can be stopped and started at any time through the app, will start at just 4 € a month, and include features that provide more extensive coverage than the typical industry standard policy. For example, Lemonade's policy will offer an optional coverage to cover against theft both in and outside of your home, worldwide - so if a customer's locked bike is stolen from the street, the customer could claim the bike's full replacement value in minutes from the comfort of the Lemonade app.
Lemonade is licensed and supervised by the Dutch Central Bank (DNB), and has its European headquarters in Amsterdam.
Residents of France can now buy a new policy through the Lemonade App or on lemonade.com/fr/en. Get updates on where Lemonade is launching next here.
To access the media kit, including visual assets, please click here.
About Lemonade
Lemonade offers renters, homeowners, and pet health insurance in the United States, contents and liability insurance in Germany and the Netherlands, and renters insurance in France, through its full-stack insurance carriers. Powered by artificial intelligence and behavioral economics, Lemonade set out to replace brokers and bureaucracy with bots and machine learning, aiming for zero paperwork and instant everything. A Certified B-Corp, Lemonade gives unused premiums to nonprofits selected by its community, during its annual Giveback.
Lemonade is currently available for most of the United States, Germany, the Netherlands and France and continues to expand globally.
Stay in touch at @lemonade_inc or press@lemonade.com
This press release contains forward-looking statements within the meaning of the Private Securities Litigation Reform Act of 1995. All statements contained in this press release that do not relate to matters of historical fact should be considered forward-looking statements, including statements regarding the success of our product launch in France. These statements are neither promises nor guarantees, but involve known and unknown risks, uncertainties and other important factors that may cause our actual results, performance or achievements to be materially different from any future results, performance or achievements expressed or implied by the forward-looking statements, including, but not limited to, the following: our history of losses and the fact that we may not achieve or maintain profitability in the future; our ability to retain and expand our customer base; the fact that the "Lemonade" brand may not become as widely known as incumbents' brands or the brand may become tarnished; the denial of claims or our failure to accurately and timely pay claims; our ability to attain greater value from each user; the novelty of our business model and its unpredictable efficacy and susceptibility to unintended consequences; the possibility that we could be forced to modify or eliminate our Giveback, which could undermine our business model; the results of examinations by our primary state insurance regulator that could result in adverse examinations findings and necessitate remedial actions or give rise to regulatory orders requiring remedial, injunctive, or other corrective action; our limited operating history; our ability to manage our growth effectively; the impact of intense competition in the segments of the insurance industry in which we operate on our ability to attain or increase profitability; the unavailability of reinsurance at current levels and prices, which could limit our ability to write new business; our ability to renew reinsurance contracts on comparable duration and terms to those currently in effect; our exposure to counterparty risks as a result of reinsurance; the loss of personal customer information, damage to our reputation and brand, or harm to our business and operating results as a result of security incidents or real or perceived errors, failures or bugs in our systems, website or app; our actual or perceived failure to protect customer information and other data, respect customers' privacy, or comply with data privacy and security laws and regulations; our ability to comply with extensive insurance industry regulations and the need to incur additional costs or devote additional resources to comply with changes to existing regulations; our exposure to additional regulatory requirements specific to other vertical markets that we enter or have entered, including auto, pet and life insurance, and the need to devote additional resources to comply with these regulations; and our inability to predict the lasting impacts of COVID-19 to our business in particular, and the global economy generally. These and other important factors are discussed under the caption "Risk Factors" in our Quarterly Report on Form 10-Q for the period ended September 30, 2020 and our other filings with the Securities and Exchange Commission could cause actual results to differ materially from those indicated by the forward-looking statements made in this press release. Any such forward-looking statements represent management's beliefs as of the date of this press release. While we may elect to update such forward-looking statements at some point in the future, we disclaim any obligation to do so, even if subsequent events cause our views to change.
lemonade@astrskpr.com
About Business Wire
Subscribe to releases from Business Wire
Subscribe to all the latest releases from Business Wire by registering your e-mail address below. You can unsubscribe at any time.
Latest releases from Business Wire
EG Group Selects PDI to Bring Contactless Payments to its North American Sites18.1.2021 13:00:00 CET | Press release
PDI (www.pdisoftware.com), a global provider of enterprise software solutions to convenience retailers and petroleum wholesalers, announced it has reached an agreement with EG Group to expand the use of PDI Payments to nearly 1,700 sites across North America. PDI added payments capabilities to its Marketing Cloud Solutions offering last year after acquiring ZipLine, the industry leader for ACH payment and provider of mobile payment technology. The PDI Payments platform currently powers EG Group's SmartPay Rewards. The rewards program originated with Cumberland Farms—one of several U.S.-based convenience store brands EG Group acquired in recent years—and will soon be rolled out to EG Group's remaining stores across North America. Customers can download the free app and enjoy a contactless payment experience, whether making purchases in the store or at the pump. PDI will provide the technology to support customer enrollment in SmartPay and deliver ongoing customer service for reward memb
Argo Blockchain PLC announces £22.4 Million Private Placement with Institutional Investors and Mining Capacity Expansion18.1.2021 09:46:00 CET | Press release
Argo, the leading cryptocurrency miner based in the UK (LSE:ARB), is pleased to announce that it has entered into a securities purchase agreement for a private placement of its ordinary shares ("Ordinary Shares") to certain institutional investors for gross proceeds of GBP £22.4 million (the "Private Placement"). Pursuant to the Private Placement, the Company will issue 28 million Ordinary Shares (the "Placement Shares") at a purchase price of GBP £0.80 per Ordinary Share. The Private Placement is limited to those certain institutional investors that have already subscribed and this announcement should not be considered an offer or solicitation to purchase or subscribe for securities in the United States. H.C. Wainwright & Co. is acting as the exclusive placement agent for the Private Placement. The net proceeds of the Private Placement will be used by the Company for working capital and general corporate purposes, including the expansion of the Company's mining capacity in Q1 and Q2 o
Reply Signs an Agreement with AWS to Develop Industry Solutions18.1.2021 09:30:00 CET | Press release
Reply, specialized on new communications channels and digital media, announces today it has signed a Strategic Collaboration Agreement (SCA) with Amazon Web Services (AWS) to develop industry solutions for Financial Services, Manufacturing, Automotive, Retail, Energy, and Telco customers. Through this SCA, the Reply Group of companies dedicated to AWS – Comsysto Reply, Data Reply, Sense Reply, and Storm Reply – will work with organizations of virtually all sizes and allow them to innovate faster and deliver consistent improvements on their business processes using advanced and secure AWS technologies. Reply's companies dedicated to AWS will offer solutions for highly regulated Financial Services customers, providing them with strategic advisory and security-related consultancy, practices, and frameworks to modernize legacy platforms and solutions designed to address fraud and financial-crime use cases. They will also provide Industrial and Manufacturing customers with the tools they ne
L&T Technology Services Rated as Global Pure-Play ER&D Services Leader by Zinnov18.1.2021 09:00:00 CET | Press release
L&T Technology Services Limited (BSE: 540115, NSE: LTTS), a leading global pure-play engineering services company, today announced that it has been rated as a 'Leader' in new technologies critical for products and services transformation and also placed in the Leadership Zone across major ER&D Services' sectors in the Zinnov Zones 2020 ER&D Services study for the fourth consecutive year. LTTS continued to hold the top leadership position in the pure play ER&D Services category in the Zinnov Zones assessments. This press release features multimedia. View the full release here: https://www.businesswire.com/news/home/20210118005070/en/ LTTS rated as a Global Leader in ER&D Services in Zinnov Zones 2020. (Graphic: Zinnov) In its latest industry rankings, Zinnov positioned L&T Technology Services as an "Expansive and Established" engineering partner with deep domain competencies in overall ER&D services. LTTS has been rated in the "Leadership Zone" across verticals such as Automotive, Aeros
Guardant Health and Vall d'Hebron Institute of Oncology Announce Partnership to Establish First Guardant-Based Liquid Biopsy Testing Service in Europe18.1.2021 09:00:00 CET | Press release
Guardant Health, Inc. (Nasdaq: GH), a leading precision oncology company, and Vall d'Hebron Institute of Oncology (VHIO), one of Europe's leading cancer research organizations, have agreed to enter into a partnership to establish in-house liquid biopsy testing services, using Guardant Health's industry-leading proprietary digital sequencing platform, at VHIO's facility in Barcelona, Spain. This press release features multimedia. View the full release here: https://www.businesswire.com/news/home/20210118005057/en/ The service is expected to become operational in 2021 and will be available for clinical research and clinical care — starting with private patients, followed by expansion into the public healthcare system over time. "We are pleased to announce this partnership with VHIO which will bring liquid biopsy comprehensive genomic testing to more cancer patients in Spain and beyond," said Helmy Eltoukhy, Guardant Health CEO. "Our vision is that all cancer patients globally have access
Topcon Announces eyeRISE 2021 Virtual Symposia & Expo18.1.2021 07:00:00 CET | Press release
Topcon Healthcare, a leading provider of medical devices and software solutions for the global eye care community, announced today that it will host a two-day virtual symposia and expo entitled eyeRISE on February 9-10, 2021. This press release features multimedia. View the full release here: https://www.businesswire.com/news/home/20210117005025/en/ eyeRISE, or Eye Research Innovation Symposia & Expo, is a new, multi-disciplinary virtual congress showcasing the latest innovations in eye care. It will feature three solutions-focused tracks, delivering clinical and practical education through symposia, roundtable discussions and interactive workshops. (Graphic: Business Wire) eyeRISE, or Eye Research Innovation Symposia & Expo, is a new, multi-disciplinary virtual congress showcasing the latest innovations in eye care. It will feature three solutions-focused tracks, delivering clinical and practical education through symposia, roundtable discussions and interactive workshops. The two-day
Servier announce updated overall survival results of exploratory TASCO1 phase II study of LONSURF ® + bevacizumab in a first-line setting for patients with unresectable mCRC non-eligible for intensive therapy16.1.2021 22:15:00 CET | Press release
Servier announced today updated results from the exploratory phase II TASCO1 study evaluating LONSURF® (trifluridine/tipiracil) + bevacizumab and capecitabine + bevacizumab (C-B) in a first-line setting for patients with unresectable metastatic colorectal cancer (mCRC) who are non-eligible for intensive therapy.1 The data were announced today during an oral presentation at the 2021 ASCO Gastrointestinal Cancers Symposium (ASCO-GI). Patients with mCRC who are not eligible for chemotherapy face a large unmet need, with fewer treatment options available to them and lower survival rates. Colorectal cancer (CRC) makes up 9.7% of total global cancer cases, with almost 1.4 million new cases of CRC each year.2 In Europe, CRC is the second most common cause of death due to cancer, and those with a metastatic disease have a 5-year survival rate of just 11%.3 "For patients with metastatic colorectal cancer, those non-eligible for standard combination therapy have few options left and we are conti
In our pressroom you can read all our latest releases, find our press contacts, images, documents and other relevant information about us.
Visit our pressroom


If you ever find yourself in need of Climax Bail Bonds, there is nothing to worry about! Our network makes it simple to find and get in touch with a licensed bail bond company in Climax, New York. Many Climax NY bail bond companies can bail you (or another person) out anytime day or night in Climax NY. At your request, many bail bonds agents will come pick you up privately. Installment payment plans are usually available depending on case by case basis.
Upon arrest anywhere in Greene county, a person must be processed at the Greene county jail. To be released from jail, a few steps must occur, including being booked and posting bail. Once the bail amount is decided, a bail bond agent comes to post the bond at the local jail. Now the jail release process starts and typically can take anywhere from one to two hours to complete. While cash bonds are allowed, it is usually not frequently done due to it's high expense.


text:
Q: yum install local rpm throws error if up to date When installing rpm packages from local file directory it runs fine the first time
sudo yum install packages/* -y --disablerepo=*

When the same thing is run the second time as part of automated scripts, it throws an error (exit code 1)
packages/package.rpm: does not update installed package.
Error: Nothing to do

I can run yum update (exit code 0)
sudo yum update packages/* -y --disablerepo=*
...
No packages marked for update

The problem with this is that update will skip the packages that are not installed.
I don't want to ignore exit code if there are any real problems here, and just want to do install-or-update. Is there a rpm -i equivalent that would achieve that? Please take note that this is done on a group of rpm packages that might at any point include additional ones.
I guess one option would be to iterate over them in a shell script and check if they are installed or not, but then again dependency resolution might become rather painful and it does sound like re-inventing a bike.
UPDATE:
rpm --install will throw exit code depending on the number of failed packages.
https://www.redhat.com/archives/rpm-list/2005-July/msg00071.html
rpm --freshen will ignore any rpms that are not installed previously while giving no output at all.

A: on my system (centos6, centos7) "yum localinstall" will return code 0 even with "Error: Nothing to do" message, while "yum install" returns 1.
sudo yum localinstall packages/* -y --disablerepo=*

Anyway you can also check the message result to ignore this as a "normal error" in your automation scripts, like for example using bash:
sudo yum install packages/* -y --disablerepo=* 2>&1 | tee /tmp/yum.output
grep -q "Error: Nothing to do" /tmp/yum.output
if [ $? -eq 0 ]; then
  ... code for no error
else
  ... code for error
fi

redpajama_set_name: RedPajamaStackExchange


text:
//
//  TGMapData.h
//  TangramMap
//
//  Created by Karim Naaji on 2/24/16.
//  Copyright (c) 2017 Mapzen. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "TGGeoPoint.h"
#import "TGGeoPolygon.h"
#import "TGGeoPolyline.h"

/**
 Dictionary of feature properties keyed by their property name
 */
typedef NSDictionary<NSString *, NSString *> TGFeatureProperties;

@class TGMapViewController;

/**
 A `TGMapData` is a convenience class to display point, polygons or polylines from a dynamic data layer.
 The data layer will be styled according to the scene file using the provided data layer name.

 In your stylesheet, add a layer with the name of the data layer you want to add in your client application:

 ```
 layers:
     mz_route_line_transit:
        data: { source: mz_route_line_transit }
     draw:
        polylines:
            color: function() { return feature.color || '#06a6d4'; }
            order: 500
            width: 10px
 ```

 In your implementation, to add a polyline fitting under the `mz_route_line_transit` layer:

 ```swift
 // Create a data layer in the TGMapViewController mapView
 var dataLayer = mapView.addDataLayer(name: "mz_Route_line_transit");

 var line = TGGeoPolyline()

 // Add some coordinates to the polyline
 line.add(latlon: TGGeoPointMake(longitude0, latitude0))
 line.add(latlon: TGGeoPointMake(longitude1, latitude1))

 // Set the data properties
 var properties = ["type": "line", "color": "#D2655F"]

 // Add the line to the data layer
 dataLayer.add(polyline: line, properties: properties);
 ```
 */
@interface TGMapData : NSObject

NS_ASSUME_NONNULL_BEGIN

/**
 Adds a point coordinate to the data source.

 @param coordinates the geographic coordinates of the point to add to the data source
 @param properties the feature properties
 */
- (void)addPoint:(TGGeoPoint)coordinates withProperties:(TGFeatureProperties *)properties;

/**
 Adds a polygon geometry to the data source.

 @param polygon the polygon geometry to add to the data source
 @param properties the feature properties
 */
- (void)addPolygon:(TGGeoPolygon *)polygon withProperties:(TGFeatureProperties *)properties;

/**
 Adds a polyline to the data source.

 @param polyline the polyline geometry to add to the data source
 @param properties the feature properties
 */
- (void)addPolyline:(TGGeoPolyline *)polyline withProperties:(TGFeatureProperties *)properties;

/**
 Adds features described in a GeoJSON string to the data source. The string must be formatted according
 to the GeoJSON specifications.

 @param data the GeoJSON formatted string to add to the data source
 */
- (void)addGeoJson:(NSString *)data;

/**
 Clears the data source from all the added features.
 */
- (void)clear;

/**
 Definitely removes the data source from the map view.
 Any future usage of this `MapData` object will be a no-op.

 @return `YES` if removal was successful
 */
- (BOOL)remove;

/// The name of the data source
@property (readonly, nonatomic) NSString* name;

NS_ASSUME_NONNULL_END

/// The map view this data source is on
@property (readonly, nonatomic) TGMapViewController* _Nullable map;

@end


text:
Home/News/Shoe thrown into Swiss lake 5,000 years ago
Shoe thrown into Swiss lake 5,000 years ago
Ordo News EditorMarch 4, 2022Last Updated: March 4, 2022
(ORDO NEWS) — The holey shoe of a man who lived five thousand years ago was discovered by archaeologists at the bottom of Lake Greifensee in northern Switzerland in 2018. And for scientists, this is an incredibly valuable artifact.
"An almost completely preserved boot, which is about five thousand years old, was found," the message posted on the website of the cantonal government of Zurich said. "There have been less than a dozen such finds in Europe."
Outwardly resembling a bast shoe, a semi-open boot is made of bast. In the production of shoes in those days, ribbons of bast half a centimeter thick were used. "Since the length of the boot is 26 cm, it most likely belonged to an adult," experts noted. There is a gaping hole under the heel of the boot: apparently, that's why it was thrown out by the owner.
Most Stone Age garments are extremely fragile. They were made from plant materials. Swiss archaeologists call it a miracle that some objects have survived to our time without succumbing to decomposition.
Underwater surveys are carried out on the Greifensee lake at a depth of 3.5 meters. Artifacts are taken to the surface along with silt, from which they are then scrupulously cleaned in the laboratory. To prevent the appearance of microbes, the laboratory room is constantly cooled, it maintains the necessary humidity.
The shoe was found in the territory of the Mau community. Ancient artifacts were first discovered in this community at the end of the 19th century, when the level of the lake dropped by one meter after the change in the course of the Glatt River.
It took more than a century before rigorous systematic research was carried out at this place. Cultural layers have been found that belong to three different cultures that succeeded each other during 3800-2500 BC.
Norway's oldest 3,000-year-old shoe recovered from melting glacier


text:
Displacement of Canada's largest public illicit drug market in response to a police crackdown
Evan Wood, Patricia M. Spittal, Will Small, Thomas Kerr, Kathy Li, Robert S. Hogg, Mark W. Tyndall, Julio S.G. Montaner and Martin T. Schechter
CMAJ May 11, 2004 170 (10) 1551-1556; DOI: https://doi.org/10.1503/cmaj.1031928
Evan Wood
Patricia M. Spittal
Will Small
Kathy Li
Robert S. Hogg
Mark W. Tyndall
Julio S.G. Montaner
Martin T. Schechter
© 2004 Canadian Medical Association or its licensors
Background: Law enforcement is often used in an effort to reduce the social, community and health-related harms of illicit drug use by injection drug users (IDUs). There are, however, few data on the benefits of such enforcement or on the potential harms. A large-scale police "crackdown" to control illicit drug use in Vancouver's Downtown Eastside provided us with an opportunity to evaluate the effect.
Methods: As part of our ongoing prospective cohort study of IDUs in Vancouver, we examined data collected from 244 IDUs in the 3 months before the police crackdown and from 142 IDUs in the 3 months after the start of the crackdown, on Apr. 7, 2003. All study subjects were active drug users. We also examined external data on needle exchanges and syringe disposal.
Results: The 2 groups of IDUs were statistically similar: they were mainly young (mean age 39 years) and male (63%), and they had injected illicit drugs for 13 years on average. Ethnic background and the proportion homeless were also similar. There were no statistically significant reported differences (all p > 0.1) in the street price of heroin, cocaine or "crack" in the 2 periods. In the 3-month periods before and after the crackdown, respectively, the rates of daily heroin injection were 27.9% and 26.8%, daily cocaine injection 28.7% and 27.5%, and daily crack use 59.4% and 60.6% (all p > 0.1). The proportions of study subjects receiving methadone treatment, 41.0% and 44.4% (p = 0.516), did not differ. However, the proportions reporting a change in where drugs were used, 22.5% and 33.8% (p < 0.05), and the proportions reporting a change in the neighbourhood of use because of police presence, 18.1% and 26.8% (p < 0.05), increased significantly. Needle-exchange data confirmed that the community levels of drug use were unchanged. Disposal statistics demonstrated that the monthly average number of used syringes found on the streets outside the traditional area of drug use increased from 784 in the 3 months before Apr. 1 to 1253 in the subsequent 3 months (p = 0.002) and the monthly average number of used syringes found in public boxes for the safe disposal of syringes decreased from 865 to 502 (p = 0.018).
Interpretation: The effort to control illicit drug use did not alter the price of drugs or the frequency of use, nor did it encourage enrolment in methadone treatment programs. Several measures indicated displacement of injection drug use from the area of the crackdown into adjacent areas of the city, which has implications for both recruitment of new initiates into injection drug use and HIV prevention efforts.
In Canada and elsewhere, policy-makers have primarily relied on law enforcement to curb the social,1 community2 and health-related harms of illicit drug use.3,4 However, this approach has been criticized because of the lack of evaluation of interventions and the growing evidence that it may be harmful when applied in isolation.5,6,7 The 2001 Auditor General's report on Canada's drug strategy concluded: "Of particular concern is the almost complete absence of basic management information on spending of resources, on expectations, and on results."8 In our recent evaluation of the largest heroin seizure in Canadian history, we were unable to detect any measurable public health benefits with respect to changes in heroin use after the seizure.9
In April 2003 the Vancouver Police Department embarked on a large-scale enforcement operation aimed at illicit drug users (IDUs) in the city's Downtown Eastside (DTES). The stated goals of the "crackdown" involved "disrupting the open drug market and interrupting the cycle of crime and drug use that marks the streets of the Downtown Eastside."10 The estimated cost of the crackdown to taxpayers was an additional $2.3 million.10 In the first several weeks of the operation an additional 236 trafficking charges against 162 individuals were reported.11
Although there has been wide speculation on other impacts of the increased police activity, including anecdotal reports of increased enrolment in methadone programs on the one hand12,13 and charges of widespread violation of human rights on the other,14,15 the crackdown's effects had not been rigorously evaluated. Our ongoing cohort study of IDUs in this neighbourhood afforded us the opportunity to investigate the outcomes of the crackdown in terms of physical displacement of the drug market to other locations, initiation of addiction treatment and frequency of drug use among current users.
Beginning in May 1996, we recruited IDUs into the Vancouver Injection Drug User Study (VIDUS), a prospective cohort study that has previously been described in detail.16,17 In brief, more than 1500 study subjects have been recruited through self-referral and street outreach, and the cohort appears to represent IDUs in the Vancouver area.9 At baseline and semiannually, subjects provided blood samples and completed an interviewer-administered questionnaire that elicited demographic data (including age, sex and place of residence), as well as information on drug use, risk-taking behaviour, access to health care services and participation in drug treatment programs. Several questions evaluated the effect of law-enforcement efforts on the supply of drugs and patterns of drug use.
The police crackdown began Apr. 7, 2003, and reportedly involved the redeployment of 50 additional officers to the DTES.18 For the primary analyses, we compared the behaviour of active IDUs residing in the DTES who were interviewed in the 3 months before the crackdown (group 1) and those interviewed in the 3 months after Apr. 7, 2003 (group 2). Data on age, sex and ethnic origin were statistically analyzed to ensure no differences between groups 1 and 2. Active drug users in VIDUS who resided outside the DTES were used as a control group.
In an effort to identify effects of the crackdown, we investigated whether there were changes in the reported drug prices, patterns of drug use and general perceptions of the effect of police activities on the drug market. We also examined drug use in the community by evaluating statistics from the needle-exchange program, which is based in the DTES.19 Using statistics compiled by the City of Vancouver, we examined changes in the use of outdoor public boxes for the safe disposal of syringes and in unsafe syringe disposal. Since public injection drug use and dealing have historically been concentrated on the corner of the DTES's Main and Hastings streets,16 we defined the area within a 1-block radius of the corner of Main and Hastings as "the core" and peripheral areas in the DTES as "outside the core." Exchange and disposal data are available on only a monthly basis; therefore, we compared the 3 months before Apr. 1, 2003, with the 3 months after this date.
We analyzed categorical explanatory variables with Pearson's χ2 test and Fisher's exact test and continuous variables with the Wilcoxon rank-sum test. All tests were 2-tailed, and the significance level was set at p < 0.05.
Between Jan. 6 and July 7, 2003, 774 VIDUS participants returned to the study site for follow-up. We excluded 178 (23.0%) from the crackdown study because they had not used heroin, cocaine or "crack" during the entire 6-month period before the interview, and we excluded 210 (27.1%) active users from the primary analyses because they did not reside in the DTES. The proportions excluded because of lack of active drug use were similar (p = 0.19) in the group interviewed in the 3 months before the crackdown (21.3% [95]) and the group interviewed in the 3 months after the start of the crackdown (25.3% [83]). Therefore, we restricted the primary analyses to the 244 active IDUs seen in the 3 months before Apr. 7 (group 1) and the 142 active IDUs seen in the 3 months after Apr. 7 (group 2). Groups 1 and 2 were similar in age (p = 0.25), sex (p = 0.87), ethnic background (p = 0.46), instability of housing (p = 0.57) and years of injection drug use (p = 0.28). The subjects were mainly young (mean age 39 years) and male (63%) and had injected illicit drugs for 13 years on average.
Table 1 compares the intensity of drug use in groups 1 and 2 and perceptions about the effects of police presence. Although after the crackdown there was a significant increase in reporting that the police had affected the types of drugs available, a marginal decrease in reported ability to acquire drugs and a significant change in the reported quality of drugs, we found no difference in the reported extent to which police affected the quantity of drugs used, the buying of drugs or which drugs were used. This finding was supported by the lack of change in the reported daily use of heroin, cocaine and crack.
As Table 2 shows, we found significant increases in reporting that police presence had affected where drugs were used and had led to outdoor (but not indoor) drug use. The latter finding was supported by a significant increase in reporting of a change in the neighbourhood or alley of use because of police presence and a marginal increase in reporting of recent use in a public space such as a park, public washroom or street. We also found a significant reduction in willingness to use a safer injecting site and a nonsignificant decrease in contact with street nurses. We observed no increases in the use of methadone maintenance treatment or in the frequency of unsuccessful attempts to obtain treatment. There were no changes between the 2 interview periods (all p > 0.1) in reported single-shot drug prices (median [and interquartile range]) for heroin ($20 [$20–$20] before and $20 [$16–$20] after the crackdown), cocaine ($10 [$10–$10] in both periods) or crack ($10 [$8–$10] in both periods). When we repeated the secondary analyses on the data for the 210 active drug users who resided outside the DTES (107 seen in the 3 months before Apr. 7 and 103 seen in the 3 months after Apr. 7), we found no significant increase (p = 0.66) in reported public injection drug use and no significant differences (all p > 0.1) in the various measures of displacement of use or in any of the other measured covariates (data not shown).
From the needle-exchange data, we found that 363 998 syringes were distributed in the 3 months before Apr. 1, 2003, and 400 382 were distributed in the 3 months after this date (t test of monthly averages: p = 0.516). As Fig. 1 shows, the total number of used syringes found on the streets in the core (panel a) decreased significantly after the crackdown, from a monthly average of 1082 in the 3 months before Apr. 1 to 585 in the 3 months after Apr. 1 (t test: p = 0.003). However, a significant increase in unsafe disposal of used syringes was observed outside the core (panel b), the monthly average total number rising from 784 to 1253 in the same periods (t test: p = 0.002). We also found that use of the 6 public boxes for the safe disposal of used syringes (panel c) — 4 in the core and 2 outside the core — decreased significantly, from a monthly average total number of 865 in the 3 months before Apr. 1 to 502 in the 3 months after Apr. 1 (t test: p = 0.018). Since disposal statistics are compiled only for the DTES, we could not assess changes outside this area. Nevertheless, we did note that the proportion of syringes distributed that were not returned to the exchange (including from DTES needle "sweeps") rose from 4.0% in the 3 months before the crackdown to 8.1% in the 3 months afterward (p < 0.001).
Fig. 1: Total number of used syringes discarded in public before and after a large-scale police "crackdown" to control illicit drug use in Vancouver's Downtown Eastside (DTES). The "core" was defined as the area within a 1-block radius of the corner of Main and Hastings streets; the remainder of the DTES was considered "outside the core."
We detected no reduction in drug-use frequency or drug price in response to a large-scale police crackdown on drug users in Vancouver's DTES. The evidence that drugs became more difficult to obtain was consistent with reports of displacement of drug dealers20,21 and was supported by the significantly higher rates of reporting that police presence had affected where drugs were used, including changes in neighbourhood and increases in use in public places. These observations were validated by examination of needle-exchange statistics.
Our findings are consistent with those showing that demand for illicit drugs enables the illicit drug market to adapt to and overcome enforcement-related constraints.9,22,23,24 Although evidence suggested that police presence made it more difficult to obtain drugs, this appeared to be explained by displacement of drug dealers.20,21 Other studies have similarly shown that concentrated police presence tends to displace drug-use activities and associated crime to neighbouring areas.22,23,25,26 Our results probably explain reports of increased injection drug use, drug-related crime and other public-order concerns in neighbourhoods where activities related to illicit drug use and the sex trade emerged or intensified in the wake of the crackdown.27,28 Such displacement has profound public-health implications if it "normalizes" injection drug use among previously unexposed at-risk youth.20,21,29,30 Furthermore, since difficulty in obtaining syringes has been shown to be a significant factor in promoting syringe sharing among IDUs in Vancouver,31 displacement away from sources of sterile syringes may increase the rates of bloodborne diseases.7,25,32 Escalated police presence may also explain the observed reduction in willingness to use a safer injection facility.33 It is unlikely that the lack of benefit of the crackdown was due to insufficient police resources. Larger crackdowns in the United States, which often involved helicopters to supplement foot and car patrols, have not had measurable benefits and have instead been associated with substantial health and social harms.5,22,24,32,34
There are several limitations to our study. As previously discussed,16 the subjects in VIDUS are not a random sample, although they are believed to represent IDUs in Vancouver.9 In addition, although we followed a statistical protocol defined a priori, the number of statistical comparisons was large. Sampling from the periods before and after the crackdown may have been affected by the drop in number of visits between the 2 periods, although we noted a similar pattern in the same 6-month period in 2002, which suggests that the reduction in visits was more likely due to the cyclic nature of the study. Although we tested for potential confounding due to differences in the 2 study groups, it is possible that unmeasured confounding existed. An additional limitation is that, because exchange and disposal statistics were available only on a monthly basis, the period Apr. 1 to Apr. 6 was included in the postcrackdown period, which would reduce any enforcement-related differences. Finally, the restricted sample size meant that there was insufficient statistical power to evaluate outcomes in HIV risk behaviour, such as syringe borrowing; however, previous studies have consistently shown police crackdowns to be associated with elevated HIV risk behaviour.5,23,24,26
In summary, we detected no reduction in drug-use frequency or drug price in response to a large-scale police crackdown in Vancouver's DTES. Our results support anecdotal reports of increased public drug use and displacement of drug users,27 and they probably explain increases in drug-related sex-trade activity28 and crime in areas outside the DTES.11,20 The crackdown also increased the rates of unsafe syringe disposal and significantly reduced the proportion of syringes being returned to the city's largest needle exchange. The displacement of the drug market to new areas has substantial public-health implications,7,25,31,35 including the potential for an increased risk of new initiates into injection drug use.29,30 Future enforcement strategies should be coordinated with expanded public-health and addiction-treatment strategies.31,33,35,36 Once addiction-treatment services are in place,37 we recommend that outreach services and supervised injection centres be evaluated in an effort to avoid the negative public-health consequences of drug-use displacement.38
This article has been peer reviewed.
Contributors: Evan Wood and Martin Schechter designed the study. Kathy Li and Evan Wood conducted the statistical analyses. Evan Wood drafted the manuscript and incorporated all suggestions. All coauthors made significant contributions to the conception and design of the analyses, interpretation of the data and drafting of the manuscript, and they all approved the version to be published.
Acknowledgements: We acknowledge the contribution of all participants in the Vancouver Injection Drug User Study (VIDUS). This study would not have been possible without the financial support of Status of Women Canada. VIDUS was supported by the US National Institutes of Health (grant R01 DA11591) and is now supported in part by the Canadian Institutes of Health Research (CIHR) (grant 122258). Evan Wood is supported by the Michael Smith Foundation for Health Research and by CIHR. Robert Hogg is supported by the Michael Smith Foundation for Health Research through a Career Investigator Award and by CIHR through an Investigator Award. Martin Schechter is a Tier I Canada Research Chair in HIV/AIDS and Urban Population Health. We also thank Bonnie Devlin, John Charette, Kathy Churchill, Caitlin Johnston, Robin Brooks, Steve Kain, Peter Vann and Nancy Laliberte for their research and administrative assistance.
Competing interests: None declared.
Correspondence to: Dr. Evan Wood, Division of Epidemiology and Population Health, British Columbia Centre for Excellence in HIV/AIDS, 608–1081 Burrard St., Vancouver BC V6Z 1Y6; fax 604 806-9044; ewoodcfenet.ubc.ca
Wall R, Rehm J, Fischer B, Brands B, Gliksman L, Stewart J, et al. Social costs of untreated opioid dependence. J Urban Health 2000;77:688-722.
Fischer B, Medved W, Kirst M, Rehm J, Gliksman L. Illicit opiates and crime: results of an untreated user cohort study in Toronto. Can J Criminol 2001; 43:197-217.
Palepu A, Tyndall MW, Leon H, Muller J, O'Shaughnessy MV, Schechter MT, et al. Hospital utilization and costs in a cohort of injection drug users. CMAJ 2001;165(4):415-20.
Wood E, Kerr T, Spittal PM, Tyndall MW, O'Shaughnessy MV, Schechter MT. The healthcare and fiscal costs of the illicit drug use epidemic: the impact of conventional drug control strategies and the impact of a comprehensive approach. B C Med J 2003;45:130-6.
Drucker E. Drug prohibition and public health: 25 years of evidence. Public Health Rep 1999;114(1):14-29.
Oscapella E. How Canadian laws and policies on "illegal" drugs contribute to the spread of HIV infection and hepatitis B and C. Ottawa: Canadian Foundation for Drug Policy; 1995. Available: www.cfdp.ca/aidsd95.html (accessed 2004 Mar 11).
Bluthenthal RN, Lorvick J, Kral AH, Erringer EA, Kahn JG. Collateral damage in the war on drugs: HIV risk behaviours among injection drug users. Int J Drug Policy 1999;10:25-38.
Auditor General of Canada. Illicit drugs: the federal government's role [chapter 11]. In: 2001 report of the Auditor General of Canada. Ottawa: Office of the Auditor General of Canada; 2001. Available: www.oag-bvg.gc.ca/domino/reports.nsf/html/01menu_e.html (accessed 2004 Mar 11).
Wood E, Tyndall MW, Spittal PM, Li K, Anis AH, Hogg RS, et al. Impact of supply-side policies for control of illicit drugs in the face of the AIDS and overdose epidemics: investigation of a massive heroin seizure. CMAJ 2003;168(2):165-9.
Rich B, LePard D. 2003 police sworn staffing request for the Downtown Eastside. Administrative report to the Standing Committee on City Services and Budgets, Vancouver City Council, from the Chief Constable; 2003 Mar 18. Available: www.city.vancouver.bc.ca/ctyclerk/cclerk/20030327/csb4.htm (accessed 2004 Mar 11).
Police Board, Vancouver Police Department. Minutes of regular meeting held on April 23, 2003. Available: www.cityvancouver.bc.ca/police/policeboardmeetingminutes/2003Apr23.htm (accessed 2004 Mar 11).
Campbell LW. Confronting poverty and addiction on Vancouver's Downtown Eastside. The City of Vancouver's response to the Human Rights Watch report on health and human rights impacts of the Vancouver Police Department's City-wide Enforcement Team (CET) Initiative. Vancouver: City of Vancouver; 2003. Available: www.city.vancouver.bc.ca/fourpillars/pdf/HRW-response.pdf (accessed 2004 Mar 11).
Culbert L. Police crackdown has cut drug use, expert doctor. Vancouver Sun 2003 May 6;Sect A:1.
Csete J, Cohen J. Abusing the user: police misconduct, harm reduction and HIV/AIDS in Vancouver. Human Rights Watch 2003;15(2B):1-28. Available: www.hrw.org/reports/2003/canada/canada0503.pdf (accessed 2004 Mar 11).
Austin I. Police sweep accused of beating people. The Province 2003 Apr 11;Sect A:1.
Wood E, Tyndall MW, Spittal PM, Li K, Kerr T, Hogg RS, et al. Unsafe injection practices in a cohort of injection drug users in Vancouver: Could safer injecting rooms help? CMAJ 2001;165(4):405-10.
Craib KJP, Spittal PM, Wood E, Laliberte N, Hogg RS, Li K, et al. Risk factors for elevated HIV incidence among Aboriginal injection drug users in Vancouver. CMAJ 2003;168(1):19-24.
Bula F. 50 officers to target downtown drug trade. Vancouver Sun 2003 Mar 7;Sect B:1.
Bardsley J, Turvey J, Blatherwick J. Vancouver's needle exchange program. Can J Public Health 1990;81:39-45.
Young S. West Enders meet to lament criminal influx. The Province 2003 Aug 22;Sect A:24.
Bula F, Fong P. Dealers, addicts just move around. Downtown Eastside problems appear elsewhere as police crack down on drugs. Vancouver Sun 2003 Jul 5;Sect B:1.
Best D, Strang J, Beswick T, Gossop M. Assessment of a concentrated high-profile police operation: no discernible impact on drug availability, price or purity. Br J Criminol 2001;41:738-45.
Maher L, Dixon D. Policing and public health: law enforcement and harm minimization in a street-level drug market. Br J Criminol 1999;39:488-512.
Aitken C, Moore D, Higgs P, Kelsall J, Kerger M. The impact of a police crackdown on a street drug scene: evidence from the street. Int J Drug Policy 2002; 13:189-98.
Wood E, Kerr T, Small W, Jones J, Schechter MT, Tyndall MW. The impact of police presence on access to needle exchange programs. J Acquir Immune Defic Syndr 2003;34:116-8.
Dovey K, Fitzgerald J, Choi Y. Safety becomes danger: dilemmas of drug-use in public space. Health Place 2001;7:319-31.
Thomas S. Sex trade moving back to Davie St. Vancouver Courier 2003 Aug 13. Available: www.vancourier.com/082203/news/082203nn9.html (accessed 2004 Mar 11).
Bula F, Fong P. Has the crackdown worked? Vancouver Sun 2003 July 5;Sect A:1.
Roy E, Haley N, Leclerc P, Cedras L, Blais L, Boivin JF. Drug injection among street youths in Montreal: predictors of initiation. J Urban Health 2003;80(1):92-105.
Fuller CM, Vlahov D, Latkin CA, Ompad DC, Celentano DD, Strathdee SA. Social circumstances of initiation of injection drug use and early shooting gallery attendance: implications for HIV intervention among adolescent and young adult injection drug users. J Acquir Immune Defic Syndr 2003;32(1):86-93.
Wood E, Tyndall MW, Spittal P, Li K, Hogg RS, O'Shaughnessy MV, et al. Needle exchange and difficulty with needle access during an ongoing HIV epidemic. Int J Drug Policy 2002;13:95-102.
Bluthenthal RN, Kral AH, Lorvick J, Watters JK. Impact of law enforcement on syringe exchange programs: a look at Oakland and San Francisco. Med Anthropol 1997;18(1):61-83.
Kerr T, Wood E, Small D, Palepu A, Tyndall MW. Potential use of safer injecting facilities among injection drug users in Vancouver's Downtown Eastside. CMAJ 2003;169(8):759-63.
Des Jarlais DC, Friedman SR. Fifteen years of research on preventing HIV infection among injecting drug users: what we have learned, what we have not learned, what we have done, what we have not done. Public Health Rep 1998; 113 (Suppl 1):182-8.
Wood E, Tyndall MW, Spittal PM, Li K, Hogg RS, Montaner JS, et al. Factors associated with persistent high-risk syringe sharing in the presence of an established needle exchange programme. AIDS 2002;16:941-3.
Cartwright WS. Cost-benefit and cost-effectiveness analysis of drug abuse treatment services. Eval Rev 1988;22:609-36.
Wood E, Spittal PM, Li K, Kerr T, Miller CL, Hogg RS, et al. Inability to access addiction treatment and risk of HIV-infection among injection drug users. J Acquir Immune Defic Syndr. In press.
Wood E, Kerr T, Montaner JS, Strathdee SA, Wodak A, Hankings CA, et al. Rationale for evaluating North America's first medically supervised safer injecting facility. Lancet Infect Dis. In press.
CMAJ
Vol. 170, Issue 10
To sign up for email alerts or to access your current email alerts, enter your email address below:
Thank you for your interest in spreading the word on CMAJ.
You are going to email the following Displacement of Canada's largest public illicit drug market in response to a police crackdown
Message Subject (Your Name) has sent you a message from CMAJ
Message Body (Your Name) thought you would like to see the CMAJ web site.
Evan Wood, Patricia M. Spittal, Will Small, Thomas Kerr, Kathy Li, Robert S. Hogg, Mark W. Tyndall, Julio S.G. Montaner, Martin T. Schechter
CMAJ May 2004, 170 (10) 1551-1556; DOI: 10.1503/cmaj.1031928
 Request Permissions
Highlights of this issue
A police education programme to integrate occupational safety and HIV prevention: protocol for a modified stepped-wedge study design with parallel prospective cohorts to assess behavioural outcomes
Prevalence and structural correlates of gender based violence among a prospective cohort of female sex workers
Public injecting among a cohort of injecting drug users in Vancouver, Canada
Impact of a medically supervised safer injection facility on community drug use patterns: a before and after study
Changes in public order after the opening of a medically supervised safer injecting facility for illicit injection drug users
Scopus (115)
Falsely elevated point-of-care lactate measurement after ingestion of ethylene glycol
Severe necrotizing pancreatitis following combined hepatitis A and B vaccination
Can hockey playoffs harm your hearing?
Show more Research article


text:
New Bodie Island Hunt Blind to Open
11/22/2019 by	Staff Report
Entrance to hunt blind and wildlife-viewing platform. Photo: NPS
Cape Hatteras National Seashore's new Architectural Barriers Act, or ABA, accessible hunt blind and wildlife-viewing platform will be open to hunters with limited mobility starting Dec. 14 to hunt waterfowl during authorized dates, the seashore announced Thursday.
Waterfowl hunting season dates and information on reserving the platform can be found on the Seashore's waterfowl hunting webpage.
Starting April 1 after hunting season, all visitors can use the new hunt blind and wildlife-viewing platform located about two miles north of the Bodie Island Lighthouse for wildlife-viewing, educational and photography opportunities. For more information on the wildlife-viewing platform, visit the nature viewing and photography web page.
"I am pleased to improve accessibility options for important recreational activities in the Seashore," David Hallac, Superintendent, National Parks of Eastern North Carolina, said in a statement. "We appreciate the technical support and guidance from our partners with the North Carolina Wildlife Resources Commission to bring this project to completion."
Waterfowl hunting was first authorized at the seashore on June 29, 1940. It is permitted, in accordance with federal and state regulations, on 1,500 acres of Bodie Island, 500 acres of Hatteras Island, and Ocracoke Island, except Ocracoke Village.
In March 2019, the National Park Service approved the seashore's plan to construct the accessible hunt blind and wildlife-viewing platform after the preparation of an environmental assessment with public review. Copies of the EA and Finding of No Significant Impact can be found on the NPS Planning, Environment, and Public Comment website.
Join the conversation on our Facebook Page
Like This Story?
It costs about $500 to produce this and all other stories on CRO. You can help pay some of the cost by sponsoring a day on CRO for as little as $100 or by donating any amount you're comfortable with. All sponsorships and donations are tax-deductible.
Prev:Review Highlights DEQ Funding Shortfall
Next:20-Year-Old Cars Free From Emissions Test
The story was compiled by staff members of Coastal Review Online.
Apply Now to Do Business at National Parks
Feedback Sought on Marina Upgrades
Co-op to Improve Electric Service to Ocracoke
Roanoke Island Aquarium Goes Green
Beach & Inlet Management
Coastal Policy
Terminal Groins


Terms and conditions of attendance, privacy statement, liability waiver, IIAV website copyright, email disclaimer notice, website cookies.
The IIAV plans to take photographs and video material at an ICSV Congress and reproduce them in news or promotional material, whether in print, electronic or other media, including the IIAV and ICSV websites and social media. By participating in an ICSV, you grant the IIAV the right to use your name, photograph and biography for such purposes. All photographs and videos are the property of the IIAV and may be displayed, distributed or used by the IIAV for any purpose.
Anyone attending an ICSV must not take part in any canvassing, leafleting, demonstrations, objectionable behaviour or any activity, which may disrupt the congress.
This privacy notice applies to anyone entering information on our websites, registering online for an ICSV congress, subscribing to our news, journal or making an enquiry or complaint to us.
We are committed to collecting and using your personal information fairly and transparently, so we will make it clear if we are collecting personal information from you or intend to use it for any purpose that is not obvious.
We use the personal information that you provide to us for our internal purposes, such as responding to your requests for information, contacting you, conducting internal analyses, and processing and completing orders and event registrations.
The IIAV also reserves the right to compile, save, use within the scope of our activities, and analyse any and all data (contact and personal data, use history, etc.) that we collect from you through our websites.
We may disclose personal information to a third party, such as a law enforcement agency, if required to do so by law. These Terms and Conditions shall be governed by and interpreted in accordance with the laws of the United States of America and any dispute arising out of or in connection with these Terms and Conditions shall be subject to the jurisdiction of the USA Courts.
The IIAV will not pass your personal information to any third party for marketing purposes without your consent.
We may share the personal information you provide to us with other companies we have hired to provide services for us. These companies – our vendors – are contractually bound to use personal information that we share with them only to perform the services we have hired them to provide.
We will take care to ensure that your personal information is secure. When we do provide mailing lists to third parties or vendors we enter into agreements with such parties requiring them to comply with all applicable laws, and prohibiting further distribution or disclosure of the lists to other parties.
Our websites are hosted and backed up on a server in Poland. We may transfer your personal information to countries outside the European Economic Area (where lower levels of data protection may apply) to make arrangements for any exhibition you have registered to attend, or in any other case where we have your specific consent.
You have the right to access personal information we hold on you.
You can ask us to correct any personal information we hold on you.
To review the information IIAV currently holds on you, please email and request to view your contact and demographic information.
Please let us know if any personal information you have given us changes, so we can keep our records up to date.
Further information about the cookies used by Google Analytics is given at Cookies and Google Analytics.
Videos and photographs are taken at an ICSV congress and used to promote future events, including direct mail and email marketing, newsletters, press releases and broadcasts over the internet, through our broadcast partners, or via other broadcast services. CCTV and webcams are not used by our organisation, although our exhibition venues may use them.
If we sell or transfer the whole or part of our business we may transfer personal information to the buyer or transferee.
We will regularly review and update this privacy notice and will ask for your consent before using your personal information in a way that is significantly different.
I agree and acknowledge that I am undertaking participation in an ICSV congress and activities as my own free and intentional act and I am fully aware that possible physical injury might occur to me as a result of my participation in these events. I give this acknowledgement freely and knowingly and that I am, as a result, able to participate in IIAV events and I do hereby assume responsibility for my own wellbeing and safety.
The IIAV plans to take photographs and video material at an ICSV and reproduce them in news or promotional material, whether in print, electronic or other media, including the IIAV and ICSV websites and social media. By participating in an ICSV, you grant the IIAV the right to use your name, photograph and biography for such purposes. All photographs and videos are the property of the IIAV and may be displayed, distributed or used by the IIAV for any purpose.
I hereby agree to release, defend, and hold harmless the IIAV and its agents or employees, including any firm publishing and/or distributing the finished product in whole or in part, from and against any claims, damages or liability arising from or related to the use of the photographs or video material, including but not limited to any misuse, distortion, blurring, alteration, optical illusion, or in the taking, processing, reduction or production of the finished product, its publication or distribution.
Companies that submit artwork or upload or link any material (including but not limited to images, text, documents and/or video files) to the website are solely responsible for the content of such material and for gaining required permissions under copyright, trademark, trade secret or other applicable law for the use of such material. (Caution: many websites purchase artwork from stock photo suppliers for the expressed website use or from hired photographers who have only supplied one-time rights.) By submitting any such material, the submitting company represents and agrees that (i) it has obtained the necessary permissions referenced above, (ii) any such material is not likely to defame and does not invade the privacy of any person, and (iii) it will defend, indemnify and hold harmless the company, its affiliates and their respective directors, employees and agents (including , without limitation, its publishing partner or any agent acting on its behalf) from and against any and all claims, damages, obligations, losses, liabilities, costs or debt, and expenses (including reasonable attorneys' fees) resulting from the submitting company's breach of the obligations set forth in this paragraph.
By registering for and attending an ICSV Congress, I hearby agree that I accept the terms stated above and, indemnify and hold harmless the IIAV, its affiliates and their respective directors, employees and agents (including, without limitation, any agent acting on its behalf) from and against any and all claims, damages, obligations, losses, liabilities, costs or debt and expenses (including reasonable attorneys' fees) resulting from attendance at ICSV Congresses.
Companies that submit artwork or upload or link any material (including but not limited to images, text, documents and/or video files) to the website are solely responsible for the content of such material and for gaining required permissions under copyright, trademark, trade secret or other applicable law for the use of such material (Caution: Many websites purchase artwork from stock photo suppliers for the expressed website use or from hired photographers who have only supplied one-time rights.) By submitting any such material, the submitting company represents and agrees that (i) it has obtained the necessary permissions referenced above, (ii) any such material is not likely to defame and does not invade the privacy of any person, and (iii) it will defend, indemnify and hold harmless the Company, its affiliates and their respective directors, employees and agents (including , without limitation, its publishing partner or any agent acting on its behalf) from and against any and all claims, damages, obligations, losses, liabilities, costs or debt, and expenses (including reasonable attorneys' fees) resulting from the submitting company's breach of the obligations set forth in this paragraph.
Any IIAV emails (and any attachments thereto) are confidential, and may be legally privileged, and are for the intended recipient(s) only. Access, disclosure, copying, distribution or reliance on any IIAV/ICSV emails by anyone else is prohibited and may be a criminal offence. Please delete IIAV emails if obtained in error and notify the sender. Any views expressed in IIAV emails are those of the individual sender, not those of the company unless endorsed by a legal officer of the IIAV.
So that you can make full use of the user-generated features on our website, your computer, mobile/cell phone, tablet or other device will need to accept cookies.
Below are the cookies that may be sent to your device by the IIAV and what we use each cookie for. You can set your browser to reject cookies (see the 'Help' menu of your browser to find out how to do this), but please bear in mind that if you do this, certain user-generated features of our websites cannot be provided to you. You will not be able to log in to the IIAV/ICSV websites to manage your participation online without accepting cookies.
Our cookies do not store personal information such as your name, address or registration data: they simply hold the unique ID that, once you are signed in, is associated with this information.
Files that allow a website to link the actions of a visitor during a single browser session. These might be used by an internet bank or webmail service. They are not stored long term and are considered "less privacy intrusive" than persistent cookies.
A cookie is classed as being first-party if it is set by the website being visited. It might be used to study how people navigate a site.
It is classed as third-party if it is issued by a different server from that of the domain being visited. It could be used to trigger a banner advert based on the visitor's viewing habits.
These remain on the user's device between sessions and allow one or several websites to remember details about the visitor.


Implementation of the GenericMarshaller interface for JAXB 2.2.
The typical usage will be to set either the "contextPath" or the "classesToBeBound" property on this bean, possibly customize the marshaller and unmarshaller by setting properties, schemas, adapters, and listeners, and to refer to it.
Convert the given JAXBException to an appropriate exception from the org.springframework.oxm hierarchy.
Return a newly created JAXB marshaller.
Return a newly created JAXB unmarshaller.
Return the list of Java classes to be recognized by a newly created JAXBContext.
Return the JAXB context path.
Return the JAXBContext used by this marshaller, lazily building it if necessary.
Return the packages to search for JAXB2 annotations.
Template method that can be overridden by concrete JAXB marshallers for custom initialization behavior.
Returns the configured value for whether XML external entities are allowed.
Whether DTD parsing is supported.
Marshal the object graph with the given root into the provided Result.
Marshals the object graph with the given root into the provided Result, writing binary data to a MimeContainer.
Specify the XmlAdapters to be registered with the JAXB Marshaller and Unmarshaller.
Specify whether the supports(Class) should check for @XmlRootElement annotations.
Set the list of Java classes to be recognized by a newly created JAXBContext.
Set a JAXB context path.
Set multiple JAXB context paths.
Set whether to lazily initialize the JAXBContext for this marshaller.
Specify a JAXB mapped class for partial unmarshalling.
Specify the Marshaller.Listener to be registered with the JAXB Marshaller.
Set the JAXB Marshaller properties.
Specify whether MTOM support should be enabled or not.
Set the packages to search for classes with JAXB2 annotations in the classpath.
Indicates whether external XML entities are processed when unmarshalling.
Set the schema resource to use for validation.
Set the resource resolver, as used to load the schema resources.
Set the schema resources to use for validation.
Indicates whether DTD parsing should be supported.
Specify whether the supports(Class) returns true for the JAXBElement class.
Set the Unmarshaller.Listener to be registered with the JAXB Unmarshaller.
Set the JAXB Unmarshaller properties.
Set the JAXB validation event handler.
Indicate whether this marshaller can marshal instances of the supplied type.
Indicates whether this marshaller can marshal instances of the supplied generic type.
Unmarshal the given Source into an object graph.
Unmarshals the given provided Source into an object graph, reading binary attachments from a MimeContainer.
Set multiple JAXB context paths. The given array of context paths gets converted to a colon-delimited string, as supported by JAXB.
Setting either this property, "classesToBeBound" or "packagesToScan" is required.
Setting either this property, "contextPath" or "packagesToScan" is required.
Set the packages to search for classes with JAXB2 annotations in the classpath. This is using a Spring-bases search and therefore analogous to Spring's component-scan feature (ClassPathBeanDefinitionScanner).
Setting either this property, "contextPath" or "classesToBeBound" is required.
Set the JAXBContext properties. These implementation-specific properties will be set on the underlying JAXBContext.
Set the JAXB Marshaller properties. These properties will be set on the underlying JAXB Marshaller, and allow for features such as indentation.
Set the JAXB Unmarshaller properties. These properties will be set on the underlying JAXB Unmarshaller.
Set the JAXB validation event handler. This event handler will be called by JAXB if any validation errors are encountered during calls to any of the marshal APIs.
Set the schema language. Default is the W3C XML Schema: http://www.w3.org/2001/XMLSchema".
Set whether to lazily initialize the JAXBContext for this marshaller. Default is false to initialize on startup; can be switched to true.
Specify whether MTOM support should be enabled or not. Default is false: marshalling using XOP/MTOM not being enabled.
Default is false, meaning that supports(Class) always returns false for JAXBElement classes (though supports(Type) can return true, since it can obtain the type parameters of JAXBElement).
This property is typically enabled in combination with usage of classes like MarshallingView, since the ModelAndView does not offer type parameter information at runtime.
Default is true, meaning that supports(Class) will check for this annotation. However, some JAXB implementations (i.e. EclipseLink MOXy) allow for defining the bindings in an external definition file, thus keeping the classes annotations free. Setting this property to false supports these JAXB implementations.
Default is false meaning that DTD is disabled.
Default is false, meaning that external entities are not resolved. Note that processing of external entities will only be enabled/disabled when the Source passed to unmarshal(Source) is a SAXSource or StreamSource. It has no effect for DOMSource or StAXSource instances.
Note: setting this option to true also automatically sets setSupportDtd(boolean) to true.
Return a newly created JAXB marshaller. JAXB marshallers are not necessarily thread safe.
Template method that can be overridden by concrete JAXB marshallers for custom initialization behavior. Gets called after creation of JAXB Marshaller, and after the respective properties have been set.
The default implementation sets the defined properties, the validation event handler, the schemas, listener, and adapters.
Return a newly created JAXB unmarshaller. Note: JAXB unmarshallers are not necessarily thread-safe.


text:
Yamaha MT-15 Beats Sales of Yamaha YZF-R15 V 3.0 V 3.0, Yamaha FZ25 and KTM 125 Duke
May 28, 2019 by Team Bike India Leave a Comment
The Yamaha MT-15 has become a threat to three motorcycles, namely the Yamaha YZF-R15 V 3.0, the Yamaha FZ25 and the KTM 125 Duke.
The Yamaha MT-15 had beat the sales of the KTM 125 Duke in March by almost 2,000 units. April sales figures tell us that the Yamaha MT-15 has yet again beat the sales of the KTM 125 Duke. It has also overtaken Yamaha's YZF-R15 V 3.0 and FZ25. The MT-15 costs Rs 1.36 lakh and the KTM 125 Duke costs Rs 1.25 lakh making the MT-15 Rs 11,000 more expensive than the 125 Duke; all prices are ex-showroom. Meanwhile, the Yamaha YZF-R15 V 3.0 is sold for 1.33 lakh (ex-showroom) making it Rs 3,000 more expensive than its naked sibling. The Yamaha FZ25 falls in the 250-cc segment and costs 1.33 lakh (ex-showroom) which is Rs 3,000 cheaper than the MT-15, making it an interesting value-for-money proposition.
Recent reports state that the Yamaha MT-15 has sold 3,823 units in April. Meanwhile, there has been a 24 per cent decline in the sales of the FZ25; selling only 989 units as compared to the 1,508 units sold in March. The Yamaha YZF-R15 V 3.0, on the other hand, sold 4,975 units in April 2019 and saw an 18 per cent decline in sales as compared to the 6,034 units sold in the same month in 2018. The KTM 125 Duke that is being offered in India is not the international-spec model and the MT-15 that borrows its looks from the MT-09 is proving to be a more attractive motorcycle for buyers. The KTM 125 Duke sold 2,199 units last month, which is around 1,600 units less than the Yamaha MT-15.
The Yamaha MT-15 is powered by the same 155-cc, liquid cooled, four-stroke, SOHC, four-valve engine from the YZF-R15 V3.0 that produces 19.3 PS at 10,000 rpm and a peak torque of 14.7 Nm at 8,500 rpm. The motor is mated to a six-speed gearbox that comes with a slipper clutch as standard. The Yamaha offers a slightly more powerful engine and more features such as a slip-and-assist-clutch. These, along with the sharp and futuristic design, give the Yamaha MT-15 a major advantage over the KTM 125 Duke. Perhaps, one of the reasons why buyers don't mind spending more to get their hands on the MT-15. The things that the MT-15 misses out on are dual-channel ABS and the gold anodized USD forks that we see in the international-spec model.
The Yamaha MT-15 is proving to be a game-changer with its launch in India and is taking on many motorcycles head-on in the sales department. The MT range internationally offers the MT-15, MT-25, MT-03, MT-07, MT-09 and MT-10. In India, Yamaha are offering the MT-15 and the MT-09. We hope to see some new bikes from the MT range launching in India in the near future.
Also Read: First ride review of the Yamaha MT-15
Story: Azaman Chothia
Team Bike India – who has written 770 posts on Bike India.
Honda CRF1100L Africa Twin Adventure Sports 2021 Launched in India
Filed Under: KTM, Latest News, News, Yamaha Tagged With: 2019, bike, duke, India, KTM, latest, motorcycle, news, Sales, yamaha, yamaha MT-15
+ = eighteen


This paper examines existing international approaches and practices in the area of dealing with parties at fault in a bank failure and fraud in deposit insurance, considering various aspects of investigating and prosecuting actions and omissions that contributed to bank losses and failures.
This paper examines the deposit insurer's role in early detection and timely intervention frameworks and, where appropriate, suggests guidance in order to enhance these frameworks.
This paper discusses moral hazard in the context of the deposit insurer and the financial safety net and suggests instruments and best practices that can mitigate moral hazard.
This paper examines deposit insurance coverage and suggests additional guidance for effective deposit insurance practice as requested by the Financial Stability Board (FSB) Thematic Review on Deposit Insurance Systems: Peer Review Report.
This paper examines public awareness of deposit insurance systems and suggests additional guidance for effective deposit insurance practices as requested by the Financial Stability Board (FSB) Thematic Review on Deposit Insurance Systems: Peer Review Report.
This paper examines deposit insurer reimbursement systems and suggests additional guidance for effective deposit insurance practice as requested by the Financial Stability Board (FSB) Thematic Review on Deposit Insurance Systems: Peer Review Report.
This paper reviews the challenges, issues and effective practices for reimbursing depositors and sets out supporting guidance for the effective implementation of Core Principle 17 of the BCBS/IADI Core Principles for Effective Deposit Insurance Systems.


text:
Q: export table to excel file with leading 0s using bcp I need to upload following data to excel file using bcp command
id       |  phoneNo     | IsValid
--------------------------------------
1        |  011         |    1
2        |  011         |    1
3        |  022         |    1
4        |  022         |    1
5        |  033         |    1
6        |  011         |    1

Problem occurs when i trying to export telephone numbers. in excel leading zero's missing.
What i have tried so far-
alter procedure [dbo].[proc_generate_excel_with_columns]
(       @SERVERNAME VARCHAR(100),
        @db_name varchar(100),
        @table_name varchar(100),
        @file_name varchar(100)
)
as

--Generate column names as a recordset
declare @columns varchar(8000), @sql varchar(8000), @data_file varchar(100),@schemaTable varchar(100)

--set @table_name='test'
set @schemaTable='dbo.'+ @table_name

select
        @columns=coalesce(@columns+',','')+column_name+' as '+column_name
from
        information_schema.columns
where
        table_name=@table_name

select @columns=''''''+replace(replace(@columns,' as ',''''' as '),',',',''''')

--Create a dummy file to have actual data
select @data_file=substring(@file_name,1,len(@file_name)-charindex('\',reverse(@file_name)))+'\data_file.xls'

--Generate column names in the passed EXCEL file
set @sql='exec master..xp_cmdshell ''bcp " select * from (select '+@columns+') as t" queryout "'+@file_name+'" -c -S'+@SERVERNAME+' -T '''

exec(@sql)

--Generate data in the dummy file

set @sql='exec master..xp_cmdshell ''bcp "select * from '+'['+@db_name+']'+'.'+@schemaTable+'" queryout "'+@data_file+'" -c -S'+@SERVERNAME+' -T '''
PRINT @sql
exec(@sql)

--Copy dummy file to passed EXCEL file
set @sql= 'exec master..xp_cmdshell ''type '+@data_file+' >> '+@file_name+''''

exec(@sql)

--Delete dummy file
set @sql= 'exec master..xp_cmdshell ''del '+@data_file+''''
exec(@sql)

How can i solve this problem? I found Solution here , but it mentioned use code like this.
SELECT '="' + phoneNo+ '"' from Phone

but it seems i can't come up with this solution. How can i overcome with this problem.
Thanks

A: For this i have created intermediate table, i use that table in bcp command.
create table temp_WriteDataToFile(PHONE text, IsValid varchar(1))

insert into temp_WriteDataToFile
 select '="'+ PHONE +'"',ACMA,convert(varchar(25)) from temp_ProcessData

it need get value in following format :
="011 "

then it will allow to write in excel/csv command with leading zero's


Below you find an overview of the current international service alerts. With the International Service Alerts we keep you informed on the consequences that current events in the world might have on the delivery of your international shipments. Once an update is available we will publish the additional information below.


text:
#ifndef TYPE_SPECIFICATION_VISITOR_HH
#define TYPE_SPECIFICATION_VISITOR_HH

#include "HooBaseVisitor.h"

#include <hoo/parser/ErrorListener.hh>

using namespace antlr4;
using namespace antlrcpp;

namespace hoo
{
    namespace parser
    {
        class TypeSpecificationVisitor : public HooBaseVisitor
        {
        private:
            ErrorListener *_error_listener;

        public:
            TypeSpecificationVisitor(ErrorListener *error_listener);

        public:
            Any visitBasicDataTypeSpecifier(HooParser::BasicDataTypeSpecifierContext *ctx) override;

            Any visitIdentifierTypeSpecifier(HooParser::IdentifierTypeSpecifierContext *ctx) override;

            Any visitNestedTypeSpecifier(HooParser::NestedTypeSpecifierContext *ctx) override;

            Any visitArrayTypeSpecifier(HooParser::ArrayTypeSpecifierContext *ctx) override;
        };
    } // namespace parser
} // namespace hoo

#endif


text:
{% extends "index.html" %}
{% load staticfiles %}
{% block corpo %}
<meta http-equiv="refresh" content="20">

Informações POX

     {% if status = 1 %}

O Controlador POX está ATIVO

       {% else %}

POX está INATIVO .. Verifique

     {% endif %}

{% endblock %}


though everyone has interacted with money from a very early stage in life. Students find it difficult to acquire the knowledge of basic terms, facts, concepts, principles and assumptions in economics such as the concepts of welfare, law of demand and supply, the meaning of a poverty-line and economic planning. At MyAssignmentExpert.com, we help students develop familiarity with the basic terminology and elementary as well as advanced ideas of economics. We try simplifying the information for students and try to give suitable examples from their day-to-day lives to ensure that they are able to imbibe the facts in a better fashion.
An integral part of economics is to ensure that students are aware of contemporary economic problems. At MyAssignmentExpert.com, we help students in writing critical analyses of the current economic situation – the quality of the work is impeccable because not only do our experts prepare the answer by highlighting the flaws; all efforts that are being made to solve the problems are also appreciated in the economics assignment. Presenting both sides of the coin always enhances your chance of getting a good grade.
Economics encourages students to develop an understanding of the country's physical and human resources and of avoiding misuse. It also teaches students various economic processes that help in improving the standard of living. In classrooms, the theory often gets delivered but the practical aspects may not be outlined appropriately as a result of which students find economics to be, sometimes, dull. At MyAssignmentExpert.com, we try to liven up the subject and even though our answers are all technically correct, they will never be boring to read.
Economics also involves having some practical knowledge – such as knowing how to interpret basic statistical data. MyAssignmentExpert.com extends its services to even completing economics projects for you – be it a project involving a survey of a particular area to find out the number of working and non-working population and the extent of unemployment or a study on any economic institution explaining its mode of functioning and its importance to local or national economy.
Economics as a subject is very useful in everyone's life because of its practical application. Everyone should have some knowledge about money and banking at a basic level. Economics students are expected to know greater details of concepts like credit creation, the differences between nationalized and privatized banks, the various types of inflation such as cost-push, demand-pull and the effects of these on economies. At some point, students may get jumbled up because it all may seem like a bit too much for them to remember. MyAssignmentExpert.com comes to the rescue of such students by helping them prepare examination notes to ensure that the students not only get conceptual clarity but also that they score very well in their examinations.
Submit your Economics assignment requirements now and be pleasantly surprised with our quote.
Make Payment to confirm the Economics assignment and relax.


The Village Review Overlay Zone provides architectural guidance to property owners within the zone. No change, as determined through the criteria of Section 403.5, to the exterior of an existing building, no addition to an existing building, or any new construction shall occur in the Village Review Overlay Zone without approval of either the City Staff or the Planning Board, as set forth in Section 403.8.
Changes to the exterior appearance of a building or an addition with a footprint equal to, or less than, 3,000 square feet may be reviewed by City Staff. For all administrative reviews a building permit application must also be filed.


Dr Sebagh Signature Serum harnesses the latest biotechnology to increase DNA life-span and boost cell energy for faster and more effective cell renewal – essential for younger looking skin. Its intensely moisturising properties and cutting edge anti-ageing ingredients, has been in development for more than 5 years to produce a super serum which is like no other.
Dr Sebagh Signature Serum is available exclusively in one retail store per country. In the United Kingdom, it is available exclusively in Harrods. In USA, it is available at Barneys.
"This is one of the very first products Dr Sebagh created, but it was just for clients at the clinic and they can be demanding, so it had to be something that delivered fast, and on lots of levels ... Creamy enough to be the perfect daily all-in-one or used under a favourite cream. Either way, skin looks plumper, firmer and healthier within two weeks."
"This is the Birkin bag of anti-aging serums."
This product is one of the best beauty products I've ever used! Definitely makes my skin feel lush, and VERY smooth. I'm in my 50's, and after using this product for a week, I feel like my skin in the best it's been in years!! I will be a life-long user of this product.
If you are going to spend this kind of money, this is the serum to purchase! The result is substantial and immediate. I love it. I would love it more often if they could ease up on the price a bit.
I just purchased this product when placing a phone order to the Chicago, IL Barneynsnewyork Store. I spend thousands on Dr. Sebaugh products often at Barneys! I was planning on restocking several Dr. Sebaugh items and several new items I had read about on-line and quite disappointed the Barneys in Chicago hadn't called me in awhile to inform me of the new & larger Dr. Sebaugh items. On my own DEMAND (as I was geared to other lines from SA ) I reordered some of my regular Dr. Sebaugh products and with NO OFFER OR HELP OR ADVICE FROM SA ordered the $830.00 SIGNATURE SERUM which came with no directions, except for a card. Read this card & live in IOWA !! So...with that sad news I also read that had I ordered thru this website I would have received FREE GIFTS ALONG WITH MY ORDER OF SIGNATURE SERUM that I happened to buy in Chicago Barneys-never again ( Chigago SA's beyond terrible!) My mistake as I just ordered from Chocago store & not thru your site. Do u ever send out the gifts without order thru website since it is $830 and unfortunately I'll never be able to get an appt of my dreams?
Dr Sebagh explains what makes his new serum so special, so expensive - and so worth it.
The unique formulation, developed to repair and minimise the key signs of skin ageing, combines powerful moisturisers and antioxidants with protective, anti-wrinkle, firming and smoothing active ingredients. In tandem with the body's own chronobiological clock, it is especially potent at night, when the skin's regenerative process takes place.
It also includes a pioneering active ingredient that combats the ageing of the cell's nucleus – encouraging it to behave like a young cell and so delaying the metabolic and nucleus senescence (the process of deterioration with age). It also limits oxidative stress and Telomeres shortening to ensure optimum metabolism and the replication of young cells.
Gently scented with rose, the serum has a delightful non-greasy texture that provides a luxurious long-term benefit and care throughout a 24 hour period.
AQUA (WATER), ISONONYL ISONONANOATE, DIPENTAERYTHRITYL HEXACAPRYLATE/HEXACAPRATE, CAPRYLIC/CAPRIC TRIGLYCERIDE, EUGLENA GRACILIS EXTRACT, DIMETHYL ISOSORBIDE, ISOSTEARYL ISOSTEARATE, BIOSACCHARIDE GUM-4, DIMETHICONE, PHENOXYETHANOL, CAPRYLIC/CAPRIC/SUCCINIC TRIGLYCERIDE, LAUROYL LYSINE, RHIZOBIAN GUM, SODIUM HYALURONATE, ALPHA-GLUCAN OLIGOSACCHARIDE, PROPANEDIOL, CHLORPHENESIN, DIMETHICONE/VINYL DIMETHICONE CROSSPOLYMER, SODIUM POLYACRYLATE, C18-C21 ALKANE, CAPRYLYL GLYCOL, GLYCERIN, SESAMUM INDICUM (SESAME) SEED OIL, CITRIC ACID, PEG-20 SORBITAN COCOATE, AROMA (FLAVOR), TRITICUM VULGARE (WHEAT) GERM OIL, ALGIN, PHOENIX DACTYLIFERA (DATE) SEED EXTRACT, TOCOPHERYL ACETATE, TRIDECETH-6, BRASSICA CAMPESTRIS (RAPESEED) STEROLS, POTASSIUM SORBATE, TOCOPHEROL, BHT, CI 14700 (RED4), CITRONELLOL, BENZYL ALCOHOL, GERANIOL.