Name: Water Mains (Material Type)

Display Field: BLOCK

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Polyline featureclass depicting the spatial location and attribute values of Watermains within the City of Brandon.Projection NAD 1983 UTM 14N Data DictionaryField NameData TypeDomain NameDescriptionObjectID*ObjectIDNoneFeature IDDISTRICTLongNoneIdentifies cob infrastructure district feature is located inBLK_NUMStringNoneCOB BLOCK# watermain is associated withSTREETStringNoneCOB Street feature is located onOWNERSHIPStringOwnershipDefines owner of asset (Public/Private)ASSET_TYPEStringAsset TypeDefines asset type (Main,Service Connection/Business connection)JOINT_TYPEStringNoneDefines Joint(connector) type of the asset. DIAMETER_MStringWater Main DiameterDefines Diasmeter of water main pipeMATERIALStringWater Main Material TypesDefines material assiet is made fromFacilityIDStringNoneCityworks FIDLocationStringNoneStreetaddress location field for use in CityworksWarrantyDateDateNoneWarranty Start/end date for featureAcquisitionCostDoubleNoneDefines Acquisition cost of featureInstallDateDateNoneDefines date asset was installedExpectedLifeLongNoneDefines asset lifespan expectancySalvageValueDoubleNoneDefines predicted salvage value of featureAssetDisposedStringNoneHas the asset been disposed of/Salvaged?Ground_TypeStringNoneDefines the ground typwe the asset was installed inproject_codeStringNoneDefines project code Asset was installed underShape*GeometryNonedefines Geometry of featureGlobalIDGlobal IDNoneArcMap Auto Generated FID AbandonedStringAbandonedHas the Asset been abandonedShape.lenDoubleNoneLength of feature expressed in meters

Service Item Id: a185cd5f2ced422a89639ff79987f062

Copyright Text: Author: Date Created (DD/MM/YYYY): Development Services Division Department of Engineering AR McDiarmid Civic Complex 638 Princess Ave. Brandon, MB R7A OP3 Phone 204.729.2142 Fax 204.725.3235

Default Visibility: false

MaxRecordCount: 500

Supported Query Formats: JSON, geoJSON

Min Scale: 25000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.11326729851E7
YMin: 6413481.640100002
XMax: -1.11153072075E7
YMax: 6429775.155199997
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNERSHIP
Field 2: MATERIAL
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: PUBLIC,AC
  Label: PUBLIC, AC
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [223, 115, 255, 255]
  Width: 1
• Value: PUBLIC,CIBS
  Label: PUBLIC, CI
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [115, 76, 0, 255]
  Width: 1
• Value: PUBLIC,CIBT
  Label: PUBLIC, CI
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [115, 76, 0, 255]
  Width: 1
• Value: PUBLIC,CI
  Label: PUBLIC, CI
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [115, 76, 0, 255]
  Width: 1
• Value: PUBLIC,CIUI
  Label: PUBLIC, CI
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [115, 76, 0, 255]
  Width: 1
• Value: PUBLIC,CU
  Label: PUBLIC, CU
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: PUBLIC,DI
  Label: PUBLIC, DI
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 1
• Value: PUBLIC,PE
  Label: PUBLIC, PE
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: PUBLIC,PVC
  Label: PUBLIC, PVC
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 255, 255]
  Width: 1
• Value: PUBLIC,PVCS
  Label: PUBLIC, PVCS
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 1
• Value: PUBLIC,STL
  Label: PUBLIC, STL
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 1
• Value: PUBLIC,UNKNOWN
  Label: PUBLIC, UNKNOWN
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [0, 0, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [MATERIAL]
Use Coded Values: false
Symbol:
Color: [0, 112, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Segoe UI
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 4000.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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• DISTRICT ( type: esriFieldTypeInteger, alias: DISTRICT )
• BLOCK ( type: esriFieldTypeString, alias: BLOCK, length: 10 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 25 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 50 )
• ASSET_TYPE ( type: esriFieldTypeString, alias: ASSET_TYPE, length: 10 )
• JOINT_TYPE ( type: esriFieldTypeString, alias: JOINT_TYPE, length: 10 )
• DIAMETER_M ( type: esriFieldTypeString, alias: DIAMETER_M, length: 50 )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 50 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• AcquisitionCost ( type: esriFieldTypeDouble, alias: AcquisitionCost )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• ExpectedLife ( type: esriFieldTypeInteger, alias: ExpectedLife )
• SalvageValue ( type: esriFieldTypeDouble, alias: SalvageValue )
• AssetDisposed ( type: esriFieldTypeString, alias: AssetDisposed, length: 5 )
• Ground_Type ( type: esriFieldTypeString, alias: Ground_Type, length: 20 )
• project_code ( type: esriFieldTypeString, alias: project_code, length: 20 )
• Abandoned ( type: esriFieldTypeString, alias: Abandoned, length: 15 )
• CONSTRUCTION_TYPE ( type: esriFieldTypeString, alias: Construction Type, length: 50 )
• created_by ( type: esriFieldTypeString, alias: created_by, length: 255 )
• created_on ( type: esriFieldTypeDate, alias: created_on, length: 8 )
• edited_by ( type: esriFieldTypeString, alias: edited_by, length: 255 )
• edited_on ( type: esriFieldTypeDate, alias: edited_on, length: 8 )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, length: 2048 )
• LEAD_SERVICES ( type: esriFieldTypeSmallInteger, alias: LEAD_SERVICES )
• BREAKS ( type: esriFieldTypeSmallInteger, alias: BREAKS )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: INSPECTION_DATE, length: 8 )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• AREA ( type: esriFieldTypeDouble, alias: AREA )
• SHAPE_Length ( type: esriFieldTypeDouble, alias: SHAPE_Length )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata