|
|
| Line 6: |
Line 6: |
| | }} | | }} |
| | == Database schema of the oedb<br/> == | | == Database schema of the oedb<br/> == |
| | + | |
| | | | |
| | | | |
| Line 13: |
Line 14: |
| | |- | | |- |
| | | style="width: 101px" | '''ISO 19115 code'''<br/> | | | style="width: 101px" | '''ISO 19115 code'''<br/> |
| − | | style="width: 114px" | '''Schema name'''<br/> | + | | style="width: 113px" | '''Schema name'''<br/> |
| − | | style="width: 531px" | '''Definition'''<br/> | + | | style="width: 532px" | '''Definition'''<br/> |
| | |- | | |- |
| | | style="width: 101px" | 003<br/> | | | style="width: 101px" | 003<br/> |
| − | | style="width: 114px" | boundaries | + | | style="width: 113px" | boundaries |
| − | | style="width: 531px" | legal land descriptions Examples: political and administrative boundaries<br/> | + | | style="width: 532px" | legal land descriptions. examples: political and administrative boundaries<br/> |
| | |- | | |- |
| | | style="width: 101px" | 004<br/> | | | style="width: 101px" | 004<br/> |
| − | | style="width: 114px" | climate | + | | style="width: 113px" | climate |
| − | | style="width: 531px" | processes and phenomena of the atmosphere. Examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation<br/> | + | | style="width: 532px" | processes and phenomena of the atmosphere. examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation<br/> |
| | |- | | |- |
| | | style="width: 101px" | 005<br/> | | | style="width: 101px" | 005<br/> |
| − | | style="width: 114px" | economy | + | | style="width: 113px" | economy |
| − | | style="width: 531px" | 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<br/> | + | | style="width: 532px" | 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<br/> |
| | |- | | |- |
| | | style="width: 101px" | <br/> | | | style="width: 101px" | <br/> |
| − | | style="width: 114px" | energy_demand | + | | style="width: 113px" | energy_demand |
| − | | style="width: 531px" | <br/> | + | | style="width: 532px" | consumption and use of energy. examples: peak loads, load curves<br/> |
| | |- | | |- |
| | | style="width: 101px" | <br/> | | | style="width: 101px" | <br/> |
| − | | style="width: 114px" | energy_grid<br/> | + | | style="width: 113px" | energy_grid<br/> |
| − | | style="width: 531px" | <br/> | + | | style="width: 532px" | energy transmission infrastructure. examples: power lines, substation, pipelines<br/> |
| | |- | | |- |
| | | style="width: 101px" | <br/> | | | style="width: 101px" | <br/> |
| − | | style="width: 114px" | energy_supply<br/> | + | | style="width: 113px" | energy_supply<br/> |
| − | | style="width: 531px" | <br/> | + | | style="width: 532px" | conversion (generation) of energy. examples: power stations, renewables<br/> |
| | |- | | |- |
| | | style="width: 101px" | 007<br/> | | | style="width: 101px" | 007<br/> |
| − | | style="width: 114px" | environment<br/> | + | | style="width: 113px" | environment<br/> |
| − | | style="width: 531px" | environmental resources, protection and conservation Examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape<br/> | + | | style="width: 532px" | environmental resources, protection and conservation. examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape<br/> |
| | |- | | |- |
| | | style="width: 101px" | 016<br/> | | | style="width: 101px" | 016<br/> |
| − | | style="width: 114px" | society<br/> | + | | style="width: 113px" | society<br/> |
| − | | style="width: 531px" | 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<br/> | + | | style="width: 532px" | 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<br/> |
| | |- | | |- |
| | | style="width: 101px" | <br/> | | | style="width: 101px" | <br/> |
| − | | style="width: 114px" | model_draft<br/> | + | | style="width: 113px" | model_draft<br/> |
| − | | style="width: 531px" | <br/> | + | | style="width: 532px" | <br/> |
| | |- | | |- |
| | | style="width: 101px" | <br/> | | | style="width: 101px" | <br/> |
| − | | style="width: 114px" | reference<br/> | + | | style="width: 113px" | reference<br/> |
| − | | style="width: 531px" | <br/> | + | | style="width: 532px" | <br/> |
| | |} | | |} |
| | | | |
1. A database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).
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 code
|
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
|
|
energy_demand
|
consumption and use of energy. examples: peak loads, load curves
|
|
energy_grid
|
energy transmission infrastructure. examples: power lines, substation, pipelines
|
|
energy_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
|
|
|
reference
|
|
WARNING: The case and spacing on these terms is controlled and will be invalid if altered.
(also see NOAA ISO Topic Categories)
