View In:   ArcGIS Online Map Viewer

Name: Sewer Pump

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: E-1 pumps are for individual homes/businesses that are on forcemain sewer systems. These pumps are maintained by the City unless they are private. Points are GPS'd unless marked with an NV at the end of the Layer field. Private pumps are marked with PRI in the layer name.

Copyright Text:

Default Visibility: true

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: 2307545.5758903027
YMin: 1652526.4698726386
XMax: 2345274.898725465
YMax: 1683483.212749064
Spatial Reference: 102655  (2233)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Residential Pump
  Label: Residential Pump
  Description: N/A
  Symbol:
  
• Value: Private Pump
  Label: Private Pump
  Description: N/A
  Symbol:
  
• Value: Lift Station Pump
  Label: Lift Station Pump
  Description: N/A
  Symbol:
  
• Value: Air Injection Vault
  Label: Air Injection Vault
  Description: N/A
  Symbol:
  
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: TYPE

Fields:

• SERIAL_NUMBER ( type: esriFieldTypeString, alias: SERIAL_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SERIAL_NUMBER )
• CG_IMPORT ( type: esriFieldTypeString, alias: CG_IMPORT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CG_IMPORT )
• CG_ID ( type: esriFieldTypeInteger, alias: CG_ID, editable: true, nullable: true, defaultValue: null, modelName: CG_ID )
• Panel_Update_Date ( type: esriFieldTypeDate, alias: Panel_Update_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Panel_Update_Date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTURER )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MATERIAL )
• PIPEDIAM ( type: esriFieldTypeDouble, alias: PIPEDIAM, editable: true, nullable: true, defaultValue: null, modelName: PIPEDIAM )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STREETNAME )
• HOUSE_NUM ( type: esriFieldTypeInteger, alias: HOUSE_NUM, editable: true, nullable: true, defaultValue: null, modelName: HOUSE_NUM )
• ADDRESSID ( type: esriFieldTypeInteger, alias: ADDRESSID, editable: true, nullable: true, defaultValue: null, modelName: ADDRESSID )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• NOTES ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENT )
• 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 )
• RETIRED_DATE ( type: esriFieldTypeDate, alias: RETIRED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETIRED_DATE )
• RESPONSIBLE_PARTY ( type: esriFieldTypeString, alias: RESPONSIBLE_PARTY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RESPONSIBLE_PARTY )
• VERIFICATION_METHOD ( type: esriFieldTypeString, alias: VERIFICATION_METHOD, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VERIFICATION_METHOD )
• LOC_DESC ( type: esriFieldTypeString, alias: LOC_DESC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOC_DESC )
• REPLACE_DATE ( type: esriFieldTypeDate, alias: REPLACE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPLACE_DATE )
• STREET_SUFFIX ( type: esriFieldTypeString, alias: STREET_SUFFIX, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREET_SUFFIX )
• STREET_PREFIX ( type: esriFieldTypeString, alias: STREET_PREFIX, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREET_PREFIX )

Types:

ID: Residential Pump
Name: Residential Pump
Domains:
Templates:
• Name: Residential Pump
  Description:
  Prototype:
  STREET_PREFIX: null
  STREET_SUFFIX: null
  SERIAL_NUMBER: null
  CG_IMPORT: null
  CG_ID: null
  Panel_Update_Date: null
  TYPE: Residential Pump
  MODEL: null
  MANUFACTURER: null
  GPS_DATE: null
  MATERIAL: null
  PIPEDIAM: null
  STREETNAME: null
  HOUSE_NUM: null
  ADDRESSID: null
  INSTALL_DATE: null
  NOTES: null
  REPLACE_DATE: null
  LOC_DESC: null
  VERIFICATION_METHOD: null
  RESPONSIBLE_PARTY: null
  RETIRED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Private Pump
Name: Private Pump
Domains:
Templates:
• Name: Private Pump
  Description:
  Prototype:
  STREET_SUFFIX: null
  SERIAL_NUMBER: null
  CG_IMPORT: null
  CG_ID: null
  Panel_Update_Date: null
  STREET_PREFIX: null
  REPLACE_DATE: null
  TYPE: Private Pump
  MODEL: null
  MANUFACTURER: null
  GPS_DATE: null
  MATERIAL: null
  PIPEDIAM: null
  STREETNAME: null
  HOUSE_NUM: null
  ADDRESSID: null
  INSTALL_DATE: null
  NOTES: null
  LOC_DESC: null
  VERIFICATION_METHOD: null
  RESPONSIBLE_PARTY: null
  RETIRED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Lift Station Pump
Name: Lift Station Pump
Domains:
Templates:
• Name: Lift Station Pump
  Description:
  Prototype:
  STREET_PREFIX: null
  STREET_SUFFIX: null
  SERIAL_NUMBER: null
  CG_IMPORT: null
  CG_ID: null
  Panel_Update_Date: null
  TYPE: Lift Station Pump
  MODEL: null
  MANUFACTURER: null
  GPS_DATE: null
  MATERIAL: null
  PIPEDIAM: null
  STREETNAME: null
  HOUSE_NUM: null
  ADDRESSID: null
  INSTALL_DATE: null
  NOTES: null
  REPLACE_DATE: null
  LOC_DESC: null
  VERIFICATION_METHOD: null
  RESPONSIBLE_PARTY: null
  RETIRED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Air Injection Vault
Name: Air Injection Vault
Domains:
Templates:
• Name: Air Injection Vault
  Description:
  Prototype:
  STREET_SUFFIX: null
  SERIAL_NUMBER: null
  CG_IMPORT: null
  CG_ID: null
  Panel_Update_Date: null
  STREET_PREFIX: null
  REPLACE_DATE: null
  TYPE: Air Injection Vault
  MODEL: null
  MANUFACTURER: null
  GPS_DATE: null
  MATERIAL: null
  PIPEDIAM: null
  STREETNAME: null
  HOUSE_NUM: null
  ADDRESSID: null
  INSTALL_DATE: null
  NOTES: null
  LOC_DESC: null
  VERIFICATION_METHOD: null
  RESPONSIBLE_PARTY: null
  RETIRED_DATE: 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