Name: Sign Panels

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• SIGN_TYPE ( type: esriFieldTypeString, alias: Sign Type, length: 20 , Coded Values: [Regulatory: Regulatory] , [Warning: Warning] , [Guide: Guide] , ...5 more... )
• REG_CDE ( type: esriFieldTypeString, alias: Regulatory Code, length: 20 , Coded Values: [R1-1: R1-1] , [R1-2: R1-2] , [R1-3: R1-3] , ...150 more... )
• WARN_CDE ( type: esriFieldTypeString, alias: Warning Code, length: 20 , Coded Values: [W1-1AR: W1-1AR] , [W1-1L: W1-1L] , [W1-1R: W1-1R] , ...116 more... )
• GUIDE_CDE ( type: esriFieldTypeString, alias: Guide Code, length: 20 , Coded Values: [I-5: I-5] , [I-5A: I-5A] , [I-6: I-6] , ...58 more... )
• SCHOOL_CDE ( type: esriFieldTypeString, alias: School Code, length: 20 , Coded Values: [S1-1: S1-1] , [S1-3A: S1-3A] , [S3-1: S3-1] , ...9 more... )
• OBJ_MKR ( type: esriFieldTypeString, alias: Object Marker Code, length: 20 , Coded Values: [OM-1: OM-1] , [OM2-2H: OM2-2H] , [OM2-2V: OM2-2V] , ...6 more... )
• DEST ( type: esriFieldTypeString, alias: Destination Code, length: 20 , Coded Values: [D1-1: D1-1] , [D1-1A: D1-1A] , [D1-2: D1-2] , ...20 more... )
• SPCL_CDE ( type: esriFieldTypeString, alias: Special Code, length: 20 , Coded Values: [L31-P: L31-P] , [LW9-11: LW9-11] , [STREET: STREET NAME] , ...2 more... )
• SPEED ( type: esriFieldTypeString, alias: Speed, length: 5 , Coded Values: [10: 10] , [15: 15] , [20: 20] , ...10 more... )
• SIDE_ST ( type: esriFieldTypeString, alias: Side of Street, length: 20 , Coded Values: [North: North] , [South: South] , [East: East] , ...4 more... )
• FACING ( type: esriFieldTypeString, alias: Direction, length: 30 , Coded Values: [North: North] , [South: South] , [East: East] , ...1 more... )
• SHEETING ( type: esriFieldTypeString, alias: Facing Material, length: 60 , Coded Values: [Diamond/VIP: Diamond/VIP] , [Eng-grade: Eng-grade] , [HIP: HIP] , ...2 more... )
• SIGNS_ON ( type: esriFieldTypeString, alias: Signs on Post, length: 5 , Coded Values: [One: One] , [Two: Two] , [Three: Three] , ...8 more... )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 20 , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...1 more... )
• Sign_Month ( type: esriFieldTypeSmallInteger, alias: Sign Month )
• Sign_Year ( type: esriFieldTypeSmallInteger, alias: Sign Year )
• SIGN_SIZE ( type: esriFieldTypeString, alias: Sign Size, length: 20 , Coded Values: [4x8: 4x8] , [8x12: 8x12] , [8x18: 8x18] , ...74 more... )
• OBSTRUCT ( type: esriFieldTypeSmallInteger, alias: Obstructions )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 50 )
• COMMENTS2 ( type: esriFieldTypeString, alias: Comments2, length: 50 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 100 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• INSTALL_TECH ( type: esriFieldTypeString, alias: Install Technician, length: 5 , Coded Values: [JM: JM] , [Other: Other] , [JH: JH] , ...5 more... )
• YEAR_RETIRED ( type: esriFieldTypeSmallInteger, alias: Year Retired )
• TASK_1 ( type: esriFieldTypeString, alias: Task 1, length: 20 , Coded Values: [Acdt Rplmt: Acdt Rplmt] , [Constr: Constr] , [Constr-Rein: Constr_Rein] , ...9 more... )
• TASK_1_DATE ( type: esriFieldTypeDate, alias: Task 1 Date, length: 8 )
• TASK_1_TECH ( type: esriFieldTypeString, alias: Task 1 Tech, length: 10 , Coded Values: [JM: JM] , [Other: Other] , [JH: JH] , ...5 more... )
• TASK_2 ( type: esriFieldTypeString, alias: Task 2, length: 20 , Coded Values: [Acdt Rplmt: Acdt Rplmt] , [Constr: Constr] , [Constr-Rein: Constr_Rein] , ...9 more... )
• TASK_2_DATE ( type: esriFieldTypeDate, alias: Task 2 Date, length: 8 )
• TASK_2_TECH ( type: esriFieldTypeString, alias: Task 2 Tech, length: 10 , Coded Values: [JM: JM] , [Other: Other] , [JH: JH] , ...5 more... )
• TASK_3 ( type: esriFieldTypeString, alias: Task 3, length: 20 , Coded Values: [Acdt Rplmt: Acdt Rplmt] , [Constr: Constr] , [Constr-Rein: Constr_Rein] , ...9 more... )
• TASK_3_DATE ( type: esriFieldTypeDate, alias: Task 3 Date, length: 8 )
• TASK_3_TECH ( type: esriFieldTypeString, alias: Task 3 Tech, length: 10 , Coded Values: [JM: JM] , [Other: Other] , [JH: JH] , ...5 more... )
• TASK_4 ( type: esriFieldTypeString, alias: Task 4, length: 20 , Coded Values: [Acdt Rplmt: Acdt Rplmt] , [Constr: Constr] , [Constr-Rein: Constr_Rein] , ...9 more... )
• TASK_4_DATE ( type: esriFieldTypeDate, alias: Task 4 Date, length: 8 )
• TASK_4_TECH ( type: esriFieldTypeString, alias: Task 4 Tech, length: 10 , Coded Values: [JM: JM] , [Other: Other] , [JH: JH] , ...5 more... )
• TASK_5 ( type: esriFieldTypeString, alias: Task 5, length: 20 , Coded Values: [Acdt Rplmt: Acdt Rplmt] , [Constr: Constr] , [Constr-Rein: Constr_Rein] , ...9 more... )
• TASK_5_DATE ( type: esriFieldTypeDate, alias: Task 5 Date, length: 8 )
• TASK_5_TECH ( type: esriFieldTypeString, alias: Task 5 Tech, length: 10 , Coded Values: [JM: JM] , [Other: Other] , [JH: JH] , ...5 more... )
• SIGNTYPE ( type: esriFieldTypeString, alias: SIGNTYPE, length: 50 , Coded Values: [R10-2: R10-2] , [R10-3: R10-3] , [R10-3A: R10-3A] , ...8 more... )
• SIGNSTYLE ( type: esriFieldTypeString, alias: SIGNSTYLE, length: 130 , Coded Values: [R1-1: Stop Sign] , [R1-2: Yield] , [R1-3W: 3 Way Stop] , ...110 more... )
• OWNEDBY ( type: esriFieldTypeString, alias: Owned By, length: 10 , Coded Values: [City: City] , [Private: Private] , [Public: Public] , ...1 more... )
• MAINTBY ( type: esriFieldTypeString, alias: Maintained By, length: 10 , Coded Values: [City: City] , [Private: Private] , [Public: Public] , ...1 more... )
• 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 )
• CondIndex ( type: esriFieldTypeSmallInteger, alias: CondIndex )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear )
• LastInspectedBy ( type: esriFieldTypeString, alias: LastInspectedBy, length: 50 )
• LastInspectedDate ( type: esriFieldTypeDate, alias: LastInspectedDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Support_ID ( type: esriFieldTypeSmallInteger, alias: Support_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• Sign_Supports (0) -- Related To: Sign Supports (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata