All Layers and Tables (TrafficEngView)

Layers:

Layer: Traffic_Eng__Dept (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Traffic Eng. Dept.","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
WorkOrderType (type: esriFieldTypeString, alias: Work Order Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Trouble-Call: Trouble Call], [SR: Service Req], [In-House: In-House], ... 1 more ...)
SRNumber (type: esriFieldTypeString, alias: SR #, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
street (type: esriFieldTypeString, alias: For Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Direction (type: esriFieldTypeString, alias: Direction (Bounds), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Eastbound: EB], [Westbound: WB], [Northbound: NB], ... 15 more ...)
ATstreet (type: esriFieldTypeString, alias: At Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Quadrant (type: esriFieldTypeString, alias: Quadrant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [StreetName: StreetName], [EAST: East], [NORTH: North], ... 12 more ...)
Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
RequestedBy (type: esriFieldTypeString, alias: Requested By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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 ...)
PostLabor (type: esriFieldTypeString, alias: Post Labor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [INSTALLED: Installed], [REPLACED: Replaced], [STRAIGHTENED: Straightened], ... 3 more ...)
SignLaborOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NOTIFICATION (type: esriFieldTypeString, alias: Notification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [RADIO: Radio], [PHONE: Phone], [LETTER: Letter], ... 2 more ...)
REMARKS (type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DateRecieived (type: esriFieldTypeDate, alias: Date/Time Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DateCrewNotified (type: esriFieldTypeDate, alias: Date/Time Crew Notified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DateTimeCompleted (type: esriFieldTypeDate, alias: Date/Time Completed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SupervisorDate (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SuperVisorName (type: esriFieldTypeString, alias: Supervisor, SQL Type: sqlTypeOther, length: 255, 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)
OtherFor (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
OtherAt (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
REMARKS_LIST (type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Requested by order: Requested by order], [Sign damaged: Sign damaged], [Post damaged: Post damaged], ... 13 more ...)
REMARKSOTHER (type: esriFieldTypeString, alias: Other Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Relationships:

Traffic_Eng__Dept_SignsUsed (1) -- Related To: SignsUsed (1)
Traffic_Eng__Dept_Posts (2) -- Related To: Posts (2)
Traffic_Eng__Dept_PICS (3) -- Related To: PICS (3)
Traffic_Eng__Dept_EquipmentUsed (4) -- Related To: EquipmentUsed (4)
Traffic_Eng__Dept_LaborUsed (5) -- Related To: LaborUsed (5)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

SignsUsed (1)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Posts (2)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
PostMaterial (type: esriFieldTypeString, alias: Post Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [7': 7'], [11': 11'], [7' Existing: 7' Existing], ... 10 more ...)
PostMaterialOther (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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)
PostLabor (type: esriFieldTypeString, alias: Post Labor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [INSTALLED: Installed], [REPLACED: Replaced], [STRAIGHTENED: Straightened], ... 3 more ...)

Relationships:

Traffic_Eng__Dept_Posts (2) -- Related To: Traffic_Eng__Dept (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

PICS (3)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
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)

Relationships:

Traffic_Eng__Dept_PICS (3) -- Related To: Traffic_Eng__Dept (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

EquipmentUsed (4)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
EquipmentCount (type: esriFieldTypeInteger, alias: No., SQL Type: sqlTypeOther, nullable: true, editable: true)
EquipmentDesc (type: esriFieldTypeString, alias: Equipment Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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)

Relationships:

Traffic_Eng__Dept_EquipmentUsed (4) -- Related To: Traffic_Eng__Dept (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

LaborUsed (5)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
EMPNAME (type: esriFieldTypeString, alias: Employee, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [J VASQUEZ: J Vasquez 41688], [D TERRANCE: D Terrance 46634], [T HENSLEY: T Hensley 46053], ... 13 more ...)
EmpNo (type: esriFieldTypeString, alias: EmpNo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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)

Relationships:

Traffic_Eng__Dept_LaborUsed (5) -- Related To: Traffic_Eng__Dept (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: