View In:   ArcGIS Online Map Viewer

Name: ENG_TrafficSignals_ServiceRequests

Display Field: GROUP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1d8dbf12fa204a4fa8d2034a08d28f59

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -7391948.44583945
YMin: -1409846.513244018
XMax: 3.4969231912667125E7
YMax: 1.3744090137155384E7
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: INCIDENT_TYPE_ID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: 10192
  Label: EN-Traffic Signal Maintenance
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [212, 252, 217, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 10195
  Label: EN-Traffic Signal Operation
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 179, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: INCIDENT_TYPE_ID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, editable: true, nullable: true, length: 50, defaultValue: MANUAL, modelName: REC_EDIT_MODE , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REC_EDIT_MODE_COMMENTS )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• DIVISION ( type: esriFieldTypeString, alias: Division, editable: true, nullable: true, length: 150, defaultValue: null, modelName: DIVISION )
• DEPARTMENT ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 150, defaultValue: null, modelName: DEPARTMENT )
• CATEGORY ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CATEGORY )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: Oracle ID, editable: true, nullable: true, defaultValue: null, modelName: INCIDENT_ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: INCIDENT_NUMBER )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID, editable: true, nullable: true, defaultValue: 0, modelName: INCIDENT_TYPE_ID )
• REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUEST_TYPE )
• REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, editable: true, nullable: true, length: 20, defaultValue: Open, modelName: REQUEST_STATUS , Coded Values: [Open: Open] , [In Progress: In Progress] , [Deferred: Deferred] , ...1 more... )
• REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, editable: true, nullable: true, length: 15, defaultValue: Low, modelName: REQUEST_PRIORITY , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPORTED_DATE )
• REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: REQUEST_SUMMARY )
• SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SR_CREATION_CHANNEL )
• CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CREATED_BY_USER , Coded Values: [ANTHONY: ANTHONY] , [BURROUGHS, J: BURROUGHS, J] , [COUSIN: COUSIN] , ...35 more... )
• DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old, editable: true, nullable: true, defaultValue: null, modelName: DAYS_OLD )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATION_DATE )
• CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY, editable: true, nullable: true, defaultValue: null, modelName: CREATED_BY )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_UPDATE_DATE )
• UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UPDATED_BY_USER , Coded Values: [ANTHONY: ANTHONY] , [BURROUGHS, J: BURROUGHS, J] , [COUSIN: COUSIN] , ...35 more... )
• LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY, editable: true, nullable: true, defaultValue: null, modelName: LAST_UPDATED_BY )
• LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN, editable: true, nullable: true, defaultValue: null, modelName: LAST_UPDATE_LOGIN )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_MODIFIED_DATE )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FOLLOWUP_DATE )
• NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NEXT_OPEN_TASK_DATE )
• JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: JOB_NOTES )
• REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: REQUEST_NOTES )
• ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSIGNED_TO , Coded Values: [ANTHONY: ANTHONY] , [BURROUGHS, J: BURROUGHS, J] , [COUSIN: COUSIN] , ...35 more... )
• ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSIGNED_DATE )
• SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUPERVISOR , Coded Values: [ANTHONY: ANTHONY] , [BURROUGHS, J: BURROUGHS, J] , [COUSIN: COUSIN] , ...35 more... )
• DISPATCH ( type: esriFieldTypeString, alias: Dispatcher, editable: true, nullable: true, length: 55, defaultValue: null, modelName: DISPATCH , Coded Values: [ANTHONY: ANTHONY] , [BURROUGHS, J: BURROUGHS, J] , [COUSIN: COUSIN] , ...35 more... )
• ISSUED_BY ( type: esriFieldTypeString, alias: Issued By, editable: true, nullable: true, length: 55, defaultValue: null, modelName: ISSUED_BY , Coded Values: [311 REQUEST: 311 REQUEST] , [631: 631] , [632: 632] , ...41 more... )
• NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTIFICATION , Coded Values: [1: SHOP] , [2: RADIO] , [3: ROUTINE MAINTENANCE] , ...5 more... )
• QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QAQC_YESNO , Coded Values: [Yes: Yes] , [No: No] )
• QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating, editable: true, nullable: true, defaultValue: null, modelName: QAQC_RATING , Coded Values: [1: Good - 1] , [2: Fair - 2] , [3: Fair - 3] , ...2 more... )
• SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SUPERVISOR_APPROVAL , Coded Values: [Yes: Yes] , [No: No] )
• SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUPERVISOR_NOTES )
• RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RESOLVED_DATE )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSE_DATE )
• TROUBLE_CODE ( type: esriFieldTypeString, alias: Trouble Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TROUBLE_CODE , Coded Values: [00: 00 - Unknown] , [10: 10 - Flashing] , [11B: 11B - Lamp Out Bulb] , ...80 more... )
• RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RESOLUTION_CODE )
• RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RESOLUTION_CODE_MEANING )
• RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: RESOLUTION_SUMMARY )
• GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GROUP_NAME )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNER_NAME )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREET_NAME )
• ADDRESS1 ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS1 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS2 )
• ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS3 )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATE )
• POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POSTAL_CODE )
• PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PARCEL_ID )
• ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSET_ID )
• P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID, editable: true, nullable: true, defaultValue: null, modelName: P_LOCATION_ID )
• P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID, editable: true, nullable: true, defaultValue: null, modelName: P_PARTY_ID )
• CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTACT_NAME_FIRST )
• CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTACT_NAME_LAST )
• PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_ADDRESS1 )
• PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_ADDRESS2 )
• PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERSON_ADDRESS3 )
• PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PERSON_STATE )
• PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PERSON_CITY )
• PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PERSON_ZIP_CODE )
• MAP_PG ( type: esriFieldTypeString, alias: Map Page, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAP_PG , Coded Values: [118: 118] , [119: 119] , [120: 120] , ...122 more... )
• MAP_BLK ( type: esriFieldTypeString, alias: Map Block, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAP_BLK , Coded Values: [A: A] , [B: B] , [C: C] , ...14 more... )
• GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number, editable: true, nullable: true, defaultValue: null, modelName: GRID_NO , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CODE_SUBDISTRICT , Coded Values: [1-1: 1-1] , [1-2: 1-2] , [1-3: 1-3] , ...35 more... )
• TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TARGET_BLOCK , Coded Values: [1: 1] , [10: 10] , [100: 100] , ...235 more... )
• DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DRAIN_ZONE )
• DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DRAIN_GRID )
• STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_ZONE )
• STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_GRID )
• TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TRAFFIC_ZONE )
• SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWM_AREA , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
• SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWM_ZONE , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
• COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COLLECTION_DAY , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
• SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWM_ROUTE )
• PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code, editable: true, nullable: true, defaultValue: null, modelName: PREM_CODE )
• CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code, editable: true, nullable: true, defaultValue: null, modelName: CUST_CODE )
• MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MLGW_ON )
• MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MLGW_STATUS , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
• SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWF_RATE , Coded Values: [C1: Special Class] , [C10: Single Family] , [C10A: Single Family Plus One Cart] , ...77 more... )
• SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWF_STATUS , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
• MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MLGW_CUSTOMER )
• MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MLGW_CONTACT1 )
• MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MLGW_CONTACT2 )
• MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MLGW_EMAIL )
• NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_TASKS )
• LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LINKED_SR )
• RELATION ( type: esriFieldTypeString, alias: Relation with SR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RELATION )
• cd_name ( type: esriFieldTypeInteger, alias: Council District No, editable: true, nullable: true, defaultValue: null, modelName: cd_name )
• cd_desc ( type: esriFieldTypeString, alias: Council District, editable: true, nullable: true, length: 100, defaultValue: null, modelName: cd_desc )
• sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No, editable: true, nullable: true, defaultValue: null, modelName: sccd_name )
• sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, editable: true, nullable: true, length: 100, defaultValue: null, modelName: sccd_desc )
• scd_name ( type: esriFieldTypeInteger, alias: Super District No, editable: true, nullable: true, defaultValue: null, modelName: scd_name )
• scd_desc ( type: esriFieldTypeString, alias: Super Council District, editable: true, nullable: true, length: 100, defaultValue: null, modelName: scd_desc )
• neigh_name ( type: esriFieldTypeString, alias: neigh_name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: neigh_name )
• neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: neigh_desc )
• tract_name ( type: esriFieldTypeInteger, alias: Tract Number, editable: true, nullable: true, defaultValue: null, modelName: tract_name )
• tract_desc ( type: esriFieldTypeString, alias: Tract, editable: true, nullable: true, length: 100, defaultValue: null, modelName: tract_desc )
• voting_name ( type: esriFieldTypeString, alias: voting_name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: voting_name )
• voting_desc ( type: esriFieldTypeString, alias: Voting, editable: true, nullable: true, length: 100, defaultValue: null, modelName: voting_desc )
• zip_name ( type: esriFieldTypeInteger, alias: Zip Code No, editable: true, nullable: true, defaultValue: null, modelName: zip_name )
• zip_desc ( type: esriFieldTypeString, alias: Zip Code, editable: true, nullable: true, length: 100, defaultValue: null, modelName: zip_desc )
• ce_name ( type: esriFieldTypeString, alias: ce_name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ce_name )
• ce_desc ( type: esriFieldTypeString, alias: ce_desc, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ce_desc )
• cityzone ( type: esriFieldTypeString, alias: City Zone, editable: true, nullable: true, length: 100, defaultValue: null, modelName: cityzone )
• CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CONTACT_NAME )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CONTACT_EMAIL )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTACT_PHONE )
• SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SCF_URL )
• SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: SCF_Description )
• EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EX_ATTRIBUTE12 )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• JURSIDICTION ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JURSIDICTION , Coded Values: [Collierville Eng: Collierville Eng] , [Germantown Eng: Germantown Eng] , [Lakeland Sch: Lakeland Sch] , ...18 more... )
• QUARTER ( type: esriFieldTypeSmallInteger, alias: Quarter, editable: true, nullable: true, defaultValue: null, modelName: QUARTER , Coded Values: [1: Q1] , [2: Q2] , [3: Q3] , ...1 more... )
• PAY_APPLICATION ( type: esriFieldTypeInteger, alias: Pay Application, editable: true, nullable: true, defaultValue: null, modelName: PAY_APPLICATION )
• SS4 ( type: esriFieldTypeString, alias: SS4, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SS4 )
• START_TIME ( type: esriFieldTypeDate, alias: Start Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_TIME )
• FINISH_TIME ( type: esriFieldTypeDate, alias: Finish Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FINISH_TIME )
• FIELDTECH1 ( type: esriFieldTypeString, alias: Technician 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIELDTECH1 , Coded Values: [ANTHONY: ANTHONY] , [BURROUGHS, J: BURROUGHS, J] , [COUSIN: COUSIN] , ...35 more... )
• FIELDTECH2 ( type: esriFieldTypeString, alias: Technician 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIELDTECH2 , Coded Values: [ANTHONY: ANTHONY] , [BURROUGHS, J: BURROUGHS, J] , [COUSIN: COUSIN] , ...35 more... )
• DM_MAINT ( type: esriFieldTypeInteger, alias: DM Maintenance, editable: true, nullable: true, defaultValue: null, modelName: DM_MAINT , Coded Values: [0: No] , [1: Yes] )
• UNIT_NUMB ( type: esriFieldTypeString, alias: Unit Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: UNIT_NUMB )
• DM_NUMB ( type: esriFieldTypeInteger, alias: DM Number, editable: true, nullable: true, defaultValue: null, modelName: DM_NUMB )
• EQUIP_NUMB2 ( type: esriFieldTypeString, alias: Equipment Number 2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EQUIP_NUMB2 )
• DM_NUMB2 ( type: esriFieldTypeString, alias: DM Number 2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DM_NUMB2 )
• LOOP_TYPE ( type: esriFieldTypeString, alias: Loop Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOOP_TYPE , Coded Values: [1: 1 - SB Front] , [10: 10 - EB Front] , [10A: 10A - EB Curb] , ...38 more... )
• LOOP_NAME ( type: esriFieldTypeString, alias: Loop Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOOP_NAME )
• LOOP_ID ( type: esriFieldTypeString, alias: Loop ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOOP_ID )
• REPAIRED ( type: esriFieldTypeInteger, alias: Repaired, editable: true, nullable: true, defaultValue: null, modelName: REPAIRED , Coded Values: [0: No] , [1: Yes] )
• REPAIR_DATE ( type: esriFieldTypeDate, alias: Repair_Dat, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPAIR_DATE )
• LOOP_SIZE ( type: esriFieldTypeString, alias: Loop_Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOOP_SIZE , Coded Values: [5x5: 5x5] , [6x lane width: 6x lane width] , [6x45: 6x45] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ASSET_GUID ( type: esriFieldTypeGUID, alias: ASSET_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ASSET_GUID )
• CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District, editable: true, nullable: true, defaultValue: null, modelName: CODE_DISTRICT , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
• EQUIP_NUMB ( type: esriFieldTypeString, alias: Equipment Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EQUIP_NUMB )
• OLD_OBJECTID ( type: esriFieldTypeInteger, alias: OLD_OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OLD_OBJECTID )
• Transfer ( type: esriFieldTypeString, alias: Is Transferring, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Transfer , Coded Values: [Yes: Yes] , [No: No] )
• Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Transfer_Dept )
• Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Transfer_Notes )

Types:

ID: 10192
Name: EN-Traffic Signal Maintenance
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• CREATED_BY_USER:
  Inherited
• UPDATED_BY_USER:
  Inherited
• ASSIGNED_TO:
  Inherited
• SUPERVISOR:
  Inherited
• DISPATCH:
  Inherited
• ISSUED_BY:
  Inherited
• QAQC_YESNO:
  Inherited
• QAQC_RATING:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• TROUBLE_CODE:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [ENTM1NC: Present controls are appropriate. No change is warranted] , [ENTM1PL: Changes to improve traffic signal operation at this location are planned and will be scheduled according to its priority with respect to other similar locations.] , [ENTM1REEVAL: An engineering evaluation has indicated traffic signal control is not appropriate at this location at this time. As conditions change, this location will be re-evaluated.] , ...12 more...
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• JURSIDICTION:
  Inherited
• QUARTER:
  Inherited
• FIELDTECH1:
  Inherited
• FIELDTECH2:
  Inherited
• DM_MAINT:
  Inherited
• LOOP_TYPE:
  Inherited
• REPAIRED:
  Inherited
• LOOP_SIZE:
  Inherited
• CODE_DISTRICT:
  Inherited
Templates:
• Name: EN-Traffic Signal Maintenance
  Description:
  Prototype:
  Transfer_Dept: null
  Transfer: null
  REC_EDIT_MODE: MANUAL
  REC_EDIT_MODE_COMMENTS: null
  X: null
  Y: null
  DIVISION: null
  DEPARTMENT: null
  CATEGORY: null
  INCIDENT_ID: null
  INCIDENT_NUMBER: null
  INCIDENT_TYPE_ID: 10192
  REQUEST_TYPE: null
  REQUEST_STATUS: null
  REQUEST_PRIORITY: Low
  REPORTED_DATE: null
  REQUEST_SUMMARY: null
  SR_CREATION_CHANNEL: null
  CREATED_BY_USER: null
  DAYS_OLD: null
  CREATION_DATE: null
  CREATED_BY: null
  LAST_UPDATE_DATE: null
  UPDATED_BY_USER: null
  LAST_UPDATED_BY: null
  LAST_UPDATE_LOGIN: null
  LAST_MODIFIED_DATE: null
  FOLLOWUP_DATE: null
  NEXT_OPEN_TASK_DATE: null
  JOB_NOTES: null
  REQUEST_NOTES: null
  ASSIGNED_TO: null
  ASSIGNED_DATE: null
  SUPERVISOR: null
  DISPATCH: null
  ISSUED_BY: null
  NOTIFICATION: null
  QAQC_YESNO: null
  QAQC_RATING: null
  SUPERVISOR_APPROVAL: null
  SUPERVISOR_NOTES: null
  RESOLVED_DATE: null
  CLOSE_DATE: null
  TROUBLE_CODE: null
  RESOLUTION_CODE: null
  RESOLUTION_CODE_MEANING: null
  RESOLUTION_SUMMARY: null
  GROUP_NAME: null
  OWNER_NAME: null
  STREET_NAME: null
  ADDRESS1: null
  ADDRESS2: null
  ADDRESS3: null
  CITY: null
  STATE: null
  POSTAL_CODE: null
  PARCEL_ID: null
  ASSET_ID: null
  P_LOCATION_ID: null
  P_PARTY_ID: null
  CONTACT_NAME_FIRST: null
  CONTACT_NAME_LAST: null
  PERSON_ADDRESS1: null
  PERSON_ADDRESS2: null
  PERSON_ADDRESS3: null
  PERSON_STATE: null
  PERSON_CITY: null
  PERSON_ZIP_CODE: null
  MAP_PG: null
  MAP_BLK: null
  GRID_NO: null
  CODE_SUBDISTRICT: null
  TARGET_BLOCK: null
  DRAIN_ZONE: null
  DRAIN_GRID: null
  STREET_ZONE: null
  STREET_GRID: null
  TRAFFIC_ZONE: null
  SWM_AREA: null
  SWM_ZONE: null
  COLLECTION_DAY: null
  SWM_ROUTE: null
  PREM_CODE: null
  CUST_CODE: null
  MLGW_ON: null
  MLGW_STATUS: null
  SWF_RATE: null
  SWF_STATUS: null
  MLGW_CUSTOMER: null
  MLGW_CONTACT1: null
  MLGW_CONTACT2: null
  MLGW_EMAIL: null
  NUMBER_OF_TASKS: null
  LINKED_SR: null
  RELATION: null
  cd_name: null
  cd_desc: null
  sccd_name: null
  sccd_desc: null
  scd_name: null
  scd_desc: null
  neigh_name: null
  neigh_desc: null
  tract_name: null
  tract_desc: null
  voting_name: null
  voting_desc: null
  zip_name: null
  zip_desc: null
  ce_name: null
  ce_desc: null
  cityzone: null
  CONTACT_NAME: null
  CONTACT_EMAIL: null
  CONTACT_PHONE: null
  SCF_URL: null
  SCF_Description: null
  EX_ATTRIBUTE12: null
  X_COORD: null
  Y_COORD: null
  JURSIDICTION: null
  QUARTER: null
  PAY_APPLICATION: null
  SS4: null
  START_TIME: null
  FINISH_TIME: null
  FIELDTECH1: null
  FIELDTECH2: null
  DM_MAINT: null
  UNIT_NUMB: null
  DM_NUMB: null
  EQUIP_NUMB2: null
  DM_NUMB2: null
  LOOP_TYPE: null
  LOOP_NAME: null
  LOOP_ID: null
  REPAIRED: null
  REPAIR_DATE: null
  LOOP_SIZE: null
  Transfer_Notes: null
  OLD_OBJECTID: null
  EQUIP_NUMB: null
  CODE_DISTRICT: null
  ASSET_GUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 10195
Name: EN-Traffic Signal Operation
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• CREATED_BY_USER:
  Inherited
• UPDATED_BY_USER:
  Inherited
• ASSIGNED_TO:
  Inherited
• SUPERVISOR:
  Inherited
• DISPATCH:
  Inherited
• ISSUED_BY:
  Inherited
• QAQC_YESNO:
  Inherited
• QAQC_RATING:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• TROUBLE_CODE:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [ENTM1NC: Present controls are appropriate. No change is warranted] , [ENTM1PL: Changes to improve traffic signal operation at this location are planned and will be scheduled according to its priority with respect to other similar locations.] , [ENTM1REEVAL: An engineering evaluation has indicated traffic signal control is not appropriate at this location at this time. As conditions change, this location will be re-evaluated.] , ...12 more...
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• JURSIDICTION:
  Inherited
• QUARTER:
  Inherited
• FIELDTECH1:
  Inherited
• FIELDTECH2:
  Inherited
• DM_MAINT:
  Inherited
• LOOP_TYPE:
  Inherited
• REPAIRED:
  Inherited
• LOOP_SIZE:
  Inherited
• CODE_DISTRICT:
  Inherited
Templates:
• Name: EN-Traffic Signal Operation
  Description:
  Prototype:
  Transfer_Dept: null
  Transfer: null
  REC_EDIT_MODE: MANUAL
  REC_EDIT_MODE_COMMENTS: null
  X: null
  Y: null
  DIVISION: null
  DEPARTMENT: null
  CATEGORY: null
  INCIDENT_ID: null
  INCIDENT_NUMBER: null
  INCIDENT_TYPE_ID: 10195
  REQUEST_TYPE: null
  REQUEST_STATUS: null
  REQUEST_PRIORITY: Low
  REPORTED_DATE: null
  REQUEST_SUMMARY: null
  SR_CREATION_CHANNEL: null
  CREATED_BY_USER: null
  DAYS_OLD: null
  CREATION_DATE: null
  CREATED_BY: null
  LAST_UPDATE_DATE: null
  UPDATED_BY_USER: null
  LAST_UPDATED_BY: null
  LAST_UPDATE_LOGIN: null
  LAST_MODIFIED_DATE: null
  FOLLOWUP_DATE: null
  NEXT_OPEN_TASK_DATE: null
  JOB_NOTES: null
  REQUEST_NOTES: null
  ASSIGNED_TO: null
  ASSIGNED_DATE: null
  SUPERVISOR: null
  DISPATCH: null
  ISSUED_BY: null
  NOTIFICATION: null
  QAQC_YESNO: null
  QAQC_RATING: null
  SUPERVISOR_APPROVAL: null
  SUPERVISOR_NOTES: null
  RESOLVED_DATE: null
  CLOSE_DATE: null
  TROUBLE_CODE: null
  RESOLUTION_CODE: null
  RESOLUTION_CODE_MEANING: null
  RESOLUTION_SUMMARY: null
  GROUP_NAME: null
  OWNER_NAME: null
  STREET_NAME: null
  ADDRESS1: null
  ADDRESS2: null
  ADDRESS3: null
  CITY: null
  STATE: null
  POSTAL_CODE: null
  PARCEL_ID: null
  ASSET_ID: null
  P_LOCATION_ID: null
  P_PARTY_ID: null
  CONTACT_NAME_FIRST: null
  CONTACT_NAME_LAST: null
  PERSON_ADDRESS1: null
  PERSON_ADDRESS2: null
  PERSON_ADDRESS3: null
  PERSON_STATE: null
  PERSON_CITY: null
  PERSON_ZIP_CODE: null
  MAP_PG: null
  MAP_BLK: null
  GRID_NO: null
  CODE_SUBDISTRICT: null
  TARGET_BLOCK: null
  DRAIN_ZONE: null
  DRAIN_GRID: null
  STREET_ZONE: null
  STREET_GRID: null
  TRAFFIC_ZONE: null
  SWM_AREA: null
  SWM_ZONE: null
  COLLECTION_DAY: null
  SWM_ROUTE: null
  PREM_CODE: null
  CUST_CODE: null
  MLGW_ON: null
  MLGW_STATUS: null
  SWF_RATE: null
  SWF_STATUS: null
  MLGW_CUSTOMER: null
  MLGW_CONTACT1: null
  MLGW_CONTACT2: null
  MLGW_EMAIL: null
  NUMBER_OF_TASKS: null
  LINKED_SR: null
  RELATION: null
  cd_name: null
  cd_desc: null
  sccd_name: null
  sccd_desc: null
  scd_name: null
  scd_desc: null
  neigh_name: null
  neigh_desc: null
  tract_name: null
  tract_desc: null
  voting_name: null
  voting_desc: null
  zip_name: null
  zip_desc: null
  ce_name: null
  ce_desc: null
  cityzone: null
  CONTACT_NAME: null
  CONTACT_EMAIL: null
  CONTACT_PHONE: null
  SCF_URL: null
  SCF_Description: null
  EX_ATTRIBUTE12: null
  X_COORD: null
  Y_COORD: null
  JURSIDICTION: null
  QUARTER: null
  PAY_APPLICATION: null
  SS4: null
  START_TIME: null
  FINISH_TIME: null
  FIELDTECH1: null
  FIELDTECH2: null
  DM_MAINT: null
  UNIT_NUMB: null
  DM_NUMB: null
  EQUIP_NUMB2: null
  DM_NUMB2: null
  LOOP_TYPE: null
  LOOP_NAME: null
  LOOP_ID: null
  REPAIRED: null
  REPAIR_DATE: null
  LOOP_SIZE: null
  Transfer_Notes: null
  OLD_OBJECTID: null
  EQUIP_NUMB: null
  CODE_DISTRICT: null
  ASSET_GUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• SR to Asset (0) -- Related To: ENG_TrafficSignals_Asset_Locations (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata