View In:   ArcGIS Online Map Viewer

Name: Storm System Pipe

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 02893db677bf42018c02c048d0339eec

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 18055.954822

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: -8637984.951336069
YMin: 4502102.145794918
XMax: -8614895.808307946
YMax: 4523547.908222664
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LifeCycleStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [56, 168, 0, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: Inactive
  Label: Inactive
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: Proposed
  Label: Proposed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
• Value: Under Construction
  Label: Under Construction
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: LifeCycleStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LegacyID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConditionDate )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• InstallContractor ( type: esriFieldTypeString, alias: Install Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InstallContractor )
• EditBy ( type: esriFieldTypeString, alias: Edit By, editable: false, nullable: true, length: 30, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Life Cycle Status, editable: true, nullable: true, length: 35, defaultValue: Active, modelName: LifeCycleStatus , Coded Values: [Active: Active] , [Proposed: Proposed] , [Under Construction: Under Construction] , ...2 more... )
• ConstructionInspector ( type: esriFieldTypeString, alias: Construction Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConstructionInspector )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• WorkOrderNumber ( type: esriFieldTypeString, alias: Work Order Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkOrderNumber )
• OracleInquiryNumber ( type: esriFieldTypeString, alias: Oracle Inquiry Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OracleInquiryNumber )
• DPUDrawingNumber ( type: esriFieldTypeString, alias: DPU Drawing Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConstructionDrawing )
• ProjectNumber ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectName )
• Accessible ( type: esriFieldTypeString, alias: Accessible, editable: true, nullable: true, length: 10, defaultValue: Unknown, modelName: Accessible , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• FromAssetID ( type: esriFieldTypeString, alias: From Asset ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FromAssetID )
• ToAssetID ( type: esriFieldTypeString, alias: To Asset ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ToAssetID )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 20, defaultValue: Main, modelName: Type , Coded Values: [Drain: Drain] , [Floor Drain: Floor Drain] , [Lateral: Lateral] , ...7 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Material , Coded Values: [ABS Plastic: ABS Plastic] , [Cast Iron: Cast Iron] , [Concrete: Concrete] , ...17 more... )
• PipeSize ( type: esriFieldTypeInteger, alias: Pipe Size, editable: true, nullable: true, defaultValue: null, modelName: PipeSize , Coded Values: [4: 4"] , [6: 6"] , [8: 8"] , ...45 more... )
• PipeShape ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PipeShape , Coded Values: [Circular: Circular] , [Elliptical: Elliptical] , [Rectangular: Rectangular] , ...4 more... )
• InvertUpstream ( type: esriFieldTypeDouble, alias: Invert Upstream, editable: true, nullable: true, defaultValue: null, modelName: InvertUpstream )
• InvertDownstream ( type: esriFieldTypeDouble, alias: Invert Downstream, editable: true, nullable: true, defaultValue: null, modelName: InvertDownstream )
• MeasuredLength ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: MeasuredLength )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
• CIPP ( type: esriFieldTypeString, alias: CIPP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CIPP , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• CIPPDate ( type: esriFieldTypeDate, alias: CIPP Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CIPPDate )
• CIPPContractor ( type: esriFieldTypeString, alias: CIPP Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPPContractor )
• LastRenovationDate ( type: esriFieldTypeDate, alias: Last Renovation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastRenovationDate )
• CCTVProjectName ( type: esriFieldTypeString, alias: CCTV Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CCTVProjectName )
• CCTVProjectNumber ( type: esriFieldTypeString, alias: CCTV Project Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CCTVProjectNumber )
• CCTVAssessment ( type: esriFieldTypeString, alias: CCTV Assessment, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CCTVAssessment , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...3 more... )
• CCTVAssessmentDate ( type: esriFieldTypeDate, alias: CCTV Assessment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CCTVAssessmentDate )
• CCTVContractor ( type: esriFieldTypeString, alias: CCTV Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CCTVContractor )
• RehabDrawingNumber ( type: esriFieldTypeString, alias: Rehab Drawing Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RehabDrawingNumber )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• Dimension ( type: esriFieldTypeDouble, alias: Dimension, editable: true, nullable: true, defaultValue: null, modelName: Dimension , Coded Values: [64.1: 8" x 8"] , [80: 8" x 10"] , [96: 8" x 12"] , ...136 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• StormwaterTraceWeight ( type: esriFieldTypeInteger, alias: StormwaterTraceWeight, editable: true, nullable: true, defaultValue: null, modelName: StormwaterTraceWeight )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 30, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• DirectionUpstream ( type: esriFieldTypeString, alias: Direction Upstream, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DirectionUpstream , Coded Values: [N: N] , [S: S] , [E: E] , ...7 more... )
• DirectionDownstream ( type: esriFieldTypeString, alias: Direction Downstream, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DirectionDownstream , Coded Values: [N: N] , [S: S] , [E: E] , ...7 more... )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Condition_1 , Coded Values: [Unobstructed: Unobstructed] , [Angular joint separation: Angular joint separation] , [Cracked pipe: Cracked pipe] , ...10 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: Active
Name: Active
Domains:
• LifeCycleStatus:
  Inherited
• Accessible:
  Inherited
• Type:
  Inherited
• Material:
  Inherited
• PipeSize:
  Inherited
• PipeShape:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
• Dimension:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Condition:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  Type: Main
  LifeCycleStatus: Active
  Accessible: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Inactive
Name: Inactive
Domains:
• LifeCycleStatus:
  Inherited
• Accessible:
  Inherited
• Type:
  Inherited
• Material:
  Inherited
• PipeSize:
  Inherited
• PipeShape:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
• Dimension:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Condition:
  Inherited
Templates:
• Name: Inactive
  Description:
  Prototype:
  Type: Main
  LifeCycleStatus: Inactive
  Accessible: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Proposed
Name: Proposed
Domains:
• LifeCycleStatus:
  Inherited
• Accessible:
  Inherited
• Type:
  Inherited
• Material:
  Inherited
• PipeSize:
  Inherited
• PipeShape:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
• Dimension:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Condition:
  Inherited
Templates:
• Name: Proposed
  Description:
  Prototype:
  Type: Main
  LifeCycleStatus: Proposed
  Accessible: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Under Construction
Name: Under Construction
Domains:
• LifeCycleStatus:
  Inherited
• Accessible:
  Inherited
• Type:
  Inherited
• Material:
  Inherited
• PipeSize:
  Inherited
• PipeShape:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
• Dimension:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Condition:
  Inherited
Templates:
• Name: Under Construction
  Description:
  Prototype:
  Type: Main
  LifeCycleStatus: Under Construction
  Accessible: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Unknown
Name: Unknown
Domains:
• LifeCycleStatus:
  Inherited
• Accessible:
  Inherited
• Type:
  Inherited
• Material:
  Inherited
• PipeSize:
  Inherited
• PipeShape:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
• Dimension:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Condition:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  Type: Main
  LifeCycleStatus: Unknown
  Accessible: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

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: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata