Name: SignsUsed

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• SignMaterial (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new: New], [reusable: Reusable])
• SignType (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [regulatory: Regulatory], [warning: Warning], [guide: Guide], ... 6 more ...)
• RequlatorySigns (type: esriFieldTypeString, alias: Regulatory Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [STOP: Stop], [ALL WAY: All Way], [SPEED LIMIT 20: Speed Limit 20], ... 57 more ...)
• WarningSigns (type: esriFieldTypeString, alias: Warning Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10 MPH SPEED ADVISORY: 10 MPH Speed Advisory], [15 MPH SPEED ADVISORY: 15 MPH Speed Advisory], [20 MPH SPEED ADVISORY: 20 MPH Speed Advisory], ... 56 more ...)
• ConstructionSigns (type: esriFieldTypeString, alias: Construction Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DETOUR AHEAD: Detour Ahead], [DETOUR W/ STRAIGHT ARROW: Detour w/ Straight Arrow], [DETOUR W/LEFT ARROW: Detour w/Left Arrow], ... 15 more ...)
• GuideSigns (type: esriFieldTypeString, alias: Guide Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SNS: SNS], [BLOCK NUMBER: Block Number], [FRENCH QUARTER STYLE SNS: French Quarter Style SNS], ... 2 more ...)
• MiscSigns (type: esriFieldTypeString, alias: Misc Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [MILLAGE/RENEWAL SIGN: Millage/Renewal Sign], [RESERVED PARKING SIGN: Reserved Parking Sign])
• SchoolSigns (type: esriFieldTypeString, alias: School Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CELL PHONE PROHIBITED: Cell Phone Prohibited], [SCHOOL AHEAD: School Ahead], [SCHOOL ZONE SIGN: School Zone Sign], ... 11 more ...)
• ParadeSigns (type: esriFieldTypeString, alias: Parade Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [FAMILY GRAS SIGN: Family Gras Sign], [IRISH ITALIAN PARADE SIGN: Irish Italian Parade Sign], [MARDI GRAS PARADE SIGN: Mardi Gras Parade Sign], ... 3 more ...)
• ZoningSigns (type: esriFieldTypeString, alias: ZoningSigns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BOARD OF ZONING OF ADJUSTMENT SIGN: Board of Zoning of Adjustment Sign], [OLD METAIRIE COMMISSION SIGN: Old Metairie Commission Sign], [PLANNING ADVISORY BOARD SIGN: Planning Advisory Board Sign])
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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: false)
• 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: false)
• SignLabor (type: esriFieldTypeString, alias: Sign Labor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [INSTALLED: Installed], [REPLACED: Replaced], [STRAIGHTENED: Straightened], ... 6 more ...)
• SignLaborOther (type: esriFieldTypeString, alias: Other Labor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SignTypeOther (type: esriFieldTypeString, alias: Other Sign, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• Traffic_Eng__Dept_SignsUsed (1) -- Related To: Traffic_Eng__Dept (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/21/2026 3:26:32 PM

Schema Last Edit Date: 9/21/2026 3:26:32 PM

Data Last Edit Date: 9/21/2026 3:39:21 PM

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