not logged in | [Login]
This page explains how to manage indicators on the Hotmaps toolbox. An indicator is a value that is displayed on the Hotmaps toolbox in the client-side. The indicator is part of a layer. An indicator is a value, for a specific spatial region, with a unit. An indicator is part of a layer dictionary. A layer object contains an array named "indicators". This table will be used to list all the indicators that you want to see for the layer.
layers = {
'heat_tot_curr_density_tif':{
'tablename':'heat_tot_curr_density_tif',
'from_indicator_name':'stat_heat_tot_curr_density_tif',
'schema_scalelvl': 'stat',
'schema_hectare': 'geo',
'crs': '3035',
'geo_column': 'geometry',
'table_type':'raster',
'data_lvl':['NUTS 0','NUTS 1','NUTS 2','NUTS 3','LAU 2','Hectare'],
'data_aggregated':True,
'scalelvl_column':'',
'indicators':[
{'table_column': 'sum', 'unit': 'MWh','indicator_id':'consumption'},
{'table_column': 'count', 'unit': 'cells','indicator_id':'count_cell'},
{
'reference_indicator_id_1': 'consumption',
'reference_tablename_indicator_id_1': 'heat_tot_curr_density_tif',
'operator': '/',
'reference_indicator_id_2': 'count_cell',
'reference_tablename_indicator_id_2': 'pop_tot_curr_density_tif',
'unit':'MWh/person', 'indicator_id': 'heat_tot_curr_density_tif_per_pop_tot_curr_density_tif'
}
]
}
}
Name of the DB table. (Example: 'heat_tot_curr_density_tif')
Subtablename for the selection of indicators. Must be unique. (Example: 'stat_heat_tot_curr_density_tif')
Is the data aggregated or not (Values: True or False)
Scale level column name if different to default one (Example: 'code')
Levels available for the data in the database
Table schema location for the nuts level. (Example: 'geo', 'stat', 'public')
Table schema location for the hectare level. (Example: 'geo', 'stat', 'public')
Projection of the geometry (Example: '3035', '4326', '4258')
Name of the geometry column in the database (Example: 'geom', 'geometry')
Type of the layer in the database (Values: 'vector' or 'raster').
Important: If it is a raster, the available columns are count, sum, mean, stddev, min and max
There are 2 types of indicators (Simple indicators & Cross indicators).
A simple indicator is an object with 3 parameters.
{
'table_column': 'count',
'unit': 'cells',
'indicator_id':'count_cell'
}
This is the table column that is selected in the table. (Example: 'count')
This is the unit of the indicator. (Example: 'cells', 'MWh')
This is the indicator identifier of the indicator (Like an ID). This name must be unique in the array of indicators.
A cross indicator is an object with 7 parameters. The goal of this indicator is to make a calculation among simple indicators.
{
'reference_indicator_id_1': 'consumption',
'reference_tablename_indicator_id_1':'heat_tot_curr_density_tif',
'operator': '/',
'reference_indicator_id_2':'count_cell',
'reference_tablename_indicator_id_2':'pop_tot_curr_density_tif',
'unit':'MWh/person',
'indicator_id':'heat_tot_curr_density_tif_per_pop_tot_curr_density_tif'
}
Corresponds to the identifier of a simple indicator. This name must be defined in the indicator array. It is value number 1.
Reference of the layer tablename that references the value number 1. (Example: 'heat_tot_curr_density_tif')
Calculation rule to apply to the 2 values (Values: '/' or '*' or '+' or '-')
Corresponds to the identifier of a simple indicator. This name must be defined in the indicator array. It is value number 2.
Reference of the layer tablename that references the value number 2. (Example: 'pop_tot_curr_density_tif')
This is the unit of the indicator. (Example: 'cells', 'MWh')
This is the name of the indicator (Like an ID). This name must be unique in the array of indicators.
reference_tablename_indicator_id_1.reference_indicator_id_1 / reference_tablename_indicator_id_2.reference_indicator_id_2 = heat_tot_curr_density_tif.consumption / pop_tot_curr_density_tif.count_cell
The result of the indicators are as follows:
{
"values": [
{
"unit": "MWh",
"name": "heat_tot_curr_density_tif_consumption",
"value": "4112030.46"
},
{
"unit": "cells",
"name": "heat_tot_curr_density_tif_count_cell",
"value": "46764"
},
{
"unit": "MWh/person",
"name": "heat_tot_curr_density_tif_per_pop_tot_curr_density_tif",
"value": "38.0092476775893146"
}
],
"name": "heat_tot_curr_density_tif"
}
Mostafa Fallahnejad, in Hotmaps-Wiki, Guidelines-for-defining-indicators (April 2019)
This page was written by Mostafa Fallahnejad EEG - TU Wien.
☑ This page was reviewed by Marcul Hummel e-think.
Copyright © 2016-2020: Mostafa Fallahnejad
Creative Commons Attribution 4.0 International License
This work is licensed under a Creative Commons CC BY 4.0 International License.
SPDX-License-Identifier: CC-BY-4.0
License-Text: https://spdx.org/licenses/CC-BY-4.0.html
We would like to convey our deepest appreciation to the Horizon 2020 Hotmaps Project (Grant Agreement number 723677), which provided the funding to carry out the present investigation.
View in another language:
Bulgarian* Czech* Danish* German* Greek* Spanish* Estonian* Finnish* French* Irish* Croatian* Hungarian* Italian* Lithuanian* Latvian* Maltese* Dutch* Polish* Portuguese (Portugal, Brazil)* Romanian* Slovak* Slovenian* Swedish*
* machine translated