Name: Wastewater Service Connection

Display Field: FACILITYID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• P_INST_DATE (type: esriFieldTypeDate, alias: Pipe Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: Connection Type, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true, Coded Values: [TAP: Tap], [WYE: Wye])
• CON_MAT (type: esriFieldTypeString, alias: Connection Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PVC: PVC], [VCP: Vitrified Clay Pipe], [CI: Cast Iron], ... 1 more ...)
• PIPE_MAT (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PVC: PVC], [VCP: Vitrified Clay Pipe], [CI: Cast Iron], ... 1 more ...)
• RISER_MAT (type: esriFieldTypeString, alias: Riser Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PVC: PVC], [VCP: Vitrified Clay Pipe], [CI: Cast Iron], ... 1 more ...)
• RISER_HT (type: esriFieldTypeDouble, alias: Riser Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RISER (type: esriFieldTypeString, alias: Riser?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: 4"], [6: 6"], [8: 8"], ... 1 more ...)
• SERVICE_TYPE (type: esriFieldTypeString, alias: COMMENT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [COMM: Commercial], [DOM: Domestic], [IND: Industrial])
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CITY: City of Topeka], [COUNTY: Shawnee County], [Private: Privately Owned], ... 5 more ...)
• CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• CREATEDDATE (type: esriFieldTypeDate, alias: CREATEDDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LASTEDITOR (type: esriFieldTypeString, alias: LASTEDITOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• LASTUPDATE (type: esriFieldTypeDate, alias: LASTUPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• C_INST_DATE (type: esriFieldTypeDate, alias: Connection Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MH_DIST (type: esriFieldTypeDouble, alias: Distance From US MH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DR_DIR (type: esriFieldTypeString, alias: Draw Direction, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [L: Left], [R: Right])
• DR_LEN (type: esriFieldTypeDouble, alias: Draw Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPE_REF (type: esriFieldTypeString, alias: Pipe Reference, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [ABAND: Abandoned], [ACT: Active], [CONST: Construction Phase], ... 6 more ...)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• S_TYPE (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [COMM: Commercial], [DOM: Domestic], [IND: Industrial])
• DEPTH (type: esriFieldTypeDouble, alias: Depth at Main, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Service Connection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• TYPE:

Relationships:

• wwGravityMain (0) -- Related To: Wastewater Pipe (11)
• wwGravityMain (2) -- Related To: Abandoned Wastewater Pipe (17)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/8/2025 1:52:19 PM

Schema Last Edit Date: 9/8/2025 1:52:19 PM

Data Last Edit Date: 9/8/2025 1:52:19 PM

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