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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: SubtypeCode

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

---

ID: 2
Name: Fiber Scalability Cabinet
Domains:
• WorkPad:
  Inherited
• Switch:
  Inherited
• CabinetRiser:
  Inherited
• FiberOpticStarCoupler:
  Inherited
• Status:
  Inherited
• Enabled:
  Inherited

---

ID: 3
Name: Pedestal
Domains:
• WorkPad:
  Inherited
• Switch:
  Inherited
• CabinetRiser:
  Inherited
• FiberOpticStarCoupler:
  Inherited
• Status:
  Inherited
• Enabled:
  Inherited

---

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 50 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 16 )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 50 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 )
• LoopSize ( type: esriFieldTypeString, alias: Size, length: 50 )
• Description ( type: esriFieldTypeString, alias: Description, length: 100 )
• InspectionDate ( type: esriFieldTypeString, alias: InspectionDate, length: 50 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 50 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 16 )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 50 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 )
• Type ( type: esriFieldTypeSmallInteger, alias: Type )
• MountType ( type: esriFieldTypeString, alias: MountType, length: 255 )
• BaseType ( type: esriFieldTypeString, alias: BaseType, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• Customer ( type: esriFieldTypeString, alias: Customer, length: 255 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 50 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 16 )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 50 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 )
• PowerSource ( type: esriFieldTypeSmallInteger, alias: PowerSource , Coded Values: [1: Wired] , [2: Solar] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Type ( type: esriFieldTypeString, alias: Type, length: 50 )
• MountType ( type: esriFieldTypeString, alias: MountType, length: 50 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 50 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 16 )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 50 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 )
• Type ( type: esriFieldTypeSmallInteger, alias: Type , Coded Values: [1: Solar School Zone] , [2: Solar Pedestrian] , [3: EPAC Flasher] , ...2 more... )
• PoleType ( type: esriFieldTypeString, alias: PoleType, length: 50 )
• PoleColor ( type: esriFieldTypeSmallInteger, alias: PoleColor , Coded Values: [1: Yellow] , [2: Black] , [3: Other] )
• BaseType ( type: esriFieldTypeString, alias: BaseType, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Subtype ( type: esriFieldTypeString, alias: Subtype, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 50 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 16 )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 50 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 )
• PoleType ( type: esriFieldTypeString, alias: PoleType, length: 50 )
• PoleDiameter ( type: esriFieldTypeString, alias: PoleDiameter, length: 50 )
• PoleColor ( type: esriFieldTypeSmallInteger, alias: PoleColor , Coded Values: [1: Yellow] , [2: Black] , [3: Other] )
• BaseType ( type: esriFieldTypeString, alias: BaseType, length: 50 )
• Breakaway ( type: esriFieldTypeSmallInteger, alias: Breakaway )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

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

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: SUBTYPECODE

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

---

ID: 4
Name: Vault
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• FrameMaterial:
  Inherited
• CoverMaterial:
  Inherited
• CoverType:
  Inherited
• Extra:
  Inherited
• Status:
  Inherited

---

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

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

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 50 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 8 )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 50 )
• Material ( type: esriFieldTypeString, alias: Material, length: 254 )
• ClearanceHeight ( type: esriFieldTypeString, alias: ClearanceHeight, length: 15 )
• HeightAdjustmentDate ( type: esriFieldTypeDate, alias: HeightAdjustmentDate, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 25 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• Color ( type: esriFieldTypeString, alias: Color, length: 25 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• Color ( type: esriFieldTypeString, alias: Color, length: 25 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• TransformerComments ( type: esriFieldTypeString, alias: TransformerComments, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• MountType ( type: esriFieldTypeString, alias: MountType, length: 25 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• Color ( type: esriFieldTypeString, alias: Color, length: 25 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• Color ( type: esriFieldTypeString, alias: Color, length: 25 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• Color ( type: esriFieldTypeString, alias: Color, length: 25 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• SignMessage ( type: esriFieldTypeString, alias: SignMessage, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Color ( type: esriFieldTypeString, alias: Color, length: 25 )
• Material ( type: esriFieldTypeString, alias: Material, length: 25 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

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: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• Material ( type: esriFieldTypeString, alias: Material, length: 25 )
• Color ( type: esriFieldTypeString, alias: Color, length: 25 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

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