View In:   ArcGIS Online Map Viewer

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: 14e7ef21db9b446a91a0b36bb59987b3

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: 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:

Fields:

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

Templates:

• Name: COM_311_REQUESTS_OPM
  Description:
  Prototype:
  NEXT_OPEN_TASK_DATE: null
  CE_CATEGORY: null
  Anonymous: null
  ASSET_ID: null
  ASSIGNED_DATE: null
  ASSIGNED_TO: null
  CATEGORY: null
  cd_desc: null
  cd_name: null
  CITY: null
  Closed_Date: null
  CODE_DISTRICT: null
  CODE_SUBDISTRICT: null
  CONTACT_EMAIL: null
  CONTACT_NAME: null
  CONTACT_NAME_FIRST: null
  CONTACT_PHONE: null
  created_date: null
  created_user: null
  DAYS_OLD: null
  DEPARTMENT: null
  DISTRICT: null
  DIVISION: null
  DRAIN_GRID: null
  DRAIN_ZONE: null
  FOLLOWUP_DATE: null
  GROUP_NAME: null
  INCIDENT_ID: null
  INCIDENT_NUMBER: null
  INCIDENT_RESOLVED_DATE: null
  INCIDENT_TYPE_ID: 13750
  JOB_NOTES: null
  last_edited_date: null
  last_edited_user: null
  LINKED_SR: null
  Location_Address: null
  MAP_BLK: null
  MAP_PG: null
  MLGW_CONTACT1: null
  MLGW_CONTACT2: null
  MLGW_CustCode: null
  MLGW_CUSTOMER: null
  MLGW_EMAIL: null
  MLGW_EstDate: null
  MLGW_PremiseCode: null
  MLGW_STATUS: null
  neigh_desc: null
  NOTIFICATION: null
  Owner_City: null
  Owner_Joint_Name: null
  Owner_Location_Address: null
  Owner_Name: null
  Owner_State: null
  Owner_Unit_Address: null
  Owner_Zip: null
  PARCEL_ID: null
  QAQC_RATING: null
  QAQC_YESNO: null
  REPORTED_DATE: null
  REQUEST_NOTES: null
  REQUEST_PRIORITY: null
  REQUEST_STATUS: null
  REQUEST_SUMMARY: null
  REQUEST_TYPE: null
  RESOLUTION_CODE: null
  RESOLUTION_SUMMARY: null
  RESOLVED_DATE: null
  sccd_desc: null
  sccd_name: null
  scd_desc: null
  scd_name: null
  SCF_Description: null
  SCF_URL: null
  STATE: null
  STREET_GRID: null
  STREET_ZONE: null
  SUPERVISOR: null
  SUPERVISOR_APPROVAL: null
  Supervisor_Notes: null
  SWF_RATE: null
  SWF_STATUS: null
  SWM_AREA: null
  SWM_CollectionDay: null
  SWM_ROUTE: null
  SWM_ZONE: null
  TARGET_BLOCK: null
  TRAFFIC_ZONE: null
  Transfer: null
  Transfer_Dept: null
  Transfer_Notes: null
  Transfer_Status: null
  Unit_Address: null
  X: null
  Y: null
  ZipCode: null
  ADDRESS2: null
  NUMBER_OF_TASKS: null
  RESOLUTION_CODE_MEANING: null
  SR_CREATION_CHANNEL: null
  STREET_NAME: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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