View In:   ArcGIS Online Map Viewer

Name: Sewer System Force Main

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: c50ad40eb2f74d7a83d5993975942fa0

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: -8631716.874558527
YMin: 4503245.357032024
XMax: -8616064.430757038
YMax: 4523780.917739673
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: esriSLSDashDot
Color: [130, 130, 130, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [38, 115, 0, 255]
  Width: 1
• Value: Inactive
  Label: Inactive
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 168, 132, 255]
  Width: 1
• Value: Proposed
  Label: Proposed
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [230, 0, 0, 255]
  Width: 1
• Value: Under Construction
  Label: Under Construction
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [0, 168, 132, 255]
  Width: 1
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSDashDot
  Color: [181, 255, 238, 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 )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 30, defaultValue: Other, modelName: Condition , Coded Values: [Unobstructed: Unobstructed] , [Angular joint separation: Angular joint separation] , [Cracked pipe: Cracked pipe] , ...10 more... )
• 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 )
• System ( type: esriFieldTypeString, alias: System, editable: true, nullable: true, length: 10, defaultValue: null, modelName: System , Coded Values: [Sanitary: Sanitary] , [Combined: Combined] , [CSO: CSO] )
• InterceptorName ( type: esriFieldTypeString, alias: Interceptor Name, editable: true, nullable: true, length: 50, defaultValue: Unknown, modelName: InterceptorName , Coded Values: [22nd Street Interceptor Part 1: 22nd Street Interceptor Part 1] , [22nd Street Interceptor Part 2: 22nd Street Interceptor Part 2] , [42nd Street Interceptor: 42nd Street Interceptor] , ...40 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 40, defaultValue: Unknown, modelName: Material , Coded Values: [Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , [Precast Concrete: Precast Concrete] , ...6 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: In Service, modelName: Status , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] )
• PipeSize ( type: esriFieldTypeDouble, alias: Pipe Size, editable: true, nullable: true, defaultValue: null, modelName: PipeSize , Coded Values: [2: 2"] , [4: 4"] , [6: 6"] , ...28 more... )
• PipeName ( type: esriFieldTypeString, alias: Pipe Name, editable: true, nullable: true, length: 50, defaultValue: Unknown, modelName: PipeName )
• MeasuredLength ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: MeasuredLength )
• NormalOperatingPressure ( type: esriFieldTypeDouble, alias: Normal Operating Pressure, editable: true, nullable: true, defaultValue: null, modelName: NormalOperatingPressure )
• CIPP ( type: esriFieldTypeString, alias: CIPP, editable: true, nullable: true, length: 10, defaultValue: Unknown, modelName: CIPP , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• CIPPContractor ( type: esriFieldTypeString, alias: CIPP Contractor, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: CIPPContractor )
• LastRenovationDate ( type: esriFieldTypeDate, alias: Last Renovation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastRenovationDate )
• CCTVProjectName ( type: esriFieldTypeString, alias: CC TV Project Name, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: CCTVProjectName )
• CCTVProjectNumber ( type: esriFieldTypeString, alias: CC TV Project Number, editable: true, nullable: true, length: 10, defaultValue: Unknown, modelName: CCTVProjectNumber )
• CCTVAssessment ( type: esriFieldTypeString, alias: CCTVAssessment, editable: true, nullable: true, length: 15, defaultValue: Unknown, modelName: CCTVAssessment , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...3 more... )
• CCTVAssessmentDate ( type: esriFieldTypeDate, alias: CC TV Assessment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CCTVAssessmentDate )
• CCTVContractor ( type: esriFieldTypeString, alias: CC TV Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CCTVContractor )
• RehabDwgNumber ( type: esriFieldTypeSmallInteger, alias: Rehab Drawing Number, editable: true, nullable: true, defaultValue: null, modelName: RehabDwgNumber )
• WISPNumber ( type: esriFieldTypeString, alias: WISP Number, editable: true, nullable: true, length: 10, defaultValue: Unknown, modelName: WISPNumber )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• SewerTraceWeight ( type: esriFieldTypeInteger, alias: SewerTraceWeight, editable: true, nullable: true, defaultValue: null, modelName: SewerTraceWeight )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: Active
Name: Active
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeSize:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  Condition: Other
  WISPNumber: Unknown
  LifeCycleStatus: Active
  InterceptorName: Unknown
  Material: Unknown
  Status: In Service
  PipeName: Unknown
  CIPP: Unknown
  CIPPContractor: Unknown
  CCTVProjectName: Unknown
  CCTVProjectNumber: Unknown
  CCTVAssessment: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Inactive
Name: Inactive
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeSize:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Inactive
  Description:
  Prototype:
  Condition: Other
  WISPNumber: Unknown
  LifeCycleStatus: Inactive
  InterceptorName: Unknown
  Material: Unknown
  Status: In Service
  PipeName: Unknown
  CIPP: Unknown
  CIPPContractor: Unknown
  CCTVProjectName: Unknown
  CCTVProjectNumber: Unknown
  CCTVAssessment: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Proposed
Name: Proposed
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeSize:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Proposed
  Description:
  Prototype:
  Condition: Other
  WISPNumber: Unknown
  LifeCycleStatus: Proposed
  InterceptorName: Unknown
  Material: Unknown
  Status: In Service
  PipeName: Unknown
  CIPP: Unknown
  CIPPContractor: Unknown
  CCTVProjectName: Unknown
  CCTVProjectNumber: Unknown
  CCTVAssessment: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Under Construction
Name: Under Construction
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeSize:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Under Construction
  Description:
  Prototype:
  Condition: Other
  WISPNumber: Unknown
  LifeCycleStatus: Under Construction
  InterceptorName: Unknown
  Material: Unknown
  Status: In Service
  PipeName: Unknown
  CIPP: Unknown
  CIPPContractor: Unknown
  CCTVProjectName: Unknown
  CCTVProjectNumber: Unknown
  CCTVAssessment: Unknown
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Unknown
Name: Unknown
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeSize:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  Condition: Other
  WISPNumber: Unknown
  LifeCycleStatus: Unknown
  InterceptorName: Unknown
  Material: Unknown
  Status: In Service
  PipeName: Unknown
  CIPP: Unknown
  CIPPContractor: Unknown
  CCTVProjectName: Unknown
  CCTVProjectNumber: Unknown
  CCTVAssessment: 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