Please enable JavaScript to view this site.

VertiGIS Utilities Solution

Navigation: Attributes

Sewer

 Prev Top Next More

The following tables list the attributes of the Sewer UN feature classes.  

Some of these attributes are found in all categories: they are listed in the table below. Attributes that are filled in automatically are highlighted in gray.   [0=Esri Domain, 1=CodedValue Domain]

Line

Device

Junction

Boundary

SubnetLine

Assembly

EdgeObject

JunctionObject

Field name

Field type

Localization

Domain

Description

X

X

X

X

 

 

 

 

AbnormalCoveringHeight

FLOAT

CH

 

Abnormal Covering height [m]

X

X

X

X

 

 

X

X

AddressID

TEXT, 255

Basic

 

Address (Reference)

X

X

X

X

 

 

X

X

AssetCatalogItem

LONG

Basic

 

Asset catalog item

X

X

X

X

 

 

X

X

AssetID

TEXT, 80

Basic

 

Asset ID

X

X

X

X

 

X

X

X

AssetName

TEXT, 255

Basic

 

Asset name

X

X

X

X

 

 

X

X

AssetOwner

SHORT

Basic

VGU_Organization (1)

Asset owner

X

X

X

X

 

X

X

X

AssetText

TEXT, 255

Basic

 

Asset text

X

X

X

X

 

X

X

X

CommentGeneral

TEXT, 255

Basic

 

Comment

X

X

X

X

X

X

X

X

created_date

DATE

Basic

 

Created date

X

X

X

X

 

X

X

X

DataOwner

SHORT

CH

VGU_Organization (1)

Data owner

X

X

X

X

 

X

X

X

DataProvider

SHORT

CH

VGU_Organization (1)

Data provider

X

X

X

X

 

 

X

X

DetailLifeCycleStatus

LONG

Basic

VGU_DetailLifeCycleStatus (1)

DetailLifeCycleStatus

X

X

X

X

X

X

X

X

Document_ref

GUID

Basic

 

Document_ref

 

X

X

 

 

 

 

 

Elevation

DOUBLE

Basic

 

Elevation (m a.s.l.)

X

X

X

X

 

 

X

X

FormerAssetName

TEXT, 255

Basic

 

Former Asset name

X

X

X

X

X

X

X

X

last_edited_date

DATE

Basic

 

Last edited date

X

 

 

 

 

 

 

 

Length_XY_calc

DOUBLE

Basic

 

Calculated 2D length [m]

X

 

 

 

 

 

 

 

Length_XYZ_calc

DOUBLE

Basic

 

Calculated 3D length [m]

X

 

 

 

 

 

 

 

Length_XYZ_effective

DOUBLE

Basic

 

Effective 3D length [m]

X

X

X

X

 

 

 

 

MaintenanceResponsible

SHORT

Basic

VGU_Organization (1)

Maintenance responsible

 

X

 

 

 

 

 

 

NET_CurrentPosition

SHORT

Basic

VGU_DevicePosition (0)

Current position

X

X

X

 

 

 

X

X

NET_Custom

LONG

Basic

 

Net custom

X

X

X

X

 

 

X

X

NET_MainLifeCycleStatus

SHORT

Basic

VGU_MainLifeCycleStatus (0)

Main life cycle status

 

X

 

 

 

 

 

 

NET_NormalPosition

SHORT

Basic

VGU_DevicePosition (0)

Normal position

X

X

X

 

 

 

X

X

NET_Trace

LONG

Basic

 

Trace

 

X

X

 

 

 

 

 

PosDeterm_XY_Method

SHORT

Basic

VGU_PositionDetermination_XY_Method (1)

XY position determination method

 

X

X

 

 

 

 

 

PosDeterm_XY_Range

DOUBLE

Basic

 

XY position determination range [m]

X

X

X

X

 

 

 

 

PosDeterm_XY_Reliability

SHORT

Basic

VGU_PositionDetermination_Reliability (0)

XY position determination reliability

 

X

X

 

 

 

 

 

PosDeterm_Z_Method

SHORT

Basic

VGU_PositionDetermination_Z_Method (1)

Z position determination method

 

X

X

 

 

 

 

 

PosDeterm_Z_Range

DOUBLE

Basic

 

Z position determination range [m]

X

X

X

X

 

 

 

 

PosDeterm_Z_Reliability

SHORT

Basic

VGU_PositionDetermination_Reliability (0)

Z position determination reliability

X

X

X

X

 

X

X

X

SIA405_ID

TEXT, 16

CH

 

SIA ID

 

X

X

 

 

X

 

 

SYM_ROTATION

DOUBLE

Basic

 

Symbol rotation

X

X

X

X

 

X

 

 

SYM_STYLE

TEXT, 64

Basic

 

Symbol style

 

 

 

 

X

 

 

 

TotalLength

DOUBLE

Basic

 

Total length [m]

 

 

 

 

X

 

 

 

TotalServiceConnectionDevice

LONG

Basic

 

Total service connections

X

X

X

X

 

 

X

X

VG_CalculateArcade

TEXT, 2048

Basic

 

VG calculate Arcade

 

The following attributes are specific to sewer.

Line

Device

Junction

Boundary

SubnetLine

Assembly

EdgeObject

JunctionObject

Field name

Field type

Lokalization

Domain

Description

 

 

 

 

 

 

X

X

AcceptanceDate

DATE

DE

 

Acceptance Date

 

X

X

 

 

 

 

 

ActualBackwaterElevation

DOUBLE

CH

 

Backwater Elevation (Actual)

 

X

 

 

 

 

 

 

ActualOpeningDimension

SHORT

CH

 

Opening Dimension (Actual)

 

X

 

 

 

 

 

 

ActualOpeningDimensionOpt

SHORT

CH

 

Opening Dimension Optimized (Actual)

X

 

 

 

 

 

 

 

ActualUsageClass

SHORT

Basic

SEW_UsageClass (1)

UsageClass (Actual)

 

 

 

 

 

 

X

X

AmortisationPeriod

SHORT

DE

 

Amortisation Period

 

X

 

 

 

 

 

 

ApprovalNumber

TEXT, 50

CH

 

Approval Number

X

X

X

 

 

X

X

X

AssetEntity

LONG

Basic

SEW_AssemblyAssetEntityTreatmentPlant (1),

SEW_DeviceAssetEntityInfiltrationDelivery (1),

SEW_DeviceAssetEntityOverflow (1),

SEW_DeviceAssetEntityPump (1),

SEW_DeviceAssetEntityShutOff_Throttling (1),

SEW_DeviceAssetEntityStormWaterDelivery (1),

SEW_JunctionAssetEntityFeedPoint (1),

SEW_JunctionAssetEntitySensorUnit (1)

Asset type detail

 

 

 

 

 

X

 

 

BaseArea

DOUBLE

DE

 

Base Area

 

 

 

 

 

 

X

X

BendingModule

DOUBLE

DE

 

Bending Module

 

 

 

 

 

X

 

 

BOD5

LONG

CH

 

BOD5

 

 

X

 

 

 

 

 

BottomLevel

DOUBLE

Basic

 

Bottom Level

 

X

 

 

 

 

 

 

BuildingGrossCost

DOUBLE

CH

 

Building Gross Cost

 

X

 

 

 

 

 

 

BuildingSubsidies

DOUBLE

CH

 

Subsidies

 

 

 

 

 

 

X

X

ChemicalResistance

TEXT, 60

DE

 

Chemical Resistance

 

 

 

 

 

X

 

 

COD

LONG

CH

 

COD

 

 

 

 

 

 

X

X

CommentMeasure

TEXT, 255

DE

 

CommentMeasure

 

 

 

 

 

 

X

X

CommentPosition

TEXT, 255

DE

 

Comment Position

 

 

 

 

 

 

X

X

CompositeMaterial

SHORT

DE

SEW_CompositeMaterial (1)

Composite Material

 

 

 

 

 

 

X

X

CompositeMaterial2

SHORT

DE

SEW_CompositeMaterial (1)

Composite Material 2

X

X

X

 

 

 

X

X

ConditionGeneral

SHORT

Basic

VGU_Condition (0)

General Condition

X

 

X

 

 

 

 

 

ConnectionComment

TEXT, 255

DE

 

Connection Comment

X

 

X

 

 

 

 

 

ConnectionMaterial

SHORT

DE

SEW_Material (1)

Connection Material

 

 

X

 

 

 

 

 

ConnectionPositionISY

DOUBLE

DE

 

Connecting PositionISY

 

 

X

 

 

 

 

 

ConnectionSealed

SHORT

CH

VGU_YesNo (1)

Connection Sealed

 

 

 

 

 

 

X

X

Contract_ref

GUID

Basic,

DE

 

Contract_ref

 

 

 

 

 

 

X

X

ContractID

SHORT

DE

 

Contract ID

 

X

 

 

 

 

 

 

CrossSectionSurface

DOUBLE

CH

 

Cross-section

X

 

 

 

 

 

 

 

CurrentHydraulicLoad

SHORT

CH

 

Hydraulic Load (Current)

 

 

 

 

 

X

 

 

DammingBody

SHORT

CH

SEW_AssemblySensorUnitDammingBody (1)

Damming Body

 

 

 

 

 

X

 

 

Depth

DOUBLE

DE

 

Depth

 

X

 

 

 

 

 

 

DimensionLength

DOUBLE

CH

 

Bottom Opening Length /  Weir Length

 

X

 

 

 

 

 

 

DischargePoint

TEXT, 20

CH

 

Discharge point

 

X

 

 

 

 

 

 

DischargeType

SHORT

DE

SEW_DischargeType (1)

Discharge Type

X

 

X

 

 

 

 

 

DrainageConnected

SHORT

DE

VGU_YesNo (1)

Drainage Connected

X

 

 

 

 

 

 

 

DryWeatherFlowtime

LONG

CH

 

Flowtime (Dry Weather)

X

 

 

 

 

 

 

 

EdgeType

SHORT

DE

SEW_SEWLineEdgeType (1)

Edge Type

 

X

 

 

 

 

 

 

EffectiveCrossSectionSurface

DOUBLE

CH

 

Effective cross-section

 

X

 

 

 

 

 

 

ElevationStart

DOUBLE

Basic

 

Elevation Start

 

X

 

 

 

 

 

 

ElevationStop

DOUBLE

Basic

 

Elevation Stop

 

 

 

 

 

X

 

 

EliminationRateCOD

DOUBLE

CH

 

Elimination rate COD

 

 

 

 

 

X

 

 

EliminationRateN

DOUBLE

CH

 

Elimination rate N

 

 

 

 

 

X

 

 

EliminationRateNH4

DOUBLE

CH

 

Elimination rate NH4

 

 

 

 

 

X

 

 

EliminationRateP

DOUBLE

CH

 

Elimination rate P

X

 

 

 

 

 

 

 

EndNode_ref

GUID

Basic

 

EndNode_ref

 

 

 

 

 

 

X

X

EndOfWarranty

DATE

DE

 

End of Warranty

 

 

 

 

 

 

X

X

EndPosition

SHORT

Basic,

DE

 

End Position

 

 

 

 

 

 

X

X

EndStation

DOUBLE

DE

 

End Station

 

 

 

 

 

 

X

X

ExecutionEnd

DATE

DE

 

End of Execution

 

 

 

 

 

 

X

X

ExecutionStart

DATE

DE

 

Start of Execution

 

 

X

 

 

 

 

 

ExtraneousWaterInfiltration

DOUBLE

CH

 

Ingress of extraneous Water

X

 

X

 

 

 

 

 

Fixation

TEXT,

DE

 

Fixation

 

 

 

 

 

 

X

X

FlexuralStrength

DOUBLE

DE

 

Flexural Strength

X

 

 

 

 

 

 

 

FloodPlain

SHORT

DE

VGU_YesNo (1)

Flood Plain

X

 

 

 

 

 

 

 

FlumeFunction

SHORT

DE

SEW_SEWLineFlumeFunction (1)

Flume Function

X

 

 

 

 

 

 

 

FlushingInterval

LONG

CH

 

Flushing Interval

X

 

 

 

 

 

 

 

FunctionHierarchical

SHORT

CH

SEW_LineFunctionHierarchicalMain (1),

SEW_LineFunctionHierarchicalSecondary (1)

Function hierarchical

X

 

 

 

 

 

 

 

FunctionHydraulic

SHORT

CH

SEW_LineFunctionHydraulic_AssetGroup100 (1),

SEW_LineFunctionHydraulic_AssetGroup150 (1),

SEW_LineFunctionHydraulic_AssetGroup200 (1)

Function hydraulic

X

X

X

 

 

 

 

 

FunctionMelioration

SHORT

CH

SEW_LineFunctionMelioration (1),

SEW_NodeFunction (1)

Function Melioration

X

X

X

 

 

X

 

 

GeoCRSPosition

TEXT, 30

DE

 

GeoCRSPosition

X

X

X

 

 

X

 

 

GeoDataSource

SHORT

DE

 

GeoDataSource

X

X

X

 

 

X

 

 

GeoObjectKind

SHORT

DE

SEW_GeoObjectKind (1)

Geo Object Kind

X

X

X

 

 

X

 

 

GeoObjectType

SHORT

DE

SEW_GeoObjectType (1)

Geo Object Type

X

X

X

 

 

X

 

 

GeoPosDeterm_XY_ISY

SHORT

DE

SEW_PositionAccuracyClass (1)

GeoPosDeterm_XY_ISY

X

X

X

 

 

X

 

 

GeoPosDeterm_Z_ISY

SHORT

DE

SEW_HeightAccuracyClass (1)

GeoPosDeterm_Z_ISY

X

X

X

 

 

X

 

 

GeoPreliminaryName

TEXT, 30

DE

 

Geo Preliminary Name

X

X

X

 

 

X

 

 

GeoXYPrecision

SHORT

DE

SEW_PositionPrecision (1)

GeoXYPrecision

X

X

X

 

 

X

 

 

GeoZPrecision

SHORT

DE

SEW_HeightPrecision (1)

GeoZPrecision

X

 

 

 

 

 

 

 

GradientCalc

DOUBLE

Basic

 

Gradient

X

 

 

 

 

 

 

 

GradientPlanned

DOUBLE

CH

 

Gradient (Planned)

 

X

 

 

 

 

 

 

GroundwaterDistance

DOUBLE

CH

 

Groundwater Distance

X

 

 

 

 

 

 

 

GroundWaterDistance

SHORT

DE

SEW_GroundWaterDistance (1)

Distance To Groundwater

X

 

 

 

 

 

 

 

GutterFunction

SHORT

DE

SEW_SEWLineGutterFunction (1)

Gutter Function

X

 

 

 

 

 

 

 

HeightPrecisionEndNode

TEXT, 1

DE

 

High Precision End Node

X

 

 

 

 

 

 

 

HeightPrecisionStartNode

TEXT, 1

DE

 

High Precision Start Node

 

X

 

 

 

 

 

 

InfiltrationCapacity

DOUBLE

CH

 

Infiltration capacity

 

X

 

 

 

 

 

 

InfiltrationEffectivenessArea

DOUBLE

CH

 

Effectiveness Area

 

X

 

 

 

 

 

 

InfiltrationFacilityType

SHORT

DE

SEW_AssemblyInfiltrationFacilityTypeAssetType (1)

Infiltration Facility Type

X

X

 

 

 

 

 

 

InfiltrationFillMaterial

SHORT

CH

SEW_InfiltrationFillMaterial (1)

Fill Material

 

X

 

 

 

 

 

 

InfiltrationPenetrationResist

LONG

CH

SEW_InfiltrationPenetrationResist (1)

Resistance to water penetration

 

X

 

 

 

 

 

 

InfiltrationWaterClass

LONG

CH

SEW_InfiltrationWaterClass (1)

Infiltration water

 

 

X

 

 

 

 

 

InletLevel

DOUBLE

Basic

 

Inlet Level

X

 

 

 

 

 

 

 

InsideCoating

SHORT

CH

SEW_LineInsideCoating (1)

Inside Coating

X

 

X

 

 

 

 

 

InsideCoatingISY

SHORT

DE

SEW_SEWLineInsideCoating (1)

Inside Coating Isybau

X

X

X

 

 

X

X

X

InstallationYear

SHORT

Basic

 

Installation Year

 

X

X

 

 

 

 

 

KoteAssumption

DOUBLE

Basic

 

Kote Assumption

 

X

X

 

 

 

 

 

KoteReferenceAltitude

DOUBLE

Basic

 

Kote Altitude Reference

 

X

X

 

 

 

 

 

KoteZ

DOUBLE

Basic

 

Kote Z

 

 

 

 

 

X

 

 

LaunchingYear

SHORT

CH

 

Launching Year

X

 

 

 

 

 

 

 

LeakageProtection

SHORT

CH

VGU_YesNo (1)

Leakage Protection

 

 

 

 

 

 

X

X

LeakTest

SHORT

DE

VGU_YesNo (1)

Leak Test

X

 

 

 

 

 

 

 

Lining

SHORT

DE

SEW_LiningType (1),

SEW_SEWLineLineLining (1)

Lining

X

 

 

 

 

 

 

 

LiningMaterial

SHORT

DE

SEW_Material (1)

Lining Material

X

 

 

 

 

 

 

 

LISAGUID

TEXT, 32

DE

 

LISA-GUID

X

X

X

 

 

X

X

X

LocalDistrict_ref

GUID

Basic

 

Local District_ref

 

 

X

 

 

 

 

 

Location

TEXT, 50

Basic

 

Location

X

 

 

 

 

 

 

 

LocationComment

TEXT,

DE

 

Location Comment

 

 

X

 

 

 

 

 

LocationHouseNumber

TEXT, 50

CH

 

House number

X

 

 

 

 

 

 

 

LocationSurface

SHORT

DE

SEW_LocationSurface (1)

Location Surface

 

 

X

 

 

 

 

 

ManholeFunction

SHORT

DE

SEW_JunctionManholeI (1)

Manhole Function

 

X

 

 

 

 

 

 

ManometricDeliveryHead

DOUBLE

DE

 

Manometric Delivery Head

 

X

X

 

 

X

 

 

ManufacturedBy

TEXT, 60

DE

 

Manfactured By

 

X

X

 

 

 

 

X

Manufacturer

TEXT, 50

Basic

 

Manufacturer

 

X

X

 

 

X

 

 

ManufacturerAdress

TEXT, 60

DE

 

Manufacturer Adress

X

 

 

 

 

 

 

 

Material

LONG

Basic

SEW_LineMaterial (1)

Material

X

 

 

 

 

 

 

 

MaterialGroup

LONG

Basic

SEW_LineMaterialGroup (1)

Material Group

X

 

 

 

 

X

 

 

MaterialISY

SHORT

DE

SEW_Material (1)

MaterialISY

 

 

 

 

 

 

X

X

MaterialThickness

SHORT

DE

 

Material Thickness

 

 

 

 

 

X

 

 

MaxHeight

DOUBLE

DE

 

Max Height

 

 

 

 

 

X

 

 

MaxLength

DOUBLE

DE

 

Max Length

 

X

 

 

 

 

 

 

MaxLiftHeight

DOUBLE

DE

 

Max Lift Height

 

 

 

 

 

X

 

 

MaxWidth

DOUBLE

DE

 

Max Width

 

 

 

 

 

X

 

 

MeasuringPurpose

SHORT

CH

SEW_AssemblySensorUnitMeasuringPurpose (1)

Measuring Purpose

 

 

 

 

 

X

 

 

MeasuringType

TEXT, 50

CH

 

Measuring Type

X

X

X

 

 

 

X

X

NET_Quality

SHORT

Basic

 

Quality

 

X

 

 

 

 

 

 

NET_SystemChange

SHORT

 

 

System change

 

 

 

 

 

X

 

 

NH4

LONG

CH

 

NH4

 

 

X

 

 

 

 

 

NodeType

SHORT

DE

SEW_NodeType (1)

Node Type

 

X

 

 

 

 

 

 

NominalPower

DOUBLE

DE

 

Nominal Power

X

 

 

 

 

 

 

 

NominalPressure

SHORT

DE

 

Nominal Pressure

 

 

X

 

 

 

 

 

NumberConnections

SHORT

DE

 

Number Connections

 

X

 

 

 

 

 

 

OpeningWidth

DOUBLE

DE

 

Opening Width

 

 

X

 

 

X

 

X

Operator

SHORT

Basic,

CH,

DE

 

 

 

 

 

 

 

X

 

 

OperatorClass

SHORT

CH

SEW_AssemblyOperatorClass (1)

Operator Class

X

 

 

 

 

 

 

 

OuterDiameter

SHORT

Basic,

DE

 

Outer Diameter

 

 

X

 

 

 

 

 

OutletLevel

DOUBLE

Basic

 

Outlet Level

 

 

X

 

 

 

 

 

OutletShape

SHORT

CH

SEW_JunctionOutletForm (1)

Outlet Shape

 

 

X

 

 

 

 

 

OutletStructureType

SHORT

DE

SEW_JunctionOutletStructureTypeAssetType (1)

Outlet Structure Type

 

X

 

 

 

 

 

 

OverflowForm

LONG

CH

SEW_DeviceOverflowForm_AssetEntity10410 (1),

SEW_DeviceOverflowForm_AssetEntity10420 (1)

Bottom Opening Shape /  Weir Crest Shape

 

X

 

 

 

 

 

 

Performance

DOUBLE

DE

 

Performance

X

 

 

 

 

 

 

 

PipeProfileAspectRatio

DOUBLE

CH

 

Ratio Height-Width

X

 

 

 

 

 

 

 

PipeProfileComment

TEXT, 80

CH

 

Profile Comment

X

 

 

 

 

 

 

 

PipeProfileName

TEXT, 20

CH

 

Profile Name

X

 

 

 

 

 

 

 

PipeProfileType

SHORT

Basic

SEW_LinePipeProfileType (1)

Pipe profile

X

 

 

 

 

 

 

 

PipeProfileTypeIsy

SHORT

DE

SEW_SEWLineLinePipeProfileType (1)

Pipe profile Isy

X

X

X

 

 

X

 

 

PointIdentifier

SHORT

DE

SEW_JunctionPointIdentifierAssetType (1),

SEW_PointAttributeSEW (1)

Point Identifier

 

 

 

 

 

X

 

 

Population

LONG

DE

 

Population

 

X

 

 

 

 

 

 

PowerConsuption

DOUBLE

DE

 

Power Consumption

X

 

 

 

 

 

 

 

PressureMethod

SHORT

DE

 

Pressure Method

 

 

 

 

 

 

X

X

PrimaryMaterial

SHORT

DE

SEW_Material (1)

Primary Material

 

 

 

 

 

 

X

X

ProcessDesignation

SHORT

DE

SEW_ProcessDesignation (1)

Process Designation

 

 

 

 

 

 

X

X

ProfileCodeStructurePart

SHORT

DE

SEW_ProfileCodePart (1)

Profile Code Structure Part

X

X

X

 

 

X

X

X

PropertyISY

SHORT

DE

SEW_Property (1)

Property ISY

 

X

 

 

 

 

 

 

PumpIndividualFlowRateMax

LONG

CH

 

Individual Flow Rate (Max)

 

X

 

 

 

 

 

 

PumpIndividualFlowRateMin

LONG

CH

 

Individual Flow Rate (Min)

 

X

 

 

 

 

 

 

PumpMountingDrivePosition

SHORT

CH

SEW_DevicePumpMountingDrivePosition (1)

Drive Mounting Position

 

X

 

 

 

 

 

 

PumpMountingOrientation

SHORT

CH

SEW_DevicePumpMountingOrientation (1)

Pump Mounting Orientation

 

X

 

 

 

 

 

 

PumpOperatingPoint

DOUBLE

CH

 

Pump Operating Point

 

X

 

 

 

 

 

 

PumpType

SHORT

DE

