Layers:

Layer: Cabinets (0)

Name: Cabinets

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0786053233306512E7
YMin: 5907475.031116204
XMax: -1.0773147624746503E7
YMax: 5931647.38962138
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• SubtypeCode ( type: esriFieldTypeSmallInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: Subtype )
• CabinetType ( type: esriFieldTypeString, alias: CabinetType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CabinetType )
• BaseType ( type: esriFieldTypeString, alias: BaseType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BaseType )
• BaseComments ( type: esriFieldTypeString, alias: BaseComments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BaseComments )
• WorkPad ( type: esriFieldTypeSmallInteger, alias: WorkPad, editable: true, nullable: true, defaultValue: null, modelName: WorkPad , Coded Values: [1: Yes] , [0: No] )
• Switch ( type: esriFieldTypeSmallInteger, alias: Switch, editable: true, nullable: true, defaultValue: null, modelName: Switch , Coded Values: [1: Yes] , [0: No] )
• CabinetWiringDiagram ( type: esriFieldTypeString, alias: CabinetWiringDiagram, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CabinetWiringDiagram )
• LoadBayType ( type: esriFieldTypeString, alias: LoadBayType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LoadBayType )
• PowerStrip ( type: esriFieldTypeSmallInteger, alias: PowerStrip, editable: true, nullable: true, defaultValue: null, modelName: PowerStrip )
• Heater ( type: esriFieldTypeSmallInteger, alias: Heater, editable: true, nullable: true, defaultValue: null, modelName: Heater )
• CabinetRiser ( type: esriFieldTypeSmallInteger, alias: CabinetRiser, editable: true, nullable: true, defaultValue: null, modelName: CabinetRiser , Coded Values: [1: Yes] , [0: No] )
• BusRelayType ( type: esriFieldTypeString, alias: BusRelayType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BusRelayType )
• BusRelayInstDate ( type: esriFieldTypeString, alias: BusRelayInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: BusRelayInstDate )
• FiberDistributionPanelComments ( type: esriFieldTypeString, alias: FiberDistributionPanelComments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FiberDistributionPanelComments )
• FiberOpticStarCoupler ( type: esriFieldTypeSmallInteger, alias: FiberOpticStarCoupler, editable: true, nullable: true, defaultValue: null, modelName: FiberOpticStarCoupler , Coded Values: [1: Yes] , [0: No] )
• FlasherTransferRelayNumbers ( type: esriFieldTypeString, alias: FlasherTransferRelayNumbers, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FlasherTransferRelayNumbers )
• FlasherTransferRelayInstDate ( type: esriFieldTypeString, alias: FlasherTransferRelayInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: FlasherTransferRelayInstDate )
• LoadSwitchNumbers ( type: esriFieldTypeString, alias: LoadSwitchNumbers, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LoadSwitchNumbers )
• LoadSwitchInstDate ( type: esriFieldTypeString, alias: LoadSwitchInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: LoadSwitchInstDate )
• PowerLineFilterType ( type: esriFieldTypeString, alias: PowerLineFilterType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PowerLineFilterType )
• PowerLineFilterInstDate ( type: esriFieldTypeString, alias: PowerLineFilterInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PowerLineFilterInstDate )
• PTZPowerSupplyModel ( type: esriFieldTypeString, alias: PTZPowerSupply, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PTZPowerSupplyModel )
• PTZPowerSupplyInstDate ( type: esriFieldTypeString, alias: PTZPowerSupplyInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: PTZPowerSupplyInstDate )
• RackPowerSupplyModel ( type: esriFieldTypeString, alias: RackPowerSupplyModel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RackPowerSupplyModel )
• RackPowerSupplyInstDate ( type: esriFieldTypeString, alias: RackPowerSupplyInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: RackPowerSupplyInstDate )
• SolidStateFlasherInstDate ( type: esriFieldTypeString, alias: SolidStateFlasherInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: SolidStateFlasherInstDate )
• SurgeSuppressionModel ( type: esriFieldTypeString, alias: SurgeSuppressionModel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SurgeSuppressionModel )
• SurgeSuppressionInstDate ( type: esriFieldTypeString, alias: SurgeSuppressionInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: SurgeSuppressionInstDate )
• VehicleDetectorCardModel ( type: esriFieldTypeString, alias: VehicleDetectorCardModel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VehicleDetectorCardModel )
• VehicleDetectorCardInstDate ( type: esriFieldTypeString, alias: VehicleDetectorCardInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: VehicleDetectorCardInstDate )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Customer ( type: esriFieldTypeString, alias: Customer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Customer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• IPID ( type: esriFieldTypeGUID, alias: IPID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: IPID )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled, required: true , Coded Values: [0: False] , [1: True] )
• OldOID ( type: esriFieldTypeInteger, alias: OldOID, editable: true, nullable: true, defaultValue: null, modelName: OldOID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cabinets
  Description:
  Prototype:
  OldOID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  SubtypeCode: 0
  CabinetType: null
  BaseType: null
  BaseComments: null
  WorkPad: null
  Switch: null
  CabinetWiringDiagram: null
  LoadBayType: null
  PowerStrip: null
  Heater: null
  CabinetRiser: null
  BusRelayType: null
  BusRelayInstDate: null
  FiberDistributionPanelComments: null
  FiberOpticStarCoupler: null
  FlasherTransferRelayNumbers: null
  FlasherTransferRelayInstDate: null
  LoadSwitchNumbers: null
  LoadSwitchInstDate: null
  PowerLineFilterType: null
  PowerLineFilterInstDate: null
  PTZPowerSupplyModel: null
  PTZPowerSupplyInstDate: null
  RackPowerSupplyModel: null
  RackPowerSupplyInstDate: null
  SolidStateFlasherInstDate: null
  SurgeSuppressionModel: null
  SurgeSuppressionInstDate: null
  VehicleDetectorCardModel: null
  VehicleDetectorCardInstDate: null
  Comments: null
  Status: null
  Manufacturer: null
  Customer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  Parent_ID: null
  OldParentID: null
  Enabled: null
  IPID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• fCabinetAuxillaryRelaySystem (0) -- Related To: Cityworks_sde.DBO.fCabinetAuxillaryRelaySystem (13)
• fController (1) -- Related To: Cityworks_sde.DBO.fController (19)
• fCabinetAudiblePedSystem (2) -- Related To: Cityworks_sde.DBO.fCabinetAudiblePedSystem (12)
• fCabinetVidDetectionProcessor (3) -- Related To: Cityworks_sde.DBO.fCabinetVidDetectionProcessor (18)
• fCabinetFiberDistributionPanel (4) -- Related To: Cityworks_sde.DBO.fCabinetFiberDistributionPanel (17)
• fCabinetEthernetSwitch (5) -- Related To: Cityworks_sde.DBO.fCabinetEthernetSwitch (15)
• fCabinetEVPCard (6) -- Related To: Cityworks_sde.DBO.fCabinetEVPCard (16)
• fCabinetConflictMonitor (7) -- Related To: Cityworks_sde.DBO.fCabinetConflictMonitor (14)

Layer: Detection Loops (1)

Name: Detection Loops

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0786240264649287E7
YMin: 5907404.726227061
XMax: -1.0773188659569064E7
YMax: 5928507.518085499
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material )
• LoopSize ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LoopSize )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Description )
• InspectionDate ( type: esriFieldTypeString, alias: InspectionDate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionDate )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: DetectionLoops
  Description:
  Prototype:
  Parent_ID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  Material: null
  LoopSize: null
  Description: null
  InspectionDate: null
  Condition: null
  Comments: null
  Status: null
  Manufacturer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  OldParentID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Feed Points (2)

Name: Feed Points

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0786073397443835E7
YMin: 5907473.703510618
XMax: -1.0773112078829763E7
YMax: 5931642.771797108
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material )
• Type ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: Type )
• MountType ( type: esriFieldTypeString, alias: MountType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MountType )
• BaseType ( type: esriFieldTypeString, alias: BaseType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BaseType )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Customer ( type: esriFieldTypeString, alias: Customer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Customer )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: FeedPoints
  Description:
  Prototype:
  Parent_ID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  Material: null
  Type: null
  MountType: null
  BaseType: null
  Comments: null
  Status: null
  Manufacturer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  Customer: null
  OldParentID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Driver Feedback Signs (3)

Name: Driver Feedback Signs

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0785270741354797E7
YMin: 5909033.626224567
XMax: -1.0773790294396205E7
YMax: 5926968.133948005
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material )
• PowerSource ( type: esriFieldTypeSmallInteger, alias: PowerSource, editable: true, nullable: true, defaultValue: null, modelName: PowerSource , Coded Values: [1: Wired] , [2: Solar] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleType )
• MountType ( type: esriFieldTypeString, alias: MountType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BaseType )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: DriverFeedbackSigns
  Description:
  Prototype:
  Parent_ID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  Material: null
  PowerSource: null
  Comments: null
  Status: null
  Manufacturer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Type: null
  MountType: null
  Asset_ID: null
  OldParentID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• fBatteryRegulator (8) -- Related To: Cityworks_sde.DBO.fBatteryRegulator (11)
• fDFSignElectronicSign (9) -- Related To: Cityworks_sde.DBO.fDFSignElectronicSign (20)
• fController (10) -- Related To: Cityworks_sde.DBO.fController (19)
• fSolarPanel (11) -- Related To: Cityworks_sde.DBO.fSolarPanel (29)
• fTransformerBase (12) -- Related To: Cityworks_sde.DBO.fTransformerBase (30)
• fBattery (13) -- Related To: Cityworks_sde.DBO.fBattery (10)

Layer: Flashers (4)

Name: Flashers

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.078492877705842E7
YMin: 5908172.874622872
XMax: -1.077311138903088E7
YMax: 5928976.8437660895
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material )
• Type ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: Type , Coded Values: [1: Solar School Zone] , [2: Solar Pedestrian] , [3: EPAC Flasher] , ...2 more... )
• PoleType ( type: esriFieldTypeString, alias: PoleType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleType )
• PoleColor ( type: esriFieldTypeSmallInteger, alias: PoleColor, editable: true, nullable: true, defaultValue: null, modelName: PoleColor , Coded Values: [1: Yellow] , [2: Black] , [3: Other] )
• BaseType ( type: esriFieldTypeString, alias: BaseType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BaseType )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Subtype ( type: esriFieldTypeString, alias: Subtype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Subtype )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Flashers
  Description:
  Prototype:
  Parent_ID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  Material: null
  Type: null
  PoleType: null
  PoleColor: null
  BaseType: null
  Comments: null
  Status: null
  Manufacturer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  Subtype: null
  OldParentID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• fSignalHead (14) -- Related To: Cityworks_sde.DBO.fSignalHead (27)
• fTransformerBase (15) -- Related To: Cityworks_sde.DBO.fTransformerBase (30)
• fPedestrianButton (16) -- Related To: Cityworks_sde.DBO.fPedestrianButton (23)
• fSolarPanel (17) -- Related To: Cityworks_sde.DBO.fSolarPanel (29)
• fBattery (18) -- Related To: Cityworks_sde.DBO.fBattery (10)
• fLEDIndication (19) -- Related To: Cityworks_sde.DBO.fLEDIndication (22)
• fController (20) -- Related To: Cityworks_sde.DBO.fController (19)
• fBatteryRegulator (21) -- Related To: Cityworks_sde.DBO.fBatteryRegulator (11)

Layer: Pedestrian Button Posts (5)

Name: Pedestrian Button Posts

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.078600914450364E7
YMin: 5909545.498154273
XMax: -1.0773223730374107E7
YMax: 5929338.331131785
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material )
• PoleType ( type: esriFieldTypeString, alias: PoleType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleType )
• PoleDiameter ( type: esriFieldTypeString, alias: PoleDiameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleDiameter )
• PoleColor ( type: esriFieldTypeSmallInteger, alias: PoleColor, editable: true, nullable: true, defaultValue: null, modelName: PoleColor , Coded Values: [1: Yellow] , [2: Black] , [3: Other] )
• BaseType ( type: esriFieldTypeString, alias: BaseType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BaseType )
• Breakaway ( type: esriFieldTypeSmallInteger, alias: Breakaway, editable: true, nullable: true, defaultValue: null, modelName: Breakaway )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: PedestrianButtonPosts
  Description:
  Prototype:
  Parent_ID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  Material: null
  PoleType: null
  PoleDiameter: null
  PoleColor: null
  BaseType: null
  Breakaway: null
  Comments: null
  Status: null
  Manufacturer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  OldParentID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• fPedestrianHead (22) -- Related To: Cityworks_sde.DBO.fPedestrianHead (24)
• fPedestrianButton (23) -- Related To: Cityworks_sde.DBO.fPedestrianButton (23)

Layer: Signal Poles (6)

Name: Signal Poles

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0786045112528404E7
YMin: 5909002.360963367
XMax: -1.077317353869014E7
YMax: 5929380.739248564
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• SignalType ( type: esriFieldTypeSmallInteger, alias: SignalType, editable: true, nullable: true, defaultValue: null, modelName: SignalType )
• PoleType ( type: esriFieldTypeSmallInteger, alias: PoleType, editable: true, nullable: true, defaultValue: null, modelName: PoleType , Coded Values: [1: Type 4] , [2: Type 5] , [3: Wood] , ...1 more... )
• PoleHeight ( type: esriFieldTypeString, alias: PoleHeight, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleHeight )
• PoleColor ( type: esriFieldTypeSmallInteger, alias: PoleColor, editable: true, nullable: true, defaultValue: null, modelName: PoleColor , Coded Values: [1: Yellow] , [2: Black] , [3: Other] )
• ClearanceHeight ( type: esriFieldTypeString, alias: Height, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ClearanceHeight )
• MastArmLength ( type: esriFieldTypeString, alias: MastArmLength, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MastArmLength )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• HasBaseWings ( type: esriFieldTypeSmallInteger, alias: HasWings, editable: true, nullable: true, defaultValue: null, modelName: HasBaseWings , Coded Values: [1: Yes] , [0: No] )
• BaseSize ( type: esriFieldTypeString, alias: BaseSize, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BaseSize )
• Image_ ( type: esriFieldTypeString, alias: Image, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Image )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: SignalPoles
  Description:
  Prototype:
  Parent_ID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  SignalType: null
  PoleType: null
  PoleHeight: null
  PoleColor: null
  ClearanceHeight: null
  MastArmLength: null
  Comments: null
  Status: null
  Manufacturer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  HasBaseWings: null
  BaseSize: null
  Image_: null
  Asset_ID: null
  OldParentID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• fPedestrianHead (24) -- Related To: Cityworks_sde.DBO.fPedestrianHead (24)
• fLEDIndication (25) -- Related To: Cityworks_sde.DBO.fLEDIndication (22)
• fSignalHead (26) -- Related To: Cityworks_sde.DBO.fSignalHead (27)
• fSignalElectronicSignalSign (27) -- Related To: Cityworks_sde.DBO.fSignalElectronicSignalSign (25)
• fSignalEVPConfirmationLight (28) -- Related To: Cityworks_sde.DBO.fSignalEVPConfirmationLight (26)
• fSignalVideoDetectionCamera (29) -- Related To: Cityworks_sde.DBO.fSignalVideoDetectionCamera (28)
• fTransformerBase (30) -- Related To: Cityworks_sde.DBO.fTransformerBase (30)
• fEVPDetector (31) -- Related To: Cityworks_sde.DBO.fEVPDetector (21)
• fPedestrianButton (32) -- Related To: Cityworks_sde.DBO.fPedestrianButton (23)

Layer: Structures (7)

Name: Structures

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0786243354654035E7
YMin: 5907309.67607073
XMax: -1.0772683885069445E7
YMax: 5932771.260693347
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED, required: true , Coded Values: [0: False] , [1: True] )
• IPID ( type: esriFieldTypeGUID, alias: Item of Plant ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: IPID )
• SUBTYPECODE ( type: esriFieldTypeInteger, alias: Subtype Code, editable: true, nullable: true, defaultValue: 3, modelName: SUBTYPECODE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• NAME ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NAME )
• Rotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 16, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• FrameMaterial ( type: esriFieldTypeSmallInteger, alias: FrameMaterial, editable: true, nullable: true, defaultValue: null, modelName: FrameMaterial , Coded Values: [1: PVC] , [2: Metal] , [3: Quazite Fiber] , ...1 more... )
• CoverMaterial ( type: esriFieldTypeSmallInteger, alias: CoverMaterial, editable: true, nullable: true, defaultValue: null, modelName: CoverMaterial , Coded Values: [1: PVC] , [2: Metal] , [3: Quazite Fiber] , ...1 more... )
• CoverType ( type: esriFieldTypeSmallInteger, alias: CoverType, editable: true, nullable: true, defaultValue: null, modelName: CoverType , Coded Values: [1: Square_Rectangle] , [2: Circle] )
• Size_ ( type: esriFieldTypeString, alias: Size_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Size_ )
• Number_ ( type: esriFieldTypeString, alias: Number_, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Number_ )
• DetSpliceKitNumbers ( type: esriFieldTypeString, alias: DetSpliceKitNumbers, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DetSpliceKitNumbers )
• DetSpliceKitInstDate ( type: esriFieldTypeString, alias: DetSpliceKitInstDate, editable: true, nullable: true, length: 16, defaultValue: null, modelName: DetSpliceKitInstDate )
• Extra ( type: esriFieldTypeSmallInteger, alias: Extra, editable: true, nullable: true, defaultValue: 0, modelName: Extra , Coded Values: [1: Yes] , [0: No] )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Customer ( type: esriFieldTypeString, alias: Customer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Customer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Jurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• VaultID ( type: esriFieldTypeString, alias: VaultID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VaultID )
• OldOID ( type: esriFieldTypeInteger, alias: OldOID, editable: true, nullable: true, defaultValue: null, modelName: OldOID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Structures
  Description:
  Prototype:
  OldOID: null
  ANCILLARYROLE: null
  ENABLED: null
  IPID: null
  SUBTYPECODE: 0
  OldParentID: null
  NAME: null
  Rotation: null
  VaultID: null
  Parent_ID: null
  Asset_ID: null
  CostingDate: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  FrameMaterial: null
  CoverMaterial: null
  CoverType: null
  Size_: null
  Number_: null
  DetSpliceKitNumbers: null
  DetSpliceKitInstDate: null
  Extra: null
  Status: null
  Comments: null
  Manufacturer: null
  Customer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Conduit System (8)

Name: Conduit System

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 750000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0787495086411532E7
YMin: 5907164.455546845
XMax: -1.0770407504653694E7
YMax: 5932829.09386931
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 197, 255, 255]
Width: 1
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED, required: true , Coded Values: [0: False] , [1: True] )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTUSER )
• PROJECTID ( type: esriFieldTypeSmallInteger, alias: Project Number, editable: true, nullable: true, defaultValue: null, modelName: PROJECTNUMBER )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: MEASUREDLENGTH , Range: [1, 10000] )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• IPID ( type: esriFieldTypeGUID, alias: Item of Plant ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: IPID )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearInstalled )
• Ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Ownership )
Templates:
• Name: CommunicationLines
  Description:
  Prototype:
  YearInstalled: null
  ENABLED: 1
  CREATIONUSER: null
  DATECREATED: null
  DATEMODIFIED: null
  LASTUSER: null
  PROJECTID: null
  MEASUREDLENGTH: null
  INSTALLATIONDATE: null
  IPID: null
  Status: null
  COMMENTS: null
  Asset_ID: null
  Parent_ID: null
  Ownership: null
  OldParentID: null
  ProjectNumber: null
  
  Drawing Tool: esriFeatureEditToolLine

Layer: Span Wire Lines (9)

Name: Span Wire Lines

Display Field: ProjectNumber

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 750000.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: true

Supports Datum Transformation: true

Extent:
XMin: -1.0784952847153347E7
YMin: 5912005.192828196
XMax: -1.0773718233901303E7
YMax: 5929333.537112869
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 2
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: YearInstalled )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectRetired )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearRetired )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ConduitMaterial )
• ClearanceHeight ( type: esriFieldTypeString, alias: ClearanceHeight, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ClearanceHeight )
• HeightAdjustmentDate ( type: esriFieldTypeDate, alias: HeightAdjustmentDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HeightAdjustmentDate )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Manufacturer )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterJurisdiction )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: SpanWireLines
  Description:
  Prototype:
  Parent_ID: null
  ProjectNumber: null
  YearInstalled: null
  ProjectRetired: null
  YearRetired: null
  Material: null
  ClearanceHeight: null
  HeightAdjustmentDate: null
  Comments: null
  Status: null
  Manufacturer: null
  Jurisdiction: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  OldParentID: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• fSignalHead (33) -- Related To: Cityworks_sde.DBO.fSignalHead (27)

Tables:

Table: Cityworks_sde.DBO.fBattery (10)

Name: Cityworks_sde.DBO.fBattery

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fBattery
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DriverFeedbackSigns (13) -- Related To: Driver Feedback Signs (3)
• Flashers (18) -- Related To: Flashers (4)

Table: Cityworks_sde.DBO.fBatteryRegulator (11)

Name: Cityworks_sde.DBO.fBatteryRegulator

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fBatteryRegulator
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Flashers (21) -- Related To: Flashers (4)
• DriverFeedbackSigns (8) -- Related To: Driver Feedback Signs (3)

Table: Cityworks_sde.DBO.fCabinetAudiblePedSystem (12)

Name: Cityworks_sde.DBO.fCabinetAudiblePedSystem

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Color )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fCabinetAudiblePedSystem
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  Color: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Cabinet (2) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fCabinetAuxillaryRelaySystem (13)

Name: Cityworks_sde.DBO.fCabinetAuxillaryRelaySystem

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Color )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fCabinetAuxillaryRelaySystem
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  Color: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Cabinet (0) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fCabinetConflictMonitor (14)

Name: Cityworks_sde.DBO.fCabinetConflictMonitor

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fCabinetConflictMonitor
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Cabinet (7) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fCabinetEthernetSwitch (15)

Name: Cityworks_sde.DBO.fCabinetEthernetSwitch

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fCabinetEthernetSwitch
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Cabinet (5) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fCabinetEVPCard (16)

Name: Cityworks_sde.DBO.fCabinetEVPCard

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fCabinetEVPCard
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Cabinet (6) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fCabinetFiberDistributionPanel (17)

Name: Cityworks_sde.DBO.fCabinetFiberDistributionPanel

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fCabinetFiberDistributionPanel
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Cabinet (4) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fCabinetVidDetectionProcessor (18)

Name: Cityworks_sde.DBO.fCabinetVidDetectionProcessor

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fCabinetVidDetectionProcessor
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Cabinet (3) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fController (19)

Name: Cityworks_sde.DBO.fController

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fController
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Flashers (20) -- Related To: Flashers (4)
• DriverFeedbackSigns (10) -- Related To: Driver Feedback Signs (3)
• Cabinet (1) -- Related To: Cabinets (0)

Table: Cityworks_sde.DBO.fDFSignElectronicSign (20)

Name: Cityworks_sde.DBO.fDFSignElectronicSign

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• TransformerComments ( type: esriFieldTypeString, alias: TransformerComments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TransformerComments )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fDFSignElectronicSign
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  TransformerComments: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DriverFeedbackSigns (9) -- Related To: Driver Feedback Signs (3)

Table: Cityworks_sde.DBO.fEVPDetector (21)

Name: Cityworks_sde.DBO.fEVPDetector

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• MountType ( type: esriFieldTypeString, alias: MountType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MountType )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fEVPDetector
  Description:
  Prototype:
  OldParentID: null
  MountType: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  Parent_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignalPoles (31) -- Related To: Signal Poles (6)

Table: Cityworks_sde.DBO.fLEDIndication (22)

Name: Cityworks_sde.DBO.fLEDIndication

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Color )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fLEDIndication
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  Color: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Flashers (19) -- Related To: Flashers (4)
• SignalPoles (25) -- Related To: Signal Poles (6)

Table: Cityworks_sde.DBO.fPedestrianButton (23)

Name: Cityworks_sde.DBO.fPedestrianButton

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Color )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fPedestrianButton
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  Color: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignalPoles (32) -- Related To: Signal Poles (6)
• PedestrianButtonPosts (23) -- Related To: Pedestrian Button Posts (5)
• Flashers (16) -- Related To: Flashers (4)

Table: Cityworks_sde.DBO.fPedestrianHead (24)

Name: Cityworks_sde.DBO.fPedestrianHead

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Color )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fPedestrianHead
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  Color: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignalPoles (24) -- Related To: Signal Poles (6)
• PedestrianButtonPosts (22) -- Related To: Pedestrian Button Posts (5)

Table: Cityworks_sde.DBO.fSignalElectronicSignalSign (25)

Name: Cityworks_sde.DBO.fSignalElectronicSignalSign

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• SignMessage ( type: esriFieldTypeString, alias: SignMessage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SignMessage )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fSignalElectronicSignalSign
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  SignMessage: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignalPoles (27) -- Related To: Signal Poles (6)

Table: Cityworks_sde.DBO.fSignalEVPConfirmationLight (26)

Name: Cityworks_sde.DBO.fSignalEVPConfirmationLight

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fSignalEVPConfirmationLight
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignalPoles (28) -- Related To: Signal Poles (6)

Table: Cityworks_sde.DBO.fSignalHead (27)

Name: Cityworks_sde.DBO.fSignalHead

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Color )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Material )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fSignalHead
  Description:
  Prototype:
  OldParentID: null
  Material: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  Parent_ID: null
  Color: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignalPoles (26) -- Related To: Signal Poles (6)
• Flashers (14) -- Related To: Flashers (4)
• SpanWireLines (33) -- Related To: Span Wire Lines (9)

Table: Cityworks_sde.DBO.fSignalVideoDetectionCamera (28)

Name: Cityworks_sde.DBO.fSignalVideoDetectionCamera

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fSignalVideoDetectionCamera
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SignalPoles (29) -- Related To: Signal Poles (6)

Table: Cityworks_sde.DBO.fSolarPanel (29)

Name: Cityworks_sde.DBO.fSolarPanel

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fSolarPanel
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Manufacturer: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Flashers (17) -- Related To: Flashers (4)
• DriverFeedbackSigns (11) -- Related To: Driver Feedback Signs (3)

Table: Cityworks_sde.DBO.fTransformerBase (30)

Name: Cityworks_sde.DBO.fTransformerBase

Display Field: Model

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Type )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Warranty ( type: esriFieldTypeString, alias: Warranty, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Warranty )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LifeExpectancy )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Material )
• Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Color )
• ParentType ( type: esriFieldTypeString, alias: ParentType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentType )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EngProjectNumber )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GeneralContractor )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Location )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure, editable: true, nullable: true, defaultValue: null, modelName: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation, editable: true, nullable: true, defaultValue: null, modelName: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk, editable: true, nullable: true, defaultValue: null, modelName: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife, editable: true, nullable: true, defaultValue: null, modelName: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost, editable: true, nullable: true, defaultValue: null, modelName: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CostingDate )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Asset_ID )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_ID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OldParentID )
Templates:
• Name: Cityworks_sde.DBO.fTransformerBase
  Description:
  Prototype:
  OldParentID: null
  Parent_ID: null
  Model: null
  Type: null
  SerialNumber: null
  Warranty: null
  LifeExpectancy: null
  Material: null
  Color: null
  ParentType: null
  EngProjectNumber: null
  GeneralContractor: null
  Comments: null
  Status: Active
  Manufacturer: null
  Location: null
  ConsequenceOfFailure: null
  ProbabilityOfFailure: null
  Mitigation: null
  Risk: null
  EstimatedLife: null
  InstallationDate: null
  ReplacementCost: null
  CostingDate: null
  Asset_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DriverFeedbackSigns (12) -- Related To: Driver Feedback Signs (3)
• SignalPoles (30) -- Related To: Signal Poles (6)
• Flashers (15) -- Related To: Flashers (4)