Name: Water Main

Display Field: FacilityID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 135280.758794338
YMin: 2314528.33253693
XMax: 184317.982898172
YMax: 2371691.28120293
Spatial Reference: 2244 (2965)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[92,49,160,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Subtype (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LifecycleStatus (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 3 more ...)
• Diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 inch], [2: 2 inch], [4: 4 inch], ... 15 more ...)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CI: Cast Iron], [PVC: Poly Vinyl Chloride], [AC: Asbestos Concrete], ... 5 more ...)
• Ownership (type: esriFieldTypeString, alias: Owner Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Pub: Public], [Priv: Private], [Unk: Unknown])
• InstallYear (type: esriFieldTypeString, alias: Install Year, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Depth (type: esriFieldTypeSmallInteger, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkOrderID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PressRating (type: esriFieldTypeString, alias: Pressure Rating, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GroundType (type: esriFieldTypeString, alias: Ground Surface Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ExterCoating (type: esriFieldTypeString, alias: Exterior Coating, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CasingInfo (type: esriFieldTypeString, alias: Casing Info, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LiningType (type: esriFieldTypeString, alias: Lining Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Roughness (type: esriFieldTypeDouble, alias: Roughness, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JointType (type: esriFieldTypeString, alias: Joint Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Flange: Flange], [Weld: Weld], [Bond: Bond], ... 2 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• LastUpdate (type: esriFieldTypeDate, alias: Last Update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastEditor (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Identifier (type: esriFieldTypeString, alias: Identifier, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• FacID_SeqNu (type: esriFieldTypeInteger, alias: FacID_SeqNu, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Water Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Ownership: Pub
• Subtype: 5
• LifecycleStatus: Active
• Enabled: 1

Relationships:

• SBCommons.NETWORKS.wMainLeak (0) -- Related To: Water MainLeak (36)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/26/2022 7:20:08 PM

Schema Last Edit Date: 5/26/2022 7:20:08 PM

Data Last Edit Date: 5/26/2022 7:20:08 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat