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: 2285025.675720215
YMin: 1652051.1456920654
XMax: 2345274.898725465
YMax: 1683485.817074567
Spatial Reference: 102655  (2233)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [76, 230, 0, 255]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: 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 )
• CG_ID ( type: esriFieldTypeInteger, alias: CG_ID, editable: true, nullable: true, defaultValue: null, modelName: CG_ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE , Coded Values: [Residential Pump: Residential Pump] , [Lift Station Pump: Lift Station Pump] , [Other: Other] , ...2 more... )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTURER , Coded Values: [Barnes: Barnes] , [E One: E One] , [Smith & Loveless: Smith & Loveless] , ...1 more... )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL , Coded Values: [9GD20221: 9GD20221] , [SCDV-5022L: SCDV-5022L] , [SGD2022L: SGD2022L] , ...4 more... )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MATERIAL , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...17 more... )
• PIPEDIAM ( type: esriFieldTypeDouble, alias: PIPEDIAM, editable: true, nullable: true, defaultValue: null, modelName: PIPEDIAM , Coded Values: [1.5: 1.5 Inch] , [2: 2 Inch] , [4: 4 Inch] , ...15 more... )
• HOUSE_NUM ( type: esriFieldTypeInteger, alias: HOUSE_NUM, editable: true, nullable: true, defaultValue: null, modelName: HOUSE_NUM )
• STREET_PREFIX ( type: esriFieldTypeString, alias: STREET_PREFIX, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREET_PREFIX , Coded Values: [E: EAST] , [W: WEST] , [N: NORTH] , ...1 more... )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STREETNAME , Coded Values: [10TH: 10TH] , [11TH: 11TH] , [12TH: 12TH] , ...681 more... )
• STREET_SUFFIX ( type: esriFieldTypeString, alias: STREET_SUFFIX, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STREET_SUFFIX , Coded Values: [ALY: ALLEY] , [AVE: AVENUE] , [BLVD: BOULEVARD] , ...15 more... )
• ADDRESSID ( type: esriFieldTypeInteger, alias: ADDRESSID, editable: true, nullable: true, defaultValue: null, modelName: ADDRESSID )
• LOC_DESC ( type: esriFieldTypeString, alias: LOC_DESC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOC_DESC )
• Panel_Update_Date ( type: esriFieldTypeDate, alias: Panel_Update_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Panel_Update_Date )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• RETIRED_DATE ( type: esriFieldTypeDate, alias: RETIRED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETIRED_DATE )
• REPLACE_DATE ( type: esriFieldTypeDate, alias: REPLACE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPLACE_DATE )
• VERIFICATION_METHOD ( type: esriFieldTypeString, alias: VERIFICATION_METHOD, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VERIFICATION_METHOD , Coded Values: [CAD: CAD] , [Ortho Photo: Ortho Photo] , [Plat: Plat] , ...11 more... )
• RESPONSIBLE_PARTY ( type: esriFieldTypeString, alias: RESPONSIBLE_PARTY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RESPONSIBLE_PARTY , Coded Values: [City of Montrose: City of Montrose] , [Montrose County: Montrose County] , [Private: Private] , ...9 more... )
• SERIAL_NUMBER ( type: esriFieldTypeString, alias: SERIAL_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SERIAL_NUMBER )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENT )
• CG_IMPORT ( type: esriFieldTypeString, alias: CG_IMPORT, editable: true, nullable: true, length: 5, defaultValue: Yes, modelName: CG_IMPORT , Coded Values: [Yes: Yes] , [No: No] )
• 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: sde.SEWER.SewerPump_ALL_cg
  Description:
  Prototype:
  MATERIAL: null
  CG_IMPORT: Yes
  CG_ID: null
  TYPE: null
  MANUFACTURER: null
  MODEL: null
  PIPEDIAM: 0
  HOUSE_NUM: null
  STREET_PREFIX: null
  STREETNAME: null
  STREET_SUFFIX: null
  ADDRESSID: null
  LOC_DESC: null
  Panel_Update_Date: null
  GPS_DATE: null
  INSTALL_DATE: null
  RETIRED_DATE: null
  REPLACE_DATE: null
  VERIFICATION_METHOD: null
  RESPONSIBLE_PARTY: null
  SERIAL_NUMBER: null
  NOTES: 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