Name: SDE.DBO.SIGNS_TABLE

Display Field: NAME

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TYPE ( type: esriFieldTypeInteger, alias: Sign Type )
• NAME ( type: esriFieldTypeString, alias: Sign Name, length: 50 )
• SIGN_ID ( type: esriFieldTypeString, alias: Sign ID, length: 25 )
• POST_ID ( type: esriFieldTypeString, alias: Post ID, length: 25 )
• MOD_DATE ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• SOURCE ( type: esriFieldTypeString, alias: Source, length: 25 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 100 )
• SIGN_SHEET ( type: esriFieldTypeString, alias: Sign Sheeting, length: 50 , Coded Values: [Diamond Grade: Diamond Grade] , [Engineering Grade: Engineering Grade] , [High Intensity: High Intensity] , ...5 more... )
• SIGN_BACKG ( type: esriFieldTypeString, alias: Sign Backing, length: 50 , Coded Values: [Aluminum: Aluminum] , [Plastic: Plastic] , [Steel: Steel] , ...2 more... )
• SIGN_COND ( type: esriFieldTypeString, alias: Sign Condition, length: 50 , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• SIGN_VIS ( type: esriFieldTypeString, alias: Sign Visibility, length: 50 , Coded Values: [Clear: Clear] , [Obscured By Trees: Obscured By Trees] , [Obscured By Vehicles: Obscured By Vehicles] , ...2 more... )
• SIGN_SIZE ( type: esriFieldTypeString, alias: Sign Size, length: 30 , Coded Values: [30x30: 30x30] , [18x42: 18x42] , [36x36: 36x36] , ...12 more... )
• SIGN_DIREC ( type: esriFieldTypeString, alias: Sign Direction, length: 30 , Coded Values: [North: North] , [South: South] , [East: East] , ...7 more... )
• SIGN_HEIGH ( type: esriFieldTypeString, alias: Sign Height, length: 25 )
• ST_NAME ( type: esriFieldTypeString, alias: Street Name, length: 50 , Coded Values: [N. 1st Ave.: N. 1st Ave.] , [S. 1st Ave.: S. 1st Ave.] , [S. 2nd Ave.: S. 2nd Ave.] , ...58 more... )
• TESTING_ID ( type: esriFieldTypeDouble, alias: TESTING_ID )
• RGUID ( type: esriFieldTypeGUID, alias: RGUID, length: 38 )

Types:

ID: 1
Name: Regulatory
Domains:
• NAME:
  Coded Values: [Stop: Stop] , [Yield: Yield] , [Do Not Pass: Do Not Pass] , ...16 more...
• SOURCE:
  Coded Values: [As-Builts: As-Builts] , [Field Knowledge: Field Knowledge] , [GPS: GPS] , ...1 more...
• SIGN_SHEET:
  Inherited
• SIGN_BACKG:
  Inherited
• SIGN_COND:
  Inherited
• SIGN_VIS:
  Inherited
• SIGN_SIZE:
  Inherited
• SIGN_DIREC:
  Inherited
• ST_NAME:
  Inherited

---

ID: 2
Name: School Zone
Domains:
• NAME:
  Coded Values: [School: School] , [Advance School Zone: Advance School Zone] , [School Bus Stop Ahead: School Bus Stop Ahead] , ...2 more...
• SOURCE:
  Coded Values: [As-Builts: As-Builts] , [Field Knowledge: Field Knowledge] , [GPS: GPS] , ...1 more...
• SIGN_SHEET:
  Inherited
• SIGN_BACKG:
  Inherited
• SIGN_COND:
  Inherited
• SIGN_VIS:
  Inherited
• SIGN_SIZE:
  Inherited
• SIGN_DIREC:
  Inherited
• ST_NAME:
  Inherited

---

ID: 3
Name: Guide
Domains:
• NAME:
  Coded Values: [Road Markers: Road Markers] , [Scenic Byway: Scenic Byway] , [Road Names: Road Names] , ...9 more...
• SOURCE:
  Coded Values: [As-Builts: As-Builts] , [Field Knowledge: Field Knowledge] , [GPS: GPS] , ...1 more...
• SIGN_SHEET:
  Inherited
• SIGN_BACKG:
  Inherited
• SIGN_COND:
  Inherited
• SIGN_VIS:
  Inherited
• SIGN_SIZE:
  Inherited
• SIGN_DIREC:
  Inherited
• ST_NAME:
  Inherited

---

ID: 4
Name: Warnings
Domains:
• NAME:
  Coded Values: [Arrows: Arrows - directional] , [Curve: Curve signs with speed limits] , [Equestrian: Equestrian Crossing] , ...26 more...
• SOURCE:
  Coded Values: [As-Builts: As-Builts] , [Field Knowledge: Field Knowledge] , [GPS: GPS] , ...1 more...
• SIGN_SHEET:
  Inherited
• SIGN_BACKG:
  Inherited
• SIGN_COND:
  Inherited
• SIGN_VIS:
  Inherited
• SIGN_SIZE:
  Inherited
• SIGN_DIREC:
  Inherited
• ST_NAME:
  Inherited

---

Relationships:

• SDE.DBO.SignPosts_wSigns (0) -- Related To: SDE.DBO.SignPosts_wSigns (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata