Name: Pipe Segments

Display Field: ENGROUTENAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -11004084.4232
YMin: 3436316.31
XMax: -10890807.4371
YMax: 3460469.4288
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[104,145,0,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• INSTALLATIONDATE (type: esriFieldTypeDate, alias: InstallationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Proposed Retired: Proposed Retired], [Inactive: Inactive], ... 4 more ...)
• NOMINALDIAMETER (type: esriFieldTypeDouble, alias: Nominal Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.25: 1/4"], [0.38: 3/8"], [0.5: 1/2"], ... 43 more ...)
• OUTSIDEDIAMETER (type: esriFieldTypeDouble, alias: Outside Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.54: 0.540"], [0.675: 0.675"], [0.84: 0.840"], ... 43 more ...)
• DIAMETERUNITS (type: esriFieldTypeString, alias: Nominal Diameter Units, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Inch: Inch], [Foot: Foot], [Millimeter: Millimeter], ... 2 more ...)
• OPERATINGPRESSURE (type: esriFieldTypeDouble, alias: Operating Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COATINGTYPE (type: esriFieldTypeString, alias: Coating Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [3M Tape: 3M Tape], [Bare: Bare], [Blue Guard: Blue Guard], ... 35 more ...)
• MEASUREDLENGTH (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 1000000000])
• LENGTHSOURCE (type: esriFieldTypeString, alias: Length Source, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Field Measurement: Field Measurement], [Mapping System: Mapping System], [User-Derived: User-Derived], ... 1 more ...)
• ACTUALINTERNALDIAMETER (type: esriFieldTypeDouble, alias: Actual Internal Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WALLTHICKNESS (type: esriFieldTypeDouble, alias: Wall Thickness, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [0.125: 0.125], [0.2: 0.2], ... 12 more ...)
• ASSETUNITCODE (type: esriFieldTypeString, alias: Asset Unit Code, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_RETIRED (type: esriFieldTypeDate, alias: Date Retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSTALLATIONMETHOD (type: esriFieldTypeString, alias: Installation Method, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Trench: Trench], [Joint Trench: Joint Trench], [Insertion: Insertion], ... 2 more ...)
• WARNINGTAPE (type: esriFieldTypeString, alias: Warning Tape, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• TRACERWIRE (type: esriFieldTypeString, alias: Tracer Wire, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• PROJECTNUMBER (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• PIPETESTDATE (type: esriFieldTypeDate, alias: Pipe Test Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PIPETESTDURATION (type: esriFieldTypeDouble, alias: Pipe Test Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPETESTPRESSURE (type: esriFieldTypeDouble, alias: Pipe Test Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPETESTTYPE (type: esriFieldTypeString, alias: Pipe Test Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Air: Air], [Gas: Gas], [Water: Water])
• ELECTRICSURVEYINDICATOR (type: esriFieldTypeString, alias: Electric Survey Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• DESIGNPRESSUREENTERED (type: esriFieldTypeDouble, alias: Design Pressure - Entered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DESIGNPRESSURESTANDARD (type: esriFieldTypeDouble, alias: Design Pressure - Standard, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DESIGNPRESSUREUNITOFMEASURE (type: esriFieldTypeString, alias: Design Pressure - Unit of Measure, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Pounds/Square Inch: Pounds/Square Inch], [Inch Water Column: Inch Water Column], ... 1 more ...)
• DESIGNCLASS (type: esriFieldTypeInteger, alias: Design Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Class 1], [2: Class 2], [3: Class 3], ... 1 more ...)
• DESIGNFACTOR (type: esriFieldTypeDouble, alias: Design Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Material (type: esriFieldTypeInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SYSTEMTYPE (type: esriFieldTypeString, alias: Pipe System Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Distribution: Distribution], [Transmission: Transmission], [Gathering: Gathering], ... 2 more ...)
• CRITICALINDICATOR (type: esriFieldTypeString, alias: Critical Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• PIGGABLE (type: esriFieldTypeString, alias: Piggable, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• BARCODE (type: esriFieldTypeString, alias: Barcode, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Thrall Distribution: Thrall Distribution], [UPONOR: UPONOR], [Other: Other], ... 1 more ...)
• MANUFACTURELOTNO (type: esriFieldTypeString, alias: Manufacture Lot No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MANUFACTUREDATE (type: esriFieldTypeDate, alias: Manufacture Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PIPESPECIFICATION (type: esriFieldTypeString, alias: Pipe Specification, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [10: Other Pipe], [1J: Seamless and Welded ASTM A53/A53M Pipe], [1K: Seamless Carbon Steel ASTM A106 Pipe])
• CPSYSTEM_GlobalID (type: esriFieldTypeGUID, alias: CPSystem_GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• MAOPDESIGN (type: esriFieldTypeDouble, alias: MAOP Design, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAOPTEST (type: esriFieldTypeDouble, alias: MAOP Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAOPRECORD (type: esriFieldTypeDouble, alias: MAOP Record, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAOPUNITOFMEASURE (type: esriFieldTypeString, alias: MAOP Unit of Measure, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Pounds/Square Inch: Pounds/Square Inch], [Inch Water Column: Inch Water Column], ... 1 more ...)
• PRESSURESYSTEM_GlobalID (type: esriFieldTypeGUID, alias: PressureSystem_GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• EMERISOSYS_GlobalID (type: esriFieldTypeGUID, alias: EmerIsoSys_GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• PINCHABLE (type: esriFieldTypeString, alias: PINCHABLE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• PIPEGRADE (type: esriFieldTypeString, alias: PIPEGRADE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [M: Steel], [N: Stainless Steel], [X: Other], ... 10 more ...)
• GIRTHWELDTYPE (type: esriFieldTypeString, alias: Girth Weld Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LONGITUDINALSEAMORIENTATION (type: esriFieldTypeString, alias: Longitudinal Seam Orientation, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GASTRACEWEIGHT (type: esriFieldTypeInteger, alias: GASTRACEWEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SMYS (type: esriFieldTypeDouble, alias: SMYS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERCENTSMYS (type: esriFieldTypeDouble, alias: Percent SMYS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMODITY (type: esriFieldTypeString, alias: Commodity, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Anhydrous Ammonia: Anhydrous Ammonia], [Crude Oil: Crude Oil], [Carbon Dioxide: Carbon Dioxide], ... 8 more ...)
• SEAMTYPE (type: esriFieldTypeString, alias: Seam Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Seamless: Seamless], [Direct Current Welded: Direct Curent Welded], [High Frequency Electric Resistance Welded: High Frequency Electric Resistance Welded], ... 7 more ...)
• COATINGAPPLICATIONDATE (type: esriFieldTypeDate, alias: Coating Application Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EVENTID (type: esriFieldTypeString, alias: EventID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• FROMDATE (type: esriFieldTypeDate, alias: FromDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TODATE (type: esriFieldTypeDate, alias: ToDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SPATIALACCURACY (type: esriFieldTypeSmallInteger, alias: Spatial Accuracy, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Greater than 300 Meters], [2: 101-300 Meters], ... 8 more ...)
• ENGROUTEID (type: esriFieldTypeString, alias: Engineering Route ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ENGROUTENAME (type: esriFieldTypeString, alias: Engineering Route Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ENGFROMM (type: esriFieldTypeDouble, alias: Engineering From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENGTOROUTEID (type: esriFieldTypeString, alias: Engineering To RouteID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ENGTOROUTENAME (type: esriFieldTypeString, alias: Engineering To Route Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ENGTOM (type: esriFieldTypeDouble, alias: Engineering To Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTINROUTEID (type: esriFieldTypeString, alias: Continuous Route ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CONTINROUTENAME (type: esriFieldTypeString, alias: Continuous Route Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CONTINFROMM (type: esriFieldTypeDouble, alias: Continuous From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTINTOM (type: esriFieldTypeDouble, alias: Continuous To Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROMREFMETHOD (type: esriFieldTypeSmallInteger, alias: From Reference Method, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROMREFOFFSET (type: esriFieldTypeString, alias: From Reference Offset, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FROMREFLOCATION (type: esriFieldTypeString, alias: From Reference Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOREFMETHOD (type: esriFieldTypeSmallInteger, alias: To Reference Method, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOREFOFFSET (type: esriFieldTypeString, alias: To Reference Offset, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOREFLOCATION (type: esriFieldTypeString, alias: To Reference Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATIONERROR (type: esriFieldTypeString, alias: Location Error, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Pipe Segments
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Material: 5
• Enabled: 1
• STATUS: Proposed
• INSTALLATIONMETHOD: Direct Bore
• SYSTEMTYPE: Distribution
• PIGGABLE: N
• PINCHABLE: N
• SPATIALACCURACY: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/28/2019 5:15:33 PM

Schema Last Edit Date: 6/28/2019 5:15:33 PM

Data Last Edit Date: 6/28/2019 5:15:33 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat