Table Of ContentArcGIS Telecom Data Model
Data Dictionary
Revised: August 2007
ArcGIS Telecom Data Model – Data Dictionary
Copyright © 2006 ESRI
All rights reserved.
Printed in the United States of America.
The information contained in this document is the exclusive property of ESRI. This work is protected under United
States copyright law and other international copyright treaties and conventions. No part of this work may be
reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and
recording, or by any information storage or retrieval system, except as expressly permitted in writing by ESRI. All
requests should be sent to Attention: Contracts and Legal Services Manager, ESRI, 380 New York Street, Redlands,
California 92373-8100, USA.
The information contained in this document is subject to change without notice.
U.S. GOVERNMENT RESTRICTED/LIMITED RIGHTS
Any software, documentation, and/or data delivered hereunder is subject to the terms of the License Agreement. In no
event shall the U.S. Government acquire greater than RESTRICTED/LIMITED RIGHTS. At a minimum, use,
duplication, or disclosure by the U.S. Government is subject to restrictions as set forth in FAR §52.227-14 Alternates I,
II, and III (JUN 1987); FAR §52.227-19 (JUN 1987) and/or FAR §12.211/12.212 (Commercial Technical
Data/Computer Software); and DFARS §252.227-7015 (NOV 1995) (Technical Data) and/or DFARS §227.7202
(Computer Software), as applicable. Contractor/Manufacturer is ESRI, 380 New York Street, Redlands, California
92373-8100, USA.
@esri.com, 3D Analyst, ACORN, ADF, AML, ArcAtlas, ArcCAD, ArcCatalog, ArcCOGO, ArcData, ArcDoc,
ArcEdit, ArcEditor, ArcEurope, ArcExplorer, ArcExpress, ArcGIS, ArcGlobe, ArcGrid, ArcIMS, ARC/INFO, ArcInfo,
ArcInfo Librarian, ArcInfo—Professional GIS, ArcInfo—The World's GIS, ArcLocation, ArcLogistics, ArcMap,
ArcNetwork, ArcNews, ArcObjects, ArcOpen, ArcPad, ArcPlot, ArcPress, ArcQuest, ArcReader, ArcScan, ArcScene,
ArcSchool, ArcSDE, ArcSdl, ArcSketch, ArcStorm, ArcSurvey, ArcTIN, ArcToolbox, ArcTools, ArcUSA, ArcUser,
ArcView, ArcVoyager, ArcWatch, ArcWeb, ArcWorld, ArcXML, Atlas GIS, AtlasWare, Avenue, Business Analyst
Online, BusinessMAP, Community, CommunityInfo, Data Automation Kit, Database Integrator, DBI Kit, EDN, ESRI,
ESRI—Team GIS, ESRI—The GIS Company, ESRI—The GIS People, ESRI—The GIS Software Leader, FormEdit,
Geographic Design System, ESRI BIS, Geography Matters, Geography Network, GIS by ESRI, GIS Day, GIS for
Everyone, GISData Server, JTX, MapBeans, MapCafé, MapData, MapObjects, Maplex, MapStudio, ModelBuilder,
MOLE, NetEngine, PC ARC/INFO, PC ARCPLOT, PC ARCSHELL, PC DATA CONVERSION, PC STARTER KIT,
PC TABLES, PC ARCEDIT, PC NETWORK, PC OVERLAY, PLTS, Rent-a-Tech, RouteMAP, SDE, Site·Reporter,
SML, Sourcebook·America, Spatial Database Engine, StreetEditor, StreetMap, Tapestry, the ARC/INFO logo, the
ArcAtlas logo, the ArcCAD logo, the ArcCAD WorkBench logo, the ArcCOGO logo, the ArcData logo, the ArcData
Online logo, the ArcEdit logo, the ArcEurope logo, the ArcExplorer logo, the ArcExpress logo, the ArcGIS logo, the
ArcGIS Explorer logo, the ArcGrid logo, the ArcIMS logo, the ArcInfo logo, the ArcLogistics Route logo, the
ArcNetwork logo, the ArcPad logo, the ArcPlot logo, the ArcPress for ArcView logo, the ArcPress logo, the ArcScan
logo, the ArcScene logo, the ArcSDE CAD Client logo, the ArcSDE logo, the ArcStorm logo, the ArcTIN logo, the
ArcTools logo, the ArcUSA logo, the ArcView 3D Analyst logo, the ArcView Business Analyst logo, the ArcView
Data Publisher logo, the ArcView GIS logo, the ArcView Image Analysis logo, the ArcView Internet Map Server logo,
the ArcView logo, the ArcView Network Analyst logo, the ArcView Spatial Analyst logo, the ArcView StreetMap
2000 logo, the ArcView StreetMap logo, the ArcView Tracking Analyst logo, the ArcWorld logo, the Atlas GIS logo,
the Avenue logo, the BusinessMAP logo, the Community logo, the Data Automation Kit logo, the Digital Chart of the
World logo, the ESRI Data logo, the ESRI globe logo, the ESRI Press logo, The Geographic Advantage, the
Geography Network logo, the MapCafé logo, the MapObjects Internet Map Server logo, the MapObjects logo, the
MOLE logo, the NetEngine logo, the PC ARC/INFO logo, the Production Line Tool Set logo, the RouteMAP IMS
logo, the RouteMAP logo, the SDE logo, The World's Leading Desktop GIS, Water Writes, www.esri.com,
www.esribis.com, www.geographynetwork.com, www.gis.com, www.gisday.com, and Your Personal Geographic
Information System are trademarks, registered trademarks, or service marks of ESRI in the United States, the European
Community, or certain other jurisdictions.
Other companies and products mentioned in the ESRI Web site may be trademarks or registered trademarks of their
respective trademark owners.
ii
ArcGIS Telecom Data Model – Data Dictionary
Table of Contents
1.0 Introduction...........................................................................................................1
2.0 Data Model Classes...............................................................................................2
2.1 Underground Structures............................................................................................3
2.1.1 TelecomComplexEdge........................................................................................3
2.1.2 Conduit...............................................................................................................4
2.1.3 TelecomJunction................................................................................................4
2.1.4 Structure.............................................................................................................5
2.2 Overhead Facilities.............................................................................................7
2.2.1 TelecomFeatureStructure..................................................................................7
2.2.2 AnchorGuy.........................................................................................................7
2.2.3 Pole....................................................................................................................8
2.2.4 PushBrace..........................................................................................................9
2.2.5 Riser.................................................................................................................10
2.3 Cables................................................................................................................10
2.3.1 TelecomSimpleEdge.........................................................................................10
2.3.2 Span..................................................................................................................11
2.3.3 Cable................................................................................................................11
2.3.4 CopperCable....................................................................................................12
2.3.5 FiberCable........................................................................................................12
2.4 Devices..............................................................................................................14
2.4.1 CopperRepeater................................................................................................14
2.4.2 DigitalCrossConnect........................................................................................14
2.4.3 DigitalLoopCarrier...........................................................................................15
2.4.4 FiberInterconnect.............................................................................................15
2.4.5 LoadCoil..........................................................................................................15
2.4.6 MainDistributionFrame....................................................................................16
2.4.7 Multiplexer.......................................................................................................17
2.4.8 OpticalRepeater................................................................................................17
2.4.9 PatchPanel........................................................................................................17
2.4.10 SpliceClosure.................................................................................................18
2.4.11 Splitter............................................................................................................18
2.4.12 Terminal.........................................................................................................19
2.4.13 Termination....................................................................................................20
2.5 Object Classes...................................................................................................20
2.5.1 TelecomObject.................................................................................................20
2.5.2 Attachment.......................................................................................................21
2.5.3 BufferTube.......................................................................................................21
2.5.4 Complements...................................................................................................22
2.5.5 DuctObject.......................................................................................................22
2.5.6 Duct..................................................................................................................23
2.5.7 Innerduct..........................................................................................................23
2.5.8 Fiber.................................................................................................................24
2.5.9 Location...........................................................................................................24
iii
ArcGIS Telecom Data Model – Data Dictionary
2.5.10 Maintenance Loop.........................................................................................25
2.5.11 PortObject......................................................................................................25
2.5.12 DLCPort.........................................................................................................26
2.5.13 DXCPort........................................................................................................26
2.5.14 FICPort...........................................................................................................26
2.5.15 MUXPort........................................................................................................27
2.5.16 OptRptrPort....................................................................................................27
2.5.17 PatchPanelPort...............................................................................................27
2.5.18 SplitterPort.....................................................................................................28
3.0 Data Model Domains and Relationships...........................................................29
3.1 Domains..................................................................................................................29
3.1.1 AnchorRodType...............................................................................................29
3.1.2 AnchorType.....................................................................................................29
3.1.3 Assembly Framing Type..................................................................................30
3.1.4 Assembly Framing Type..................................................................................30
3.1.5 Availability Indicator.......................................................................................30
3.1.6 CableCoreType................................................................................................31
3.1.7 ConduitMaterial...............................................................................................31
3.1.8 EnabledDomain................................................................................................32
3.1.9 FiberBufferColors............................................................................................32
3.1.10 FiberMode......................................................................................................33
3.1.11 FibersPerBuffer..............................................................................................33
3.1.12 FiberStatus.....................................................................................................33
3.1.13 Foreign Attachment Owner............................................................................34
3.1.14 GuyMaterial...................................................................................................34
3.1.15 GuyRatingType..............................................................................................34
3.1.16 Measured Length...........................................................................................35
3.1.17 MountType.....................................................................................................35
3.1.18 MUXType......................................................................................................35
3.1.19 NumberOfBuffers..........................................................................................36
3.1.20 NumberOfFibers............................................................................................36
3.1.21 PlacementType...............................................................................................37
3.1.22 NumberOfCopperPairs..................................................................................37
3.1.23 PoleClass........................................................................................................38
3.1.24 Pole Foundation Type....................................................................................38
3.1.25 PoleHeight......................................................................................................39
3.1.26 PoleMaterial...................................................................................................39
3.1.27 PoleTreatmentType........................................................................................40
3.1.28 PortType.........................................................................................................40
3.1.29 RiserMaterial..................................................................................................41
3.1.30 SpliceType.....................................................................................................41
3.1.31 SplitterRatios..................................................................................................41
3.1.32 StrandSizes.....................................................................................................42
3.1.33 TerminalType.................................................................................................42
3.1.34 ULS Size........................................................................................................43
3.1.35 Yes/No Indicator............................................................................................43
iv
ArcGIS Telecom Data Model – Data Dictionary
3.1.36 TerminationType............................................................................................43
3.2 Relationships...........................................................................................................45
3.2.1 BufferTubeContainsFiber................................................................................45
3.2.2 CableHasComplements....................................................................................45
3.2.3 ConduitHasCopperCable.................................................................................45
3.2.4 ConduitHasDuct...............................................................................................46
3.2.5 ConduitHasFiberCable.....................................................................................46
3.2.6 Conduit_Structure............................................................................................46
3.2.7 CopperRepeaterHasComplements...................................................................46
3.2.8 DCCHasComplements.....................................................................................47
3.2.9 DCCHasPorts...................................................................................................47
3.2.10 DLCHasPorts.................................................................................................47
3.2.11 DuctHasCopperCable....................................................................................48
3.2.12 DuctHasFiberCable........................................................................................48
3.2.13 DuctHasInnerduct..........................................................................................48
3.2.14 FiberCableHasBufferTube.............................................................................49
3.2.15 FIberCableHasMaintLoop.............................................................................49
3.2.16 FICHasPorts...................................................................................................49
3.2.17 InnerductHasCopperCable.............................................................................49
3.2.18 InnerductHasFiberCable................................................................................50
3.2.19 LoadCoilHasComplements............................................................................50
3.2.20 MuxHasPorts..................................................................................................50
3.2.21 OPTRHasPorts...............................................................................................51
3.2.22 PatchPanelHasPorts.......................................................................................51
3.2.23 PoleHasAttachment........................................................................................51
3.2.24 SpanHasFiberCable........................................................................................51
3.2.25 SpanHasConduit............................................................................................52
3.2.26 SplitterHasPorts.............................................................................................52
3.2.27 TerminalHasComplements............................................................................52
3.2.28 TerminalHasLocation....................................................................................53
Appendix A – ArcGIS Data Types................................................................................54
v
ArcGIS Telecom Data Model – Data Dictionary
1.0 Introduction
ArcGIS Telecom contains a ready-to-use data model that can be configured and
customized to meet the needs of ESRI users that design and maintain telecommunications
networks and associated infrastructure.
Diagram 1.1 ArcGIS Telecom Logical Model Diagram
1
ArcGIS Telecom Data Model – Data Dictionary
2.0 Data Model Classes
The review of each class will contain the following review items:
(cid:131) Type – Whether it is an abstract or concrete class, and if concrete - feature or
object class.
(cid:131) Inherits From – What abstract classes the class inherits from in the model.
(cid:131) Geometry – If it is a feature class, the geometry type.
(cid:131) Attributes – The attributes for the class, the aliases, data types, and attribute
descriptions.
(cid:131) Subtypes – The subtypes for the class and their descriptions.
(cid:131) Relationships – The relationships which the class participates in and why.
(cid:131) Notes – Supplemental information which helps to describe the class.
Using the review items listed above, the following is the table structure which will be
used to provide information about each class:
Class Name <Name>
Type
Inherits From
Geometry
Attributes Example:
Comments – narrative (Alias is in italics) – <Text, 100> - (Data Type is
in brackets) This is the definition here.
Subtypes
Relationships
Notes
2
ArcGIS Telecom Data Model – Data Dictionary
2.1 Underground Structures
This section is comprised of Underground Structures which are part of the Telecom data
model. There are two feature classes – Conduit and Structure.
The underground system consists of ducts, direct buried cables, or pipes extending
between vaults or manholes. New conductor and telephone cable are often installed
underground in congested areas. Conductors and cables can be drawn or pulled from
manhole locations for repairs or changes.
2.1.1 TelecomComplexEdge
TelecomComplexEdge is an abstract class whose attributes are inherited by complex edge
feature classes in the model. These feature classes include Conduit, CopperCable and
FiberCable. The following table provides information regarding the
TelecomComplexEdge Abstract class, with attributes, aliases, data types and
descriptions.
Class Name TelecomComplexEdge
Type Abstract class
Inherits From ComplexEdgeFeature
Geometry Not applicable
Attributes WorkOrderID – Work Order ID - <text, 20> - Utility identifier of work order
ProjectNumber – Project Number - <text, 20> - The project number
identifier.
ProjectName – Project Name - <text, 20> - The project name.
CLLI - Common Language Location Identifier - <text, 20> - Code
descriptor used to identify telecommunications switches, interconnections,
and other network elements and their locations.
Manufacturer – Manufacturer - <text, 20> - Manufacturer of the
TelecomComplexEdge
PartNumber – Part Number - <text, 20> - Manufacturer’s part number.
CalculatedLength – Calculated Length – <double> - The calculated
length of the conduit segment.
MeasuredLength – Measured Length - <double> - The code for the
measured length of the conduit segment. A range domain is applied
constraining between 1 – 10,000.
AccountCode – Account Code - <text, 20> - The Account Code which the
Conduit is referenced.
InstallationDate – Installation Date - <date> - The date of installation.
IPID – Item of Plant ID - <long integer> - The unique identifier for the Plant
ID system.
MaterialCost – Material Cost - <double> - The estimated cost of the
material.
Diameter – Diameter - <double> - The diameter of the conduit.
Comments – Comments - <text, 100> - User or Designer Comments
3
ArcGIS Telecom Data Model – Data Dictionary
Subtypes Not applicable
Relationships Not applicable
Notes Abstract class used for the storage of additional Complex Edge attributes
which are inherited within the model.
2.1.2 Conduit
A Conduit is a linear object which belongs to the structural network. It is the outermost
casing. A Conduit may contain Duct(s) and Innerduct(s). Duct(s) and Innerduct(s) are
modeled as non-graphic objects stored in object classes. Conduit is a concrete feature
class that contains information about the position and characteristics of ducts as seen
from a manhole, vault, or a cross section of a trench and duct. Users can create duct
characteristic fields to represent their business processes.
Class Name Conduit
Type Feature class
Inherits From TelecomComplexEdge
Geometry Polyline
Attributes Material – Material - <long integer> - Code indicating conduit material.
Uses the ConduitMaterial domain.
SpanID – Span ID (fk) - <long integer> - The IPID of the associated Span
feature.
Subtypes Trench and Duct Bank
Relationships Many-to-many relationship to the Structure feature class
One-to-many relationship to the Duct table
One-to-many relationship to the FiberCable feature class
One-to-many relationship to the CopperCable feature class
Notes
2.1.3 TelecomJunction
TelecomJunction is an abstract class whose attributes are inherited by simple junction
feature classes in the model. Most concrete classes inheriting include the underground
Structure class, as well as classes in the Device section.The following table provides
information regarding the TelecomJunction Abstract class, with attributes, aliases, data
types and descriptions.
Class Name TelecomJunction
Type and Purpose Abstract class
Inherits From SimpleJunction
Geometry Not applicable
Attributes WorkOrderID – Work Order ID - <text, 20> - Utility identifier of work order
ProjectNumber – Project Number - <text, 20> - The project number
identifier.
ProjectName – Project Name - <text, 20> - The project name.
CLLI - Common Language Location Identifier - <text, 20> - Code
descriptor used to identify telecommunications switches, interconnections,
4
ArcGIS Telecom Data Model – Data Dictionary
and other network elements and their locations.
Manufacturer – Manufacturer - <text, 20> - Manufacturer of the
TelecomComplexEdge feature.
PartNumber – Part Number - <text, 20> - Manufacturer’s part number.
ModelNumber – Model Number - <text, 20> - Model Number of the
TelecomJunction feature.
SerialNumber – Serial Number - <text, 20> - Manufacturer’s Serial
number.
Cost – Cost - <double> - The estimated cost of the specific structure
facility.
AccountCode – Account Code - <text, 20> - The Account Code which the
Conduit is referenced.
InstallationDate – Installation Date - <date> - The date of installation.
IPID – Item of Plant ID - <long integer> - The unique identifier for the Plant
ID system.
Comments – Comments - <text, 100> - User or Designer Comments
Subtypes Not applicable
Relationships Not applicable
Notes Abstract class used for the storage of additional Complex Edge attributes
which are inherited within the model.
2.1.4 Structure
Structure is a concrete feature class that describes features needed to support an
underground telecommunications system. It is a simple junction feature that includes
vaults, manholes, that house and protect electrical equipment. Structures are
underground access point for cable and splices. It is comprised of the following types:
Manhole, Handhole, Pullbox, and Vault.
Class Name Structure
Type Feature class - Simple Junction
Inherits From TelecomJunction
Geometry Point
Attributes StructureSize – Structure Size - <text, 20> - Size of the structure.
Material – Material - <text, 20> - Material of the structure.
Subtypes Manhole (SubtypeCode=1)
Handhole (SubtypeCode=2)
Pullbox (SubtypeCode=3)
Vault (SubtypeCode=4)
Relationships Many-to-many relationship with Conduit feature class, with the
Conduit_Structure relationship. See the Relationships in Section 3.2 for
more information.
Notes
5
Description:ArcGIS Telecom Data Model – Data Dictionary Geography Network logo, the MapCafé logo, the MapObjects Internet Map Server logo, the
