Layers:

Layer: Water Hydrant (0)

Name: Water Hydrant

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ec5603786cbc46f8ac6b7ed83238c91f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 674814.4762
YMin: 5611358.769
XMax: 709051.2341
YMax: 5637931.5146
Spatial Reference: 3157  (3157)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Feature Draw Order:
N/A
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPEHYDRANT

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: Ancillary Role , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Id, length: 12 )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 30 , Coded Values: [CITY OF KAMLOOPS: City of Kamloops (C)] , [HEFFLEY WATER DISTRICT: Heffley Water District (H)] , [PRIVATE: Private (P)] , ...3 more... )
• SUBTYPEHYDRANT ( type: esriFieldTypeInteger, alias: Subtype )
• ACQUIREDATE ( type: esriFieldTypeDate, alias: Acquire Date, length: 8 )
• ACQUIRESOURCE ( type: esriFieldTypeString, alias: Acquire Source, length: 10 , Coded Values: [PURCHASED: Purchased] , [DONATED: Donated] , [LEASED: Leased] , ...1 more... )
• DEPRECIATIONLIFE ( type: esriFieldTypeSmallInteger, alias: Depreciation Life , Coded Values: [4: 4] , [5: 5] , [10: 10] , ...10 more... )
• AMGROUP ( type: esriFieldTypeString, alias: AM Group, length: 25 , Coded Values: [BUILDING: Building] , [COMMUNICATION NETWORK: Communication Network] , [COMPUTING INFRASTRUCTURE: Computing Infrastructure] , ...8 more... )
• ACQUIRECOST ( type: esriFieldTypeInteger, alias: Acquire Cost )
• STREETNO ( type: esriFieldTypeString, alias: Street Number, length: 30 )
• USEFLAG ( type: esriFieldTypeString, alias: Use? (Yes/No), length: 7 , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 20 )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation )
• THEORETICALFLOW ( type: esriFieldTypeInteger, alias: Theoretical Flow )
• TESTFLOW ( type: esriFieldTypeInteger, alias: Test Flow )
• FLOWDIFFERENTIAL ( type: esriFieldTypeInteger, alias: Flow Differential )
• TESTDATE ( type: esriFieldTypeDate, alias: Test Date, length: 8 )
• STATICPRESSURE ( type: esriFieldTypeInteger, alias: Static Pressure )
• RESIDUALPRESSURE ( type: esriFieldTypeInteger, alias: Residual Pressure )
• HOSEMONSTERRESIDUALPRESSURE ( type: esriFieldTypeInteger, alias: Hosemonster Residual Pressure )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, length: 30 )
• PROBLEMCODE ( type: esriFieldTypeString, alias: Problem Code, length: 20 )
• CAPTURESTATUS ( type: esriFieldTypeString, alias: Capture Status, length: 30 , Coded Values: [AS BUILT: As Built] , [PRELIMINARY: Preliminary] , [UNKNOWN: Unknown] )
• BUDGETFUNCTION ( type: esriFieldTypeString, alias: Budget Function, length: 4 , Coded Values: [100: 100-Solid Waste] , [140: 140-Environmental Services] , [150: 150-Cemetery] , ...11 more... )
• FINANCIALASSETFLAG ( type: esriFieldTypeString, alias: Financial Asset Flag, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [N/A: N/A] , ...1 more... )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 20 , Coded Values: [TYPE1-T: Type1-t] , [TYPE1-TS: Type1-ts] , [TYPE1-S: Type1-s] , ...3 more... )
• HYDRANTNO ( type: esriFieldTypeInteger, alias: Hydrant Number )
• CAPTUREMETHOD ( type: esriFieldTypeString, alias: Capture Method, length: 12 , Coded Values: [COGO: Cogo] , [DIGITIZE: Digitize] , [ELECTRONIC: Electronic] , ...5 more... )
• CREW ( type: esriFieldTypeString, alias: Crew, length: 3 , Coded Values: [A: A] , [B: B] , [C: C] , ...3 more... )
• NONNETWORKCAPACITY ( type: esriFieldTypeInteger, alias: Non-network Capacity )
• CAPITALPROJECTNO ( type: esriFieldTypeString, alias: Capital Project Number, length: 15 )
• PUBLICWORKSNOTIFYFLAG ( type: esriFieldTypeString, alias: Notify Public Works? (Yes/No), length: 7 , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] )
• ASSETSTATUS ( type: esriFieldTypeString, alias: Asset Status, length: 15 , Coded Values: [IN SERVICE: In Service] , [OUT OF SERVICE: Out of Service] , [DISPOSED: Disposed] , ...4 more... )
• MONITORFLAG ( type: esriFieldTypeString, alias: Monitor? (Yes/No), length: 7 , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] )
• STATIONNO ( type: esriFieldTypeString, alias: Station Number, length: 3 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• MAPHYDRANTNO ( type: esriFieldTypeString, alias: Map Hydrant Number, length: 10 )
• MAP ( type: esriFieldTypeString, alias: Map, length: 6 )
• MAKE ( type: esriFieldTypeString, alias: Make, length: 30 )
• STREETPREFIX ( type: esriFieldTypeString, alias: Street Prefix, length: 2 , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• STREETNAME ( type: esriFieldTypeString, alias: Street Name, length: 40 )
• STREETNAMETYPE ( type: esriFieldTypeString, alias: Street Name Type, length: 6 , Coded Values: [ST: Street] , [DR: Drive] , [RD: Road] , ...16 more... )
• STREETSUFFIX ( type: esriFieldTypeString, alias: Street Suffix, length: 1 , Coded Values: [N: N] , [S: S] , [E: E] , ...1 more... )
• MHGL ( type: esriFieldTypeInteger, alias: MHGL )
• FDMID ( type: esriFieldTypeString, alias: FDM Id, length: 12 )
• PORTCOUNT ( type: esriFieldTypeString, alias: Port Count, length: 7 , Coded Values: [2: 2] , [3: 3] , [UNKNOWN: Unknown] )
• VALVETYPE ( type: esriFieldTypeString, alias: Valve Type, length: 12 , Coded Values: [COMPRESSION: Compression] , [SLIDE: Slide] , [UNKNOWN: Unknown] )
• FLOWMETHOD ( type: esriFieldTypeString, alias: Flow Method, length: 20 , Coded Values: [FLOW TUBE: Flow Tube] , [HOSE MONSTER: Hose Monster] , [4" HOSE MONSTER: 4" Hose Monster] , ...3 more... )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• AGE ( type: esriFieldTypeSmallInteger, alias: Age )
• WORKORDERNO ( type: esriFieldTypeString, alias: Work Order Number, length: 10 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 120 )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 50 )
• INSPECTIONDATE ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• ZONE ( type: esriFieldTypeString, alias: Zone, length: 50 )
• FLOWTESTSEQUENCE ( type: esriFieldTypeSmallInteger, alias: Flow Test Sequence )
• FLOWTESTRESPONSIBILITY ( type: esriFieldTypeString, alias: Flow Test Responsibility, length: 30 , Coded Values: [CIVIC OPS: Civic Ops] , [KFR: KFR] , [PRIVATE: Private] )
• FLOWTESTYEAR ( type: esriFieldTypeSmallInteger, alias: Flow Test Year )
• SERVICELEVEL ( type: esriFieldTypeString, alias: Service Level, length: 20 , Coded Values: [NOT APPLICABLE: Not Applicable] , [ONCE A WEEK: Once a week] , [EVERY 2 WEEKS: Every 2 weeks] , ...4 more... )
• LASTSERVICEDATE ( type: esriFieldTypeDate, alias: Last Service Date, length: 8 )
• LASTSERVICECREW ( type: esriFieldTypeString, alias: Last Service Crew, length: 20 , Coded Values: [S HELLY: Susan Helly] , [UNKNOWN: Unknown] , [A MACUS: Al Macus] , ...17 more... )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 40 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
Types:
ID: 1
Name: W_Hydrant
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• OWNER:
  Inherited
• ACQUIRESOURCE:
  Inherited
• DEPRECIATIONLIFE:
  Inherited
• AMGROUP:
  Inherited
• USEFLAG:
  Inherited
• CAPTURESTATUS:
  Inherited
• BUDGETFUNCTION:
  Inherited
• FINANCIALASSETFLAG:
  Inherited
• TYPE:
  Inherited
• CAPTUREMETHOD:
  Inherited
• CREW:
  Inherited
• PUBLICWORKSNOTIFYFLAG:
  Inherited
• ASSETSTATUS:
  Inherited
• MONITORFLAG:
  Inherited
• STATIONNO:
  Inherited
• STREETPREFIX:
  Inherited
• STREETNAMETYPE:
  Inherited
• STREETSUFFIX:
  Inherited
• PORTCOUNT:
  Inherited
• VALVETYPE:
  Inherited
• FLOWMETHOD:
  Inherited
• FLOWTESTRESPONSIBILITY:
  Inherited

---

Relationships:

• HydrantHistory (0) -- Related To: HydrantHistory (1)

Tables:

Table: HydrantHistory (1)

Name: HydrantHistory

Display Field: PARENTID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: ec5603786cbc46f8ac6b7ed83238c91f

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PARENTID ( type: esriFieldTypeString, alias: PARENTID, length: 12 )
• THEORETICALFLOW ( type: esriFieldTypeInteger, alias: THEORETICALFLOW )
• TESTFLOW ( type: esriFieldTypeInteger, alias: TESTFLOW )
• FLOWDIFFERENTIAL ( type: esriFieldTypeInteger, alias: FLOWDIFFERENTIAL )
• TESTDATE ( type: esriFieldTypeDate, alias: TESTDATE, length: 8 )
• STATICPRESSURE ( type: esriFieldTypeInteger, alias: STATICPRESSURE )
• RESIDUALPRESSURE ( type: esriFieldTypeInteger, alias: RESIDUALPRESSURE )
• HOSEMONSTERRESIDUALPRESSURE ( type: esriFieldTypeInteger, alias: HOSEMONSTERRESIDUALPRESSURE )
• NONNETWORKCAPACITY ( type: esriFieldTypeInteger, alias: NONNETWORKCAPACITY )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, length: 30 )
• PROBLEMCODE ( type: esriFieldTypeString, alias: PROBLEMCODE, length: 20 )
• FLOWMETHOD ( type: esriFieldTypeString, alias: FLOWMETHOD, length: 20 )

Relationships:

• WHydrant (0) -- Related To: Water Hydrant (0)