Share
 
 

Site Feature Class

The Site feature class is used to enclose assemblies and make them reachable by fittings, valves, etc.

  • Feature class — WW_SITE
  • Feature type — Attribute
Name Data Type Description

ADDRESSOFMANUFACTURER

Varchar2

The site manufacturer’s address.

DATA_TRANSMISSION

Number

Data transmission? [yes/no].

DATE_ACQUIRED

Date

The date when the data was acquired.

DATE_CREATION

Date

The date when the item was created.

DATE_STARTUP

Date

The date when responsibility of the item was taken.

FID_CONSESSIONAIRE

Number

The concessionaire of this item.

Related to:

  • WW_CONTACT

FID_ENV_PARAMETERS

Number

The relation to the environmental parameters.

Related to:

  • WW_ENV_PARAMETERS

FID_INSTALLER

Number

The enterprise in charge of building the item.

Related to:

  • WW_CONTACT

FID_LOCATION

Number

The location of the item (street).

Related to:

  • WW_LOCATION

FID_MAINTENANCE

Number

The company that is responsible for the maintenance of this item.

Related to:

  • WW_CONTACT

FID_OPERATOR

Number

The operator of this item.

Related to:

  • WW_CONTACT

FID_OWNER

Number

The owner of this item.

Related to:

  • WW_CONTACT

FID_SITE

Number

Use to store the site in site.

Related to:

  • WW_SITE

FID_TREATMENT_PLANT

Number

The treament plant related to this item. See Treatment Plant

Related to:

  • WW_TREATMENT_PLANT

FOOTPRINT

Number

The site footprint.

GROUND_ELEVATION

Number

The elevation of the item relative to the ground, measured in meters.

HOUSE

Varchar2

The house number.

HOUSE_SUPPLEMENT

Varchar2

The house number supplement.

ID_ACCURACY

Number

How the current position of the item was determined. For example, exactly, by positioning, unknown, or inexactly.

Related to:

  • WW_ACCURACY_TBD

ID_CONDITION

Number

The condition of the item. For example, broken, leaking, etc.

Related to:

  • WW_CONDITION_TBD

ID_DISPOSITION_STATE

Number

The disposition state of the item. For example, death, planed, etc.

Related to:

  • WW_DISPOSITION_STATE_TBD

ID_FOUNDATION

Number

The type of foundation.

Related to:

  • WW_FOUNDATION_TBD

ID_FUNCTION

Number

The function ID.

Related to:

  • WW_FUNCTION_TBD

ID_HYDRAULIC_FUNCTION

Number

The hydraulic function of the item.

Related to:

  • WW_HYDRAULIC_FUNCTION_TBD

ID_LAYING_TYPE

Number

Describes how the item was placed on its location. For example, open ditch, laying on ground, etc.

Related to:

  • WW_LAYING_TYPE_TBD

ID_LOCATION

Number

The street location of this item.

Related to:

  • WW_LOCATION

ID_MARKER_TYPE

Number

Describes how the item is marked on the ground. For example, marker, magnetic tape, tape, etc.

Related to:

  • WW_MARKER_TYPE_TBD

ID_MATERIAL

Number

The material used to construct this item.

Related to:

  • WW_MATERIAL_TBD

ID_OWNERSHIP

Number

The owner of this item.

Related to:

WW_OWNERSHIP_TBD

ID_PLANT_COMBINATION

Number

The plant combination ID.

Related to:

WW_PLANT_COMBINATION_TBD

ID_TYPE

Number

Describes the kind of site.

Related to:

WW_SITE_TYPE_TBD

IS_BYPASS

Number

Is there a bypass?

IS_PLANT_COMBINATION

Number

Is there a plant combination?

IS_HANDOVER

Number

Is there a handover?

LISA_GUID

Varchar2

The LISA unique identifier.

LOCATION

Varchar2

A brief description of where the item is located. For example, 1m from the wall.

MANUFACTURER_TYPE

Varchar2

A description of the manufacturer type.

NAME_NUMBER

Varchar2

The name or number of this item.

NAME_NUMBER_1

Varchar2

Additional name number of the item.

NARRATIVE

Varchar2

A description or other unique information concerning the subject item.

SEQUENCEID

Number

The unique sequence identifier.

SERIAL_NUMBER

Varchar2

The unique serial number of the manufacturer.

SERVICE

Varchar2

The service provided by this site.

SITE_DEPTH

Number

The depth dimension of the item, measured in meters.

SITE_LENGTH

Number

The length dimension of the item, measured in meters.

SITE_WIDTH

Number

The width dimension of the item, measured in meters.

SPACE_ABOVE_GROUND

Number

The space above ground, measured in meters.

SPACE_BELOW_GROUND

Number

The space below ground, measured in meters.

UFIS_CONSTRUCTIONNUMBER

Number

The UFIS construction number.

USER_FLAG

Varchar2

An operator defined work area. This attribute can be used by the operator for user defined system processes. It does not effect the subject item's data integrity and should not be used to store the subject item's data.

Was this information helpful?