Name: Domestic Sewer Pipes (No Flow Direction)

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

MaxRecordCount: 500

Supported Query Formats: JSON, geoJSON

Min Scale: 25000

Max Scale: 5001

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

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: Abandoned
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: PUBLIC,
  Label: Public
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: PRIVATE,
  Label: Private
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [255, 0, 0, 255]
  Width: 1
• Value: PUBLIC,Abandoned
  Label: Public, Abandoned
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [130, 130, 130, 255]
  Width: 1
• Value: PRIVATE,Abandoned
  Label: Private, Abandoned
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [130, 130, 130, 255]
  Width: 1
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
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