Schema Setup

Schemas

The PostgreSQL schema structure is based on the OEDB schema structure (v0.2).

Name	Description
boundaries	legal land descriptions. examples: political and administrative boundaries
climate	processes and phenomena of the atmosphere. examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation
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
environment	environmental resources, protection and conservation. examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape
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, temporary tables. examples: modelling raw data
reference	sources, literature
scenario	scenario data
game	reeem learning simulation

Code

reeem_setup_schema.sql