Testwiki:WikiProject Bulgaria/Springs

Mineral water deposits and water wells in Bulgaria

This page describes the data regarding mineral water deposits and water wells in Template:Q. Bulgaria is known for its rich natural resources, including numerous mineral water deposits and water wells that serve various purposes, from drinking water supply to therapeutic uses. In this project, each mineral spring is associated with one or more water wells.

The links below provide a table format of the data that has been used.

Raw data links:

• raw data of mineral springs and water wells gsheet
• raw data of geographics coordinates of water wells gsheet

Cleaned and processed data:

• mineral springs and water wells gsheet
• geographics coordinates of water wells gsheet

Data model

This describes the data model

Mineral springs

Describe how mineral water springs are modeled.

Template:Claim

Template:Claim

Query for all mineral water springs in Bulgaria ordered by their discharge:

Water wells

Describe how water wells are modeled.

Template:Claim

Template:Claim

Query for all water wells in Bulgaria ordered by their temperature:

Connection between mineral water springs and water wells

Describe how mineral water springs and water wells are connected in the model.

Each mineral water deposits can have one or more water wells. For representation of this feature of the deposits the property Template:P is used.

Template:Claim

Template:Claim

Template:Claim

Query that presents all mineral water springs in Bulgaria and which are their water wells that they has part in:

Each water well can be part of only one mineral water spring. For the inverse connection is used the inverse property Template:P.

Template:Claim

Query that presents all water wells in Bulgaria and which are their mineral water springs that they are part of:

Key properties

Mineral springs

Used properties to describe the mineral water deposits:

Property	Comment
Template:P	type of springs (e.g. Template:Q)
Template:P	volume rate of water flow which is transported through a given cross-sectional area
Template:P	the country in which the mineral spring takes place
Template:P	administrative scope of the mineral springs
Template:P	the values of this property are part of this subject (Сондаж №Р-2хг е част от Находище Обединение)

Water wells

Used properties to describe the water wells:

Property	Comment
Template:P	instance of Template:Q (excavation or structure created in the ground to access groundwater)
Template:P	object of which the subject is a part, inverse property of "has part"
Template:P	year of the well construction
Template:P	volume rate of water flow which is transported through a given cross-sectional area
Template:P	the country in which the water well takes place
Template:P	administrative scope of the water well
Template:P	geocoordinates of the water well
Template:P	temperature of the water well
Template:P	depth of the water well

Locations

For coordinates in format 42°08'10" (42deg, 08min, 10sec) to be transformed in decimal format: 42.1361 is used the formula: $\text{degrees}+\frac{\text{minutes}}{60}+\frac{\text{seconds}}{3600}$

GREL statement used for the calculation:

with(value.replace("°", " ").replace("'", " ").replace("\"", " ").split(" "), parts, toNumber(parts[0]) + toNumber(parts[1]) / 60.0 + toNumber(parts[2]) / 3600.0)

Query presenting the Template:P for all water wells that have available coordinates.