GDE Tiles Database Management
This repository handles the structure and migrations in the gde_tiles database.
The database is described through SQL files in the migrations/ directory.
Database tables
gde_tiles - Main GDE Tiles information
| column name | data type |
|---|---|
| quadkey | text (primary key) |
aggregated_sources - Information about sources of aggregated exposure models
Aggregated exposure models are an input to the Global Dynamic Exposure (GDE) model. Details on the sources can be found here.
| column name | data type | description |
|---|---|---|
| aggregated_source_id | smallint | Serial primary key. |
| name | varchar | Name of the source. |
| format | varchar | Format of the source files. |
migrations - Information about database migrations
Created and managed by inyuu:
| column name | data type |
|---|---|
| name | varchar(100) |
| hash | varchar(60) |
| executed_at | timestamp |
data_units - Information about data-units
Data-units are the smallest geographical unit where an exposure model is defined, i.e. where
data is available from an input aggregated exposure model for a particular occupancy case.
Consequently, the primary key of this table consists of three fields: data_unit_id,
occupancy_case and aggregated_source_id.
| column name | data type | description |
|---|---|---|
| data_unit_id | varchar | Identifier of the data unit. |
| occupancy_case | occupancycase | See personalised enumerated types. |
| aggregated_source_id | smallint | Identifier of the source of the aggregated model. |
| exposure_entity | char(3) | Identifier of the exposure entity. If a country, ISO3 code. |
| buildings_total | float | Total number of buildings as per the aggregated exposure model. |
| dwellings_total | float | Total number of dwellings as per the aggregated exposure model. |
| people_census | float | Total number of census people as per the aggregated exposure model. |
| cost_total | float | Total replacement cost of buildings as per the aggregated exposure model. |
data_unit_tiles - Information about data-unit tiles
Data-unit tiles result from the intersection of data units with zoom level 18 quadtiles.
Consequently, the primary key of this table consists of four fields: quadkey,
aggregated_source_id, occupancy_case and data_unit_id.
| column name | data type | description |
|---|---|---|
| quadkey | char(18) | Zoom level 18 tile identifier. |
| aggregated_source_id | smallint | Identifier of the source of the aggregated model. |
| occupancy_case | occupancycase | See personalised enumerated types. |
| exposure_entity | char(3) | Identifier of the exposure entity. If a country, ISO3 code. |
| data_unit_id | varchar | Identifier of the data unit. |
| size_data_unit_tile_area | float | Area of the data-unit tile, in m2. |
| size_data_unit_tile_built_up_area | float | Built-up area within the data-unit tile, in m2. |
| fraction_data_unit_area | float |
size_data_unit_tile_area / area of the data unit. |
| fraction_data_unit_built_up_area | float |
size_data_unit_tile_built_up_area / built-up area of the data unit. |
exposure_entities_costs_assumptions - Information about assumptions associated with building replacement costs
This table stores the currency in which the replacement costs of buildings of a particular
occupancy_case in a particular exposure_entity of an aggregated exposure model with ID
aggregated_source_id are given, as well as the factors by which to multiply total costs to
obtain the costs of structural components, non-structural components and building contents.
The primary key of this table consists of three fields: exposure_entity, occupancy_case and
aggregated_source_id.
| column name | data type | description |
|---|---|---|
| exposure_entity | char(3) | Identifier of the exposure entity. If a country, ISO3 code. |
| occupancy_case | occupancycase | See personalised enumerated types. |
| aggregated_source_id | smallint | Identifier of the source of the aggregated model. |
| structural | float | Factor by which to multiply total costs to obtain the cost of the structural components. |
| non_structural | float | Factor by which to multiply total costs to obtain the cost of the non-structural components. |
| contents | float | Factor by which to multiply total costs to obtain the cost of the building contents. |
| currency | varchar | Currency in which the replacement costs are expressed. |
Personalised enumerated types
occupancycase
The occupancycase enumerated type can have any of the following values:
| value |
|---|
| residential |
| commercial |
| industrial |