Some items require the administrator to add records manually to the database tables.  This is the case for the Dashboards shown on the Dashboards section of the table. The user will need to connect to the SQL Server database OKACOMDSS.


Setting up Dashboards to display in the Dashboards section of the application. These can only be set up in the database itself. The database contains a table called GISDashboards. To display a new indicator or dashboard, data must be captured in this table. The fields are described below.


Fieldname

Description

Id

Automatically generated by the application

IndicatorName

The name that appears in the drop down list on the dashboards page

Description

The discription that is shown on the dashboards page

Interpretation

Information to aid interpretaion of the indicator being displayed

SourceMetaData

Meta data for the source (not displayed)

Citation

Citation to be displayed on the page

DataSourceTypeID

1 Google Earth Engine (GEE), 2 Other

MapDisplayTypeID

1 DSS Map display, 2 GEE imagery

BoundingLayer

A bounding layer used in GEE. This is usually the Active CORB Boundary

ImageryPath

Either GEE path as detailed in the documentation, or a layer in Geonode

BandName

The name of the band to be analysed in GEE

AggregateOperation

How data should be aggregated (sum or average)

LTAvStartYear

The start year of available data in GEE

LTAvEndYear

The end year of available data in GEE

ShowImage

An indicator to show and image

ColourPaletteID

The colour palette for the indicator (palettes are defined in the table ColourPalettes)

PaletteMinVal

Minimum value for the palette (will depend on the data being analysed)

PaletteMaxVal

Maximum value for the palette

MapLayerOpacity

The opacity of the layer on a scale of 0 to 1

ShowGraph

An indicator to tell the application to show the graph panel

GraphURL

The URL of the graphs. Graphs for GEE data are created in Google Data Studio

ScaleFactor

Analysed GEE values may need to be scaled to show correct results

AdjustBy

Analysed GEE values may need to be adjusted to show correct results

SortOrder

The order of the dashboard in the dropdown list

Enabled

A switch to make the dashboard visible

Created with the Personal Edition of HelpNDoc: Full-featured Documentation generator