View In:   ArcGIS Online Map Viewer

Name: Sewer Repair Priority Mains

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1fd259022e4245ac8d15fb6b14527b3f

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: -1.3571747902918966E7
YMin: 4529194.441063459
XMax: -1.354578877905897E7
YMax: 4541509.439894867
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Class Breaks Renderer:
Field: LikelihoodOfFailure
Min. Value: 0.0
ClassBreakInfos:
• Class Maximum Value: 3
  Label: <= 3
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [107, 181, 123, 255]
  Width: 3
• Class Maximum Value: 5
  Label: 3 to 5
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [249, 244, 0, 255]
  Width: 3
• Class Maximum Value: 10
  Label: >5
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [240, 0, 0, 255]
  Width: 3
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

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 )
• SysID ( type: esriFieldTypeInteger, alias: Sys ID, editable: true, nullable: true, defaultValue: null, modelName: SysID )
• BasinAbbreviation ( type: esriFieldTypeString, alias: Basin Abbreviation, editable: true, nullable: true, length: 2, defaultValue: null, modelName: BasinAbbreviation , Coded Values: [AC: AC] , [DT: DT] , [EA: EA] , ...6 more... )
• BasinCode ( type: esriFieldTypeString, alias: Basin Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: BasinCode , Coded Values: [ACS4C2: ACS4C2] , [ACS4C3T: ACS4C3T] , [ACS4C4: ACS4C4] , ...109 more... )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: AssetID )
• UpstreamAssetID ( type: esriFieldTypeString, alias: Upstream Asset ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: UpstreamAssetID )
• DownstreamAssetID ( type: esriFieldTypeString, alias: Downstream Asset ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DownstreamAssetID )
• CasingID ( type: esriFieldTypeString, alias: Casing ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: CasingID )
• MainSubType ( type: esriFieldTypeInteger, alias: Sub-Type, editable: true, nullable: true, defaultValue: 2, modelName: SubType , Range: [0, 12] )
• TypeDescription ( type: esriFieldTypeString, alias: Main Type, editable: true, nullable: true, length: 12, defaultValue: Gravity Main, modelName: TypeDescription , Coded Values: [Force Main: Force Main] , [Gravity Main: Gravity Main] , [Siphon: Siphon] , ...1 more... )
• OtherMaterial ( type: esriFieldTypeString, alias: Other Material, editable: true, nullable: true, length: 11, defaultValue: null, modelName: OtherMaterial )
• NumberOfParallelPipes ( type: esriFieldTypeSmallInteger, alias: No Of Parallel Pipes, editable: true, nullable: true, defaultValue: 1, modelName: NumberOfParallelPiipes , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• UpstreamInvert ( type: esriFieldTypeDouble, alias: Upstream Invert, editable: true, nullable: true, defaultValue: null, modelName: UpstreamInvert , Range: [0, 1000] )
• DownstreamInvert ( type: esriFieldTypeDouble, alias: Downstream Invert, editable: true, nullable: true, defaultValue: null, modelName: DownstreamInvert , Range: [0, 1000] )
• MapGrid ( type: esriFieldTypeString, alias: Map Grid, editable: true, nullable: true, length: 4, defaultValue: null, modelName: MapGrid , Coded Values: [1A: 1A] , [1B: 1B] , [1C: 1C] , ...69 more... )
• IsInEasement ( type: esriFieldTypeString, alias: In Easement?, editable: true, nullable: true, length: 3, defaultValue: No, modelName: IsInEasement , Coded Values: [No: No] , [Yes: Yes] )
• InstallMethod ( type: esriFieldTypeString, alias: Install Method, editable: true, nullable: true, length: 16, defaultValue: Trench, modelName: InstallMethod , Coded Values: [Cured-In-Place: Cured-In-Place] , [Pipe Burst: Pipe Burst] , [Slip Lined: Slip Lined] , ...1 more... )
• IsLined ( type: esriFieldTypeString, alias: Is Lined?, editable: true, nullable: true, length: 3, defaultValue: No, modelName: IsLined , Coded Values: [No: No] , [Yes: Yes] )
• LiningMaterial ( type: esriFieldTypeString, alias: Lining Material, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LiningMaterial , Coded Values: [Epoxy: Epoxy] , [Fiberglass: Fiberglass] , [Polyester: Polyester] , ...1 more... )
• LiningMethod ( type: esriFieldTypeString, alias: Lining Method, editable: true, nullable: true, length: 24, defaultValue: null, modelName: LiningType , Coded Values: [Slip Line: Slip Line] , [Cured-in-Place: Cured-in-Place] , [Modified Cross Section: Modified Cross Section] , ...2 more... )
• YearRehabilitated ( type: esriFieldTypeInteger, alias: Year Rehabilitated, editable: true, nullable: true, defaultValue: null, modelName: YearRehabilitated )
• YearToBeReplaced ( type: esriFieldTypeInteger, alias: Replacement Year, editable: true, nullable: true, defaultValue: null, modelName: YearToBeReplaced )
• LastServiceDate ( type: esriFieldTypeDate, alias: Date Last Serviced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastServiceDate )
• HotSpotRating ( type: esriFieldTypeSmallInteger, alias: Hot Spot Rating, editable: true, nullable: true, defaultValue: 1, modelName: RepairPriorityValue , Range: [0, 100] )
• SelectiveCleaning1 ( type: esriFieldTypeString, alias: 1st Selective Cleaning Type, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SelectiveCleaning1 , Coded Values: [CCTV: CCTV] , [Hydro: Hydro] , [Root Foamed: Root Foamed] , ...3 more... )
• SelectiveCleaning2 ( type: esriFieldTypeString, alias: 2nd Selective Cleaning Type, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SelectiveCleaning2 , Coded Values: [CCTV: CCTV] , [Hydro: Hydro] , [Root Foamed: Root Foamed] , ...3 more... )
• SelectiveCleaning3 ( type: esriFieldTypeString, alias: 3rd Selective Cleaning Type, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SelectiveCleaning3 , Coded Values: [CCTV: CCTV] , [Hydro: Hydro] , [Root Foamed: Root Foamed] , ...3 more... )
• LikelihoodOfFailure ( type: esriFieldTypeDouble, alias: Likelihood of Failure, editable: true, nullable: true, defaultValue: null, modelName: LikelihoodOfFailure , Range: [0, 100] )
• RiskScore ( type: esriFieldTypeSmallInteger, alias: Risk Score, editable: true, nullable: true, defaultValue: null, modelName: RiskScore , Range: [0, 100] )
• LastHydroDate ( type: esriFieldTypeDate, alias: Last Hydro Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastHydroDate )
• CCTVDate ( type: esriFieldTypeDate, alias: CCTV Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CCTVDate )
• CCTVScore ( type: esriFieldTypeDouble, alias: CCTV Score, editable: true, nullable: true, defaultValue: null, modelName: CCTVScore )
• CCTVDocumentURL ( type: esriFieldTypeString, alias: CCTV Document URL, editable: true, nullable: true, length: 256, defaultValue: null, modelName: CCTVDocumentURL )
• FullCap ( type: esriFieldTypeDouble, alias: Full Cap, editable: true, nullable: true, defaultValue: null, modelName: FullCap )
• ExDry ( type: esriFieldTypeDouble, alias: Ex Dry, editable: true, nullable: true, defaultValue: null, modelName: ExDry )
• ExWet ( type: esriFieldTypeDouble, alias: Ex Wet, editable: true, nullable: true, defaultValue: null, modelName: ExWet )
• UltDry ( type: esriFieldTypeDouble, alias: Ult Dry, editable: true, nullable: true, defaultValue: null, modelName: UltDry )
• UltWet ( type: esriFieldTypeDouble, alias: Ult Wet, editable: true, nullable: true, defaultValue: null, modelName: UltWet )
• OwnedBy ( type: esriFieldTypeString, alias: Owned By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OwnedBy , Coded Values: [Alameda County: Alameda County] , [BART: BART] , [California Water Service: California Water Service] , ...24 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintainedBy , Coded Values: [Alameda County: Alameda County] , [BART: BART] , [California Water Service: California Water Service] , ...24 more... )
• OperationalStatus ( type: esriFieldTypeString, alias: Operational Status, editable: true, nullable: true, length: 12, defaultValue: null, modelName: OperationalStatus , Coded Values: [Abandoned: Abandoned] , [Proposed: Proposed] , [Inoperable: Inoperable] , ...2 more... )
• DateAbandoned ( type: esriFieldTypeDate, alias: Date Abandoned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateAbandoned )
• SourceDocumentType ( type: esriFieldTypeString, alias: Source Doc Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SourceDocumentType , Coded Values: [As Built: As Built] , [Atlas Map: Atlas Map] , [Design Plan: Design Plan] , ...7 more... )
• ProjectNumber ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ProjectNumber )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 80, defaultValue: null, modelName: ProjectName )
• DocumentURL ( type: esriFieldTypeString, alias: Document URL, editable: true, nullable: true, length: 256, defaultValue: null, modelName: DocumentURL )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreatedBy )
• LastUpdated ( type: esriFieldTypeDate, alias: Last Updated, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdated )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 20, defaultValue: null, modelName: LastEditor )
• RevisionNotes ( type: esriFieldTypeString, alias: Revision Notes, editable: true, nullable: true, length: 256, defaultValue: null, modelName: RevisionNotes )
• GeometryIsValidated ( type: esriFieldTypeString, alias: Geometry Is Validated?, editable: true, nullable: true, length: 3, defaultValue: No, modelName: GeometryIsValidated , Coded Values: [No: No] , [Yes: Yes] )
• AttributesAreValidated ( type: esriFieldTypeString, alias: Attributes Are Validated?, editable: true, nullable: true, length: 3, defaultValue: No, modelName: AttributesAreValidated , Coded Values: [No: No] , [Yes: Yes] )
• UnresolvedComments ( type: esriFieldTypeString, alias: Unresolved Comments, editable: true, nullable: true, length: 256, defaultValue: null, modelName: UnresolvedComments )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, required: true, nullable: true, defaultValue: null, modelName: Shape.STLength() )

Templates:

• Name: Sewer Repair Priority Mains
  Description:
  Prototype:
  UnresolvedComments: null
  Notes: null
  SysID: null
  BasinAbbreviation: null
  BasinCode: null
  AssetID: null
  UpstreamAssetID: null
  DownstreamAssetID: null
  CasingID: null
  MainSubType: 2
  TypeDescription: Gravity Main
  OtherMaterial: null
  NumberOfParallelPipes: 1
  UpstreamInvert: null
  DownstreamInvert: null
  MapGrid: null
  IsInEasement: No
  InstallMethod: Trench
  IsLined: No
  LiningMaterial: null
  LiningMethod: null
  YearRehabilitated: null
  YearToBeReplaced: null
  LastServiceDate: null
  HotSpotRating: 1
  SelectiveCleaning1: null
  SelectiveCleaning2: null
  SelectiveCleaning3: null
  LikelihoodOfFailure: null
  RiskScore: null
  LastHydroDate: null
  CCTVDate: null
  CCTVScore: null
  CCTVDocumentURL: null
  FullCap: null
  ExDry: null
  ExWet: null
  UltDry: null
  UltWet: null
  OwnedBy: null
  MaintainedBy: null
  OperationalStatus: null
  DateAbandoned: null
  SourceDocumentType: null
  ProjectNumber: null
  ProjectName: null
  DocumentURL: null
  AttributesAreValidated: No
  GeometryIsValidated: No
  RevisionNotes: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Sync,Extract

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: LastUpdated
• Editor Field: LastEditor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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