Name: Hydrant

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: false

Views

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: -8915173.06881844
YMin: 5385803.55160678
XMax: -8853915.0156444
YMax: 5462290.90026651
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FacilityID (type: esriFieldTypeString, alias: Hydrant ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• InstallationDate (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Rotation (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [AVK: AVK], [BIBBY: Bibby-Ste-Croix], [BRIGA: Brigadier], ... 13 more ...)
• MaintenanceLastCompleted (type: esriFieldTypeDate, alias: Maintenance - Last Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• 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], ... 12 more ...)
• MaintainedBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [CITY: City], [CONS: Consultant], [DVPR: Developer], ... 12 more ...)
• Flow (type: esriFieldTypeDouble, alias: Flow Rate (L/min), 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], [OCWA: Ontario Clean Water Agency], [V: Victoria], ... 1 more ...)
• PWMapZoneTileID (type: esriFieldTypeString, alias: PW Map ZoneTile 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: [DWGCAD: Verified By Digital CAD As-Built Drawings], [DWGGEOTIF: Verified By Geo-Referenced Scanned As-Built Drawings], [DWGHARDCOPY: Verified By Hard-Copy As-Built Drawings], ... 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], ... 14 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)
• HydrantType (type: esriFieldTypeString, alias: Hydrant Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [GENERIC: Generic], [HYBLWF: Blow-Off], [HYYARD: Yard Hydrant])
• ModelNumber (type: esriFieldTypeString, alias: Model Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SerialNumber (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PressureRingColour (type: esriFieldTypeString, alias: Hydrant Pressure Ring Colour, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BLUE: Blue], [GREEN: Green], [ORANGE: Orange], ... 1 more ...)
• PressureZone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [1: Water Pressure Zone - 1], [12A: Water Pressure Zone - 12A], [12B: Water Pressure Zone - 12B], ... 39 more ...)
• OutletSize1 (type: esriFieldTypeInteger, alias: Outlet Size 1 (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletSize2 (type: esriFieldTypeInteger, alias: Outlet Size 2 (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletSize3 (type: esriFieldTypeInteger, alias: Outlet Size 3 (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletSize4 (type: esriFieldTypeInteger, alias: Outlet Size 4 (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FeederMaterial (type: esriFieldTypeString, alias: Feeder Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CI: Cast Iron], [CONP: Concrete - Precast], [COPP: Copper], ... 2 more ...)
• FeederLength (type: esriFieldTypeDouble, alias: Feeder Length (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FeederDiameter (type: esriFieldTypeDouble, alias: Feeder Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssociatedWTRMain (type: esriFieldTypeString, alias: Associated Water Main, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• AssociatedWTRServiceLine (type: esriFieldTypeString, alias: Associated Water Service Line, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LastWinterizedDate (type: esriFieldTypeDate, alias: Last Winterized Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Plugged (type: esriFieldTypeString, alias: Plugged, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• LongKeyRequired (type: esriFieldTypeString, alias: Long Key Required, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• AVKClip (type: esriFieldTypeString, alias: AVK Clip, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• HydrantMarker (type: esriFieldTypeString, alias: Has Hydrant Marker, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• DeChlorineRequired (type: esriFieldTypeString, alias: De-Chlorination Required, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• FlushFrequency (type: esriFieldTypeString, alias: Flushing Frequency, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1 MONTH: 1 Month], [1 WEEK: 1 Week], [1 YEAR: 1 Year], ... 11 more ...)
• FlushingLastCompleted (type: esriFieldTypeDate, alias: Flushing Last Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OutletElevation (type: esriFieldTypeDouble, alias: Outlet Elevation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• WaterWorksNumber (type: esriFieldTypeString, alias: Water Works Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [WW220003993: Well Supply - Caledon East-Palgrave-Centreville], [WW220004000: Well Supply - Caledon-Mono Mills-Skywood], [WW220004037: Well Supply - Inglewood], ... 2 more ...)
• 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], ... 24 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 ...)
• ReplacedByWTRHydrant (type: esriFieldTypeString, alias: Replaced By Hydrant ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ReplacementForWTRHydrant (type: esriFieldTypeString, alias: Replacement For Hydrant ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ClResidualLastFree (type: esriFieldTypeDouble, alias: Chlorine Residual Free (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClResidualLastTotal (type: esriFieldTypeDouble, alias: Chlorine Residual Total (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClResidualModel (type: esriFieldTypeDouble, alias: Chlorine Residual Model (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FireFlowValidDate (type: esriFieldTypeDate, alias: Fire Flow Valid Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FireFlowGPM (type: esriFieldTypeDouble, alias: Fire Flow (gal/min), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PressureMinPSI (type: esriFieldTypeDouble, alias: Pressure Minimum (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PressureMaxPSI (type: esriFieldTypeDouble, alias: Pressure Maximum (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssumptionDate (type: esriFieldTypeDate, alias: Assumption Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PressureLoggingData (type: esriFieldTypeString, alias: Pressure Logging Data, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• LINK2_TRAFFIC_CONTROL_LAYOUT_1 (type: esriFieldTypeString, alias: Traffic Control Layout 1, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• LINK2_TRAFFIC_CONTROL_LAYOUT_2 (type: esriFieldTypeString, alias: Traffic Control Layout 2, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• FlowTestData (type: esriFieldTypeString, alias: Flow Test Data, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Enabled: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/20/2023 3:26:33 PM

Schema Last Edit Date: 3/20/2023 3:26:33 PM

Data Last Edit Date: 3/9/2023 4:34:17 PM

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