View In:   ArcGIS Online Map Viewer

Name: Sewer Pump

Display Field: ANCILLARYROLE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c2917929c67443be84a7050612c9ea58

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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

Supports Datum Transformation: true

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102719  (2264)

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: 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 )
• 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] )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: AdministrativeArea, editable: true, nullable: true, length: 60, defaultValue: null, modelName: AdministrativeArea , Coded Values: [UNK: Unknown] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: FACILITYID )
• LEGACYID ( type: esriFieldTypeString, alias: LEGACYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LEGACYID )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: OperationalArea, editable: true, nullable: true, length: 60, defaultValue: null, modelName: OperationalArea , Coded Values: [UNK: Unknown] )
• SUBBASIN ( type: esriFieldTypeString, alias: SubBasin, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SubBasin , Coded Values: [UNK: Unknown] , [AR: Afton Run] , [CB: Caldwell Branch] , ...14 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifeCycleStatus, editable: true, nullable: true, length: 20, defaultValue: ACT, modelName: LifeCycleStatus , Coded Values: [PRP: Proposed] , [ACT: Active] , [ABN: Abandoned] , ...2 more... )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• INSTALLCONTRACTOR ( type: esriFieldTypeString, alias: INSTALLCONTRACTOR, editable: true, nullable: true, length: 60, defaultValue: null, modelName: INSTALLCONTRACTOR )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WaterType , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Reclaimed: Reclaimed Water] , ...4 more... )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• PRIMARYIMAGE ( type: esriFieldTypeString, alias: PRIMARYIMAGE, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PRIMARYIMAGE )
• CSWRPOINT ( type: esriFieldTypeDouble, alias: CSWRPOINT, editable: true, nullable: true, defaultValue: null, modelName: CSWRPOINT )
• CSWRPOINT_I ( type: esriFieldTypeDouble, alias: CSWRPOINT_I, editable: true, nullable: true, defaultValue: null, modelName: CSWRPOINT_I )
• CCOVER ( type: esriFieldTypeString, alias: CCover, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CCover , Coded Values: [SLD: Solid] , [VNT: Vented] , [OTH: Other] )
• CCOVERSTATUS ( type: esriFieldTypeString, alias: CCoverStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CCoverStatus , Coded Values: [BLT: Bolted] , [BRD: Burried] , [LKD: Locked] , ...3 more... )
• CMAPID ( type: esriFieldTypeString, alias: CMAPID, editable: true, nullable: true, length: 128, defaultValue: null, modelName: CMAPID )
• CJURISDICTI ( type: esriFieldTypeString, alias: CJurisdicti, editable: true, nullable: true, length: 12, defaultValue: null, modelName: CJurisdicti , Coded Values: [CMK: CharMeck] , [CND: Concord] , [HRS: Harrisburg] , ...4 more... )
• CSUBMAP_ ( type: esriFieldTypeString, alias: CSUBMAP_, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CSUBMAP_ )
• CSUBMAP ( type: esriFieldTypeInteger, alias: CSUBMAP, editable: true, nullable: true, defaultValue: null, modelName: CSUBMAP )
• CMIN ( type: esriFieldTypeInteger, alias: CMIN, editable: true, nullable: true, defaultValue: null, modelName: CMIN )
• CGPSDATE ( type: esriFieldTypeString, alias: CGPSDATE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CGPSDATE )
• CRE_GPS ( type: esriFieldTypeInteger, alias: CRe_GPS, editable: true, nullable: true, defaultValue: null, modelName: CRe_GPS , Coded Values: [0: No] , [1: Yes] )
• CXVAL ( type: esriFieldTypeDouble, alias: CXVAL, editable: true, nullable: true, defaultValue: null, modelName: CXVAL )
• CYVAL ( type: esriFieldTypeDouble, alias: CYVAL, editable: true, nullable: true, defaultValue: null, modelName: CYVAL )
• CPRIVATE ( type: esriFieldTypeInteger, alias: CPrivate, editable: true, nullable: true, defaultValue: null, modelName: CPrivate , Coded Values: [0: No] , [1: Yes] )
• CMHID2 ( type: esriFieldTypeString, alias: CMHID2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CMHID2 )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• BELOWGRADE ( type: esriFieldTypeInteger, alias: BelowGrade, editable: true, nullable: false, defaultValue: null, modelName: BelowGrade , Coded Values: [0: False] , [1: True] )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Manufacturer , Coded Values: [UNK: Unknown] , [OTH: Other] )
• INLETDIAMETER ( type: esriFieldTypeInteger, alias: InletDiameter, editable: true, nullable: true, defaultValue: 12, modelName: InletDiameter , Coded Values: [6: 6 inch] , [8: 8 inch] , [10: 10 inch] , ...10 more... )
• DISCHARGEDIAMETER ( type: esriFieldTypeInteger, alias: DischargeDiameter, editable: true, nullable: true, defaultValue: 12, modelName: DischargeDiameter , Coded Values: [6: 6 inch] , [8: 8 inch] , [10: 10 inch] , ...10 more... )
• RATEDFLOW ( type: esriFieldTypeDouble, alias: RATEDFLOW, editable: true, nullable: true, defaultValue: null, modelName: RATEDFLOW )
• RATEDPRESSURE ( type: esriFieldTypeSmallInteger, alias: RATEDPRESSURE, editable: true, nullable: true, defaultValue: null, modelName: RATEDPRESSURE )
• TOTALDYNAMICHEAD ( type: esriFieldTypeSmallInteger, alias: TOTALDYNAMICHEAD, editable: true, nullable: true, defaultValue: null, modelName: TOTALDYNAMICHEAD )
• LOWSETPOINT ( type: esriFieldTypeDouble, alias: LOWSETPOINT, editable: true, nullable: true, defaultValue: null, modelName: LOWSETPOINT )
• HIGHSETPOINT ( type: esriFieldTypeDouble, alias: HIGHSETPOINT, editable: true, nullable: true, defaultValue: null, modelName: HIGHSETPOINT )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MODEL )
• SERIALNUMBER ( type: esriFieldTypeString, alias: SERIALNUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SERIALNUMBER )
• PUMPTYPE ( type: esriFieldTypeInteger, alias: PumpType, editable: true, nullable: true, defaultValue: 1, modelName: PumpType )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )

Templates:

• Name: Sewer Pump
  Description:
  Prototype:
  SERIALNUMBER: null
  PUMPTYPE: 1
  ANCILLARYROLE: 0
  ENABLED: 1
  ADMINISTRATIVEAREA: null
  FACILITYID:
  LEGACYID: null
  LOCATION: null
  INSTALLDATE: null
  OPERATIONALAREA: null
  SUBBASIN: null
  ROTATION: null
  LIFECYCLESTATUS: ACT
  WORKORDERID: null
  WARRANTYDATE: null
  INSTALLCONTRACTOR: null
  WATERTYPE: null
  CONDITION: null
  CONDITIONDATE: null
  PRIMARYIMAGE: null
  CSWRPOINT: null
  CSWRPOINT_I: null
  CCOVER: null
  CCOVERSTATUS: null
  CMAPID: null
  CJURISDICTI: null
  CSUBMAP_: null
  CSUBMAP: null
  CMIN: null
  CGPSDATE: null
  CRE_GPS: null
  CXVAL: null
  CYVAL: null
  CPRIVATE: null
  CMHID2: null
  ELEVATION: null
  BELOWGRADE: 0
  MANUFACTURER: null
  INLETDIAMETER: 12
  DISCHARGEDIAMETER: 12
  RATEDFLOW: null
  RATEDPRESSURE: null
  TOTALDYNAMICHEAD: null
  LOWSETPOINT: null
  HIGHSETPOINT: null
  MODEL: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,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

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