Name: Sign Type Information

Display Field: ROADNAME

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ASSET_ID (type: esriFieldTypeString, alias: ASSET_ID, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: false)
• SUPPORT_ID (type: esriFieldTypeString, alias: SUPPORT_ID, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: false)
• RWCOMPKEY (type: esriFieldTypeInteger, alias: RWCOMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: false)
• ROADNAME (type: esriFieldTypeString, alias: Roadname, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
• COLL_DATE (type: esriFieldTypeDate, alias: Collection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• NEAR_ADDRESS (type: esriFieldTypeString, alias: Near Address, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: false)
• MUTCD (type: esriFieldTypeString, alias: MUTCD Code, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: false)
• MUTCD_DESC (type: esriFieldTypeString, alias: MUTCD Description, SQL Type: sqlTypeOther, length: 107, nullable: true, editable: false)
• WIDTH (type: esriFieldTypeInteger, alias: Sign Width, SQL Type: sqlTypeOther, nullable: true, editable: false)
• HEIGHT (type: esriFieldTypeInteger, alias: Sign Height, SQL Type: sqlTypeOther, nullable: true, editable: false)
• HEIGTH_ABOVE_ROAD (type: esriFieldTypeDouble, alias: Distance from Ground, SQL Type: sqlTypeOther, nullable: true, editable: false)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
• CONDITION_COMMENT (type: esriFieldTypeString, alias: Condition Comments, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: false)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: false)
• RVX_LINK (type: esriFieldTypeString, alias: Roadview Link, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: false)

Templates:

Name: Sign Type Information
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• SignPosts (0) -- Related To: Sign Posts and Signage (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/21/2025 3:14:57 PM

Schema Last Edit Date: 3/24/2025 11:17:59 AM

Data Last Edit Date: 3/24/2025 11:17:59 AM

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