SEW_DevicePumpTypeAssetType (1)

Pump Type

 

X

 

 

 

 

 

 

Qan_Dimension

LONG

CH

 

Q and dim

X

 

 

 

 

 

 

 

ReachClass

SHORT

DE

 

Reach Class

X

 

 

 

 

 

 

 

ReachFunction

SHORT

DE

SEW_SEWLineReachFunction (1)

Reach Function

 

X

 

 

 

 

 

 

RegulationAdjustability

SHORT

CH

SEW_DeviceRegulationAdjustability (1)

Adjustability

 

X

 

 

 

 

 

 

RegulationControl

SHORT

CH

SEW_DeviceRegulationControl (1)

Control

 

X

 

 

 

 

 

 

RegulationDriveSystem

SHORT

CH

SEW_DeviceRegulationDriveSystem (1)

Drive System

 

X

 

 

 

 

 

 

RegulationFunction

SHORT

CH

SEW_RegulationOverflowFunction (1)

Function

 

 

 

 

 

 

X

X

RehabilitationExtend

SHORT

DE

SEW_RehabilitationExtend (1)

Rehabilitation Extend

 

 

 

 

 

 

X

X

RehabilitationMeasure

TEXT, 5

DE

 

Rehabilitation Measure

 

 

 

 

 

 

X

 

ReliningConstructionTechnology

SHORT

CH

SEW_EdgeReliningConstructionTechnology (1)

Relining Construction Technology

 

 

 

 

 

 

X

 

ReliningExtent

SHORT

CH

SEW_EdgeReliningExtent (1)

Relining Extent

 

 

 

 

 

 

X

 

ReliningMaterial

SHORT

CH

SEW_EdgeReliningMaterial (1)

Relining Material

 

 

 

 

 

 

X

 

ReliningNominalDiameter

LONG

CH

 

Relining Nominal Diameter

 

X

 

 

 

 

 

 

RemoteControlled

SHORT

CH

VGU_YesNo (1)

Remote Controlled

X

 

 

 

 

 

X

X

RingStiffness

DOUBLE

CH,

DE

 

Ring Stiffness

X

X

X

 

 

X

X

X

Road_ref

GUID

Basic

 

Road_ref

X

 

 

 

 

 

 

 

RoughnessCoefficient

DOUBLE

Basic

 

Roughness Coefficient {Strickler}

 

 

X

 

 

 

 

X

SerialNumber

TEXT, 50

Basic

 

Serial Number

X

 

 

 

 

 

 

 

ServicePipeFunction

SHORT

DE

SEW_SEWLineServicePipeFunction (1)

Service Pipe Function

X

 

 

 

 

 

 

 

SewerMedium

SHORT

DE

SEW_Medium (1)

Sewer Medium

X

 

 

 

 

 

 

 

ShearStress

DOUBLE

DE

 

Shear Stress

 

X

 

 

 

 

 

 

SignalTransmission

SHORT

CH

SEW_DeviceSignalTransmission (1)

Signal transmission

 

X

 

 

 

 

 

 

SliderFunction

SHORT

DE

SEW_DeviceSliderFunctionAssetType (1)

Slider Function

 

X

 

 

 

 

 

 

SliderType

SHORT

DE

SEW_DeviceSliderTypeAssetType (1)

Slider Type

 

X

 

 

 

 

 

 

SliderWidth

DOUBLE

DE

 

Slider With

X

 

 

 

 

 

 

 

SoilType

SHORT

DE

SEW_SoilType (1)

Soil Type

X

 

 

 

 

 

 

 

SpecialProfileType

SHORT

DE

VGU_YesNo (1)

Special Profile Type

X

 

 

 

 

 

 

 

SpecialProfileXY_ref

GUID

DE

 

SpecialProfile Ref

X

 

 

 

 

 

 

 

StandardDimensionRatio

SHORT

DE

SEW_SEWLineSDR (1)

Standard Dimension Ratio

X

 

 

 

 

 

 

 

StartNode_ref

GUID

Basic

 

StartNode_ref

 

 

 

 

 

 

X

X

StartStation

DOUBLE

DE

 

Start Station

 

 

 

 

 

 

X

X

StaticLoad

SHORT

DE

SEW_Load (1)

Static Load

X

X

X

 

 

X

X

X

StatusISY

SHORT

DE

SEW_Status (1)

Status ISY

 

 

 

 

 

 

X

X

StructurePart

SHORT

DE

SEW_StructurePart (1)

Structure Part

 

X

X

 

 

X

 

 

StructureTypeISY

SHORT

DE

SEW_StructureType (1)

Structure TypeISY

X

X

X

 

 

X

X

X

SuperiorSewageObject_ref

GUID

DE

 

SuperiorSewageObject_ref

 

 

X

 

 

 

 

 

SurfaceFixation

SHORT

CH

SEW_JunctionFeedSurfaceFixation (1)

Fixation

 

 

X

 

 

 

 

 

SurfacePurpose

SHORT

CH

SEW_JunctionFeedSurfacePurpose (1)

Surface Purpose

 

 

X

 

 

 

 

 

SurfaceSlope

SHORT

CH

 

Slope

X

 

 

 

 

 

 

 

TargetUsageClass

SHORT

Basic

SEW_UsageClass (1)

UsageClass (Target)

 

X

 

 

 

 

 

 

TerrainElevation

DOUBLE

CH

 

Terrain Elevation

 

X

 

 

 

 

 

 

ThresholdLength

DOUBLE

DE

 

Threshold Length

 

X

 

 

 

 

 

 

ThresholdMax

DOUBLE

DE

 

Threshold Max

 

X

 

 

 

 

 

 

ThresholdMin

DOUBLE

DE

 

Threshold Min

 

X

 

 

 

 

 

 

TotalDeliveryHead

DOUBLE

DE

 

Total Delivery Head

X

 

X

 

 

 

 

 

Tract

TEXT, 40

Basic,

DE

 

Tract

X

X

X

 

 

X

X

X

Tract_ref

GUID

DE

 

Tract_ref

 

 

X

 

 

 

 

 

TransferManHole

SHORT

DE

VGU_YesNo (1)

Transfer Manhole

 

 

X

 

 

 

 

 

TransferPoint

SHORT

DE

VGU_YesNo (1)

Transfer Point

 

X

X

 

 

X

 

 

TransferStructure

SHORT

DE

VGU_YesNo (1)

Transfer Structure

 

X

 

 

 

 

 

 

TraverseSpeed

DOUBLE

DE

 

Traverse Speed

 

X

X

 

 

X

 

 

UFISNumber

TEXT, 10

DE

 

UFIS Number

 

 

 

 

 

X

 

 

UsableVolume

DOUBLE

DE

 

Usable Volume

 

 

 

 

 

X

 

 

VolumeBuilding

DOUBLE

DE

 

Volume Building

 

 

 

 

 

X

 

 

VolumeUnderground

DOUBLE

DE

 

Volume Underground

X

 

 

 

 

 

 

 

WallRoughness

DOUBLE

CH

 

Wall Roughness {Prandtl}

 

 

 

 

 

 

X

X

WallThickness

DOUBLE

DE

 

Wall Thickness

 

X

X

 

 

X

 

 

WasteWaterTreatmentPlantNumber

LONG

CH

 

Treatment Plant Number /  WW Treatment Plant Number

 

 

 

 

 

X

 

 

WasteWaterTreatmentPlantType

TEXT, 50

CH

 

WasteWaterTreatmentPlantType

 

X

 

 

 

 

 

 

WaterbodyFloodElevation

DOUBLE

CH

 

Flood elevation

 

X

 

 

 

 

 

 

WaterbodyID

TEXT, 25

CH

 

ID Waterbody

 

X

 

 

 

 

 

 

WaterbodySectionID

TEXT, 30

CH

 

ID Waterbody section

X

 

 

 

 

 

 

 

WaterHazardousSubstances

SHORT

DE

SEW_WaterHazardous (1)

Water Hazardous Substances

 

 

 

 

 

 

X

X

WaterPermeability

SHORT

DE

SEW_WaterPermeability (1)

Water Permeability

X

 

 

 

 

 

 

 

WaterProtectionZone

SHORT

DE

SEW_WaterProtectionZone (1)

Water Protection Zone

 

X

 

 

 

 

 

 

WaterSurfaceHydraulics

DOUBLE

CH

 

Water surface hydraulics

 

 

 

 

 

X

 

 

WaterTreatmentFunction

SHORT

DE

SEW_AssemblyFunctionAssetType (1)

Water Treatment Function

 

X

 

 

 

 

 

 

WeirCrestType

SHORT

DE

SEW_DeviceWeirCrestTypeAssetType (1)

Weir Crest Type

 

X

 

 

 

 

 

 

WeirFunction

SHORT

DE

SEW_DeviceWeirFunctionAssetType (1)

Weir Function

 

X

 

 

 

 

 

 

WeirType

SHORT

DE

SEW_DeviceWeirTypeAssetType (1)

Weir Type

 

X

 

 

 

 

 

 

ZeroPosition

DOUBLE

DE

 

Zero Postion

 

In addition, simple feature classes and tables that are not part of the Utility Network core model are used in the model.

Table name

Field name

Field type

Localization

Domain

Description

SEWAdmindata

BuildingSupervision

TEXT, 40

DE

 

Building Supervision

SEWAdmindata

CodeSupervisionConstruction

TEXT, 5

DE

 

Code Supervision Construction

SEWAdmindata

CommentAdmin

TEXT, 255

DE

 

Comment

SEWAdmindata

CRSHeight

TEXT, 20

DE

 

CRS Height

SEWAdmindata

DischargeLicenceExpiry

DATE

DE

 

Discharge Licence Expiry

SEWAdmindata

FileNumber

TEXT, 15

DE

 

File Number

SEWAdmindata

ManagingDepartment

TEXT, 40

DE

 

Managing Department

SEWAdmindata

PropertyManagement

TEXT, 40

DE

 

Property Management

SEWAdmindata

Responsibility

TEXT, 10

DE

 

Responsibility

SEWAdmindata

ResponsibleDepartment

SHORT

DE

SEW_Responsibility (1)

Responsible Department

SEWAdmindata

SupervisionConstruction

TEXT, 40

DE

 

Supervision Construction

SEWAdmindata

WastewaterDisposalObligation

SHORT

DE

SEW_RemovalDuty (1)

Wastewater Disposal Obligation

SEWAdmindata

WaterAuthority

TEXT, 40

DE

 

Water Authority

SEWAdminUnit

AdminData_ref

GUID

DE

 

AdminData_ref

SEWAdminUnit

AdministrativeUnit

TEXT, 4

DE

 

Administrative Unit

SEWAdminUnit

Adress_ref

GUID

Basic,

DE

 

Adress

SEWAdminUnit

ObjectNumber

TEXT, 4

DE

 

Object Number

SEWAdminUnit

RealEstateName

TEXT, 255

DE

 

Real Estate Name

SEWAdminUnit

RealEstateNumber

TEXT, 20

DE

 

Real Estate Number

SEWAdminUnit

Responsibilty

SHORT

DE

SEW_WE-NumberDetail (1)

Responsibility

SEWAdminUnit

UnitNumber

TEXT, 10

DE

 

Unit Number

SEWAdminUnit

UnitType

SHORT

DE

 

Unit Type

SEWCatchmentArea

CatchmentNumber

TEXT, 40

Basic

 

Catchment No

SEWCatchmentArea

ConnectedObject_ref

GUID

Basic

 

Connected Object

SEWContract

BuildingSupervisor

TEXT, 60

Basic

 

Building Supervisor

SEWContract

CodeSystem

SHORT

Basic

SEW_CodeSystem (1)

Code System

SEWContract

Contract

TEXT, 60

Basic

 

Contract

SEWContract

ContractCode

SHORT

Basic

 

Contract Code

SEWContract

ContractDATE

DATE

Basic

 

Contract DATE

SEWContract

ContractNumber

TEXT, 40

Basic,

DE

 

ContractNumber

SEWContract

Contractor

TEXT, 60

