View In:   ArcGIS Online Map Viewer

Name: Storm Pump Stations

Display Field: PointNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3bf4907d3b1c48cba93b2209f07c3f7b

Copyright Text:

Default Visibility: true

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 6000.000000000001

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: 5216151.507101548
YMin: 3633047.7375269807
XMax: 5246341.255777063
YMax: 3654712.939931394
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

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 )
• PointNumber ( type: esriFieldTypeInteger, alias: PointNumber, editable: true, nullable: true, defaultValue: null, modelName: PointNumber )
• Northing ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: Northing )
• Easting ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: Easting )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• Designation ( type: esriFieldTypeString, alias: Designation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Designation )
• Pumps ( type: esriFieldTypeInteger, alias: Pumps, editable: true, nullable: true, defaultValue: null, modelName: Pumps )
• PumpType ( type: esriFieldTypeString, alias: PumpType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PumpType , Coded Values: [SUBMERSIBLE: SUBMERSIBLE] , [GRINDER: GRINDER] , [VERTICAL: VERTICAL] , ...1 more... )
• PumpManuf ( type: esriFieldTypeString, alias: PumpManuf, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PumpManuf )
• PumpDate ( type: esriFieldTypeDate, alias: PumpDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PumpDate )
• Capacity ( type: esriFieldTypeInteger, alias: Capacity, editable: true, nullable: true, defaultValue: null, modelName: Capacity )
• FlowMeter ( type: esriFieldTypeString, alias: FlowMeter, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FlowMeter , Coded Values: [Yes: Yes] , [No: No] )
• OdorControl ( type: esriFieldTypeString, alias: OdorControl, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OdorControl , Coded Values: [Yes: Yes] , [No: No] )
• Telemetry ( type: esriFieldTypeString, alias: Telemetry, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Telemetry , Coded Values: [Yes: Yes] , [No: No] )
• AuxPower ( type: esriFieldTypeString, alias: AuxPower, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AuxPower , Coded Values: [Yes: Yes] , [No: No] )
• PumpDepth ( type: esriFieldTypeDouble, alias: PumpDepth, editable: true, nullable: true, defaultValue: null, modelName: PumpDepth )
• YearCon ( type: esriFieldTypeDate, alias: YearCon, editable: true, nullable: true, length: 8, defaultValue: null, modelName: YearCon )
• WaterBody ( type: esriFieldTypeString, alias: WaterBody, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterBody , Coded Values: [BLACK HAWK CREEK: BLACK HAWK CREEK] , [BLOWERS CREEK: BLOWERS CREEK] , [CEDAR RIVER: CEDAR RIVER] , ...5 more... )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner , Coded Values: [CITY OF WATERLOO: CITY OF WATERLOO] , [BLACK HAWK COUNTY: BLACK HAWK COUNTY] , [PRIVATE: PRIVATE] , ...4 more... )
• ServiceArea ( type: esriFieldTypeInteger, alias: ServiceArea, editable: true, nullable: true, defaultValue: null, modelName: ServiceArea , Coded Values: [10: 10] , [11: 11] , [12: 12] , ...12 more... )
• SubServiceArea ( type: esriFieldTypeInteger, alias: SubServiceArea, editable: true, nullable: true, defaultValue: null, modelName: SubServiceArea )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Comments )
• NeedGPSShot ( type: esriFieldTypeString, alias: Need GPS Shot, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NeedGPSShot , Coded Values: [Yes: Yes] , [No: No] , [Needs Review: Needs Review] , ...1 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 )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_POSITIONSOURCETYPE , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ESRIGNSS_RECEIVER )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LATITUDE )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LONGITUDE )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_ALTITUDE )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_RMS )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_V_RMS )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ESRIGNSS_FIXDATETIME )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_CORRECTIONAGE )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_STATIONID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_NUMSATS , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_DIRECTION )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_SPEED )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°), editable: true, nullable: true, defaultValue: null, modelName: ESRISNSR_AZIMUTH )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_H_RMS )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_V_RMS )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_POSITIONS )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_STDDEV )
• Status ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Removed: Removed] , [Abandoned: Abandoned] )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AssetID )

Templates:

• Name: Storm_Pump_Stations
  Description:
  Prototype:
  Capacity: null
  FlowMeter:
  OdorControl:
  Telemetry:
  Status: null
  PointNumber: null
  Northing: null
  Easting: null
  Elevation: null
  Designation: null
  Pumps: null
  PumpType: null
  PumpManuf: null
  PumpDate: null
  AuxPower:
  PumpDepth: null
  YearCon: null
  WaterBody: null
  Owner: null
  ServiceArea: null
  SubServiceArea: null
  AssetID: null
  Comments: null
  NeedGPSShot: null
  ESRIGNSS_H_STDDEV: null
  ESRIGNSS_AVG_POSITIONS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  ESRIGNSS_SPEED: null
  ESRISNSR_AZIMUTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Child Resources:   Field Groups   Contingent Values

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