Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
maxLevel4
exclude(Page Contents|Author).*

...

Introduction

This is a generic guide to the basic requirements of data layers for getting the best and most user-friendly results from WinCan Enterprise.

...

Layers

Layers can be imported from well known formats including Shapefile, Geo Database and hosted online feature services.

The absolute minimum that WinCan Enterprise requires is a line layer for pipes and . This this layer must include a unique reference for each object and also the upper node and lower node point IDs.

...

Optionally, for even further improved user experience, access to the customer’s background mapping via web feature service is also very useful. This is not an asset layer and is used to make the assets viable against their surroundings to ease the workflow for operators and managers.

...

Layer Attributes

The absolute minimum requirements for data layers are described in the section above ‘Layers’.

The user-friendliness of the data can be further enhanced in almost all global drainage inspection standards by adding the following data where items in red are mandatory, all rows where the layer exists:

Line Layer

  • Unique Asset ID

  • Asset Upper Node Unique ID (Asset must exist in the point layer)

  • Asset Lower Node Unique ID (Asset must exist in the point layer)

  • Major Dimension (usually height or diameter)

  • Minor Dimension (usually width)

  • Asset Material

  • Asset Shape

  • Asset Usage

  • Alternative Asset ID

  • Town Name

  • Street Name

  • District Name

  • Asset Depth at Upper Node

  • Asset Depth at Lower Node

  • Asset Type (i.e. gravity sewer, rising force main etc.)

Point Layer

  • Unique Asset ID

  • Alternative Asset ID

  • Cover Level AOD

  • Asset Depth

  • Asset Type (i.e. manhole, gully, catchpit etc)

  • Asset Style (i.e. real node or virtual modelling node)

  • Asset Usage

  • Town Name

  • Street Name

  • District Name

...

In the attributes of points and lines, we need to understand measurement units for numeric data where applicable.

...

Dissolved Lines

It is important for us that lines are not split into sub-segments at virtual nodes.

...

Info

Note - this does not mean that the virtual modelling nodes have to be removed. They can be very useful for example like where a lateral connects to a main sewer. This would be the downstream node of the lateral.

What it means is that the lines of the sewers must be continuous from one access point to the next.

...

Field Translations

What are we talking about? Consider a database structure where the shape code used for circular pipe is CIRC as an example, but the target standard only understands C for this information. Here we must translate CIRC into C by understanding the meaning of the customer’s database keys. Another example could be a material code where there is no equivalent lookup in the target standard, but there as an option for ‘Other’, so we can make a suitable translation by deduction.

...