Name: Valve Inspections

Display Field: ENTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;font-size:12pt"><P><SPAN>Defn was:</SPAN></P><P><SPAN STYLE="font-size:16pt"><SPAN>(</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>LASTACTIVITY</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>=</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>'EXE'</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>Or</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>LASTACTIVITY</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>=</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>'FVI'</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>)</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>And</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>DATESTAMP</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>&gt;=</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>TO_DATE</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>(</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>'2023-01-01 00:00:00'</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>,</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>'YYYY-MM-DD HH24:MI:SS'</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>)</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>And</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>VALVE_FUNCTION</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>&lt;&gt;</SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN> </SPAN></SPAN><SPAN STYLE="font-size:16pt"><SPAN>'Hydrant Valve'</SPAN></SPAN></P></DIV>

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 531867.46262471
YMin: 4809245.72102861
XMax: 542343.77762471
YMax: 4819866.24292861
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [76, 230, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...4 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• VALVE_FUNCTION ( type: esriFieldTypeString, alias: VALVE_FUNCTION, length: 20 , Coded Values: [Control Valve: Control Valve] , [Flushing Valve: Flushing Valve] , [Hydrant Valve: Hydrant Valve] , ...3 more... )
• VALVE_TYPE ( type: esriFieldTypeString, alias: VALVE_TYPE, length: 30 , Coded Values: [Butterfly Valve: Butterfly Valve] , [Curb Stop: Curb Stop] , [Gate Valve: Gate Valve] , ...9 more... )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID )
• ENTNAME ( type: esriFieldTypeString, alias: ENTNAME, length: 50 )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: SEGMENT_ID )
• VAIL_ID ( type: esriFieldTypeInteger, alias: VAIL_ID )
• CIVIC_ADDRESS ( type: esriFieldTypeString, alias: CIVIC_ADDRESS, length: 80 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 30 , Coded Values: [City of Waterloo: City of Waterloo] , [City of Kitchener: City of Kitchener] , [Region of Waterloo: Region of Waterloo] , ...12 more... )
• VALVE_MAKE ( type: esriFieldTypeString, alias: VALVE_MAKE, length: 20 , Coded Values: [AMERD: AMERD] , [COREY: COREY] , [CLOW: CLOW] , ...18 more... )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, length: 50 )
• POSITION_ACCURACY ( type: esriFieldTypeString, alias: POSITION_ACCURACY, length: 50 , Coded Values: [Digitized +/- 2m: Digitized +/- 2m] , [Total Station +/- 0.5m: Total Station +/- 0.5m] , [AutoCAD Drawings +/- 1m: AutoCAD Drawings +/- 1m] , ...10 more... )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: DIAMETER , Coded Values: [25: 25] , [50: 50] , [100: 100] , ...16 more... )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, length: 200 )
• ASSUMPTIONSTATUS ( type: esriFieldTypeString, alias: ASSUMPTIONSTATUS, length: 30 , Coded Values: [Assumed by City of Waterloo: Assumed by City of Waterloo] , [NA: NA] , [On Maintenance: On Maintenance] )
• STARTOFMAINTDATE ( type: esriFieldTypeDate, alias: STARTOFMAINTDATE, length: 8 )
• FINALACCEPTANCEDATE ( type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, length: 8 )
• REMOVED_DATE ( type: esriFieldTypeDate, alias: REMOVED_DATE, length: 8 )
• OPENSTATUS ( type: esriFieldTypeString, alias: OPENSTATUS, length: 6 , Coded Values: [Open: Open] , [Closed: Closed] )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 50 )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• SURFACE_ELEVATION ( type: esriFieldTypeDouble, alias: SURFACE_ELEVATION )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, length: 8 )
• CREATE_USER ( type: esriFieldTypeString, alias: CREATE_USER, length: 16 )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, length: 8 )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, length: 16 )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, length: 20 )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LASTACTIVITY, length: 4 , Coded Values: [INST: Installation] , [UPDT: Update Info] , [EXE: Exercise Valve] , ...6 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, length: 8 )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, length: 5 )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, length: 30 )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, length: 30 )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OPERATIONALSTATUS, length: 10 , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...3 more... )
• TURNTOOPERATE ( type: esriFieldTypeDouble, alias: TURNTOOPERATE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH )
• GPSX ( type: esriFieldTypeDouble, alias: GPSX )
• GPSY ( type: esriFieldTypeDouble, alias: GPSY )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, length: 500 )
• OPERATIONALCOMMENTS ( type: esriFieldTypeString, alias: OPERATIONALCOMMENTS, length: 200 )
• CLOCKWISETOCLOSE ( type: esriFieldTypeString, alias: CLOCKWISETOCLOSE, length: 4 )
• UPDATEGPS ( type: esriFieldTypeString, alias: UPDATEGPS, length: 4 )
• MANUALTURN ( type: esriFieldTypeString, alias: MANUALTURN, length: 1 , Coded Values: [Y: Y] , [N: N] )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 80 )
• HIGHTORQUE ( type: esriFieldTypeSmallInteger, alias: HIGHTORQUE )
• TORQUEDATA ( type: esriFieldTypeString, alias: TORQUEDATA, length: 1073741822 )
• GLAND_LEAK ( type: esriFieldTypeString, alias: GLAND_LEAK, length: 20 , Coded Values: [No gland leak: No gland leak] , [Steady: Steady] , [Stops when jammed: Stops when jammed] , ...1 more... )
• OPERATING_NUT ( type: esriFieldTypeString, alias: OPERATING_NUT, length: 16 , Coded Values: [Good Condition: Good Condition] , [Broken Off: Broken Off] , [Rounded: Rounded] , ...2 more... )
• VALVE_BROKEN ( type: esriFieldTypeString, alias: VALVE_BROKEN, length: 20 , Coded Values: [Good Condition: Good Condition] , [Valve Broken Open: Valve Broken Open] , [Valve Broken Closed: Valve Broken Closed] , ...3 more... )
• VALVE_BOX ( type: esriFieldTypeString, alias: VALVE_BOX, length: 20 , Coded Values: [Good Condition: Good Condition] , [Valve Box Broken: Valve Box Broken] , [Valve Box Shifted: Valve Box Shifted] , ...6 more... )
• VALVE_TURNS ( type: esriFieldTypeString, alias: VALVE_TURNS, length: 12 , Coded Values: [Normal: Normal] , [Above Normal: Above Normal] , [Below Normal: Below Normal] , ...1 more... )
• VALVE_PRIORITY ( type: esriFieldTypeString, alias: VALVE_PRIORITY, length: 12 , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...2 more... )
• VALVE_ACTION ( type: esriFieldTypeString, alias: VALVE_ACTION, length: 30 )
• PRESSURE_ZONE ( type: esriFieldTypeString, alias: PRESSURE_ZONE, length: 20 )
• ASSET_CLASS_OLD ( type: esriFieldTypeString, alias: ASSET_CLASS_OLD, length: 30 , Coded Values: [Bridges: Bridges] , [BIA: BIA] , [Cemeteries: Cemeteries] , ...19 more... )
• FACILITY_ID ( type: esriFieldTypeInteger, alias: FACILITY_ID )
• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, length: 50 , Coded Values: [AAANA: NA] , [Ainsworth Park: Ainsworth Park] , [Albert Green: Albert Green] , ...338 more... )
• FLUSHING_ZONE ( type: esriFieldTypeString, alias: FLUSHING_ZONE, length: 20 )
• ASSET_MANAGER ( type: esriFieldTypeString, alias: ASSET_MANAGER, length: 30 , Coded Values: [Cemeteries: Cemeteries] , [Facilities: Facilities] , [Parks: Parks] , ...15 more... )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• ASSET_CLASS ( type: esriFieldTypeString, alias: ASSET_CLASS, length: 30 , Coded Values: [Bridges: Bridges] , [BIA: BIA] , [Cemeteries: Cemeteries] , ...19 more... )
• VFA_CAMPUS_ID ( type: esriFieldTypeString, alias: VFA_CAMPUS_ID, length: 20 )
• VFA_CAMPUS_NAME ( type: esriFieldTypeString, alias: VFA_CAMPUS_NAME, length: 80 , Coded Values: [AAANA: NA] , [Ainsworth Park: Ainsworth Park] , [Albert Green: Albert Green] , ...338 more... )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata