Name: SS_RegularCleaning_222

Display Field: ENTNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8972914.9962
YMin: 5378833.4247
XMax: -8965876.8602
YMax: 5385069.6602
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"LIFECYCLESTATUS","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,145,27,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":2},"value":"Abandoned","label":"Abandoned"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":2},"value":"Never Built","label":"Never Built"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":2},"value":"Removed","label":"Removed"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":2},"value":"Split Archived","label":"Split Archived"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[255,255,0,255],"width":2},"value":"Proposed","label":"Proposed"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[255,255,0,255],"width":2},"value":"Temp","label":"Temp"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":3},"value":"Active","label":"Active"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,252,222,255],"toColor":[199,252,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,250,255],"toColor":[252,182,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,200,187,255],"toColor":[252,200,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,219,252,255],"toColor":[189,219,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,245,182,255],"toColor":[252,245,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,179,252,255],"toColor":[182,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,238,255],"toColor":[252,212,238,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,179,255],"toColor":[202,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,245,252,255],"toColor":[192,245,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,235,207,255],"toColor":[252,235,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,199,252,255],"toColor":[223,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,199,255],"toColor":[252,179,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[236,252,215,255],"toColor":[236,252,215,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[ENTID]","labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"followFeature","deconflictionStrategy":"dynamicNeverRemove","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":false,"removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":1000,"name":"Default","priority":53,"symbol":{"type":"esriTS","color":[255,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"baseline","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}

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: LIFECYCLESTATUS

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ASBUILTNUMBER (type: esriFieldTypeString, alias: ASBUILTNUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ASSET_CLASS (type: esriFieldTypeString, alias: ASSET_CLASS, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Bridges: Bridges], [BIA: BIA], [Cemeteries: Cemeteries], ... 18 more ...)
• ASSET_ID (type: esriFieldTypeInteger, alias: ASSET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSET_MANAGER (type: esriFieldTypeString, alias: ASSET_MANAGER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Cemeteries: Cemeteries], [Facilities: Facilities], [Parks: Parks], ... 14 more ...)
• REMOVED_DATE (type: esriFieldTypeDate, alias: REMOVED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ASSET_TYPE (type: esriFieldTypeString, alias: ASSET_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Local Main: Local Main], [Trunk Main: Trunk Main])
• ASSUMPTIONSTATUS (type: esriFieldTypeString, alias: ASSUMPTIONSTATUS, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Assumed by City of Waterloo: Assumed by City of Waterloo], [NA: NA], [On Maintenance: On Maintenance])
• CREATE_DATE (type: esriFieldTypeDate, alias: CREATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATE_USER (type: esriFieldTypeString, alias: CREATE_USER, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• DATE_TO_MODEL (type: esriFieldTypeDate, alias: DATE_TO_MODEL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATESTAMP (type: esriFieldTypeDate, alias: DATESTAMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeSmallInteger, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [50: 50], [75: 75], ... 24 more ...)
• DOWNDROP (type: esriFieldTypeString, alias: DOWNDROP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DOWNSTREAMINVERT (type: esriFieldTypeDouble, alias: DOWNSTREAMINVERT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ENTID (type: esriFieldTypeDouble, alias: ENTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTNAME (type: esriFieldTypeString, alias: ENTNAME, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FACILITY_ID (type: esriFieldTypeInteger, alias: FACILITY_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FACILITY_NAME (type: esriFieldTypeString, alias: FACILITY_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Albert McCormick Community Centre: Albert McCormick Community Centre], [Beaver Creek Pumping Station: Beaver Creek Pumping Station], [Button Factory: Button Factory], ... 337 more ...)
• FINALACCEPTANCEDATE (type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FROMASSETID (type: esriFieldTypeInteger, alias: FROMASSETID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROMMH (type: esriFieldTypeString, alias: FROMMH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTACTIVITY (type: esriFieldTypeString, alias: LASTACTIVITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [INSP: Inspection], [UPDT: Update], [RPR: Repair / Replacement], ... 6 more ...)
• LENGTH (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifecycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 4 more ...)
• LINED (type: esriFieldTypeSmallInteger, alias: LINED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINING_NOTES (type: esriFieldTypeString, alias: LINING_NOTES, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LINING_TYPE (type: esriFieldTypeString, alias: LINING_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CIPP: CIPP])
• LINING_YEAR (type: esriFieldTypeSmallInteger, alias: LINING_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINKEDDOCUMENTS (type: esriFieldTypeString, alias: LINKEDDOCUMENTS, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos Cement: Asbestos Cement], [Black Pipe: Black Pipe], [Cast Iron: Cast Iron], ... 9 more ...)
• MODELLED (type: esriFieldTypeString, alias: MODELLED, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MXASSETNUM (type: esriFieldTypeString, alias: MXASSETNUM, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MXCREATIONSTATE (type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [City of Waterloo: City of Waterloo], [City of Kitchener: City of Kitchener], [Region of Waterloo: Region of Waterloo], ... 12 more ...)
• POSITION_ACCURACY (type: esriFieldTypeString, alias: POSITION_ACCURACY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Digitized +/- 2m: Digitized +/- 2m], [Total Station +/- 0.5m: Total Station +/- 0.5m], [AutoCAD Drawings +/- 1m: AutoCAD Drawings +/- 1m], ... 10 more ...)
• ROWSTAMP (type: esriFieldTypeString, alias: ROWSTAMP, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• SEGMENT_ID (type: esriFieldTypeInteger, alias: SEGMENT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeSingle, alias: SLOPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SMP13_DIAM (type: esriFieldTypeString, alias: SMP13_DIAM, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SMP13_DIAMSRC (type: esriFieldTypeString, alias: SMP13_DIAMSRC, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SMP13_DOWNINV (type: esriFieldTypeString, alias: SMP13_DOWNINV, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SMP13_DOWNINVSRC (type: esriFieldTypeString, alias: SMP13_DOWNINVSRC, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SMP13_FROMMH (type: esriFieldTypeString, alias: SMP13_FROMMH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SMP13_NOTES (type: esriFieldTypeString, alias: SMP13_NOTES, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SMP13_REVIEWED (type: esriFieldTypeString, alias: SMP13_REVIEWED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SMP13_TOMH (type: esriFieldTypeString, alias: SMP13_TOMH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SMP13_UPINV (type: esriFieldTypeString, alias: SMP13_UPINV, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SMP13_UPINVS (type: esriFieldTypeString, alias: SMP13_UPINVS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STANTEC2010CAPACITYSTUDY_NOTES (type: esriFieldTypeString, alias: STANTEC2010CAPACITYSTUDY_NOTES, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STARTOFMAINTDATE (type: esriFieldTypeDate, alias: STARTOFMAINTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TOASSETID (type: esriFieldTypeInteger, alias: TOASSETID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOMH (type: esriFieldTypeString, alias: TOMH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UPDATE_DATE (type: esriFieldTypeDate, alias: UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UPDATE_USER (type: esriFieldTypeString, alias: UPDATE_USER, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• UPSTREAMINVERT (type: esriFieldTypeDouble, alias: UPSTREAMINVERT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: Abandoned
Name: Abandoned
Domains:

• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: ASSET_MANAGER
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: MODELLED
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
Templates:

Name: Abandoned
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: Abandoned

---

ID: Never Built
Name: Never Built
Domains:

• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: ASSET_MANAGER
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: MODELLED
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
Templates:

Name: Never Built
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: Never Built

---

ID: Removed
Name: Removed
Domains:

• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: ASSET_MANAGER
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: MODELLED
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
Templates:

Name: Removed
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: Removed

---

ID: Split Archived
Name: Split Archived
Domains:

• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: ASSET_MANAGER
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: MODELLED
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
Templates:

Name: Split Archived
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: Split Archived

---

ID: Proposed
Name: Proposed
Domains:

• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: ASSET_MANAGER
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: MODELLED
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
Templates:

Name: Proposed
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: Proposed

---

ID: Temp
Name: Temp
Domains:

• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: ASSET_MANAGER
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: MODELLED
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
Templates:

Name: Temp
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: Temp

---

ID: Active
Name: Active
Domains:

• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: ASSET_MANAGER
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: MODELLED
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
Templates:

Name: Active
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: Active

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/28/2024 4:11:35 PM

Schema Last Edit Date: 3/28/2024 4:11:35 PM

Data Last Edit Date: 3/28/2024 4:11:35 PM

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