Name: Wastewater Main

Display Field: HistoricOracleTableName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This dataset is a line representation of Wastewater Network Main locations within the Regional Muncipality of Peel.

Copyright Text: Public Works, Regional Municipality of Peel, Information Management Group

Min. Scale: 10000

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 585561.89
YMin: 4815104
XMax: 618784.5727
YMax: 4861618.1461
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[224,170,15,255],"width":1},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FacilityID (type: esriFieldTypeString, alias: Wastewater Main ID, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• InstallationDate (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [ABS: Acryl Butadiene Styrene], [AC: Asbestos Cement], [ACP: Asbestos Cement - Pressure], ... 39 more ...)
• Diameter (type: esriFieldTypeInteger, alias: Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeShape (type: esriFieldTypeString, alias: Pipe Shape, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [ARC: Arch], [B: Box], [EGG: Egg], ... 10 more ...)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [CITY: City], [CONS: Consultant], [DVPR: Developer], ... 11 more ...)
• MaintainedBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [CITY: City], [CONS: Consultant], [DVPR: Developer], ... 11 more ...)
• Sumflow (type: esriFieldTypeDouble, alias: Flow Summary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InvertDown (type: esriFieldTypeDouble, alias: Invert - Downstream (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• InvertUp (type: esriFieldTypeDouble, alias: Invert - Upstream (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationUserID (type: esriFieldTypeString, alias: Creation User ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ModificationUserID (type: esriFieldTypeString, alias: Modification User ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ModificationDate (type: esriFieldTypeDate, alias: Modification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• CommentsQualifier (type: esriFieldTypeString, alias: Comments Qualifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AssessmentAreaID (type: esriFieldTypeString, alias: Assessment Area ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [B01: Assessment File Area - Brampton 01], [B02: Assessment File Area - Brampton 02], [B03: Assessment File Area - Brampton 03], ... 175 more ...)
• AsBuiltDrawingNumber (type: esriFieldTypeString, alias: AsBuilt Drawing Number, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• ProjectNumber (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• CadastralAreaID (type: esriFieldTypeString, alias: Cadastral Area ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [B01: Cadastral File Area - Brampton 01], [B02: Cadastral File Area - Brampton 02], [B03: Cadastral File Area - Brampton 03], ... 165 more ...)
• OperationsYardID (type: esriFieldTypeString, alias: Operations Yard ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [C: Copper], [V: Victoria], [W: Wolfedale])
• PWMapZoneTileID (type: esriFieldTypeString, alias: PW Map Zone Tile ID, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [0001: PW Mapzone TileID - 0001], [0002: PW Mapzone TileID - 0002], [0003: PW Mapzone TileID - 0003], ... 2622 more ...)
• LegalPlanNumber (type: esriFieldTypeString, alias: Legal Plan Number, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• SpatialVerification (type: esriFieldTypeString, alias: Spatial Verification, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [LINEARCNTRPNT: Linear Asset Centre Point], [N/A: Not Applicable], [ORTHO: Verified Using Ortho-Rectified Imagery], ... 8 more ...)
• ServiceStatus (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [A: Active - Contributing], [ABND: Abandoned In Situ], [ALTN: Alternate Sampling Site], ... 13 more ...)
• HistoricOracleID (type: esriFieldTypeInteger, alias: Historic Oracle ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HistoricOracleTableName (type: esriFieldTypeString, alias: Historic Oracle Table Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• InspectionLastCompleted (type: esriFieldTypeDate, alias: Inspection - Last Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InspectionNextScheduled (type: esriFieldTypeDate, alias: Inspection - Next Scheduled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HansenCompkey (type: esriFieldTypeInteger, alias: Hansen Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeLengthGIS (type: esriFieldTypeDouble, alias: Pipe Length - GIS (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeLengthCCTV (type: esriFieldTypeDouble, alias: Pipe Length - CCTV (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• MainType (type: esriFieldTypeString, alias: Wastewater Main Type, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [CULOVF: Sanitary Overflow System], [FM_PS: Forcemain With Private Service Connection], [FM: Forcemain], ... 9 more ...)
• SurfaceCover (type: esriFieldTypeString, alias: Surface Cover, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [ASCO: Combination - Asphalt-Concrete], [ASGS: Combination - Asphalt-Grass], [ASPH: Asphalt], ... 6 more ...)
• DepthUp (type: esriFieldTypeDouble, alias: Depth - Upstream (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DepthDown (type: esriFieldTypeDouble, alias: Depth - Downstream (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RiskRatingDesc (type: esriFieldTypeString, alias: Risk Rating Description, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [EXTREME: Extreme], [HIGH: High], [INSIGNIFICANT: Insignificant], ... 2 more ...)
• AbandonedDate (type: esriFieldTypeDate, alias: Abandoned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DesignSheet (type: esriFieldTypeString, alias: Design Sheet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DrainageMap (type: esriFieldTypeString, alias: Drainage Map, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CCTVInspectionReport (type: esriFieldTypeString, alias: CCTV Inspection Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WWShedMap (type: esriFieldTypeString, alias: Wastewater Shed Map, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FromNodeType (type: esriFieldTypeString, alias: From Node Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FromNodeID (type: esriFieldTypeString, alias: From Node ID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• ToNodeType (type: esriFieldTypeString, alias: To Node Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ToNodeID (type: esriFieldTypeString, alias: To Node ID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• ParallelLineNumber (type: esriFieldTypeString, alias: Parallel Line Number, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PipeHeight (type: esriFieldTypeDouble, alias: Pipe Height (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DirectionFromDown (type: esriFieldTypeString, alias: Direction From Down, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [E: East], [ENE: East North-East], [ESE: East South-East], ... 13 more ...)
• DirectionFromUp (type: esriFieldTypeString, alias: Direction From Up, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [E: East], [ENE: East North-East], [ESE: East South-East], ... 13 more ...)
• FrictionFactor (type: esriFieldTypeDouble, alias: Friction Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlushingLastCompleted (type: esriFieldTypeDate, alias: Flushing - Last Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FlushingNextScheduled (type: esriFieldTypeDate, alias: Flushing - Next Scheduled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DropStructure (type: esriFieldTypeString, alias: Drop Structure Present, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• DropStructureInvert (type: esriFieldTypeDouble, alias: Drop Structure Invert (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DropStructureDiameter (type: esriFieldTypeInteger, alias: Drop Structure Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SoilType (type: esriFieldTypeString, alias: Soil Type, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [CLAY: Brown Clay], [CR: Clay - Rocky], [FILL: Fill], ... 17 more ...)
• Community (type: esriFieldTypeString, alias: Community, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [B: Brampton], [BC: Brampton - Churchville], [BH: Brampton - Huttonsville], ... 39 more ...)
• PANCurrent (type: esriFieldTypeInteger, alias: PAN Current, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PANPrevious (type: esriFieldTypeInteger, alias: PAN Previous, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InESPA (type: esriFieldTypeString, alias: In ESPA, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• InCorrosiveSoil (type: esriFieldTypeString, alias: In Corrosive Soil, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• WWShedID (type: esriFieldTypeString, alias: Wastewater Shed ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• EasementWithin (type: esriFieldTypeString, alias: Within Easement, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• EasementWiderThan10m (type: esriFieldTypeString, alias: Easement Wider Than 10m, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• EasementWidth (type: esriFieldTypeDouble, alias: Easement Width (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• WardID (type: esriFieldTypeString, alias: Ward ID, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [B01: Brampton - Ward 01], [B02: Brampton - Ward 02], [B03: Brampton - Ward 03], ... 23 more ...)
• AssumptionDate (type: esriFieldTypeDate, alias: Assumption Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CrossRailroad (type: esriFieldTypeString, alias: Cross Railroad, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• CrossWatercourse (type: esriFieldTypeString, alias: Cross Watercourse, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• WWSamplingManholeDischarge (type: esriFieldTypeString, alias: WW Sampling Manhole Discharge, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• WWSamplingManholeID (type: esriFieldTypeString, alias: WW Sampling Manhole ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ReplacedByWWMain (type: esriFieldTypeString, alias: Replaced By WW Main, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ReplacementForWWMain (type: esriFieldTypeString, alias: Replacement For WW Main, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Bedding (type: esriFieldTypeString, alias: Bedding, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Wastewater Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/14/2020 6:46:34 PM

Schema Last Edit Date: 2/14/2020 6:46:34 PM

Data Last Edit Date: 2/14/2020 6:46:34 PM

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