View In:   ArcGIS Online Map Viewer

Name: Traffic Controller

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 15725.6232000003
YMin: 5537108.8992
XMax: 31085.1036
YMax: 5549675.7468
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Traffic Controller
  Description:
  Symbol:
  
• Value: 2
  Label: Pedestrian Signal
  Description:
  Symbol:
  
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: true
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: SUBTYPECD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WORKORDERID ( type: esriFieldTypeString, alias: WorkOrderID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• FIELDVERIFY ( type: esriFieldTypeString, alias: FieldVerify?, editable: true, nullable: true, length: 5, defaultValue: 0, modelName: FieldVerify , Coded Values: [0: No] , [1: Yes] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• CREATIONUSER ( type: esriFieldTypeString, alias: CreationUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• LASTUSER ( type: esriFieldTypeString, alias: LastEditUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LastUser )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: LastEditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• WORKREQUESTID ( type: esriFieldTypeString, alias: Designer:WorkRequestID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkRequestID )
• DESIGNID ( type: esriFieldTypeString, alias: Designer:DesignID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DesignID )
• WORKLOCATIONID ( type: esriFieldTypeString, alias: Designer:WorkLocationID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkLocationID )
• WMSID ( type: esriFieldTypeString, alias: Designer:WorkOrderManagementSystemID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WmsID )
• WORKFLOWSTATUS ( type: esriFieldTypeInteger, alias: Designer:WorkFlowStatus, editable: true, nullable: true, defaultValue: 0, modelName: WorkFlowStatus , Coded Values: [0: None] , [1: In Design] , [2: Pending Approval] , ...4 more... )
• WORKFUNCTION ( type: esriFieldTypeInteger, alias: Designer:WorkFunction, editable: true, nullable: true, defaultValue: 0, modelName: WorkFunction , Coded Values: [0: None] , [1: Install] , [2: Remove] , ...6 more... )
• SYMBOLROTATION ( type: esriFieldTypeSingle, alias: SymbolRotation, editable: true, nullable: true, defaultValue: null, modelName: SYMBOLROTATION )
• GPSDATE ( type: esriFieldTypeDate, alias: GPSDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• GISONUMBER ( type: esriFieldTypeInteger, alias: GISONumber, editable: true, nullable: true, defaultValue: null, modelName: GISONUMBER )
• GISOTYPENBR ( type: esriFieldTypeInteger, alias: GISOTypeNumber, editable: true, nullable: true, defaultValue: null, modelName: GisoTypeNbr )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SubtypeCode, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• LABELTEXT ( type: esriFieldTypeString, alias: LabelText, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LABELTEXT )
• OWNERSHIP ( type: esriFieldTypeString, alias: FeatureOwnedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Ownership )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: CompatibleUnitID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COMPATIBLEUNITID , Coded Values: [994: Controller-Traffic Light] )
• DEVICENUMBER ( type: esriFieldTypeString, alias: DeviceNumber, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DEVICENUMBER )
• FEATURE_STATUS ( type: esriFieldTypeString, alias: FEATURE_STATUS, editable: true, nullable: false, length: 10, defaultValue: Existing, modelName: FEATURE_STATUS , Coded Values: [Existing: Existing Feature] , [New: New Feature] , [Proposed: Proposed Feature] , ...2 more... )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, editable: true, nullable: true, length: 100, defaultValue: https://medicinehatca.sharepoint.com/sites/sp_electricrepo_i/Elec%20Equip/, modelName: HYPERLINK )
• HYPERLINK_PGDB ( type: esriFieldTypeString, alias: HYPERLINK_PGDB, editable: true, nullable: true, length: 50, defaultValue: C:\ARCFM\Elec Equip\, modelName: HYPERLINK_PGDB )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• FEEDERID ( type: esriFieldTypeString, alias: FeederID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FEEDERID )
• FEEDERID2 ( type: esriFieldTypeString, alias: FeederID2, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FEEDERID2 )
• PHASEDESIGNATION ( type: esriFieldTypeInteger, alias: Phase Designation, editable: true, nullable: true, defaultValue: null, modelName: PHASEDESIGNATION , Coded Values: [4: R] , [2: Y] , [1: B] , ...5 more... )
• FEEDERINFO ( type: esriFieldTypeInteger, alias: FeederInfo, editable: true, nullable: true, defaultValue: null, modelName: FEEDERINFO )
• ELECTRICTRACEWEIGHT ( type: esriFieldTypeInteger, alias: MMElectricTraceWeight, editable: true, nullable: true, defaultValue: null, modelName: ELECTRICTRACEWEIGHT )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project?, editable: true, nullable: true, defaultValue: 0, modelName: CITYWORKSPROJECT , Coded Values: [0: No] , [1: Yes] )
• DETECTIONTYPE ( type: esriFieldTypeString, alias: Detection Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DETECTIONTYPE , Coded Values: [Aldis: Aldis] , [V5.1: V5.1] , [L: L] , ...3 more... )
• CONTROLLER_TYPE ( type: esriFieldTypeString, alias: Controller Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTROLLER_TYPE , Coded Values: [Econolite: Econolite] , [233: 233] , [CF: CF] , ...3 more... )
• UPS ( type: esriFieldTypeString, alias: UPS, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UPS , Coded Values: [No: No] , [Yes: Yes] )
• OPTICOM ( type: esriFieldTypeString, alias: OPTICOM, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OPTICOM , Coded Values: [No: No] , [Yes: Yes] )
• RADIO_CHANNEL ( type: esriFieldTypeSmallInteger, alias: Radio Channel, editable: true, nullable: true, defaultValue: null, modelName: RADIO_CHANNEL )
• POWERSOURCE ( type: esriFieldTypeString, alias: Power Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POWERSOURCE , Coded Values: [110 Vac Power: 110 Vac Power] , [Solar Power: Solar Power] )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID, editable: true, nullable: true, defaultValue: null, modelName: RuleID , Coded Values: [1: Traffic Controller] , [2: Pedestrian Signal] , [-1: Free Representation] )
• UPS_INSATLLATION_DATE ( type: esriFieldTypeDate, alias: UPS_Insatllation_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPS_INSATLLATION_DATE )
• BATTERY_INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Battery_Installation_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BATTERY_INSTALLATION_DATE )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )

Types:

ID: 1
Name: Traffic Controller
Domains:
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• FEATURE_STATUS:
  Inherited
• ENABLED:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Pedestal Mounted
  Description:
  Prototype:
  WMSID: null
  WORKFLOWSTATUS: 0
  GISONUMBER: null
  GISOTYPENBR: 302721
  OWNERSHIP: null
  DEVICENUMBER: null
  FEATURE_STATUS: Existing
  HYPERLINK: L:\shared2\Electric\DOWNLOAD\PS-trcontr_pdf\
  HYPERLINK_PGDB: C:\ARCFM\PS-trcontr_pdf\
  LOCATION: null
  WORKORDERID: null
  INSTALLATIONDATE: null
  FIELDVERIFY: null
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WORKFUNCTION: 0
  SYMBOLROTATION: null
  GPSDATE: null
  SUBTYPECD: 1
  LABELTEXT: null
  COMPATIBLEUNITID: 994
  ENABLED: 1
  FEEDERID: null
  FEEDERID2: null
  PHASEDESIGNATION: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  ASSETID: null
  CITYWORKSPROJECT: null
  DETECTIONTYPE: null
  CONTROLLER_TYPE: null
  UPS: null
  OPTICOM: null
  RADIO_CHANNEL: null
  POWERSOURCE: null
  RULEID: null
  UPS_INSATLLATION_DATE: null
  BATTERY_INSTALLATION_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Pedestrian Crossing
Domains:
• FIELDVERIFY:
  Inherited
• WORKFLOWSTATUS:
  Inherited
• WORKFUNCTION:
  Inherited
• FEATURE_STATUS:
  Inherited
• ENABLED:
  Inherited
• PHASEDESIGNATION:
  Inherited
• CITYWORKSPROJECT:
  Inherited
• DETECTIONTYPE:
  Inherited
• CONTROLLER_TYPE:
  Inherited
• UPS:
  Coded Values: [No: No] , [Yes: Yes]
• OPTICOM:
  Coded Values: [No: No] , [Yes: Yes]
• POWERSOURCE:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Pedestrian Crossing
  Description:
  Prototype:
  BATTERY_INSTALLATION_DATE: null
  LOCATION: null
  WORKORDERID: null
  INSTALLATIONDATE: null
  FIELDVERIFY: 0
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  WORKREQUESTID: null
  DESIGNID: null
  WORKLOCATIONID: null
  WMSID: null
  WORKFLOWSTATUS: 0
  WORKFUNCTION: 0
  SYMBOLROTATION: null
  GPSDATE: null
  GISONUMBER: null
  GISOTYPENBR: null
  SUBTYPECD: 2
  LABELTEXT: null
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  DEVICENUMBER: null
  FEATURE_STATUS: Existing
  HYPERLINK: L:\shared2\Electric\DOWNLOAD\PS-trcontr_pdf\
  HYPERLINK_PGDB: C:\ARCFM\PS-trcontr_pdf\
  ENABLED: 1
  FEEDERID: null
  FEEDERID2: null
  PHASEDESIGNATION: null
  FEEDERINFO: null
  ELECTRICTRACEWEIGHT: null
  ASSETID: null
  CITYWORKSPROJECT: 0
  DETECTIONTYPE: null
  CONTROLLER_TYPE: null
  UPS: null
  OPTICOM: null
  RADIO_CHANNEL: null
  POWERSOURCE: null
  RULEID: 2
  UPS_INSATLLATION_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata