User:WikiSysop/Sandbox/Badquery

Query Problems

Character set conversion problems

Incorrect

Incorrect character encoding: Aeroméxic Flight 498

Correct

Correct character encoding: Aeroméxico Flight 498

Ask query syntax

The query used Fatalities (deaths) as the search term.

Original Query:

query

[[Fatalities::>0]][[Fatalities::<1001]]

result

	Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.	Cause	Aircraft	Airline	Airport involved	Miles Traveled	State of incident	Survivors	Deaths
Aloha Airlines Flight 243	28 April 1988	Mechanical (decompression)	737	Aloha Airlines	OGG	100	Hawaii	94	1

Good Query:

query

[[Fatalities::>0]]

result

	Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.	Cause	Aircraft	Airline	Airport involved	Miles Traveled	State of incident	Survivors	Deaths
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Air Canada Flight 797	2 June 1983	Mechanical (fire)	DC-9	Air Canada	CVG	814	Ohio	23	23
Air Florida Flight 90	13 January 1982	Weather (icing)	737	Air Florida	DCA	1	District of Columbia	5	74
Air Midwest Flight 5481	8 January 2003	Mechanical (elevators)	1900	Air Midwest	CLT	1	North Carolina	0	21
Alaska Airlines Flight 261	31 January 2000	Mechanical (jackscrews)	MD83	Alaska Airlines	SFO	1320	California	0	88
Allegheny Airlines Flight 853	9 September 1969	Air traffic	DC-9	Allegheny Airlines	IND	90	Indiana	0	82
Aloha Airlines Flight 243	28 April 1988	Mechanical (decompression)	737	Aloha Airlines	OGG	100	Hawaii	94	1
Continental Flight 3407	12 February 2009	Weather (icing)	Dash 8	Continental	BUF	280	New York	0	50

Page not shown as a link

The page/article name table doesn't contain a clickable link back to that page. The first line in the return result is the name of the first column field which should also be, in this case, the page name.

query

[[Fatalities::>0]][[Fatalities::<1001]]

result

	Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.	Cause	Aircraft	Airline	Airport involved	Miles Traveled	State of incident	Survivors	Deaths
Aloha Airlines Flight 243	28 April 1988	Mechanical (decompression)	737	Aloha Airlines	OGG	100	Hawaii	94	1

Good Query:

query

[[Fatalities::>0]]

result

	Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.	Cause	Aircraft	Airline	Airport involved	Miles Traveled	State of incident	Survivors	Deaths
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Air Canada Flight 797	2 June 1983	Mechanical (fire)	DC-9	Air Canada	CVG	814	Ohio	23	23
Air Florida Flight 90	13 January 1982	Weather (icing)	737	Air Florida	DCA	1	District of Columbia	5	74
Air Midwest Flight 5481	8 January 2003	Mechanical (elevators)	1900	Air Midwest	CLT	1	North Carolina	0	21
Alaska Airlines Flight 261	31 January 2000	Mechanical (jackscrews)	MD83	Alaska Airlines	SFO	1320	California	0	88
Allegheny Airlines Flight 853	9 September 1969	Air traffic	DC-9	Allegheny Airlines	IND	90	Indiana	0	82
Aloha Airlines Flight 243	28 April 1988	Mechanical (decompression)	737	Aloha Airlines	OGG	100	Hawaii	94	1
Continental Flight 3407	12 February 2009	Weather (icing)	Dash 8	Continental	BUF	280	New York	0	50

Correct category

Best choice (category set to : [[Category:Accidents and incidents on commercial airliners in the United States]] Query set to : [[Category:Accidents and incidents on commercial airliners in the United States]][[Fatalities::>0]]

	Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.	Cause	Aircraft	Airline	Airport involved	Miles Traveled	State of incident	Survivors	Deaths
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Air Canada Flight 797	2 June 1983	Mechanical (fire)	DC-9	Air Canada	CVG	814	Ohio	23	23
Air Florida Flight 90	13 January 1982	Weather (icing)	737	Air Florida	DCA	1	District of Columbia	5	74
Air Midwest Flight 5481	8 January 2003	Mechanical (elevators)	1900	Air Midwest	CLT	1	North Carolina	0	21
Alaska Airlines Flight 261	31 January 2000	Mechanical (jackscrews)	MD83	Alaska Airlines	SFO	1320	California	0	88
Allegheny Airlines Flight 853	9 September 1969	Air traffic	DC-9	Allegheny Airlines	IND	90	Indiana	0	82
Aloha Airlines Flight 243	28 April 1988	Mechanical (decompression)	737	Aloha Airlines	OGG	100	Hawaii	94	1
Continental Flight 3407	12 February 2009	Weather (icing)	Dash 8	Continental	BUF	280	New York	0	50

Linkable result for page in the first result column

Airline/Flight	Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.	Cause	Aircraft	Airline	Airport involved	Miles Traveled	State of incident	Survivors	Deaths
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Aeroméxico Flight 498	31 August 1986	Air traffic	DC-9	Aeroméxico	LAX	135	California	0	64
Air Canada Flight 797	2 June 1983	Mechanical (fire)	DC-9	Air Canada	CVG	814	Ohio	23	23
Air Florida Flight 90	13 January 1982	Weather (icing)	737	Air Florida	DCA	1	District of Columbia	5	74
Air Midwest Flight 5481	8 January 2003	Mechanical (elevators)	1900	Air Midwest	CLT	1	North Carolina	0	21
Alaska Airlines Flight 261	31 January 2000	Mechanical (jackscrews)	MD83	Alaska Airlines	SFO	1320	California	0	88
Allegheny Airlines Flight 853	9 September 1969	Air traffic	DC-9	Allegheny Airlines	IND	90	Indiana	0	82
Aloha Airlines Flight 243	28 April 1988	Mechanical (decompression)	737	Aloha Airlines	OGG	100	Hawaii	94	1
Continental Flight 3407	12 February 2009	Weather (icing)	Dash 8	Continental	BUF	280	New York	0	50

Groundwater remediation is the process by which water pollution is extracted and filtered. Groundwater is a readily available source of drinking water. At least one half of the population of the United States depends upon groundwater as a source of drinking water. Groundwater is also used by farms to irrigate crops and by industries to produce everyday goods. Most groundwater is clean, but groundwater can become polluted, or contaminated as a result of human activities. The many and diverse activities of man produce innumerable waste materials and by-products; these are often deposited or stored on land surfaces where by percolation they eventually get carried downward contaminating the underlying groundwater and therefore jeopardizing the natural quality of it. As a result, contaminated groundwater becomes unsuitable for use. Using contaminated ground water causes hazards to public health through poisoning or the spread of disease. Contaminants found in ground water cover the entire range of physical, inorganic chemical, organic chemical, bacteriological, and radioactive parameters. Pollutants and contaminants can be removed from ground water by applying various techniques thereby making it safe for use.

Techniques

Ground water remediation techniques span biological, chemical, and physical treatment technologies. Most ground water treatment techniques utilize a combination of technologies. Some of the biological treatment techniques include bioaugmentation, bioventing, biosparging, bioslurping, and phytoremediation. Some chemical treatment techniques include ozone and oxygen gas injection, chemical precipitation, membrane separation, ion exchange, carbon absorption, aqueous chemical oxidation, and surfactant enhanced recovery. Physical treatment techniques include, but not limited to, pump and treat, air sparging, and dual phase extraction.

Biological treatment technologies

Bioaugmentation

If a treatability study shows no degradation (or an extended lab period before significant degradation is achieved) in contamination contained in the groundwater, then inoculation with strains known to be capable of degrading the contaminants may be helpful. This process increases the reactive enzyme concentration within the bioremediation system and subsequently may increase contaminant degradation rates over the nonaugmented rates, at least initially after inoculation.

Bioventing

Bioventing is an in situ remediation technology that uses microorganisms to biodegrade organic constituents adsorbed in the groundwater. Bioventing enhances the activity of indigenous bacteria and simulates the natural in situ biodegradation of hydrocarbons by inducing air or oxygen flow into the unsaturated zone and, if necessary, by adding nutrients. During bioventing, oxygen may be supplied through direct air injection into residual contamination in soil. Bioventing primarily assists in the degradation of adsorbed fuel residuals, but also assists in the degradation of volatile organic compounds (VOCs) as vapors move slowly through biologically active soil.

Biosparging

Biosparging is an in situ remediation technology that uses indigenous microorganisms to biodegrade organic constituents in the saturated zone. In biosparging, air (or oxygen) and nutrients (if needed) are injected into the saturated zone to increase the biological activity of the indigenous microorganisms. Biosparging can be used to reduce concentrations of petroleum constituents that are dissolved in groundwater, adsorbed to soil below the water table, and within the capillary fringe.

Bioslurping

Bioslurping combines elements of bioventing and vacuum-enhanced pumping of free-product to recover free-product from the groundwater and soil, and to bioremediate soils. The bioslurper system uses a “slurp” tube that extends into the free-product layer. Much like a straw in a glass draws liquid, the pump draws liquid (including free-product) and soil gas up the tube in the same process stream. Pumping lifts light non-aqueous phase liquids (LNAPLs), such as oil, off the top of the water table and from the capillary fringe (i.e., an area just above the saturated zone, where water is held in place by capillary forces). The LNAPL is brought to the surface, where it is separated from water and air. The biological processes in the term “bioslurping” refer to aerobic biological degradation of the hydrocarbons when air is introduced into the unsaturated zone.

Phytoremediation

In the phytoremediation process certain plants and trees are planted, whose roots absorb contaminants from ground water over time, and are harvested and destroyed. This process can be carried out in areas where the roots can tap the ground water. Few examples of plants that are used in this process are Chinese Ladder fern Pteris vittata, also known as the brake fern, is a highly efficient accumulator of arsenic. Genetically altered cottonwood trees are good absorbers of mercury and transgenic Indian mustard plants soak up selenium well.

Chemical treatment technologies

Chemical precipitation

Chemical precipitation is commonly used in wastewater treatment to remove hardness and heavy metals. In general, the process involves addition of agent to an aqueous waste stream in a stirred reaction vessel, either batchwise or with steady flow. Most metals can be converted to insoluble compounds by chemical reactions between the agent and the dissolved metal ions. The insoluble compounds (precipitates) are removed by settling and/or filtering.

Ion exchange

Ion exchange for ground water remediation is virtually always carried out by passing the water downward under pressure through a fixed bed of granular medium (either cation exchange media and anion exchange media) or spherical beads. Cations are displaced by certain cations from the solutions and ions are displaced by certain anions from the solution. Ion exchange media most often used for remediation are zeolites (both natural and synthetic) and synthetic resins.

Carbon absorption

The most common activated carbon used for remediation is derived from bituminous coal. Activated carbon absorbs volatile organic compounds from ground water by chemically binding them to the carbon atoms.

Chemical oxidation

In this process chemical oxidants are delivered in the subsurface to destroy (converted to water and carbon dioxide or to nontoxic substances) the organics molecules. The oxidants are introduced as either liquids or gasses. Oxidants include air or oxygen, ozone, and certain liquid chemicals such as hydrogen peroxide, permanganate and persulfate. Ozone and oxygen gas can be generated on site from air and electricity and directly injected into soil and groundwater contamination. The process has the potential to oxidize and/or enhance naturally occurring aerobic degradation.

Surfactant enhanced recovery

Surfactant enhanced recovery increases the mobility and solubility of the contaminants absorbed to the saturated soil matrix. Surfactant-enhanced recovery injects surfactants (surface-active agents that are primary ingredient in soap and detergent) into contaminated groundwater. A typical system uses an extraction pump to remove groundwater downstream from the injection point. The extracted groundwater is treated aboveground to separate the injected surfactants from the contaminants and groundwater. Once the surfactants have separated from the groundwater they are re-used. The surfactants used are non-toxic, food-grade, and biodegradable. Surfactant enhanced recovery is used most often when the groundwater is contaminated by dense nonaqueous phase liquids (DNAPLs). These dense compounds, such as trichloroethylene (TCE), sink in groundwater because they have a higher density than water. They then act as a continuous source for contaminant plumes that can stretch for miles within an aquifer. These compounds may biodegrade very slowly. They are commonly found in the vicinity of the original spill or leak where capillary forces have trapped them.

Physical treatment technologies

Pump and treat

Pump and treat is one of the most widely used ground water remediation technologies. In this process ground water is pumped to the surface and is coupled with either biological or chemical treatments to remove the impurities.

Air sparging

Air sparging is the process of blowing air directly into the ground water. As the bubbles rise, the contaminants are removed from the groundwater by physical contact with the air (i.e., stripping) and are carried up into the unsaturated zone (i.e., soil). As the contaminants move into the soil, a soil vapor extraction system is usually used to remove vapors.

Dual phase extraction

Dual-phase extraction (DPE), also known as multi-phase extraction, is a technology that uses a high-vacuum system to remove both contaminated groundwater and soil vapor. In DPE systems a high-vacuum extraction well is installed with its screened section in the zone of contaminated soils and groundwater. Fluid/vapor extraction systems depress the water table and water flows faster to the extraction well. DPE removes contaminants from above and below the water table. As the water table around the well is lowered from pumping, unsaturated soil is exposed. This area, called the capillary fringe, is often highly contaminated, as it holds undissolved chemicals, chemicals that are lighter than water, and vapors that have escaped from the dissolved groundwater below. Contaminants in the newly exposed zone can be removed by vapor extraction. Once above ground, the extracted vapors and liquid-phase organics and groundwater are separated and treated. Use of dual-phase extraction with these technologies can shorten the cleanup time at a site, because the capillary fringe is often the most contaminated area.

Monitoring-Well Oil Skimming

Monitoring-wells are often drilled for the purpose of collecting ground water samples for analysis. These wells, which are usually six inches or fewer in diameter, can also be used to remove hydrocarbons from the contaminant plume within a groundwater aquifer by using a belt style oil skimmer. Belt oil skimmers, which are simple in design, are commonly used to remove oil and other floating hydrocarbon contaminants from industrial water systems.

A monitoring-well oil skimmer remediates various oils, ranging from light fuel oils such as petrol, light diesel or kerosene to heavy products such as No. 6 oil, creosote and coal tar. It consists of a continuously moving belt that runs on a pulley system driven by an electric motor. The belt material has a strong affinity for hydrocarbon liquids and for shedding water. The belt, which can have a vertical drop of 100+ feet, is lowered into the monitoring well past the LNAPL/water interface. As the belt moves through this interface it picks up liquid hydrocarbon contaminant, which is removed and collected at ground level as the belt passes through a wiper mechanism. To the extent that DNAPL hydrocarbons settle at the bottom of a monitoring well, and the lower pulley of the belt skimmer reaches them, these contaminants can also be removed by a monitoring-well oil skimmer.

Typically, belt skimmers remove very little water with the contaminant, so simple weir type separators can be used to collect any remaining hydrocarbon liquid, which often makes the water suitable for its return to the aquifer. Because the small electric motor uses little electricity, it can be powered from solar panels or a wind turbine, making the system self-sufficient and eliminating the cost of running electricity to a remote location.