|
|
| (6 intermediate revisions by 2 users not shown) |
| Line 5: |
Line 5: |
| | |Sources=https://en.wikipedia.org/wiki/Database_schema, https://geo-ide.noaa.gov/wiki/index.php?title=ISO_Topic_Categories | | |Sources=https://en.wikipedia.org/wiki/Database_schema, https://geo-ide.noaa.gov/wiki/index.php?title=ISO_Topic_Categories |
| | }} | | }} |
| | + | |
| | + | |
| | + | |
| | == Database schema of the oedb<br/> == | | == Database schema of the oedb<br/> == |
| | | | |
| | | | |
| | | | |
| − | ==== v0.3<br/> ==== | + | ==== v0.2 (current version)<br/> ==== |
| | | | |
| − | {| style="width: 100%" border="1" cellspacing="1" cellpadding="1" | + | {| style="width: 100%" cellspacing="1" cellpadding="1" border="1" |
| | |- | | |- |
| | | style="width: 70px" | '''ISO 19115'''<br/> | | | style="width: 70px" | '''ISO 19115'''<br/> |
| Line 30: |
Line 33: |
| | |- | | |- |
| | | style="width: 70px" | <br/> | | | style="width: 70px" | <br/> |
| − | | style="width: 104px" | energy_demand | + | | style="width: 104px" | demand |
| | | style="width: 572px" | consumption and use of energy. examples: peak loads, load curves<br/> | | | style="width: 572px" | consumption and use of energy. examples: peak loads, load curves<br/> |
| | |- | | |- |
| | | style="width: 70px" | <br/> | | | style="width: 70px" | <br/> |
| − | | style="width: 104px" | energy_grid<br/> | + | | style="width: 104px" | grid<br/> |
| | | style="width: 572px" | energy transmission infrastructure. examples: power lines, substation, pipelines<br/> | | | style="width: 572px" | energy transmission infrastructure. examples: power lines, substation, pipelines<br/> |
| | |- | | |- |
| | | style="width: 70px" | <br/> | | | style="width: 70px" | <br/> |
| − | | style="width: 104px" | energy_supply<br/> | + | | style="width: 104px" | supply<br/> |
| | | style="width: 572px" | conversion (generation) of energy. examples: power stations, renewables<br/> | | | style="width: 572px" | conversion (generation) of energy. examples: power stations, renewables<br/> |
| | |- | | |- |
| Line 60: |
Line 63: |
| | | style="width: 104px" | reference<br/> | | | style="width: 104px" | reference<br/> |
| | | style="width: 572px" | sources, literature<br/> | | | style="width: 572px" | sources, literature<br/> |
| | + | |- |
| | + | | style="width: 70px" | <br/> |
| | + | | style="width: 104px" | emission<br/> |
| | + | | style="width: 572px" | emissions, generally means the emission of particles, substances, (sound) waves or radiation into the environment. examples: Annual CO² emissions of Fossil fuel power station<br/> |
| | + | |- |
| | + | | style="width: 70px" | <br/> |
| | + | | style="width: 104px" | openstreetmap<br/> |
| | + | | style="width: 572px" | OpenStreetMap is a open project that collects and structures freely usable geodata and keeps them in a database for use by anyone. This data is available under a free license, the Open Database License.<br/> |
| | |} | | |} |
| − | | + | <div></div> |
| | <br/> | | <br/> |
| | | | |
| − | <br/>
| |
| − |
| |
| − |
| |
| − | ==== v0.1<br/> ====
| |
| | | | |
| − | demand<br/>economic<br/>emission<br/>environmental <br/>grid<br/>political_boundary<br/>scenario <br/>social<br/>supply <br/>weather<br/>workshop<br/> | + | ==== v0.1 ==== |
| | + | <div>demand<br/></div><div>economic</div><div>environmental</div><div>grid</div><div>openstreetmap</div><div>political_boundary</div><div>reference</div><div>scenario</div><div>social</div><div>supply</div><div>weather</div><div>workshop</div> |
| | | | |
| | | | |
1. A database schema of a database system is its structure described in a formal language supported by the database management system.
2. The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of the schema. All constraints are expressible in the same language.
ISO 19115
|
Schema name
|
Definition
|
003
|
boundaries
|
legal land descriptions. examples: political and administrative boundaries
|
004
|
climate
|
processes and phenomena of the atmosphere. examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation
|
005
|
economy
|
economic activities, conditions and employment. examples: production, labour, revenue, commerce, industry, tourism and ecotourism, forestry, fisheries, commercial or subsistence hunting, exploration and exploitation of resources such as minerals, oil and gas
|
|
demand
|
consumption and use of energy. examples: peak loads, load curves
|
|
grid
|
energy transmission infrastructure. examples: power lines, substation, pipelines
|
|
supply
|
conversion (generation) of energy. examples: power stations, renewables
|
007
|
environment
|
environmental resources, protection and conservation. examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape
|
016
|
society
|
characteristics of society and cultures. examples: settlements, anthropology, archaeology, education, traditional beliefs, manners and customs, demographic data, recreational areas and activities, social impact assessments, crime and justice, census information
|
|
model_draft
|
modelling sandbox, temp tables. examples: ego_grid_loadareas. !no version control!
|
|
|
scenario
|
scenario data
|
|
reference
|
sources, literature
|
|
emission
|
emissions, generally means the emission of particles, substances, (sound) waves or radiation into the environment. examples: Annual CO² emissions of Fossil fuel power station
|
|
openstreetmap
|
OpenStreetMap is a open project that collects and structures freely usable geodata and keeps them in a database for use by anyone. This data is available under a free license, the Open Database License.
|
WARNING: The case and spacing on these terms is controlled and will be invalid if altered.
(also see NOAA ISO Topic Categories)
