Name: Signs

Display Field:

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• SignGuid (type: esriFieldTypeGUID, alias: SignGuid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• SIGNDESC (type: esriFieldTypeString, alias: Sign Description, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• SIGNTYPE (type: esriFieldTypeString, alias: Sign Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [J ASSEMBLY: J ASSEMBLY], [R1-1: STOP SIGN], [R1-2: YIELD SIGN], ... 97 more ...)
• FACINGDIR (type: esriFieldTypeString, alias: Facing Direction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [North: North], [South: South], [East: East], ... 5 more ...)
• SIGNYEAR (type: esriFieldTypeString, alias: SIGNYEAR, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SHEETING (type: esriFieldTypeString, alias: Sheeting Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [3M Diamond: 3M Diamond], [3M HIP: 3M HIP], [3M Engineer Grade: 3M Engineer Grade], ... 3 more ...)
• BACKING (type: esriFieldTypeString, alias: Backing Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Metal: Metal], [Wood: Wood])
• SIGNSIZE (type: esriFieldTypeString, alias: Sign Size, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [24x39: 24x39], [48x39: 48x39], [30x30: 30x30], ... 36 more ...)
• BGD_REFLECT (type: esriFieldTypeSingle, alias: Background Retroreflectivity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LETTERING_REFLECT (type: esriFieldTypeSingle, alias: Lettering Retroreflectivity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CUSTOMSIZE (type: esriFieldTypeString, alias: Custom Size, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true, Coded Values: [Shawn Best: Shawn Best], [Eric Goebel: Eric Goebel], [Fred Anderson: Fred Anderson])
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true, Coded Values: [Shawn Best: Shawn Best], [Eric Goebel: Eric Goebel], [Fred Anderson: Fred Anderson])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Relationships:

• polerelate (0) -- Related To: Pole (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2023 3:55:54 PM

Schema Last Edit Date: 6/29/2023 3:58:41 PM

Data Last Edit Date: 6/29/2023 3:58:41 PM

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