Basic

 

Contractor

SEWContract

ContractStatus

SHORT

Basic

SEW_ContractStatus (1)

Contract Status

SEWContract

Deleted

SHORT

DE

 

Deleted

SEWContract

InpectionLocation

TEXT, 40

Basic

 

Inspect Location

SEWContract

InspectionEndDATE

DATE

Basic

 

End of Inspection

SEWContract

InspectionIntention

SHORT

Basic

SEW_InspIntention (1)

Inspection Intention

SEWContract

InspectionType

SHORT

Basic

SEW_InspContract (1)

Inspection Type

SEWContract

ObjectManagement

TEXT, 60

Basic

 

Object Management

SEWContract

QualityAssurance

TEXT, 60

Basic

 

Quality Assurance

SEWContract

RehabilitationContractType

SHORT

Basic

SEW_SanContractType (1)

Rehabilitation Contract Type

SEWContract

Software

TEXT, 40

Basic

 

Software

SEWContract

SoftwareVersion

TEXT, 10

Basic

 

Software Version

SEWImportLog

BaseData

SHORT

DE

 

Base Data

SEWImportLog

ConditionData

SHORT

DE

 

Condition Data

SEWImportLog

ImportDate

DATE

Basic

 

Import Date

SEWImportLog

ImportFile

TEXT, 255

Basic

 

Import File

SEWImportLog

ImportVersion

TEXT, 255

Basic

 

Import Version

SEWLocalDistrict

Name

TEXT, 255

Basic,

DE

 

Name

SEWLocalDistrict

Town_ref

GUID

Basic

 

Town ref

SEWNodeInspection

CUS_class

SHORT

 

 

CUS_class

SEWNodeInspection

HorizontalReferencePoint

SHORT

DE

SEW_HorizontalReference (1)

Horizontal Reference Point

SEWNodeInspection

InspectionDate

DATE

Basic

 

Inspection Date

SEWNodeInspection

InspectionMethod

SHORT

Basic

SEW_InspectionType (1)

Inspection Method

SEWNodeInspection

MainDamage

TEXT, 10

DE

 

Main Damage

SEWNodeInspection

MainQuantification

DOUBLE

DE

 

Main Quantification

SEWNodeInspection

MaxSZeAuto

SHORT

DE

 

MaxSZeAuto

SEWNodeInspection

Node_ref

GUID

Basic

 

Node_ref

SEWNodeInspection

PreliminaryNumber

SHORT

DE

 

Preliminary Number

SEWNodeInspection

RatingMethod

SHORT

DE

SEW_ClassificationMethod (1)

Rating Method

SEWNodeInspection

VerticalReferencePoint

SHORT

DE

SEW_VerticalReference (1)

Vertical Reference Point

SEWNodeInspection

VIdeoReference

TEXT, 30

Basic,

DE

 

Video  Reference

SEWNodeInspection

VideoReferenceType

SHORT

DE

SEW_TypeReference (1)

Video Reference Type

SEWNodeInspection

VideoStorage

SHORT

DE

SEW_VideoStorage (1)

Video Storage

SEWNodeInspection

Waterflow

SHORT

DE

SEW_IYS2017WaterRetentionType (1)

Waterflow

SEWNodeInspection

Weather

SHORT

DE

SEW_WeatherType (1)

Weather

SEWPipeInspection

AdditionalPoints

SHORT

DE

 

Additional Points

SEWPipeInspection

ClassAutomatic

SHORT

DE

 

Class Automatic

SEWPipeInspection

ClassManually

SHORT

DE

 

Class Manually

SEWPipeInspection

Cleaning

SHORT

DE

VGU_YesNo (1)

Cleaning

SEWPipeInspection

CommentInspection

TEXT, 255

Basic,

DE

 

Comment Inspection

SEWPipeInspection

ConectionEdgeType

SHORT

DE

SEW_SEWLineEdgeType (1)

Connection Edge Type

SEWPipeInspection

ConnectedTo

TEXT, 30

DE

 

Connected To

SEWPipeInspection

ConnectionKind

SHORT

DE

SEW_ConnectionKind (1)

Connection Kind

SEWPipeInspection

ConnectionPosition

DOUBLE

CH,

DE

VGU_ClockFacePosition (0)

Connecting Position

SEWPipeInspection

DimensionHeight

SHORT

Basic,

DE

 

Dimension Height

SEWPipeInspection

EndNode

TEXT, 30

Basic,

DE

 

End Node

SEWPipeInspection

EndNodeType

SHORT

DE

SEW_NodeType (1)

Type End Node

SEWPipeInspection

FinalNumber

SHORT

DE

 

Final Number

SEWPipeInspection

InspectionDirection

SHORT

Basic

SEW_InspectionDirection (1)

Inspection Direction

SEWPipeInspection

InspectionLength

DOUBLE

Basic

 

Inspection Length

SEWPipeInspection

InspectionTechnology

SHORT

DE

SEW_InsepctionTechnic (1)

Inspection Technology

SEWPipeInspection

InspectionTime

DATE

DE

 

Inspection Time

SEWPipeInspection

Inspector

TEXT, 40

DE

 

Inspector

SEWPipeInspection

LengthPipePart

DOUBLE

DE

 

Length Pipe Part

SEWPipeInspection

Line_ref

GUID

Basic

 

Line_ref

SEWPipeInspection

MaterialSource

SHORT

DE

SEW_Source (1)

Material Source

SEWPipeInspection

PipeType

SHORT

DE

SEW_PipeType (1)

Pipe Type

SEWPipeInspection

ProfileSource

SHORT

DE

SEW_SourceProfile (1)

Profile Source

SEWPipeInspection

RatingDate

DATE

DE

 

Rating Date

SEWPipeInspection

ReferencePoint

SHORT

DE

SEW_PositionReference (1)

Reference Point

SEWPipeInspection

Result

SHORT

DE

SEW_ResultType (1)

Result

SEWPipeInspection

SewerTypeISY

SHORT

DE

SEW_SewerType (1)

Sewer Type ISY

SEWPipeInspection

StartNode

TEXT, 30

Basic,

DE

 

Start Node

SEWPipeInspection

StartNodeTYpe

SHORT

DE

SEW_NodeType (1)

Type Start Node

SEWPipeInspection

Temperature

SHORT

DE

 

Temperature

SEWPipeInspection

TestDate

DATE

DE

 

Test Date

SEWPipeInspection

TestLength

DOUBLE

DE

 

Test Length

SEWPipeInspection

TestMethod

SHORT

DE

SEW_TestMethod (1)

Test Method

SEWPipeInspection

TestReason

SHORT

DE

SEW_TestReason (1)

Test Reason

SEWPipeInspection

TestScope

SHORT

DE

SEW_TestExtend (1)

Test Scope

SEWPipeInspection

TestSpecification

SHORT

DE

SEW_IYS2017TestSpecification (1)

Test Specification

SEWPipeInspection

vorDeltaP

DOUBLE

DE

 

vorDeltaP

SEWPipeInspection

vorhDeltaV

DOUBLE

DE

 

vorhDeltaV

SEWPipeInspection

zulDeltaV

DOUBLE

DE

 

zulDeltaV

SEWPipeInspection

zulDetlaP

DOUBLE

DE

 

zulDetlaP

SEWProfile

DimensionWidth

SHORT

Basic,

CH,

DE

 

Dimension Width

SEWProfile

ProfileTypeIsy

SHORT

Basic

SEW_SEWLineLinePipeProfileType (1)

Profile Type Isy

SEWProfile

SDR

SHORT

DE

SEW_SEWLineSDR (1)

Standard Dimension Ratio

SEWProfile

SpecialProfileExist

SHORT

Basic

 

SpecialProfile Exists

SEWProfileCoordinates

ProfileID

LONG

Basic,

DE

 

Profile ID

SEWProfileCoordinates

ProfileName

TEXT, 40

Basic

 

Profile Name

SEWProfileCoordinates

SeqNo

SHORT

Basic

 

Seq- Number

SEWProfileCoordinates

X

DOUBLE

Basic

 

X

SEWProfileCoordinates

Y

DOUBLE

Basic

 

Y

SEWRoad

RoadID

LONG

DE

 

Road ID

SEWSegment

AdministrativeUnit_ref

GUID

DE

 

Administrative Unit ref

SEWSegment

BuildingYear

TEXT, 4

DE

 

Building Year

SEWSegment

ClearHeight

DOUBLE

Basic,

DE

 

Clear Height

SEWSegment

ClearWidth

DOUBLE

Basic,

DE

 

Clear Width

SEWSegment

DocumentDirection

SHORT

Basic,

DE

SEW_DocumentationDirection (1)

Document direction

SEWSegment

MaterialSegment

SHORT

DE

SEW_SEWLineLinePipeProfileType (1)

Material Segment

SEWSegment

Profil_ref

GUID

Basic

 

Profile Ref

SEWSegment

SegmentName

TEXT, 40

Basic

 

Segment Name

SEWSegment

StartPosition

DOUBLE

Basic,

DE

 

Start Position

SEWSurroundings

AssetID

TEXT, 80

Basic,

DE

 

Asset ID

SEWSurroundings

Comment

TEXT,

DE

 

Comment

SEWSurroundings

CommentGeneral

TEXT, 255

DE

 

Comment

SEWSurroundings

DateHHGW

DATE

DE

 

DateHHGW

SEWSurroundings

Description

TEXT,

DE

 

Descritption

SEWSurroundings

MaxGWLevel

DOUBLE

DE

 

Max Grounwater Level

SEWSurroundings

RelevantKfValue

DOUBLE

DE

 

Relevant Kf Value

SEWSurroundings

RelevantSoilType

TEXT, 4

DE

 

Relevant Soil Type

SEWSurroundings

SlopeClass

SHORT

DE

SEW_GradientClass (1)

Slope Class

SEWSurroundings

Usage

SHORT

DE

SEW_AreaUsage (1)

Usage

SEWTown

Town

TEXT, 255

Basic

 

Town

SEWTract

TractName

TEXT, 255

DE

 

Tract Name

SEWTract

TractNumber

TEXT, 255

DE

 

Tract Number

SEWTreatmentPlantCatchmentArea

ResidentsConnected

LONG

CH

 

Residents Connected

SEWTreatmentPlantCatchmentArea

ResidentsTotal

LONG

CH

 

Residents Total

SEWTreatmentPlantCatchmentArea

SIA405_ID

TEXT, 16

CH

 

SIA ID

SEWVideo

AbsolutPath

SHORT

DE

 

Absolut Path

SEWVideo

Endframe

LONG

DE

 

Endframe

SEWVideo

FileName

TEXT, 255

DE

 

File Name

SEWVideo

FPS

SHORT

DE

 

FPS

SEWVideo

Startframe

LONG

DE

 

Startframe

SEWVideo

Video

TEXT, 255

DE

 

Video

SEWVideo

VideoFileName

TEXT, 255

DE

 

Video Filename

SEWVideo

VideoPath

TEXT, 255

DE

 

Video Path

SEWVideo

VideoReference

TEXT, 30

DE

 

Video  Reference

SEWVideoCalibration

MPEGFrameNr

LONG

DE

 

MPEGFrameNr

SEWVideoCalibration

TcFrameNr

LONG

DE

 

TcFrameNr

SEWVideoCalibration

Video_ref

GUID

DE

 

Video_ref

SEWVideoObject

Asset_ref

GUID

DE

 

Asset_ref

SEWVideoObject

AssetName

TEXT, 40

Basic,

DE

 

AssetName

SEWVideoObject

Inspection_ref

GUID

DE

 

Inspection_ref

SEWVideoObject

ObjectType

SHORT

DE

SEW_IYS2017FacilityType (1)

Object Type

SEWProfileCoordinates

created_user

TEXT, 255

Basic

 

Created user

SEWTargetSewerageSystemZone

last_edited_user

TEXT, 255

Basic

 

Last edited user

 

 

© 2025 VertiGIS GmbH Germany. All Rights Reserved. | Privacy Center | Imprint
Documentation Version 1.5