View In:   ArcGIS Online Map Viewer

Parent Layer: Private

Name: Water Private Hydrant

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 6bfb677752f64a949b705b790e98607d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Effective Min Scale: 5000

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, editable: true, nullable: true, defaultValue: 0, modelName: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: FACILITYID )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 30, defaultValue: CITY OF KAMLOOPS, modelName: Owner , 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: SubtypeHydrant, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeHydrant )
• ACQUIREDATE ( type: esriFieldTypeDate, alias: ACQUIREDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACQUIREDATE )
• ACQUIRESOURCE ( type: esriFieldTypeString, alias: AcquireSource, editable: true, nullable: true, length: 10, defaultValue: PURCHASED, modelName: AcquireSource , Coded Values: [PURCHASED: Purchased] , [DONATED: Donated] , [LEASED: Leased] , ...1 more... )
• DEPRECIATIONLIFE ( type: esriFieldTypeSmallInteger, alias: DEPRECIATIONLIFE, editable: true, nullable: true, defaultValue: 40, modelName: DEPRECIATIONLIFE , Coded Values: [4: 4] , [5: 5] , [10: 10] , ...10 more... )
• AMGROUP ( type: esriFieldTypeString, alias: AMGroup, editable: true, nullable: true, length: 25, defaultValue: WATER NETWORK, modelName: AMGroup , Coded Values: [BUILDING: Building] , [COMMUNICATION NETWORK: Communication Network] , [COMPUTING INFRASTRUCTURE: Computing Infrastructure] , ...8 more... )
• ACQUIRECOST ( type: esriFieldTypeInteger, alias: ACQUIRECOST, editable: true, nullable: true, defaultValue: null, modelName: ACQUIRECOST )
• STREETNO ( type: esriFieldTypeString, alias: STREETNO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STREETNO )
• USEFLAG ( type: esriFieldTypeString, alias: UseFlag, editable: true, nullable: true, length: 7, defaultValue: YES, modelName: UseFlag , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MODEL )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• THEORETICALFLOW ( type: esriFieldTypeInteger, alias: THEORETICALFLOW, editable: true, nullable: true, defaultValue: null, modelName: THEORETICALFLOW )
• TESTFLOW ( type: esriFieldTypeInteger, alias: TESTFLOW, editable: true, nullable: true, defaultValue: null, modelName: TESTFLOW )
• FLOWDIFFERENTIAL ( type: esriFieldTypeInteger, alias: FLOWDIFFERENTIAL, editable: true, nullable: true, defaultValue: null, modelName: FLOWDIFFERENTIAL )
• TESTDATE ( type: esriFieldTypeDate, alias: TESTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TESTDATE )
• STATICPRESSURE ( type: esriFieldTypeInteger, alias: STATICPRESSURE, editable: true, nullable: true, defaultValue: null, modelName: STATICPRESSURE )
• RESIDUALPRESSURE ( type: esriFieldTypeInteger, alias: RESIDUALPRESSURE, editable: true, nullable: true, defaultValue: null, modelName: RESIDUALPRESSURE )
• HOSEMONSTERRESIDUALPRESSURE ( type: esriFieldTypeInteger, alias: HOSEMONSTERRESIDUALPRESSURE, editable: true, nullable: true, defaultValue: null, modelName: HOSEMONSTERRESIDUALPRESSURE )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, editable: true, nullable: true, length: 30, defaultValue: null, modelName: INSPECTOR )
• PROBLEMCODE ( type: esriFieldTypeString, alias: PROBLEMCODE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PROBLEMCODE )
• CAPTURESTATUS ( type: esriFieldTypeString, alias: CaptureStatus, editable: true, nullable: true, length: 30, defaultValue: PRELIMINARY, modelName: CaptureStatus , Coded Values: [AS BUILT: As Built] , [PRELIMINARY: Preliminary] , [UNKNOWN: Unknown] )
• BUDGETFUNCTION ( type: esriFieldTypeString, alias: BudgetFunction, editable: true, nullable: true, length: 4, defaultValue: 820, modelName: BudgetFunction , Coded Values: [100: 100-Solid Waste] , [140: 140-Environmental Services] , [150: 150-Cemetery] , ...11 more... )
• FINANCIALASSETFLAG ( type: esriFieldTypeString, alias: FinancialAssetFlag, editable: true, nullable: true, length: 3, defaultValue: ZZZ, modelName: FinancialAssetFlag , Coded Values: [YES: Yes] , [NO: No] , [N/A: N/A] , ...1 more... )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 20, defaultValue: TYPE1-TS, modelName: Type , Coded Values: [TYPE1-T: Type1-t] , [TYPE1-TS: Type1-ts] , [TYPE1-S: Type1-s] , ...3 more... )
• HYDRANTNO ( type: esriFieldTypeInteger, alias: HYDRANTNO, editable: true, nullable: true, defaultValue: null, modelName: HYDRANTNO )
• CAPTUREMETHOD ( type: esriFieldTypeString, alias: CaptureMethod, editable: true, nullable: true, length: 12, defaultValue: null, modelName: CaptureMethod , Coded Values: [COGO: Cogo] , [DIGITIZE: Digitize] , [ELECTRONIC: Electronic] , ...5 more... )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Crew , Coded Values: [A: A] , [B: B] , [C: C] , ...3 more... )
• NONNETWORKCAPACITY ( type: esriFieldTypeInteger, alias: NONNETWORKCAPACITY, editable: true, nullable: true, defaultValue: 0, modelName: NONNETWORKCAPACITY )
• CAPITALPROJECTNO ( type: esriFieldTypeString, alias: CAPITALPROJECTNO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CAPITALPROJECTNO )
• PUBLICWORKSNOTIFYFLAG ( type: esriFieldTypeString, alias: PublicWorksNotifyFlag, editable: true, nullable: true, length: 7, defaultValue: UNKNOWN, modelName: PublicWorksNotifyFlag , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] )
• ASSETSTATUS ( type: esriFieldTypeString, alias: AssetStatus, editable: true, nullable: true, length: 15, defaultValue: IN SERVICE, modelName: AssetStatus , Coded Values: [IN SERVICE: In Service] , [OUT OF SERVICE: Out of Service] , [DISPOSED: Disposed] , ...4 more... )
• MONITORFLAG ( type: esriFieldTypeString, alias: MonitorFlag, editable: true, nullable: true, length: 7, defaultValue: NO, modelName: MonitorFlag , Coded Values: [YES: Yes] , [NO: No] , [UNKNOWN: Unknown] )
• STATIONNO ( type: esriFieldTypeString, alias: StationNo, editable: true, nullable: true, length: 3, defaultValue: null, modelName: StationNo , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• MAPHYDRANTNO ( type: esriFieldTypeString, alias: MAPHYDRANTNO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAPHYDRANTNO )
• MAP ( type: esriFieldTypeString, alias: MAP, editable: true, nullable: true, length: 6, defaultValue: null, modelName: MAP )
• MAKE ( type: esriFieldTypeString, alias: MAKE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MAKE )
• STREETPREFIX ( type: esriFieldTypeString, alias: STREETPREFIX, editable: true, nullable: true, length: 2, defaultValue: null, modelName: StreetPrefix , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: STREETNAME )
• STREETNAMETYPE ( type: esriFieldTypeString, alias: STREETNAMETYPE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: StreetNameType , Coded Values: [ST: Street] , [DR: Drive] , [RD: Road] , ...16 more... )
• STREETSUFFIX ( type: esriFieldTypeString, alias: STREETSUFFIX, editable: true, nullable: true, length: 1, defaultValue: null, modelName: StreetSuffix , Coded Values: [N: N] , [S: S] , [E: E] , ...1 more... )
• MHGL ( type: esriFieldTypeInteger, alias: MHGL, editable: true, nullable: true, defaultValue: null, modelName: MHGL )
• FDMID ( type: esriFieldTypeString, alias: FDMID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: FDMID )
• PORTCOUNT ( type: esriFieldTypeString, alias: PORTCOUNT, editable: true, nullable: true, length: 7, defaultValue: UNKNOWN, modelName: PortCount , Coded Values: [2: 2] , [3: 3] , [UNKNOWN: Unknown] )
• VALVETYPE ( type: esriFieldTypeString, alias: VALVETYPE, editable: true, nullable: true, length: 12, defaultValue: UNKNOWN, modelName: ValveType , Coded Values: [COMPRESSION: Compression] , [SLIDE: Slide] , [UNKNOWN: Unknown] )
• FLOWMETHOD ( type: esriFieldTypeString, alias: FLOWMETHOD, editable: true, nullable: true, length: 20, defaultValue: HOSE MONSTER, modelName: FlowMethod , 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, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• AGE ( type: esriFieldTypeSmallInteger, alias: AGE, editable: true, nullable: true, defaultValue: null, modelName: AGE )
• WORKORDERNO ( type: esriFieldTypeString, alias: WorkOrderNo, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WORKORDERNO )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 120, defaultValue: null, modelName: COMMENTS )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• INSPECTIONDATE ( type: esriFieldTypeDate, alias: INSPECTIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTIONDATE )
• ZONE ( type: esriFieldTypeString, alias: ZONE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ZONE )
• FLOWTESTSEQUENCE ( type: esriFieldTypeSmallInteger, alias: FlowTestSequence, editable: true, nullable: true, defaultValue: null, modelName: FLOWTESTSEQUENCE )
• FLOWTESTRESPONSIBILITY ( type: esriFieldTypeString, alias: FlowTestResponsibility, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FLOWTESTRESPONSIBILITY , Coded Values: [CIVIC OPS: Civic Ops] , [KFR: KFR] , [PRIVATE: Private] )
• FLOWTESTYEAR ( type: esriFieldTypeSmallInteger, alias: FlowTestYear, editable: true, nullable: true, defaultValue: null, modelName: FLOWTESTYEAR )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• SERVICELEVEL ( type: esriFieldTypeString, alias: Service Level, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SERVICELEVEL , 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICEDATE )
• LASTSERVICECREW ( type: esriFieldTypeString, alias: Last Service Crew, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LASTSERVICECREW , Coded Values: [S HELLY: Susan Helly] , [UNKNOWN: Unknown] , [A MACUS: Al Macus] , ...17 more... )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ADDRESS )

Templates:

• Name: Water Private Hydrant
  Description:
  Prototype:
  OWNER: CITY OF KAMLOOPS
  LASTSERVICECREW: null
  ANCILLARYROLE: 0
  ENABLED: 1
  FACILITYID: null
  SUBTYPEHYDRANT: 1
  ACQUIREDATE: null
  ACQUIRESOURCE: PURCHASED
  DEPRECIATIONLIFE: 40
  AMGROUP: WATER NETWORK
  ACQUIRECOST: null
  STREETNO: null
  USEFLAG: YES
  MODEL: null
  ELEVATION: null
  THEORETICALFLOW: null
  TESTFLOW: null
  FLOWDIFFERENTIAL: null
  TESTDATE: null
  STATICPRESSURE: null
  RESIDUALPRESSURE: null
  HOSEMONSTERRESIDUALPRESSURE: null
  INSPECTOR: null
  PROBLEMCODE: null
  CAPTURESTATUS: PRELIMINARY
  BUDGETFUNCTION: 820
  FINANCIALASSETFLAG: ZZZ
  TYPE: TYPE1-TS
  HYDRANTNO: null
  CAPTUREMETHOD: null
  CREW: null
  NONNETWORKCAPACITY: 0
  CAPITALPROJECTNO: null
  PUBLICWORKSNOTIFYFLAG: UNKNOWN
  ASSETSTATUS: IN SERVICE
  MONITORFLAG: NO
  STATIONNO: null
  MAPHYDRANTNO: null
  MAP: null
  MAKE: null
  STREETPREFIX: null
  STREETNAME: null
  STREETNAMETYPE: null
  STREETSUFFIX: null
  MHGL: null
  FDMID: null
  PORTCOUNT: UNKNOWN
  VALVETYPE: UNKNOWN
  FLOWMETHOD: HOSE MONSTER
  LASTSERVICEDATE: null
  SERVICELEVEL: null
  ADDRESS: null
  FLOWTESTYEAR: null
  AGE: null
  WORKORDERNO: null
  COMMENTS: null
  LOCATION: null
  INSPECTIONDATE: null
  ZONE: null
  FLOWTESTSEQUENCE: null
  FLOWTESTRESPONSIBILITY: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• GIS.HydrantHistory (11) -- Related To: HydrantHistory (852)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata