Name: Sign Panel

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 100000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 35 )
• POLEID ( type: esriFieldTypeString, alias: Pole ID, length: 15 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• SIGNSEQUENCE ( type: esriFieldTypeString, alias: Sign Sequence On Pole Number, length: 2 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...34 more... )
• SIGNTEXT ( type: esriFieldTypeString, alias: Sign Text, length: 100 )
• CONDITION ( type: esriFieldTypeString, alias: Condition, length: 20 )
• REF_CONDITION ( type: esriFieldTypeString, alias: Reflectivity Condition, length: 15 )
• LAST_CON_ASSESS ( type: esriFieldTypeDate, alias: Last Condition Assessment, length: 8 )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD Code, length: 15 )
• SUBTYPE ( type: esriFieldTypeInteger, alias: SubType )
• OPTICS ( type: esriFieldTypeString, alias: Optics, length: 15 )
• SHEETING ( type: esriFieldTypeString, alias: Sheeting Type, length: 10 )
• BACKGROUND ( type: esriFieldTypeString, alias: Background Color, length: 15 )
• LEGEND ( type: esriFieldTypeString, alias: Legend Color, length: 15 )
• DIRFACES ( type: esriFieldTypeString, alias: Direction Faces, length: 5 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...6 more... )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 100 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 15 )
• IMAGEID ( type: esriFieldTypeString, alias: Image ID, length: 75 )
• REPLACEMENTDATE ( type: esriFieldTypeDate, alias: Replacement Date, length: 8 )
• INVENTORYDATE ( type: esriFieldTypeDate, alias: Inventory Date, length: 8 )
• LATITUDE ( type: esriFieldTypeString, alias: Latitude, length: 20 )
• LONGITUDE ( type: esriFieldTypeString, alias: Longitude, length: 20 )
• F02_ALPHA_BACKGROUND ( type: esriFieldTypeDouble, alias: Background Reflectivity )
• F02_ALPHA_LEGEND ( type: esriFieldTypeDouble, alias: Legend Reflectivity )
• STOP_SIGN_SIZE ( type: esriFieldTypeString, alias: Stop Sign Size, length: 2 )
• LIFE_SPAN ( type: esriFieldTypeInteger, alias: Sign Life Span )
• 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 )

Types:

ID: 1
Name: DESTINATION
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [D10-2: MILE MARKER (2 DIGITS)] , [D10-3: MILE MARKER (3 DIGITS)] , [D1-1: ONE CITY W/ARROW] , ...21 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 2
Name: GUIDE
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [E1-1: INTERCHANGE ADV GUIDE _ MILE] , [E11-1: EXIT ONLY W/ARROW] , [E11-15C: HOSPITAL ARW] , ...20 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 3
Name: INFORMATION
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [I10-3: FLORIDA STATE POLICE] , [I10-4: SHERIFF DEPT] , [I-11: RECYCLING SYMBOL] , ...43 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 4
Name: MARKER
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [M1-1: I_ ROUTE MARKER] , [M1-2: I_BL ROUTE MARKER] , [M1-3: I_BS ROUTE MARKER] , ...40 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 5
Name: OBJECT
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [OM1-1: California Standard (yellow) 8 button ref] , [OM1-2: DIAMOND w/ REFLECTORS, YELLOW] , [OM1-3: DIAMOND, YELLOW] , ...12 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 6
Name: REGULATORY
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [R10-1: CROSS ON GREEN LIGHT ONLY] , [R10-10L: LEFT TURN SIGNAL] , [R10-10R: RIGHT TURN SIGNAL] , ...194 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 7
Name: SCHOOL
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [S1-1: SCHOOL ADVANCE SYMBOL] , [S2-1: SCHOOL CROSSING SYMBOL] , [S3-1: SCHOOL BUS STOP AHEAD] , ...17 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 8
Name: WARNING
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [W10-1: RAILROAD ADVANCE] , [W10-2: SIDE RR ADVANCE FULL INTERSECTION] , [W10-3: SIDE RR ADVANCE SIDE INTERSECTION] , ...137 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

ID: 9
Name: NA
Domains:
• CONDITION:
  Coded Values: [EXCELLENT: Excellent] , [GOOD: Good] , [FAIR: Fair] , ...3 more...
• REF_CONDITION:
  Coded Values: [PASS: PASS] , [FAIL: FAIL] , [INVALID: INVALID] , ...6 more...
• MUTCD:
  Coded Values: [D10-2: MILE MARKER (2 DIGITS)] , [D10-3: MILE MARKER (3 DIGITS)] , [D1-1: ONE CITY W/ARROW] , ...21 more...
• OPTICS:
  Coded Values: [BEADED: Beaded] , [PRISMATIC: Prismatic] , [CG: Computer Generated]
• SHEETING:
  Coded Values: [I: I] , [II: II] , [III+: III+]
• BACKGROUND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• LEGEND:
  Coded Values: [YELLOW: Yellow] , [BLUE: Blue] , [GREEN: Green] , ...5 more...
• DIRFACES:
  Inherited
• STATUS:
  Coded Values: [ACTIVE: ACTIVE] , [RETIRED: RETIRED]
• STOP_SIGN_SIZE:
  Coded Values: [24: 24] , [30: 30] , [36: 36] , ...1 more...

---

Relationships:

• SUMTERGIS.DBO.SignRetro (1) -- Related To: Sign Retroreflectivity (2)
• SUMTERGIS.DBO.SignSupport (0) -- Related To: Sign Support (0)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata