View In:   ArcGIS Online Map Viewer

Name: GIS_Planning.DBO.InsuredSewerPumpStations_Joined

Display Field: Pump_Station_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9bbb7a2b7b964ed596853ec3965d0458

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 2622304.575483218
YMin: 551043.5666083992
XMax: 2726822.8730078936
YMax: 613447.2403572202
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Pump_Station_Name ( type: esriFieldTypeString, alias: Pump Station Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Station_Name )
• Wetwell_Length ( type: esriFieldTypeDouble, alias: Wetwell Length, editable: true, nullable: true, defaultValue: null, modelName: Wetwell_Length )
• Wetwell_Width ( type: esriFieldTypeDouble, alias: Wetwell Width, editable: true, nullable: true, defaultValue: null, modelName: Wetwell_Width )
• Wetwell_Diameter ( type: esriFieldTypeDouble, alias: Wetwell Diameter, editable: true, nullable: true, defaultValue: null, modelName: Wetwell_Diameter )
• Wetwell_Depth ( type: esriFieldTypeDouble, alias: Wetwell Depth, editable: true, nullable: true, defaultValue: null, modelName: Wetwell_Depth )
• Arrangement ( type: esriFieldTypeString, alias: Arrangement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Arrangement )
• Pumps ( type: esriFieldTypeString, alias: Pumps, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Pumps )
• Inflow_Invert_1 ( type: esriFieldTypeDouble, alias: Inflow Invert 1, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Invert_1 )
• Inflow_Invert_2 ( type: esriFieldTypeDouble, alias: Inflow Invert 2, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Invert_2 )
• Inflow_Invert_3 ( type: esriFieldTypeDouble, alias: Inflow Invert 3, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Invert_3 )
• Inflow_Invert_4 ( type: esriFieldTypeDouble, alias: Inflow Invert 4, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Invert_4 )
• Inflow_Angle_1 ( type: esriFieldTypeDouble, alias: Inflow Angle 1, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Angle_1 )
• Inflow_Angle_2 ( type: esriFieldTypeDouble, alias: Inflow Angle 2, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Angle_2 )
• Inflow_Angle_3 ( type: esriFieldTypeDouble, alias: Inflow Angle 3, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Angle_3 )
• Inflow_Angle_4 ( type: esriFieldTypeDouble, alias: Inflow Angle 4, editable: true, nullable: true, defaultValue: null, modelName: Inflow_Angle_4 )
• Gallons_Per_Minute ( type: esriFieldTypeDouble, alias: Gallons Per Minute, editable: true, nullable: true, defaultValue: null, modelName: Gallons_Per_Minute )
• Force_Main_Diameter ( type: esriFieldTypeDouble, alias: Force Main Diameter, editable: true, nullable: true, defaultValue: null, modelName: Force_Main_Diameter )
• Force_Main_Material ( type: esriFieldTypeString, alias: Force Main Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Force_Main_Material )
• Discharge_Diameter ( type: esriFieldTypeDouble, alias: Discharge Diameter, editable: true, nullable: true, defaultValue: null, modelName: Discharge_Diameter )
• Discharge_Material ( type: esriFieldTypeString, alias: Discharge Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Discharge_Material )
• TDH ( type: esriFieldTypeString, alias: TDH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TDH )
• Guide_Rails ( type: esriFieldTypeString, alias: Guide Rails, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Guide_Rails )
• Wetwell_Lid_Material ( type: esriFieldTypeString, alias: Wetwell Lid Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Wetwell_Lid_Material )
• Wetwell_Construction ( type: esriFieldTypeString, alias: Wetwell Construction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Wetwell_Construction )
• Number_of_Pumps ( type: esriFieldTypeDouble, alias: Number of Pumps, editable: true, nullable: true, defaultValue: null, modelName: Number_of_Pumps )
• Date_of_mfg ( type: esriFieldTypeString, alias: Date of mfg, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Date_of_mfg )
• Motor_Horsepower ( type: esriFieldTypeString, alias: Motor Horsepower, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Motor_Horsepower )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage, editable: true, nullable: true, defaultValue: null, modelName: Voltage )
• Phase ( type: esriFieldTypeString, alias: Phase, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phase )
• Motor_RPM ( type: esriFieldTypeDouble, alias: Motor RPM, editable: true, nullable: true, defaultValue: null, modelName: Motor_RPM )
• Frame ( type: esriFieldTypeString, alias: Frame, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Frame )
• Actual_GPM_1 ( type: esriFieldTypeDouble, alias: Actual GPM 1, editable: true, nullable: true, defaultValue: null, modelName: Actual_GPM_1 )
• Actual_GPM_2 ( type: esriFieldTypeDouble, alias: Actual GPM 2, editable: true, nullable: true, defaultValue: null, modelName: Actual_GPM_2 )
• Actual_GPM_3 ( type: esriFieldTypeDouble, alias: Actual GPM 3, editable: true, nullable: true, defaultValue: null, modelName: Actual_GPM_3 )
• Actual_GPM_4 ( type: esriFieldTypeDouble, alias: Actual GPM 4, editable: true, nullable: true, defaultValue: null, modelName: Actual_GPM_4 )
• Pump_1_Serial_Number ( type: esriFieldTypeString, alias: Pump 1 Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_1_Serial_Number )
• Pump_2_Serial_Number ( type: esriFieldTypeString, alias: Pump 2 Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_2_Serial_Number )
• Pump_3_Serial_Number ( type: esriFieldTypeString, alias: Pump 3 Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_3_Serial_Number )
• Pump_4_Serial_Number ( type: esriFieldTypeString, alias: Pump 4 Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_4_Serial_Number )
• Pump_Model_1 ( type: esriFieldTypeString, alias: Pump Model 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Model_1 )
• Pump_Model_2 ( type: esriFieldTypeString, alias: Pump Model 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Model_2 )
• Pump_Model_3 ( type: esriFieldTypeString, alias: Pump Model 3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Model_3 )
• Pump_Model_4 ( type: esriFieldTypeString, alias: Pump Model 4, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Model_4 )
• Pump_Brand_1 ( type: esriFieldTypeString, alias: Pump Brand 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Brand_1 )
• Pump_Brand_2 ( type: esriFieldTypeString, alias: Pump Brand 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Brand_2 )
• Pump_Brand_3 ( type: esriFieldTypeString, alias: Pump Brand 3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Brand_3 )
• Pump_Brand_4 ( type: esriFieldTypeString, alias: Pump Brand 4, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pump_Brand_4 )
• Type_Level_Sensor ( type: esriFieldTypeString, alias: Type Level Sensor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type_Level_Sensor )
• Backup_Level_Sensor ( type: esriFieldTypeString, alias: Backup Level Sensor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Backup_Level_Sensor )
• Impellar_Diameter ( type: esriFieldTypeString, alias: Impellar Diameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Impellar_Diameter )
• Priming_Lift ( type: esriFieldTypeString, alias: Priming Lift, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Priming_Lift )
• Flow_Monitoring_Device_FM ( type: esriFieldTypeString, alias: Flow Monitoring Device FM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Flow_Monitoring_Device_FM )
• Flow_Monitoring_Device_Gravity ( type: esriFieldTypeString, alias: Flow Monitoring Device Gravity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Flow_Monitoring_Device_Gravity )
• High_Level_Float ( type: esriFieldTypeString, alias: High Level Float, editable: true, nullable: true, length: 100, defaultValue: null, modelName: High_Level_Float )
• Lag_Pump_Float ( type: esriFieldTypeString, alias: Lag Pump Float, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Lag_Pump_Float )
• Lead_Pump_Float ( type: esriFieldTypeString, alias: Lead Pump Float, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Lead_Pump_Float )
• Pump_Off_Float ( type: esriFieldTypeString, alias: Pump Off Float, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Pump_Off_Float )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• RuleID ( type: esriFieldTypeInteger, alias: Rule ID, editable: true, nullable: true, defaultValue: null, modelName: RuleID , Coded Values: [1: Sewer Pump Station] , [-1: Free Representation] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID_1, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• ID ( type: esriFieldTypeInteger, alias: ID, editable: true, nullable: true, defaultValue: null, modelName: ID )
• Insured ( type: esriFieldTypeString, alias: Insured, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Insured )
• PolNum ( type: esriFieldTypeString, alias: PolNum, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PolNum )
• LocNum ( type: esriFieldTypeInteger, alias: LocNum, editable: true, nullable: true, defaultValue: null, modelName: LocNum )
• SewerLiftID ( type: esriFieldTypeInteger, alias: SewerLiftID, editable: true, nullable: true, defaultValue: null, modelName: SewerLiftID )
• Occupancy ( type: esriFieldTypeString, alias: Occupancy, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Occupancy )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Description )
• ST_NUM ( type: esriFieldTypeString, alias: ST_NUM, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ST_NUM )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STREET )
• Constr ( type: esriFieldTypeString, alias: Constr, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Constr )
• OriginalBldgValue ( type: esriFieldTypeInteger, alias: OriginalBldgValue, editable: true, nullable: true, defaultValue: null, modelName: OriginalBldgValue )
• CurrentBldgValue ( type: esriFieldTypeInteger, alias: CurrentBldgValue, editable: true, nullable: true, defaultValue: null, modelName: CurrentBldgValue )
• ValType ( type: esriFieldTypeString, alias: ValType, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ValType )
• Pers_Prop_Value ( type: esriFieldTypeInteger, alias: Pers Prop Value, editable: true, nullable: true, defaultValue: null, modelName: Pers_Prop_Value )
• Total_Value ( type: esriFieldTypeInteger, alias: Total Value, editable: true, nullable: true, defaultValue: null, modelName: Total_Value )
• SquareFeet ( type: esriFieldTypeInteger, alias: SquareFeet, editable: true, nullable: true, defaultValue: null, modelName: SquareFeet )
• YearBuilt ( type: esriFieldTypeString, alias: YearBuilt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: YearBuilt )
• NumofStories ( type: esriFieldTypeInteger, alias: NumofStories, editable: true, nullable: true, defaultValue: null, modelName: NumofStories )
• LocPrem ( type: esriFieldTypeDouble, alias: LocPrem, editable: true, nullable: true, defaultValue: null, modelName: LocPrem )
• Effective1 ( type: esriFieldTypeDate, alias: Effective1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Effective1 )
• BldgValDate1 ( type: esriFieldTypeDate, alias: BldgValDate1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BldgValDate1 )

Templates:

• Name: GIS_Planning.DBO.InsuredSewerPumpStations_Joined
  Description:
  Prototype:
  Pump_Off_Float: null
  BldgValDate1: null
  Pump_Station_Name: null
  Wetwell_Length: null
  Wetwell_Width: null
  Wetwell_Diameter: null
  Wetwell_Depth: null
  Arrangement: null
  Pumps: null
  Inflow_Invert_1: null
  Inflow_Invert_2: null
  Inflow_Invert_3: null
  Inflow_Invert_4: null
  Inflow_Angle_1: null
  Inflow_Angle_2: null
  Inflow_Angle_3: null
  Inflow_Angle_4: null
  Gallons_Per_Minute: null
  Force_Main_Diameter: null
  Force_Main_Material: null
  Discharge_Diameter: null
  Discharge_Material: null
  TDH: null
  Guide_Rails: null
  Wetwell_Lid_Material: null
  Wetwell_Construction: null
  Number_of_Pumps: null
  Date_of_mfg: null
  Motor_Horsepower: null
  Voltage: null
  Phase: null
  Motor_RPM: null
  Frame: null
  Actual_GPM_1: null
  Actual_GPM_2: null
  Actual_GPM_3: null
  Actual_GPM_4: null
  Pump_1_Serial_Number: null
  Pump_2_Serial_Number: null
  Pump_3_Serial_Number: null
  Pump_4_Serial_Number: null
  Pump_Model_1: null
  Pump_Model_2: null
  Pump_Model_3: null
  Pump_Model_4: null
  Pump_Brand_1: null
  Pump_Brand_2: null
  Pump_Brand_3: null
  Pump_Brand_4: null
  Type_Level_Sensor: null
  Backup_Level_Sensor: null
  Impellar_Diameter: null
  Priming_Lift: null
  Flow_Monitoring_Device_FM: null
  Flow_Monitoring_Device_Gravity: null
  High_Level_Float: null
  Lag_Pump_Float: null
  Lead_Pump_Float: null
  Enabled: 1
  RuleID: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  Comments: null
  OBJECTID_1: null
  ID: null
  Insured: null
  PolNum: null
  LocNum: null
  SewerLiftID: null
  Occupancy: null
  Description: null
  ST_NUM: null
  STREET: null
  Constr: null
  OriginalBldgValue: null
  CurrentBldgValue: null
  ValType: null
  Pers_Prop_Value: null
  Total_Value: null
  SquareFeet: null
  YearBuilt: null
  NumofStories: null
  LocPrem: null
  Effective1: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata