Name: All EE Service Requests

Display Field: GROUP_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1e8ab59911a64c4f847ab1fef2796ce6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -90.07604244351387
YMin: -89.90723793208599
XMax: 3.4969241878198385E7
YMax: 7819273.351313978
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: [0, 173, 32, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 32747
  Label: EE-Clean Site
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [95, 60, 163, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 31747
  Label: EE-Illegal Dumping
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [72, 179, 61, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: false
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: true
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 )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: Live Link: Change to MANUAL, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
• DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
• CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
• REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 , Coded Values: [EE-Illegal Dumping: EE-Illegal Dumping] , [EE-Littering: EE-Littering] , [EE-SW Violation: EE-SW Violation] , ...2 more... )
• REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 , Coded Values: [Back to Department: Back to Department] , [Closed: Closed] , [Open: Open] , ...3 more... )
• REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
• REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
• SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 50 )
• CREATED_BY_USER ( type: esriFieldTypeString, alias: Created By, length: 255 , Coded Values: [ROBERT.WITTER: Witter, Robert Devin] , [ANDREW.WILBURN: Wilburn, Andrew] , [MICHAEL.WARD: Ward, Michael Dale Jr] , ...29 more... )
• DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
• CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: Last Updated Date, length: 8 )
• UPDATED_BY_USER ( type: esriFieldTypeString, alias: Updated By, length: 50 , Coded Values: [ROBERT.WITTER: Witter, Robert Devin] , [ANDREW.WILBURN: Wilburn, Andrew] , [MICHAEL.WARD: Ward, Michael Dale Jr] , ...29 more... )
• LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
• LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
• NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
• JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
• REQUEST_NOTES ( type: esriFieldTypeString, alias: Consolidated Notes, length: 2000 )
• ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 , Coded Values: [ROBERT.WITTER: Witter, Robert Devin] , [ANDREW.WILBURN: Wilburn, Andrew] , [MICHAEL.WARD: Ward, Michael Dale Jr] , ...29 more... )
• SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 )
• NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 , Coded Values: [Data To Special Ops: Data To Special Ops] , [Delivered: Delivered] , [Hearing Held: Hearing Held] , ...10 more... )
• QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SUPERVISOR_NOTES ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
• RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
• RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 )
• RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
• RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
• GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 50 )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
• ADDRESS1 ( type: esriFieldTypeString, alias: Location, length: 255 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 100 )
• ADDRESS3 ( type: esriFieldTypeString, alias: ADDRESS3, length: 100 )
• CITY ( type: esriFieldTypeString, alias: City, length: 100 )
• STATE ( type: esriFieldTypeString, alias: State, length: 50 )
• POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
• PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
• P_LOCATION_ID ( type: esriFieldTypeInteger, alias: P_LOCATION_ID )
• P_PARTY_ID ( type: esriFieldTypeInteger, alias: P_PARTY_ID )
• CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
• CONTACT_NAME_LAST ( type: esriFieldTypeString, alias: Owner Name 2, length: 255 )
• PERSON_ADDRESS1 ( type: esriFieldTypeString, alias: Owner Address1, length: 255 )
• PERSON_ADDRESS2 ( type: esriFieldTypeString, alias: Owner Address2, length: 255 )
• PERSON_ADDRESS3 ( type: esriFieldTypeString, alias: Owner Address3, length: 255 )
• PERSON_STATE ( type: esriFieldTypeString, alias: Owner State, length: 50 )
• PERSON_CITY ( type: esriFieldTypeString, alias: Owner City, length: 100 )
• PERSON_ZIP_CODE ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
• CODE_DISTRICT ( type: esriFieldTypeString, alias: Code District, length: 50 )
• CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 , Coded Values: [1-1: 1-1] , [1-2: 1-2] , [1-3: 1-3] , ...35 more... )
• TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 , Coded Values: [1: 1] , [10: 10] , [100: 100] , ...235 more... )
• MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 , Coded Values: [118: 118] , [119: 119] , [120: 120] , ...122 more... )
• MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 , Coded Values: [A: A] , [B: B] , [C: C] , ...14 more... )
• GRID_NO ( type: esriFieldTypeSmallInteger, alias: Grid Number , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
• SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
• COLLECTION_DAY ( type: esriFieldTypeString, alias: Collection Day, length: 20 , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
• SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 10 )
• PREM_CODE ( type: esriFieldTypeInteger, alias: Premise Code )
• CUST_CODE ( type: esriFieldTypeInteger, alias: Customer Code )
• MLGW_ON ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
• MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
• SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 , Coded Values: [C1: Special Class] , [C10: Single Family] , [C10A: Single Family Plus One Cart] , ...77 more... )
• SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 , Coded Values: [A: Active] , [F: Final] , [I: Inactive] , ...1 more... )
• MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
• MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
• MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
• MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
• NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
• LINKED_SR ( type: esriFieldTypeString, alias: Linked SR, length: 50 )
• RELATION ( type: esriFieldTypeString, alias: Relation with SR, length: 50 )
• cd_name ( type: esriFieldTypeInteger, alias: Council District No )
• cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
• sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
• sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
• scd_name ( type: esriFieldTypeInteger, alias: Super District No )
• scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
• neigh_name ( type: esriFieldTypeString, alias: neigh_name, length: 100 )
• neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
• tract_name ( type: esriFieldTypeInteger, alias: Tract Number )
• tract_desc ( type: esriFieldTypeString, alias: Tract, length: 100 )
• voting_name ( type: esriFieldTypeString, alias: voting_name, length: 100 )
• voting_desc ( type: esriFieldTypeString, alias: Voting, length: 100 )
• zip_name ( type: esriFieldTypeInteger, alias: Zip Code No )
• zip_desc ( type: esriFieldTypeString, alias: Zip Code, length: 100 )
• ce_name ( type: esriFieldTypeString, alias: ce_name, length: 100 )
• ce_desc ( type: esriFieldTypeString, alias: ce_desc, length: 100 )
• cityzone ( type: esriFieldTypeString, alias: City Zone, length: 100 )
• CONTACT_NAME ( type: esriFieldTypeString, alias: SCF Name, length: 100 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: SCF Email, length: 100 )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: SCF Phone, length: 50 )
• SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
• SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
• EX_ATTRIBUTE12 ( type: esriFieldTypeString, alias: EX_ATTRIBUTE12, length: 100 )
• Case_Number ( type: esriFieldTypeString, alias: Case Number, length: 50 )
• Initial_InspDate ( type: esriFieldTypeDate, alias: Initial Inspection Date, length: 8 )
• Mailer_Date ( type: esriFieldTypeDate, alias: Mailer Date, length: 8 )
• Latest_InspDate ( type: esriFieldTypeDate, alias: Last Inspection date, length: 8 )
• Summons_Date ( type: esriFieldTypeDate, alias: Summons Date, length: 8 )
• NPA_Assigned_To ( type: esriFieldTypeString, alias: NPA Assigned To, length: 50 )
• NPA_PreCourt_Inspection_Date ( type: esriFieldTypeDate, alias: NPA PreCourt Inspection Date, length: 8 )
• NPA_Inspect_Summary ( type: esriFieldTypeString, alias: NPA Inspection Summary, length: 1000 )
• NPA_Inspect_Resolved_Date ( type: esriFieldTypeDate, alias: NPA Inspection Resolved Date, length: 8 )
• CivilWarrant ( type: esriFieldTypeInteger, alias: Civil Warrant )
• Court_Date ( type: esriFieldTypeDate, alias: Court Date, length: 8 )
• NextCourtDate ( type: esriFieldTypeDate, alias: Next Court Date, length: 8 )
• Court_AssignedTo ( type: esriFieldTypeString, alias: Court Assigned To, length: 50 , Coded Values: [Alexandra Francis: Alexandra Francis] , [Brittany Williams: Brittany Williams] , [City Prosecutor: City Prosecutor] , ...19 more... )
• Court_Status ( type: esriFieldTypeString, alias: Court Status, length: 50 , Coded Values: [Demo: Demo] , [Dev Plan: Dev Plan] , [Dismissed: Dismissed] , ...11 more... )
• Court_Property_Owner ( type: esriFieldTypeString, alias: Court Property Owner, length: 100 )
• TireShop_GUID ( type: esriFieldTypeGUID, alias: TireShop_GUID, length: 38 )
• Business_Name ( type: esriFieldTypeString, alias: Tire Shop Name, length: 255 )
• TireShop_Status ( type: esriFieldTypeString, alias: Tire Shop Status, length: 50 , Coded Values: [Active: Active] , [Closed: Closed] , [Nonqualified: Nonqualified] )
• TirePermit_No ( type: esriFieldTypeString, alias: Permit Number, length: 50 )
• TirePermit_Date ( type: esriFieldTypeDate, alias: Permit Date, length: 8 )
• CertCompliance_Date ( type: esriFieldTypeDate, alias: Cert. Compliance Date, length: 8 )
• Business_Lic ( type: esriFieldTypeString, alias: Business Lic., length: 50 )
• Hauling_Permit ( type: esriFieldTypeString, alias: Hauling Permit, length: 50 )
• Disposal_Manifest ( type: esriFieldTypeString, alias: Disposal Manifest, length: 50 )
• Tire_Count ( type: esriFieldTypeInteger, alias: Current Tire Count )
• Storage_Space ( type: esriFieldTypeString, alias: Storage Space, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• Tireshop_Type ( type: esriFieldTypeString, alias: Tire Shop Type, length: 50 )
• QAQC_RATING ( type: esriFieldTypeDouble, alias: QA/QC Rating , Coded Values: [1: Good - 1] , [2: Fair - 2] , [3: Fair - 3] , ...2 more... )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Transfer ( type: esriFieldTypeString, alias: Is Transferring, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 )
• Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )
• Number_Closing_Pics_Taken ( type: esriFieldTypeSmallInteger, alias: Number Closing Pics Taken , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )

Types:

ID: 31747
Name: EE-Illegal Dumping
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_TYPE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• CREATED_BY_USER:
  Inherited
• UPDATED_BY_USER:
  Inherited
• ASSIGNED_TO:
  Inherited
• NOTIFICATION:
  Inherited
• QAQC_YESNO:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [BACK TO MCSC: BACK TO MCSC] , [CIT_ATT1: CIT_ATT1] , [CIT_ATT2: CIT_ATT2] , ...28 more...
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• Court_AssignedTo:
  Inherited
• Court_Status:
  Inherited
• TireShop_Status:
  Inherited
• Storage_Space:
  Inherited
• QAQC_RATING:
  Inherited

---

ID: 32747
Name: EE-Clean Site
Domains:
• REC_EDIT_MODE:
  Inherited
• REQUEST_TYPE:
  Inherited
• REQUEST_STATUS:
  Inherited
• REQUEST_PRIORITY:
  Inherited
• CREATED_BY_USER:
  Inherited
• UPDATED_BY_USER:
  Inherited
• ASSIGNED_TO:
  Inherited
• NOTIFICATION:
  Inherited
• QAQC_YESNO:
  Inherited
• SUPERVISOR_APPROVAL:
  Inherited
• RESOLUTION_CODE:
  Coded Values: [CLEANED: CLEANED] , [CU_SW: CU_SW] , [CU_GS: CU_GS] , ...5 more...
• CODE_SUBDISTRICT:
  Inherited
• TARGET_BLOCK:
  Inherited
• MAP_PG:
  Inherited
• MAP_BLK:
  Inherited
• GRID_NO:
  Inherited
• SWM_AREA:
  Inherited
• SWM_ZONE:
  Inherited
• COLLECTION_DAY:
  Inherited
• MLGW_STATUS:
  Inherited
• SWF_RATE:
  Inherited
• SWF_STATUS:
  Inherited
• Court_AssignedTo:
  Inherited
• Court_Status:
  Inherited
• TireShop_Status:
  Inherited
• Storage_Space:
  Inherited
• QAQC_RATING:
  Inherited

---

Relationships:

• CODECREATOR.PW_EnvEnforcement_Suspects (0) -- Related To: All EE Suspects (1)
• CODECREATOR.PW_EnvEnforcement_Suspects (1) -- Related To: Active EE Suspects (3)
• CODECREATOR.PW_EnvEnforcement_Suspects (2) -- Related To: Follow Up - Suspects (6)
• CODECREATOR.PW_EnvEnforcement_Suspects (3) -- Related To: Follow Up Pass Due - Suspects (8)
• CODECREATOR.PW_EnvEnforcement_Suspects (4) -- Related To: Follow Up - Suspects - This week (12)
• CODECREATOR.PW_EnvEnforcement_Suspects (5) -- Related To: Follow Up - Suspects - Today (13)
• PW_Code_EnvEnf_CourtCases (21) -- Related To: EE Court Cases (16)
• Tire Shops (9) -- Related To: EE Tireshop Locations (9)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata