View In:   ArcGIS Online Map Viewer

Name: Irrigation Pump

Display Field: Nameplate

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A pump is a facility that moves, compresses, or alters the pressure of a fluid, such as water or air, being conveyed through a natural or artificial channel by mechanical actionSubtypes:Axial FlowCentrifugalJetReciprocatingRotaryTurbineFieldsfieldnamefieldtypeprecisionscalelengthaliasisnullabledomaindefaultInstallContractorTEXT100Install ContractorNULLABLEManufacturerTEXT30ManufacturerNULLABLESerialTEXT50SerialNULLABLEModelTEXT50ModelNULLABLEPortSizeDOUBLE388Port Size(mm)NULLABLEInletDiameterTEXT30Inlet DiameterNULLABLEirrDiameterDischargeDiameterTEXT30Discharge DiameterNULLABLEirrDiameterFlowRateRangeTEXT20Flow Rate RangeNULLABLEirrFlowRateFlowUnitsTEXT20Flow UnitsNULLABLEirrFlowUnitsPressureSettingSHORT5Pressure SettingNULLABLEHorsePowerDOUBLE388Horse PowerNULLABLEVoltsDOUBLE388VoltsNULLABLEMaxSuctionLiftDOUBLE388Max Suction LiftNULLABLEHoseAdaptersDOUBLE388Hose AdaptersNULLABLESelfPrimingSHORT5Self-PrimingNULLABLEBooleanTotalDynamicHeadDOUBLE388Total Dynamic HeadNULLABLELowSetPointDOUBLE388Low Set PointNULLABLEHighSetPointDOUBLE388High Set PointNULLABLEDefinitionFieldDescriptionInstall ContractorContractor Installing the pumpManufacturerDevice manufacturerSerial NumberDevice serial number ModelDevice modelPort Size (mm)Port diametre size in mmInlet DiameterDiameter of inlet openingDischarge DiameterDiameter of outlet openingFlow Rate RangeFlow rate rangeFlow UnitsFlow unitsPressure Setting (psi)Pressure value in psiHorse PowerHorse power capacityVoltsVolts capacityMax Suction LiftMax suction lift capacityHose AdaptersHose adapter valueSelf PrimingIs it self-priming?Total Dynamic HeadTotal dynamic head valueLow Set PointLow set point valueHigh Set PointHigh set point valuePick ListirrDiameterBooleanirrFlowRateCodeDescriptionCodeDescriptionCodeDescription1/2"1/2" (13 mm)0FALSE0-90 to 93/4"3/4" (20 mm)1TRUE10-9910 to 991"1" (25 mm)100-499100 to 4991 1/4"1 1/4" (32 mm)irrFlowUnits500-999500 to 9991 1/2"1 1/2" (40 mm)CodeDescription2"2" (50 mm)GPMGallons Per Minute2 1/2"2 1/2" (65 mm)GPHGallons Per Hour3"3" (80 mm)GPDGallons Per Day4"4" (100 mm)LPMLitres Per Minute6"6" (150 mm)LPHLitres Per Hour8"8" (200 mm)LPDLitres Per DayUNKUnknownOTHOther

Service Item Id: 87c96b8e69f647e6b963e19bc30c02f3

Copyright Text: City of Prince George

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

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: 512310.8398537834
YMin: 5982811.88274376
XMax: 512310.8603462174
YMax: 5982812.122056239
Spatial Reference: 26910  (26910)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SubType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 6
  Label: Axial Flow
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Centrifugal
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Jet
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Reciprocating
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Rotary
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Turbine
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 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: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.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: true
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: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssetID )
• LifeCycleStatus ( type: esriFieldTypeString, alias: LifeCycle Status, editable: true, nullable: true, length: 20, defaultValue: ACT, modelName: LifeCycleStatus , Coded Values: [PRP: Proposed] , [ACT: Active] , [ABN: Abandoned] , ...2 more... )
• SubType ( type: esriFieldTypeInteger, alias: SubType, editable: true, nullable: true, defaultValue: 1, modelName: SubType )
• AssetOwner ( type: esriFieldTypeSmallInteger, alias: Owner of the Asset, editable: true, nullable: true, defaultValue: null, modelName: AssetOwner , Coded Values: [1: CPG] , [-1: RDFFG] , [-2: Private] , ...3 more... )
• AssetManager ( type: esriFieldTypeSmallInteger, alias: Manager of the Asset, editable: true, nullable: true, defaultValue: null, modelName: AssetManager , Coded Values: [1: Asset] , [2: Bylaw] , [3: Civic Facility] , ...21 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• InstallContractor ( type: esriFieldTypeString, alias: Install Contractor, editable: true, nullable: true, length: 100, defaultValue: null, modelName: InstallContractor )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Manufacturer )
• Serial ( type: esriFieldTypeString, alias: Serial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Serial )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• PortSize ( type: esriFieldTypeDouble, alias: Port Size, editable: true, nullable: true, defaultValue: null, modelName: PortSize )
• InletDiameter ( type: esriFieldTypeSmallInteger, alias: Inlet Diameter, editable: true, nullable: true, defaultValue: null, modelName: InletDiameter , Coded Values: [1: 1/2" (13 mm)] , [2: 3/4" (20 mm)] , [3: 1" (25 mm)] , ...7 more... )
• DischargeDiameter ( type: esriFieldTypeSmallInteger, alias: Discharge Diameter, editable: true, nullable: true, defaultValue: null, modelName: DischargeDiameter , Coded Values: [1: 1/2" (13 mm)] , [2: 3/4" (20 mm)] , [3: 1" (25 mm)] , ...7 more... )
• FlowRate ( type: esriFieldTypeDouble, alias: Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: FlowRate )
• PressureSetting ( type: esriFieldTypeSmallInteger, alias: Pressure Setting, editable: true, nullable: true, defaultValue: null, modelName: PressureSetting )
• HorsePower ( type: esriFieldTypeDouble, alias: Horse Power, editable: true, nullable: true, defaultValue: null, modelName: HorsePower )
• Volts ( type: esriFieldTypeDouble, alias: Volts, editable: true, nullable: true, defaultValue: null, modelName: Volts )
• MaxSuctionLift ( type: esriFieldTypeDouble, alias: Max Suction Lift, editable: true, nullable: true, defaultValue: null, modelName: MaxSuctionLift )
• HoseAdapters ( type: esriFieldTypeDouble, alias: Hose Adapters, editable: true, nullable: true, defaultValue: null, modelName: HoseAdapters )
• SelfPriming ( type: esriFieldTypeSmallInteger, alias: Self Priming, editable: true, nullable: true, defaultValue: null, modelName: SelfPriming , Coded Values: [0: False] , [1: True] )
• TotalDynamicHead ( type: esriFieldTypeDouble, alias: Total Dynamic Head, editable: true, nullable: true, defaultValue: null, modelName: TotalDynamicHead )
• LowSetPoint ( type: esriFieldTypeDouble, alias: Low Set Point, editable: true, nullable: true, defaultValue: null, modelName: LowSetPoint )
• HighSetPoint ( type: esriFieldTypeDouble, alias: High Set Point, editable: true, nullable: true, defaultValue: null, modelName: HighSetPoint )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 6
Name: Axial Flow
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• InletDiameter:
  Inherited
• DischargeDiameter:
  Inherited
• SelfPriming:
  Inherited
Templates:
• Name: Axial Flow
  Description:
  Prototype:
  LifeCycleStatus: ACT
  HighSetPoint: null
  AssetID: null
  SubType: 6
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  InstallContractor: null
  Manufacturer: null
  Serial: null
  Model: null
  PortSize: null
  InletDiameter: null
  DischargeDiameter: null
  FlowRate: null
  PressureSetting: null
  HorsePower: null
  Volts: null
  MaxSuctionLift: null
  HoseAdapters: null
  SelfPriming: null
  TotalDynamicHead: null
  LowSetPoint: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Centrifugal
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• InletDiameter:
  Inherited
• DischargeDiameter:
  Inherited
• SelfPriming:
  Inherited
Templates:
• Name: Centrifugal
  Description:
  Prototype:
  LifeCycleStatus: ACT
  HighSetPoint: null
  AssetID: null
  SubType: 1
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  InstallContractor: null
  Manufacturer: null
  Serial: null
  Model: null
  PortSize: null
  InletDiameter: null
  DischargeDiameter: null
  FlowRate: null
  PressureSetting: null
  HorsePower: null
  Volts: null
  MaxSuctionLift: null
  HoseAdapters: null
  SelfPriming: null
  TotalDynamicHead: null
  LowSetPoint: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Jet
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• InletDiameter:
  Inherited
• DischargeDiameter:
  Inherited
• SelfPriming:
  Inherited
Templates:
• Name: Jet
  Description:
  Prototype:
  LifeCycleStatus: ACT
  HighSetPoint: null
  AssetID: null
  SubType: 2
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  InstallContractor: null
  Manufacturer: null
  Serial: null
  Model: null
  PortSize: null
  InletDiameter: null
  DischargeDiameter: null
  FlowRate: null
  PressureSetting: null
  HorsePower: null
  Volts: null
  MaxSuctionLift: null
  HoseAdapters: null
  SelfPriming: null
  TotalDynamicHead: null
  LowSetPoint: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Reciprocating
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• InletDiameter:
  Inherited
• DischargeDiameter:
  Inherited
• SelfPriming:
  Inherited
Templates:
• Name: Reciprocating
  Description:
  Prototype:
  LifeCycleStatus: ACT
  HighSetPoint: null
  AssetID: null
  SubType: 3
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  InstallContractor: null
  Manufacturer: null
  Serial: null
  Model: null
  PortSize: null
  InletDiameter: null
  DischargeDiameter: null
  FlowRate: null
  PressureSetting: null
  HorsePower: null
  Volts: null
  MaxSuctionLift: null
  HoseAdapters: null
  SelfPriming: null
  TotalDynamicHead: null
  LowSetPoint: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Rotary
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• InletDiameter:
  Inherited
• DischargeDiameter:
  Inherited
• SelfPriming:
  Inherited
Templates:
• Name: Rotary
  Description:
  Prototype:
  LifeCycleStatus: ACT
  HighSetPoint: null
  AssetID: null
  SubType: 4
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  InstallContractor: null
  Manufacturer: null
  Serial: null
  Model: null
  PortSize: null
  InletDiameter: null
  DischargeDiameter: null
  FlowRate: null
  PressureSetting: null
  HorsePower: null
  Volts: null
  MaxSuctionLift: null
  HoseAdapters: null
  SelfPriming: null
  TotalDynamicHead: null
  LowSetPoint: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Turbine
Domains:
• LifeCycleStatus:
  Inherited
• AssetOwner:
  Inherited
• AssetManager:
  Inherited
• InletDiameter:
  Inherited
• DischargeDiameter:
  Inherited
• SelfPriming:
  Inherited
Templates:
• Name: Turbine
  Description:
  Prototype:
  LifeCycleStatus: ACT
  HighSetPoint: null
  AssetID: null
  SubType: 5
  AssetOwner: null
  AssetManager: null
  Location: null
  InstallDate: null
  InstallContractor: null
  Manufacturer: null
  Serial: null
  Model: null
  PortSize: null
  InletDiameter: null
  DischargeDiameter: null
  FlowRate: null
  PressureSetting: null
  HorsePower: null
  Volts: null
  MaxSuctionLift: null
  HoseAdapters: null
  SelfPriming: null
  TotalDynamicHead: null
  LowSetPoint: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

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: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata