How Schema On Read vs. Schema On Write Started It All

first_imgArticle originally appeared as Schema On Read vs. Schema On Write Explained.What’s the difference between Schema on read vs. Schema on write?How did Schema on read shift the way data is stored?Since the inception of Relational Databases in the 70’s, schema on write has be the defacto procedure for storing data to be analyzed. However recently there has been a shift to use a schema on read approach, which has led to the exploding popularity of Big Data platforms and NoSQL databases. In this post let’s take a deep dive into what are the differences between schema on read vs. schema on write.What is Schema On WriteSchema on write is defined as creating a schema for data before writing into the database. If you have done any kind of development with a database you understand the structured nature of Relational Database(RDBMS) because you have used Structured Query Language (SQL) to read data from the database.One of the most time consuming task in a RDBMS  is doing Extract Transform Load (ETL) work. Remember just because the data is structured doesn’t mean it starts out that way. Most of the data that exist is in an unstructured fashion. Not only do you have to define the schema for the data but you must also structure it based on that schema.For example if I wanted to store menu data for a local restaurant how would I begin to set the schema and write the data into the database? First task is to setup the tablesItemIngredientsNutritional values All those steps had to be done before being able to store the data and analyze it for new insights. The overhead for having to do the ETL is one of the reasons new data sets are hard to get into your Enterprise Data Warehouse(EDW) quickly.What is Schema On ReadSchema on read differs from schema on write because you create the schema only when reading the data. Structured is applied to the data only when it’s read, this allows unstructured data to be stored in the database. Since it’s not necessary to define the schema before storing the data it makes it easier to bring in new data sources on the fly.The exploding growth of unstructured data and overhead of ETL for storing data in RDBMS is the main reason for shift to schema on read. Many times analyst aren’t sure what types of insights they will gain from new data sources which is why getting new data source is time consuming. Remember back to our schema on write scenario let’s walk through it using schema on read. First step is to load our data into the databaseBoom! We are done! All of the menu data is in the database. Any insights we want to investigate we can try and apply the schema while testing. Let’s be clear though, we are still doing ETL on the data to fit into a schema but only when reading the data. Think of this as schema on demand!Key Differences Schema On Read vs. Schema On WriteSince schema on read allows for data to be inserted without applying a schema should it become the defacto database? No, there are pros and cons for schema on read and schema on write. For example when structure of the data is known schema on write is perfect because it can return results quickly. See the comparison below for a quick overview:There is no better or best with schema on read vs. schema on write. Just like most things in development– it depends on the use case. Is the workload mostly data supporting a dashboard where the results need to be fast and repetitive? It’s going to need to use a schema on write database. Will there be a lot of unknowns with the data and constant new sources? Sounds like a schema on read will work. Next index items to map relationshipsThen write a regular expression to extract fields for each table in the databaseLastly write SQL insert statements for extracted datalast_img read more

New Fredonia Restaurant Opens In Former Wing City Grille Building

first_imgSubmitted image.FREDONIA – A new restaurant is now open in the former Wing City Grille building on Route 60 across from Walmart in the Village of Fredonia. Officials say a ribbon cutting ceremony was held Tuesday at Buddy Brewster’s Ale House, which is owned by Andrew and Amber Carlson. The Carlson’s say they decided to take advantage of the downtime this past spring from the restaurant industry shutdown to remodel the building.“We brought in our chef from the Chop House on Main in Jamestown, Burke Lindquist, to create an amazing new menu,” Andrew Calrson said. “We offer a fresh homemade menu and a full bar including twelve draughts from local breweries.”“We are very excited to be part of the Fredonia community and have taken extra measures to ensure the safety of our guests through these difficult times.” Emily Aults is the General Manager of the new restaurant.County Executive P. J. Wendel, Fredonia Mayor Doug Essek, and representatives from the Fredonia and Dunkirk Community Chambers of Commerce were on hand  to help the Carlson family and staff cut a ribbon to formally open the new restaurant.Guests can order online at and pick up curbside, or can stop in. Seating in the dining room is available.Buddy Brewster’s Ale House is open 11am to 10pm daily serving lunch and dinner. Share:Click to share on Facebook (Opens in new window)Click to share on Twitter (Opens in new window)Click to email this to a friend (Opens in new window)last_img read more

Go Backstage at B’way’s Finding Neverland With Matthew Morrison

first_imgNew musical Finding Neverland has finally landed on the Great White Way and the show’s headliner Matthew Morrison recently took GMA co-host Lara Spencer behind-the-scenes. As we know, the Glee star began his career on the boards as a dancer and he showed off some impressive breakdancing skills to Spencer. He also explained that the new musical is a “marathon,” and revealed that to save his voice: “I don’t talk when I go home. My wife and I have little cue cards and stuff!” Check out the interview below and then the tuner, currently in preview and co-starring Kelsey Grammer and Vlogger Laura Michelle Kelly, at the Lunt-Fontanne Theatre. Show Closed This production ended its run on Aug. 21, 2016 View Comments World News Videos | US News Videoscenter_img Related Shows Finding Neverlandlast_img read more

Governor outlines plan for closing Vermont State Hospital

first_imgGovernor Peter Shumlin said today that the Vermont State Hospital in Waterbury, which was closed following Tropical Storm Irene, will not re-open, and outlined his plan to ensure Vermont’s mental health community has access to quality services across the state. The plan includes acute in-patient care in at least two locations, increased services that enable individuals to remain in their communities, expanded local emergency services, and increased support for effective programs helping those with mental health conditions. The governor said these improvements would be monitored and evaluated, and discussions about a long-term plan will continue, and acknowledged the need to talk about other inpatient capacity. ‘Building a replacement facility is years away at best, and we need to put services in place now to ensure all Vermonters have access to the care they need,’ Shumlin said. ‘The absence of the hospital creates the opportunity to fund community services for recovery that can help prevent the need for hospitalization. We believe that all of these actions taken together will meet Vermont’s mental health needs.’ The following actions are in motion: Establish a long-term agreement with the Brattleboro Retreat for 14 acute care beds. The Retreat has been helping since the flood to provide up to 15 beds and will make some renovations to allow them, on a long term basis, to care for individuals with higher needs for supervision and management. 2.      Fund two additional ‘step down’ facilities (similar to Second Spring in Williamstown) for people ready to leave the hospital, so that individuals ready to move from the hospital to another setting for recovery have quick access to a bed. This will help ensure hospital beds are reserved for those in need for that level of service. Deliver on the long-overdue promise of community-based mental health services. Continue to find and secure a facility that can provide 15 beds for appropriate care and services for people in need of acute care. We have looked at many possibilities already and continue to search. Pine Ridge School in Williston is under active consideration, as is a site located near the Central Vermont Medical Center. Governor Shumlin praised the heroic efforts of Vermont State Hospital staff and patients for not only safely evacuating the facility during the tropical storm, but for staff continuing to travel far from home to provide support in other settings. He also thanked community hospitals for providing care to individuals whose needs often exceed what the hospitals are designed to handle.  ‘This crisis is an opportunity to rebuild our mental health services to make them better than before. That’s just what we intend to do,’ the  governorsaid.  Goveror’s office. 10.20.2011last_img read more

Operation Martillo using a Stiletto to stop traffickers

first_imgBy Dialogo April 25, 2013 WASHINGTON, D.C., U.S.A. – Traffickers beware: You’re likely to be pursued by a Stiletto. No, not the knife, a boat – a 90-foot long, 40-foot-wide vessel that reaches speeds of more than 50 mph and is filled with radars and computers and screens to track anything on water. And its unique, M-shaped hull and four 1,650-horsepower diesel engines allow the US$10 million boat to zip across the water while leaving just a small wake. The Stiletto is expected to become even more of a major factor in Operation Martillo, a regional counter-narcotics mission that brings together Western Hemisphere and European countries to cut the flow of illicit drugs through Central America. The Stiletto also has space to store an inflatable boat, which counter-narcotics personnel can use to get closer to vessels they want to board. About 80% of cocaine shipments are moved via maritime routes. Nearly 90% of the cocaine that reaches the United States comes through Mexico and Central America, according to the United Nations International Narcotics Control Board. Operation Martillo is led by Joint Interagency Task Force South, based in Key West, Fla., but it relies heavily on working with law enforcement and military agencies in other countries. “All the nations along the Central American isthmus, the United States, European partners, Canadians, etc., have been working more closely than ever in my 30 years or so working this particular problem set, as a direct result of Operation Martillo,” said JIATF-S Director Rear Adm. Charles D. Michel in January, at the conclusion of the operation’s first year. And what a year it was. Launched in January 2012, Operation Martillo directly seized or assisted in the capture of 127 metric tons (279,987 pounds) of cocaine in 2012, JIATF-S authorities reported. Security forces also have seized 56 go-fast boats, six pangas, two motor vessels, two semi-submersible vessels, two sailing vessels, six vehicles, seven fishing vessels and 12 aircraft and arrested all those individuals who were operating those crafts, according to Michel. A go-fast boat typically carries 1,000 kilograms of cocaine. “Operation Martillo is designed to deny or significantly hamper the ability of the traffickers to operate in the littoral routes along both sides of the Central American isthmus and force them into the deep-water routes. We have not achieved that on both sides of the isthmus,” Michel said. “On the Caribbean side we have been able to change some of the trafficking patterns.” Operation Martillo has carried its momentum into 2013, as the year already has been marked by major narcotics seizures. • Panama’s National Aeronaval Service (SENAN) agents seized 1.475 tons of cocaine and arrested four Colombians, SENAN Director Belsio González said on April 23. The seizure – the country’s largest of the year – occurred this past weekend when authorities spotted a suspicious vessel off the coast of the central province of Veraguas. Officers chased the boat for several minutes before boarding it. The cocaine was packed in 59 bundles. • In early April, U.S. law enforcement authorities arrested 103 suspects on April 3 in what was described as a “massive operation” against heroin and cocaine traffickers from the Caribbean into the U.S. state of Connecticut. • U.S. and Guatemalan counter-narcotics forces seized more than 998 kilograms of cocaine worth upward of US$90 million in the eastern Pacific in early March. • The Costa Rican Coast Guard seized 1.5 tons of cocaine after four crew members fled a boat to avoid arrest on March 13, Mauricio Boraschi, Costa Rica’s national anti-drug commissioner, said. Costa Rican officials have seized five tons of cocaine, eradicated 51,494 marijuana plants and broken up four narco-trafficking gangs so far this year, according to the Ministry of Security. • On Jan. 4, the USS Gary, a United States Navy frigate, intercepted a suspicious vessel carrying 600 pounds of cocaine. Coast Guard officers seized the shipment, which had a street value of about US$22 million. Michel, however, said there’s more work to be done. “We have seen strategic shifts in trafficking patterns in the Western Caribbean,” he added. “In the Eastern Pacific side, we are still working on that. We have seen some shifts but on the Pacific side we have a lot more challenges than we do on the Caribbean side in significantly changing those routes. One thing I will say about routes outside of Central America is that we have not yet been able to sense significant shifts into other routes, for example deeper into the Eastern Pacific or to Asia, or through the Central Caribbean or Eastern Caribbean. Those routes are essentially the same as they were before but we are constantly trying to sense those routes.”last_img read more

A look at what’s ahead for credit cards

first_imgby: Brian ScottIn almost every industry, a new year means new trends and expectations. The credit card industry is no different. EMV chip cards are receiving a great deal of attention these days, but it isn’t the only change the world of credit cards will see in 2015.A recent U.S. News article highlights five specific trends the credit card industry is likely to experience this year.Advancements in security features — Beyond the distribution of millions of EMV chip cards, enhancements to overall card security are expected this year. Innovations in monitoring credit card activity are among the anticipated changes.Free credit scores — In early 2014, the Consumer Financial Protection Bureau (CFPB) began urging major credit card issuers to provide free credit scores on consumers’ statements. Although this score may well differ from the score a lender sees when a consumer applies for a loan, more issuers are expected to begin providing scores in 2015.Increased access to credit — A combination of healthier credit scores and more lenient lending standards are predicted to result in more easily obtained credit for many consumers. This presents a potential threat for credit unions and community banks working with outdated risk models. continue reading » 5SHARESShareShareSharePrintMailGooglePinterestDiggRedditStumbleuponDeliciousBufferTumblrlast_img read more

7 money resolutions to make in 2016

first_imgIt’s almost January 1. No matter what your financial goals, now is the time to tackle them. You’re starting fresh (tax-wise, anyway), you’re probably a little cash-shocked from the holidays, and you’re in a goal-setting frame of mind. Need more incentive? According to a 2015 Fidelity survey, 29 percent of those people who made money-related resolutions at the start of 2014 actually achieved their goals, while 74 percent got at least halfway there. What’s more, half believed they were better off financially. Here are seven ways to improve your fiscal picture.Start a budget. The first step in whipping your finances into shape is figuring out where your cash ends up each pay cycle. Fortunately, monitoring your spending habits is easy—no complicated spreadsheet needed. If you’re the pencil-and-paper type, crunch the numbers with a Dome Simplified Home Budget Book. For a high-tech way to track every penny, use a budgeting tool such as It pulls all of your personal financial accounts into one place, categorizes them, tracks them, and helps you create a spending plan. Nice feature: You can set up your account to send alerts whenever you’re close to going over in any category.“It’s very important for people to understand where their money is going,” says Howard Pressman, a financial planner in Vienna, VA. “The problem is that many people don’t like what the results are, as they realize how much money they’re wasting on odd things.” continue reading » 64SHARESShareShareSharePrintMailGooglePinterestDiggRedditStumbleuponDeliciousBufferTumblrlast_img read more

Swiss €8bn public pension fund developing sustainability strategy

first_imgHe told IPE the pension fund had assessed its existing portfolio, but he could not say much more about what its next steps would be as it was still in discussions with the board of trustees.The strategy would be finalised by early summer, according to Wetterwald.He indicated it would be informed by Swiss and international “norms” – laws and conventions – about sustainability.BLPK is the Swiss responsible investment association’s ninth member. The environmental, social and corporate governance (ESG) criteria that SVVK-ASIR applies are also defined on the basis of Swiss laws and regulations, as well as international agreements and conventions.BLPK’s move to develop a “sustainable investment strategy” comes as many Swiss Pensionskassen, according to an independent adviser, are “overwhelmed” by the ESG investing trend.According to the World Wildlife Fund and ratings agency Inrate, the majority of the 20 largest Swiss pension funds “are still relatively far off the WWF vision for the second pillar to play an active role in helping shape a more sustainable society”.BLPK has around 24,000 beneficiaries and more than 200 affiliated employers, including local authorities, retirement homes, and higher education institutions.In response to lower return expectations, the pension fund last year cut the “technischer Zinssatz” – the rate it uses to calculate liabilities – from 3% to 1.75%.As a result it is also implementing a gradual reduction of the conversion rate that determines a beneficiary’s yearly pension. For a 65-year old, this is to be lowered from 5.8% to 5% by 2022. The public pension fund for the Swiss canton of Basel-Landschaft is developing an investment strategy more oriented towards sustainability.Implementation of such a strategy was “top of the agenda” for 2019, Basellandschaftliche Pensionskasse (BLPK) said in a statement.It became a member of SVVK-ASIR, a Swiss responsible investment association that was founded by a group of major domestic institutional investors, at the beginning of the month.Stephan Wetterwald, chief executive at the CHF9.4bn (€8.3bn) pension fund, said: “We are aware that as a public pension fund, we are particularly called upon to take account of ethical as well as economic criteria in our investment policy.”last_img read more

Out of this world Gold Coast mansion hits the market with $30 million price tag

first_imgA waterfront mansion at 7-13 King Arthurs Court, Sovereign Islands, is up for grabs for an eye-watering $30 million.A FUTURISTIC Gold Coast house with a $30 million price tag has hit the market, a week after a $45 million mansion was listed for sale in the same prestige enclave.The Sovereign Islands home at 7-13 King Arthurs Court will return to the market after a two-year sales campaign ended in July.RELATED: Gold Coast’s biggest mansion hits market with $45 million price tagThe eye-watering price looks like a steal compared to the Glitter Strip’s biggest mansion at 26 Knightsbridge Pde East, which was listed with a US$30 million ($A45 million) price tag.The first property to sell will set a new price record for the Coast, eclipsing the $27 million benchmark held by a Mermaid Beach house.The futuristic property is launching back onto the market after a two-year sales campaign ended in July.The front door alone is worth almost $500,000.MORE NEWS: Rent fitness queen Ashy Bines’ home MORE NEWS: Agents share their most embarrassing moments Bespoke International Realty managing director Patrick Pancur, who is marketing the property alongside James Drake, has carried the King Arthurs Court listing across from his previous agency and said the Gold Coast’s prestige market was “where it was at”.“These types of properties very rarely come on the market, to see both on Sovereign Islands of this calibre is very rare, a once-in-a-lifetime opportunity,” Mr Pancur said.“A lot of properties are moving in the prestige space and that has stemmed from interstate buyers taking the opportunity for the lifestyle change. This particular one is built like a Swisse watch, everything is very detailed, intricate and customised.”Video Player is loading.Play VideoPlayNext playlist itemMuteCurrent Time 0:00/Duration 1:32Loaded: 0%Stream Type LIVESeek to live, currently playing liveLIVERemaining Time -1:32 Playback Rate1xChaptersChaptersDescriptionsdescriptions off, selectedCaptionscaptions settings, opens captions settings dialogcaptions off, selectedQuality Levels720p720pHD540p540p360p360p270p270pAutoA, selectedAudio Tracken (Main), selectedFullscreenThis is a modal window.Beginning of dialog window. Escape will cancel and close the window.TextColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentBackgroundColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparentWindowColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaqueFont Size50%75%100%125%150%175%200%300%400%Text Edge StyleNoneRaisedDepressedUniformDropshadowFont FamilyProportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall CapsReset restore all settings to the default valuesDoneClose Modal DialogEnd of dialog window.This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.Close Modal DialogThis is a modal window. This modal can be closed by pressing the Escape key or activating the close button.PlayMuteCurrent Time 0:00/Duration 0:00Loaded: 0%Stream Type LIVESeek to live, currently playing liveLIVERemaining Time -0:00 Playback Rate1xFullscreen7-13 King Arthur Court01:33It is the second mansion to hit the market with a jaw-dropping price tag this month.The property took three years to build.The mansion was designed by architect John Lea and took three years to build.The owners, German super yacht builder Klaus Lilischkies and his wife Leigh, spent $13 million creating the mini resort, which is known as Chateau de Reves, French for “castle of dreams”.“This house has been their holiday house, they have always lived overseas and just completed a home in Dubai on the same scale and have decided to reside overseas rather than on the Gold Coast,” Mr Pancur said.“The finishes are unmatched, you couldn’t replicate this finish.“We have had interest from the Philippines, Hong Kong and the Middle East. A lot of money is moving from Hong Kong at the moment and interest from Hong Kong has spiked.”More from news02:37International architect Desmond Brooks selling luxury beach villa9 hours ago02:37Gold Coast property: Sovereign Islands mega mansion hits market with $16m price tag1 day agoIt has a build cost of $13 million.The bar is “bigger than some nightclubs.”Eight ensuited bedrooms, including staff quarters, a 16-seat formal dining room, pool with 24 karat gold detailed tiles, a Turkish steam room, massage room, sauna, tennis court, 14 car basement and an extravagant stainless-steel staircase are highlights of the property.The entertainment options are also endless with a cinema, teppanyaki grill, wine cellar and bar with a dance floor that is “bigger than some nightclubs”.The front door was designed by Antoni Gaudi, a famous Spanish architect, and is worth almost $500,000.There’s also a bulletproof door to the main bedroom, a space that also features a retractable skylight, lavish custom-designed rotating bed and a dedicated shoe wardrobe.The three-storey house has 4000sq m of living space and is on a 3070sq m block with 85m of [email protected] Player is loading.Play VideoPlayNext playlist itemMuteCurrent Time 0:00/Duration 1:42Loaded: 0%Stream Type LIVESeek to live, currently playing liveLIVERemaining Time -1:42 Playback Rate1xChaptersChaptersDescriptionsdescriptions off, selectedCaptionscaptions settings, opens captions settings dialogcaptions off, selectedQuality Levels720p720pHD540p540p360p360p270p270pAutoA, selectedAudio Tracken (Main), selectedFullscreenThis is a modal window.Beginning of dialog window. Escape will cancel and close the window.TextColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentBackgroundColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparentWindowColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaqueFont Size50%75%100%125%150%175%200%300%400%Text Edge StyleNoneRaisedDepressedUniformDropshadowFont FamilyProportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall CapsReset restore all settings to the default valuesDoneClose Modal DialogEnd of dialog window.This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.Close Modal DialogThis is a modal window. This modal can be closed by pressing the Escape key or activating the close button.PlayMuteCurrent Time 0:00/Duration 0:00Loaded: 0%Stream Type LIVESeek to live, currently playing liveLIVERemaining Time -0:00 Playback Rate1xFullscreenTop 5 hot Brisbane suburbs 01:43last_img read more

Claims on Govt Cannabis Pamphlet Labelled As “Inflated”, “Unrealistic”, “Unachievable” – NZMJ

first_imgMedia Release SayNopeToDope NZ 3 August 2020The claims on the cannabis referendum pamphlet sent to households by the government have been labelled as ‘inflated’, ‘unrealistic’, and ‘unlikely to be achievable’ in the latest edition of the New Zealand Medical Journal. And the proposed bill comes in for scathing criticism from the Auckland University academics who authored the article.The article “New Zealand’s ‘Cannabis Legalisation and Regulation Bill’: an evidence-based assessment and critique of essential regulatory components towards policy outcomes” by Benedikt Fischer and Dimitri Daldegan-Bueno assert that illegal cannabis markets and supply will remain “active and resilient after the implementation of legalisation”, that there is “no reason to assume why young people’s access to cannabis should be expected to decrease in the context of—overall increased—availability of both legal and illegal markets/supply”, and that “legal production, distribution and use is also likely to increase, rather than decrease cannabis ‘public visibility’, and overall societal ‘normalisation’” as a result of any potential legalisation.Other parts of the proposed legislation also come in for significant criticism:“the age limit is inconsistent with age limits for other legal drug use… [F]or alcohol use—an arguably more hazardous substance, especially for young people—no minimum consumption age exists, and the purchase age for tobacco products is 18 years. Thus, the proposed age limit for cannabis is not scientifically supported but appears rather arbitrary, nor is it consistent or policy-coherent in regards to other, widely used legal substances. Here political considerations appear to have trumped science, with questionable compromising for results.”“limiting cannabis use to private homes, by design, will bring substantial health risk to other parties; it also contravenes longstanding efforts to direct away tobacco smoking from homes.”“‘home-growing’ creates a backdoor that directly undermines these protective safeguards. The restrictions for cannabis ‘home-growing’ are practically impossible for authorities to monitor or enforce (unless accepting inspections to regularly search private homes)… [H]ome-growing facilitates potential and easy access to cannabis products by others (eg, including minors), and so can easily enable cannabis diversion”For retail distribution, it is “unclear how density for legal cannabis retail outlets will be regulated or restricted” and that “despite well-intended public health goals, their operational viability and economic success will naturally depend on and strive for increased volumes of customers and sales.”“commercial cannabis industry entities will likely either quickly merge with, or follow the commercial business strategies of large-scale multi-national cannabis, or alcohol and tobacco corporations.”“many cannabis products the legal retail market—for example, for health protections—restricts or bans will remain on offer by illegal sources.”Regarding criminalisation and ‘social justice’, “it is unlikely that the extensive list of new and remaining offenses defined, combined with the likely levels of popular (non-) compliance, will lead to such substantial reductions.” And that “it is unclear whether the practical enforcement of core offenses under legalisation will substantially serve to improve social justice, or rather shift while extending previous discretion and systemic biases under new covers. Conversely, there are key areas where substantially increased, targeted law enforcement would be required to secure legalisation’s essential public health and safety objectives.”“This is a scathing assessment of the sales pitch that the government has given voters. The government tries to argue through their pamphlet that “The bill’s purpose is to reduce harm to people and communities” – but that is purely the view of those lobbying for change. Those against the legislation are arguing that legalisation will lead to more harm to people and communities, and this latest analysis backs our position,” says spokesperson Aaron Ironside.“The use of cannabis is associated with increased risks of a number of adverse outcomes including educational delay, welfare dependence, increased risks of psychotic symptoms, major depression, increased risks of motor vehicle accidents, increased risks of tobacco use, increased risks of other illicit drug use, and respiratory impairment. At a time when New Zealand’s mental health system is bursting at the seams, why would we go and legitimise a mind-altering product which will simply add to social harm?”last_img read more