Name: PWE_GDB.ADM.Traffic_Light_Fixture_Information

Display Field: Old_AF_ID

Type: Table

Geometry Type: N/A

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

Max Result Window: N/A

Max Record Count: 5000

Standard Max Record Count No Geometry: N/A

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 5000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• Old_AF_ID ( modelName: Old_AF_ID, nullable: true, editable: true, defaultValue: N/A, length: 16, alias: Old_AF_ID, type: esriFieldTypeString )
• Pole_ID ( modelName: Pole_ID, nullable: true, editable: true, defaultValue: N/A, alias: Pole_ID, type: esriFieldTypeInteger )
• POLENO ( modelName: POLENO, nullable: true, editable: true, defaultValue: N/A, length: 16, alias: POLENO, type: esriFieldTypeString )
• EWEB_NO ( modelName: EWEB_NO, nullable: true, editable: true, defaultValue: N/A, length: 16, alias: EWEB_NO, type: esriFieldTypeString )
• Arm_Number ( modelName: Arm_Number, nullable: true, editable: true, defaultValue: N/A, alias: Arm_Number, type: esriFieldTypeInteger )
• Arm_Length ( modelName: Arm_Length, nullable: true, editable: true, defaultValue: N/A, alias: Arm_Length, type: esriFieldTypeSmallInteger )
• Tennon_Diameter ( modelName: Tennon_Diameter, nullable: true, editable: true, defaultValue: N/A, alias: Tennon_Diameter, type: esriFieldTypeSingle )
• Mounting_Height ( modelName: Mounting_Height, nullable: true, editable: true, defaultValue: N/A, alias: Mounting_Height, type: esriFieldTypeDouble )
• Orientation ( modelName: Orientation, nullable: true, editable: true, defaultValue: N/A, length: 3, alias: Orientation, type: esriFieldTypeString )
• Angle ( modelName: Angle, nullable: true, editable: true, defaultValue: N/A, alias: Angle, type: esriFieldTypeInteger )
• Wattage ( modelName: Wattage, nullable: true, editable: true, defaultValue: N/A, alias: Wattage, type: esriFieldTypeInteger )
• Voltage ( modelName: Voltage, nullable: true, editable: true, defaultValue: N/A, alias: Voltage, type: esriFieldTypeInteger )
• Fixture_Type ( modelName: Fixture_Type, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Fixture_Type, type: esriFieldTypeString )
• Fix_Number ( modelName: Fix_Number, nullable: true, editable: true, defaultValue: N/A, alias: Fix_Number, type: esriFieldTypeInteger )
• Lighting_Pattern ( modelName: Lighting_Pattern, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Lighting_Pattern, type: esriFieldTypeString )
• Type_Lens ( modelName: Type_Lens, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Type_Lens, type: esriFieldTypeString )
• PEC ( modelName: PEC, nullable: true, editable: true, defaultValue: N/A, alias: PEC, type: esriFieldTypeSmallInteger )
• PEC_CIR ( modelName: PEC_CIR, nullable: true, editable: true, defaultValue: N/A, length: 16, alias: PEC_CIR, type: esriFieldTypeString )
• Shorting_Cap ( modelName: Shorting_Cap, nullable: true, editable: true, defaultValue: N/A, alias: Shorting_Cap, type: esriFieldTypeSmallInteger )
• Plug ( modelName: Plug, nullable: true, editable: true, defaultValue: N/A, alias: Plug, type: esriFieldTypeSmallInteger )
• Shield ( modelName: Shield, nullable: true, editable: true, defaultValue: N/A, alias: Shield, type: esriFieldTypeSmallInteger )
• Painted ( modelName: Painted, nullable: true, editable: true, defaultValue: N/A, alias: Painted, type: esriFieldTypeSmallInteger )
• Fixture_Installed ( modelName: Fixture_Installed, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Fixture_Installed, type: esriFieldTypeDate )
• FixtureType ( modelName: FixtureType, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: FixtureType, type: esriFieldTypeString )
• Record_Status ( modelName: Record_Status, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: Record_Status, type: esriFieldTypeString )
• Date_Inspected ( modelName: Date_Inspected, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Date_Inspected, type: esriFieldTypeDate )
• Manufacture ( modelName: Manufacture, nullable: true, editable: true, defaultValue: N/A, length: 64, alias: Manufacture, type: esriFieldTypeString )
• Notes ( modelName: Notes, nullable: true, editable: true, defaultValue: N/A, length: 1073741822, alias: Notes, type: esriFieldTypeString )
• Installed_By ( modelName: Installed_By, nullable: true, editable: true, defaultValue: N/A, length: 32, alias: Installed_By, type: esriFieldTypeString )
• Installed_Date ( modelName: Installed_Date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Installed_Date, type: esriFieldTypeDate )
• Supervisor_Status ( modelName: Supervisor_Status, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Supervisor_Status, type: esriFieldTypeString )
• Ornamental ( modelName: Ornamental, nullable: true, editable: true, defaultValue: N/A, alias: Ornamental, type: esriFieldTypeSmallInteger )
• Record_Created ( modelName: Record_Created, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Record_Created, type: esriFieldTypeDate )
• AF_ID ( modelName: AF_ID, nullable: true, editable: true, defaultValue: N/A, alias: AF_ID, type: esriFieldTypeInteger )
• OBJECTID ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )

Templates:

• Name: PWE_GDB.ADM.Traffic_Light_Fixture_Information
  Description:
  Prototype:
  AF_ID: null
  Fixture_Installed: null
  Shield: null
  Wattage: null
  Plug: null
  Record_Status: null
  Arm_Length: null
  Fixture_Type: null
  Mounting_Height: null
  Fix_Number: null
  Installed_Date: null
  Installed_By: null
  PEC_CIR: null
  Voltage: null
  Lighting_Pattern: null
  Ornamental: null
  EWEB_NO: null
  Notes: null
  Pole_ID: null
  Old_AF_ID: null
  Arm_Number: null
  Record_Created: null
  Orientation: null
  Tennon_Diameter: null
  Painted: null
  PEC: null
  Shorting_Cap: null
  Angle: null
  Date_Inspected: null
  Type_Lens: null
  POLENO: null
  Manufacture: null
  FixtureType: null
  Supervisor_Status: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• LightFixtures (0) -- Related To: PWE_GDB.ADM.StreetLights (0)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata