View In:   ArcGIS Online Map Viewer

Name: sde.GIS.Pipes

Display Field: TYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 2400

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 985412.43359375
YMin: 238172.31992188096
XMax: 1038554.2037109435
YMax: 293379.19472655654
Spatial Reference: 102710  (3437)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [197, 0, 255, 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 )
• TYPE ( type: esriFieldTypeString , alias: TYPE , editable: true , nullable: true , length: 8 , Coded Values: [DRAIN: DRAIN] , [CBLAT: CBLAT] , [CULVERT: CULVERT] , ...3 more... )
• SLOPE ( type: esriFieldTypeString , alias: SLOPE , editable: true , nullable: true , length: 8 )
• PLAN_ ( type: esriFieldTypeString , alias: PLAN_ , editable: true , nullable: true , length: 8 )
• COMMENTS ( type: esriFieldTypeString , alias: COMMENTS , editable: true , nullable: true , length: 75 )
• DISTANCE ( type: esriFieldTypeDouble , alias: DISTANCE , editable: true , nullable: true )
• PIPESHAPE ( type: esriFieldTypeString , alias: PipeShape , editable: true , nullable: true , length: 20 )
• PIPEWIDTH ( type: esriFieldTypeSmallInteger , alias: PIPEWIDTH , editable: true , nullable: true )
• PIPEHEIGHT ( type: esriFieldTypeSmallInteger , alias: PIPEHEIGHT , editable: true , nullable: true )
• US_ID ( type: esriFieldTypeString , alias: US_ID , editable: true , nullable: true , length: 16 )
• DS_ID ( type: esriFieldTypeString , alias: DS_ID , editable: true , nullable: true , length: 16 )
• CDM_PIPEID ( type: esriFieldTypeString , alias: CDM_PIPEID , editable: true , nullable: true , length: 32 )
• US_RIMTOFLOW ( type: esriFieldTypeDouble , alias: US_RIMTOFLOW , editable: true , nullable: true )
• DS_RIMTOFLOW ( type: esriFieldTypeDouble , alias: DS_RIMTOFLOW , editable: true , nullable: true )
• ADJUSTED ( type: esriFieldTypeSmallInteger , alias: ADJUSTED , editable: true , nullable: true )
• DIAMETER ( type: esriFieldTypeSmallInteger , alias: DIAMETER , editable: true , nullable: true )
• MATERIAL ( type: esriFieldTypeString , alias: Material , editable: true , nullable: true , length: 15 , Coded Values: [Brick: Brick] , [Cement: Cement] , [Granite: Granite] , ...12 more... )
• INSTALLDATE ( type: esriFieldTypeString , alias: INSTALLDATE , editable: true , nullable: true , length: 8 )
• UPSTREAMINVERT ( type: esriFieldTypeDouble , alias: UPSTREAMINVERT , editable: true , nullable: true )
• DOWNSTREAMINVERT ( type: esriFieldTypeDouble , alias: DOWNSTREAMINVERT , editable: true , nullable: true )
• PIPELENGTH ( type: esriFieldTypeSmallInteger , alias: PIPELENGTH , editable: true , nullable: true )
• SOURCE ( type: esriFieldTypeString , alias: Source , editable: true , nullable: true , length: 50 , Coded Values: [Cont2: Contract 2 Outskirt Seperation] , [Cont3: Contract 3 City Proper] , [CityProper: Old Plan City Proper] , ...8 more... )
• QCSTATUS ( type: esriFieldTypeString , alias: QCSTATUS , editable: true , nullable: true , length: 1 )
• ENABLED ( type: esriFieldTypeSmallInteger , alias: Enabled , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• UPSTREAMIMAGE ( type: esriFieldTypeString , alias: UPSTREAMIMAGE , editable: true , nullable: true , length: 20 )
• DOWNSTREAMIMAGE ( type: esriFieldTypeString , alias: DOWNSTREAMIMAGE , editable: true , nullable: true , length: 20 )
• PIPEID ( type: esriFieldTypeSmallInteger , alias: PIPEID , editable: true , nullable: true )
• PLAN_QC ( type: esriFieldTypeString , alias: PLAN_QC , editable: true , nullable: true , length: 1 )
• YEARLINED ( type: esriFieldTypeSmallInteger , alias: Year Lined , editable: true , nullable: true )
• SEASONLINED ( type: esriFieldTypeString , alias: Season Lined , editable: true , nullable: true , length: 13 , Coded Values: [Spring: Spring] , [Spring/Summer: Spring/Summer] , [Summer/Fall: Summer/Fall] , ...2 more... )
• LINERMATERIAL ( type: esriFieldTypeString , alias: Liner Material , editable: true , nullable: true , length: 15 , Coded Values: [Felt/Resin: Felt/Resin] , [PVC: PVC] )
• LININGTYPE ( type: esriFieldTypeString , alias: Lining Type , editable: true , nullable: true , length: 15 , Coded Values: [Cured in Place: Cured in Place] , [Fold & Form: Fold & Form] )
• LININGCONTRACTOR ( type: esriFieldTypeString , alias: Lining Contractor , editable: true , nullable: true , length: 25 , Coded Values: [Insituform of NE: Insituform of NE] , [Eastern Pipe Service: Eastern Pipe Service] , [Azurix North America: Azurix North America] , ...1 more... )
• PRIVATE ( type: esriFieldTypeString , alias: PRIVATE , editable: true , nullable: true , length: 1 , Coded Values: [Y: Yes] , [N: No] )
• PERFORATED ( type: esriFieldTypeString , alias: PERFORATED , editable: true , nullable: true , length: 1 , Coded Values: [Y: Yes] , [N: No] )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• STATUS ( type: esriFieldTypeString , alias: STATUS , editable: true , nullable: true , length: 12 , Coded Values: [Laid: Laid] , [Relaid: Relaid] , [Repaired: Repaired] )
• created_user ( type: esriFieldTypeString , alias: created_user , editable: false , nullable: true , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , editable: false , nullable: true , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , editable: false , nullable: true , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , editable: false , nullable: true , length: 8 )
• AssetID ( type: esriFieldTypeString , alias: AssetID , editable: true , nullable: true , length: 50 )

Templates:

• Name: sde.GIS.Pipes
  Description:
  Prototype:
  STATUS: Laid
  AssetID: null
  TYPE: null
  SLOPE: null
  PLAN_: null
  COMMENTS: null
  DISTANCE: null
  PIPESHAPE: Circular
  PIPEWIDTH: null
  PIPEHEIGHT: null
  US_ID: null
  DS_ID: null
  CDM_PIPEID: null
  US_RIMTOFLOW: null
  DS_RIMTOFLOW: null
  ADJUSTED: null
  DIAMETER: null
  MATERIAL: null
  INSTALLDATE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  PIPELENGTH: null
  SOURCE: null
  QCSTATUS: null
  ENABLED: 1
  UPSTREAMIMAGE: null
  DOWNSTREAMIMAGE: null
  PIPEID: null
  PLAN_QC: null
  YEARLINED: null
  SEASONLINED: null
  LINERMATERIAL: null
  LININGTYPE: null
  LININGCONTRACTOR: null
  PRIVATE: N
  PERFORATED: N
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• DrainMainMaintenance (0) -- Related To: sde.GIS.Util_tbl_DrainMainMaintenance (1)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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 Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata