Name: Sanitary_Main_Clean_JOIN

Display Field: Collection_Method

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 803834.187984329
YMin: 554892.984624736
XMax: 840709.036150496
YMax: 583800.509814821
Spatial Reference: 103444 (103444)

Drawing Info:

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

HasZ: false

HasM: false

Has Attachments: true

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:

• Collection_Method (type: esriFieldTypeString, alias: Collection_Method, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [GEO: GEO], [ASBUILT: ASBUILT], [ENGINEER_SURVEY: ENGINEER_SURVEY], ... 3 more ...)
• Project_Number (type: esriFieldTypeDouble, alias: Project_Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• To_Direction (type: esriFieldTypeString, alias: To_Direction, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [N: NORTH], [S: SOUTH], [E: EAST], ... 5 more ...)
• To_Invert (type: esriFieldTypeDouble, alias: To_Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• From_Direction (type: esriFieldTypeString, alias: From_Direction, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [N: NORTH], [S: SOUTH], [E: EAST], ... 5 more ...)
• From_Invert (type: esriFieldTypeDouble, alias: From_Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Structure_Id (type: esriFieldTypeString, alias: Structure_Id, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Diameter (type: esriFieldTypeString, alias: Diameter, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• Date_Cleaned (type: esriFieldTypeString, alias: Date_Cleaned, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PVC: PVC], [RCP: RCP], [DIP: DIP], ... 7 more ...)
• Engineer (type: esriFieldTypeString, alias: Engineer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Note (type: esriFieldTypeString, alias: Note, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Length (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Document_Number_Engineer (type: esriFieldTypeString, alias: Document_Number_Engineer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Year_Installed (type: esriFieldTypeString, alias: Year_Installed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CleanDate (type: esriFieldTypeDate, alias: CleanDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CleanSched (type: esriFieldTypeString, alias: CleanSched, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CleanNotes (type: esriFieldTypeString, alias: CleanNotes, SQL Type: sqlTypeOther, length: 2500, 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: sqlTypeOther, nullable: true, editable: false)
• Main_ID (type: esriFieldTypeString, alias: Sanitary Main ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Cleaned_1748967577862 (type: esriFieldTypeDate, alias: Date Cleaned, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PassFail (type: esriFieldTypeString, alias: Any Issues With The Main?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pass: Pass], [Fail: Fail])
• Issues (type: esriFieldTypeString, alias: What Issues Did You See?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NumberofRuns (type: esriFieldTypeInteger, alias: Number of Runs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GallonsofWater (type: esriFieldTypeInteger, alias: Gallons of Water Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: Sanitary_Cleaning
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/3/2026 4:36:18 PM

Schema Last Edit Date: 10/28/2024 7:16:42 PM

Data Last Edit Date: 10/28/2024 7:16:42 PM

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