Parent Layer:
Land Drainage
Name: Land Drainage
Display Field: DISTRICT
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Point feature class Providing spatial and attribute values for all City of Brandon land drainage pipes and Culverts</SPAN></P><P STYLE="margin:0 0 7 0;"><SPAN STYLE="font-weight:bold;"><SPAN>Projection </SPAN></SPAN></P><P STYLE="margin:0 0 7 0;"><SPAN><SPAN>NAD 1983 UTM 14N </SPAN></SPAN></P><P STYLE="font-weight:bold;margin:0 0 11 0;"><SPAN /><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;"><SPAN>Data Dictionary</SPAN></SPAN></P><TABLE><TBODY><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>Field Name</SPAN></SPAN></P></TD><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>Data Type</SPAN></SPAN></P></TD><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>Domain Name</SPAN></SPAN></P></TD><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>Description</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>OBJECTID*</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Double</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Object ID</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>DISTRICT</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Long</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>District</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Identifies cob infrastructure district feature is located in</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>BLOCK</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>City Block feature is located on</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>STREET</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Official_Street_Names</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Defines COB block that feature is associated with</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>OWNERSHIP</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Ownership</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Identifies jurisdiction (ownership) of asset</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>DRAIN_TYPE</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>LD_Drain_Type</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Identifies type of asset</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>ASSET_TYPE</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>LD_Pipes_Asset_Type</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Identifies Type of asset</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>MATERIAL</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>LD_Line_Material</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Domain field Defining Material LD pipes is constructed from</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>DIAMETER_M</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>LD_Line_Diameter</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Defines diameter in mm of manhole</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>GroundType</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Defines Groundt type pipe is situated in/on</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>FacilityID</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Cityworks FID</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Location</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Streetaddress location field for use in Cityworks</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>WarrantyDate</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Date</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Warranty Start/end date</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>AcquisitionCost</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Double</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Defines aqquisition cost for street segment</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>InstallDate</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Date</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Defines date Street segment was consstructed on</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>ExpectedLife</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Long</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>defines expected life of asset</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>SalvageValue</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Double</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Defines if Feature is wi8thin COB City limits</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>AssetDisposed</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>defines if asset has been disposed of</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Abandoned</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>MAIN_ABANDONED</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Defines if main is abandoned or not</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>project_code</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Defines COB project code for work/replacement</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>GlobalID</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>GlobalID</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Unique database autogenerated ID#</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Shape*</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Geometry</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>defines Geometry of feature</SPAN></SPAN></P></TD></TR><TR><TD><P><SPAN><SPAN>Shape.len</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Double</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Length of feature expressed in meters</SPAN></SPAN></P></TD></TR></TBODY></TABLE><P><SPAN /></P></DIV></DIV></DIV>
Service Item Id: 1dce1605e23b496fbacf9127f89fee89
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: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 5000
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: 427551.7906999998
YMin: 5518193.481000001
XMax: 440639.97200000007
YMax: 5529475.9867
Spatial Reference: 26914
(26914)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: DRAIN_TYPE
Field 2: OWNERSHIP
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: N/A
UniqueValueInfos:
-
Value: PIPE,PUBLIC
Label: Public
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [56, 168, 0, 255]
Width: 5
-
Value: PIPE,PRIVATE
Label: Private
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [56, 168, 0, 255]
Width: 5
-
Value: CHANNEL,PRIVATE
Label: Channel
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
-
Value: CHANNEL,PUBLIC
Label: Channel
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
-
Value: CULVERT,PRIVATE
Label: Culvert
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [230, 152, 0, 255]
Width: 1
-
Value: CULVERT,PUBLIC
Label: Culvert
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [230, 152, 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: Object ID
)
-
STREET
(
type: esriFieldTypeString, alias: Street Names, length: 25
, Coded Values:
[1: PTH 1]
, [10: PTH 10]
, [10TH ST: 10TH ST]
, ...513 more...
)
-
OWNERSHIP
(
type: esriFieldTypeString, alias: Ownership, length: 10
, Coded Values:
[PUBLIC: Public]
, [PRIVATE: Private]
)
-
DRAIN_TYPE
(
type: esriFieldTypeString, alias: Drain Type, length: 10
, Coded Values:
[CHANNEL: Channel]
, [CULVERT: Culvert]
, [PIPE: Pipe]
)
-
ASSET_TYPE
(
type: esriFieldTypeString, alias: Asset Type, length: 25
, Coded Values:
[BC: Business Connection]
, [MAIN: Main]
, [OVER: Overflow]
, ...11 more...
)
-
MATERIAL
(
type: esriFieldTypeString, alias: Material, length: 50
, Coded Values:
[CMP: Corrugated Metal Pipe]
, [CONC: Concrete]
, [WT: Weeping Tile]
, ...5 more...
)
-
DIAMETER_M
(
type: esriFieldTypeString, alias: Diameter, length: 50
, Coded Values:
[0: Unknown]
, [100: 100mm]
, [1000: 1000mm]
, ...37 more...
)
-
GroundType
(
type: esriFieldTypeString, alias: Ground Type, length: 20
)
-
FacilityID
(
type: esriFieldTypeString, alias: Facility ID, length: 20
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 100
)
-
WarrantyDate
(
type: esriFieldTypeDate, alias: Warranty Start Date, length: 8
)
-
AcquisitionCost
(
type: esriFieldTypeDouble, alias: Acquisition Cost ($)
)
-
InstallDate
(
type: esriFieldTypeDate, alias: Install Year, length: 8
)
-
ExpectedLife
(
type: esriFieldTypeInteger, alias: Design Life (yrs)
)
-
SalvageValue
(
type: esriFieldTypeDouble, alias: Salvage Value ($)
)
-
AssetDisposed
(
type: esriFieldTypeString, alias: Asset Disposed?, length: 5
)
-
project_code
(
type: esriFieldTypeString, alias: Project Code, length: 20
)
-
Abandoned
(
type: esriFieldTypeString, alias: Lifecycle Status, length: 15
, Coded Values:
[ABANDONED: Abandoned]
, [REMOVED: Removed]
, [NO: No]
, ...1 more...
)
-
CONSTRUCTION_TYPE
(
type: esriFieldTypeString, alias: Drawing Type, length: 50
, Coded Values:
[AS-BUILT: As-Built]
, [PRELIMINARY: Preliminary]
, [CONSTRUCTION: Construction]
, ...4 more...
)
-
created_by
(
type: esriFieldTypeString, alias: Created by, length: 255
)
-
created_on
(
type: esriFieldTypeDate, alias: Created on, length: 8
)
-
edited_by
(
type: esriFieldTypeString, alias: Last edited by, length: 255
)
-
edited_on
(
type: esriFieldTypeDate, alias: Last edited on, length: 8
)
-
SHAPE
(
type: esriFieldTypeGeometry, alias: Shape
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
UP_STREAM_MH
(
type: esriFieldTypeString, alias: Up Stream FID, length: 20
)
-
UP_STREAM_INVERT
(
type: esriFieldTypeDouble, alias: Up Stream Invert (m)
)
-
UP_STREAM_RIM
(
type: esriFieldTypeDouble, alias: Up Stream Rim (m)
)
-
DOWN_STREAM_MH
(
type: esriFieldTypeString, alias: Down Stream FID, length: 20
)
-
DOWN_STREAM_INVERT
(
type: esriFieldTypeDouble, alias: Down Stream Invert (m)
)
-
DOWN_STREAM_RIM
(
type: esriFieldTypeDouble, alias: Down Stream Rim (m)
)
-
BLOCK
(
type: esriFieldTypeSmallInteger, alias: Block #
, Coded Values:
[0: 000]
, [100: 100]
, [200: 200]
, ...60 more...
)
-
DISTRICT
(
type: esriFieldTypeInteger, alias: District #
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...41 more...
)
-
INSPECTION_YEAR
(
type: esriFieldTypeDate, alias: Inspection Year, length: 8
)
-
PipeLogix_ID
(
type: esriFieldTypeString, alias: PipeLogix ID, length: 255
)
-
omrating
(
type: esriFieldTypeDouble, alias: Operations & Maintenance Rating
)
-
strating
(
type: esriFieldTypeDouble, alias: Structural Rating
)
-
classification
(
type: esriFieldTypeString, alias: Classification, length: 255
, Coded Values:
[ARTERIAL: Arterial]
, [COLLECTOR: Collector]
, [LOCAL: Local]
, ...6 more...
)
-
adjacentlanduse
(
type: esriFieldTypeSmallInteger, alias: Adjacent Land Use
, Coded Values:
[0: Unknown]
, [1: Industrial]
, [2: Parks]
, ...3 more...
)
-
customertype
(
type: esriFieldTypeSmallInteger, alias: Customer Type
, Coded Values:
[0: Unknown]
, [1: Residential]
, [3: Industrial / Commercial]
, ...2 more...
)
-
contaminatedsite
(
type: esriFieldTypeString, alias: Contaminated Site, length: 255
, Coded Values:
[TRUE: True]
, [FALSE: False]
)
-
flooding
(
type: esriFieldTypeString, alias: Flooding, length: 255
, Coded Values:
[TRUE: True]
, [FALSE: False]
)
-
depth
(
type: esriFieldTypeDouble, alias: Pipe Depth (m)
)
-
grade
(
type: esriFieldTypeDouble, alias: Pipe Grade (%)
)
-
remaininglife
(
type: esriFieldTypeSmallInteger, alias: Remaining Life
)
-
SHAPE.STLength()
(
type: esriFieldTypeDouble, alias: SHAPE.STLength()
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata