View In:   ArcGIS Online Map Viewer

Name: MPGIS.SDE.SEWER_MAINS

Display Field: COMMENT

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: false

Supports Datum Transformation: true

Extent:

XMin: -9793390.617556944
YMin: 5164312.709381731
XMax: -9785164.42676734
YMax: 5175309.41989339
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 54, 135, 255]
Width: 1
Label:
Description:
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

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 )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENT )
• UNITID ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UNITID )
• UNITID2 ( type: esriFieldTypeString, alias: UNITID2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UNITID2 )
• PIPETYPE ( type: esriFieldTypeString, alias: PIPETYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIPETYPE , Coded Values: [CI: CAST IRON] , [CIPP: CURED IN PLACE] , [CON: POURED CONCRETE] , ...16 more... )
• PIPESHAPE ( type: esriFieldTypeString, alias: PIPESHAPE, editable: true, nullable: true, length: 50, defaultValue: CIRC, modelName: PIPESHP , Coded Values: [BOX: BOX STRUCTURE] , [ELIP: ELLIPTICAL] , [CIRC: CIRCULAR] )
• COMPTYPE ( type: esriFieldTypeSmallInteger, alias: COMPTYPE, editable: true, nullable: true, defaultValue: 21, modelName: COMPTYPE )
• MAINCOMP1 ( type: esriFieldTypeInteger, alias: MAINCOMP1, editable: true, nullable: true, defaultValue: null, modelName: MAINCOMP1 )
• MAINCOMP2 ( type: esriFieldTypeInteger, alias: MAINCOMP2, editable: true, nullable: true, defaultValue: null, modelName: MAINCOMP2 )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• GIS ( type: esriFieldTypeString, alias: GIS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNER , Coded Values: [VOMP: VOMP] , [MWRD: MWRD] , [UNK: UNKNOWN] , ...13 more... )
• SEGMENT_KEY ( type: esriFieldTypeInteger, alias: SEGMENT_KEY, editable: true, nullable: true, defaultValue: null, modelName: SEGMENT_KEY )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• HEIGHT ( type: esriFieldTypeDouble, alias: HEIGHT, editable: true, nullable: true, defaultValue: null, modelName: HEIGHT )
• UNIT_TYPE ( type: esriFieldTypeString, alias: UNIT_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UNIT_TYPE )
• MAPNO ( type: esriFieldTypeString, alias: MAPNO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAPNO )
• UP_INVERT ( type: esriFieldTypeDouble, alias: UP_INVERT, editable: true, nullable: true, defaultValue: null, modelName: UP_INVERT )
• DOWN_INVERT ( type: esriFieldTypeDouble, alias: DOWN_INVERT, editable: true, nullable: true, defaultValue: null, modelName: DOWN_INVERT )
• YEAR_INSTALLED ( type: esriFieldTypeInteger, alias: YEAR_INSTALLED, editable: true, nullable: true, defaultValue: null, modelName: YEAR_INSTALLED )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTES )
• BASIN ( type: esriFieldTypeString, alias: BASIN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BASIN )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• 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 ( type: esriFieldTypeDate, alias: RETIRED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETIRED )
• UP_ASSET_TYPE ( type: esriFieldTypeString, alias: UP_ASSET_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UP_ASSET_TYPE )
• DOWN_ASSET_TYPE ( type: esriFieldTypeString, alias: DOWN_ASSET_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DOWN_ASSET_TYPE )
• CGID ( type: esriFieldTypeString, alias: CGID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CGID )
• UNITTYPE ( type: esriFieldTypeString, alias: UNITTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UNITTYPE , Coded Values: [CS: Combined] , [WW: Wastewater] , [STW: Stormwater] )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL , Coded Values: [CI: CAST IRON] , [CIPP: CURED IN PLACE] , [PVC: POLYVINYLCHLORIDE] , ...8 more... )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREET )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• EASEMENTTYPE ( type: esriFieldTypeString, alias: EASEMENT TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EASEMENTTYPE )
• EASEMENTOWNER ( type: esriFieldTypeString, alias: EASEMENT OWNER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EASEMENTOWNER )

Templates:

• Name: MPGIS.SDE.SEWER_MAINS
  Description:
  Prototype:
  PIPETYPE: null
  PIPESHAPE: CIRC
  EASEMENTTYPE: null
  COMMENT: null
  UNITID: null
  UNITID2: null
  COMPTYPE: 21
  MAINCOMP1: null
  MAINCOMP2: null
  COMPKEY: null
  GIS: null
  OWNER: null
  SEGMENT_KEY: null
  DIAMETER: null
  HEIGHT: null
  UNIT_TYPE: null
  MAPNO: null
  UP_INVERT: null
  DOWN_INVERT: null
  YEAR_INSTALLED: null
  LENGTH: null
  NOTES: null
  BASIN: null
  INSTALL_DATE: null
  EASEMENTOWNER: null
  CITY: null
  STREET: null
  MATERIAL: null
  RETIRED: null
  UP_ASSET_TYPE: null
  DOWN_ASSET_TYPE: null
  CGID: null
  UNITTYPE: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: MPGIS.SDE.SEWER_MAINS
  Description:
  Prototype:
  PIPETYPE: null
  PIPESHAPE: CIRC
  EASEMENTTYPE: null
  COMMENT: null
  UNITID: null
  UNITID2: null
  COMPTYPE: 21
  MAINCOMP1: null
  MAINCOMP2: null
  COMPKEY: null
  GIS: null
  OWNER: null
  SEGMENT_KEY: null
  DIAMETER: null
  HEIGHT: null
  UNIT_TYPE: null
  MAPNO: null
  UP_INVERT: null
  DOWN_INVERT: null
  YEAR_INSTALLED: null
  LENGTH: null
  NOTES: null
  BASIN: null
  INSTALL_DATE: null
  EASEMENTOWNER: null
  CITY: null
  STREET: null
  MATERIAL: null
  RETIRED: null
  UP_ASSET_TYPE: null
  DOWN_ASSET_TYPE: null
  CGID: null
  UNITTYPE: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Uploads,Editing,Sync

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

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