Name: Water Mains

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This feature class contains the estimated locations of the water pipes in the City of Savannah. This feature class also stored asset inventory information.

Service Item Id: 78d233ce67f941b594f9bc75cd14389f

Copyright Text: City of Savannah, Water Distribution Department, Laura Biddison

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.0176499005591068E7
YMin: 2874581.962957508
XMax: -9011181.088090044
YMax: 3800188.4929743465
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Diameter
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 0.5
  Label: 0.5
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 0.75
  Label: 0.75
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 1
  Label: 1
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 1.5
  Label: 1.5
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 2
  Label: 2
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 2.5
  Label: 2.5
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 3
  Label: 3
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 4
  Label: 4
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 6
  Label: 6
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 1
• Value: 8
  Label: 8
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
• Value: 10
  Label: 10
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 1
• Value: 12
  Label: 12
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 14
  Label: 14
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 16
  Label: 16
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 18
  Label: 18
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 20
  Label: 20
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 24
  Label: 24
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 30
  Label: 30
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 36
  Label: 36
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 42
  Label: 42
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
• Value: 48
  Label: 48
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [Diameter] CONCAT "''" CONCAT "W"
Use Coded Values: true
Symbol:
Color: [0, 92, 230, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [Diameter] CONCAT "''" CONCAT "W"
Use Coded Values: true
Symbol:
Color: [230, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [Diameter] CONCAT "''" CONCAT "W"
Use Coded Values: true
Symbol:
Color: [230, 152, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [Diameter] CONCAT "''" CONCAT "W"
Use Coded Values: true
Symbol:
Color: [76, 230, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [Diameter] CONCAT "''" CONCAT "W"
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 7
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

Feature Draw Order:

N/A

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0.5: 0.5] , [0.75: 0.75] , [1: 1] , ...18 more... )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 20 )
• ArchivedID ( type: esriFieldTypeString, alias: ArchivedID, length: 20 )
• Address ( type: esriFieldTypeString, alias: Address, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 10 , Coded Values: [A: Active] , [AB: Abandoned in Place] , [R: Removed] , ...2 more... )
• Material ( type: esriFieldTypeString, alias: Material, length: 10 , Coded Values: [DIP: Ductile Iron] , [CAS: Cast Iron] , [PE: Polyethylene] , ...8 more... )
• AsBuiltRef ( type: esriFieldTypeString, alias: AsBuiltRef, length: 255 )
• Condition ( type: esriFieldTypeDouble, alias: Condition )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 10 , Coded Values: [CITY: City of Savannah] , [PVT: Private] )
• MaintBy ( type: esriFieldTypeString, alias: MaintBy, length: 10 , Coded Values: [WD: Water Distribution] , [WS: Water Supply and Treatment] , [ID: I&D] , ...1 more... )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 255 )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation )
• InstallYear ( type: esriFieldTypeInteger, alias: InstallYear )
• ServiceType ( type: esriFieldTypeString, alias: ServiceType, length: 10 , Coded Values: [BLOW: Blow Off] , [CHEM: Chemical Injection] , [DIST: Distribution Main] , ...5 more... )
• CasingPipe ( type: esriFieldTypeString, alias: CasingPipe, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• CasingMaterial ( type: esriFieldTypeString, alias: CasingMaterial, length: 10 , Coded Values: [HDPE: High Density Polythylene (HDPE)] , [FPVC: Fusible Polyvinyl Chloride (FPVC)] , [SP: Steel] , ...2 more... )
• SourceType ( type: esriFieldTypeString, alias: SourceType, length: 10 , Coded Values: [AERIAL: Found on aerial photo] , [ASBUILT: Found on As-Built] , [400: Found on old 1:400 scale maps] , ...4 more... )
• LiningYear ( type: esriFieldTypeInteger, alias: LiningYear )
• LiningMaterial ( type: esriFieldTypeString, alias: LiningMaterial, length: 250 )
• System ( type: esriFieldTypeString, alias: System, length: 10 , Coded Values: [SM: Savannah Main] , [SQ: Savannah Quarters] , [DI: Dutch Island] , ...4 more... )
• ActualLength ( type: esriFieldTypeDouble, alias: ActualLength )
• Traceable ( type: esriFieldTypeString, alias: Traceable, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• ExternalWrap ( type: esriFieldTypeString, alias: ExternalWrap, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• ADD_ID ( type: esriFieldTypeDouble, alias: ADD_ID )
• MaintZone ( type: esriFieldTypeString, alias: MaintZone, length: 10 )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• ServiceLife ( type: esriFieldTypeSmallInteger, alias: ServiceLife )
• POF ( type: esriFieldTypeSmallInteger, alias: POF )
• COF ( type: esriFieldTypeSmallInteger, alias: COF )
• BRE ( type: esriFieldTypeSmallInteger, alias: BRE )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Relationships:

• SAV_WATER_MAIN_HYPERLINK (0) -- Related To: Water Main Record Drawings Link (7)

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

  Iteminfo   Thumbnail   Metadata