Theming Incidents On Time or Date to Display Most Recent

By default the GeoPlan displays all objects, which can lead to a visually busy display. Displaying all objects also incurs a performance cost, the graphics card processor having to render all objects. Consider the following section of a network displaying some incidents (customer complaints) with the date opened labelled, which range from 2010 unto 2015.

Incidents with Date

Incidents with Date

It is possible to create a theme on the year that the incident happened, but will require an SQL theme to only look at the year part of the date. The following steps outline the methodology.

1. Bring up the GeoPlan Property and Themes dialog box and click on the Theme Column, Edit button so as to create a new Theme.

New Theme

New Theme

2. Create a new Theme to overlay the ‘Base Theme’.

Overlay Base Theme

Overlay Base Theme

3. Name the new theme (Date Opened) and make it an SQL theme by clicking on the SQL button.

SQL Theme

SQL Theme

4. Create the SQL Expression required, in this case to theme according to the customer complaints year.

Create the SQL Expression

Create the SQL Expression

5. Using an Individual Range the software picks out the individual years that the incidents happened in.

Individual Range

Individual Range

6. The Network now reflects the Theme.

Network with Theme

Network with Theme

7. Editing the theme to only display the latest customer complaints. This can be achieved by using by using Visibility tick box in the theme and then setting the visibility bar to zero.

Changing The Visibility Of Unwanted Objects

Changing The Visibility Of Unwanted Objects

8. The network now display only the latest customer complaints.

Latest Objects Displayed

Latest Objects Displayed

Share this post!

    About Idris Nujjoo

    Idris is the Product Sector Leader for InfoNet and InfoMaster and has been working for Innovyze (and its earlier incarnations) since 2001 and specifically working on InfoNet and Asset Management for the past decade.

    This entry was posted in ICMLive, InfoNet, InfoWorks ICM, InfoWorks WS, IWLive, SWMMLive and tagged , , , . Bookmark the permalink.