Name: Watermain

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Attribute Field Notes: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryLineOBJECTIDIntegerCurrent asset IDWaterIDDoubleStreetNameStringDiameterDoublePipeLengthDoubleManually entered pipe length. This is the length of record although the accuracy cannot be guaranteed, particularly with older recordsMaterialStringPipe material. It's preferred that this data be enterred with material and dimension ratio or other qualifying information e.g. 'PVC DR-18' or 'CPP AWWA 303' but this information is not always availableInstallatiStringInstall date currently entered in format of YYYYMMDD. Many estimates entered as YYYY0101. Dates currently entered should represent the project or repair completion date as defined by Environmental Services. This data should have a high degree of completness for newer data with older data requiring verification.ReliningMaStringReliningDaStringFromValveIntegerToValveIntegerRoadNameFuStringFromStreetStringToStreetStringCommentStringShape_LengDoubleImprovNoStringFrom previous asset management plan?ImprovDescStringFrom previous asset management plan?ReplNoStringFrom previous asset management plan?ReplDescStringFrom previous asset management plan?ConditionSingleFrom previous asset management plan?OWNERSHIPStringShould be irrelevant as all features should be city-ownedAddToVadimStringFrom previous asset management plan?YearInspecIntegerFrom previous asset management plan?SizeClassStringFrom previous asset management plan?DuplicateSmallIntegerSHAPE_LengthDouble

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

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 304578.6364000002
YMin: 4890248.262499999
XMax: 313383.23330000043
YMax: 4898837.8006
Spatial Reference: 26918  (26918)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 109, 212, 255]
Width: 2
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 255, 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: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2000.0
Max. Scale: 0.0

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: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OBJECTID_1 ( type: esriFieldTypeOID, alias: System ID )
• OBJECTID ( type: esriFieldTypeInteger, alias: Water Main ID )
• WaterID ( type: esriFieldTypeDouble, alias: WaterID (Obsolete) )
• StreetName ( type: esriFieldTypeString, alias: Street Name, length: 200 , Coded Values: [ABBOTT ST: ABBOTT ST] , [ADAM ST: ADAM ST] , [ADRIAN ST: ADRIAN ST] , ...603 more... )
• Diameter ( type: esriFieldTypeDouble, alias: Pipe Diameter , Coded Values: [20: 20mm] , [25: 25mm] , [32: 32mm] , ...15 more... )
• PipeLength ( type: esriFieldTypeDouble, alias: Pipe Length )
• Material ( type: esriFieldTypeString, alias: Pipe Material, length: 14 , Coded Values: [PVC: PVC] , [CI: CI - Cast Iron] , [DI: DI - Ductile Iron] , ...10 more... )
• Installati ( type: esriFieldTypeString, alias: Installation Date, length: 50 )
• ReliningMa ( type: esriFieldTypeString, alias: Relining Material, length: 17 , Coded Values: [CEMENT MORTAR: Cement Mortar] , [CEMENT ASBESTOS: Cement Asbestos] , [: ] )
• ReliningDa ( type: esriFieldTypeString, alias: Relining Date, length: 50 )
• FromValve ( type: esriFieldTypeInteger, alias: From Valve )
• ToValve ( type: esriFieldTypeInteger, alias: To Valve )
• RoadNameFu ( type: esriFieldTypeString, alias: Street Name (Full), length: 100 )
• FromStreet ( type: esriFieldTypeString, alias: From Street, length: 254 )
• ToStreet ( type: esriFieldTypeString, alias: To Street, length: 254 )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 254 )
• Shape_Leng ( type: esriFieldTypeDouble, alias: Shape_Leng (Obsolete) )
• ImprovNo ( type: esriFieldTypeString, alias: Improvement Number, length: 254 )
• ImprovDesc ( type: esriFieldTypeString, alias: Improvement Description, length: 254 )
• ReplNo ( type: esriFieldTypeString, alias: Replacement Number, length: 254 )
• ReplDesc ( type: esriFieldTypeString, alias: Replacement Description, length: 254 )
• Condition ( type: esriFieldTypeDouble, alias: Asset Condition )
• Ownership ( type: esriFieldTypeString, alias: Ownership, length: 254 )
• AddToVadim ( type: esriFieldTypeString, alias: Add To Vadim, length: 254 )
• YearInspec ( type: esriFieldTypeInteger, alias: Year Inspected )
• SizeClass ( type: esriFieldTypeString, alias: Size Class, length: 254 )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate (obsolete) )
• Shape ( type: esriFieldTypeGeometry, alias: Shape Geometry )
• Segment_ID ( type: esriFieldTypeInteger, alias: Segment_ID )
• AM_ID ( type: esriFieldTypeString, alias: AM_ID, length: 20 )
• CRID ( type: esriFieldTypeString, alias: CRID, length: 20 )
• Project_Title ( type: esriFieldTypeString, alias: Project_Title, length: 200 )
• Responsible_Department ( type: esriFieldTypeString, alias: Responsible_Department, length: 100 )
• Service_Area ( type: esriFieldTypeString, alias: Service_Area, length: 50 )
• Project_Type ( type: esriFieldTypeString, alias: Project_Type, length: 50 )
• Project_Description ( type: esriFieldTypeString, alias: Project_Description, length: 250 )
• Project_Cost_2024 ( type: esriFieldTypeDouble, alias: Project_Cost_2024 )
• Project_Budget_Year ( type: esriFieldTypeString, alias: Project_Budget_Year, length: 20 )
• Project_Timing ( type: esriFieldTypeString, alias: Project_Timing, length: 20 )
• Risk_Score ( type: esriFieldTypeSmallInteger, alias: Risk_Score )
• Current_PoF ( type: esriFieldTypeSmallInteger, alias: Current_PoF )
• CoF ( type: esriFieldTypeSmallInteger, alias: CoF )
• Current_Replacement_Value ( type: esriFieldTypeDouble, alias: Current_Replacement_Value )
• Asset_Risk_Score ( type: esriFieldTypeSmallInteger, alias: Asset_Risk_Score )

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

  Iteminfo   Thumbnail   Metadata