Name: Abandoned Water Main

Display Field: LEGACYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: b4e612f210de4cb2a63462bd626a6080

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 36113

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: 1369763.6987875998
YMin: 492637.2997380644
XMax: 1402228.209281832
YMax: 526756.2025538385
Spatial Reference: 102723  (3735)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 3
Label:
Description:
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LEGACYID ( type: esriFieldTypeString, alias: CityWorks LegacyID, length: 20 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, length: 8 )
• ASSETID ( type: esriFieldTypeString, alias: CityWorks AssetID, length: 20 )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, length: 50 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, length: 50 )
• PIPETYPE ( type: esriFieldTypeString, alias: Pipe Type, length: 3 , Coded Values: [M: Water Main] , [S: Water Service] , [T: Transmission] , ...2 more... )
• REASON ( type: esriFieldTypeString, alias: REASON, length: 3 , Coded Values: [RM: Removed] , [RE: Replaced] , [RL: Relocated] , ...2 more... )
• RETIREDDATE ( type: esriFieldTypeDate, alias: RETIREDDATE, length: 8 )
• WADIA ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [2: 2"] , [3: 3"] , [6: 6"] , ...11 more... )
• WAMATL ( type: esriFieldTypeString, alias: Material, length: 4 , Coded Values: [PE: Polyethylene] , [CI: Cast Iron] , [CO: Concrete] , ...9 more... )
• REMOVEDIND ( type: esriFieldTypeString, alias: Removed Indicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• BEDDING_TYPE ( type: esriFieldTypeString, alias: Bedding, length: 15 , Coded Values: [NATIVE: Native Soil] , [703 Modified: Modified Sand] , [SAND: Sand] )
• WRAPPED ( type: esriFieldTypeString, alias: Wrapped, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• LINED ( type: esriFieldTypeString, alias: Lined, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 30 )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 100 )
• PRESSUREZONE ( type: esriFieldTypeString, alias: Pressure Zone, length: 10 , Coded Values: [D: 817 System] , [T: 817 Transmission] , [G: 875 System] , ...10 more... )
• SERVICE_STATUS ( type: esriFieldTypeString, alias: Service Status, length: 15 , Coded Values: [A: Active] , [I: Inactive] )
• FIELDMEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Field Measured Length )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, length: 15 )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• CONDITIONCODE ( type: esriFieldTypeString, alias: Condition Code, length: 1 , Coded Values: [G: Good] , [A: Average] , [P: Poor] )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: Location Description, length: 64 )
• LOCATIONCONFIDENCELEVEL ( type: esriFieldTypeString, alias: Location Confidence Level, length: 1 , Coded Values: [H: High] , [M: Medium] , [L: Low] )
• CATHODICPROTECTIONIND ( type: esriFieldTypeString, alias: Cathodic Protection Inicator, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• BURIEDDEPTHINCHES ( type: esriFieldTypeInteger, alias: Buried Depth - Inches )
• OWNER ( type: esriFieldTypeString, alias: Owner, length: 15 , Coded Values: [CITY: City of Hamilton] , [OTH: Other] )
• WATERTRACEWEIGHT ( type: esriFieldTypeDouble, alias: Water Trace Weight )
• DRAWING_REF ( type: esriFieldTypeString, alias: Drawing Reference, length: 10 )
• DRAWING_ID_REF_ID ( type: esriFieldTypeString, alias: Drawing_ID_Ref_ID, length: 50 )
• SUBDIVISIONDRAWINGS ( type: esriFieldTypeString, alias: Subdivision Drawings, length: 75 )
• INSTALLER ( type: esriFieldTypeString, alias: Installer, length: 32 , Coded Values: [CITY: City of Hamilton] , [CONT: Contractor] , [HO: Home Owner] , ...2 more... )
• MAPID ( type: esriFieldTypeString, alias: Map ID, length: 10 )
• REHABDATE ( type: esriFieldTypeDate, alias: Rehabilitation Date, length: 8 )
• FIREFLOWPROBLEM ( type: esriFieldTypeString, alias: Problematic Fire Flow, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• BREAKCOUNT ( type: esriFieldTypeSmallInteger, alias: Break Count )
• PIPECLASS ( type: esriFieldTypeString, alias: Pipe Class, length: 3 , Coded Values: [A: Most Critical] , [B: Moderately Critical] , [C: Least Critical] )
• PIPECLASSCONDITION ( type: esriFieldTypeSmallInteger, alias: Pipe Class Condition )
• BREAKCOUNTCONDITION ( type: esriFieldTypeSmallInteger, alias: Break Count Condition )
• CRITICALITY ( type: esriFieldTypeSmallInteger, alias: Criticality )
• RISK ( type: esriFieldTypeSmallInteger, alias: Risk Factor )
• REPLACEMENTYEAR ( type: esriFieldTypeDate, alias: Estimated Replacement Year, length: 8 )
• CRITICALTYREASON ( type: esriFieldTypeString, alias: Criticality Reason, length: 50 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• 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 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata