Name: Water Scada Sensor

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The SCADA sensor is a feature that’s used to remotely measure the status of network components as part of a supervisory control and data acquisition (SCADA) system. SCADA systems provide alarms, responses, data acquisition, and control for collection and distribution systems. Operators use the SCADA system to monitor and adjust processes and facilities.

Copyright Text: City of Prince George

Min. Scale: 250000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 511495.391
YMin: 5977228.803
XMax: 512315.7703
YMax: 5979530.8136
Spatial Reference: 26910 (26910)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"10496fcb4e1ddc5b914882fcbf433c4b","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAWCAYAAAArdgcFAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB8UlEQVQ4je2VMUgbYRTH/x89iVZBqDqcFXGSCi0VYwcFt+JQzkGcxEUcruCgtlVBQTjRipM4RS5bW207tIoG1MHoYIcOKijW0amtIGj1vIuJ5u7J90WFxIsQo4PQ//YeHz/+7/3fcRLuUNJ/eFprISIdQCGAv4yx17cGJyLVDJP67rMBvSWX137G2GracCLyAtAGp034l0JoeJGJ2meewPkUaTvXtndteXTeEsWbCQPr7wtkPg1jzH9jOMVcK28nDESiJHpbf6LwBS201WZrAG4OB6AFf0UwvRaOb06aaKrO4u7168JNCici1XagdIwblz2PxMQE/ywHfd+O4GvOVa8L1xVORDws1bdgYfN3FCX5DzDb9QhPZAlffx6jaexAhNv6MhtPiyR+opWpOFf2TcerTZmi6FZyUFYYe9pYlYWPP44xvxFB+6dDBHvyvDwbN/dSkhD1vu9H2Dcd0Tu1Y2Fe6OQ83MWtE0ythFFfmel6mm7ONb4KfTF02RgOmKgoycDz4gx8WA4J6IU6vxh4Ve5xPU3J7fQ6xg3YMdNCOwcOagb2XPe3vWtjZM5CT10O331yOHfNx+Tnl4qGZkw01zxEovtEuL9UlpSl3jykKiKRQ1yocXDGWICI+vEYcsp0YCfxYq4Eyhjjn/Wt6P7+5s4A8nHXMZoEcNAAAAAASUVORK5CYII=","contentType":"image/png","width":17,"height":16,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• assetid (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: LifecycleStatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
• location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• installcontractor (type: esriFieldTypeSmallInteger, alias: InstallContractor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• condition (type: esriFieldTypeDouble, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• conditiondate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• currentvalue (type: esriFieldTypeString, alias: CurrentValue, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• id (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• measurementtype (type: esriFieldTypeString, alias: MeasurementType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• acquisitioncost (type: esriFieldTypeDouble, alias: AcquisitionCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• expectedlife (type: esriFieldTypeDouble, alias: ExpectedLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• residualvalue (type: esriFieldTypeDouble, alias: ResidualValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• cofscore (type: esriFieldTypeDouble, alias: CoFScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cofdate (type: esriFieldTypeDate, alias: CoFDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• riskscore (type: esriFieldTypeDouble, alias: RiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
• ISSUBNETWORKCONTROLLER (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True], [2: Unknown])
• SUBNETWORKCONTROLLERNAME (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• TIERNAME (type: esriFieldTypeSmallInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Water Cathodic Protection], [2: Water System], ... 3 more ...)
• TIERRANK (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TERMINALCONFIGURATION (type: esriFieldTypeString, alias: Terminal path, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• cpsubnetworkname (type: esriFieldTypeString, alias: CP Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• DMASubnetworkName (type: esriFieldTypeString, alias: DMA Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• secondarydiameter (type: esriFieldTypeDouble, alias: secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressure (type: esriFieldTypeDouble, alias: pressure: Amperage, Pressure, Rated Pressure, Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designtype (type: esriFieldTypeSmallInteger, alias: designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• normalstatus (type: esriFieldTypeSmallInteger, alias: Normal Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• additionaldetails (type: esriFieldTypeSmallInteger, alias: additionaldetails: Clockwise to Close, Cooling Method, Critical, Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designinfo (type: esriFieldTypeDouble, alias: designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operable (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CPG], [-1: RDFFG], [-2: Private], ... 3 more ...)
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Asset], [2: Bylaw], [3: Civic Facility], ... 21 more ...)
• additionaldevice (type: esriFieldTypeSmallInteger, alias: additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
• lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
• cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
• manufacturer (type: esriFieldTypeSmallInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operator (type: esriFieldTypeSmallInteger, alias: Postindicator Valve, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressurezone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• groundtype (type: esriFieldTypeSmallInteger, alias: Ground Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• overflowelev (type: esriFieldTypeDouble, alias: Overflow Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nozzlediameter2 (type: esriFieldTypeDouble, alias: Nozzle Diameter 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nozzlediameter3 (type: esriFieldTypeDouble, alias: Nozzle Diameter 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nozzlediameter4 (type: esriFieldTypeDouble, alias: Nozzle Diameter 4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• seatdiameter (type: esriFieldTypeDouble, alias: Seat Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• markertype (type: esriFieldTypeSmallInteger, alias: Marker Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designflow (type: esriFieldTypeString, alias: Design Flow, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• serialnumber (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• bottomelev (type: esriFieldTypeDouble, alias: Elevation at Bottom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressurerange (type: esriFieldTypeString, alias: Pressure Range, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• pressuresettingus (type: esriFieldTypeDouble, alias: Pressure Setting Upstream, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressuresettingds (type: esriFieldTypeDouble, alias: Pressure Setting Downstream, SQL Type: sqlTypeOther, nullable: true, editable: true)
• totaldynamichead (type: esriFieldTypeInteger, alias: Total Dynamic Head, SQL Type: sqlTypeOther, nullable: true, editable: true)
• depth (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• percentopen (type: esriFieldTypeInteger, alias: Percent Open, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: Parent Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• subtypetext (type: esriFieldTypeString, alias: Subtype Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Water Scada Sensor
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• enabled: 1
• VALIDATIONSTATUS: 6
• lifecyclestatus: ACT
• ASSETGROUP: 0
• ASSETTYPE: 0
• ASSOCIATIONSTATUS: 0
• ISSUBNETWORKCONTROLLER: 0
• ISCONNECTED: 2
• SUBNETWORKCONTROLLERNAME: Unknown
• TIERNAME: 0
• TIERRANK: 0
• TERMINALCONFIGURATION: Default
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• SystemSubnetworkName: Unknown
• PressureSubnetworkName: Unknown
• IsolationSubnetworkName: Unknown
• DMASubnetworkName: Unknown
• cptraceability: 0

Is Data Versioned: false

Has Contingent Values: true

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/26/2025 3:23:56 AM

Schema Last Edit Date: 7/26/2025 3:23:56 AM

Data Last Edit Date: 7/26/2025 3:23:56 AM

Child Resources:   Field Groups   Contingent Values

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