Name: Traffic Light Cable - Downtown - Municipal Works
Display Field: WORKORDERID
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: This is all equipment that is behind the meter downtown and owned by Municipal Works but we track and locate on their behalf.Originally was like normal Municipal Works Street and Traffic Lighting. In 2016 it was decided to put them behind a meter. Generally anything behind a meter is not Electric's responsibiility, but a deal was made that we would maintain the records and do the locates for these features.
Copyright Text: City of Medicine Hat - UDS - Electric
Picture is a screen shot from ArcMap 2019/12/04
Default Visibility: true
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON
Min Scale: 2500.0
Max Scale: 0.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: 22858.8947000001
YMin: 5544582.463
XMax: 23468.5207000002
YMax: 5544958.0816
Spatial Reference: 3779
(3779)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSLSSolid
Color: [0, 43, 150, 255]
Width: 1
Label:
Description:
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
)
-
WORKORDERID
(
type: esriFieldTypeString, alias: WORKORDERID, length: 20
)
-
INSTALLATIONDATE
(
type: esriFieldTypeDate, alias: INSTALLATIONDATE, length: 8
)
-
FIELDVERIFY
(
type: esriFieldTypeString, alias: FieldVerify, length: 5
, Coded Values:
[0: No]
, [1: Yes]
)
-
COMMENTS
(
type: esriFieldTypeString, alias: COMMENTS, length: 100
)
-
CREATIONUSER
(
type: esriFieldTypeString, alias: CREATIONUSER, length: 20
)
-
DATECREATED
(
type: esriFieldTypeDate, alias: DATECREATED, length: 8
)
-
LASTUSER
(
type: esriFieldTypeString, alias: LastEditUser, length: 20
)
-
DATEMODIFIED
(
type: esriFieldTypeDate, alias: LastEditDate, length: 8
)
-
WORKREQUESTID
(
type: esriFieldTypeString, alias: Designer:WorkRequestID, length: 20
)
-
DESIGNID
(
type: esriFieldTypeString, alias: Designer:DesignID, length: 20
)
-
WORKLOCATIONID
(
type: esriFieldTypeString, alias: Designer:WorkLocationID, length: 20
)
-
WMSID
(
type: esriFieldTypeString, alias: Designer:WorkOrderManagementSystemID, length: 50
)
-
WORKFLOWSTATUS
(
type: esriFieldTypeInteger, alias: Designer:WorkFlowStatus
, Coded Values:
[0: None]
, [1: In Design]
, [2: Pending Approval]
, ...4 more...
)
-
WORKFUNCTION
(
type: esriFieldTypeInteger, alias: Designer:WorkFunction
, Coded Values:
[0: None]
, [1: Install]
, [2: Remove]
, ...6 more...
)
-
FEEDERID
(
type: esriFieldTypeString, alias: FeederID, length: 25
)
-
LENGTHSOURCE
(
type: esriFieldTypeString, alias: LengthSource, length: 5
, Coded Values:
[FM: Field Measurement]
, [MS: Mapping System]
)
-
MEASUREDLENGTH
(
type: esriFieldTypeDouble, alias: MEASUREDLENGTH
, Range: [1, 1000000000]
)
-
LENGTHUOMCODE
(
type: esriFieldTypeString, alias: LengthUnitofMeasure, length: 5
, Coded Values:
[FT: Feet]
, [EA: Each]
, [M: Meter]
, ...2 more...
)
-
USECODE
(
type: esriFieldTypeString, alias: USECODE, length: 5
)
-
WIRECOUNT
(
type: esriFieldTypeInteger, alias: WIRECOUNT
)
-
GISONUMBER
(
type: esriFieldTypeInteger, alias: GISONUMBER
)
-
GISOTYPENBR
(
type: esriFieldTypeInteger, alias: GISOTypeNumber
)
-
SUBTYPECD
(
type: esriFieldTypeInteger, alias: SubtypeCode
)
-
LABELTEXT
(
type: esriFieldTypeString, alias: LABELTEXT, length: 255
)
-
OWNERSHIP
(
type: esriFieldTypeString, alias: FeatureOwnedBy, length: 20
)
-
COMPATIBLEUNITID
(
type: esriFieldTypeString, alias: Conductor Size, length: 5
, Coded Values:
[230: Cable/Wire #6 CU CN 600V]
, [231: Cable/Wire 2/0 CU CN 600V]
, [373: Cable/Wire #10 CU]
, ...60 more...
)
-
OPERATINGVOLTAGE
(
type: esriFieldTypeInteger, alias: OperatingVoltage
, Coded Values:
[10: 120V]
, [20: 120/208V]
, [22: 120/240V]
, ...27 more...
)
-
PHASEDESIGNATION
(
type: esriFieldTypeInteger, alias: PhaseDesignation
, Coded Values:
[4: R]
, [2: Y]
, [1: B]
, ...5 more...
)
-
FDRMGRNONTRACEABLE
(
type: esriFieldTypeInteger, alias: FdrMgrNonTraceable
, Coded Values:
[0: Traceable]
, [1: Non-Traceable]
)
-
ENABLED
(
type: esriFieldTypeSmallInteger, alias: Enabled
, Coded Values:
[0: False]
, [1: True]
)
-
FEATURE_STATUS
(
type: esriFieldTypeString, alias: FEATURE_STATUS, length: 10
, Coded Values:
[Existing: Existing Feature]
, [New: New Feature]
, [Proposed: Proposed Feature]
, ...2 more...
)
-
STREETLIGHT_FACILITY
(
type: esriFieldTypeString, alias: STREETLIGHT_FACILITY, length: 50
, Coded Values:
[STLT-REN: Streetlights-rental lights]
, [LT-OTHER: Lights - Other]
, [STLT-MED: Streetlights-in Medicine Hat (529760)]
, ...8 more...
)
-
REPLACED_DATE_MM_DD_YYYY
(
type: esriFieldTypeString, alias: REPLACED_DATE_MM_DD_YYYY, length: 50
)
-
CONTROL_CABLE
(
type: esriFieldTypeString, alias: Control Cable, length: 50
, Coded Values:
[0: No]
, [1: Yes]
)
-
FEEDERINFO
(
type: esriFieldTypeInteger, alias: FeederManagerInfo
)
-
ELECTRICTRACEWEIGHT
(
type: esriFieldTypeInteger, alias: MMElectricTraceWeight
)
-
FEEDERID2
(
type: esriFieldTypeString, alias: SecondaryFeederID, length: 50
)
-
ASSETID
(
type: esriFieldTypeString, alias: AssetID, length: 50
)
-
FEATURESTATUS
(
type: esriFieldTypeString, alias: Feature Status, length: 10
, Coded Values:
[E: Existing]
, [A: Abasnonded In Place]
, [R: Removed from Field]
)
-
SHAPE
(
type: esriFieldTypeGeometry, alias: SHAPE
)
-
SHAPE.LEN
(
type: esriFieldTypeDouble, alias: SHAPE.LEN
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata