Name: COM_311_REQUESTS_OPM

Display Field: CONTACT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This Feature class is created for the purpose of housing all 311 requests created by 311 Support center staff and citizens.

Service Item Id: bb0167c891574976b1474e0e3bd44efd

Copyright Text: Allworld Project Management, LLC 60 N. BB King Blvd Memphis, TN 38103 https://allworldpm.com

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: -6.446010433784268E7
YMin: -1.326952937027444E7
XMax: 5.3920631647915214E7
YMax: 3.641184469033514E7
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [48, 0, 150, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Anonymous ( type: esriFieldTypeString, alias: Stay Anonymous, length: 5 )
• ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
• ASSIGNED_DATE ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
• ASSIGNED_TO ( type: esriFieldTypeString, alias: Assigned To, length: 50 )
• CATEGORY ( type: esriFieldTypeString, alias: Category, length: 50 )
• cd_desc ( type: esriFieldTypeString, alias: Council District, length: 100 )
• cd_name ( type: esriFieldTypeInteger, alias: Council District No )
• CITY ( type: esriFieldTypeString, alias: City, length: 100 )
• Closed_Date ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
• CODE_DISTRICT ( type: esriFieldTypeSmallInteger, alias: Code District )
• CODE_SUBDISTRICT ( type: esriFieldTypeString, alias: Code Sub-District, length: 50 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: Contact Email, length: 100 )
• CONTACT_NAME ( type: esriFieldTypeString, alias: Contact Name, length: 100 )
• CONTACT_NAME_FIRST ( type: esriFieldTypeString, alias: Owner Name, length: 255 )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: Contact Phone, length: 50 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• DAYS_OLD ( type: esriFieldTypeSmallInteger, alias: Days Old )
• DEPARTMENT ( type: esriFieldTypeString, alias: Department, length: 150 )
• DISTRICT ( type: esriFieldTypeInteger, alias: DISTRICT )
• DIVISION ( type: esriFieldTypeString, alias: Division, length: 150 )
• DRAIN_GRID ( type: esriFieldTypeString, alias: Drain Grid, length: 50 )
• DRAIN_ZONE ( type: esriFieldTypeString, alias: Drain Zone, length: 50 )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
• GROUP_NAME ( type: esriFieldTypeString, alias: GROUP_NAME, length: 50 )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: Incident ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: Service Request Number, length: 15 )
• INCIDENT_RESOLVED_DATE ( type: esriFieldTypeInteger, alias: INCIDENT_RESOLVED_DATE )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: Service Request Type ID )
• JOB_NOTES ( type: esriFieldTypeString, alias: Job Notes, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• LINKED_SR ( type: esriFieldTypeString, alias: Duplicate SR, length: 50 )
• Location_Address ( type: esriFieldTypeString, alias: Location, length: 255 )
• MAP_BLK ( type: esriFieldTypeString, alias: Map Block, length: 50 )
• MAP_PG ( type: esriFieldTypeString, alias: Map Page, length: 50 )
• MLGW_CONTACT1 ( type: esriFieldTypeString, alias: MLGW Contact 1, length: 25 )
• MLGW_CONTACT2 ( type: esriFieldTypeString, alias: MLGW Contact 2, length: 25 )
• MLGW_CustCode ( type: esriFieldTypeInteger, alias: Customer Code )
• MLGW_CUSTOMER ( type: esriFieldTypeString, alias: MLGW Customer, length: 255 )
• MLGW_EMAIL ( type: esriFieldTypeString, alias: MLGW Contact Email, length: 100 )
• MLGW_EstDate ( type: esriFieldTypeString, alias: MLGW Est Date, length: 25 )
• MLGW_PremiseCode ( type: esriFieldTypeInteger, alias: Premise Code )
• MLGW_STATUS ( type: esriFieldTypeString, alias: MLGW Acct. Status, length: 25 )
• neigh_desc ( type: esriFieldTypeString, alias: Neighborhood Name, length: 100 )
• NOTIFICATION ( type: esriFieldTypeString, alias: Notification To, length: 50 )
• Owner_City ( type: esriFieldTypeString, alias: Owner City, length: 100 )
• Owner_Joint_Name ( type: esriFieldTypeString, alias: Owner Name 2, length: 255 )
• Owner_Location_Address ( type: esriFieldTypeString, alias: Owner Location Address, length: 255 )
• Owner_Name ( type: esriFieldTypeString, alias: OWNER_NAME, length: 50 )
• Owner_State ( type: esriFieldTypeString, alias: Owner State, length: 50 )
• Owner_Unit_Address ( type: esriFieldTypeString, alias: Owner Unit Address, length: 255 )
• Owner_Zip ( type: esriFieldTypeString, alias: Owner Zip Code, length: 50 )
• PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 20 )
• QAQC_RATING ( type: esriFieldTypeInteger, alias: QA/QC Rating )
• QAQC_YESNO ( type: esriFieldTypeString, alias: QA/QC, length: 50 )
• REPORTED_DATE ( type: esriFieldTypeDate, alias: Reported Date, length: 8 )
• REQUEST_NOTES ( type: esriFieldTypeString, alias: Request Notes, length: 2000 )
• REQUEST_PRIORITY ( type: esriFieldTypeString, alias: Service Request Priority, length: 15 )
• REQUEST_STATUS ( type: esriFieldTypeString, alias: Service Request Status, length: 20 )
• REQUEST_SUMMARY ( type: esriFieldTypeString, alias: Service Request Summary, length: 2000 )
• REQUEST_TYPE ( type: esriFieldTypeString, alias: Service Request Type, length: 50 )
• RESOLUTION_CODE ( type: esriFieldTypeString, alias: Resolution Code, length: 100 )
• RESOLUTION_SUMMARY ( type: esriFieldTypeString, alias: Resolution Summary, length: 2000 )
• RESOLVED_DATE ( type: esriFieldTypeDate, alias: Resolved Date, length: 8 )
• sccd_desc ( type: esriFieldTypeString, alias: Shelby Co. Council District, length: 100 )
• sccd_name ( type: esriFieldTypeInteger, alias: Shelby Co. Council No )
• scd_desc ( type: esriFieldTypeString, alias: Super Council District, length: 100 )
• scd_name ( type: esriFieldTypeInteger, alias: Super District No )
• SCF_Description ( type: esriFieldTypeString, alias: SeeClickFix Description, length: 2000 )
• SCF_URL ( type: esriFieldTypeString, alias: SeeClickFix URL, length: 1000 )
• STATE ( type: esriFieldTypeString, alias: State, length: 50 )
• STREET_GRID ( type: esriFieldTypeString, alias: Street Grid, length: 50 )
• STREET_ZONE ( type: esriFieldTypeString, alias: Street Zone, length: 50 )
• SUPERVISOR ( type: esriFieldTypeString, alias: Supervisor, length: 50 )
• SUPERVISOR_APPROVAL ( type: esriFieldTypeString, alias: Supervisor Approval, length: 20 )
• Supervisor_Notes ( type: esriFieldTypeString, alias: Supervisor Notes, length: 255 )
• SWF_RATE ( type: esriFieldTypeString, alias: SWM Fee Rate, length: 10 )
• SWF_STATUS ( type: esriFieldTypeString, alias: SWM Fee Status, length: 10 )
• SWM_AREA ( type: esriFieldTypeString, alias: SWM Area, length: 10 )
• SWM_CollectionDay ( type: esriFieldTypeString, alias: Collection Day, length: 20 )
• SWM_ROUTE ( type: esriFieldTypeString, alias: SWM Route, length: 50 )
• SWM_ZONE ( type: esriFieldTypeString, alias: SWM Zone, length: 10 )
• TARGET_BLOCK ( type: esriFieldTypeString, alias: Target Block, length: 50 )
• TRAFFIC_ZONE ( type: esriFieldTypeString, alias: Traffic Zone, length: 50 )
• Transfer ( type: esriFieldTypeString, alias: Transfer Needed, length: 5 )
• Transfer_Dept ( type: esriFieldTypeString, alias: Transferring To, length: 150 )
• Transfer_Notes ( type: esriFieldTypeString, alias: Transfer Justification, length: 2000 )
• Transfer_Status ( type: esriFieldTypeString, alias: Transfer Status, length: 50 )
• Unit_Address ( type: esriFieldTypeString, alias: Unit, length: 100 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, length: 255 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 255 )
• NUMBER_OF_TASKS ( type: esriFieldTypeInteger, alias: NUMBER_OF_TASKS )
• RESOLUTION_CODE_MEANING ( type: esriFieldTypeString, alias: RESOLUTION_CODE_MEANING, length: 255 )
• SR_CREATION_CHANNEL ( type: esriFieldTypeString, alias: SR_CREATION_CHANNEL, length: 255 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 255 )
• NEXT_OPEN_TASK_DATE ( type: esriFieldTypeDate, alias: NEXT_OPEN_TASK_DATE, length: 8 )
• CE_CATEGORY ( type: esriFieldTypeString, alias: CE_CATEGORY1, length: 100 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

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

  Iteminfo   Thumbnail   Metadata