Name: PWE_GDB.ADM.Traffic_Light_Fixture_Information

Display Field: Old_AF_ID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

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

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