Name: SW_Infiltration_Inflow_176

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: -8965631.6051
YMin: 5380974.5258
XMax: -8960708.3938
YMax: 5386517.7937
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[34,133,155,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

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:

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)

Templates:

Name: SW_Infiltration_Inflow_176
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:33 PM

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

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

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