View In:   ArcGIS Online Map Viewer

Name: Sanitary Mains

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: -118121300
YMin: -97418300
XMax: 2317711.84491973
YMax: 452068.495420054
Spatial Reference: 102754  (2289)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: MainLineType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label: Unassigned
UniqueValueInfos:
• Value: Force Main
  Label: Force Main
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 200, 255, 255]
  Width: 2
• Value: Interceptor
  Label: Interceptor
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: Sanitary Sewer
  Label: Sanitary Sewer
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 168, 132, 255]
  Width: 2
• Value: Siphon
  Label: Siphon
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: MainLineType

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: 50, defaultValue: null, modelName: G1_ASSET_ID )
• AssetStatus ( type: esriFieldTypeString, alias: Asset Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: G1_ASSET_STATUS , Coded Values: [Excellent: Excellent] , [Good: Good] , [In Service: In Service] , ...4 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: G1_COMMENTS )
• SDE.San_Main.AREA ( type: esriFieldTypeString, alias: SDE.San_Main.AREA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SDE.San_Main.AREA )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOC , Coded Values: [Alley, Good Access: Alley, Good Access] , [Alley, Poor Access: Alley, Poor Access] , [Asphalt Street: Asphalt Street] , ...14 more... )
• MainLineType ( type: esriFieldTypeString, alias: Main Line Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MainLineType , Coded Values: [Combined Drainage & Sanitary: Combined Drainage & Sanitary] , [Culvert: Culvert] , [Drainage: Drainage] , ...9 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer , Coded Values: [Abb/Cct Environmental: Abb/Cct Environmental] , [Abm Electric Motors: Abm Electric Motors] , [Advanced Flow Technology: Advanced Flow Technology] , ...280 more... )
• SurfaceCover ( type: esriFieldTypeString, alias: Surface Cover, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SurfaceCover , Coded Values: [Asphalt Street: Asphalt Street] , [Boulevard: Boulevard] , [Close to Fence: Close to Fence] , ...13 more... )
• CriticalRating ( type: esriFieldTypeString, alias: Critical Rating, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CriticalRating , Coded Values: [0- FYI: 0- FYI] , [1- Low Priority: 1- Low Priority] , [2- Medium Priority: 2- Medium Priority] , ...1 more... )
• PipeType ( type: esriFieldTypeString, alias: Pipe Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeType , Coded Values: [Asbestos Cement Pipe: Asbestos Cement Pipe] , [Cast Iron Pipe: Cast Iron Pipe] , [Cured-In-Place Pipe: Cured-In-Place Pipe] , ...25 more... )
• PipeShape ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeShape , Coded Values: [Circular: Circular] , [Elliptical: Elliptical] )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [0: 0] , [2: 2] , [4: 4] , ...18 more... )
• Height ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• UpsDepth ( type: esriFieldTypeDouble, alias: Ups Depth, editable: true, nullable: true, defaultValue: null, modelName: UpsDepth )
• DownDepth ( type: esriFieldTypeDouble, alias: Down Depth, editable: true, nullable: true, defaultValue: null, modelName: DownDepth )
• DwnInvertElev ( type: esriFieldTypeDouble, alias: Down Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: DwnInvertElev )
• Length ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
• asblt ( type: esriFieldTypeString, alias: Asbuilt, editable: true, nullable: true, length: 150, defaultValue: null, modelName: asblt )
• LiningMethod ( type: esriFieldTypeString, alias: LiningMethod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LiningMethod , Coded Values: [CIP-Cured In Place Pipe: CIP- Cured In Place Pipe] , [FF- Fold and Form: FF- Fold and Form] , [FP- Formed in Place Liner: FP- Formed in Place Liner] , ...11 more... )
• LiningInstallDate ( type: esriFieldTypeDate, alias: Lining Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LININGINSTALL )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL )
• PluggedSewerReport ( type: esriFieldTypeString, alias: PluggedSewerReport, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PluggedSewerReport )
• UpsInvertElev ( type: esriFieldTypeDouble, alias: Upstream Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: UpsInvertElev )
• LiningManufacturer ( type: esriFieldTypeString, alias: Lining Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LiningManufacturer )
• LiningInstallContractor ( type: esriFieldTypeString, alias: Lining Install Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LiningInstallContractor )
• PipeManufacturer ( type: esriFieldTypeString, alias: Pipe Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeManufacturer )
• CleaningStatus ( type: esriFieldTypeString, alias: CleaningStatus, editable: true, nullable: true, length: 50, defaultValue: Pending, modelName: CleaningStatus , Coded Values: [Complete: Complete] , [Pending: Pending] )
• AsbuiltLink1 ( type: esriFieldTypeString, alias: As-Built Link 1, editable: true, nullable: true, length: 150, defaultValue: null, modelName: AsbuiltLink1 )
• AsbuiltLink2 ( type: esriFieldTypeString, alias: As-Built Link 2, editable: true, nullable: true, length: 150, defaultValue: null, modelName: AsbuiltLink2 )
• TelevisingStatus ( type: esriFieldTypeString, alias: Televising Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TelevisingStatus , Coded Values: [Yes: Yes] , [No: No] )
• TelevisingInfo ( type: esriFieldTypeString, alias: Televising Info- IT Pipes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: TelevisingInfo )
• Asset_ID_Start ( type: esriFieldTypeString, alias: Asset ID Start, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_ID_Start )
• Asset_ID_End ( type: esriFieldTypeString, alias: Asset ID End, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_ID_End )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• DateLastTelevised ( type: esriFieldTypeDate, alias: Date Last Televised, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateLastTelevised )
• DateLastCleaned ( type: esriFieldTypeDate, alias: Date Last Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateLastCleaned )
• MID_X ( type: esriFieldTypeDouble, alias: MID_X, editable: true, nullable: true, defaultValue: null, modelName: MID_X )
• MID_Y ( type: esriFieldTypeDouble, alias: MID_Y, editable: true, nullable: true, defaultValue: null, modelName: MID_Y )
• FrictionFactor ( type: esriFieldTypeDouble, alias: Friction Factor, editable: true, nullable: true, defaultValue: null, modelName: FrictionFactor )
• Company ( type: esriFieldTypeString, alias: Company, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Company )
• YearRenewed ( type: esriFieldTypeInteger, alias: Year Renewed, editable: true, nullable: true, defaultValue: null, modelName: YearRenewed )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• StreetName ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetName )
• Surface ( type: esriFieldTypeString, alias: Surface, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Surface )
• DateFound ( type: esriFieldTypeDate, alias: Date Found, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateFound )
• IssueRepairNeeded ( type: esriFieldTypeString, alias: Issue/Repair Needed, editable: true, nullable: true, length: 500, defaultValue: null, modelName: IssueRepairNeeded )
• Rating ( type: esriFieldTypeInteger, alias: Rating, editable: true, nullable: true, defaultValue: null, modelName: Rating )
• RepairYear ( type: esriFieldTypeInteger, alias: RepairYear, editable: true, nullable: true, defaultValue: null, modelName: RepairYear )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )

Types:

ID: Force Main
Name: Force Main
Domains:
• AssetStatus:
  Inherited
• Location:
  Inherited
• MainLineType:
  Inherited
• Manufacturer:
  Inherited
• SurfaceCover:
  Inherited
• CriticalRating:
  Inherited
• PipeType:
  Inherited
• PipeShape:
  Inherited
• Diameter:
  Inherited
• LiningMethod:
  Inherited
• CleaningStatus:
  Inherited
• TelevisingStatus:
  Inherited
Templates:
• Name: Force Main
  Description:
  Prototype:
  RepairYear: null
  Rating: null
  AssetID: null
  AssetStatus: null
  Comments: null
  SDE.San_Main.AREA: null
  Location: null
  MainLineType: Force Main
  Manufacturer: null
  SurfaceCover: null
  CriticalRating: null
  PipeType: null
  PipeShape: null
  Diameter: null
  Height: null
  UpsDepth: null
  DownDepth: null
  DwnInvertElev: null
  Length: null
  Slope: null
  asblt: null
  LiningMethod: null
  LiningInstallDate: null
  InstallDate: null
  PluggedSewerReport: null
  UpsInvertElev: null
  LiningManufacturer: null
  LiningInstallContractor: null
  PipeManufacturer: null
  CleaningStatus: Pending
  AsbuiltLink1: null
  AsbuiltLink2: null
  TelevisingStatus: null
  TelevisingInfo: null
  Asset_ID_Start: null
  Asset_ID_End: null
  DateFound: null
  Surface: null
  StreetName: null
  IssueRepairNeeded: null
  DateLastTelevised: null
  DateLastCleaned: null
  MID_X: null
  MID_Y: null
  FrictionFactor: null
  Company: null
  YearRenewed: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Interceptor
Name: Interceptor
Domains:
• AssetStatus:
  Inherited
• Location:
  Inherited
• MainLineType:
  Inherited
• Manufacturer:
  Inherited
• SurfaceCover:
  Inherited
• CriticalRating:
  Inherited
• PipeType:
  Inherited
• PipeShape:
  Inherited
• Diameter:
  Inherited
• LiningMethod:
  Inherited
• CleaningStatus:
  Inherited
• TelevisingStatus:
  Inherited
Templates:
• Name: Interceptor
  Description:
  Prototype:
  RepairYear: null
  Rating: null
  AssetID: null
  AssetStatus: null
  Comments: null
  SDE.San_Main.AREA: null
  Location: null
  MainLineType: Interceptor
  Manufacturer: null
  SurfaceCover: null
  CriticalRating: null
  PipeType: null
  PipeShape: null
  Diameter: null
  Height: null
  UpsDepth: null
  DownDepth: null
  DwnInvertElev: null
  Length: null
  Slope: null
  asblt: null
  LiningMethod: null
  LiningInstallDate: null
  InstallDate: null
  PluggedSewerReport: null
  UpsInvertElev: null
  LiningManufacturer: null
  LiningInstallContractor: null
  PipeManufacturer: null
  CleaningStatus: Pending
  AsbuiltLink1: null
  AsbuiltLink2: null
  TelevisingStatus: null
  TelevisingInfo: null
  Asset_ID_Start: null
  Asset_ID_End: null
  DateFound: null
  Surface: null
  StreetName: null
  IssueRepairNeeded: null
  DateLastTelevised: null
  DateLastCleaned: null
  MID_X: null
  MID_Y: null
  FrictionFactor: null
  Company: null
  YearRenewed: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Sanitary Sewer
Name: Sanitary Sewer
Domains:
• AssetStatus:
  Inherited
• Location:
  Inherited
• MainLineType:
  Inherited
• Manufacturer:
  Inherited
• SurfaceCover:
  Inherited
• CriticalRating:
  Inherited
• PipeType:
  Inherited
• PipeShape:
  Inherited
• Diameter:
  Inherited
• LiningMethod:
  Inherited
• CleaningStatus:
  Inherited
• TelevisingStatus:
  Inherited
Templates:
• Name: Sanitary Sewer
  Description:
  Prototype:
  RepairYear: null
  Rating: null
  AssetID: null
  AssetStatus: null
  Comments: null
  SDE.San_Main.AREA: null
  Location: null
  MainLineType: Sanitary Sewer
  Manufacturer: null
  SurfaceCover: null
  CriticalRating: null
  PipeType: null
  PipeShape: null
  Diameter: null
  Height: null
  UpsDepth: null
  DownDepth: null
  DwnInvertElev: null
  Length: null
  Slope: null
  asblt: null
  LiningMethod: null
  LiningInstallDate: null
  InstallDate: null
  PluggedSewerReport: null
  UpsInvertElev: null
  LiningManufacturer: null
  LiningInstallContractor: null
  PipeManufacturer: null
  CleaningStatus: Pending
  AsbuiltLink1: null
  AsbuiltLink2: null
  TelevisingStatus: null
  TelevisingInfo: null
  Asset_ID_Start: null
  Asset_ID_End: null
  DateFound: null
  Surface: null
  StreetName: null
  IssueRepairNeeded: null
  DateLastTelevised: null
  DateLastCleaned: null
  MID_X: null
  MID_Y: null
  FrictionFactor: null
  Company: null
  YearRenewed: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Siphon
Name: Siphon
Domains:
• AssetStatus:
  Inherited
• Location:
  Inherited
• MainLineType:
  Inherited
• Manufacturer:
  Inherited
• SurfaceCover:
  Inherited
• CriticalRating:
  Inherited
• PipeType:
  Inherited
• PipeShape:
  Inherited
• Diameter:
  Inherited
• LiningMethod:
  Inherited
• CleaningStatus:
  Inherited
• TelevisingStatus:
  Inherited
Templates:
• Name: Siphon
  Description:
  Prototype:
  RepairYear: null
  Rating: null
  AssetID: null
  AssetStatus: null
  Comments: null
  SDE.San_Main.AREA: null
  Location: null
  MainLineType: Siphon
  Manufacturer: null
  SurfaceCover: null
  CriticalRating: null
  PipeType: null
  PipeShape: null
  Diameter: null
  Height: null
  UpsDepth: null
  DownDepth: null
  DwnInvertElev: null
  Length: null
  Slope: null
  asblt: null
  LiningMethod: null
  LiningInstallDate: null
  InstallDate: null
  PluggedSewerReport: null
  UpsInvertElev: null
  LiningManufacturer: null
  LiningInstallContractor: null
  PipeManufacturer: null
  CleaningStatus: Pending
  AsbuiltLink1: null
  AsbuiltLink2: null
  TelevisingStatus: null
  TelevisingInfo: null
  Asset_ID_Start: null
  Asset_ID_End: null
  DateFound: null
  Surface: null
  StreetName: null
  IssueRepairNeeded: null
  DateLastTelevised: null
  DateLastCleaned: null
  MID_X: null
  MID_Y: null
  FrictionFactor: null
  Company: null
  YearRenewed: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• Sanitary_Pipe_Inspection (1) -- Related To: Pipe Inspections (3)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata