Year 8 students had a thoroughly enjoyable week of their residential field trip at Kaeng Krachan. They started by visiting the Wildlife Friends Foundation of Thailand and the students had a great time with the animals and the volunteers.
After that they continued their trip to the resort. It was a busy week filled with lots of activities and experiences that none of the students would forget easily. Scuba diving and lake kayaking were mixed with more gentle pursuits such as archery and Thai cooking.
In the evenings, the staff entertained the students with a variety of drama, games and team building exercises. They returned to SISB happy but exhausted after a really fun week. All the students behaved impeccably well and were a credit to SISB. Together, they made many happy memories for everyone


How to check if a table already exists in the database with MySQL with INFORMATION_SCHEMA.TABLES.?
MySQLMySQLi Database
In order to check if a table already exists in the database by using MySQL, you can use INFORMATION_SCHEMA.TABLES. Following is the syntax −
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'yourDatabaseName'
AND TABLE_NAME = 'yourTableName';
Let us implement the above syntax in order to check if a table already exists in the database.
Case 1: When the table is present −
mysql> SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'sample'
AND TABLE_NAME = 'DemoTable';
This will produce the following output −
+--------------+
| TABLE_NAME |
+--------------+
| DemoTable |
+--------------+
1 row in set (0.01 sec)
Case 2: When the table is not present −
mysql> SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA= 'sample'
AND TABLE_NAME= 'DemoTable2';
This will produce the following output −
Empty set (0.01 sec)
raja
Published on 03-May-2019 12:16:53
Advertisements


Invertebrate abundance and health are acquatic biomonitoring indicators to evaluate the effects of water pollution and climate change.
STINAPA is monitoring invertebrate abundance in Lac Bay, Bonaire since 1999 at irregular time intervals. During monitoring the species and the number of individuals of that species is counted at 66 different locations.


ZF-3792: joinUsing() produces wrong SQL
$db->select()->from('A')->joinUsing('B', 'colname')
Should produce SQL syntax with the {{USING}} clause:
But it currently tries to guess at the tables being joined, and output a traditional equi-join:
SELECT * FROM A JOIN B ON A.colname = B.colname
This actually results in semantic problems in some queries, because Zend_Db_Select always assumes that a "Using" join is joining to the first table referenced in the query. This is not how the {{USING}} clause works in SQL.
$db->select()->from('A')->joinUsing('B', 'colname1')->joinUsing('C', 'colname2')
Should produce SQL syntax:
SELECT * FROM A JOIN B USING (colname1) JOIN C USING (colname2)
This should give the same results as this query:
SELECT * FROM A JOIN B ON B.colname1 = A.colname1 JOIN C ON C.colname2 = B.colname2
But in Zend_Db_Select, it produces the following SQL:
SELECT * FROM A JOIN B ON B.colname1 = A.colname1 JOIN C ON C.colname2 = A.colname2
Of course if table {{A}} has no {{colname2}}, this query returns an error.
If both {{A}} and {{B}} have a column named {{colname2}}, a query with {{USING (column2)}} is ambiguous, and should return an error. The SQL produced by Zend_Db_Select is not ambiguous, but it assumes that {{C}} is joined to {{A}}. This is in improper assumption.
Schema for above example:
CREATE TABLE A ( colname1 INT);
CREATE TABLE B ( colname1 INT, colname2 INT);
CREATE TABLE C ( coname2 INT);
SQL's {{USING}} clause actually knows which columns exist in which tables, and it decides which table you're trying to join based on which table has a column of the same name. So it knows that you intend to join {{C.colname2 = B.colname2}} because it knows {{B}} has a column {{colname2}}.
When multiple tables in the query contain a column of the same name, this is ambiguous and the semantics for {{USING}} can't guess what you intended. So it throws an error, which is the right thing to do.
Updating project management info: Minor, Should Have in Next Mini Release, assumed 2h of work.
I think that joinUsing should change to support USING like it should and at the same time it should support a joinOn. I spoke with Ralph about this issue and I came with a suggested implementation:
 public function joinOn($table, $onCondition) {
 if (strpos($onCondition,'') === false) {
 $onCondition = $this->_name. '.'. $this->_primary.'= '. $table. '.'. $onCondition;
 $this->... = 'JOIN '. $table.'ON ('. $onCondition. ')';
It's a pseudo-code... I'm not too focused on Zend Framework internals. So it's just an idea. Just a quick explanation:
The condition is there to support custom queries too. Examples:
$q->joinOn('B', 'column'); // JOIN B ON (A.column = B.column)
$q->joinOn('B','= B.column2'); // JOIN B ON ( = B.column2)
After speaking with [~ralph] on the issue, it was decided to close this as "Won't Fix" for these two reasons:
 - SQL Server and Sybase do not support USING clause
 - JOIN USING and JOIN ON differ in the way they return columns. ie: JOIN ON would have t1.col and t2.col in the result set, but JOIN USING would have only col, so references to t1.col or t2.col in the WHERE clause would fail.
More information here:…


Charging the iPad Mini 2 when planning a trip to Peru
Instructions showing how to recharge your iPad Mini 2 with a Peruvian power outlet using the USB Lightning Apple cable and a 2 pin Europlug Type C power adapter, powering the iPad Mini 2 using a two pin Type A power adapter and how to power the iPad Mini 2 using a 3 pin Type B power charger
Peruvian power outlet
Varying different region codes and voltages can all be daunting when planning on travelling to another country for the first time traveller. These instructions have been specifically written to stop travellers worrying if they'll be able to charge the iPad Mini 2 when staying in Peru.When you are travelling to Peru the following useful instructions show how to charge your iPad Mini 2 by using their standard C, A or B type Peruvian 220 volt 60Hz power outlets, please note Type C power outlets will be used by a majority of Peruvians. Power sockets will vary depending on which area you are travelling to so we recommend reading the list of World power supplies for a complete list of regions and countries. When travelling to Peru from a different country please check that your iPad Mini 2 can be charged using a 240v supply. If it originated in a country which uses a lower voltage (for example 110v) make sure your device is dual voltage (indicated by 100-240 volts) otherwise you may need to use an additional transformer to prevent the device from overheating whilst powering it up. If you intend to stay somewhere such as Lima or Arequipa read the Peru Wikipedia page [1] for further details. These instructions assume that you have installed Apple iOS 7 or greater on the iPad Mini 2.
Charging the iPad Mini 2 in Peru
Can you use the iPad Mini 2 in Peru?
You can use the iPad Mini 2 in Peru by using a power adaptor.
What is the best travel charger for recharging the iPad Mini 2 in Peru?
If you are travelling with more than just your iPad Mini 2 the best international travel adapter for Peru is a multiple USB port charger which includes swappable plugs such as a 4 port USB travel charger. Peruvians use three different types of wall outlets (C, A and B) and bringing this ensures that you are covered for both types A and C.
Because these types of chargers come with interchangeable pins and can handle 100 volts - 240 volts it makes them ideal for over 100 countries around the world just by switching the supplied plugs over. If your iPad Mini 2 supports Fast Charge then you'll benefit from much quicker charging times by using one of these USB power adapters and support for more power demanding devices like tablets. This means you can charge more than one device at once without needing to bring seperate travel chargers on your Peruvian trip or using up additional power sockets. Because you are only packing a single international travel charger will also keep the size and weight down, making it perfect to fold up in hand baggage and on hand for recharging your iPad Mini 2 at an airport or on the flight. Due to their space saving flexibility these types of power adapters can be used when you return home so when you're not travelling they can sit overnight charging multiple tablets, phones and e-readers using only a single power outlet.
For those travelling to Peru we suggest searching for an adaptable travel charger of this nature online; the travel charger illustrated below is the 4 Port USB Wall Charger which has been successfully tested with multiple USB devices in numerous foreign countries.
Alternative travel adapter for Peru
The 4 port USB travel charger is the most compact option for travellers from any country wanting to charge devices using USB, however for visitors also wishing to use their domestic plugs these power converters provide larger but more versatile solutions. All 3 power converters offer surge protection which can be crucial when visiting regions with unreliable or unstable power grids. These power converters come with interchangeable type C, I and G plugs which cover Europe, America, Australia, United Kingdom, Japan, China and over 150 countries around the world:
 - BESTEK Portable International Travel Voltage Converter - The BESTEK international travel adaptor has 4 USB charging ports with 3 AC power outlets and is the most popular portable power adapter for travellers originating from America going to Peru using 3 pin type B plug sockets.
 - ORICO Traveling Outlet Surge Protector Power Strip - Also having 4 USB ports but only 2 AC power outlets the travel adapter from Orico is also aimed at travellers from the US using type B plugs. This is a much cheaper alternative to the BESTEK with just one less AC outlet at almost half price.
 - BESTEK International USB Travel Power Strip - This power strip has 2 AC outlets but offers a generous 5 USB charging ports. This versatile power strip is compatible with both American plugs and popular plug types A, D,E/F, G, H, I, L and N making it perfect for most travellers from around the world visiting Peru. [10] [AD]
What is the best travel charger for recharging the iPad Mini 2 in Peru?
Powering the iPad Mini 2 with a Peruvian power outlet by using a 2 pinned Type A USB adapter
A page showing how to charge your iPad Mini 2 with a Peruvian power outlet with the USB Lightning Apple cable with a Type A USB charger.
 1. To power your iPad Mini 2 using the Peruvian power outlet you will need to use a Type A USB power adapter [4] and a USB to Apple Lightning cable [5], Apple will typically supply the cable with the iPad Mini 2.
 2. Start by taking the Type A USB power adapter and plugging it in the wall supply. This ungrounded power outlet (technically called the Type A power outlet [3]) can be recognised by 2 thin adjacent slots where the plug outlet blades go.
 3. Connect the USB end of the Lightning cable into the bottom of the USB power adapter and the other end into the Lightning connector on the iPad Mini 2. The iPad Mini 2 lightning connector is situated at the base of the iPad Mini 2.
 4. Turn on the Peruvian power outlet.
 5. The battery icon that you'll find in the top right corner of the tablet will display a charge icon to indicate that the iPad Mini 2 is powering up taking roughly 60 to 240 minutes to fully recharge to full capacity.
Powering the iPad Mini 2 with a Peruvian power outlet by using a 2 pinned Type A USB adapter
Powering the iPad Mini 2 with a Peruvian power outlet by using a 3 pinned Type B USB adapter
Using a Lightning connector and a 3 pin Type B power adapter to power the iPad Mini 2 with a Peruvian power outlet.
 1. To charge the iPad Mini 2 from a Peruvian power outlet you will need to use a Type B USB power adapter [7] and a USB to Apple Lightning cable [5] (Apple usually include this USB cable with the iPad Mini 2).
 2. Start by taking the Type B USB power adapter and plugging it in the wall supply. The wall outlet, sometimes called the Type B power outlet [6], can be recognised by 2 thin slots for live and neutral blades with a single hole below for the earth pin.
 3. Then connect the USB end of the Apple charging cord into the USB power adapter and the other end into the Lightning connector on the iPad Mini 2. The iPad Mini 2 lightning connector is found at the bottom of the iPad Mini 2.
 4. Switch on the Peruvian power outlet.
 5. The battery icon which appears in the top right corner of the tablet will display a charge icon to indicate that the iPad is recharging, typically taking between one-four hours to completely recharge.
Powering the iPad Mini 2 with a Peruvian power outlet by using a 3 pinned Type B USB adapter
Powering the iPad Mini 2 with a Peruvian power outlet by using a 2 pinned Type C Europlug USB adapter
Instructions showing how to recharge your iPad Mini 2 with a Peruvian power outlet using the USB Lightning Apple cable and a 2 pin Europlug Type C power adapter.
 1. To power your iPad Mini 2 using the Peruvian power outlet you will need to use a Type C USB power adapter [9] and a USB to Apple Lightning cable [5], the USB cable is normally already included with the device by Apple.
 2. Start by taking the Type C USB power adapter and plugging it in the wall supply. This unearthed power outlet, also known as a Europlug, can be recognised by 2 circular adjacent holes next to each other where the live and neutral pins slide into.
 3. Then connect the USB end of the USB Lightning cable into the bottom of the USB power adapter and the other end into the Lightning connector on the iPad Mini 2. The iPad Mini 2 lightning connector is situated at the base of the iPad Mini 2.
 4. Turn on the Peruvian power outlet.
 5. The battery icon that you'll find in the top right corner of the tablet will display a charge icon to indicate that the iPad Mini 2 is powering up which typically takes roughly 60 to 240 minutes to fully recharge to full capacity.
Powering the iPad Mini 2 with a Peruvian power outlet by using a 2 pinned Type C Europlug USB adapter
See also
We endeavour to ensure that links on this page are periodically checked and correct for suitability. This website may receive commissions for purchases made through links on this page. As an Amazon Associate WikiConnections earn from qualifying purchases. For more details please read the disclaimers page.
 1. Wikipedia - Peru Wikipedia page
 2. Apple - official iPad user guide
 3. iec.ch - Type A power outlet
 4. Type A USB power adapter - An unearthed Type A


Space Shuttle Debris
DebrisI had my kids watch the space shuttle takeoff today. It was fun for them. Then later the news started to talk about "debris" spotted on shuttle video during the launch.
All day something rubbed me the wrong way, and I'm not sure if I'm right on this or not. But is "debris" the right word for spotting something falling off the shuttle or fuel tank or whatever? I looked it up in and Merriam-Webster and neither gave a definition of "debris" that seemed to fit the context. At best it's a piece of something that's been destroyed, not something that has one piece fall off. Thoughts?


text:
Our customer have a question.
Q : When using the Initialization Latch Method, is it necessary that the Initialization Latch register and the function latch register be the same?
If different setting, execution of the initialization latch method automatically executes the function latch, so I think that the value of the function latch register will be valid.Is this correct?
Please let me know if there are inconveniences when using different values.
They must be the same value (except for the control bits). See the Initialization Latch section on page 20 for more information.

source: m-a-p/FineFineWeb


text:
Alghero is one of the most frequented areas by divers in Northern
Sardinia. One of its most distinctive aspects is the presence of
caves and caverns, derived to geological history of that area. Alghero
offers dive sites suitable for all kinds of activities: from introduction
dive to the highest degree. The presence of a protected marine area
for several years has contributed to the recovery of many species
The proposed routes will respect the level and experience of the
individual and its will be chosen about also the weather conditions.
The presence of numerous caves and underwater caves make it even
more fascinating diving in Alghero, giving more excitement and a
chance to meet animal species, otherwise unusual.


text:
Velocity Training Minimizing Risk Of Injury
There are many pitching coaches that offer velocity training, claiming they can increase velocity by 4-5 MPH…
Can their velocity training minimize the risk of injury?
We teach scientifically documented ways of increasing velocity while also decreasing the risk of injury.
- Fastball velocity training and functional fitness. This involves
(stability, mobility, durability, and flexibility). These factors have to
be in balance to increase velocity and decrease the risk of injury.
- What is velocity? And Understanding it?
- What is real velocity? (Kevin will explain)
- Perceived velocity? (Kevin will explain)
- Effective velocity? (Kevin will explain)
- Pitching Inside and Why?
- The softer the thrower, the more he has to pitch inside. Understand why?
Start improving your game and sign up for velocity training now!
Share and Enjoy

source: openbmb/Ultra-FineWeb


char(255) default NULL,
 last_name varchar(255) default NULL,
 city varchar(255),
 state varchar(255)
);
-- Populate the table with data
INSERT INTO mytable (id,first_name,last_name,city,state)
 VALUES
 (1,'Ryan','Dalton','Salt Lake City','UT'),
 (2,'Upton','Conway','Birmingham','AL'),
 (3,'Kibo','Horton','Columbus','GA');
-- Unload the data to a file in a stage
COPY INTO @mystage
 FROM (SELECT OBJECT_CONSTRUCT('id', id, 'first_name', first_name, 'last_name', last_name, 'city', city, 'state', state) FROM mytable)
 FILE_FORMAT = (TYPE = JSON);
-- The COPY INTO location statement creates a file named data_0_0_0.json.gz in the stage.
-- The file contains the following data:
{"city":"Salt Lake City","first_name":"Ryan","id":1,"last_name":"Dalton","state":"UT"}
{"city":"Birmingham","first_name":"Upton","id":2,"last_name":"Conway","state":"AL"}
{"city":"Columbus","first_name":"Kibo","id":3,"last_name":"Horton","state":"GA"}
Unloading a Relational Table to Parquet with Multiple Columns
You can unload data in a relational table to a multi-column Parquet file by using a SELECT statement as input to the COPY statement. The SELECT statement specifies the column data in the relational table to include in the unloaded file. Use the HEADER = TRUE copy option to include the column headers in the output files.
For example, unload the rows from three columns (id, name, start_date) in the mytable table into one or more files that have the naming format myfile.parquet:
COPY INTO @mystage/myfile.parquet FROM (SELECT id, name, start_date FROM mytable)
 FILE_FORMAT=(TYPE='parquet')
 HEADER = TRUE;
Explicitly Converting Numeric Columns to Parquet Data Types
By default, when table data is unloaded to Parquet files, fixed-point number columns are unloaded as DECIMAL columns, while floating-point number columns are unloaded as DOUBLE columns.
To choose the Parquet data types for sets of unloaded data, call the CAST , :: function in the COPY INTO <location> statement to convert specific table columns to explicit data types. A query in a COPY INTO <location> statement enables selecting specific columns to unload and accepts conversion SQL functions to transform the column data.
Queries in COPY INTO <location> statements support the syntax and semantics of SELECT statements to query specific Snowflake table columns to unload. Convert the data in numeric columns to specific data types using the CAST , :: function.
The following table maps Snowflake numeric data types to Parquet physical and logical data types:
Snowflake Logical Data Type
Parquet Physical Data Type
Parquet Logical Data Type
TINYINT
INT32
INT(8)
SMALLINT
INT32
INT(16)
INT
INT32
INT(32)
BIGINT
INT64
INT(64)
FLOAT
FLOAT
N/A
DOUBLE
DOUBLE
N/A
The following example shows a COPY INTO <location> statement that converts the numeric data in each unloaded column to a different data type to explicitly choose the data types in the Parquet files:
COPY INTO @mystage
FROM (SELECT CAST(C1 AS TINYINT) ,
 CAST(C2 AS SMALLINT) ,
 CAST(C3 AS INT),
 CAST(C4 AS BIGINT) FROM mytable)
FILE_FORMAT=(TYPE=PARQUET);
Floating-point Numbers Truncated
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately (15,9).
The values are not truncated when unloading floating-point number columns to Parquet files.
Back to top


text:
Currently, the NN logs its edits to each of its edits directories in sequence. This can produce the following bad sequence:
- NN accumulates 100 edits (tx 1-100) in the buffer. Writes and syncs to local drive, then crashes
- Failover occurs. SBN takes over at txid=1, since txid 1 never got writen.
- First NN restarts. It reads up to txid 100 from its local directories. It is now "ahead" of the active NN with inconsistent state.
The solution is to write to the shared edits dir, and sync that, before writing to any local drives.


The majority of quartz crystallises in a hydrothermal environment, the result of rapid cooling of silicon and oxygen in either molten magma flows or within hot thermal vents.
Enhydro quartz is transparent crystalline quartz with water-filled internal cavities. Enclosed in negative voids within the stone, there may be a bubble of air which has evaporated out of the liquid as the growing quartz crystal cooled.
If there is sufficient space enough to allow it, these air bubbles move within the cavity as the stone is rotated.
Liquid filled negative spaces within gems are common, but magnification is usually needed to observe them.
however, in some cases where the stone and the void are large enough, the movement is visible to the naked eye, making such examples highly collectable gem rarities.


Take the 2-minute tour ×
The Hermite polynomials are defined as $$H_n(x)=(-1)^n e^{x^2}\dfrac{d^n}{dx^n}e^{-x^2}.$$
How does one prove that all the roots of the Hermite polynomial are real?
share|improve this question
2 Answers 2
up vote 16 down vote accepted
By induction, $H_n$ is a polynomial of degree $n$. Its roots are the zeros of $u_n(x) = \frac{d^n}{dx^n} e^{-x^2}$. But by Rolle's theorem, between any two zeros of a differentiable function there is a zero of its derivative. The same is true between a zero and $+\infty$ or $-\infty$ for a function that goes to $0$ at $\pm \infty$.
share|improve this answer
This is a great answer! – rotten Feb 2 '12 at 6:48
_USER_ Israel I will complete the answer in the following:Assume the result is right when k=n-1, that is $u_{n-1}(x)$ has n-1 real roots.Then consider when k=n, by Rolle's theorem, there are n-2 real roots which satisfies u_n(x)=0, name them $$a_1


smallstring-0.1.0: A string type optimized for size in memory
The SmallString type is for storing small identifiers. We do not provide fast operations on strings - what we offer is low memory overhead.
The Ord instance is not guaranteed to be the same as that of the corresponding string.
data SmallString Source
A space efficient representation of text. This is like a strict ByteString, but with fewer features, and UTF preserving. Fow ASCII data, we're slightly smaller than ByteStrings for small strings.
fromString :: String -> SmallStringSource
Convert a String into a SmallString.
toString :: SmallString -> StringSource
Convert a SmallString into a String.


text:
This article was originally distributed via PRWeb. PRWeb, WorldNow and this Site make no warranties or representations in connection therewith.
Complete Blood Viscosity Profile Accurately Measures Thickness and Stickiness of Blood Flow for Assessing Cardiovascular Health
Seattle, WA (PRWEB) October 11, 2012
Meridian Valley Laboratory, a pioneer in diagnostic and functional testing for patients and practitioners worldwide since 1976, is the first laboratory in the nation to offer a new blood viscosity test that offers unprecedented insight about a patient's blood thickness and stickiness for earlier detection of cardiovascular risks. The test can offer an early warning for helping patients and their doctors utilize the results for prevention of future heart attacks and strokes. Unlike blood viscosity tests that use serum and plasma, the Complete Blood Viscosity Profile tests whole blood and is thus able to provide information about the actual ability of blood to flow.
"Over 10,000 peer-reviewed scientific studies have been published on blood viscosity," says Dr. Jonathan V. Wright, internationally known physician, author and Meridian Valley Lab's founder and medical director. "Blood viscosity has been shown to be an independent predictor of heart attacks and strokes. Systolic blood viscosity alone has been shown to contribute at least as much predictive power as blood pressure and LDL cholesterol and more predictive power than tobacco use. Blood that is too thick or sticky can cause problems with blood flow and can damage your cardiovascular system. The Complete Blood Viscosity Profile test is critical for anyone over the age of 60 and highly recommended for people with any personal or family history of heart disease or stroke, personal or family history of diabetes, metabolic syndrome or obesity, or high blood pressure."
As part of the Baltimore Longitudinal Study of Aging, researchers at the National Institute of Aging demonstrated the critical relationship between blood viscosity and age. There is almost no age-associated increase in viscosity until 60 years of age, but after 60 years, blood viscosity increases exponentially. The Complete Blood Viscosity Profile is a vital sign for all adults over 60 year old in general health assessments and for earlier, more accurate detection of cardiovascular risk.
A few clinical reference labs claim to offer whole blood viscosity, however these tests are just for systolic blood viscosity, not diastolic. In other words, the other labs only test the thickness of the blood and not the stickiness. This is like testing blood pressure with a cuff and only measuring systolic pressure, not diastolic. The Tahoma Clinic uses an automated scanning capillary viscometer that acquires a Complete Viscosity Profile for each patient. It is the only way available to measure systolic and diastolic blood viscosity – both the thickness and stickiness of blood.
Doctors interested in scheduling patients for a blood viscosity test can contact Meridian Valley Lab to order a viscosity shipping kit or to establish an account at _PHONE_ (toll-free at 855-405-TEST).
About Meridian Valley Lab
Meridian Valley Lab, founded in 1976, is a world leader in allergy and hormone testing, specializing in comprehensive 24-hour Urine Hormone and Metabolite testing. Meridian Valley Lab was the first lab in the USA to offer this test to help doctors use Bio-Identical Hormone Replacement Therapy safely and effectively. The pioneering spirit of the lab is largely due the fearless dedication of Dr. Jonathan Wright, Medical Director, and his fearless dedication to serving humanity. Meridian Valley Lab's core values are quality and accuracy. The staff working at all levels within the organization are fully qualified, conscientious and interested in providing the best laboratory services.
More information is available at _URL_
For the original version on PRWeb visit: _URL_

source: HuggingFaceFW/fineweb-edu


Distributed Spatial Keyword Querying on Road Networks
Abstract
Spatial-keyword queries on road networks are receiving increasing attention with the prominence of location-based services. There is a growing need to handle queries on road networks in distributed environments because a large network is typically distributed over multiple machines and it will improve query throughput. However, all the existing work on spatial keyword queries is based on a centralized setting. In this paper, we develop a distributed solution to answering spatial keyword queries on road networks. Example queries include "find locations near a supermarket and a hospital," and "find Chinese restaurants within 500 meters from my current location." We define an operation for answering such queries and reduce the problem of answering a query into computing a function of such operations. We propose a new distributed index that enables each machine to independently evaluate the operation on its network fragment in a distributed setting. We theoretically prove the space optimality of the proposed index technique. We conduct experiments with a distributed setting. Experimental results demonstrate the promising performance of our method.
DOI: 10.5441/002/edbt.2014.23
Extracted Key Phrases
13 Figures and Tables
01020201520162017
Citations per Year
Citation Velocity: 7
Averaging 7 citations per year over the last 3 years.
Learn more about how we calculate this metric in our FAQ.
Cite this paper
@inproceedings{Luo2014DistributedSK, title={Distributed Spatial Keyword Querying on Road Networks}, author={Siqiang Luo and Yifeng Luo and Shuigeng Zhou and Gao Cong and Jihong Guan}, booktitle={EDBT}, year={2014} }


Drew Silcock new Stream(consciousness)
Jekyll KaTeX Block
If you follow Hacker News, then you might've seen the latest development from Khan Academy: .
Although it hasn't yet implemented the full set of mathematical symbols, promises to replace MathJax as the web technology for displaying mathematical expressions. This plugin utilises Jekyll's plugin system to enable you to easily add mathematical equations to your statically generated site, by adding a Liquid block corresponding to content to be rendered by .
It's as simple as adding this plugin to your _plugins folder, pointing the plugin to your JavaScript file in _config.yml, and including the CSS in the resulting web pages.
For more information, continue reading, or if you want to just go straight to the code, head over to _URL_
Why KaTeX?
So why should you use ? Well, here's a few reasons:
 - It's super fast;
 - It supports server side rendering;
 - Pure CSS (the JS is only necessary is you're rendering client-side);
 - It's super fast.
The Jekyll KaTeX plugin
So how does this Jekyll plugin fit in?
Well, there are three types of Jekyll plugins:
 1. Generators
 2. Converters
 3. Tags
A subset of the Tags plugin is the Block plugin. What this does is provides access to a Liquid block, that takes the content inside the block and does with it as you specify in your plugin. Here's an example of a Liquid block:
{% myblock %}
This is the content inside the block!
{% endmyblock %}
The Jekyll block then provides the {% latex %} block, which uses to compile the contents of the block into an equation. So this is how you'd use it in your post:
{% latex %}
E = \gamma mc^2
{% endlatex %}
In addition, you can pass tokens to blocks like so:
{% myblock mytoken %}
Block contents
{% endmyblock %}
So if you pass the centred token to the latex block like so:
{% latex centred %}
E = \gamma mc^2
{% endlatex %}
Then the equation will also be cented on the page, with some space above and below. This is achieved using a little bit of inline CSS injected into the equation.
How to install it
If you've already got the JavaScript installed on your system, as well as the CSS files and the font files, then all you need to do is drop jekyll-katex-block.rb into your _plugins directory in your project, and you're ready to go!
Just make sure that you're loading the CSS in your web page (but not the JavaScript) and have the font files available.
Options
You can specify where to tell the plugin to look for your JavaScript file in your _config.yml with the following:
katex:
 path_to_js: "./the/path/to/your/js"
Troubleshooting
If you're seeing a bunch of weird symbols instead of your equations, then it's probably because you're not using UTF-8. This is what it'll look like:
without utf-8, your browser will get very confused
Put the following in the head of your HTML to sort it out:
<meta charset=utf-8>
If you're seeing your equations, but they don't have any special formatting and just look like weird, squished, ugly versions of what you want, like this:
this is what happens if you don't have the font files in the right place
Then it's probably because your server can't find the font files. You can test this out by doing the following:
$ jekyll build
$ cd _site
$ python -m SimpleHTTPServer
Go to your web page in question with your web browser, and look at the output of your Python session. It should say something like:
Serving HTTP on 0.0.0.0 port 8000 ...
127.0.0.1 - - [04/Nov/2014 12:18:07] "GET / HTTP/1.1" 200 -
But if your server can't find the font files, it'll output the following:
127.0.0.1 - - [04/Nov/2014 12:23:26] code 404, message File not found
127.0.0.1 - - [04/Nov/2014 12:23:26] "GET /fonts/KaTeX_Math-Italic.woff HTTP/1.1" 404 -
127.0.0.1 - - [04/Nov/2014 12:23:26] code 404, message File not found
127.0.0.1 - - [04/Nov/2014 12:23:26] "GET /fonts/KaTeX_Size1-Regular.woff HTTP/1.1" 404 -
127.0.0.1 - - [04/Nov/2014 12:23:26] code 404, message File not found
127.0.0.1 - - [04/Nov/2014 12:23:26] "GET /fonts/KaTeX_Size3-Regular.woff HTTP/1
To solve this, put all your font files in in the same directory as your CSS file, that way it'll automatically look for and find it. If you're still having problems, have a look at the example Jekyll site on the GitHub repo, or comment below.
Now you should be back to how it's supposed to look:
K0=ihtmei2πhtm(xx)2
How it works
The plugin basically works by compiling within the Ruby script using the ExecJS module. The JavaScript function renderToString is then called from this compiled JavaScript on the content inside the block. This converts the content from to HTML.
The Ruby code to actually do this looks like this:
# Compile the KaTeX JavaScript
katexsrc = open(path_to_katex_js).read
@katex = ExecJS.compile(katexsrc)
# Turn a LaTeX string into HTML equation
equation_string = "E = \gamma mc^2"
html = @katex.call("katex.renderToString", equation_string)
The @ sign indicates that the katex variable is an instance variable, which basically means that it's available to all the methods within the current class. The block itself is a class inheriting from Liquid::Block. It's a member of the Jekyll::Tags module, which makes it accessible to Jekyll on runtime.
As with all tags, it then needs to be registered. This is where you tell Liquid what identifier the tag should have, i.e. what string inside the {% and %} brackets should activate the plugin. This looks like the following:
Liquid::Template.register_tag('latex', Jekyll::Tags::KatexBlock)
Where KatexBlock is the block class.
To see the full code, head over to the GitHub repository.
If you liked this post, have any questions or fancy having a good discussion, please leave a comment below, or send me an email.
comments powered by Disqus


text:
Automation of capacitance measurements for power semiconductor modules
This paper presents an overview of questions related to the increase in accuracy of measurements of capacitance parameters of power semiconductor modules when developing a device for automated measurements. The paper addresses the matters of circuit engineering of primary components, technical characteristics and software of a meter designed to automate the process of testing of capacitance parameters of power modules based on insulated gate
bipolar transistors and fast recovery diodes. Unit testing results that prove the efficiency of
the proposed method of the technical implementation are provided. Software implementation is described; ways to improve software-hardware solution are proposed. The paper is of value for developers and users of equipment for automated testing of electric parameters of semiconductor devices.
Keywords: automated test equipment (ATE), capacitance parameters, IGBT, FRD, power semiconductor modules, MATLAB.


text:
tree-equal tree-1 tree-2 &key test test-not => generalized-boolean
Arguments and Values:
test---a designator for a function of two arguments that returns a generalized boolean.
test-not---a designator for a function of two arguments that returns a generalized boolean.
generalized-boolean---a generalized boolean.
tree-equal tests whether two trees are of the same shape and have the same leaves. tree-equal returns true if tree-1 and tree-2 are both atoms and satisfy the test, or if they are both conses and the car of tree-1 is tree-equal to the car of tree-2 and the cdr of tree-1 is tree-equal to the cdr of tree-2. Otherwise, tree-equal returns false.
tree-equal recursively compares conses but not any other objects that have components.
The first argument to the :test or :test-not function is tree-1 or a car or cdr of tree-1; the second argument is tree-2 or a car or cdr of tree-2.
(setq tree1 '(1 (1 2)) tree2 '(1 (1 2))) => (1 (1 2)) (tree-equal tree1 tree2) => true (eql tree1 tree2) => false (setq tree1 '('a ('b 'c)) tree2 '('a ('b 'c))) => ('a ('b 'c)) => ((QUOTE A) ((QUOTE B) (QUOTE C))) (tree-equal tree1 tree2 :test 'eq) => true
Side Effects: None.
Affected By: None.
The consequences are undefined if both tree-1 and tree-2 are circular.
equal, Section 3.6 (Traversal Rules and Side Effects)
The :test-not parameter is deprecated.


text:
Background: Living kidney donors have donation-related out-of-pocket costs (direct costs) and/or ongoing daily expenses while losing income (indirect costs). Yet there is little information about how much of a subjective burden these constitute for the donors.
Methods: From December 2003 through December 2014, we surveyed donors 6 months postdonation to determine their financial burden related to donation (on a scale of 1 to 10) and what resources were used to cover expenses.
Results: Of 1136 surveyed, 796 (70%) responded. Among respondents, mean age at donation was 43.6 ± 10.6 years, 64% were women, 96% were white, and 53% were related by blood to their recipient. Overall, 26% scored their financial burden as 5 or higher; 8% scored it as 8 or higher. Increased expenses were associated with a higher reported burden; however, significant burden was reported by some with no out-of-pocket expenses (presumably due to lost wages and continuing expenses). The burden was scored as 5 or higher by 27% of those employed outside the home (n = 660), 15% homemakers, 13% retirees, 40% students; 28% unemployed; and 26% whose occupation was unknown. Over half (51%) of those receiving a local or (means-tested) national grant still reported moderate to severe burden. Besides grants, donors used a variety of sources to help offset expenses: dipped into savings, borrowed from friends or family, took out a loan, and/or had a fundraiser. Those with the highest burden reported using the most additional sources.
Conclusions: Donors should not have to incur costs or a financial burden to donate; the transplant community should strive to make donation financially neutral.


Perform an upgrade
You can upgrade your Adobe Commerce or Magento Open Source application from the command line if you installed the software by:
 - Downloading the metapackage using the composer create-project command.
 - Installing the compressed archive.
NOTE
Do not use this method to upgrade if you cloned the GitHub repository. Instead, see Upgrade a git-based installation for upgrade instructions.
The following instructions show you how to upgrade using Composer. Adobe Commerce 2.4.2 introduced support for Composer 2. If you are attempting to upgrade from <2.4.1, you must first upgrade to a version that is compatible with Composer 2 (for example, 2.4.2) using Composer 1 before upgrading to Composer 2 for >2.4.2 upgrades. In addition, you must be running a supported version of PHP.
WARNING
The procedure for upgrading Adobe Commerce and Magento Open Source has changed. You must install a new version of the magento/composer-root-update-plugin package (see prerequisites). In addition, the commands for upgrading have changed from composer require magento/<package_name> to composer require-commerce magento/<package_name>.
Before you begin
You must complete the upgrade prerequisites to prepare your environment before starting the upgrade process.
Manage packages
NOTE
See the examples at the end of this section for help with specifying different release levels. For example, minor release, quality patch, and security patch. Adobe Commerce customers can access patches two weeks before the General Availability (GA) date. Pre-release packages are available through Composer only. You cannot find them on the Downloads Portal or GitHub until GA. If you cannot find these packages in Composer, contact Adobe Commerce Support.
 1. Switch to maintenance mode to prevent access to your store during the upgrade process.
 bin/magento maintenance:enable

 See Enable or disable maintenance mode for additional options. Optionally, you can create a custom maintenance mode page.
 2. Create a backup of the composer.json file.
 cp composer.json composer.json.bak

 3. Add or remove specific packages based on your needs.
 For example, if you are upgrading from Magento Open Source to Adobe Commerce, remove the Magento Open Source package.
 composer remove magento/product-community-edition --no-update

 You can also upgrade sample data.
 composer require <sample data module-1>:<version> ... <sample data module-n>:<version> --no-update

 - Adobe Commerce:
 composer require magento/module-bundle-sample-data:100.4.* magento/module-widget-sample-data:100.4.* magento/module-theme-sample-data:100.4.* magento/module-catalog-sample-data:100.4.* magento/module-customer-sample-data:100.4.* magento/module-cms-sample-data:100.4.* magento/module-catalog-rule-sample-data:100.4.* magento/module-sales-rule-sample-data:100.4.* magento/module-review-sample-data:100.4.* magento/module-tax-sample-data:100.4.* magento/module-sales-sample-data:100.4.* magento/module-grouped-product-sample-data:100.4.* magento/module-downloadable-sample-data:100.4.* magento/module-msrp-sample-data:100.4.* magento/module-configurable-sample-data:100.4.* magento/module-product-links-sample-data:100.4.* magento/module-wishlist-sample-data:100.4.* magento/module-swatches-sample-data:100.4.* magento/sample-data-media:100.4.* magento/module-offline-shipping-sample-data:100.4.* magento/module-gift-card-sample-data:100.4.* magento/module-customer-balance-sample-data:100.4.* magento/module-target-rule-sample-data:100.4.* magento/module-gift-registry-sample-data:100.4.* magento/module-multiple-wishlist-sample-data:100.4.* --no-update

 - Magento Open Source:
 composer require magento/module-bundle-sample-data:100.4.* magento/module-widget-sample-data:100.4.* magento/module-theme-sample-data:100.4.* magento/module-catalog-sample-data:100.4.* magento/module-customer-sample-data:100.4.* magento/module-cms-sample-data:100.4.* magento/module-catalog-rule-sample-data:100.4.* magento/module-sales-rule-sample-data:100.4.* magento/module-review-sample-data:100.4.* magento/module-tax-sample-data:100.4.* magento/module-sales-sample-data:100.4.* magento/module-grouped-product-sample-data:100.4.* magento/module-downloadable-sample-data:100.4.* magento/module-msrp-sample-data:100.4.* magento/module-configurable-sample-data:100.4.* magento/module-product-links-sample-data:100.4.* magento/module-wishlist-sample-data:100.4.* magento/module-swatches-sample-data:100.4.* magento/sample-data-media:100.4.* magento/module-offline-shipping-sample-data:100.4.* --no-update

 4. Upgrade your instance using the following composer require-commerce command syntax:
 composer require-commerce magento/<product> <version> --no-update [--interactive-root-conflicts] [--force-root-updates] [--help]

 Command options include:
 - <product> —(Required) The package to upgrade. For on-premises installations, this value must be either product-community-edition or product-enterprise-edition.
 - <version> —(Required) The version of Adobe Commerce or Magento Open Source you are upgrading to. For example, 2.4.3.
 - --no-update —(Required) Disables the automatic update of the dependencies.
 - --interactive-root-conflicts —(Optional) Allows you to interactively view and update any out-of-date values from previous versions, or any customized values that do not match the version you are upgrading to.
 - --force-root-updates —(Optional) Overrides all conflicting custom values with the expected Magento values.
 - --help —(Optional) Provides usage details about the plugin.
 If neither --interactive-root-conflicts nor --force-root-updates are specified, the command keeps the existing values that are in conflict and displays a warning message. To learn more about the plugin, refer to the Plugin Usage README.
 5. Update the dependencies.
 composer update

Example - list available versions
To see the full list of available 2.4.x versions:
Magento Open Source:
composer show magento/product-community-edition 2.4.* --available | grep -m 1 versions
Adobe Commerce:
composer show magento/product-enterprise-edition 2.4.* --available | grep -m 1 versions
Example - Minor release
Minor releases contain new features, quality fixes, and security fixes. Use Composer to specify a minor release. For example, to specify the Magento Open Source 2.4.3 metapackage:
Magento Open Source:
composer require-commerce magento/product-community-edition 2.4.0 --no-update
Adobe Commerce:
composer require-commerce magento/product-enterprise-edition 2.4.0 --no-update
Example - Quality patch
Quality patches primarily contain functional and security fixes. However, they can sometimes contain new, backward-compatible features. Use Composer to download a quality patch. For example, to specify the Magento Open Source 2.4.1 metapackage:
composer require-commerce magento/product-community-edition 2.4.3 --no-update
Magento Open Source:
composer require-commerce magento/product-community-edition 2.4.3 --no-update
Adobe Commerce:
composer require-commerce magento/product-enterprise-edition 2.4.3 --no-update
Example - Security patch
Security patches contain security fixes only. They are designed to make the upgrade process faster and easier.
Security patches use the Composer naming convention 2.4.x-px. Use Composer to specify a patch.
Magento Open Source:
composer require-commerce magento/product-community-edition 2.4.3-p1 --no-update
Adobe Commerce:
composer require-commerce magento/product


PLEASE, please leave comments so I feel more motivated to post XD. Lots of love!
Friday, 7 December 2018
Kurokami sama
What is Kurokami Sama?
It is the name of a ritual as well as of a god.*1
This ritual can be done when you have received unfair treatment, such as bullying and power harrassment*2, from others.
How to do it
1. Pull out a strand of your hair.
2. Holding the strand of your hair in your hand, intone the name of the person you want to get revenge on and what deeds this person has done to you. And say, "May my wrongs be avenged."
3. Go up to a high place like the top of a building, and say "Kurokami sama, please avenge my wrongs," and let go of the strand of the hair.
Make sure you tell no one about the ritual
There was once a girl called K who was being bullied at school. As soon as she performed the ritual, those who were bullying her met with misfortunes one by one; some had their families broken up, some fell victims to incurable disease, and others suffered severe mental breakdown. The bullying to her stopped, but one day K came across another bullying done to another girl, and she taught the girl about Kurokami sama ritual. Right after that, the fortunes of K's bullies gradually began to rise, and instead K's fortune quickly declined. K eventually disappeared. No one knows where she is now.
When is Kurokami sama active?
It is said that Kurokami sama begins to be active around two after midnight to fulfil the wish of those who seek the god's help. Kurokami sama appears in the form of "something that is covered competely by hair." If a "good person" happens to encounter Kurokami sama, it will bring luck to the person, but if a "bad person" encounters Kurokami sama, it will bring misfortune to the person. There has been sporadic reports of sightings of Kurokami sama in Kanto region. *3
*1Kurokami sama - Kuro (黒) means black, kami (髪) means hair and sama is a horonific for someone of a higher rank than yourself or for deities (Wikipedia).
*2 5 facts about Power Harassment: Workplace Bullying in Japan
*3 Kanto Region - an area encompasing Tokyo (Wikipedia)
Friday, 30 November 2018
Announcement from Saya (AGAIN)
Thank you everyone for your kind messages yesterday.
I'm not trying to create a confusion here, but yesterday I had a very, very, VERY bad day.
But today I feel better and I realise I want to keep this blog going and it's not such a good idea to leave it unupdated for too long.
So I have decided to update something next week.
I'm sorry to have confused you.
I love you all,
(P.S. I will reply to your comments soon)
Thursday, 29 November 2018
Announcement from Saya
Hi everyone! Thank you always for your support!
I would just like to let you know that I may not be updating the blog until Christmas.
I'm too busy and too tired right now. If I change my mind, I will let you know!
Take care and be happy! :)
Much Love,
Tuesday, 27 November 2018
Notsuke Peninsula, Hokkaido
Notsuke Peninsula in Hokkaido is Japan's longest sandspit, extending for 26 km (about 16 miles) in length. Withered pine trees stand all around on the wetland, giving the landscape a bleak and otherworldly appearance.
Todowara, Notsuke Peninsula, aka "The End of the World"
But it is rumoured that on a foggy day, this place truly becomes a gateway of anotherwold.
On such a day, people are warned not to walk towards the direction from which the sound of bells comes, or not to follow after a little girl wearing red dress.
Sunday, 25 November 2018
Emergency Shelter
(Translated by Saya)
This is a cryptic story! :)
A certain countryside region was hit by earthquake.
I headed to the nearest elementary school building, which was a designated emeregency shelter, and decided to spend a night in there; but as turned out, it was too crowded and therefore too noisy and too warm.
When I went outside to get some fresh air, I noticed there was another building with the lights out on the same premises.
I walked over to it and went inside. It was cool, quiet and a lot of people were lying down on the floor.
I felt so lucky to have found the place and lay down in the same way as the others to go to sleep. But after a while I realised there was something wrong with the place. It was far too quiet.
I dashed out of the building.
Monday, 19 November 2018
Yokai or Ghost? A Creepy Woman Appears in Hokkaido, Japan
 A creepy woman appears in Sapporo, Hokkaido, who stands in the middle of a pedestrian crossing and keeps staring ahead even after traffic lights have changed.
(Translated by Saya)
1: Anonymous 2018/11/11(Sun) 23:12:14.45 ID:jBrM7swNd
Pure horror
3: Anonymous 2018/11/11(Sun) 23:12:55.85 ID:HwScmoOB0
OK scary
6: Anonymous 2018/11/11(Sun) 23:13:31.28 ID:PPuJ216O0
Frightened the living daylights out of me!
8: Anonymous 2018/11/11(Sun) 23:13:53.64 ID:8D5sQ8j50
This is like a materialised ghost
12: Anonymous 2018/11/11(Sun) 23:14:21.56 ID:bQohlaqe0
I thought she was going to attack the car, but she just keeps standing there. That makes it even creepier.
Wednesday, 14 November 2018
The Suspension Bridge
(Translated by Saya)
This is a true story that really happened to my friend, although he never told me the exact location where it took place.
The incident caused two deaths, and he himself had to be quesitoned by the police over and over again.
I heard the story in question from my friend while we were still at college...
It happened when my friend and his six coworkers at his part-time job went for a drive to a suspension bridge in a certain prefecture in the Chugoku region.*1
They split off and drove separately in two cars.
My friend was the driver of the second car.
In the first car which drove ahead of him, there were the manager and a couple, and in his own car there were the remaining four people including himself.
Although they set off in the morning, due to the many stops they made on the way, the sun was already setting when they arrived at the suspension bridge.
The suspension bridge ran across a deep valley in the middle of a mountain.
As they approached the bridge, it began to drizzle, and fog started swirling around them.
There was an open space in front of the bridge, and if the weather were fine, they would have parked their cars in there and crossed the bridge to the other side on foot and come back.
(The other side of the bridge was a dead end. The bridge was left there for sight-seeing.)
However, the moment they reached the open space, the first car came to an abrupt halt.
"What are they doing...?"
The four people, who were inside the second car which also stopped about 10 metres behind the first car, had no clue as to why the manager stopped his car. For some minutes, those in the second car just sat there looking on.
Sunday, 11 November 2018
Full Moon
(Translated by Saya)
The following is the account of my mother's experience...
Five years ago, my mother was working for my father's business partner.
Her boss, the company director, would become very irritable at times, and lose his temper at the slightest provacation.
Someone would tell him, "please make sure you look through these documents," and he would somehow blow up, and start taking his anger on the objects around him, and sometimes even start throwing them around.
One day, my mother was on her way home thinking "he was in a bad mood today too," when she noticed the full moon in the sky.
The same thing happened the following month, and the month after that; and she realised that when her boss became irritable it was invariably on a full moon day.
In time, she started thinking, "I don't want to go to work tomorrow because it's a full moon day."
But the boss died suddenly, and it was not because of illness or an accident. He had seemed perfectly robust and healthy up until the time of his death.
Apparently, he had a heart attack. People conjectured that perhaps he had been working too hard.
Friday, 9 November 2018
(Translated by Saya)
When I told this to a friend, he froze for a second, and then burst out laughing...
But to me, it was a quite creepy experience.
This story involves my daughter, who turned three last June.
My daughter has some


Learn Scuba Diving on Koh Tao
Why learn scuba diving? It may be to explore a new world, to travel to new places or to experience what it is like to be weightless just like an astronaut! If you are still wondering why, below are 5 reasons to visit Koh Tao to try scuba diving on your next trip.
Become an explorer
Descending to the depths of our ocean is a very special feeling. Realising how vast and diverse the ocean's underwater ecosystem is, can be quite humbling. Often people describe scuba diving as exploring a new and unknown world. We still regularly discover new species. Diving Koh Tao is a perfect way to satisfy this need to explore and learn how to scuba dive.
Travel to new places
Once you have completed your PADI Open Water scuba diving course, the world is your oyster! It will open up new travel destinations that you had never considered before. Maybe the quality of transport and accommodation take second place in favor of fantastic diving and exploring new parts of the vast underwater world.
Know what it feels like to defy gravity
We all know what it feels like navigate in a two dimensional way bound by gravity. But what about defying gravity and weightlessly explore in three dimensions? Your scuba diving instructor will teach you about buoyancy and how to remain neutral to gravity no matter what depth you are diving at. The possibilities are endless. Imagine exploring details of a huge war ship at eye level, as opposed to standing at the foot of it in a museum.
Join the scuba diving community
Scuba divers are relaxed people that share a love for our ocean and marine life. Being a scuba diver will undoubtedly change your life and introduce you to a new community of people. You will meet other divers from all over the world with whom you can exchange diving spots. Many divers attribute diving to having changed their lives forever. Especially those of us who become diving professionals and make a career out of diving.
Become an advocate for our ocean
We often think of the ocean as this vast body of water that is invincible. As a PADI scuba diver, you will soon realise how fragile the marine ecosystem is. Every choice you make is somehow connected to our ocean and its marine life. Most scuba divers fall in love with the ocean and become advocates to preserve our ocean for future generations. At Sairee Cottage Diving, we donate to PADI Project AWARE with every Open Water certification.
Can you think of additional reasons? Share them in the comments.
Spread the love
1 Comment
 1. Get under the water to chill out, empty your head of all the everyday hustle, bustle and stress. So calming down there in the blue, a magical place.
Leave a Reply


PLC FAQ's
Answer:
You can extend modules using the existing backplane. When additional backplanes are required, both local I/O extension and remote I/O extension are available. Remote I/O extension is available via DeviceNet.
System Extension Structure
Answer:
The DVP10MC is a CANopen motion controller and the DVPCOPM-SL is a CANopen master communication module. Both support protocols. The DVP10MC has built-in motion control and PLC functions which adopt the method of CANopen bus to achieve multi-axis motion control. It also supports general extension functions which are the same as the Delta Slim Type extension modules on the left and the PLC on the right. Some default data exchange areas are reserved for data transfer when conducting motion control and program control.
2. Generate E-CAM data from DTO instructions.
The CAM chart draws the curves from point-to-point or via functions.
The DTO instructions automatically create flying shear curves. Users can set relevant parameters and operation requirements for the actual structure of the flying shear. E-CAM curves that meet these requirements can then be created and utilized.
Answer:
There are two ways to create a CAM chart.
1. Draw E-CAM curves from the CAM chart.
2. Generate E-CAM data from DTO instructions.
The CAM chart draws the curves from point-to-point or via functions.
The DTO instructions automatically create flying shear curves. Users can set relevant parameters and operation requirements for the actual structure of the flying shear. E-CAM curves that meet these requirements can then be created and utilized.
Answer:
Four models do: the EH2-L, 28SV, 12SA2, and 20SX2.

Answer:
The 2-axis 200K models that have such a feature are the 20EH00T2, 32EH00T2, and 32EH00T2-L. The 4-axis 200K model that has this feature is the 40EH00T2.
Answer:
The extension module on the left is a parallel high-speed extension module, that includes extensions to the communication module and analog function. The general extension module is a serial extension module on the right, including extensions to I/O points and analog functions, temperature measurement, motion control, and communication and power modules.
Answer:
The input or output modes of the Delta analog module all have corresponding control register (CR) numbers. The CR data can be read or written using the From/To instructions.
Answer:
The range of analog input voltage for the analog input module DVP04AD/DVP06AD is ± 10V while the range of digital conversion and resolution are ± 8,000 and 14 bits. The range of analog input current is ± 20mA while the range of digital conversion and resolution are ± 4,000 and 13 bits.
Answer:
There are 12 bits of resolution for the analog output module DVP02DA/DVP04DA, a range of 0 ~ 10V for the analog voltage output, and a range of 0 ~20mA for the analog current output. All correspond to the range of 0 to 4,000 for digital data.


s in Discovery Dashboard.
Setting up Algorithm Controls in Ranking Diagnostics
 1. Go to Search & Merchandising > Operational tools > Ranking diagnostics. In this example, we have Query Relaxation turned ON by default. The query "small fabulous table" currently shows 1463 results. We'll turn Query Relaxation OFF using Algorithm controls parameters.
1999
 1. To turn OFF Query Relaxation, click the Edit option next to the API Modifier tag.
1141
 1. Select the Custom tab and enter the required parameter. In this case, the parameter is query.relaxation=off.
 2. Click +Add and then Save the settings. The added parameter will appear next to the API Modifier tag.
Impact of Algorithm mode changes
After disabling Query Relaxation, the same query will now show null results.
1999
Note: We have discussed Query Relaxation OFF mode controls in this example. You can follow the same steps for adding parameters to the front-end API calls for the other 3 Algorithm controls.
API Controls FAQs
 1. Can all the algo controls be turned off?
 No, only Query Relaxation, Spell Correct, and SmartSort can be turned off. Refer to the table above for more details
 2. What happens when two different values of the same algo control feature are passed in one API call?
 The system will respect the order in which the parameters are sent in the API call and will pick the last one. Although, if the last value isn't correct or cannot be applied for that query, then the system will fall back to the previous value that is passed in the API.
 For example, in an API call, consider the first value for precision mode passed is query.precision=product_type_precision followed by query.precision=category_precision. In this case, the system will apply query.precision=category_precision given all the conditions for Category Precision are satisfied for that query. If the conditions are not satisfied, it will fall back to Product Type Precision
 3. What happens when invalid values are passed in the API parameters?
 Invalid values will throw a 400 error with the message "Incorrect value passed for X''. Here, X could be query.precision, facet.precision, query.spellcorrect, query.relaxation. For example:
824
 1. What takes priority over what is passed through API vs what is currently enabled for a customer?
 API takes precedence over backend configuration i.e. whatever is currently enabled for you. For example, if Category precision is currently enabled for you in the backend, it will continue to work as-is. However, if you want to test out Product type precision, you can pass that in the API call and then API (Product Type) will override the existing setting enabled in the backend(Category Precision).
 2. What happens when a parameter is passed for a catalog that doesn't support an Algorithm control or Algorithm control mode?
 It will disregard the parameter i.e. the API call will not fail, but the value that is passed will not get applied. For example, Product Type Precision is not applicable to the French catalog. So, if you send a parameter in the API call as query.precision=product_type_precision for this French catalog, it will not be applied.
 3. Would the dashboard automatically sync and show the same results if Algorithm control parameters are passed directly through the front-end API?
 No, controlling the setting of features directly from the front-end API call doesn't automatically synchronize with Bloomreach's dashboard. Hence, the results might look different in both places. To ensure consistency, you would need to pass the same parameter that you are controlling on the front-end API in the "API Modifier" section under Setup -> brSM global configurations -> API modifier
What's next?
Learn to configure algorithm settings using


More than 200 Organizations Push Congress to Address Western Water Infrastructure
A national coalition of over 200 agricultural organizations and urban and rural water districts including the Western Agricultural Processors Association urged President-elect Joe Biden and congressional leadership today to address aging Western water infrastructure in any potential infrastructure or economic recovery package. The coalition includes organizations from 15 states that collectively represent $120 billion in agricultural production, nearly one-third of all agricultural production in the country, and tens of millions of urban and rural water users. In separate letters to President-elect Biden and congressional leaders, the coalition said existing Western water infrastructure is in desperate need of rehabilitation and improvement. Most of the federal water projects in the West were built more than 50 years ago and were not designed with the present and future population demands and climate conditions in mind. Without immediate attention, the coalition said, the Western water system will quickly prove inadequate to meet the needs of urban and rural users and the environment. The coalition encouraged the federal government to invest in a diversified water management portfolio that enhances water supply and quality for urban and environmental uses while keeping water flowing to Western farms. Specific recommendations include funding for:
- Water conservation.
- Water recycling, reuse and desalination projects.
- New water storage facilities, both surface and groundwater.
- Watershed management, fish passage and recovery, and habitat restoration.
- Federal financing mechanisms for water projects.
- Loans for local districts operating and maintaining federally owned irrigation projects.
- Water quality improvement for rural communities.
Beyond financial support, the coalition also called on the federal government to ensure the timely construction of water projects by streamlining the regulation and permitting processes. Association President/CEO Roger A. Isom stated the time is absolutely now! We have gone too many years without upgrades to our water infrastructure."
Click here for the letter to President-elect Joe Biden and click here for the letter to congressional leadership.
Welcome to WAPA
Governor Signs Ag Overtime Bill


text:
Definition of inexactly
adv. - In a manner not exact or precise; inaccurately. 2
The word "inexactly" uses 9 letters: A C E I L N T X Y.
No direct anagrams for inexactly found in this word list.
Words formed by adding one letter before or after inexactly (in bold), or to aceilntxy in any order:
g - exactingly
All words formed from inexactly by changing one letter
Browse words starting with inexactly by next letter


Can Traffic Cameras Be Used Against You? What You Need to Know
traffic camera in the urban
Running red lights is one of the top causes of accidents, accounting for thousands of deaths and tens of thousands of injuries each year in the U.S. Because this is such a serious problem, cities across the country have started to add more and more traffic cameras to promote safety and reduce accidents at intersections.
If you've been involved in a collision at an intersection, you might be wondering whether traffic camera footage can be used against you in a personal injury case, or if this footage may be useful to your claim. While violators caught on camera will often receive a ticket for the infraction, it is possible that more severe consequences could come if you're involved in a crash.
What Is the Purpose of Traffic Cameras?
Red light cameras and speed cameras are intended to help law enforcement monitor traffic and deter violations by recording video footage of activity around red lights and speed-restricted areas, respectively.
Q: How do traffic cameras work?
A: Most of the time, red-light cameras are only triggered when violators run red lights at monitored intersections. Speed cameras are only activated when drivers cruise past them while exceeding the legal speed limit. However, mistakes sometimes happen.
Q: Are Traffic Cameras Legal?
A: Not everywhere in the United States, but law enforcement agencies are permitted to operate both speed cameras and red light cameras in most locations throughout Alabama.
How Are Traffic Cameras Used Against You?
If you've received a traffic camera violation ticket, you're probably expecting some kind of a fine, but how else could traffic cameras be used against you?
Q: Do you have to pay for traffic camera tickets?
A: Generally speaking, yes. Traffic camera tickets are enforceable throughout Alabama, so unless you win a successful challenge to your ticket, you will have to pay the given fee.
Q: How much could my ticket cost?
A: This depends on your particular jurisdiction and the nature of your violation, but could be as much as $110 after administrative fees.
Traffic Camera Video in a Car Crash Case
So, what happens if you're in an accident involving a traffic violation that was recorded by a red light camera or speed camera? Again, the answer depends on your jurisdiction and the specific types of traffic light cams they use.
Some cameras just capture still images of license plates or seconds-long video of the events surrounding a traffic violation. Others give law enforcement agencies access to 24/7 footage and recordings of all activity.
Both types of recordings could be useful in your car crash case but may be challenging to obtain. An experienced Montgomery auto accident lawyer can help.
Disputing a Traffic Camera Ticket
If you believe you have received a traffic camera ticket in error, you may feel unsure of what to do. It's common to feel pressured to pay your fine to avoid trouble, but you do have the option to dispute your ticket.
With the help of a dedicated attorney, you may be able to fight back by demonstrating that:
 - You were not driving the vehicle in question when the traffic violation occurred.
 - The flagged behavior was not a traffic violation, only mistakenly labeled as such by automated systems or human reviewers.
 - The traffic cameras were not adequately marked or otherwise used properly.
Contact a Car Accident Lawyer Today
If you were involved in an accident at an intersection that may have been recorded by a traffic camera, contact the Alabama car accident lawyers at Stokes Stemle, LLC today. We provide free consultations to discuss your accident, and we'll collect no fees unless we win compensation for you.
Call us now or contact us online to learn more.


text:
Citrus is the most extensively produced tree fruit crop in the world. It is growing in a wide diversity of climatic and soil conditions. its importance for the world is demonstrated by its wide-scale cultivation under tropical and sub-tropical conditions. Also, it has a tremendous socio-economical and cultural impact on the whole society. The multifold nutritional and medicinal values make this type of fruit indispensable in several parts of the world. Citrus is primarily valued for the fruit, which is either eaten alone as fresh fruit, processed into juice.
Potassium plays an important role in improving the productivity and quality of citrus crop and the crop's need for potassium increases significantly during the stage of growth and development of fruits, so it must be added in sufficient quantities to ensure optimal growth of fruits. The most important roles also:
Phosphorus plays an important role in improving the productivity and quality of citrus crop. The most important roles of phosphorus for citrus crop: -
Calcium considered one of the most important effective nutrients on citrus crop. Some of the physiological roles of calcium in citrus are:
Potassium deficiency Symptoms appear on leaves in form of yellowing in general, in addition to burning of external leaves edges; moreover, potassium deficiency leads to reduction of yield and decreases fruit quality.
Trees suffer from phosphorus deficiency are small leaves with a dark green color and the leaves turn bronze and fall early. Phosphorus deficiency also leads to:
Calcium deficiency symptoms on citrus crop appear wrap the leaves in the form of a hook and the leaves are light green in addition , as calcium shortage it is leads to:-


text:
GeoIO lib is a simple geometry library that encapsulates the drawing of various geometrical entities (like lines, circle, arc, text etc), storing them in a list with support for undo/redo operations. There is a sample application called Cad2D attached which exposes some of the basic drawing and serilaization functionality of the GeoIO library.
Couple of developers/programmers have come across a situation to develop simple application to draw 2-Dimensional geometry entities. However they are blocked due to many reasons like lack of time, unwilling to explore OpenGL, develop the module from base etc. The MFC set of classes (
DeviceContext) gives some good functionality to draw simple entities like lines, circles, rectangles etc, but a first timer may take sometime to learn, understand and experiment it. GeoIO library has encapsulated the complete functionality of MFC into set of core geometry classes. All that you have to do is add this module into your project and start with it. The module also supports drawing, dragging operation OnMouseMove handler and serialization.
Using the code
GeoIO is simple MFC DLL. Add this as dynamic-linked or static-linked to your project. Initially the usage of this module might look difficult, but once you read the below fundamental concepts you should sail through easily. Open the sample project Cad2D (SDI MFC application) which uses GeoIO to draw 2D basic geometry objects. Please explore this sample project to learn and understand the usage of GeoIO.
NOTE: The project has.vcproj and.vcxproj files so it should open in VS2010 and earlier versions of Visual Studio.
Geometry classes in GeoIO:
CPrimitive - the principle base class for all the below mentioned classes.
CGeoArc - class to draw and serialize an arc
CGeoCircle - class to draw and serialize a circle
CGeoLine - class to draw and serialize a line
CGeoPolybezier - class to draw and serialize a polybezier
- class to draw and serialize a polygon
CGeoRectangle - class to draw and serialize a rectangle
CGeoText - class to draw and serialize a string
Note: Some drawing logic have been inspired from various online articles.
CEntityList - class to hold objects of
CLayerList - class to hold objects of
CLayer - class stores an instance of
CLayer object is identified by a layer ID.
So, in your application follow the below procedure:
CLayer *pLayer = new CLayer(); CPrimitive *pEntity = new CGeoLine(); pEntity->m_StPnt = CPoint(10, 10);
pEntity->m_EndPoint = CPoint(100, 100); pEntity->m_clr = RGB(255, 255, 255); pLayer->AddEntityToLayer(pEntity);
OnDraw(CDC *pDC) method of your window class, call the
Also note that in the example above I have hard-coded the
pEntity->m_EndPnt to some random
CPoint values. Ideally this should be done in the
OnLButtonDown handler which gives you the
CPoint data as a parameter.
Concept of layers
In your application, you can create 'N' number layers and maintain them in the
CLayerList class. In the
OnDraw() method of your window class, you can select which
CLayer to be drawn. If you wish to draw all the layers then iterate each layer in the
CLayerList and then call
DrawLayer() method of the
Initial upload: 14 July


an image from it.
There are several video conversion tools available online that can help you convert the video file to a compatible format. These tools allow you to select the desired output format and adjust the video quality if needed.
Once you have converted the video file to a compatible format, retry generating the image from the video using AVFoundation. If the compatibility issue was the cause of the AVFoundationErrorDomain Error Code 11800, the error should no longer occur.
It is important to note that different versions of AVFoundation may support different video formats, so it is recommended to refer to the official Apple documentation or the developer resources for the specific version of AVFoundation you are using to ensure compatibility.
In addition to checking video format compatibility, it is also a good practice to verify the video encoding settings such as bitrate, codec, resolution, and frame rate. These settings should be aligned with the requirements of the AVFoundation framework to avoid any compatibility issues.
By ensuring video format compatibility, you can prevent the AVFoundationErrorDomain Error Code 11800 from occurring and successfully generate images from videos using AVFoundation.
Free Up Device Storage Space
One of the common causes of AVFoundationErrorDomain Error Code 11800 is insufficient device storage. If your device does not have enough storage space, it may encounter errors when generating an image from a video using AVFoundation.
In order to fix this issue, you need to free up device storage space. Here are some steps you can take:
 - Delete unused apps: Go through your device and uninstall any apps that you no longer use or need. This can help free up a significant amount of storage space.
 - Delete unnecessary files: Look for any files, such as photos, videos, or documents, that you no longer need and delete them. You can use the built-in file management app or a third-party app to easily identify and delete these files.
 - Clear app cache: Some apps store temporary files and data in the cache, which can take up valuable storage space. Go to the settings of each app and clear its cache to free up storage.
 - Move files to cloud storage: If you have files that you don't need immediate access to, consider moving them to a cloud storage service like iCloud, Google Drive, or Dropbox. This can help free up local storage space while still allowing you to access your files when needed.
 - Offload unused apps: If you don't want to completely delete unused apps, you can offload them. This removes the app from your device but keeps its data and documents in case you want to use it again in the future.
 - Manage photo and video storage: Photos and videos can quickly take up a large amount of storage space. Use the built-in photo and video management features on your device to optimize their storage. This may involve storing them at lower resolutions or uploading them to a cloud storage service.
 - Restart your device: Sometimes, a simple restart can help free up temporary storage and resolve any issues that may be causing the AVFoundationErrorDomain Error Code 11800.
By following these steps and freeing up device storage space, you should be able to fix the AVFoundationErrorDomain Error Code 11800 and generate images from videos without any issues.
Like this post? Please share to your friends:
Error codes and solutions to them
Leave a Reply
;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!:


Manduca Sexta Lab Report
967 Words 4 Pages
Metabolism is a complex process in organisms that convert the food into energy for organism to function properly. Metabolic rate is typically defined as the amount of energy the organism is currently using to maintain the activity (Perkin, 2015). Since metabolism is a key in sustaining the organisms' life, we decided to investigate the experiment about metabolic rate caterpillar, Manduca sexta. There are many techniques used to measuring the metabolic rate, but there are only best method that can be done in laboratory: "quantification of heat production and quantification of gas consumption" (Perkin, 2015).Our investigation is about measuring the oxygen consumption of the caterpillar in the trial duration when it was placed in sealed chamber along with chemical absorbing CO2 produced. Metabolism are mostly varies in …show more content…
Since we need to find that whether there is a statistically correlation between the body mass and metabolic rate of Manduca sexta, Regression test was used to analyze our data. The independent variable is the metabolic rate and the dependent variable is body mass.
3. Result The body mass of caterpillar (Manduca sexta) varied from 0.25g to 1.55g. The measured temperature inside of the chamber varied in different caterpillar and ranged from 22.0°C to 23.1°C. The volume of O2 consumption in 15 min ranged from 0.0mL to 0.60mL. The metabolic rate value (mL/min) was 0 to 0.04. From the Regression test, the P value is 0.079, coefficient value is 0.019 and 95% confidence interval value is from -0.0033 to 0.0405. It can be seen the correlation between body mass of Manduca sexta and its metabolic rate based on the graph (Fig.1) Figure 1: The correlation between body mass of Manduca sexta and its metabolic rate 4.
Related Documents


Queen's Counsel
From Wikipedia, the free encyclopedia
Jump to: navigation, search
Queen's Counsel (postnominal QC), during the reign of a male sovereign known as King's Counsel (KC), are senior lawyers in various Commonwealth countries.
They are appointed by letters patent to be one of "Her Majesty's Counsel learned in the law". They are not a separate type of lawyer. They are more than long serving lawyers, because their status is given by the Crown and recognised by the courts.
Queen's Counsel have the privilege of sitting within the Bar of court, and wear silk gowns of a special design (hence the informal title Silks). The special robes are the reason why becoming a QC is often called "taking silk".
In order to "take silk" a lawyer usually has to serve as a barrister or a Scottish advocate for at least 10 years. Recently solicitors have also been appointed Queen's Counsel.
A QC's status means they generally charge higher fees than ordinary barristers, and always have another barrister as an assistant. This assistant is called a "junior" even if the junior has been a lawyer longer than the "silk".


text:
Museum of Natural History's Written In Bone Exhibition
Left Image: 17th century human skeletal remains from an archaeological site near Annapolis MD.
Right Image: Reassembly of the bones took place in scanning studio, part of a forensic reconstruction of the individual for a museum display. Kari Bruwelheide,
National Museum of Natural History; and Jane Cox, Anne Arundel County Archaeologist did the reassembly. This was then scanned by Vicky Karas and Mel Wachowiak.
Left Image: Screenshot of virtual reconstruction of skeletal remains.
Right Image: Partial assembly of replica of 17th century human skeletal remains from an archaeological site created from scan data by Chris Hollshwander and Caroline
Thome of Smithsonian Office of Exhibit Central.
CNC milling of smaller scale replica overseen by OEC Modelmaker Chris Hollshwander.


text:
Over 14 tons of glass collected during Recycle Glass
The Glass Packaging Institute's (GPI) 2009 Recycle Glass
Week proved a success, with glass container manufacturers,
including Anchor Glass, O-I, Rocky Mountain Bottle Company
(RMBC), and Saint-Gobain Containers, Inc., collecting
over 14 tons of glass bottles, and counting, for recycling,
through events at their plants and in local communities.
The energy saved from the recycled glass collected is
equivalent to planting 128 trees.
In all, over 50 educational activities and public events
in 22 states were held during the week, building awareness
for glass bottle recycling across the United States.
Two events, in Colorado and Indiana, also lead to permanent
collection locations for glass container recycling.
Doubling the United States glass container recycling
rate (28 percent in 2007) would allow manufacturers to
use 50 percent recycled glass to make new glass containers,
saving enough energy to power 21,978 homes for one year
and removing 181,550 tons of waste from landfills every
During Recycle Glass Week, GPI also recognized seven
'Friends of Glass,' honoring those making significant
and innovative efforts to promote or participate in glass


text:
To store the audit log in an additional third-party storage, to send a notification, or just monitor the "logged" events, implement an IAuditLogger with its single Log method and register it in the container (a name is required):
For more details on implementation, refer to the ElasticsearchAuditLogger GitHub project.
NOTE: The Log method is called synchronously during event handling, which means that the time your logging takes is added to the overall operation time (for example, to publishing an item). Plan carefully the performance implications and if needed, introduce some asynchronicity in your code. Alternatively, introduce an out-of-process message queue or a logging agent to ensure the quick completion of the operation.
To implement audit for your custom events or for Sitefinity's events not implemented out-of-the-box, either construct an AuditInfo instance and the Log method of all registered loggers:
Alternatively, register an event handler along with the corresponding converters as demonstrated by the following code:
To augment the logged event information, for instance loading additional information, implement an IAuditInfoProcessor with its single Process method and register it the container (the name is required).
Following is an example code that adds the display name of the current user (first name and last name) to each log entry:
Back To Top


I've a table (locations) which contains records as given below:
id | lat | lng | radius_in_km
1 | -18.17943 | 83.968051 | 5
2 | 44.5796 | 7.069637 | 10
Now, I've got a point (lat, lng) from Google and I need to fetch the records from locations table if the given lat, lng falls into radius of those rows. Please notice, the radius is dynamic/different for each row so I need to match the records according to their radius with the given point.
I've searched the stackoverflow network but couldn't find anything that works for me, any hints would be fine even not the code.
Keeping lat long like that isn't spatial. You need to make a point
I would store the result of the above on the row, rather than individual lat/long cords. Regardless of what you store on the row, that's what you have to work with. Not storing that on the row will just be slower, as you'll have to calculate it every time.
Next what you want is the Bounding Box test. In MySQL they're designated with an MBR prefix.
FROM table
WHERE ST_Contains(
 ST_Buffer( Point(lng,lat), DISTANCE_IN_DEGREES ),
 Point(google.long, google.lat)
You'll have to calculate DISTANCE_IN_DEGREES yourself. MySQL doesn't have a geography type, so you can't just use a fixed distance like meters, miles, or feet. You have to do the math yourself. This is a lot of work in itself.
ST_Contains doesn't use an index. For that you'll need MBRContains. Or you could just use PostgreSQL, for that it'll look like this,
FROM table
 ST_Buffer( ST_MakePoint(lng,lat)::geography, DISTANCE_IN_METERS ),
 ST_MakePoint(google.long, google.lat)::geography
Not just is that shorter, but from the docs
This function call will automatically include a bounding box comparison that will make use of any indexes that are available on the geometries.
So you don't have to use two functions like you would in MySQL MBRcontains (bounding box w/ index), and ST_Contains.
 - Thanks for your answer but I'm still confused. If I change the lat, lng to point and instead of storing radius as km, if I store the distance in degrees then which query should I use? – The Alpha Aug 20 '17 at 19:03
 - _USER_ both, however if you take it one step further and (1) store them as a point, (2) store the ST_Buffer(pt, radius) as a geom, and index the geom then the operation on MBRContains will use the index, potentially saving costly calculations with ST_Contains – Evan Carroll Aug 20 '17 at 20:37
Your Answer


Export (0) Print
Expand All
Column Mappings and Transformations
SQL Server 2000
Column Mappings and Transformations
Use this dialog box to specify the mappings between the source and destination columns and to specify the transformations the data goes through, if any, as it is moved to the destination. You also can change the data type of the data if a valid data conversion is applicable.
Column Mappings Tab
Use this tab to specify how to treat the destination table and to specify column attributes on any newly created table.
Options
Create destination table
Create the destination table before copying the source data. This is the default option if the destination table you specified does not exist. If this option is selected and the destination table already exists, an error occurs, unless you select the Drop and re-create destination table check box.
Edit SQL
Customize the Transact-SQL CREATE TABLE statements used to create the destination table.
Delete rows in destination table
Delete all rows in the destination table before copying the source data. This option is only available if the destination table already exists. Existing indexes and constraints on the destination table are not affected by this option.
Append rows to destination table
Insert source data into the destination table. This option is available only if the table already exists. Existing data, indexes, and constraints on the destination table are not affected. However, rows are not necessarily appended to the end of the destination table. You can determine where rows will be inserted only by having a clustered index on the destination table.
Drop and re-create destination table
Drop the destination table and re-create it before moving data into it. All existing data in the destination table and any indexes are destroyed.
Enable identity insert
Allow explicit values to be inserted into the identity column of a table (Microsoft® SQL Server™ only). This option is only available if an identity column is detected. An identity column is a column that has been defined as having a data type of bigint, decimal, integer, numeric, smallint, or tinyint, where the Identity property for the column is set to yes.
Mappings table
Edit the cells in the table. The table does not list the order in which the destination columns will appear, but rather lists each destination column alongside each source column to which it maps.
For each column in the Mappings table, you can set the following properties:
Source
Choose the column name in the source table to copy to the destination. Click <ignore> on the source column name to set the destination column to NULL for a new table. If the table already exists, the data will be NULL if allowed, or set to its default value if one was defined. If the destination is defined as NOT NULL, clicking <ignore> in the source column results in an error when the package is executed if no default value is specified for the destination column.
If you copy a source column defined as an identity column, the data will not be copied unless the Enable identity insert check box is selected.
If you copy a source column defined with user-defined data types to a new table, the data type of the destination column is the system-defined data type that corresponds to the user-defined data type.
You may change the following properties only if a new destination table is being created.
Destination
Choose the column name in the destination table to receive the source data. Click <ignore> to prevent the source column from being created in the destination table when creating a new table. If you want to remove a column from an existing table, click <ignore> in the destination column, but also select the Drop and re-create destination table check box in this dialog box. This will re-create the table with the columns specified. Existing data and indexes in the table will be lost.
timestamp columns cannot be copied by the Data Transformation Services (DTS) Import/Export Wizard. If the destination column is a timestamp column, the value in that field will be a new timestamp indicating when the row was inserted, not a copy of the timestamp data from the source table.
Type
Select a data type for the destination column. The default setting matches the data type of the destination column to the source.
Note Invalid data conversions can be specified without causing an error, as the default transformation setting allows all possible conversions. For example, converting an int data type to a tinyint data type will result in data truncation, but the conversion will proceed.
Nullable
Specify if destination can allow null values.
Size
Specify the length of the Destination column, in units corresponding to the data type. The value is only applicable for the char, varchar, nchar, nvarchar, binary, and varbinary data types. Specifying a size smaller than the length of the source can result in data truncation.
Precision
Enter the maximum number of decimal digits that can be stored to the left and to the right of the decimal point. This option applies only to decimal and numeric data types.
Scale
Enter the maximum number of decimal digits that are stored to the right of the decimal point. The number must be less than or equal to the number in the Precision column. This option applies only to decimal and numeric data types.
Transformations tab
Use this tab to specify whether unique transformation code must be written. The column mappings set on the Column Mappings tab are reflected in code shown in the text area.
Options
Copy the source column directly to the destination columns
Copy the source column to the destination tables without changing the data or the source and destination mappings.
Transform information as it is copied to the destination
Edit the script in the text area to customize the columns before copying them from the source to the destination. For complex transformations, consider using DTS Designer, which offers support for Microsoft ActiveX® scripting.
Language
Select a scripting language. The default language is Microsoft Visual Basic® Scripting Edition (VBScript). Available languages are VBScript or JScript.
Browse
Display the Select File dialog box, where you can select a file that contains previously written transformation code, if the code already has been written and saved to a .txt, .vbs or .bas file. When a file is selected, the text from the file is copied into the Query statement text area.
See Also
ActiveX Script Transformation
Using ActiveX Scripts in DTS
Show:
© 2015 Microsoft


text:
In email communication, people often use "can you do X" instead of "please do X". Is this a more polite form, or is this just an idiom which means exactly the same?
If I use "dig this hole" as an abstract example, I can write this in several forms:
- Can you dig this hole?
- Can you dig this hole.
- Can you please dig this hole.
- Please dig this hole.
Do these forms have some different but measurable level of politeness? I feel that (2) is a bit rude, but may be just careless spelling; is my feeling justified?
If I want to ask someone to "dig this hole", which is the most polite way to do that?
I am interested mostly in email communication, because this is the only way I use English now. But maybe considering spoken language can help.


text:
EM6100 - External Memory Module
The External Memory Module is part of the DVCS6100 system and is provided with standard installation packages for an aircraft. The module is similar to a memory stick or USB storage device. It provides control of REU6100 REU through a software configurable file. An avionics or maintenance technician can program the aircraft audio system configuration on a laptop or desktop computer and store it to the memory module, which can be taken to the aircraft and plugged-in to the REU so the audio system configuration can be downloaded to the REU.
Manuals and specifications
Back to Components Overview


text:
- Perceptions of Coercion, Discrimination and Other Negative Experiences in Postpartum Contraceptive Counseling for Low-income Minority Women
- Journal of Health Care for the Poor and Underserved
- Johns Hopkins University Press
- Volume 22, Number 4, November 2011
- pp. _PHONE_
- View Citation
Background. Using in-depth qualitative methods, we investigated negative contraception counseling experiences, including those felt to be coercive or discriminatory, in a population of postpartum urban minority women. Methods. Brief surveys and semi-structured interviews were conducted with 30 consenting postpartum women who had received care at a Medicaid-funded obstetrics clinic. In-person one-on-one interviews were then reviewed for themes using an iterative process of qualitative analysis. Results. In this sample of African American (63%) and Hispanic (37%) women (median age 26), 73% had unplanned pregnancies. Features of negative counseling experiences included having insufficient, non-physician-directed and impersonal counseling. Most women had experienced episodes of poor communication with providers; 10 described feeling coerced or perceiving racially-based discrimination in counseling. Conclusions. Negative experiences with contraceptive counseling may affect contraception utilization. Contraceptive education should respect each individual's autonomy, culture, and values.


text:
Why Choose to Cycle in a Middle-Income Country?
Research on the adoption of the bicycle as a means of transport has been booming in high-income countries. However, little is known about bicycle adoption in lower-income countries where air pollution is high and cycling infrastructure is poor. Understanding the drivers of cycling adoption in developing economies can increase the efficiency of transport policies while reducing local air pollution, improving health, and cutting greenhouse gas emissions. The objective of this study is to identify the factors affecting cycling uptake in a low-income country using the city of Bishkek in Kyrgyzstan as a case study. The analysis is based on the Theory of Planned Behavior, a questionnaire-based survey of 900 respondents, factor analysis, and a logit model. In contrast to studies carried out in developed countries, this study finds that students are less likely to adopt cycling than other population groups. Other findings suggest that support for public transport, a desire for regular exercise and perceptions of the environmental benefits of cycling increase the probability of the use of cycling as a mode of transport in a low-income country. The paper also identifies positive and negative perceptions of cycling among cyclists and non-cyclists.