Name: STM_StormMain

Display Field: GLOBALID

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: 602200.835205078
YMin: 4804865.2432251
XMax: 609682.415222168
YMax: 4814567.60021973
Spatial Reference: 26917 (26917)

Drawing Info:

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

HasZ: true

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: Objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• RMOHID (type: esriFieldTypeInteger, alias: Rmohid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeString, alias: GLOBALID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• DATACAPTUREMETHOD (type: esriFieldTypeString, alias: DataCaptureMethod, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [AC DATA DIGITAL TRANSFER +/- 2 M: AC DATA DIGITAL TRANSFER +/- 2 M], [AC DATA MANUAL TRANSFER +/- 5 M: AC DATA MANUAL TRANSFER +/- 5 M], [DESIGN DATA DIGITAL TRANSFER +/- 2 M: DESIGN DATA DIGITAL TRANSFER +/- 2 M], ... 14 more ...)
• ADMINISTRATIVEAREA (type: esriFieldTypeString, alias: AdministrativeArea, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [HALTON: Regional Municipality of Halton], [BURLINGTON: City of Burlington], [HAMILTON: City of Hamilton], ... 7 more ...)
• INSTALLDATE (type: esriFieldTypeInteger, alias: InstallDate, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1900 - 2030])
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifecycleStatus, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [INSRV: In Service], [OUTSRV: Out Of Service], [PROP: Proposed], ... 1 more ...)
• OPERATIONALAREA (type: esriFieldTypeString, alias: OperationalArea, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [OAKVILLE: Town of Oakville], [MILTON: Town of Milton], [HALTON HILLS: Town of Halton Hills], ... 4 more ...)
• PROJECTNUMBER (type: esriFieldTypeString, alias: Projectnumber, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• MAINTENANCERESPONSIBILITY (type: esriFieldTypeString, alias: Maintenanceresponsibility, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SUBTYPE (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DESIGNLIFE (type: esriFieldTypeInteger, alias: Designlife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USEFULLIFE (type: esriFieldTypeInteger, alias: Usefullife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXPECTEDYEAROFFAILURE (type: esriFieldTypeInteger, alias: Expectedyearoffailure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HISTORICCOST (type: esriFieldTypeDouble, alias: Historiccost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMORTIZATIONDATE (type: esriFieldTypeDate, alias: Amortizationdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• DIAMETER (type: esriFieldTypeInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [25: 25], [50: 50], ... 99 more ...)
• HEIGHT (type: esriFieldTypeInteger, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH (type: esriFieldTypeInteger, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEASUREDLENGTH (type: esriFieldTypeDouble, alias: Measuredlength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [CI: Cast Iron], [CCSS: Concrete Coated Stainless Steel], ... 17 more ...)
• PIPEMATERIALCLASS (type: esriFieldTypeSmallInteger, alias: PipeMaterialClass, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 100 D], [2: 140 D], [3: 40 D], ... 28 more ...)
• PIPESHAPE (type: esriFieldTypeString, alias: PipeShape, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [ARCH: Arch], [EGG: Egg], [ELH: Elliptical Horizontal], ... 8 more ...)
• BEDCLASS (type: esriFieldTypeString, alias: BedClass, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [CLASS A: Class A], [CLASS B: Class B], [CLASS C: Class C], ... 1 more ...)
• DROPINVERTELEVATION (type: esriFieldTypeDouble, alias: Dropinvertelevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DROPINVERTTYPE (type: esriFieldTypeString, alias: DropInvertType, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [INT: Internal], [EXT: External], [NONE: None])
• DROPSTRUCTUREOPSD (type: esriFieldTypeString, alias: DropStructureOPSD, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [STD 3-4: CB connection details], [1003.0100: Cast-in-place MH drop structure, Tee], [1003.0200: Cast-in-place MH drop structure, Wye], ... 6 more ...)
• TRENCHOPSD (type: esriFieldTypeString, alias: TrenchOPSD, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [0802.0100: Flexible pipe embedment and backfill earth excavation], [0802.0130: Flexible pipe embedment and backfill rock excavation], [0802.0140: Flexible pipe embedment in embankment, original grouund: earth or rock], ... 14 more ...)
• REHABILITATIONDATE (type: esriFieldTypeInteger, alias: RehabilitationDate, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1900 - 2030])
• STRUCTURALCONDITIONGRADE (type: esriFieldTypeInteger, alias: Structuralconditiongrade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPERATIONSCONDITIONGRADE (type: esriFieldTypeInteger, alias: Operationsconditiongrade, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RATINGYEAR (type: esriFieldTypeInteger, alias: Ratingyear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREET (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ENVSTRUCTUREID (type: esriFieldTypeInteger, alias: Envstructureid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINING (type: esriFieldTypeString, alias: Lining, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [WPE: Woven Polyester], [HDPE: High Density Polyethylene], [EPOX: Epoxy Resin], ... 4 more ...)
• ENTRY_UID (type: esriFieldTypeString, alias: Entry Uid, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ENTRY_WHEN (type: esriFieldTypeDate, alias: Entry When, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PARENTID (type: esriFieldTypeString, alias: Parentid, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• GISID (type: esriFieldTypeInteger, alias: Gisid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PREFIXID (type: esriFieldTypeString, alias: Prefixid, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true, Coded Values: [O_0200_: O_0200_], [O_0160_: O_0160_], [O_0120_: O_0120_], ... 9 more ...)
• RECORDCONVCODE (type: esriFieldTypeString, alias: Recordconvcode, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• GLOBALID_1 (type: esriFieldTypeGlobalID, alias: GLOBALID_1, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• PROJECTSTATUS (type: esriFieldTypeString, alias: Projectstatus, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [P: Pending], [IC: Issued for Construction], [AB: As-Built], ... 1 more ...)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NextInspection (type: esriFieldTypeSmallInteger, alias: NextInspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspection (type: esriFieldTypeString, alias: Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: Complete], [B: Not Complete], [C: Flushed], ... 2 more ...)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: STM_StormMain
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• ADMINISTRATIVEAREA: OAKVILLE
• LIFECYCLESTATUS: INSRV
• OPERATIONALAREA: OAKVILLE
• SUBTYPE: 1
• DROPINVERTTYPE: NONE

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/17/2024 7:52:25 PM

Schema Last Edit Date: 12/17/2024 7:43:34 PM

Data Last Edit Date: 12/17/2024 7:52:25 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat