Name: Domestic Sewer Pipes (Material Type)

Display Field: BLOCK

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: polyline featureclass showing the spatial location and attribute vlaues for all of the wastewater sewer lines in the City of Brandon.Projection NAD 1983 UTM 14N Data DictionaryField NameData TypeDomain NameDescriptionObjectID*ObjectIDNoneFeature IDDISTRICTLongNoneIdentifies cob infrastructure district feature is located inBLOCKStringNoneCOB Block the parcel is associated withSTREETStringOfficial Street NamesCOB Street feature is located onASSET_TYPEStringAsset TypeDefines Asset type (main/Business conection, service connection, etc.)DIAMETER_MStringWastewater DiameterDefines interior diameter of pipeMATERIALStringWastewater Material TypesDefines material pipe is constructedout ofHYDRAULICSStringWastewater Hydraulics TypeDefines Hydraulics of pipe (Gravity,Forced, etc.)FacilityIDStringNoneCityworks FIDLocationStringNoneStreetaddress location field for use in CityworksWarrantyDateDateNoneWarranty Start/end dateAcquisitionCostDoubleNoneDefines dollar amount cost of initial purchase of assetInstallDateDateNoneDefines date Pipe segment was constructed onExpectedLifeLongNoneDefines expected life in years of asset at date of installSalvageValueDoubleNoneDefines value of asset if salvagedAssetDisposedStringNonedefines if asset has been disposed ofShape*GeometryNonedefines Geometry of featureproject_codeStringNonedefines COB project code for work on/construction of assetGlobalIDGlobal 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: 5000

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.11326920364E7
YMin: 6413875.305399999
XMax: -1.11133630629E7
YMax: 6429762.575300001
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,ABS
  Label: PUBLIC, ABS
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: PUBLIC,AC
  Label: PUBLIC, AC
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [223, 115, 255, 255]
  Width: 1
• Value: PUBLIC,CLAY
  Label: PUBLIC, CLAY
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [115, 76, 0, 255]
  Width: 1
• Value: PUBLIC,CONC
  Label: PUBLIC, CONC
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [104, 104, 104, 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
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [MATERIAL]
Use Coded Values: false
Symbol:
Color: [255, 0, 0, 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 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 25 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 50 )
• ASSET_TYPE ( type: esriFieldTypeString, alias: ASSET_TYPE, length: 5 )
• DIAMETER_M ( type: esriFieldTypeString, alias: DIAMETER_M, length: 50 )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 20 )
• HYDRAULICS ( type: esriFieldTypeString, alias: HYDRAULICS, 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 )
• project_code ( type: esriFieldTypeString, alias: project_code, length: 20 )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, length: 2048 )
• Abandoned ( type: esriFieldTypeString, alias: Abandoned, length: 15 )
• CONSTRUCTION_TYPE ( type: esriFieldTypeString, alias: Construction Type, length: 50 )
• YEAR_FLUSHED ( type: esriFieldTypeDate, alias: Year Flushed, length: 8 )
• COMBINED ( type: esriFieldTypeString, alias: COMBINED, length: 5 )
• BLOCK ( type: esriFieldTypeSmallInteger, alias: BLOCK )
• created_by ( type: esriFieldTypeString, alias: created_by, length: 50 )
• created_on ( type: esriFieldTypeDate, alias: created_on, length: 8 )
• edited_by ( type: esriFieldTypeString, alias: edited_by, length: 50 )
• edited_on ( type: esriFieldTypeDate, alias: edited_on, length: 8 )
• UP_STREAM_MH ( type: esriFieldTypeString, alias: UP_STREAM_MH, length: 20 )
• UP_STREAM_INVERT ( type: esriFieldTypeDouble, alias: UP_STREAM_INVERT )
• UP_STREAM_RIM ( type: esriFieldTypeDouble, alias: UP_STREAM_RIM )
• DOWN_STREAM_MH ( type: esriFieldTypeString, alias: DOWN_STREAM_MH, length: 20 )
• DOWN_STREAM_INVERT ( type: esriFieldTypeDouble, alias: DOWN_STREAM_INVERT )
• DOWN_STREAM_RIM ( type: esriFieldTypeDouble, alias: DOWN_STREAM_RIM )
• INSPECTION_YEAR ( type: esriFieldTypeDate, alias: INSPECTION_YEAR, length: 8 )
• PipeLogix_ID ( type: esriFieldTypeString, alias: PipeLogix_ID, length: 255 )
• ASSET_NUMBER ( type: esriFieldTypeInteger, alias: ASSET_NUMBER )
• omrating ( type: esriFieldTypeDouble, alias: omrating )
• strating ( type: esriFieldTypeDouble, alias: strating )
• depth ( type: esriFieldTypeDouble, alias: depth )
• grade ( type: esriFieldTypeDouble, alias: grade )
• adjacentlanduse ( type: esriFieldTypeSmallInteger, alias: adjacentlanduse )
• classification ( type: esriFieldTypeSmallInteger, alias: classification )
• customertype ( type: esriFieldTypeSmallInteger, alias: customertype )
• crossing ( type: esriFieldTypeSmallInteger, alias: crossing )
• retention ( type: esriFieldTypeSmallInteger, alias: retention )
• POF ( type: esriFieldTypeDouble, alias: POF )
• COF ( type: esriFieldTypeDouble, alias: COF )
• BRE ( type: esriFieldTypeDouble, alias: BRE )
• MSPU ( type: esriFieldTypeDouble, alias: MSPU )
• MSPO ( type: esriFieldTypeDouble, alias: MSPO )
• MSR ( type: esriFieldTypeDouble, alias: MSR )
• AVERAGEENDYEAR ( type: esriFieldTypeSmallInteger, alias: AVERAGEENDYEAR )
• FASTENDYEAR ( type: esriFieldTypeSmallInteger, alias: FASTENDYEAR )
• SLOWENDYEAR ( type: esriFieldTypeSmallInteger, alias: SLOWENDYEAR )
• CALCULATIONNAME ( type: esriFieldTypeString, alias: CALCULATIONNAME, length: 255 )
• DATECALCULATED ( type: esriFieldTypeDate, alias: DATECALCULATED, length: 8 )
• pipeshape ( type: esriFieldTypeString, alias: pipeshape, length: 255 )
• remaininglife ( type: esriFieldTypeSmallInteger, alias: remaininglife )
• pof_condition ( type: esriFieldTypeSmallInteger, alias: pof_condition )
• pof_material ( type: esriFieldTypeSmallInteger, alias: pof_material )
• pof_remaininglife ( type: esriFieldTypeSmallInteger, alias: pof_remaininglife )
• pof_pipegrade ( type: esriFieldTypeSmallInteger, alias: pof_pipegrade )
• cof_economic ( type: esriFieldTypeSmallInteger, alias: cof_economic )
• cof_operational ( type: esriFieldTypeSmallInteger, alias: cof_operational )
• cof_social ( type: esriFieldTypeSmallInteger, alias: cof_social )
• cof_environmental ( type: esriFieldTypeSmallInteger, alias: cof_environmental )
• cof_econ_materialtype ( type: esriFieldTypeSmallInteger, alias: cof_econ_materialtype )
• cof_econ_diameter ( type: esriFieldTypeSmallInteger, alias: cof_econ_diameter )
• 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