Name: SignsTable

Display Field: SignID

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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)
• SignID (type: esriFieldTypeString, alias: SignID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PoleGlobalID (type: esriFieldTypeGUID, alias: PoleGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• PoleID (type: esriFieldTypeString, alias: PoleID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SignType (type: esriFieldTypeString, alias: SignType, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Regulatory: Regulatory], [Warning: Warning], [Guide: Guide], ... 1 more ...)
• SignMUTCD (type: esriFieldTypeString, alias: SignMUTCD, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [D3-1: D3-1 Street Name Sign], [R26K-CA: R26K-CA No Parking Tow Away], [R28: R28 No Parking], ... 149 more ...)
• Sheeting (type: esriFieldTypeString, alias: Sheeting, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [EG: Engineering Grade], [HI: High Intensity], [DGC: Diamond Grade Cubed], ... 1 more ...)
• SignText (type: esriFieldTypeString, alias: SignText, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SignHeightIN (type: esriFieldTypeSmallInteger, alias: SignHeightIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SignWidthIN (type: esriFieldTypeSmallInteger, alias: SignWidthIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FacingDirection (type: esriFieldTypeString, alias: FacingDirection, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [FWBT: FWBT], [FEBT: FEBT], [FSBT: FSBT], ... 3 more ...)
• HorizClearIN (type: esriFieldTypeSmallInteger, alias: HorizClearIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HorizFrom (type: esriFieldTypeString, alias: HorizFrom, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• VertClearIN (type: esriFieldTypeSmallInteger, alias: VertClearIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VertClearFrom (type: esriFieldTypeString, alias: VertClearFrom, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FieldComments (type: esriFieldTypeString, alias: FieldComments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SuppMatls (type: esriFieldTypeString, alias: Supplemental Materials, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [NotThere: Not there], [Good: Good], [Fair: Fair], ... 1 more ...)
• OwnedBy (type: esriFieldTypeSmallInteger, alias: OwnedBy, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Private], [1: City])
• ManagedBy (type: esriFieldTypeSmallInteger, alias: ManagedBy, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Private], [1: City])
• LastUpdateDate (type: esriFieldTypeDate, alias: LastUpdateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Last_Editor (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [FANG: Francisco Anguiano], [SAPP: Steve Appletone], [ABAR: Arturo Barrera], ... 21 more ...)
• LocationCriteria (type: esriFieldTypeString, alias: LocationCriteria, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SignSize (type: esriFieldTypeString, alias: StandardSignSize, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [6x12: 6x12], [9x24: 9x24], [9x30: 9x30], ... 14 more ...)

Templates:

Name: SignsTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• LocationCriteria: Yes

Relationships:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/11/2019 2:38:14 PM

Schema Last Edit Date: 6/11/2019 2:38:14 PM

Data Last Edit Date: 6/11/2019 2:38:14 PM

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