Parent Layer:
Sewer Network
Name: Sewer Mains
Display Field: DISTRICT
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 7 0;"><SPAN STYLE="font-weight:bold;">Projection </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> </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 /></TD><TD><P /></TD><TD><P /></TD><TD><P /></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>ObjectID*</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>ObjectID</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>Feature 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>None</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Identifies cob infrastructure district feature is located in</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><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 STYLE="margin:0 0 0 0;"><SPAN><SPAN>COB Block the parcel is associated with</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><SPAN><SPAN>COB Street feature is located on</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 STYLE="margin:0 0 0 0;"><SPAN><SPAN>Asset Type</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Defines Asset type (main/Business conection, service connection, etc.)</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>DIAMETER_M</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Wastewater Diameter</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Defines interior diameter of pipe</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>MATERIAL</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Wastewater Material Types</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Defines material pipe is constructedout of</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>HYDRAULICS</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>Wastewater Hydraulics Type</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Defines Hydraulics of pipe (Gravity,Forced, etc.)</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 STYLE="margin:0 0 0 0;"><SPAN><SPAN>AcquisitionCost</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Double</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 dollar amount cost of initial purchase of asset</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 Pipe segment was constructed on</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><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 STYLE="margin:0 0 0 0;"><SPAN><SPAN>Defines expected life in years of asset at date of install</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 value of asset if salvaged</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 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>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><SPAN><SPAN>defines COB project code for work on/construction of asset</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>Global ID</SPAN></SPAN></P></TD><TD><P><SPAN><SPAN>None</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>ArcMap Auto Generated FID </SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Abandoned</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>String</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Abandoned</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Has the Asset been abandoned</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Shape.Len</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Double</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>Length of feature expressed in meters</SPAN></SPAN></P></TD></TR></TBODY></TABLE><P STYLE="margin:0 0 11 0;"><SPAN /><SPAN /></P><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: 15000
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: 425841.3569
YMin: 5515991.723200001
XMax: 440107.81209999975
YMax: 5528443.929
Spatial Reference: 26914
(26914)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: OWNERSHIP
Field 2: HYDRAULICS
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: N/A
UniqueValueInfos:
-
Value: PRIVATE,FORCED
Label: Low Pressure Sewer
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 5
-
Value: PRIVATE,LPS
Label: Low Pressure Sewer
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 5
-
Value: PRIVATE,GRAVITY
Label: Private
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 5
-
Value: PUBLIC,FORCED
Label: Force Main
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [115, 0, 0, 255]
Width: 2
-
Value: PUBLIC,GRAVITY
Label: Public
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 5
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
)
-
DISTRICT
(
type: esriFieldTypeInteger, alias: District
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...41 more...
)
-
STREET
(
type: esriFieldTypeString, alias: Street Name, length: 25
, Coded Values:
[1: PTH 1]
, [10: PTH 10]
, [10TH ST: 10TH ST]
, ...513 more...
)
-
OWNERSHIP
(
type: esriFieldTypeString, alias: Ownership, length: 50
, Coded Values:
[PUBLIC: Public]
, [PRIVATE: Private]
)
-
ASSET_TYPE
(
type: esriFieldTypeString, alias: Asset Type, length: 5
, Coded Values:
[BC: Business Connection]
, [MAIN: Main]
, [OVER: Overflow]
, ...11 more...
)
-
DIAMETER_M
(
type: esriFieldTypeString, alias: Diameter, length: 50
, Coded Values:
[100: 100mm]
, [150: 150mm]
, [200: 200mm]
, ...23 more...
)
-
MATERIAL
(
type: esriFieldTypeString, alias: Material, length: 20
, Coded Values:
[CONC: Concrete]
, [WT: Weeping Tile]
, [PE: Polyethylene]
, ...6 more...
)
-
HYDRAULICS
(
type: esriFieldTypeString, alias: Hydraulics, length: 50
, Coded Values:
[GRAVITY: Gravity]
, [FORCED: Forced]
, [WEEPING TILE: Weeping Tile]
, ...1 more...
)
-
FacilityID
(
type: esriFieldTypeString, alias: Facility ID, length: 20
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 100
)
-
WarrantyDate
(
type: esriFieldTypeDate, alias: Warranty End Date, length: 8
)
-
AcquisitionCost
(
type: esriFieldTypeDouble, alias: Acquisition Cost
)
-
InstallDate
(
type: esriFieldTypeDate, alias: Install Date, length: 8
)
-
ExpectedLife
(
type: esriFieldTypeInteger, alias: Design Life
)
-
SalvageValue
(
type: esriFieldTypeDouble, alias: Salvage Value
)
-
AssetDisposed
(
type: esriFieldTypeString, alias: AssetDisposed, length: 5
)
-
project_code
(
type: esriFieldTypeString, alias: project_code, length: 20
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
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...
)
-
YEAR_FLUSHED
(
type: esriFieldTypeDate, alias: Year Flushed, length: 8
)
-
COMBINED
(
type: esriFieldTypeString, alias: Combined, length: 5
, Coded Values:
[YES: Yes]
, [NO: No]
)
-
BLOCK
(
type: esriFieldTypeSmallInteger, alias: Block
, Coded Values:
[0: 000]
, [100: 100]
, [200: 200]
, ...60 more...
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
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 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)
)
-
INSPECTION_YEAR
(
type: esriFieldTypeDate, alias: Inspection Year, length: 8
)
-
PipeLogix_ID
(
type: esriFieldTypeString, alias: Pipe Logix ID, length: 255
)
-
ASSET_NUMBER
(
type: esriFieldTypeInteger, alias: Asset #
)
-
omrating
(
type: esriFieldTypeDouble, alias: Operations & Maintenance Rating
)
-
strating
(
type: esriFieldTypeDouble, alias: Structural Rating
)
-
depth
(
type: esriFieldTypeDouble, alias: Pipe Depth (m)
)
-
grade
(
type: esriFieldTypeDouble, alias: Pipe Grade (%)
)
-
adjacentlanduse
(
type: esriFieldTypeSmallInteger, alias: Adjacent Land Use
, Coded Values:
[0: Unknown]
, [1: Industrial]
, [2: Parks]
, ...3 more...
)
-
classification
(
type: esriFieldTypeSmallInteger, alias: Classification
, Coded Values:
[0: Unknown]
, [1: Local]
, [2: Local Industrial]
, ...5 more...
)
-
customertype
(
type: esriFieldTypeSmallInteger, alias: Customer Type
, Coded Values:
[0: Unknown]
, [1: Residential]
, [3: Industrial / Commercial]
, ...2 more...
)
-
crossing
(
type: esriFieldTypeSmallInteger, alias: Crossing
, Coded Values:
[0: Unknown]
, [1: River Crossing]
, [2: PTH/PR Crossing]
, ...3 more...
)
-
retention
(
type: esriFieldTypeSmallInteger, alias: Distance to Retention Pod
, Coded Values:
[0: Unknown]
, [1: <25m]
, [2: >25m]
)
-
POF
(
type: esriFieldTypeDouble, alias: Probability of Failure
)
-
COF
(
type: esriFieldTypeDouble, alias: Consequence of Failure
)
-
BRE
(
type: esriFieldTypeDouble, alias: Business Risk Exposure
)
-
MSPU
(
type: esriFieldTypeDouble, alias: Maintenance Score Proactive Under-maintained
)
-
MSPO
(
type: esriFieldTypeDouble, alias: Maintenance Score Proactive Over-maintained
)
-
MSR
(
type: esriFieldTypeDouble, alias: Maintenance Score Reactive
)
-
AVERAGEENDYEAR
(
type: esriFieldTypeSmallInteger, alias: Average End Year
)
-
FASTENDYEAR
(
type: esriFieldTypeSmallInteger, alias: Fast End Year
)
-
SLOWENDYEAR
(
type: esriFieldTypeSmallInteger, alias: Slow End Year
)
-
CALCULATIONNAME
(
type: esriFieldTypeString, alias: Calculation Name, length: 255
)
-
DATECALCULATED
(
type: esriFieldTypeDate, alias: Date Calculated, length: 8
)
-
pipeshape
(
type: esriFieldTypeString, alias: Pipe Shape, length: 255
, Coded Values:
[Egg: Egg]
, [Round: Round]
)
-
remaininglife
(
type: esriFieldTypeSmallInteger, alias: Remaining Life
)
-
pof_condition
(
type: esriFieldTypeSmallInteger, alias: PoF: Condition
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...2 more...
)
-
pof_material
(
type: esriFieldTypeSmallInteger, alias: PoF: Material
, Coded Values:
[10: Unknown / Concrete / CMP]
, [8: Vitrified Clay Pipe]
, [5: Asbestos Cement]
, ...2 more...
)
-
pof_remaininglife
(
type: esriFieldTypeSmallInteger, alias: PoF: Remaining Life
, Coded Values:
[10: <=0]
, [8: 0 - 10]
, [5: 10 - 25]
, ...1 more...
)
-
pof_pipegrade
(
type: esriFieldTypeSmallInteger, alias: PoF: Pipe Grade
, Coded Values:
[10: <= 1% Grade]
, [5: >= 4% Grade]
, [1: >1% Less Than <4%]
)
-
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: Material Type
)
-
cof_econ_diameter
(
type: esriFieldTypeSmallInteger, alias: CoF: Diameter
, Coded Values:
[1: < 365mm]
, [6: 450mm to 675mm]
, [8: >675mm Round]
, ...1 more...
)
-
Shape.STLength()
(
type: esriFieldTypeDouble, alias: Shape.STLength()
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata