Name: SW_CCTV_Lateral_Inspected_31

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: -8969019.9126
YMin: 5381128.231
XMax: -8963826.7474
YMax: 5387100.0696
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"OWNER","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[38,115,0,255],"width":2},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[38,115,0,255],"width":2.5},"value":"City of Waterloo","label":"City of Waterloo"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[184,230,252,255],"width":1},"value":"City of Waterloo Property","label":"City of Waterloo Property"}],"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","textOrientation":"direction","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"stackSeparators":[{"separator":" "}],"useCodedValues":true,"maxScale":0,"minScale":1000,"name":"Default","priority":79,"symbol":{"type":"esriTS","color":[38,115,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":8,"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: OWNER

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_ID (type: esriFieldTypeInteger, alias: ASSET_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEGMENT_ID (type: esriFieldTypeInteger, alias: SEGMENT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VAIL_ID (type: esriFieldTypeDouble, alias: VAIL_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CIVIC_ADDRESS (type: esriFieldTypeString, alias: CIVIC_ADDRESS, SQL Type: sqlTypeOther, length: 80, 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)
• DIAMETER (type: esriFieldTypeSmallInteger, alias: DIAMETER, 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)
• 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)
• REMOVED_DATE (type: esriFieldTypeDate, alias: REMOVED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 100, 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)
• LENGTH (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTID (type: esriFieldTypeDouble, alias: ENTID, SQL Type: sqlTypeOther, 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 ...)
• 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: City of Waterloo
Name: City of Waterloo
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

Name: City of Waterloo
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Active
• OWNER: City of Waterloo
• ENABLED: 1

---

ID: City of Waterloo Property
Name: City of Waterloo Property
Domains:

• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: ASSUMPTIONSTATUS
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: POSITION_ACCURACY
  Inherited
  
• Field Name: ASSET_CLASS
  Inherited
  
• Field Name: FACILITY_NAME
  Inherited
  
Templates:

Name: City of Waterloo Property
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• LIFECYCLESTATUS: Active
• OWNER: City of Waterloo Property
• ENABLED: 1

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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