Name: Land Drainage Pipes & Culverts

Display Field: BLOCK

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Point feature class Providing spatial and attribute values for all City of Brandon land drainage pipes and CulvertsProjection NAD 1983 UTM 14N Data DictionaryField NameData TypeDomain NameDescriptionOBJECTID*DoubleNoneObject IDDISTRICTLongDistrictIdentifies cob infrastructure district feature is located inBLOCKStringNoneCity Block feature is located onSTREETStringOfficial_Street_NamesDefines COB block that feature is associated withOWNERSHIPStringOwnershipIdentifies jurisdiction (ownership) of assetDRAIN_TYPEStringLD_Drain_TypeIdentifies type of assetASSET_TYPEStringLD_Pipes_Asset_TypeIdentifies Type of assetMATERIALStringLD_Line_MaterialDomain field Defining Material LD pipes is constructed fromDIAMETER_MStringLD_Line_DiameterDefines diameter in mm of manholeGroundTypeStringNoneDefines Groundt type pipe is situated in/onFacilityIDStringNoneCityworks FIDLocationStringNoneStreetaddress location field for use in CityworksWarrantyDateDateNoneWarranty Start/end dateAcquisitionCostDoubleNoneDefines aqquisition cost for street segmentInstallDateDateNoneDefines date Street segment was consstructed onExpectedLifeLongNonedefines expected life of assetSalvageValueDoubleNoneDefines if Feature is wi8thin COB City limitsAssetDisposedStringNonedefines if asset has been disposed ofAbandonedStringMAIN_ABANDONEDDefines if main is abandoned or notproject_codeStringNoneDefines COB project code for work/replacementGlobalIDGlobalIDNoneUnique database autogenerated ID#Shape*GeometryNonedefines Geometry of featureShape.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: 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.11328131029E7
YMin: 6413866.907200001
XMax: -1.11125082275E7
YMax: 6431362.764399998
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNERSHIP
Field 2: DRAIN_TYPE
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: PUBLIC,PIPE
  Label: Public
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 4
• Value: PRIVATE,PIPE
  Label: Private
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 4
• Value: PUBLIC,CULVERT
  Label: Public, Culvert
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 4
• Value: PRIVATE,CULVERT
  Label: Private, Culvert
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 4
• Value: PUBLIC,CHANNEL
  Label: Public, Channel
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: PRIVATE,CHANNEL
  Label: Private, Channel
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [56, 168, 0, 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 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 25 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 10 )
• DRAIN_TYPE ( type: esriFieldTypeString, alias: DRAIN_TYPE, length: 10 )
• ASSET_TYPE ( type: esriFieldTypeString, alias: ASSET_TYPE, length: 25 )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 50 )
• DIAMETER_M ( type: esriFieldTypeString, alias: DIAMETER_M, length: 50 )
• GroundType ( type: esriFieldTypeString, alias: GroundType, length: 20 )
• 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 )
• Abandoned ( type: esriFieldTypeString, alias: Abandoned, length: 15 )
• CONSTRUCTION_TYPE ( type: esriFieldTypeString, alias: Drawing 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 )
• 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 )
• BLOCK ( type: esriFieldTypeSmallInteger, alias: BLOCK )
• DISTRICT ( type: esriFieldTypeInteger, alias: DISTRICT )
• INSPECTION_YEAR ( type: esriFieldTypeDate, alias: INSPECTION_YEAR, length: 8 )
• PipeLogix_ID ( type: esriFieldTypeString, alias: PipeLogix_ID, length: 255 )
• omrating ( type: esriFieldTypeDouble, alias: omrating )
• strating ( type: esriFieldTypeDouble, alias: strating )
• classification ( type: esriFieldTypeString, alias: classification, length: 255 )
• adjacentlanduse ( type: esriFieldTypeSmallInteger, alias: adjacentlanduse )
• customertype ( type: esriFieldTypeSmallInteger, alias: customertype )
• contaminatedsite ( type: esriFieldTypeString, alias: contaminatedsite, length: 255 )
• flooding ( type: esriFieldTypeString, alias: flooding, length: 255 )
• depth ( type: esriFieldTypeDouble, alias: depth )
• grade ( type: esriFieldTypeDouble, alias: grade )
• remaininglife ( type: esriFieldTypeSmallInteger, alias: remaininglife )
• 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