Name: HB_Inspection

Display Field: Street

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 4000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Inspection_Date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Street_Served (type: esriFieldTypeString, alias: Street Served, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 1 more ...)
• Condition_Issue (type: esriFieldTypeString, alias: Condition Issue, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Vegitation: Trim Vegitation], [Knockdown: Knockdown], [Missing Fixture: Missing Fixture], ... 7 more ...)
• Condition_Comment (type: esriFieldTypeString, alias: Condition Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Feed_Point (type: esriFieldTypeString, alias: Feed Point, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [HHAB: Hand Hole at base of Pole], [HHAPB: Hand Hole with adjacent pull box], [NHHWPB: No Hand Hole with adjacent pull box], ... 1 more ...)
• Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Cobra: Cobra], [Shoebox: Shoebox], [Pendant: Pendant], ... 5 more ...)
• Style (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [No Style: No Style], [Decorative: Decorative], [Other: Other])
• Pole_Number (type: esriFieldTypeString, alias: Pole Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Pole_Mast_Arm_Size (type: esriFieldTypeString, alias: Pole Mast Arm Size, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [A: A type Mount], [B: B type Mount], [0: Mounted at Pole], ... 9 more ...)
• Pole_Mount_Config (type: esriFieldTypeString, alias: Pole Mount Config, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Wattage (type: esriFieldTypeString, alias: Wattage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [3: 3 (35 W)], [5: 5 (50/55 W)], [7: 7 (70 W)], ... 17 more ...)
• Sticker_Color (type: esriFieldTypeString, alias: Sticker Color, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yellow: Yellow], [White: White], [Blue: Blue], ... 4 more ...)
• Multi_Fixture_Per_Pole (type: esriFieldTypeString, alias: Multi Fixture Per Pole, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unresolved: Unresolved], [Yes: Yes], [No: No], ... 1 more ...)
• Decoration_Present (type: esriFieldTypeString, alias: Decoration Present, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unresolved: Unresolved], [Yes: Yes], [No: No], ... 1 more ...)
• Device_Present (type: esriFieldTypeString, alias: Device Present, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unresolved: Unresolved], [Yes: Yes], [No: No], ... 1 more ...)
• Shield_Present (type: esriFieldTypeString, alias: Shield Present, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unresolved: Unresolved], [Yes: Yes], [No: No], ... 1 more ...)
• Double_Pole (type: esriFieldTypeString, alias: Double Pole, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unresolved: Unresolved], [Yes: Yes], [No: No], ... 1 more ...)
• Already_LED (type: esriFieldTypeString, alias: Already LED, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unresolved: Unresolved], [Yes: Yes], [No: No], ... 1 more ...)
• General_Issues (type: esriFieldTypeString, alias: General Issues, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CouldNotMatch: Could not match Pole # to fixture], [CouldNotAccess: Could not access the pole (private, safety)], [CouldNotLocate: Could not locate the fixture], ... 9 more ...)
• General_Comments (type: esriFieldTypeString, alias: General Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• Creator_Date (type: esriFieldTypeDate, alias: Creator Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• Editor_Date (type: esriFieldTypeDate, alias: Editor_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GIS_ID (type: esriFieldTypeString, alias: GIS_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Location_on_Street (type: esriFieldTypeString, alias: Location on Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Roadway: Roadway], [IOT: Inside of Turn], [OOT: Outside of Turn], ... 2 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: HB_Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (0) -- Related To: HB_Data_Phase4 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/29/2018 1:44:52 AM

Schema Last Edit Date: 8/29/2018 1:44:52 AM

Data Last Edit Date: 8/29/2018 1:44:52 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat