text:
Home Investments FSSA IM Portfolio Manager Sophia Li: Japan – Land of Hidden Gems
FSSA IM Portfolio Manager Sophia Li: Japan – Land of Hidden Gems
Sophia Li FSSA Investment Manager Portfolio Manager
Caproasia.com | The leading source of data, research, information & resource for financial professionals, institutional investors, professional investors and private investors (UHNWs, & HNWs). Covering capital markets, investments and private wealth in Asia. How do you invest $3 million to $300 million? How do you manage $20 million to $3 billion of assets?
This site is for accredited investors, professional investors, investment managers and financial professionals only. You should have assets around $3 million to $300 million or managing $20 million to $3 billion.
Extract of Investment commentary: Fund Manager Q&A on Japan – Land of Hidden GEM by FSSA IM Portfolio Manager Sophia Li (August 2021):
FSSA Investment Managers (FSSA IM) is an autonomous team within First Sentier Investors. FSSA IM are bottom-up investors, using fundamental research and analysis to construct high-conviction portfolios, conducting more than a thousand direct company meetings a year, seeking to identify high quality companies that they can invest in for the long term. FSSA IM manages $38.7 billion globally (30/6/21).
2021 Data Release
2020 List of Private Banks in Hong Kong
2020 List of Private Banks in Singapore
2020 Top 10 Largest Family Office
2020 Top 10 Largest Multi-Family Offices
2020 Report: Hong Kong Private Banks & Asset Mgmt - $4.49 Trillion
2020 Report: Singapore Asset Mgmt - $3.48 Trillion AUM
Family Office Networking - Monthly
Investment Day - Monthly
Membership | Join a Powerful Network
Caproasia User
Japan – Land of Hidden Gems
Sophia Li, Portfolio Manager, joined FSSA Investment Managers as a graduate in 2009 and has developed an extensive coverage of companies in North Asia. Sophia manages the team's Japan equity strategies and is the manager of the FSSA Japan Equity Strategy.
Sophia holds a Master's degree in Statistics from Harvard University and a Bachelor of Science degree from Fudan University. She is also a CFA charterholder.
1) What are some of the biggest misconceptions about Japan?
Sophia: Strategists often argue that Japan is perhaps the most cyclical market amongst the major global economies, with profits highly correlated to global trade. We disagree. It is true that many of the large index constituents are companies with high overseas exposure or are highly sensitive to forex fluctuations. However, in our view, Japan's economy is actually very defensive and mainly driven by domestic demand. Japan's exports account for less than 20% of GDP — far lower than that of Germany or South Korea where more than 40% of GDP is derived from exports.
Another misconception about Japan is that the ageing population and prolonged deflationary environment means that there are few quality companies that can deliver
high growth and returns. We disagree with that notion too. Especially from a bottom-up perspective, our viewis that Japan has a deep investment universe with many high-quality companies that are focused on delivering sustainable growth and returns and are uncorrelated to the global macro environment.
2) Why should investors consider Japan?
Sophia: Firstly, in our view, you can find a large number of companies in Japan which have strong global franchises and dominant market share in secular growth industries such as factory automation, machine vision, medical equipment and semiconductors.
Secondly, we see strong Japanese consumer brands benefitting from the favourable demographics in Asia, which accounts for more than 60% of the global population. Not to mention the rising number of middle-income families in Asia with increasing consumption power.
Thirdly, we believe there are even more investment opportunities among the purely domestic Japanese companies. We tend to find hidden gems in the underpenetrated and emerging industries in Japan — such as e-commerce, digital payments and Software-as-a- Service (SaaS). They are often under-researched by the market and our view is that this is what really makes Japan an interesting investment destination.
If you look at the chart below, more than 70% of the listed companies in Japan are covered by only one analyst, or none at all. In addition, if we look at the number of 10-baggers in Japan (defined as stocks that have delivered returns of more than 10 times the amount of its initial investment over the past 10 years) it is second only to India and is far higher than China or other Asian countries. We believe this proves that the market efficiency mechanism has not broken down in the way that people might think.
To us, the investment case for Japan has nothing to do with the macro environment. Rather, we seek to back a set of globally-competitive companies and local domestic disruptors that can win market share from complacent incumbents. As such, we believe Japan is a perfect market for bottom-up active investors like FSSA who have a different, contrarian perspective to deliver active returns.
3) What sets FSSA's Japan strategy apart from peers?
Sophia: First of all, as we adopt a benchmark agnostic investment philosophy, our strategy usually has a high active share, ranging historically between 70% to 90%. In addition, we define risk as the permanent loss of capital, rather than deviation from the benchmark or short-term volatility of stock performance.
As bottom-up investors, the FSSA Japan strategy is built company by company, from the bottom up and with little regard for index positioning. This results in a focused portfolio of around 40 to 45 high-conviction stocks. As
a team, FSSA believes that what we don't own is just as important as what we do own. As such, we do not invest in industries that cause direct harm to society or the environment. Nor have we invested in companies with structural problems, or companies that are driven purely by global macro cycles.
We are long-term investors and have an investment horizon of around three-to-five years, if not more. Our investment philosophy is to identify high-quality companies that can deliver sustainable investment returns and growth that is uncorrelated with the macro environment. Once we have built sufficient conviction, we aim to buy them at sensible prices and hold for the long term.
4) How does a stock make it into the portfolio?
Sophia: We evaluate companies based on three aspects: the quality of its franchise and management, and sustainability of growth.
Firstly, in terms of the franchise, we look for companies that have a dominant market share in niche industries that can gradually make inroads into associated markets.
In addition, we prefer companies that adopt an asset-light business model, which in our view is a key factor in delivering high return on invested capital (ROIC) and strong earnings resilience during an economic downturn. We also prefer to invest in companies that have a continued ability to innovate, so that they can disrupt the industry incumbents and win market share.
In terms of management, in Japan we look for distinctive leaders, rather than those with typical management characteristics. Conventional Japanese corporates usually have a slow and stubborn corporate culture, where promotion is based on seniority and an employee's ability to conform, rather than their actual performance.
In our view, this may partially explain why their corporate performance has been struggling since the economic bubble burst. Instead, we back management who are open-minded and motivated, who have a speedy decision-making process and can rectify mistakes quickly, and can adjust their strategy according to the fast-changing external environment.
Lastly, we focus on the sustainability of a company's growth. We try to identify structural trends in Japanese corporate and consumer behaviour, and look for the best investment opportunities that we believe should most benefit from those secular drivers. We look for innovative companies, in terms of business models or new product launches, as this helps them gain market share from incumbents. This is especially important because Japan is already a mature economy where most industries are quite saturated. We also like defensive and sticky business models that can generate revenue on a recurring basis.
5) The Japan equity market has been quite volatile in recent months. How do you manage against these risks in the portfolio?
Sophia: We do not see short-term market volatility as a kind of risk. Instead, we define risk as the permanent loss of client capital — and to protect against that risk, we believe the most important thing we can do is maintain the discipline to stick to our rigorous bottom-up stock selection process.
Recent market volatility has been driven in part by concerns about global inflation. For companies to make
it into our portfolio, we require them to have a dominant franchise or strong pricing power, so they should continue to perform well even in a high inflation environment. We also require businesses to be highly defensive, with the ability to produce medium-to-long-term secular growth.
The portfolio is invested in a combination of both domestic Japanese companies and Japanese companies with global franchises (those with high overseas exposure). The global companies should perform well in a global recovery, while the purely domestic companies should be able to deliver sustainable earnings growth and remain resilient during an economic downturn.
6) How does the team define overvalued? Are there any examples where you have divested based on valuations?
Sophia: We conduct a fair market value (FMV) exercise for each company in our portfolio (including those on our watch list), calculating the annualised return and dividends on a three-to-five year basis. As a rule of thumb, we require more than a double digit return to invest in a company — and for those that comes with higher risk, we would require even higher returns to compensate. If a business generates a negative return in our FMV calculations, we consider it to be overvalued.
We used to own a company called Hoshizaki Electric, a domestic leader in commercial fridges and freezers for restaurants in Japan. When we invested in the company, it had only limited sell-side coverage. The valuation was reasonable at about 20x price-to-earnings (P/E) ratio.
However, over the years it re-rated far more quickly than its earnings growth, and after conducting more detailed due diligence, we found that the company did not have much substance to its overseas expansion story. There were also some concerns with the new management. As a result, we completely disposed of the stock not long after.
7) Did the Covid-19 sell-off last year present any good accumulation opportunities for the portfolio?
Sophia: With hindsight, the market crash early last year did indeed present great opportunities for global investors to buy companies in Japan. We picked up mainly two types
of companies.
The first was what we believed to be Covid beneficiaries — not just temporarily, but goods and services that should benefit from the structural changes brought forward by the pandemic. For example, Japanese consumers and corporates can be quite conservative, and the pandemic had accelerated the digitalisation of their behaviours. Beneficiaries of this changing behaviour included companies in the digital payments
(GMO Payment Gateway), e-commerce (M3 and Shift) and Software-as-a-Service (Rakus) sectors.
The other type of companies were the ones that we believed would be affected by the pandemic in the short term (in terms of their valuation) but, given their strong franchises, should be able to rebound in the next one or two quarters. Examples include Recruit Holdings, which we believed should benefit from the economy re-opening, and a hidden gem called Kotobuki Spirits, which sells souvenir sweets mainly to domestic and inbound tourists in Japan.
Kotobuki Spirits generated decent return-on-equity (ROE) and profit margins even before the pandemic. We believe after the pandemic is over, both margins and ROE should improve due to a series of cost reduction activities over the past 12 months. We also believe they are well prepared for demand to recover post the pandemic.
8) Do you see any opportunities in the small- to mid-cap segment?
Sophia: In our view, there are quite a lot of opportunities in this space, mainly because of the lack of analyst coverage. These smaller companies tend to have slightly higher price volatility in the short term, given the higher participation from retail investors. However, we believe that in the long run they can generate good returns for global investors.
Every year we host around 250 to 300 meetings with companies and more than half of them are with new companies. Hence, we are quite optimistic about the opportunity set in the small- to mid-cap sector.
9) Do you see any opportunities in the Electric Vehicle (EV) market in Japan?
Sophia: We have been looking for investment opportunities in the Electric Vehicle (EV) sector for about four years, but have struggled to find any well-managed and relatively pure businesses that can benefit from this sector. We also do not want to chase after "hot themes" just for the sake of it, as it would compromise our investment philosophy.
We have a position in a company called Nidec, which produces servo motors, but across all industries and not just EV. Although we believe its EV traction motors may hold some promise, this line of business is still very small. Today, it accounts for just 1% of the company's revenue. That said, we believe it will grow quickly and by 2025, we believe it could account for 15% of revenue as EV penetration continues to rise.
10) Environmental, Social and Governance (ESG) analysis is central to the team's investment philosophy. How has the Japan strategy evolved over the years from this perspective?
Sophia: ESG has always been an integrated part of our investment process, ever since the team was first established. But it has been a journey, and our process has indeed evolved over the years. As a team, we do not invest in any industries or companies that cause direct harm to the environment or to society; and we value the quality of the management and corporate governance above a company's franchise or growth prospects. In the early days, we would apply this lens as a form of risk management. However, over the years, we started to identify companies that are able to transform environmental and social risks into opportunities.
For example, we own a number of companies in the portfolio that are committed to providing products and services to small and medium sized enterprises (SMEs) in Japan, which are usually at a disadvantage compared to large enterprises due to their size. Rakus's corporate mission for example, is to provide affordable services to SMEs. We have also been expanding our risk metrics from mainly corporate governance to include environmental and social risks. In our view, one of Japan's biggest weaknesses is gender diversity. Since last year, we have started to hold annual engagement meetings with investee companies. The meetings last around 60 to 90 minutes and we would discuss all the key and material issues of their businesses, defined according to the Sustainability Account Standards Board (SASB).
We would also encourage them to disclose more information — the lack of information disclosure has been a particular problem with mid- to small-cap companies
in Japan. Through our engagement efforts, we are happy to see that some management are quite open-minded and are making progress. That said, given that "slow and steady" is really the name of the game in Japan, we will continue to engage with companies patiently and monitor the progress.
11) Are there any past company engagements that you could share?
Sophia: A few years ago, Fast Retailing (Uniqlo) had an issue on labour protection with one of their previous suppliers in Indonesia. We engaged with them on their supply chain management processes, especially on their lack of a grievance system (which had been adopted by global peers such as H&M and Zara). Fast Retailing did not have such a system back then.
We introduced Fast Retailing to a company called Elevate, a supply chain solutions provider, which carried out a consultation. As a result, Fast Retailing improved their grievance system and now are currently in discussions on whether they should introduce proper surveys and assessment tools for the system.
12) What are your thoughts on sector rotations in the Japanese market? Are you ever tempted to buy some of the cheaper stocks with lower-quality growth prospects?
Sophia: In the past, we were tempted; and we purchased companies that were cheap by compromising our standards on quality. However, in hindsight, these were not good purchases and we actually lost money on them.
As a team, we have a relatively long-term investment horizon of at least three-to-five years if not more. However, lower-quality companies tend to generate mediocre returns over the cycle and when something goes wrong, we find it very difficult to muster enough conviction to add on weakness. It turns out that these companies are cheap for a reason. We have learnt our lesson; and will not be tempted to chase sector rotations in future cycles. In fact, we do not take any macro view — when we invest in a company, we look for businesses that can generate sustainable returns and growth that is unrelated to the macro environment.
Many companies in the portfolio are in a net cash position. 18 months into Covid, how has this benefitted them?
From our observations, when markets crash, companies with strong balance sheets tend to have the benefit of the doubt from investors and are usually more resilient.
Many companies, especially Software-as-a-Service (SaaS) companies, took the opportunity during the pandemic to reinvest into their businesses. They called 2020 a "once in a lifetime opportunity" for them to increase market penetration, and invested massively during the year to promote their services.
Meanwhile, companies like Japan Elevator Service and Shift made quite a few merger and acquisition (M&A) deals over the past 12 months or so. The smaller players were struggling because of the pandemic and were keen to sell their businesses.
Japanese SMEs have a structural succession issue. In the next five years or so, more than 70% of the SME founders in Japan will retire and many will struggle to find a successor. This crisis presents a great opportunity for industry leaders with ample cash on their balance sheet to consolidate the market.
This is an extract of Investment commentary: Fund Manager Q&A on Japan – Land of Hidden GEM by FSSA IM Portfolio Manager Sophia Li (August 2021)
About FSSA Investment Managers
FSSA Investment Managers (FSSA IM) is an autonomous team within First Sentier Investors with dedicated investment professionals in Hong Kong, Singapore, Tokyo and Edinburgh. FSSA IM are bottom-up investors, using fundamental research and analysis to construct high-conviction portfolios. They conduct more than a thousand direct company meetings a year, seeking to identify high quality companies that they can invest in for the long term. As responsible, long-term shareholders, FSSA IM have integrated ESG analysis into their investment process and engage extensively on environmental, labour and governance issues. As at 30 June 2021, FSSA IM manages US$38.7 billion on behalf of clients globally.
The information contained within this document is generic in nature and does not contain or constitute investment or investment product advice. The information has been obtained from sources that First Sentier Investors ("FSI") believes to be reliable and accurate at the time of issue but no representation or warranty, expressed or implied, is made as to the fairness, accuracy, completeness or correctness of the information. Neither FSI, nor any of its associates, nor any director, officer or employee accepts any liability whatsoever for any loss arising directly or indirectly from any use of this document. Reference to specific securities (if any) is included for the purpose of illustration only and should not be construed as a recommendation to buy or sell the same. All securities mentioned herein may or may not form part of the holdings of First Sentier Investors' portfolios at a certain point in time, and the holdings may change over time.
This document has been prepared for general information purpose. It does not purport to be comprehensive or to render special advice. The views expressed herein are the views of the writer at the time of issue and may change over time. This is not an offer document, and does not constitute an investment recommendation. No person should rely on the content and/or act on the basis of any matter contained in this document without obtaining specific professional advice. The information in this document may not be reproduced in whole or in part or circulated without the prior consent of FSI. This document shall only be used and/or received in accordance with the applicable laws in the relevant jurisdiction.
In Hong Kong, this document is issued by First Sentier Investors (Hong Kong) Limited and has not been reviewed by the Securities & Futures Commission in Hong Kong. In Singapore, this document is issued by First Sentier Investors (Singapore) whose company registration number is 196900420D. This advertisement or publication has not been reviewed by the Monetary Authority of Singapore. First Sentier Investors and FSSA Investment Managers are business names of First Sentier Investors (Hong Kong) Limited. First Sentier Investors (registration number 53236800B) and FSSA Investment Managers (registration number 53314080C) are business divisions of First Sentier Investors (Singapore). The FSSA Investment Managers logo is a trademark of the MUFG (as defined below) or an affiliate thereof.
First Sentier Investors (Hong Kong) Limited and First Sentier Investors (Singapore) are part of the investment management business of First Sentier Investors, which is ultimately owned by Mitsubishi UFJ Financial Group, Inc. ("MUFG"), a global financial group. First Sentier Investors includes a number of entities in different jurisdictions.
MUFG and its subsidiaries are not responsible for any statement or information contained in this document. Neither MUFG nor any of its subsidiaries guarantee the performance of any investment or entity referred to in this document or the repayment of capital. Any investments referred to are not deposits or other liabilities of MUFG or its subsidiaries, and are subject to investment risk, including loss of income and capital invested.
Data Release
2020 List of International Private Banks in Hong Kong
2020 List of International Private Banks in Singapore
2020 Top 10 Largest Family Office in the World
2020 Top 10 Largest Multi-Family Offices in the World
Caproasia Platforms:
TFC Marketplace | Find Private Banks, Family Office Services, Hedge Funds
Caproasia Jobs | Find jobs in Private Banks, Family Office, Hedge Funds
Caproasia Access | Your Homepage
Caproasia.com | You are already here
Caproasia Events & Coverage:
2021 Upcoming Events
Caproasia.com | The leading financial website for financial professionals, professional investors and HNW investors. Covering capital markets, investments and private wealth in Asia. How do you invest $3 million to $300 million? How do you manage $20 million to $3 billion of assets? Quicklinks: Caproasia Access | TFC | Caproasia | Jobs
Join 14,000+ leading financial professionals and professional investors in Asia. Stay ahead of your peers & competition.
For press release, email to press@caproasia.com
For editorial, media kit, listing on TFC, events, seminars or research & data services, email to mail@caproasia.com
FSSA IM
FSSA Investment Manager
Sophia Li
First Sentier
Previous articleOECD: 136 Countries Representing 90% of Global GDP Agree to 15% Corporate Tax Rate from 2023
Next articleAllianz Global Wealth Report 2021: Global Financial Assets at $231 Trillion
Caproasia.com covering capital markets, investments and private wealth in Asia. Our users manage, advise & invest $25 trillion assets in Asia
HSBC Global Private Banking 2022 Investment Outlook: The Big Reset
HSBC Private Bank: 2021 Q4 Investment Outlook – Slower But Steady Wins the Race
Citi Private Bank: Investment Implications of the Federal Reserve Policy
Singapore Joins China & Hong Kong in Discouraging Cryptocurrency Trading by...


You can get easy access to for "Ezmoney Com Login" Obtaining loans can be difficult if you do not have the best credit. That's why title loans are often preferable. If you have a car that is free and clear, you can use that as collateral. It's similar to how people borrow money to get a home equity loan, using their house as collateral. There are companies that will allow you to do this. This is going to make it easier for you to get any type of loan that you want. There are ways to find companies that offer this option, and one of the best cash advance. This overview of EzMoney will show you why so many people are using this particular business to get loans today. Get cash today at Ezmoney Com Login.
Searching for Ezmoney Com Login. $200-$1000 Payday advances within Rapidly Period. Absolutely no Lines Absolutely no Inconvenience. 24/7 Immediate Authorization. Get Urgent Bank loan Today.
Ezmoney Com Login, How Does This Company Operate?
It is actually a famous simple fact that loans are far more easy to get if you have some form of collateral backing you. For example, when you are a property owner, and you have equity within your house, you can get loans urgently by doing so. However, you could possibly have a loan for those who have a vehicle that is certainly free and clear. By just supplying the title, they can use that as collateral to ensure they are going to have a payment for the investment that you are currently borrowing.
The application process is actually very simple. You may do a couple different things. Firstly, you can get a loan after as little as 1 day by offering your title is a type of collateral for this business. urgent approvals are required when working with these companies, plus you get to keep driving your car or truck. They have got very competitive rates and are generally serving a huge portion of the us, having provided these loans more than two decades.
It's not going to take extended at all to have this loan. Actually, you should receive it in the end of the day. Should it be a greater loan, it might take a little bit longer. They need to connect you with a lender this willing to work with you. The main benefit is that you simply are providing collateral and that's always will be helpful. Title loans are notoriously easy to make do comparison to standard unsecured payday cash loans.
Paying it back is either going to be at the same time, or you are going to make payments. It is highly recommended that you pay everything off once you can. Some people take these out due to emergencies, and then they can pay it off using their next paycheck. These are simply strapped for cash and so they need a loan at the earliest opportunity. Provided you can pay it off at the end of four weeks, it's likely to help you save a substantial amount of money. It's what most people choose related to air borrowing in their means, which makes using this company very useful.


text:
Holdich era una localidad argentina del departamento Escalante, Provincia del Chubut. Se sitúa sobre la Ruta Provincial 37, a pocos km del límite con la Provincia de Santa Cruz. Sobre el poblado se encontraba la estación homónima del Ferrocarril de Comodoro Rivadavia. Por estar ubicada sobre una ruta su acceso es fácil, por lo que su vandalización y desguace por particulares chatarreros fue muy rápida y sencilla. Unos kilómetros siguiendo la ruta rumbo a Santa Cruz se halla abandonado el puesto policial Holdich que integraba también esta localdiad y vigilaba el límite provincial.

Toponimia

El nombre de la localidad alude a Sir Thomas Holdich, delegado del rey de Inglaterra, Eduardo VII, para la demarcación de límites entre Chile y Argentina, en especial en el año 1902 durante el disputa de límites entre Argentina y Chile (1896-1902). A pesar de llevar varios años sin habitantes el nombre Holdich aun perdura en la zona; explicado, en parte, gracias a la antigua comisaría que cerró en años recientes.

Historia

Nacida junto al ferrocarril para 1910 era la estación más próxima a Santa Cruz. Su nacimiento fue el resultado de la desviación del proyecto original que uniría Sarmiento con Comodoro en línea recta. Esta modificación se debió a la intervención de los poderosos capitales privados de la estancia La Nueva Oriental que intervinieron política y monetariamente  para formar la curva hacia el sur que permitió que el ferrocarril llevara su elevada producción lanera y ovina. Esta acción además posibilitó fundar una gama de estaciones y pueblos impensados, entre los que nació Holdich. Sin embargo, la consecuencia de esta intervención fue la demora extra para completar el recorrido, las complicaciones de la geografía de la zona y superposición de localidades y estaciones.

Años más tarde ante el estancó del proyecto original de llevarlo a la cordillera a este ferrocarril en 1927, el diputado Guillermo Fonrouge, planteó la unión de esta estación con la estación Las Heras, la cual pertenecía al ferrocarril Patagónico. El proyecto pretendía pasar por los campos petroleros de Cañadón Seco y Caleta Olivia. A pesar de la corta distancia entre ambas no prosperó la iniciativa.

El poblado tuvo un relativo importante crecimiento hasta mediados de siglo, estando la economía del poblado centrada en el paso de viajeros, las estancias vecinas y del ferrocarril. En su mayor apogeo el pueblo albergó la estación de chapa y madera del ferrocarril, el tanque de agua para surtir a las locomotoras, una vivienda de material para las cuadrillas de peones del ferrocarril, una subcomisaría de policía, dos hoteles-boliches de grandes dimensiones, varios galpones y un imponente edificio de correo erigido por la poderosa estancia La Nueva Oriental, propiedad del imperio patagónico Menéndez-Behety, fundadores de la actual cadena de supermercados La Anónima. El importante tamaño del edificio de correos se explica por la gran cantidad de población rural que habitaba en la zona y que hoy es poco significativa.

En 1932 el poblado entró en decadencia de modo acentuado y la construcción del edificio escolar no registró inscripciones. De este modo, esta escuela fue construida en Diadema Argentina. El pueblo era el paso obligatorio de viajeros por la ruta de tierra que unía el sur de Chubut con el norte de Santa Cruz.

A partir de la segunda mitad del siglo XX el poblado decayó rápidamente, en gran parte por el declive del ferrocarril frente al transporte automotor, incorrectamente superpuestos por falta de planeamiento nacional. Aún para 1951 su población era contada entre las pocas localidades que la línea Comodoro Rivadavia a Colonia Sarmiento recorría.Para 1957 las únicas poblaciones considerables del ramal se concentran en torno a Comodoro y Sarmiento; estando todas las demás poblaciones como esta consideradas de poca relevnacia o ya despobladas.La sentencia de muerte llegó con la clausura definitiva del ferrocarril, ocurrida en 1978.

Antes de desaparecer Holdich es inmortalizado 1985 cuando, en las cercanías del poblado y algunos de sus edificios, se filmaron escenas de La película del rey, de Carlos Sorín. En esas tomas se ven el correo en buen estado y el boliche de los Vascos por dentro y fuera. Además, se mostraron tomas de las instalaciones del ferrocarril conservadas, pero ya con la estación desguazada.

En 1987 la muerte de la localidad llegó cuando Antonia Aramburu; la propietaria del comercio conocido como "el boliche de Los Vascos", decidió  mudarse a Comodoro Rivadavia. Luego, el paraje nunca más volvió a tener habitantes permanentes.

Por otro lado, a 5 kilómetros al sur perduró unos años más el destacamento policial hasta el año 1991. La desaparición del boliche fuer rápida, ya para 1995 por su deterioro parecía demolido. Aun perduraban en pie partes de las paredes. Se reconocían tramos de las bases y fragmentos de algunas paredes, un sótano y las columnas que sostuvieron la puerta de entrada. Entre los escombros se amontonaban latas y botellas de vidrio de cervezas y gaseosas de los años '70 y '80.

Aún en los años 1990 un particular se ocupaba de cuidar lo que quedaba del pueblo, su labor contribuyó a preservar parte del patrimonio histórico. Este héroe anónimo recibía a los visitantes con escopeta en mano para evitar los desmanes. La persona era un vecino de Diadema y acondicionó una de las habitaciones del edificio de viviendas de las cuadrillas para residir los fines de semana. La misma había sido recosntruida y permitía su habitabilidad. Lamentablemente, el defensor de Holdich desapareció del lugar y luego de su partida el lugar cayó en desmanes sistémicos.

En las últimas décadas se han desmantelado los rieles de la vía férrea y se han destruido todos los edificios que existían.

Para mediados de 2006 los trabajos de desmantelamiento del ferrocarril, encargados por el gobierno de Das Neves, trajeron los desmanes finales. Con el propósito de lucrar con la chatarra de los rieles y los durmientes que se hallaban aún en el sitio donde estuvo la estación. Por este saqueo al lugar se le quita la esencia que aun tenía.Ante estos hechos vandálicos, los vecinos de Sarmiento, indignados, intentaron organizarse para que se declare patrimonio cultural y monumento histórico al lugar. Mientras que en Comodoro Rivadavia, el director del museo regional Antonio Garcés, Hugo Pérez Ruiz, comprometió gestiones en idéntico sentido ante la provincia. Los pedidos, pese a ser razonables y justos, no fueron atendidos y el desguace y el abandono persisten.

El 26 de septiembre de 2012 el destacamento fue rehabilitado a cargo de la policía de la provincia de Santa Cruz con el grado de subcomisaría. Para este acto concurrieron al lugar el jefe y el segundo jefe de la Unidad Regional Norte, Carlos Ayuso y Víctor Ramos, acompañados por el juez de instrucción de Las Heras, Eduardo Quelín; el titular de la Comisaría Primera de esa localidad, Héctor Tebes, y el jefe de Operaciones Rurales,  Carlos Inostrosa. Los mismos presenciaron trabajos de nivelación de bases donde se colocaron módulos que se enviaron desde Neuquén y reemplazaron a la antigua construcción de material fueron declaradas ruinas y reemplazadas por módulos o tráileres. Los cuales fueron donados por YPF en pos de que funcionarán oficinas, cocina, comedor y un calabozo. Los módulos disponían de quipos de calefacción, muebles para oficinas, habitaciones, además de un grupo electrógeno y una Ford Ranger.
El propósito de la reapertura de la localidad era que el personal policial afectado realizará controles de vehículos y tareas de prevención de delitos sobre la ruta e inmediaciones, ya sea sobre casos de abigeato o  de sustracción de elementos de la industria petrolera. El 20 de mayo de 2015 con expediente JP n° 793.099/14 se la reconoció como subcomisaría con asignación de fondos Disposición 008-J-2015  y en los boletines oficiales determinaron que estas gestiones estuvieron bajo la responsabilidad del Comisario General Jorge Mario Hasan y del Comisario General Salomón Aleuy, gobernación de Daniel Peralta. El control operativo de la subcomisaría Holdich dependía de la Comisaría Ramón Santos.

La reactivación de la localidad fue efímera. Al asumir la Dra. Alicia Kirchner, el nuevo Jefe de Policía de Santa Cruz, José Luis Cortes dispuso el cierre de varios destacamentos por razones presupuestarias, entre ellos la Subcomisaria Holdich.

Los trabajadores petroleros que a diario trabajan en la zona expresaron que los policías eran dos, a veces uno y no tenían nada. Los mismos trabajares le llevaban comida y gasoil. Los policías tampoco tenían elementos de higiene para los tráileres y hasta pasaban frío. Solo se tenían un generador de luz y no tenían vehículo para sus tareas. El único medio de comunicación un celular al que pegaban a la pared del tráiler con cinta para tener señal. De este modo, Holdich primero vio muchos días cerrada la subcomisaría, hasta después que fue abandonada. Finalmente, en julio de 2016 YPF retiró los tráileres.

También, en 2015 la localidad fue elegida por un grupo de artistas locales para una exposición artística. La misma tuvo eje en sus edificios abandonados, uso paredes del frente y en el interior pegado fotos, dibujos y pinturas. De esta forma, la intervención artística se volvió un hecho muy original porque momentáneamente volvió a la vida al paraje.

Actualmente, la zona de Holdich aun es tema recurrente ya que hay abigeato, presunto tráfico de sustancias controladas, traslado de  elementos robados de todo tipo. La ruta  que la atraviesa hoy es especialmente elegida para el contrabando de cable de cobre.
Según los trabajadores petroleros:

Geografía

Se ubica a 755 , sobre la Pampa del Castillo en plena meseta patagónica. En invierno, son frecuentes las nevadas y las condiciones climáticas son adversas.
La localidad y todo el entorno esta en la planicie desértica de la meseta y da una vista panorámica monótoma que recién se interrumpe hacia el este cuando da paso a faldeos de pendientes pronunciadas que desembocaban en cañadones y valles.

Galería

Referencias

Enlaces externos

 Coord.geográficas e imágenes NASA, Google

Localidades abandonadas de Argentina
Departamento Escalante

redpajama_set_name: RedPajamaWikipedia


text:
Q: Influxdb downsampling strategy We are using influx DB. Basically I wish to store my data for one year total so I created a default RETENTION POLICY fro 365d.
I also want to create downsampling. I store my event every second, but I dont need them in seconds resolution for more than 3 months. basically, after 3 monthes I prefer to SUM the data in days and after 6 months I prefer to sum the data in weeks resolution.
I understood from this doc that I can downsample using "continues queries".
What I also understood that I have to downsample to another table. This will make my query process much harder because I will have to decide which table should I query and maybe combine the data of several tables.
Can I somehow create Downsampling process that will have all the data in the same table?
Regards,
Ido

A: To summarize the comments on this question: with Influxdb, you can not have multiple retention policies within a single table. You will have to query across multiple retention policies. You might want to Subscribe to this Github feature request for Intelligent Rollups and Querying of Aggregated Data

redpajama_set_name: RedPajamaStackExchange


text:
Nicola Roberts Full Sex Tape
Hugh Grant Admits Sex With Elizabeth Hurley "Fizzled," Says He Made "Too Many Jokes" About Julia Roberts
Nicola Roberts
Member of pop girl group Girls Aloud whose single "Sound of the Underground" made the UK Billboard charts. She appeared on Popstars: The Rivals. She was in a girl group called The 5 Musketeers. She and Girls Aloud got included in the Guinness Book of World Records for most successful reality television music-group. Her mother was seventeen years old when she had her. Roberts and Charlie Fennel started dating in 2008. She was bullied by singer Lily Allen after winning Popstars.
Birthday: October 5, 1985
Born: England
Birth Sign: Libra
Other: Jennifer Lawrence, Kristen Stewart, Lena Olin, Melissa Auf der Maur, Polina Edmunds, Rachel Bright, Reeva Steenkamp, Stacey Solomon, Tobin Heath, Anastasia Karanikola, Anja Konstantinova, Ava Elizabeth Sambora, Brittany Carpentro, Eka Samone, Eva Riccobono, Imogen Lovell,
Agreed to Get Naked On Film.
Naked. Bares Topless Breasts.
Nude. Has no regrets over nude pics.
Find out if Nicola Roberts was ever nude, where to look for her nude pictures and how old was she when she first got naked. Emma Roberts–Super Slut (ws,MFf,M+f,scat,beast,spank,nc/reluc,pedo) Emma Roberts is a 14-year-old girl with long brown hair that is down to her shoulder blades, and.
Full archive of her photos and videos from ICLOUD LEAKS 2018 Here. Here's a Bonus Day of Love Advet with Nicola Peltz. Nicola Peltz is an American actress (When the Street Lights Go On).
Full archive of her photos and videos from ICLOUD LEAKS 2018 Here. Sweet Instagram photos of an American actress Nicola Peltz. Full archive of her photos and videos from ICLOUD LEAKS 2018 Here. Hayley Roberts and David Hasselhoff spend a day on the beach in Miami. Prepare to become a physician, build your knowledge, lead a health care organization, and advance your career with NEJM Group information and services. David Nicola Cicilline s ɪ s ɪ ˈ l iː n i born July 15, 1961) is an American politician who has been the U.S. Representative for Rhode Island&aposs 1st congressional district since 2011. He is a member of the Democratic Party.
Gay literature is a collective term for literature produced by or for the LGBT community which involves characters, plot lines, and/or themes portraying male homosexual behavior. #1 New York Times-bestselling author Nora Roberts explores the wilds of the Grand Tetons-and the mysteries of love, murder, and madness-in her engrossing and passionate new novel.
Nicola Roberts Full Sex Video
Roberts Temecula Public Library (30600 Pauba Road). Copies of Everything, Everything by Nicola Yoon will be available for check out at the circulation desk prior to the event. YARMOUTH — Nicola Roberts-Fenton wants people to experience the serenity of laying on their back on a mossy bed in the Tobeatic forest, listening to leaves rustling and birds singing overhead. Nicola Roberts has revealed that she is a huge fan of EastEnders.
Cheryl Cole will apparently feature on Rihanna's new Sky Living show.
Rear-Admiral Wipan Chamachote (center) presents consolation awards to fourth placed Herve Le Maux and Nicola Davies with their young supporter. Dave and Louise Roberts won the 2019 Dart 18 World Championship hosted . In fourth place were Herve Le Maux and Nicola Davies of France, with David Lloyd and Hayley Smith GBR in fifth overall. The number of female company directors for the companies below the ASX200 but within the ASX300 stood at just 19.7%, 30% Club chair Nicola Wakefield Evans noted .
Justice Nicola Pain on Wednesday dismissed a challenge from community group Local Democracy Matters and Waverley Council that claimed Planning Minister Anthony Roberts had failed to consider "design e.
Gals Aloud - who are about to go on a national tour which covers the highs and lows of the girl band's story - stars Kitty Scott-Claus as Kimberley Walsh, Ophelia Love as Nicola Roberts, Lydia L'Scabi. news and red carpet pictures. Congratulations go to Dave and Louise Roberts, the 2017 world champions . and then a 1 st in races 9 and 10 respectively. Hugh Grant Admits Sex With Elizabeth Hurley "Fizzled," Says He Made "Too Many Jokes" About Julia Roberts

redpajama_set_name: RedPajamaCommonCrawl


Do I actually like EarthBound, or do I just like being in exclusive clubs?
Last night I wrote a rather long rant about the effect bad translations had on my enjoyment of an adult male targeted comic book series called "Rozen Maiden". In the 20-odd hours since then, I found scanlations of that series and completed it. The translation quality was terrible, and I even spent some time shocking some of the Telefang translators as to what the fanbase does with clearly translatable vocal tics.
Read more about Do I actually like EarthBound, or do I just like being in exclusive clubs?
So, I need to confess something - I've been putting off work on the Telefang patches. I originally planned to release patches on a monthly basis, but after rolling out v111, I moved onto another Smilesoft game in need of hacking. I assumed other adjustments would come from other members of the project to justify v112 in July, but it didn't happen. Bugsite is it's own can of worms, but yet another thing has interrupted that project for something else.


Luxury Photos Of Kitchen Cabinet Metal Drawer Boxes – From the thousands of Photos online about kitchen cabinet metal drawer boxes, we all filter the most selections together with excellent resolution completely for our readers, and now this pics ,in actual fact, believed as one of stocks libraries inside our ideal pictures gallery with regards to Luxury Photos Of Kitchen Cabinet Metal Drawer Boxes. I hope you can want it.
published simply by Laura Graham at 2019-02-10 18:26:38. To find out many photograph inside Luxury Photos Of Kitchen Cabinet Metal Drawer Boxes photograph gallery remember to bear in mind this web page URL.


text:
2018 July Dev Update
by Brian Jamison on August 6, 2018 in Uncategorized
July wrapped up another solid month of development for us. Read on for all the details!
Probably the most important piece of functionality in July was the completion of the event spawning rules. These govern how, where, when and what kinds of events are generated. They're a fairly complex set of interlocking rules, and I'm very happy to say that they are working as expected. The game took a major step forward in playability with the completion of the event spawning rules.
The Harvesters approach
I want to emphasize that these rules are completely disconnected from how well the player is doing – if you fumble, the game will roll over you. XO is relentless, brutally hard, unforgiving, and just what I was hoping for at this stage. My current record is surviving for 90 days.
A new piece of event functionality was completed, the preTrigger. Up until now, events would not start unless the player hailed a ship. Now we can start events immediately when they are spawned. This was critical to what I call Attackship events, where warships jump in and target ships in your fleet.
With this functionality in place I made all of our existing Attackship events use the preTrigger. Attackship events have a chance to occur when you jump into space held by a faction you have a negative relationship with, and they dramatically increase the price you pay for making an enemy in the game. As I gain familiarity with the preTrigger and game balance I'll be adding many more of these events.
The aftermath of an attackships event
Thanks to Heru we have another new event condition, the shipExists condition. This starts an event only if particular types, classes or abilities of ships are present. We can also specify if the ships are in the player fleet or not. So for example, if I wanted to create an event that only started if the player had a ship that could mine ore, I could. Or only if the player could repair, or if they had a food-producing ship.
Another great tag we now have in our event system is the assignShip tag. This allows us to specify a certain ship in events. So for example, a foodship in the player's fleet can now be directly referenced in an event.
These three new event features are a big deal. But I'm not going to go into any further detail about the more fiendish events I have been developing with the preTrigger, shipExists condition, and assignShip functionality. You'll have to use your imagination for now and wait to play the game to find out!
Alexander completed the Rover lifeboat icon which rounds out all the lifeboats, and I resized the lifeboat icons so they weren't being mistaken for ships.
A Rover lifeboat jettisoned from a refugee ship
I created an animation for the minimap to show a new contact appearing. This hasn't been implemented yet, but it will make new ships jumping in much more visible.
Now that crews are implemented, it is now possible to hail an abandoned enemy ship. And if you crew one of these ships it becomes yours… even if you are enemies with the faction. Probably next month we will discuss the consequences that come along with this strategy.
Speaking of that, Heru fixed an amusing bug where if you put crew on a station, the station would join your fleet and jump with you. You can still abandon crew on a station (with consequences) but the station doesn't join or jump with you now.
I wrote the June Kickstarter update which took about two days including screencaps.
I adjusted the collision boxes on the Irenic station. And I made some minor changes to hover text for clarity.
Mostly in July I created many more events. First I created 27 new rescue events, bringing the total to 32. About half of those involve lifeboats.
Then I moved on to creating a lot more trade events. We're up to 56 trade events now. I added a good number of join events, mostly warships last month, bringing the count of join events to 118.
The grand total of events is now at 274. I still have a very large number of ideas for new events, over a hundred ideas.
And since we've got so many events in the game, individual events are now no longer duplicated in a given game session. I've been looking forward to this one for a long time, as it really helps the narrative feeling of the game.
Starting a trade event
I was able to fix an issue with an event where rescuing crews from a station and using them to crew specific ships wasn't working.
I continued to improve my scripts for helping me generate events; I added unique tags that we use to programmatically determine 'main' ships to the scripts, and expanded the destination tag to include script-generated dialog once you reach your destination in a given mission. I fixed a couple of minor syntax issues and improved the logic to require even less cut and pasting of events. Many events now require no adjustment from the script – I just paste them directly in. I'm very happy about this.
I added logic for shipTypeLimits since I'm mostly creating events that have a ships where there is a maximum number allowed. I also added a new MissionFail tag, and a new Destroyed trigger that starts actions when a specified ship is destroyed.
I expanded out the script I use to help me balance events, adding more detail and ratios. For example, the ratio of abandoned ships to crews that you can rescue is currently 3:2 — reflecting my desire for there to be more ships than crews you can find to put them in. Partly I want to encourage players to rescue as many crews as possible, partly I want the decision to crew a given abandoned ship to be fraught with the 'but what if a better ship comes along?' feeling. Right now the Join-to-rescue ratio is about 3:1. All these ratios are likely to change through alpha and beta.
A desperate defense
You're now able to click a skip button to bypass narrative/text blocks and jump straight to the decisions. It's a pet peeve of mine when games with a lot of text don't give an option for this. Later we'll probably add a key-based skip, something like holding down a certain key (spacebar or controller button) for longer than a second.
We now no longer spawn two of the same 'main' ships if more than one event is spawned. So for example, you'll never have to choose between rescuing two refugee ships, or two lifeboats, or two warships. This really helps to make your choices more meaningful.
A bug was fixed by Heru where the shield counter would move around with the camera when the game was paused.
Heru fixed an issue where the Harvester fighters were moving quite slow and failing to latch.
Heru also fixed an issue where a preTriggered event didn't like other events running simultaneously.
We had a bug where a ship that was mining ore or melting ice threw an error after jumping. Heru took care of that one, and another one where you weren't able to mine ore too, and a different one where in some cases you couldn't melt water.
Another bug related to melting water happened when you had a water riot and dismissed the ship that was doing the melting, but that one is also gone now thanks to Heru.
He fixed another issue where multiple missiles were firing on a single fighter, wasting missiles.
Another bug was fixed related to jumping when a ship in a formation became disabled.
The shield collapse animation was implemented by Heru, which brings shields to 100% implemented. I'm reasonably happy with the animation I created; I may yet decide to improve it.
He also fixed an issue where a ship in a formation with a shieldship wasn't being protected by the shield when attacked with the mining laser.
Another shield issue was fixed having to do with equipping a shield from the trade dialog. Fighters striking a shield now hit the expanding shield all of the time instead of only when the shield was at 100% radius.
Yet another shield bug was squashed, this one when the shield collapse animation was triggered.
And one more shield bug crept in and was eliminated, this one was thrown every time you shot at a shield.
Jumping with only three seconds until a water riot
I'm happy to say that all of our combat rules have now been implemented. This is a great step, but there are quite a number of outstanding issues and edge cases we have yet to address, as well as making adjustments on how the ships move and interact. This will definitely take substantial additional time.
As a result we now have a working 'running attack' which makes a warship attempt to kite its target ship in the opposite direction of travel.
We also now have a basic retreat command. This causes your ship (if it is under attack) to run in the opposite direction of an attacker until it is out of weapons range. It still needs some additional code to work with Harvester fighters properly, but it's working great against warships. Any ship can retreat, not just warships.
Formation attack rules were adjusted so that formations do not flip sides, and the outermost ship in a formation is used to determine things like stopping distances for formations when the close to attack. Ships now automatically return to their formation at the conclusion of a given order, and on emerging from jump form themselves into their formation.
Ships that are protecting other ships now only pursue attackers when they come in weapons range, otherwise they stay close to the protectee. This fixed an issue where protectors would seem to abandon the ship they were protecting to try and intercept incoming Harvester fighters when they were on the other side of the map.
We also finally have an Abort action. This halts any action in progress, which in my playtesting has come in handy uncountable times. For example when a bunch of Harvesters jump in and change the tactical situation. The Abort action in the contextual list (when you right click a ship) also tells you what action the ship is currently taking.
Abort! Abort!
I don't often mention it, but when we add new features we adjust our software tests, and this was the case for the final combat functions too.
Heru made it so that when you abandoned ship to lifeboat, the lifeboat didn't jump with you to the next destination. Soon you will also lose relationship with the faction that you left behind!
You can now evacuate passengers from a station that is neutral or friendly with you. You can also move passenger crews around from one ship to another on ships in your own fleet.
Rescue ops on enemy crews
Heru also completed the adjustments to our rules for generating planet types at the start of the game. I'll be balancing these to dial in the right mix, but this is now functionally complete. Heru added a nice overlay in the scene view to help me with balancing too.
Also on the balancing side, I adjusted the missile acceleration and top speed to equalize the Empire warships. Missiles are now dramatically faster and cannot be outrun. I made some adjustments to the frequency of habitable worlds.
A better galactic mix
For a long time in XO, when you did the Protect action on a ship it would also join your fleet if relations were friendly enough. This didn't make sense with the new event system but I kept it in place to help me playtest the game. Well I'm happy to say we no longer need that crutch, because the game is playable without it, so we removed the joining action from protect. It is a small thing but a very personal milestone for me.
I feel like July was quite productive given that I had to take a week off. My wonderful aunt passed away and I had to help with her estate sale and attend her ceremonies. Still, we're making good progress against the remaining tasks. Just a heads up for everyone, August is likely to have much less functionality completed than July. Once Heru finishes the functionality for fleet events we will turn to aggressively fix a number of small but annoying bugs that have accumulated, cover off quite a few edge cases we've found, and make further improvements to combat.
Thank you everyone for the support and positivity. It really makes a difference.
← 2018 June Dev Update
2018 August Dev Update →


Another huge field turned out this week for the Super Tuesday, with the 635 entrants tying for the fourth-largest Super Tuesday field ever (the record being 663). That meant $635,000 was up for grabs -- more than twice the $300K guarantee -- with the top 72 finishers splitting up the prize pool. And after more than 11-and-a-half hours it was Christian "CMoosepower" Elgstrøm of Denmark topping everyone to earn this week's title.
Elgstrøm ended up earning a $74,868.06 payday for the win after a six-handed final table deal, with runner-up Shhh00kem of Canada actually picking a little more by taking away $75,354.41 and fifth-place finisher 1dönertasche of Germany also realizing a nice $71,527.98 payday.
But it took a lot of poker beforehand to get to that point. Here's the story of how this week's tourney played out.
It took about five-and-a-half hours for the field to be whittled down to 73 players remaining at which point a lengthy period of hand-for-hand began. A couple of Team Online members had been among those to go out relatively shy of the cash as Marc-Andre "FrenchDawg" Ladouceur was eliminated in 119th, then Caio "pessagno" Pessagno was knocked out in 76th after losing his short stack with T♦T♠ to üä-qaypö.wsx's J♠J♣.
Among the several players still sitting with below average chips was Matt "salty14" Salsberg, who took to Twitter to describe his plight.
It wasn't long after that tweet that LORDXFLVCKO became the unfortunate 73rd-place finisher and the bubble had burst.
ITM! It IS a SUPER TUESDAY INDEED. Now lets run it up or have dinner.
Alas for Salsberg, his dinner would be coming sooner than later after getting knocked out by one of the two opponents he'd mentioned before, Zo "pakmanmma" Karim. Salsberg ran his 6♥6♠ into Karim's K♥K♣ to lose his last nine big blinds and go out in 59th. Faraz "The-Toilet 0" Jaka would then go out moments later when his A♦7♦ couldn't outdraw TiltMeBig's 9♣9♦ and he hit the rail in 57th, like Salsberg cashing for $2,222.50.
It wasn't long after knocking out Jaka that TiltMeBig had risen to the top spot in the counts as the first player to 300,000 as the field shrunk below 30.
They'd just crossed the eight-hour mark when Zo "pakmanmma" Karim finally went out in 20th, then young_diam18 followed in 19th with both earning $3,810 for their efforts. With two tables left TiltMeBig was still there with an average stack while Shhh00kem had moved out in front with more than 430,000 with goleafsgo41 the nearest challenger with about 290,000.
It would take another hour-and-a-half for the next eight to go, with SerPol999 (18th), Thomas "ttesone" Tesone (17th), and xerox206 (16th) each earning $5,080; Vampyboy (15th), medmar (14th), and Saul "iCeVeNoM" Khalili (13th) taking away $6,350 apiece; and WICKED617 (12th) and sincinaty118 (11th) both cashing for $7,620.
With 10 left hand-for-hand play commenced once more, and after a while a hand developed in which TiltMeBig raised from the button and both goleafsgo41 (small blind) and Timorm1 (big blind) called. Then following a K♠8♠T♦ flop goleafsgo41 checked, Timorm1 bet, TiltMeBig called, goleafsgo41 check-raised, Timorm1 folded, TiltMeBig shoved, and goleafsgo41 called.
goleafsgo41 showed K♥Q♦ for top pair of kings but was behind TiltMeBig's A♠A♥, and when the next two streets brought a couple of fives, goleafsgo41 had finished in 10th for $7,620.
With that hand pushing TiltMeBig back into first position, the final table was underway.
It was a final table with nine different countries represented, including EPT6 London champion Aaron "Aguskb" Gustavson playing from Macao. Gustavson tweeted the news of his having made it that far to his followers as the first final table hand was dealt.
Gustavson was referring to the big $120,015 prize originally scheduled for the winner, although as things ultimately played out, the final table deal would be spreading the remaining prize money out among several players.
It wasn't long before the next elimination occurred. The blinds were at 4,500/9,000 when 1dönertasche raised 2x to 18,000 from middle position, then it folded around to milldollbaby in the big blind who three-bet to 41,580 and 1dönertasche called. The flop came A♣A♠4♥, and milldollbaby check-called a bet of 21,512 from 1dönertasche. The turn then brought the 9♦ and another check from milldollbaby. This time 1dönertasche shoved all in and milldollbaby called with the 123,556 left behind.
milldollbaby had Q♦Q♥ for aces and queens, but 1dönertasche had trip aces with A♥Q♣. The river was the 3♦, and milldollbaby was done in ninth.
Two hands later Timorm1 was nearly felted after losing a preflop all-in with Q♦J♦ versus PingoPingwin's A♥K♥. Then the next hand saw leader TiltMeBig raise the minimum to 20,000 from the hijack seat, Shhh00ken reraise to 44,222 from the cutoff, then Timorm1 call all in from the button for just 22,505.
The blinds and TiltMeBig folded, then Shhh00kem showed A♦9♦ and Timorm1 J♣9♣. The board ran out six-high, coming 4♥6♦2♠5♦4♦ to give Shhh00kem a flush and knock Timorm1 out in eighth.
About an orbit later it was Aaron "Aguskb" Gustavson open-raising all in from under the gun for 95,766 (about nine-and-a-half big blinds), then Batistu10 reraised from a couple of seats over and all folded. It was J♠9♠ for Gustavson and A♠J♥ for Batistu10, and when the community cards came 7♥K♦A♥J♦T♦, Gustavson's Super Tuesday run had ended in seventh.
The remaining six made it to the 10-hour break, then decided to pause the tournament to discuss a possible deal with Shhh00kem and 1dönertasche the chip leaders.
Both "ICM" and "chip chop" numbers were produced (leaving $6,000 for which to play), and the ensuing discussion lasted for nearly half an hour. Finally a deal based on the "chip chop" figures was agreed upon, with Christian "CMoosepower" Elgstrøm (in third position) managing to convince everyone but Shhh00kem and TiltMeBig to give him a little extra before a deal was struck.
Soon after play resumed, it was TiltMeBig min-raising to 24,000 from early position, then watching Elgstrøm reraise to 57,475 from the big blind. TiltMeBig responded with an all-in push for 263,745, and CMoosepower called without hesitation.
TiltMeBig and A♠J♣ while CMoosepower turned over Q♥Q♣. The flop brought an ace, but a queen as well, coming 2♣Q♠A♥. The turn was the 6♥ and river the A♣, meaning TiltMeBig's trip aces weren't enough against Elgstrøm's full house, thus ending TiltMeBig's night in sixth.
Soon it was 1dönertasche raising to 24,000 from the button, CMoosepower reraising to 64,375 from the small blind, and 1dönertasche calling. The flop came T♦5♠8♦, Elgstrøm bet 71,250, and 1dönertasche called. The turn was the T♠, pairing the board. Elgstrøm's bet 134,275 this time, and when 1dönertasche shoved for 486,177, CMoosepower called.
Both players had made trips, it turned out, but CMoosepower's A♠T♥ gave him a better kicker than 1dönertasche who had Q♥T♣. The river was the 3♠, and 1dönertasche was eliminated in fifth.
The blinds moved to 7,000/14,000, then a hand arose that saw PingoPingwin raise to 28,000 from UTG, then Shhh00kem reraise to 70,000 from the big blind. PingoPingwin then pushed for 520,691 and Shhh00kem called.
PingoPingwin showed A♠J♥ but needed help against Shhh00kem's A♣K♠. The board came 7♦7♠2♦, then 6♥, then T♦, and PingoPingWin was out in fourth.
On the very next hand, Batistu10 raised to 28,000 from the button, Shhh00kem reraised to 63,000 from the small blind, then Christian "CMoosepower" Elgstrøm cold four-bet to 156,475 from the big blind. Batistu10 then pushed all in for 668,521 and after Shhh00kem folded, CMoosepower called.
Batistu10's pocket pair was ahead before and after the 3♠T♠J♣ flop, but the Q♥ fell on fourth street to make a straight for Elgstrøm and make the river 9♦ no matter. They were down to two.
Heads-up began with Christian "CMoosepower" Elgstrøm enjoying a little over a 2-to-1 chip lead with 2,143,519 to Shhh00kem's 1,031,481. Elgstrøm stayed in front for the next dozen hands, then Shhh00kem managed to double up with 5♥5♦ through CMoosepower's A♣T♥ to sneak in front by a few chips.
But Elgstrøm soon moved back ahead and by the time the 11-hour break arrived had built up over 2 million once again. The pair would ultimately battle another 40 minutes more, with the lead swinging back and forth a couple more times before CMoosepower again had his stack up around 2.1 million when the final hand at last took place.
The blinds were up to 10,000/20,000, and the hand began with Elgstrøm raising from the button to 40,000, Shhh00kem reraising to 100,000, then Elgstrøm four-betting to 220,000. Shhh00kem came back with an all-in push for 1,063,848, and CMoosepower called, turning over 8♦8♠ while Shhh00kem had A♠J♥.
The community cards brought no help to Shhh00kem, coming 7♠K♣8♣K♥Q♣, giving CMoosepower a full house, the pot, and a Super Tuesday title.
Congratulations to Christian "CMoosepower" Elgstrøm for topping a huge Super Tuesday field and tough final table to win this week's tourney, and kudos as well to Shhh00kem for a gritty heads-up battle and for taking away a shade more than Elgstrøm thanks to the six-handed chop.
Ben Mayhew came away with the UKIPT4 Nottingham title yesterday. Read all about his triumph here.


text:
Home / Blogs / Opinion / 'Whatever happened to the promise of more clinical services?'
'Whatever happened to the promise of more clinical services?'
Pharmacist, Ashley Cohen, looks back at the five-year pharmacy contract and how far along clinical services have really come.
Almost two years ago, a five-year deal for community pharmacies was agreed between DHSC, NHSE&I and PSNC. The deal, agreed in July 2019, secured pharmacy funding and set out a clear vision for the expansion of clinical service delivery over the next five years, in line with the NHS long term plan. A flat funding of £2.52bn/year was proposed for the duration of the five-year period.
This financial settlement came after two previous years of significant cuts to the pharmacy sector, and although there was no financial uplift over the following five years, it at least provided some stability in terms of knowing the medium terms financial settlement rather than the historical annual contractual review. However, the settlement came against a backdrop of rising minimum wage, increased pension contributions, increased rent, and rates, along with other IT and premises upgrades, and it was going to be difficult to 'sell' this to those working in the sector.
The promise of moving away from volume-based prescription work to more clinical service delivery was certainly something that the sector has been crying out for, so two years on from the new contract and still in the depth of a global pandemic I thought it would be useful to review the contract and how it has been received at the coal face.
The NHS Community Pharmacist Consultation Service was launched on 29 October 2019 as an Advanced Service.
Since 1 November 2020, general practices have been able to refer patients for a minor illness consultation via CPCS. This new service which was launched during the pandemic was a massive opportunity to shift minor illness from GP services to community pharmacy.
While GP practices were struggling to find capacity to see patients face to face, due to vaccination priorities and dealing with more complex caseloads, this new service should have fundamentally changed the way we are working, diverting consultations from general practice to community pharmacy teams. However, 18 months since the start of this service and six months since GP CPCS was launched, the volume coming through is barely registering.
To date across three of our pharmacies, we have yet to have a single referral via the GP CPCS, and only a dozen other CPCS referrals over the past six months. Its hardly the seismic shift in clinical services we were promised.
We are told that general practice has capacity issues and cannot manage the demand for its services, how come some of the workload is not being diverted to the pharmacy sector? Is it for fear that if general practice loses this work, then their funding will also be top sliced and shifted to accommodate this shift in provision?
MURs were phased out over the first two years of the five-year deal, to free up capacity and funding for the CPCS, and in recognition that NHSE&I did not consider them to offer good value for money. The service was finally decommissioned on 31 March 2021. This hardly was the right time to end a service just at the promise of a paradigm shift towards more clinical services.
So, pharmacy teams have had to stop a service that was paying circa £11,200/annum and replace it with a new service that, at current uptake, is paying about a tenth of that income.
NHSE&I have now commissioned Structured Medication Reviews (SMRs) back with general practice.
Why was our network of community pharmacies not better utilised to support these services?
New Medicines Service
Having the time to talk to patients on new medicines is extremely important and the NMS is often under utilised in practice. A formal framework exists that will remunerate pharmacies for engaging with patients taking certain category of medicines. Reassuring patients of side affects and compliance issues within the first few weeks of taking a new medicine provides better long-term adherence to medication and improved health outcomes. The service also confirms to patients that pharmacists are best qualified to talk about medication issues.
Pharmacy teams – look at your PMR and find ways of flagging up new medication, as the potential for improved clinical service and increased revenue can be substantial and rewarding.
From my experience, patients are pleased that a healthcare professional calls them to check how they are getting on with a new medicine.
Discharge Medicines Service
The Discharge Medicines Service (DMS) became a new Essential service within the Community Pharmacy Contractual Framework (CPCF) on 15 February 2021.
From 15 February 2021, NHS Trusts were able to refer patients who would benefit from extra guidance around new prescribed medicines for provision of the DMS at their community pharmacy. The service has been identified by NHS England and NHS Improvement's (NHSE&I) Medicines Safety Improvement Programme to be a significant contributor to the safety of patients at transitions of care, by reducing readmissions to hospital.
Some three months on from launch, the uptake is patchy at best, and the number of referrals again are in single figures for our small group.
Although pharmacies had to be compliant in the service from February, hospital trusts are only rolling this service out slowing over the coming months. A huge amount of time was invested in staff training; SOPs; understanding the service, yet many pharmacies have yet to receive a referral.
Why the hesitation?
It's great to be told about the shift from volume-based prescription workload to clinical services, but words need to be followed by actions.
Launching a few new NHS services that drip feed the occasional referral is hardly a paradigm shift. These need to be part of our day-to-day routine, not the odd one popping through every second month.
The new services I have described above barely register 0.75% of our monthly income – so it is hardly surprising contractors still feel the need to chase after prescriptions.
I am aware of pharmacies looking for ways of generating additional income to help support them through these difficult financial times. Setting up travel vaccination clinics, and private PGDs for certain services are a welcome addition, but these are all outside the NHS income stream. If our paymasters think we can undertake more clinical services: why the hesitation?
We have a network of clinically competent professionals ready willing and able!
'Community pharmacy teams should be working together with our general practice colleagues'
This year it is more important — perhaps more than ever — that the pharmacy...
Is it too early in the flu jab season to say I'm tired?
Is it too early in the flu jab season to say I'm tired? Because I'm...


Finding just the right pair of sunglasses is not easy. There are thousands of brands, styles and colors to choose from online or in your local sunglasses retail store. You want a style that looks great, offers maximum protection for your eyes, and sunglasses that are going to last. Here are some great tips on finding the sunglasses that are right for you.
Probably the best place to find a vast selection of sunglasses is on the Web. There are retailers online that offer every brand of sunglasses you can imagine – Maui Jim Sunglasses, Prada Sunglasses, Oakley Sunglasses, Ray Ban Sunglasses and more! Some of these retailers also offer related items such as goggles or watches. So, you can do all your shopping in one place, and never have to leave your home!
Every person's facial shape is unique. Sunglasses that look great on one person will look "not so great" on another. That's why it is important to search for sunglasses that look great on you. Don't choose sunglasses just because someone you know has a pair. Make sure you choose a style that looks great with your skin tone, shape of face, nose shape, and hair.
Tip: If you have a long, slender nose and chin, then small, round sunglasses with a thin frame would look better than large, thick glasses. The opposite is true if you have a round-shaped face and a very small nose.
Sunglasses come in a variety of colors, from pink and orange to green and purple. Choose a color that goes well with your hair and skin color. If you enjoy matching your sunglasses with your outfits, choose several pair in different colors for a variety.
UV protection (ultraviolet ray protection) is important if you plan to be outdoors any length of time. Your eyes are very sensitive to the rays of the sun whether you realize it or not. Without UV protection, your eyes are exposed to harmful ultraviolet rays that could do permanent damage to your retina. There are many types of sunglasses available online in different styles and colors that offer 100% UV protection. Though these may cost more than your average discount store sunglasses, they are going to protect your eyes, which are irreplaceable at any price! Also, sunglasses with UV protection are usually made to last, so you're getting two fabulous benefits in one.
The great thing about shopping online for items like sunglasses, watches and goggles is you get to pick and choose from many brand names such as Maui Jim Sunglasses, Oakley Sunglasses, Ray Ban Sunglasses and Prada Sunglasses, and from all sorts of styles and colors to fit your needs. And, you can take time in the privacy of your home to shop around until you find the perfect sunglasses.


text:
SeniorAdvisor Service Rating
4.6 /5 Stars
See SeniorAdvisor.com's Feefo reviews here.
If you would like to leave a review for SeniorAdvisor.com, input your email address below and click 'Submit'. You will receive an email with a link to our independent review collection service - Feefo.
In Home Care, TX
In-Home Care, Texarkana TX
In-Home Care near Texarkana, TX
Compare Pricing, Reviews, Photos & More. Fill Out The Form Below To Receive a Free Consultation:
Invalid Name Invalid Email Invalid Phone
Why use SeniorAdvisor.com?
We've helped 60 families in Texarkana, TX find options that meet their unique needs.
Talk to our local Expert Advisors for insider info on In-Home Care in Texarkana, TX.
See the best options for your budget & needs in your area.
SeniorAdvisor.com Service Rating
4.6/5 Stars Based on 3440 Reviews
Scroll down to see the most recent Feefo reviews
5 results with 2 reviews in Texarkana.
No Image Provided
Heritage Plaza Nursing Center - Texarkana, TX
600 W 52nd St, Texarkana, TX 75503
1-866-344-6929 for a local advisor
Reunion Plaza Senior Care & Rehabilitation Center - Texarkana, TX
1401 Hampton Rd, Texarkana, TX 75503
Family caregivers need time for themselves. Our senior living consultants specialize in finding the right help for family caregivers. Call us now.
1-800-805-3621 Hours
Atlanta Memorial Hospital - Atlanta, TX
1007 S William St, Atlanta, TX 75551
Southwest Arkansas Dev Council - Lewisville, AR
226 Spruce St, Lewisville, AR 71845
North Caddo Home Health - Vivian, LA
815 S Pine St, Vivian, LA 71082
Senior Care by Type in Texarkana, TX
Assisted Living in Texarkana, TX
Memory Care in Texarkana, TX
Nursing Homes in Texarkana, TX
Independent Living in Texarkana, TX
In-Home Care in Texarkana, TX
Other Assisted Living in Texas
Houston, TX Assisted Living
Dallas, TX Assisted Living
San Antonio, TX Assisted Living
Austin, TX Assisted Living
Fort Worth, TX Assisted Living
Plano, TX Assisted Living
Arlington, TX Assisted Living
Lubbock, TX Assisted Living
Home Care in Texarkana, TX
Studies have indicated that the fastest growing age demo in the United States is the one sectioned off for ages 70 and above. This is tremendous news from a strictly physiological and biological standpoint, as it means that people are living longer than ever. Yet it also means that the need for assisted living is a metric that is also going to increase over time. As such, it stands to reason to believe that there will be a lot more families of golden agers needing to figure out the dilemma that often occurs when the senior loved one in their lives needs some sort of assisted living to get through the day. And while some of these families may decide the best course of action is to do what they can to provide aid themselves, doing so tends to take its toll on people rather quickly, both from an emotional and from a physical standpoint. Yet the good news is that there are plenty of home care services in Texarkana, Texas are readily available to provide the care that golden agers may need later in life, all while providing the peace of mind for the families of the senior loved one.
A Look Around Texarkana
Like the name may intone, the Texas town of Texarkana finds itself on the border of Texas and Arkansas. More specifically, it shares a border with Texarkana, Arkansas. While the Lone Star State's iteration of the city has a population of around 36,000 residents, this population number increases to about 66,000 residents when the Arkansas version is considered.
And in a way, Texarkana Texas could be considered to be the city that connects the Midwest to the South. It is a key hub in a region that is known colloquially as Ark-La-Tex, a region that covers cities in Arkansas, Louisiana, and Texas. Needless to say, Texarkana is relatively close to Louisiana, yet it is also not that far from the Oklahoma border. As such, the city has unique positioned itself to be a place where its residents can explore the ways in which the South gradually turns into the Midwest through geography, weather, culture, and more.
Texarkana enjoys a reputation for offering a quiet, relaxed spin on Texas living; one that contains a hearty, downhome ambiance that may have more in common to Texas' roots than what could be found in the Lone Star State's major cities. It has a pretty sturdy economic landscape that is driven by retail service and the military; two industries that help keep the town's unique Texas spirit humming. Additionally, the city boasts a cost of living that is substantially lower when compared to the national average. This is terrific news to those that are looking for a city that will provide them with the chance to stretch their dollars further than the average place.
Texarkana Home Care at a Glance
Home care, which is also known as home health care or in-home care, is more or less defined as care that is provided to a senior by a professional caregiver within the confines of the golden ager's own residence. There are in essence two chief responsibilities for a caregiver in this position. Firstly, they are charged with administering aid and assistance for various activities of daily living, also known as ADLs. These important activities include dressing, bathing, or eating. The second responsibility is to provide aid with tasks to keep the affairs of the senior's house life running smoothly. Some of these tasks include housecleaning, buying groceries, and cooking meals. Ultimately, these functions work together to provide seniors with the type of aid that they would otherwise be provided in a senior living community. However, because these services would happen in the senior's own home, the senior living community would not be considered part of process.
Safe Living in Texarkana
You cannot blame a senior for wanting to receive aid for daily living within his or her own home. After all, that simple step could easily be translated to granting him or her some sort of independence. And this desire is why the home care services in Texarkana matter on the level in which they do. Because they enable golden agers to receive the care that they need within their own home, they will experience a sense of comfort and security that can only come from being in familiar surroundings. What's more, the services also provide families of the golden ager in question with a great deal of peace, which is every bit as important as the service itself.
Reported Monthly Price
Get FREE Personalized Options for Your Family Today!
See Pricing Options
Local Expert Advice


text:
What Are All The Differences Between "The Witches" Movies and Book?
I suppose some people can watch a movie without comparing it to the book it was based on or the movie version of said book that was made 30 years prior. I, however, am not that person. From the opening scene in The Witches, I started a mental catalog of the differences strictly for the purposes of writing this post. Here are all of the changes I found between the book and the 1990 and 2020 versions of the film. Needless to say, there are spoilers ahead!
Differences Between The Book And Film Versions Of "The Witches"
© Warner Bros
The book and the 2020 film are narrated by an unnamed boy. The 1990 film version begins with a narration by the grandmother and the boy is named Luke.
Both the book and 1990 version of The Witches begin in Norway and moves to England. The 2020 version of The Witches is set in 1968 Alabama, with a very brief introductory scene in Chicago.
In the book and the 2020 version of the film, the boy was in the car with his parents when the accident occurred and he survived because he was wearing his seatbelt. In the 1990 film, the boy was home with his grandmother when the car crash happened.
The boy is told stories of witches by his grandmother before his parents' deaths in the 1990 film. In the book, witch stories are told as a way to bond after the car accident. In the 2020 film, they bond by dancing to records and the grandmother only speaks of witches after one is first spotted by the boy.
©Warner Bros
The grandmother tells her grandson a story about a friend who was tricked by a witch in both movies. In the 1990 film, the friend was captured inside of an oil painting. In the 2020 version, the friend was turned into a chicken. Both things happened in the book, along with several other tales of how children disappeared.
The book and 1990 film version feature a grandmother who was a witch hunter or "witchophile". The 2020 version of the grandmother was a healer.
The grandmother smoked cigars in the book and in the 1990 movie, but the cigars were not present in the 2020 film.
The boy encounters his first witch while in the grocery store in the 2020 film. His original witch encounter took place while he was in his treehouse in the book and 1990 film.
In the book, witches hid their lack of toes by wearing stylish, pointy shoes that were painful. In the 1990 version, witches never wore pointed or pretty shoes. In 2020, the pretty, pointed shoes were back.
Three different illnesses affect the grandmother between the book and film versions. She coughs when a witch is near in the 2020 film. In the book she has pneumonia. In the 1990 film, the grandmother has diabetes.
Witches in the book had pupils that would change color, appearing as fire and ice. Witches had a purple tinge to their eyes in the 1990 film. Eyes aren't mentioned as a way to spot a witch in the 2020 movie, but they are given an elongated mouth that is hidden with pancake makeup.
The boy has pet mice in every iteration of the story. In the book and 1990 version, the grandmother gives him two mice he names William and Mary. In the 2020 film, he is given one mouse he names Daisy. While William and Mary are never more than pet mice, Daisy turns out to be a little girl who was changed into a mouse by a witch.
The boy trains his mice in the hotel ballroom behind a folding screen in the book and 1990 film version. The screen is missing in the 2020 movie so he hides under the stage riser.
The Grand High Witch is in room 666 in the 2020 film version, but is in room 454 in the book and room 208 in the 1990 film. In each iteration the grandmother and boy are in the room directly above the witch. The 2020 film mentions the hotel builder's interest in numerology when talking about the room numbers.
In every version, the boy is lowered in a partially knitted sock to visit the Grand High Witch's room to steal a bottle of Formula 86 Delayed Action Mouse Maker. He makes his escape in the sock in the 2020 film, but he has to run out the door and find his way back to his grandmother in the book and 1990 movie.
The witches eat pea soup in the book and 2020 movie. The soup is watercress in the 1990 film.
Bruno Jenkins, a little boy turned into a mouse in all versions, is returned to his family in the book and the 1990 film. In the 2020 film, he goes to live with the boy and his grandmother since his own mom hates mice and won't accept him.
The endings of the book and both films are all quite different. In the book, the grandmother and boy return to Norway and the boy remains a mouse. They find out the Grand High Witch lived in a castle in Norway and devise a plan to kill all of the remaining witches. The boy learns that he will probably only live another nine years, but is ok with that because he doesn't want to live without his grandmother.
The boy sneaks an address tag onto the trunk belonging to the Grand High Witch before they leave the hotel in the 1990 film. The trunk is delivered to their home and contains money and an address book with the location of every witch in the world. This will allow them to travel the world hunting witches. The film also included a character named Miss Irvine, an ill-treated assistant to the Grand High Witch. She travels to the grandmother and boy's home and turns him back into a human.
Finally, the 2020 version shows the grandmother, the boy, Bruno, and Daisy all living together in Alabama. They show a series of images that follow their adventures over the next few years, including one that features witch-hunting. The film ends with the boy, now a much older mouse, training children in how to kill witches.
Ready to see how all three versions compare? The Witches (2020) is streaming now on HBOMax, while The Witches (1990) is streaming on Netflix. You can pick up the book at your local library or wherever books or sold.
The SpongeBob Musical Interview: Tom Kenny and Ethan Slater
Spooky Scary Skeletons Downloadable Activity Sheets


text:
/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.facebook.presto.spi.plan;

import com.facebook.presto.spi.ColumnHandle;
import com.facebook.presto.spi.TableHandle;
import com.facebook.presto.spi.predicate.TupleDomain;
import com.facebook.presto.spi.relation.VariableReferenceExpression;
import com.fasterxml.jackson.annotation.JsonCreator;
import com.fasterxml.jackson.annotation.JsonProperty;

import javax.annotation.concurrent.Immutable;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import static java.util.Collections.emptyList;
import static java.util.Collections.unmodifiableList;
import static java.util.Collections.unmodifiableMap;
import static java.util.Objects.requireNonNull;

@Immutable
public final class TableScanNode
        extends PlanNode
{
    private final TableHandle table;
    private final Map<VariableReferenceExpression, ColumnHandle> assignments;
    private final List<VariableReferenceExpression> outputVariables;

    // Used during predicate refinement over multiple passes of predicate pushdown
    // TODO: think about how to get rid of this in new planner
    // TODO: these two fields will not be effective if they are created by connectors until we have refactored PickTableLayout
    private final TupleDomain<ColumnHandle> currentConstraint;

    private final TupleDomain<ColumnHandle> enforcedConstraint;

    @JsonCreator
    public TableScanNode(
            @JsonProperty("id") PlanNodeId id,
            @JsonProperty("table") TableHandle table,
            @JsonProperty("outputVariables") List<VariableReferenceExpression> outputVariables,
            @JsonProperty("assignments") Map<VariableReferenceExpression, ColumnHandle> assignments)
    {
        // This constructor is for JSON deserialization only. Do not use.
        super(id);
        this.table = requireNonNull(table, "table is null");
        this.outputVariables = unmodifiableList(requireNonNull(outputVariables, "outputVariables is null"));
        this.assignments = unmodifiableMap(new HashMap<>(requireNonNull(assignments, "assignments is null")));
        checkArgument(assignments.keySet().containsAll(outputVariables), "assignments does not cover all of outputs");
        this.currentConstraint = null;
        this.enforcedConstraint = null;
    }

    public TableScanNode(
            PlanNodeId id,
            TableHandle table,
            List<VariableReferenceExpression> outputVariables,
            Map<VariableReferenceExpression, ColumnHandle> assignments,
            TupleDomain<ColumnHandle> currentConstraint,
            TupleDomain<ColumnHandle> enforcedConstraint)
    {
        super(id);
        this.table = requireNonNull(table, "table is null");
        this.outputVariables = unmodifiableList(requireNonNull(outputVariables, "outputVariables is null"));
        this.assignments = unmodifiableMap(new HashMap<>(requireNonNull(assignments, "assignments is null")));
        checkArgument(assignments.keySet().containsAll(outputVariables), "assignments does not cover all of outputs");
        this.currentConstraint = requireNonNull(currentConstraint, "currentConstraint is null");
        this.enforcedConstraint = requireNonNull(enforcedConstraint, "enforcedConstraint is null");
        if (!currentConstraint.isAll() || !enforcedConstraint.isAll()) {
            checkArgument(table.getLayout().isPresent(), "tableLayout must be present when currentConstraint or enforcedConstraint is non-trivial");
        }
    }

    /**
     * Get the table handle provided by connector
     */
    @JsonProperty("table")
    public TableHandle getTable()
    {
        return table;
    }

    /**
     * Get the mapping from symbols to columns
     */
    @JsonProperty
    public Map<VariableReferenceExpression, ColumnHandle> getAssignments()
    {
        return assignments;
    }

    /**
     * A TupleDomain that represents a predicate that every row this TableScan node
     * produces is guaranteed to satisfy.
     *

     * This guarantee can have different origins.
     * For example, it may be successful predicate push down, or inherent guarantee provided by the underlying data.
     */
    public TupleDomain<ColumnHandle> getCurrentConstraint()
    {
        // currentConstraint can be pretty complex. As a result, it may incur a significant cost to serialize, store, and transport.
        checkState(currentConstraint != null, "currentConstraint should only be used in planner. It is not transported to workers.");
        return currentConstraint;
    }

    /**
     * A TupleDomain that represents a predicate that has been successfully pushed into
     * this TableScan node. In other words, predicates that were removed from filters
     * above the TableScan node because the TableScan node can guarantee it.
     *

     * This field is used to make sure that predicates which were previously pushed down
     * do not get lost in subsequent refinements of the table layout.
     */
    public TupleDomain<ColumnHandle> getEnforcedConstraint()
    {
        // enforcedConstraint can be pretty complex. As a result, it may incur a significant cost to serialize, store, and transport.
        checkState(enforcedConstraint != null, "enforcedConstraint should only be used in planner. It is not transported to workers.");
        return enforcedConstraint;
    }

    @Override
    public List<PlanNode> getSources()
    {
        // table scan should be the leaf node
        return emptyList();
    }

    @Override
    @JsonProperty
    public List<VariableReferenceExpression> getOutputVariables()
    {
        return outputVariables;
    }

    @Override
    public <R, C> R accept(PlanVisitor<R, C> visitor, C context)
    {
        return visitor.visitTableScan(this, context);
    }

    @Override
    public String toString()
    {
        StringBuilder stringBuilder = new StringBuilder(this.getClass().getSimpleName());
        stringBuilder.append(" {");
        stringBuilder.append("table='").append(table).append('\'');
        stringBuilder.append(", outputVariables='").append(outputVariables).append('\'');
        stringBuilder.append(", assignments='").append(assignments).append('\'');
        stringBuilder.append(", currentConstraint='").append(currentConstraint).append('\'');
        stringBuilder.append(", enforcedConstraint='").append(enforcedConstraint).append('\'');
        stringBuilder.append('}');
        return stringBuilder.toString();
    }

    @Override
    public PlanNode replaceChildren(List<PlanNode> newChildren)
    {
        checkArgument(newChildren.isEmpty(), "newChildren is not empty");
        return this;
    }

    private static void checkArgument(boolean test, String errorMessage)
    {
        if (!test) {
            throw new IllegalArgumentException(errorMessage);
        }
    }

    private static void checkState(boolean test, String errorMessage)
    {
        if (!test) {
            throw new IllegalStateException(errorMessage);
        }
    }
}

redpajama_set_name: RedPajamaGithub