Name: SW_CCTV_Inspected_1300

Display Field: FACILITY_NAME

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: -8969007.064
YMin: 5380950.276
XMax: -8960405.2079
YMax: 5387421.5033
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"LIFECYCLESTATUS","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,140,115,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":3},"value":"Abandoned","label":"Abandoned"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":3},"value":"Never Built","label":"Never Built"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":3},"value":"Split Archived","label":"Split Archived"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[52,52,52,255],"width":3},"value":"Removed","label":"Removed"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[255,170,0,255],"width":3},"value":"Proposed","label":"Proposed"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[255,170,0,255],"width":3},"value":"Temp","label":"Temp"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":3},"value":"Active","label":"Active"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[68,199,125,255],"toColor":[68,199,125,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,49,142,255],"toColor":[189,49,142,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,116,39,255],"toColor":[184,116,39,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[50,135,191,255],"toColor":[50,135,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[48,46,199,255],"toColor":[48,46,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[167,201,42,255],"toColor":[167,201,42,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,70,82,255],"toColor":[189,70,82,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[49,71,158,255],"toColor":[49,71,158,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[61,182,184,255],"toColor":[61,182,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[125,42,161,255],"toColor":[125,42,161,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[40,184,40,255],"toColor":[40,184,40,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[91,153,58,255],"toColor":[91,153,58,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[171,156,48,255],"toColor":[171,156,48,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpression":"[ENTID]","labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"followFeature","deconflictionStrategy":"dynamicNeverRemove","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","textOrientation":"direction","stackLabel":false,"removeDuplicates":"all","removeDuplicatesDistance":146,"useCodedValues":true,"maxScale":0,"minScale":1000,"name":"Default","priority":72,"symbol":{"type":"esriTS","color":[56,168,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":11,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: false

HasM: false

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)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifecycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 4 more ...)
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ASSET_TYPE (type: esriFieldTypeString, alias: ASSET_TYPE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Collector: Collector], [Culvert: Culvert], [Ditch: Ditch], ... 2 more ...)
• ASSET_ID (type: esriFieldTypeInteger, alias: ASSET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTID (type: esriFieldTypeDouble, alias: ENTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEGMENT_ID (type: esriFieldTypeInteger, alias: SEGMENT_ID, SQL Type: sqlTypeOther, 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 ...)
• ASBUILTNUMBER (type: esriFieldTypeString, alias: ASBUILTNUMBER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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 ...)
• HEIGHT (type: esriFieldTypeSmallInteger, alias: HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [100: 100], [150: 150], ... 49 more ...)
• WIDTH (type: esriFieldTypeSmallInteger, alias: WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [100: 100], [150: 150], ... 49 more ...)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asbestos Cement: Asbestos Cement], [Cast Iron: Cast Iron], [Clay: Clay], ... 8 more ...)
• UPSTREAMINVERT (type: esriFieldTypeDouble, alias: UPSTREAMINVERT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNSTREAMINVERT (type: esriFieldTypeDouble, alias: DOWNSTREAMINVERT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeDouble, alias: SLOPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CROSSSECTIONSHAPE (type: esriFieldTypeString, alias: CrossSectionShape, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Circular: Circular], [Rectangular: Rectangular], [Unknown: Unknown], ... 2 more ...)
• LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• 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])
• STARTOFMAINTDATE (type: esriFieldTypeDate, alias: STARTOFMAINTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FINALACCEPTANCEDATE (type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FROMMH (type: esriFieldTypeString, alias: FROMMH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TOMH (type: esriFieldTypeString, alias: TOMH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FROM_ASSET_ID (type: esriFieldTypeInteger, alias: FROM_ASSET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_ASSET_ID (type: esriFieldTypeInteger, alias: TO_ASSET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CULVERT_BRIDGE (type: esriFieldTypeString, alias: CULVERT_BRIDGE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• STANTEC2010CAPACITYSTUDY_NOTES (type: esriFieldTypeString, alias: STANTEC2010CAPACITYSTUDY_NOTES, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• REMOVED_DATE (type: esriFieldTypeDate, alias: REMOVED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, 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])
• 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)
• 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)
• 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 ...)
• DATESTAMP (type: esriFieldTypeDate, alias: DATESTAMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LINKEDDOCUMENTS (type: esriFieldTypeString, alias: LINKEDDOCUMENTS, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• LINED (type: esriFieldTypeSmallInteger, alias: LINED, SQL Type: sqlTypeOther, 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)
• LINING_NOTES (type: esriFieldTypeString, alias: LINING_NOTES, 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 ...)
• 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 ...)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: Abandoned
Name: Abandoned
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: HEIGHT
  Inherited
  
• Field Name: WIDTH
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: CROSSSECTIONSHAPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: CULVERT_BRIDGE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

Name: Abandoned
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Abandoned
• CROSSSECTIONSHAPE: Circular
• ENABLED: 1

---

ID: Never Built
Name: Never Built
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: HEIGHT
  Inherited
  
• Field Name: WIDTH
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: CROSSSECTIONSHAPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: CULVERT_BRIDGE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

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

Attributes:

• LIFECYCLESTATUS: Never Built
• CROSSSECTIONSHAPE: Circular
• ENABLED: 1

---

ID: Split Archived
Name: Split Archived
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: HEIGHT
  Inherited
  
• Field Name: WIDTH
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: CROSSSECTIONSHAPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: CULVERT_BRIDGE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

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

Attributes:

• LIFECYCLESTATUS: Split Archived
• CROSSSECTIONSHAPE: Circular
• ENABLED: 1

---

ID: Removed
Name: Removed
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: HEIGHT
  Inherited
  
• Field Name: WIDTH
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: CROSSSECTIONSHAPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: CULVERT_BRIDGE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

Name: Removed
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Removed
• CROSSSECTIONSHAPE: Circular
• ENABLED: 1

---

ID: Proposed
Name: Proposed
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: HEIGHT
  Inherited
  
• Field Name: WIDTH
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: CROSSSECTIONSHAPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: CULVERT_BRIDGE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

Name: Proposed
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Proposed
• CROSSSECTIONSHAPE: Circular
• ENABLED: 1

---

ID: Temp
Name: Temp
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: HEIGHT
  Inherited
  
• Field Name: WIDTH
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: CROSSSECTIONSHAPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: CULVERT_BRIDGE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

Name: Temp
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Temp
• CROSSSECTIONSHAPE: Circular
• ENABLED: 1

---

ID: Active
Name: Active
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: HEIGHT
  Inherited
  
• Field Name: WIDTH
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: CROSSSECTIONSHAPE
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: CULVERT_BRIDGE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: LASTACTIVITY
  Inherited
  
• Field Name: LINING_TYPE
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

Name: Active
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Active
• CROSSSECTIONSHAPE: Circular
• ENABLED: 1

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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