ArcFM Solution Configuration Guide
Structural Analysis Tables

Version: 10.1

Resource Center Home

ArcFM Structural Analysis allows you to perform "what if" scenarios to evaluate the structural integrity of a support structure and its associated features. These analysis tools rely on lookup tables in the EngAnalysisLookupTables.mdb. This database is installed in the Support folder of the ArcFM Solution installation directory. The tables included in this database are defined below. These tables must be owned by SDE.

 

MMENG_ANCHORCAPACITY

Field

Data Type

Description

Units

How Used

AnchorType

text

Reflects the value chosen by the user in the Type field on the Anchor Properties dialog.

 

Used to look up anchor properties (i.e., torque, holding capacity, shear pins)

Torque

long integer

The appropriate amount of torque for the anchor type.

Ft-lbs

Used in anchor calculations.

HoldingCapacity

long integer

The maximum holding capacity for the anchor type.

lbs

Used in anchor calculations.

ShearPins

long integer

The number of shear pins required for the anchor type.

 

Used in anchor calculations.

 

MMENG_ANCHORPRICE

Field

Data Type

Description

Units

How Used

AnchorType

text

Reflects the value chosen by the user in the Type field on the Anchor Properties dialog.

 

Used to look up price by torque.

Torque

long integer

The appropriate amount of torque for the anchor type.

ft.-lbs.

Used to create unique combination of price and torque.

Price

long integer

The cost of the anchor type.

US $$

Used the choose the lowest priced anchor for the run capacity needed.

 

MMENG_ANCHORSTOCKNUMBER

Field

Data Type

Description

Units

How Used

AnchorType

text

Reflects the value chosen by the user in the Type field on the Anchor Properties dialog.

 

Not currently used.

StockNumber

text

The stock number associated with the anchor type.

 

Not currently used.

 

MMENG_ANCHORTORQUES

Field

Data Type

Description

Units

How Used

SoilClass

text

Reflects the value chosen by the user in the Soil Class field.

 

The value selected in the Soil Class field is used to filter the list of available anchors.

AnchorType

text

Reflects the value chosen by the user in the Type field on the Anchor Properties dialog.

 

Used to create a unique combination of anchor type and torque by soil type.

Torque

long integer

The appropriate amount of torque for the anchor type.

ft.-lbs.

Used to create a unique combination of anchor type and torque by soil type.

 

MMENG_ANCHORTYPES

Field

Data Type

Description

Units

How Used

AnchorType

text

This field populates the pull down menu for the Type field in the Anchor Properties dialog.

 

Not currently used.

 

MMENG_CONDMATLTRANSLATION

Field

Data Type

Description

Units

How Used

GeoMaterial

text

Material type in the geodatabase.

 

Used to auto-populate engineering data grids with geodatabase materials.

EngMaterial

text

Material type in the engineering calculations tables.

 

Used to auto-populate engineering data grids with geodatabase materials.

 

MMENG_CONDMATLVV

Field

Data Type

Description

Units

How Used

ConductorMaterial

text

Reflects the conductor material.

 

The conductor material is shown along with the size in the Type field in the Span Properties and Add Span dialogs (Figure 1).

 

MMENG_CONDSIZETRANSLATION

Field

Data Type

Description

Units

How Used

GeoSize

text

Size in the geodatabase.

 

Used to auto-populate engineering data grids with geodatabase size.

EngSize

text

Size in the engineering calculations tables.

 

Used to auto-populate engineering data grids with geodatabase size.

 

MMENG_CONDSIZEVV

Field

Data Type

Description

Units

How Used

ConductorSize

text

Reflects the size of the conductor.

 

The conductor material is shown along with the size in the Type field in the Span Properties and Add Span dialogs (Figure 1).

 

MMENG_CONDTENSION

Field

Data Type

Description

Units

How Used

RulingSpan

long integer

Reflects the value selected in the Design Ruling Span field on the Ruling Span tab.

ft.

This value is used as the basis for the sag and tension computations of the conductor.

LoadingDistrict

text

The loading district of the pole. This field reflects the value chosen by the user in the Loading District field.

 

The chosen value for a pole is used to retrieve the correct values from other MMENG tables.

ConductorSize

text

Reflects the size of the conductor. The size is shown along with the conductor material in the Type field in the Conductor grid (Figure 1).

 

Used to calculate the Wind Moment on Pole.

ConductorMaterial

text

Reflects the conductor material. The conductor material is shown along with the size in the Type field in the Conductor grid (Figure 1).

 

Used in pole moment calculations.

Stranding

text

 

 

Not currently used.

SortSize

text

 

 

Not currently used.

Sag_at_Max_Tension

text

Sag at conductor maximum tension.

feet

Used to calculate conductor clearance.

Tension_at_Max_Sag

text

 

lbs.

Not currently used.

MaxSag

text

 

 

Not currently used.

MaxCondTension

long integer

Maximum conductor tension.

lbs.

Used in pole moment calculations.

WeightPerFoot

double

Weight of one foot of conductor.

lbs.-ft.

Used in pole moment calculations.

 

MMENG_CONDTRANSWINDLOAD

Field

Data Type

Description

Units

How Used

LoadingDistrict

text

The loading district of the pole. This field reflects the value chosen by the user in the Loading District field.

 

Used to calculate the Wind Moment on Pole.

ConductorSize

text

Reflects the size of the conductor. The size is shown along with the conductor material in the Type field in the Conductor grid (Figure 1).

 

Used to calculate the Wind Moment on Pole.

ConductorMaterial

text

Reflects the conductor material. The conductor material is shown along with the size in the Type field in the Conductor grid (Figure 1).

 

Used to calculate the Wind Moment on Pole.

SortSize

long integer

 

 

Not currently used.

TransverseWindLoad

double

Wind load of the conductor loading district.

lbs.

Used in the wind load calculation.


Figure 1, The Type field displays the conductor’s size and material

 

MMENG_DEVICEWEIGHT

Field

Data Type

Description

Units

How Used

ModelName

text

ArcFM object model name that identifies the device.

 

Used to look up device weight by type and rating.

ManufacturerModel

text

Name of manufacturer model for device.

 

Uniquely identifies a device and weight. Used in buckling calculations.

SerialNumber

text

Serial number of the device model.

 

Uniquely identifies a device and weight. Used in buckling calculations.

Rating

text

Rating of the device (e.g., 25 kVA).

 

Uniquely identifies a device and weight. Used in buckling calculations.

DeviceType

text

Distinguishes like devices by type.

 

Uniquely identifies a device and weight. Used in buckling calculations.

Weight

double

Weight of device.

lbs

Used in buckling calculations.

Diameter

double

 

 

Not currently used.

AttachmentHeight

double

 

 

Not currently used.

 

MMENG_GUYCABLEDIAMETERVV

Field

Data Type

Description

Units

How Used

Diameter_as_Text

text

Diameter of the guy wire.

 

Look up values for guy types to populate the guy properties.

 

MMENG_GUYCABLEMATERIALVV

Field

Data Type

Description

Units

How Used

Material

text

Material of a guy wire.

 

Look up values for guy types to populate the guy properties.

 

MMENG_GUYCABLESTRENGTH

Field

Data Type

Description

Units

How Used

Diameter_as_Text

text

Diameter of the guy.

 

Look up values for guy types to populate the guy properties.

Material

text

Material type of the guy wire.

 

Used to uniquely identify the rated breaking strength for a given guy material and diameter.

Diameter

double

Diameter of the guy wire.

in.

Used to uniquely identify the rated breaking strength for a given guy material and diameter.

RatedBreakingStrength

double

Total Guy Capacity for a guy.

ft.-lbs.

This value is displayed in the Guys and Anchors field on the Bisector Guy and Dead End Guy tabs.

 

MMENG_GUYWIRESIZETRNSLATN

Field

Data Type

Description

Units

How Used

GeoWireSize

text

Wire size in the geodatabase.

in.

Used to auto-populate engineering data grids with geodatabase wire size.

EngWireSize

text

Wire size in the engineering calculation tables.

in.

Used to auto-populate engineering data grids with geodatabase wire size.

 

MMENG_GUYWRSTRNGTHTRNSLATN

Field

Data Type

Description

Units

How Used

GeoWireStrength

text

Wire strength in the geodatabase.

ft.-lbs.

Used to auto-populate engineering data grids with geodatabase wire strength.

EngWireStrength

text

Wire strength in the engineering calculation tables.

ft.-lbs.

Used to auto-populate engineering data grids with geodatabase wire strength.

 

MMENG_INSULATORSTRENGTH

Field

Data Type

Description

Units

How Used

Insulator

text

This field lists the types of insulators available for selection on the Cross Arm Tab (Figure 3).

 

Used to populate the drop down box in the Insulator field on the Cross Arm tab.

Description

text

This field provides a description of the insulators.

 

Used to display insulator strength on the Cross Arm tab.

WorkingStrength

double

Rated strength of insulator.

ft.-lbs.

Used when comparing the load of the wire/conductor to the strength of the insulator(s). If the load of the conductor exceeds the strength of the insulator(s), the Insulator fields are highlighted in red on the Cross Arm tab.

 

MMENG_LOADINGDISTRICTS

Field

Data Type

Description

Units

How Used

LoadingDistrict

text

This lookup table populates the Loading District field on the Transverse Pole Strength tab.

 

The chosen value for a pole is used to retrieve the correct values from other MMENG tables.

RadialIce

double

The amount of radial ice associated with the loading district.

in.

Not currently used.

WindPressure

double

The amount of wind pressure associated with the loading district.

lbs/sq. ft.

Not currently used.

Temperature

double

The temperature associated with the loading district.

 

Not currently used.

K

double

 

 

Not currently used.

 

MMENG_NESCLEARANCE

Field

Data Type

Description

Units

How Used

ClearanceCategory

text

The NESC clearance category value.

 

If NESC is selected as the Clearance Standard, this field is used to populate the Clearance Category field.

NeutralWire

float

Clearance value of the neutral wire.

feet

Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid.

SecondaryWire

float

Clearance value of the secondary wire.

feet

Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid.

PrimaryWire

float

Clearance value of the primary wire.

feet

Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid.

 

MMENG_PINSTOCKNUMBER

Field

Data Type

Description

Units

How Used

Pin

text

The types of pins available for section on the Cross Arm tab (Figure 3).

 

Not currently used.

StockNumber

text

The stock number associated with the pin.

 

Not currently used.

 

MMENG_PINSTRENGTH

Field

Data Type

Description

Units

How Used

Pin

text

The types of pins available for selection on the Cross Arm tab (Figure 3).

 

Used to populate the drop-down lists in the Pin fields on the Cross Arm tab.

Description

text

A description of the pin.

 

Used to populate the drop-down lists in the Pin fields on the Cross Arm tab.

WorkingStrength

long integer

Rated breaking strength of the pin.

ft.-lbs.

Used when comparing the load of the wire/conductor to the strength of the pin(s). If the load of the conductor exceeds the strength of the pin(s), the field(s) are highlighted in red.

 

MMENG_POLECLASSES

Field

Data Type

Description

Units

How Used

Class

long integer

This field populates the pole’s Class field (Figure 2).

 

This value is used along with the Height and Material values to display the Maximum Resisting Moment of the pole.

MinTopCircumference

double

 

in.

Not currently used.

MaxHorzLbs2ftFromTop

double

 

 

Not currently used.

 

MMENG_POLECLASSTRANSLATION

Field

Data Type

Description

Units

How Used

EngPoleClassTranslation

long integer

Pole class in the engineering calculations tables.

 

Used to auto-populate engineering data grids with geodatabase pole class.

GeoPoleClassTranslation

text

Pole class in the geodatabase.

 

Used to auto-populate engineering data grids with geodatabase pole class.

 

MMENG_POLEHEIGHTSETDEPTH

Field

Data Type

Description

Units

How Used

Height

long integer

This field populates the pole’s Height field (Figure 2).

ft.

This value is used along with the Material and Class values to display the Maximum Resisting Moment of the pole.

SettingDepth

double

The optimum setting depth for the height. The user may change the value in this field in the user interface.

in.

This value is used to calculate Total Bending Moment.


Figure 2, Pole Properties

 

MMENG_POLEHEIGHTTRANSLATION

Field

Data Type

Description

Units

How Used

GeoPoleHeight

text

Pole height in the geodatabase.

ft.

Used to auto-populate engineering data grids with geodatabase pole height.

EngPoleHeight

long integer

Pole height in the engineering calculation tables.

ft.

Used to auto-populate engineering data grids with geodatabase pole height.

 

MMENG_POLEMATERIALTRANSLATION

Field

Data Type

Description

Units

How Used

EngPoleMaterial

text

Pole material in the engineering calculation tables.

 

Used to auto-populate engineering data grids with geodatabase pole material.

GeoPoleMaterial

text

Pole material in the geodatabase.

 

Used to auto-populate engineering data grids with geodatabase pole material.

 

MMENG_POLESETDEPTHADJUST

Field

Data Type

Description

Units

How Used

ModelName

text

Model name of device on pole.

 

Used to adjust the setting depth of a pole based on the device.

Description

text

Description of the device.

 

Not currently used.

SetDepthAdjust

long integer

The amount by which the depth of the pole will be adjusted.

in.

Used to adjust the setting depth of a pole based on the device.

 

MMENG_POLEWINDMOMENT

Field

Data Type

Description

Units

How Used

Species

text

The species of wood used for the pole.

 

Used to find the appropriate wind moment for a specific species, height, class, and loading district.

Height

long integer

Height of the pole.

ft.

Used to find the appropriate wind moment for a specific species, height, class, and loading district.

Class

long integer

Class of the pole.

 

Used to find the appropriate wind moment for a specific species, height, class, and loading district.

LoadingDistrict

text

The loading district of the pole. This field reflects the value chosen by the user in the Loading District field.

 

Used to find the appropriate wind moment for a specific species, height, class, and loading district.

WindMoment

long integer

The wind moment on the pole only.

 

Used to calculate wind moment on the pole based on the loading district.

 

MMENG_REACLEARANCE

Field

Data Type

Description

Units

How Used

ClearanceCategory

text

The REA clearance category value.

 

If REA is selected as the Clearance Standard, this field is used to populate the Clearance Category field.

NeutralWire

long integer

Clearance value of the neutral wire.

ft.

Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid.

SecondaryWire

long integer

Clearance value of the secondary wire.

ft.

Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid.

Primary1Wire

long integer

Clearance value of the primary wire.

ft.

Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid.

Primary2Wire

long integer

Clearance value of the primary wire

ft.

Used to calculate clearance results. If the results are less than 0, the conductor fails and is highlighted in red on the Conductors grid.

 

MMENG_SOILCLASS

Field

Data Type

Description

Units

How Used

SoilClass

text

This field populates the pull down menu for the Soil Class field (Overcapacity Factors).

 

Used to look up values associated with soil class codes.

 

MMENG_SOILCLASSDESCRIPTION

Field

Data Type

Description

Units

How Used

SoilClass

text

Reflects the value chosen by the user in the Soil Class field.

 

The value selected in the Soil Class field uses the MMENG_ANCHORTORQUES table to filter the list of available anchors.

EngineeringDescription

text

Engineering description for the soil class.

 

Used to display the engineering descriptions of soil classes by soil class codes.

FamiliarName

text

 

 

Not currently used.

 

MMENG_VOLTAGETRANSLATION

Field

Data Type

Description

Units

How Used

GeoVoltage

text

Voltage in the geodatabase.

 

Used to auto-populate engineering data grids with geodatabase voltage.

EngVoltage

text

Voltage in the engineering calculation tables.

 

Used to auto-populate engineering data grids with geodatabase voltage.

 

MMENG_WDSPCIESULTFIBERSTRESS

Field

Data Type

Description

Units

How Used

Species

text

Populates the pole’s Material field (Figure 2).

 

This value is used along with the Height and Class values to display the Maximum Resisting Moment of the pole.

Abbrev

text

Code used to identify the wood species.

 

Used to look up values for maximum resistance moment calculations.

UltimateFiberStress

double

 

lbs./sq. in.

Not currently used.

 

MMENG_WOODPOLERESISMOMENT

Field

Data Type

Description

Units

How Used

Class

long integer

The value selected in the pole’s Class field.

 

Used to calculate the Maximum Resisting Moment of the pole.

Height

long integer

The value selected in the pole’s Height field.

ft.

Used to calculate the Maximum Resisting Moment of the pole.

Species

text

The value selected in the pole’s Material field.

 

Used to calculate the Maximum Resisting Moment of the pole.

MinCircumferenceAtSixFeet

double

 

in.

Not currently used.

ResistingMoment

long integer

Resisting moment of the pole by height, class, and species.

ft.-lbs.

Used to display resisting moment of the pole. Also used in deflection and buckling calculations.

HTABVGND

double

Height of the pole above ground.

 

Not currently used.

CIRCTOP

double

Circumference of the pole top.

 

Used in pole top deflection and buckling calculations.

CIRCGND

double

Circumference of the pole at the ground.

 

Used in pole top deflection and buckling calculations.

 

MMENG_XARM

Field

Data Type

Description

Units

How Used

DisplayName

text

The name of the configuration as it appears in the Cross Arm Configuration field (Figure 3).

 

Used to populate the drop-down list of the Cross Arm Configuration field on the Cross Arm tab.

Code

text

A unique code that identifies the cross arm configuration.

 

Used in cross arm strength calculations.

BendStress

double

Maximum bending stress for the cross arm.

 

Used to calculate the maximum moment on the cross arm.

DimV

double

Vertical dimension of the cross arm.

 

Used to calculate the maximum moment on the cross arm.

DimH

double

Horizontal dimension of the cross arm.

 

Used to calculate the maximum moment on the cross arm.

BoltDiam

double

Bolt diameter for the cross arm.

in.

Used to calculate the maximum moment on the cross arm.

 

MMENG_XARM_CONFIG

Field

Data Type

Description

Units

How Used

DisplayName

text

The name of the configuration as it appears in the Cross Arm Configuration field (Figure 3).

 

Used to populate the drop-down lists of the Cross Arm Configuration field on the Cross Arm tab.

Code

text

A unique code that identifies the cross arm configuration.

 

Used internally to associate cross arm values to a cross arm configuration.

ImageName

text

The name of the image associated with the selected configuration.

 

Used to display the graphic that corresponds with the selected cross arm configuration. If an image name is listed Designer will attempt to load it from <ArcFM install directory>\Program Files (x86)\Miner and Miner\ArcFM Solution\bin\Graphics. If a path and name is provided, Designer will load the image from that location. If no image name appears or the image name is invalid, or the image path is invalid, Designer will load a default image.

NumWires

short integer

The number of wires associated with the configuration.

 

Used to automatically associate a conductor to a pin position.

DeadEnd

short integer

This field indicates whether the configuration is a dead end. A value of 0 indicates it is NOT a dead end. Any other value indicates that it is a dead end.

 

Used to calculate moments on the cross arms in transverse and dead end cases.

CondAtt1

double

Attachment height of conductor #1.

 

Used to determine the actual moment on the cross arm.

CondAtt2

double

Attachment height of conductor #2.

 

Used to determine the actual moment on the cross arm.

CondAtt3

double

Attachment height of conductor #3.

 

Used to determine the actual moment on the cross arm.

CondAtt4

double

Attachment height of conductor #4.

 

Used to determine the actual moment on the cross arm.


Figure 3, Cross Arm Configuration


Send Comment