Name: Sewer Main - Inspection by Year

Display Field: PW_GIS.ssGravityMain.LifecycleStatus

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Sewer system for the City of La Mesa.This feature class contains data pertaining to gravity mains within the City of La Mesa. Gravity mains are pipes that channel sewer flow (wastewater) from one point to another via gravity.Based on the Esri Simplified Sewer file geodatabase model; added La Mesa content.Feature-linked annotation allows for a relationship between the feature and the annotation. If the feature is moved the annotation will also be moved. When an attribute is updated the annotation text updates if it is linked. Placement properties are also stored in the feature class so that individual text can be moved as needed.

Copyright Text: City of La Mesa, Department of Public Works

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6314584.490129724
YMin: 1851444.5612029731
XMax: 6336838.893783554
YMax: 1870111.5143545568
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PW_GIS.SewerVideoInspectionYears.InspetionVideoYear
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 3
Default Label: No video year
UniqueValueInfos:
• Value: 2000
  Label: 2000
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 34, 0, 255]
  Width: 3
• Value: 2001
  Label: 2001
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 64, 0, 255]
  Width: 3
• Value: 2002
  Label: 2002
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 89, 0, 255]
  Width: 3
• Value: 2003
  Label: 2003
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 111, 0, 255]
  Width: 3
• Value: 2004
  Label: 2004
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 132, 0, 255]
  Width: 3
• Value: 2005
  Label: 2005
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 152, 0, 255]
  Width: 3
• Value: 2006
  Label: 2006
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 173, 0, 255]
  Width: 3
• Value: 2007
  Label: 2007
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 193, 0, 255]
  Width: 3
• Value: 2008
  Label: 2008
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 213, 0, 255]
  Width: 3
• Value: 2009
  Label: 2009
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 234, 0, 255]
  Width: 3
• Value: 2010
  Label: 2010
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 3
• Value: 2012
  Label: 2012
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [226, 237, 0, 255]
  Width: 3
• Value: 2013
  Label: 2013
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [198, 220, 0, 255]
  Width: 3
• Value: 2014
  Label: 2014
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [172, 203, 0, 255]
  Width: 3
• Value: 2015
  Label: 2015
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [146, 187, 0, 255]
  Width: 3
• Value: 2016
  Label: 2016
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [122, 170, 0, 255]
  Width: 3
• Value: 2017
  Label: 2017
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [99, 155, 0, 255]
  Width: 3
• Value: 2018
  Label: 2018
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [77, 140, 0, 255]
  Width: 3
• Value: 2019
  Label: 2019
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [55, 125, 0, 255]
  Width: 3
• Value: 2020
  Label: 2020
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [34, 111, 0, 255]
  Width: 3
• Value: 2021
  Label: 2021
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [1, 97, 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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• PW_GIS.ssGravityMain.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PW_GIS.ssGravityMain.InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• PW_GIS.ssGravityMain.LifecycleStatus ( type: esriFieldTypeString, alias: Lifecycle Status, length: 20 , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...2 more... )
• PW_GIS.ssGravityMain.Material ( type: esriFieldTypeString, alias: Material, length: 255 , Coded Values: [PVC: Poly Vinyl Chloride] , [AC: Asbestos Concrete] , [VCP: Vitrified Clay Pipe] , ...8 more... )
• PW_GIS.ssGravityMain.UpstreamInvert ( type: esriFieldTypeDouble, alias: Upstream Invert )
• PW_GIS.ssGravityMain.DownstreamInvert ( type: esriFieldTypeDouble, alias: Downstream Invert )
• PW_GIS.ssGravityMain.NominalDiameter ( type: esriFieldTypeDouble, alias: Nominal Diameter )
• PW_GIS.ssGravityMain.Slope ( type: esriFieldTypeDouble, alias: Slope )
• PW_GIS.ssGravityMain.PipeID ( type: esriFieldTypeString, alias: Pipe ID, length: 20 )
• PW_GIS.ssGravityMain.Length ( type: esriFieldTypeDouble, alias: Length )
• PW_GIS.ssGravityMain.AsBuiltNumber ( type: esriFieldTypeString, alias: As-Built Number, length: 25 )
• PW_GIS.ssGravityMain.ManholeUp ( type: esriFieldTypeString, alias: Manhole Up, length: 20 )
• PW_GIS.ssGravityMain.ManholeDown ( type: esriFieldTypeString, alias: Manhole Down, length: 20 )
• PW_GIS.ssGravityMain.Street ( type: esriFieldTypeString, alias: Street, length: 50 , Coded Values: [3rd St: 3rd St] , [4th St: 4th St] , [67th St: 67th St] , ...598 more... )
• PW_GIS.ssGravityMain.Location ( type: esriFieldTypeString, alias: Location, length: 20 , Coded Values: [ESMT: Easement] , [RDES: Roadway and Easement] , [ROAD: Roadway] , ...2 more... )
• PW_GIS.ssGravityMain.OldID ( type: esriFieldTypeString, alias: Old ID, length: 20 )
• PW_GIS.ssGravityMain.Comments ( type: esriFieldTypeString, alias: Comments, length: 150 )
• PW_GIS.ssGravityMain.PageNumber ( type: esriFieldTypeString, alias: Page Number, length: 10 , Coded Values: [A04: A-04] , [A05: A-05] , [A06: A-06] , ...68 more... )
• PW_GIS.ssGravityMain.CIPYear ( type: esriFieldTypeString, alias: CIP Year, length: 20 )
• PW_GIS.ssGravityMain.EditInitials ( type: esriFieldTypeString, alias: Edit Initials, length: 20 )
• PW_GIS.ssGravityMain.EditDate ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• PW_GIS.ssGravityMain.EditSource ( type: esriFieldTypeString, alias: Edit Source, length: 250 )
• PW_GIS.ssGravityMain.OldAsbuiltNumber ( type: esriFieldTypeString, alias: Old As-built Number, length: 25 )
• PW_GIS.ssGravityMain.Owner ( type: esriFieldTypeString, alias: Owner, length: 20 , Coded Values: [Other: Other agency] , [San Diego: San Diego] , [SD County: SD County] , ...4 more... )
• PW_GIS.ssGravityMain.Miles ( type: esriFieldTypeDouble, alias: Miles )
• PW_GIS.ssGravityMain.Hotspot ( type: esriFieldTypeString, alias: Hotspot, length: 50 , Coded Values: [JET: JET] , [ROD: ROD] , [NO: NO] )
• PW_GIS.ssGravityMain.Footage ( type: esriFieldTypeSmallInteger, alias: Footage )
• PW_GIS.ssGravityMain.HotspotType ( type: esriFieldTypeString, alias: Hotspot Type, length: 50 )
• PW_GIS.ssGravityMain.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• PW_GIS.ssGravityMain.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• PW_GIS.ssGravityMain.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• PW_GIS.ssGravityMain.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• PW_GIS.ssGravityMain.Zone ( type: esriFieldTypeSmallInteger, alias: Zone )
• PW_GIS.ssGravityMain.SewerBasin ( type: esriFieldTypeString, alias: SewerBasin, length: 10 )
• PW_GIS.ssGravityMain.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PW_GIS.ssGravityMain.PipePhysicalDetails ( type: esriFieldTypeString, alias: Pipe Physical Details, length: 50 , Coded Values: [Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , [Extra Strength: Extra Strength] , ...3 more... )
• PW_GIS.ssGravityMain.InspPageNumber ( type: esriFieldTypeString, alias: Inspection Page Number, length: 50 )
• PW_GIS.ssGravityMain.FiscalYear ( type: esriFieldTypeString, alias: Fiscal Year, length: 50 )
• PW_GIS.ssGravityMain.InspBinderSection ( type: esriFieldTypeString, alias: InspBinderSection, length: 100 )
• PW_GIS.ssGravityMain.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• PW_GIS.SewerVideoInspectionYears.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• PW_GIS.SewerVideoInspectionYears.PipeID ( type: esriFieldTypeString, alias: Pipe ID, length: 1073741822 )
• PW_GIS.SewerVideoInspectionYears.InspetionVideoYear ( type: esriFieldTypeInteger, alias: Inspection Video Year )
• PW_GIS.SewerVideoInspectionYears.Source ( type: esriFieldTypeString, alias: Source, length: 1073741822 )
• PW_GIS.SewerVideoInspectionYears.GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• PW_GIS.SewerVideoInspectionYears.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• PW_GIS.SewerVideoInspectionYears.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• PW_GIS.SewerVideoInspectionYears.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• PW_GIS.SewerVideoInspectionYears.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• SewerVideoInspectionYears (0) -- Related To: SewerVideoInspectionYears (1)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata