View In:   ArcGIS Online Map Viewer

Name: Abandoned Grinder Pumps

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: LPS Grinder Pumps contains devices that macerate solids before sending them to the collection system. This is a point layer using US feet units in Kansas North State Plane coordinate system, NAD 83 datum.

Service Item Id: ef9c006f552a4a4993e614c1de4067c4

Copyright Text: Sewer Maintenance Section of Water Pollution Control (WPC) Division of the Unifed Government of Wyandotte County/Kansas City, Kansas.

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 6000.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: 2195975.8348972537
YMin: 279035.5479343459
XMax: 2274300.9052809216
YMax: 324374.9959691763
Spatial Reference: 102677  (3419)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FACILITYID] CONCAT NEWLINE CONCAT "MAINT-" CONCAT [MANAGEDBY]
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: 7
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 1000.0
Max. Scale: 0.0

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
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 Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• FACILITYID ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Facility ID, type: esriFieldTypeString )
• ADDRESS ( modelName: ADDRESS, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: Address, type: esriFieldTypeString )
• CITY ( modelName: CITY, nullable: true, editable: true, defaultValue: Kansas City, length: 20, alias: City, type: esriFieldTypeString , Coded Values: [Kansas City: Kansas City] , [Edwardsville: Edwardsville] , [Bonner Springs: Bonner Springs] , ...2 more... )
• STATE ( modelName: STATE, nullable: true, editable: true, defaultValue: Kansas, length: 10, alias: State, type: esriFieldTypeString )
• ZIPCODE ( modelName: ZIPCODE, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: Zip Code, type: esriFieldTypeString )
• PARCEL ( modelName: PARCEL, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: Parcel, type: esriFieldTypeString )
• SUBDIVISION ( modelName: SUBDIVISION, nullable: true, editable: true, defaultValue: N/A, length: 150, alias: Subdivision, type: esriFieldTypeString )
• LPS_DATE ( modelName: LPS_DATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: LPS Date, type: esriFieldTypeDate )
• PUMP_SERIAL_NO ( modelName: PUMP_SERIAL_NO, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Pump Serial No, type: esriFieldTypeString )
• WARRANTY_START ( modelName: WARRANTY_START, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Warranty Start Date, type: esriFieldTypeDate )
• WARRANTY_END ( modelName: WARRANTY_END, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Warranty End Date, type: esriFieldTypeDate )
• RofD_BOOK ( modelName: RofD_BOOK, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: RofD Book, type: esriFieldTypeString )
• RofD_PAGE ( modelName: RofD_PAGE, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: RofD Page, type: esriFieldTypeString )
• RofD_DOC_NO ( modelName: RofD_DOC_NO, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: RofD Doc No, type: esriFieldTypeString )
• RofD_DATE_FILED ( modelName: RofD_DATE_FILED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: RofD Date Filed, type: esriFieldTypeDate )
• LOCATION_DESC ( modelName: LOCATION_DESC, nullable: true, editable: true, defaultValue: N/A, length: 200, alias: Location Description, type: esriFieldTypeString )
• COMMENT ( modelName: COMMENT, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: Comment, type: esriFieldTypeString )
• LUCITYLINK ( modelName: LUCITYLINK, nullable: true, editable: true, defaultValue: N/A, alias: LUCITYLINK, type: esriFieldTypeInteger )
• ENABLED ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• GPSDATE ( modelName: GPSDATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: GPS Date, type: esriFieldTypeDate )
• OWNEDBY ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: UG] , [2: Private] , [4: Fairfax Drainage] , ...6 more... )
• MANAGEDBY ( modelName: MANAGEDBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [1: UG] , [2: Private] , [4: Fairfax Drainage] , ...7 more... )
• CREATED_USER ( modelName: CREATED_USER, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: Created User, type: esriFieldTypeString, required: true )
• CREATED_DATE ( modelName: CREATED_DATE, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: Created Date, type: esriFieldTypeDate, required: true )
• LAST_EDITED_USER ( modelName: LAST_EDITED_USER, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: Last Edited User, type: esriFieldTypeString, required: true )
• LAST_EDITED_DATE ( modelName: LAST_EDITED_DATE, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: Last Edited Date, type: esriFieldTypeDate, required: true )
• GR_PUMP_TYPE ( modelName: GR_PUMP_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 25, alias: GR_PUMP_TYPE, type: esriFieldTypeString , Coded Values: [GRPUMP: Grinder Pump] )
• ACTIVEFLAG ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: 1, alias: Active Flag, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• GlobalID ( modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• MAINTYPE ( modelName: MAINTYPE, nullable: true, editable: true, defaultValue: N/A, length: 25, alias: MAINTYPE, type: esriFieldTypeString , Coded Values: [LPS: LPS] , [Grav: Gravity] , [HIGH: High] )

Templates:

• Name: Abandoned Grinder Pumps
  Description:
  Prototype:
  RofD_BOOK: null
  MAINTYPE: null
  STATE: Kansas
  MANAGEDBY: 1
  COMMENT: null
  GR_PUMP_TYPE: null
  LUCITYLINK: null
  LPS_DATE: null
  FACILITYID: null
  RofD_DATE_FILED: null
  SUBDIVISION: null
  RofD_PAGE: null
  WARRANTY_END: null
  ZIPCODE: null
  RofD_DOC_NO: null
  WARRANTY_START: null
  OWNEDBY: 1
  CITY: Kansas City
  PARCEL: null
  PUMP_SERIAL_NO: null
  ACTIVEFLAG: 1
  ADDRESS: null
  GPSDATE: null
  LOCATION_DESC: null
  ENABLED: 1
  
  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:

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