Name: Sanitary Pump Stations

Display Field: PointNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A map of all sanitary pump stations in the City of Waterloo, Iowa sewer system.

Service Item Id: ac99dc44cc0c42dc8ce485dfe7933f76

Copyright Text: Ben Wagner, City of Waterloo, Iowa Engineering Dept.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 6000.000000000001

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 5212355.417252806
YMin: 3621660.6690938002
XMax: 5256028.223279716
YMax: 3673412.680747067
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: false
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: true
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: null

Fields:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata