Name: SDE.DBO.SIGNS_TABLE

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: TYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TYPE ( type: esriFieldTypeInteger, alias: Sign Type, editable: true, nullable: true, defaultValue: 1, modelName: TYPE )
• NAME ( type: esriFieldTypeString, alias: Sign Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• SIGN_ID ( type: esriFieldTypeString, alias: Sign ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SIGN_ID )
• POST_ID ( type: esriFieldTypeString, alias: Post ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: POST_ID )
• MOD_DATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOD_DATE )
• SOURCE ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SOURCE )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• SIGN_SHEET ( type: esriFieldTypeString, alias: Sign Sheeting, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_SHEET , Coded Values: [Diamond Grade: Diamond Grade] , [Engineering Grade: Engineering Grade] , [High Intensity: High Intensity] , ...5 more... )
• SIGN_BACKG ( type: esriFieldTypeString, alias: Sign Backing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_BACKG , Coded Values: [Aluminum: Aluminum] , [Plastic: Plastic] , [Steel: Steel] , ...2 more... )
• SIGN_COND ( type: esriFieldTypeString, alias: Sign Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_COND , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• SIGN_VIS ( type: esriFieldTypeString, alias: Sign Visibility, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIGN_VIS , 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, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SIGN_SIZE , Coded Values: [30x30: 30x30] , [18x42: 18x42] , [36x36: 36x36] , ...12 more... )
• SIGN_DIREC ( type: esriFieldTypeString, alias: Sign Direction, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SIGN_DIREC , Coded Values: [North: North] , [South: South] , [East: East] , ...7 more... )
• SIGN_HEIGH ( type: esriFieldTypeString, alias: Sign Height, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SIGN_HEIGH )
• ST_NAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ST_NAME , 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, editable: true, nullable: true, defaultValue: null, modelName: TESTING_ID )
• RGUID ( type: esriFieldTypeGUID, alias: RGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RGUID )

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
Templates:
• Name: Regulatory
  Description:
  Prototype:
  TESTING_ID: null
  RGUID: null
  TYPE: 1
  NAME: null
  SIGN_ID: null
  POST_ID: null
  MOD_DATE: null
  SOURCE: null
  COMMENTS: null
  SIGN_SHEET: null
  SIGN_BACKG: null
  SIGN_COND: null
  SIGN_VIS: null
  SIGN_SIZE: null
  SIGN_DIREC: null
  SIGN_HEIGH: null
  ST_NAME: null
  
  Drawing Tool: esriFeatureEditToolNone

---

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
Templates:
• Name: School Zone
  Description:
  Prototype:
  TESTING_ID: null
  RGUID: null
  TYPE: 2
  NAME: null
  SIGN_ID: null
  POST_ID: null
  MOD_DATE: null
  SOURCE: null
  COMMENTS: null
  SIGN_SHEET: null
  SIGN_BACKG: null
  SIGN_COND: null
  SIGN_VIS: null
  SIGN_SIZE: null
  SIGN_DIREC: null
  SIGN_HEIGH: null
  ST_NAME: null
  
  Drawing Tool: esriFeatureEditToolNone

---

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
Templates:
• Name: Guide
  Description:
  Prototype:
  TESTING_ID: null
  RGUID: null
  TYPE: 3
  NAME: null
  SIGN_ID: null
  POST_ID: null
  MOD_DATE: null
  SOURCE: null
  COMMENTS: null
  SIGN_SHEET: null
  SIGN_BACKG: null
  SIGN_COND: null
  SIGN_VIS: null
  SIGN_SIZE: null
  SIGN_DIREC: null
  SIGN_HEIGH: null
  ST_NAME: null
  
  Drawing Tool: esriFeatureEditToolNone

---

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
Templates:
• Name: Warnings
  Description:
  Prototype:
  TESTING_ID: null
  RGUID: null
  TYPE: 4
  NAME: null
  SIGN_ID: null
  POST_ID: null
  MOD_DATE: null
  SOURCE: null
  COMMENTS: null
  SIGN_SHEET: null
  SIGN_BACKG: null
  SIGN_COND: null
  SIGN_VIS: null
  SIGN_SIZE: null
  SIGN_DIREC: null
  SIGN_HEIGH: null
  ST_NAME: null
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata