View In:   ArcGIS Online Map Viewer

Name: Sewer System Gravity Pipe

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: -8638021.327240454
YMin: 4502667.866243145
XMax: -8614405.351027323
YMax: 4523797.371337654
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: [204, 204, 204, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [112, 168, 0, 255]
  Width: 1
• Value: Inactive
  Label: Inactive
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [112, 168, 0, 255]
  Width: 1
• Value: Proposed
  Label: Proposed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 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: [182, 252, 251, 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: Unobstructed, 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] )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 20, defaultValue: Main, modelName: Type , Coded Values: [Connector: Connector] , [Digested Sludge: Digested Sludge] , [Discharge: Discharge] , ...12 more... )
• InterceptorName ( type: esriFieldTypeString, alias: Interceptor Name, editable: true, nullable: true, length: 50, defaultValue: null, 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: 70, defaultValue: null, modelName: Material , Coded Values: [ABS Plastic: ABS Plastic] , [Asbestos Cement (AKA Transite): Asbestos Cement (AKA Transite)] , [Brick: Brick] , ...24 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Status , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] )
• PipeShape ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 20, defaultValue: Circular, modelName: PipeShape , Coded Values: [Arch: Arch] , [Circular: Circular] , [Egg: Egg] , ...4 more... )
• PipeSize ( type: esriFieldTypeDouble, alias: Pipe Size, editable: true, nullable: true, defaultValue: null, modelName: PipeSize , Coded Values: [4: 4"] , [6: 6"] , [8: 8"] , ...59 more... )
• PipeDimension ( type: esriFieldTypeDouble, alias: Pipe Dimension, editable: true, nullable: true, defaultValue: null, modelName: PipeDimension , Coded Values: [80: 8" x 10"] , [96: 8" x 12"] , [120: 10" x 12"] , ...131 more... )
• PipeName ( type: esriFieldTypeString, alias: Pipe Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeName )
• 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: CC TV Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CCTVProjectName )
• CCTVProjectNumber ( type: esriFieldTypeString, alias: CC TV Project Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CCTVProjectNumber )
• CCTVAssessment ( type: esriFieldTypeString, alias: CC TV 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: 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 )
• BackupReports ( type: esriFieldTypeString, alias: Backup Reports, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BackupReports , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• RepairHistory ( type: esriFieldTypeString, alias: Repair History, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RepairHistory )
• WorkInStreetPermitNumber ( type: esriFieldTypeString, alias: Work In Street Permit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WorkInStreetPermitNumber )
• 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... )
• 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 )
• PipeHeight ( type: esriFieldTypeDouble, alias: Pipe Height, editable: true, nullable: true, defaultValue: null, modelName: PipeHeight )
• PipeWidth ( type: esriFieldTypeDouble, alias: Pipe Width, editable: true, nullable: true, defaultValue: null, modelName: PipeWidth )
• ModelComment ( type: esriFieldTypeString, alias: ModelComment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ModelComment )
• 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
• Type:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeShape:
  Inherited
• PipeSize:
  Inherited
• PipeDimension:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• BackupReports:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  Condition: Unobstructed
  PipeShape: Circular
  LifeCycleStatus: Active
  Type: Main
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Inactive
Name: Inactive
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• Type:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeShape:
  Inherited
• PipeSize:
  Inherited
• PipeDimension:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• BackupReports:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Inactive
  Description:
  Prototype:
  Condition: Unobstructed
  PipeShape: Circular
  LifeCycleStatus: Inactive
  Type: Main
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Proposed
Name: Proposed
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• Type:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeShape:
  Inherited
• PipeSize:
  Inherited
• PipeDimension:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• BackupReports:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Proposed
  Description:
  Prototype:
  Condition: Unobstructed
  PipeShape: Circular
  LifeCycleStatus: Proposed
  Type: Main
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Under Construction
Name: Under Construction
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• Type:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeShape:
  Inherited
• PipeSize:
  Inherited
• PipeDimension:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• BackupReports:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Under Construction
  Description:
  Prototype:
  Condition: Unobstructed
  PipeShape: Circular
  LifeCycleStatus: Under Construction
  Type: Main
  Enabled: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Unknown
Name: Unknown
Domains:
• Condition:
  Inherited
• LifeCycleStatus:
  Inherited
• System:
  Inherited
• Type:
  Inherited
• InterceptorName:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• PipeShape:
  Inherited
• PipeSize:
  Inherited
• PipeDimension:
  Inherited
• CIPP:
  Inherited
• CCTVAssessment:
  Inherited
• BackupReports:
  Inherited
• DirectionUpstream:
  Inherited
• DirectionDownstream:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  Condition: Unobstructed
  PipeShape: Circular
  LifeCycleStatus: Unknown
  Type: Main
  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