All Layers and Tables (STM_Main_Inspection

Layers:

Layer: STM_Main Inspection (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":9}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
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: false, 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)
Inspection (type: esriFieldTypeString, alias: Inspection, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Complete: Complete], [Not Complete: Not Complete])
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

LIFECYCLESTATUS: INSRV
ENABLED: 1
ADMINISTRATIVEAREA: OAKVILLE
OPERATIONALAREA: OAKVILLE
SUBTYPE: 1
DROPINVERTTYPE: NONE
GISID: 0
PROJECTSTATUS: P

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (STM_Main_Inspection_2024)

Layers:

Layer: STM_Main Inspection (0)