Name: Hydrant 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>'INSP'</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>'FIRE'</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></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: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 531870.79472471
YMin: 4809092.57982861
XMax: 542331.95332471
YMax: 4819833.37282861
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [197, 0, 255, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [DATESTAMP]
Use Coded Values: true
Symbol:
Color: [168, 0, 132, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1000.0
Max. Scale: 0.0

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... )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID )
• HYDRANT_ID ( type: esriFieldTypeDouble, alias: HYDRANT_ID )
• ENTNAME ( type: esriFieldTypeString, alias: ENTNAME, length: 20 )
• 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... )
• 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... )
• MAIN_DIAMETER ( type: esriFieldTypeSmallInteger, alias: MAIN_DIAMETER , Coded Values: [25: 25] , [50: 50] , [100: 100] , ...16 more... )
• HYDRANT_MAKE ( type: esriFieldTypeString, alias: HYDRANT_MAKE, length: 20 , Coded Values: [AMERD: AMERD] , [COREY: COREY] , [CLOW: CLOW] , ...18 more... )
• DISTANCE_HYD_TO_VALVE ( type: esriFieldTypeSingle, alias: DISTANCE_HYD_TO_VALVE )
• NUMBER_OF_OUTLETS ( type: esriFieldTypeSmallInteger, alias: NUMBER_OF_OUTLETS )
• STORTZ_CONNECTION ( type: esriFieldTypeString, alias: STORTZ_CONNECTION, length: 20 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• DRAINHOLES_CAPPED ( type: esriFieldTypeString, alias: DRAINHOLES_CAPPED, length: 20 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• BARREL_TYPE ( type: esriFieldTypeString, alias: BARREL_TYPE, length: 20 )
• ATLAS_TILE ( type: esriFieldTypeString, alias: ATLAS_TILE, length: 10 )
• HYDRANT_FLOW ( type: esriFieldTypeString, alias: HYDRANT_FLOW, length: 50 )
• COLOUR_CODE ( type: esriFieldTypeString, alias: COLOUR_CODE, length: 20 , Coded Values: [Blue: Blue] , [Green: Green] , [Orange: Orange] , ...1 more... )
• PRESSURE_ZONE ( type: esriFieldTypeString, alias: PRESSURE_ZONE, length: 20 )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, length: 80 )
• 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 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 200 )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• 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] , [INSP: Inspection] , ...5 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: 5 , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...3 more... )
• FLOWGPM ( type: esriFieldTypeSmallInteger, alias: FLOWGPM )
• FLOW20 ( type: esriFieldTypeSmallInteger, alias: FLOW20 )
• STATICPSI ( type: esriFieldTypeSmallInteger, alias: STATICPSI )
• RESIDPSI ( type: esriFieldTypeSmallInteger, alias: RESIDPSI )
• PITOT ( type: esriFieldTypeSmallInteger, alias: PITOT )
• FLOWMINS ( type: esriFieldTypeString, alias: FLOWMINS, length: 7 )
• GALUSED ( type: esriFieldTypeString, alias: GALUSED, length: 20 )
• ISOVALVE ( type: esriFieldTypeString, alias: ISOVALVE, length: 4 )
• OPERATIONCOMMENTS ( type: esriFieldTypeString, alias: OPERATIONCOMMENTS, length: 200 , Coded Values: [BranchValveNS: Branch valve needs service] , [Broken Barrel: Broken Barrel] , [Broken Stem: Broken Stem] , ...6 more... )
• HYDRANTREPAIRS ( type: esriFieldTypeString, alias: HYDRANTREPAIRS, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• PITOT2 ( type: esriFieldTypeSmallInteger, alias: PITOT2 )
• FLOWGPM2 ( type: esriFieldTypeSmallInteger, alias: FLOWGPM2 )
• RESIDUAL_HYDRANT ( type: esriFieldTypeString, alias: RESIDUAL_HYDRANT, length: 20 )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, length: 500 )
• REPAIRS_NEEDED ( type: esriFieldTypeString, alias: REPAIRS_NEEDED, length: 50 , Coded Values: [Major: Major] , [Minor: Minor] )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• HYDRANT_DRAINAGE ( type: esriFieldTypeString, alias: HYDRANT_DRAINAGE, length: 20 , Coded Values: [Yes: Yes] , [No: No] )
• HYDRANT_OPERATION_NUT ( type: esriFieldTypeString, alias: HYDRANT_OPERATION_NUT, length: 20 , Coded Values: [needs service: needs service] , [good condition: good condition] )
• HYDRANT_PAINTING ( type: esriFieldTypeString, alias: HYDRANT_PAINTING, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• ASSET_CLASS_OLD ( type: esriFieldTypeString, alias: ASSET_CLASS_OLD, length: 30 , Coded Values: [Bridges: Bridges] , [BIA: BIA] , [Cemeteries: Cemeteries] , ...19 more... )
• FACILITY_ID ( type: esriFieldTypeSmallInteger, 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