20210802 17012400 1.0 FALSE PW_Code_EnvEnf_ServiceRequests 002 722965.364655 34969241.878198 263283.500069 2204554.130644 1 Relationship Relationship Relationship Relationship PW_Code_EnvEnf_TireShops_SR_Relationship Relationship Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.5'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Tennessee_FIPS_4100_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1968500.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-86.0],PARAMETER[&quot;Standard_Parallel_1&quot;,35.25],PARAMETER[&quot;Standard_Parallel_2&quot;,36.41666666666666],PARAMETER[&quot;Latitude_Of_Origin&quot;,34.33333333333334],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2274]]</WKT><XOrigin>-121521300</XOrigin><YOrigin>-93934000</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102736</WKID><LatestWKID>2274</LatestWKID></ProjectedCoordinateSystem> 20230118 14442800 20230118 14442800 Version 6.2 (Build 9200) ; Esri ArcGIS 10.5.1.7333 PW_Code_EnvEnf_ServiceRequests 1 -90.453679 -0.000020 40.383072 -2.862573 Feature Class dataset EPSG 5.3(9.0.0) 11614 Simple FALSE 11614 TRUE FALSE PW_Code_EnvEnf_ServiceRequests Feature Class 11614 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. REC_EDIT_MODE Live Link: Change to MANUAL String 50 0 0 REC_EDIT_MODE_COMMENTS REC_EDIT_MODE_COMMENTS String 255 0 0 X X Double 8 38 8 Y Y Double 8 38 8 DIVISION Division String 150 0 0 DEPARTMENT Department String 150 0 0 CATEGORY Category String 50 0 0 INCIDENT_ID Oracle ID Integer 4 10 0 INCIDENT_NUMBER Service Request Number String 15 0 0 INCIDENT_TYPE_ID Service Request Type ID Integer 4 10 0 REQUEST_TYPE Service Request Type String 50 0 0 REQUEST_STATUS Service Request Status String 20 0 0 REQUEST_PRIORITY Service Request Priority String 15 0 0 REPORTED_DATE Reported Date Date 8 0 0 REQUEST_SUMMARY Service Request Summary String 2000 0 0 SR_CREATION_CHANNEL SR_CREATION_CHANNEL String 50 0 0 CREATED_BY_USER Created By String 255 0 0 DAYS_OLD Days Old SmallInteger 2 5 0 CREATION_DATE Creation Date Date 8 0 0 CREATED_BY CREATED_BY Integer 4 10 0 LAST_UPDATE_DATE Last Updated Date Date 8 0 0 UPDATED_BY_USER Updated By String 50 0 0 LAST_UPDATED_BY LAST_UPDATED_BY Integer 4 10 0 LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN Integer 4 10 0 LAST_MODIFIED_DATE LAST_MODIFIED_DATE Date 8 0 0 FOLLOWUP_DATE Follow Up Date Date 8 0 0 NEXT_OPEN_TASK_DATE NEXT_OPEN_TASK_DATE Date 8 0 0 JOB_NOTES Job Notes String 255 0 0 REQUEST_NOTES Consolidated Notes String 2000 0 0 ASSIGNED_TO Assigned To String 50 0 0 SUPERVISOR Supervisor String 50 0 0 NOTIFICATION Notification To String 50 0 0 QAQC_YESNO QA/QC String 50 0 0 QAQC_RATING QA/QC Rating Double 8 38 8 SUPERVISOR_APPROVAL Supervisor Approval String 5 0 0 SUPERVISOR_NOTES Supervisor Notes String 255 0 0 RESOLVED_DATE Resolved Date Date 8 0 0 CLOSE_DATE Closed Date Date 8 0 0 RESOLUTION_CODE Resolution Code String 100 0 0 RESOLUTION_CODE_MEANING RESOLUTION_CODE_MEANING String 255 0 0 RESOLUTION_SUMMARY Resolution Summary String 2000 0 0 GROUP_NAME GROUP_NAME String 50 0 0 OWNER_NAME OWNER_NAME String 50 0 0 STREET_NAME STREET_NAME String 100 0 0 ADDRESS1 Location String 255 0 0 ADDRESS2 ADDRESS2 String 100 0 0 ADDRESS3 ADDRESS3 String 100 0 0 CITY City String 100 0 0 STATE State String 50 0 0 POSTAL_CODE Postal Code String 20 0 0 PARCEL_ID Parcel ID String 20 0 0 P_LOCATION_ID P_LOCATION_ID Integer 4 10 0 P_PARTY_ID P_PARTY_ID Integer 4 10 0 CONTACT_NAME_FIRST Owner Name String 255 0 0 CONTACT_NAME_LAST Owner Name 2 String 255 0 0 PERSON_ADDRESS1 Owner Address1 String 255 0 0 PERSON_ADDRESS2 Owner Address2 String 255 0 0 PERSON_ADDRESS3 Owner Address3 String 255 0 0 PERSON_STATE Owner State String 50 0 0 PERSON_CITY Owner City String 100 0 0 PERSON_ZIP_CODE Owner Zip Code String 50 0 0 CODE_DISTRICT Code District String 50 0 0 CODE_SUBDISTRICT Code Sub-District String 50 0 0 TARGET_BLOCK Target Block String 50 0 0 MAP_PG Map Page String 50 0 0 MAP_BLK Map Block String 50 0 0 GRID_NO Grid Number SmallInteger 2 5 0 SWM_AREA SWM Area String 10 0 0 SWM_ZONE SWM Zone String 10 0 0 COLLECTION_DAY Collection Day String 20 0 0 SWM_ROUTE SWM Route String 10 0 0 PREM_CODE Premise Code Integer 4 10 0 CUST_CODE Customer Code Integer 4 10 0 MLGW_ON MLGW Est Date String 25 0 0 MLGW_STATUS MLGW Acct. Status String 25 0 0 SWF_RATE SWM Fee Rate String 10 0 0 SWF_STATUS SWM Fee Status String 10 0 0 MLGW_CUSTOMER MLGW Customer String 255 0 0 MLGW_CONTACT1 MLGW Contact 1 String 25 0 0 MLGW_CONTACT2 MLGW Contact 2 String 25 0 0 MLGW_EMAIL MLGW Contact Email String 100 0 0 NUMBER_OF_TASKS NUMBER_OF_TASKS Integer 4 10 0 LINKED_SR Linked SR String 50 0 0 RELATION Relation with SR String 50 0 0 cd_name Council District No Integer 4 10 0 cd_desc Council District String 100 0 0 sccd_name Shelby Co. Council No Integer 4 10 0 sccd_desc Shelby Co. Council District String 100 0 0 scd_name Super District No Integer 4 10 0 scd_desc Super Council District String 100 0 0 neigh_name neigh_name String 100 0 0 neigh_desc Neighborhood Name String 100 0 0 tract_name Tract Number Integer 4 10 0 tract_desc Tract String 100 0 0 voting_name voting_name String 100 0 0 voting_desc Voting String 100 0 0 zip_name Zip Code No Integer 4 10 0 zip_desc Zip Code String 100 0 0 ce_name ce_name String 100 0 0 ce_desc ce_desc String 100 0 0 cityzone City Zone String 100 0 0 CONTACT_NAME SCF Name String 100 0 0 CONTACT_EMAIL SCF Email String 100 0 0 CONTACT_PHONE SCF Phone String 50 0 0 SCF_URL SeeClickFix URL String 1000 0 0 SCF_Description SeeClickFix Description String 2000 0 0 EX_ATTRIBUTE12 EX_ATTRIBUTE12 String 100 0 0 Case_Number Case Number String 50 0 0 Initial_InspDate Initial Inspection Date Date 8 0 0 Mailer_Date Mailer Date Date 8 0 0 Latest_InspDate Last Inspection date Date 8 0 0 Summons_Date Summons Date Date 8 0 0 NPA_Assigned_To NPA Assigned To String 50 0 0 NPA_PreCourt_Inspection_Date NPA PreCourt Inspection Date Date 8 0 0 NPA_Inspect_Summary NPA Inspection Summary String 1000 0 0 NPA_Inspect_Resolved_Date NPA Inspection Resolved Date Date 8 0 0 CivilWarrant Civil Warrant Integer 4 10 0 Court_Date Court Date Date 8 0 0 NextCourtDate Next Court Date Date 8 0 0 Court_AssignedTo Court Assigned To String 50 0 0 Court_Status Court Status String 50 0 0 Court_Property_Owner Court Property Owner String 100 0 0 TireShop_GUID TireShop_GUID GUID 38 0 0 Business_Name Tire Shop Name String 255 0 0 TireShop_Status Tire Shop Status String 50 0 0 TirePermit_No Permit Number String 50 0 0 TirePermit_Date Permit Date Date 8 0 0 CertCompliance_Date Cert. Compliance Date Date 8 0 0 Business_Lic Business Lic. String 50 0 0 Hauling_Permit Hauling Permit String 50 0 0 Disposal_Manifest Disposal Manifest String 50 0 0 Tire_Count Current Tire Count Integer 4 10 0 Storage_Space Storage Space String 50 0 0 Tireshop_Type Tire Shop Type String 50 0 0 SHAPE Shape Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. X_COORD X_COORD Double 8 38 8 Y_COORD Y_COORD Double 8 38 8 EE-Illegal Dumping 31747 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value CODECREATOR String REQUEST_TYPE EE-Illegal Dumping EE_RequestTypes Description Coded Value Default value Default value CODECREATOR String REQUEST_STATUS Open REQUEST_STATUS Solid Waste REQUEST_STATUS Coded Value Default value Default value CODECREATOR String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value CODECREATOR String CREATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value CODECREATOR String UPDATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value CODECREATOR String ASSIGNED_TO EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value CODECREATOR String NOTIFICATION Code_Notification Determines whether VO was mailed by data staff or delivered by inspector Coded Value Default value Default value CODECREATOR String QAQC_YESNO YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value CODECREATOR String SUPERVISOR_APPROVAL YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value CODECREATOR String RESOLUTION_CODE EE_Res_IllegalDumping EE_Res_IllegalDumping Coded Value Default value Default value CODECREATOR String CODE_SUBDISTRICT CE_SubDistricts Code Grounds Services CE_SubDistricts Coded Value Default value Default value CODECREATOR String TARGET_BLOCK CE_TargetBlocks Code Grounds Services CE_TargetBlocks Coded Value Default value Default value CODECREATOR String MAP_PG MAP_PG Environmental Enforcement MAP_PG Coded Value Default value Default value CODECREATOR String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value CODECREATOR String GRID_NO GRID_NO Environmental Enforcement GRID_NO Coded Value Default value Default value CODECREATOR SmallInteger SWM_AREA SWM_AREA Environmental Enforcement SWM_AREA Coded Value Default value Default value CODECREATOR String SWM_ZONE SWM_ZONE Environmental Enforcement SWM_ZONE Coded Value Default value Default value CODECREATOR String COLLECTION_DAY SWM_COLLECTION_DAY Environmental Enforcement SWM_COLLECTION_DAY Coded Value Default value Default value CODECREATOR String MLGW_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value CODECREATOR String SWF_RATE MLGW_SWF_RATE Environmental Enforcement MLGW_SWF_RATE Coded Value Default value Default value CODECREATOR String SWF_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value CODECREATOR String Court_AssignedTo Code_MemphisFightsBlightAssignedTo Memphis Fights Blight Assigned To Coded Value Default value Default value CODECREATOR String Court_Status Code_MemphisFightsBlightStatus Memphis Fights Blight Status Coded Value Default value Default value CODECREATOR String TireShop_Status Code_TireShopStatus Tire Shop Status Coded Value Default value Default value CODECREATOR String Storage_Space YesNoNA_String Environmental Enforcement YesNoNA_String Coded Value Default value Default value CODECREATOR String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value CODECREATOR Integer EE-Clean Site 32747 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value CODECREATOR String REQUEST_TYPE EE-Tire Shop Inspection EE_RequestTypes Description Coded Value Default value Default value CODECREATOR String REQUEST_STATUS REQUEST_STATUS Solid Waste REQUEST_STATUS Coded Value Default value Default value CODECREATOR String Open REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value CODECREATOR String CREATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value CODECREATOR String UPDATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value CODECREATOR String ASSIGNED_TO EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value CODECREATOR String NOTIFICATION Code_Notification Determines whether VO was mailed by data staff or delivered by inspector Coded Value Default value Default value CODECREATOR String QAQC_YESNO YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value CODECREATOR String SUPERVISOR_APPROVAL YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value CODECREATOR String RESOLUTION_CODE EE_Res_CleanSite EE_Res_CleanSite Coded Value Default value Default value CODECREATOR String CODE_SUBDISTRICT CE_SubDistricts Code Grounds Services CE_SubDistricts Coded Value Default value Default value CODECREATOR String TARGET_BLOCK CE_TargetBlocks Code Grounds Services CE_TargetBlocks Coded Value Default value Default value CODECREATOR String MAP_PG MAP_PG Environmental Enforcement MAP_PG Coded Value Default value Default value CODECREATOR String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value CODECREATOR String GRID_NO GRID_NO Environmental Enforcement GRID_NO Coded Value Default value Default value CODECREATOR SmallInteger SWM_AREA SWM_AREA Environmental Enforcement SWM_AREA Coded Value Default value Default value CODECREATOR String SWM_ZONE SWM_ZONE Environmental Enforcement SWM_ZONE Coded Value Default value Default value CODECREATOR String COLLECTION_DAY SWM_COLLECTION_DAY Environmental Enforcement SWM_COLLECTION_DAY Coded Value Default value Default value CODECREATOR String MLGW_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value CODECREATOR String SWF_RATE MLGW_SWF_RATE Environmental Enforcement MLGW_SWF_RATE Coded Value Default value Default value CODECREATOR String SWF_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value CODECREATOR String Court_AssignedTo Code_MemphisFightsBlightAssignedTo Memphis Fights Blight Assigned To Coded Value Default value Default value CODECREATOR String Court_Status Code_MemphisFightsBlightStatus Memphis Fights Blight Status Coded Value Default value Default value CODECREATOR String TireShop_Status Code_TireShopStatus Tire Shop Status Coded Value Default value Default value CODECREATOR String Storage_Space YesNoNA_String Environmental Enforcement YesNoNA_String Coded Value Default value Default value CODECREATOR String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value CODECREATOR Integer EE-SW Violation 27749 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE EE-SW Violation EE_RequestTypes Description Coded Value Default value Default value String REQUEST_STATUS REQUEST_STATUS Solid Waste REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value String UPDATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value String ASSIGNED_TO EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value String NOTIFICATION Code_Notification Determines whether VO was mailed by data staff or delivered by inspector Coded Value Default value Default value String QAQC_YESNO YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value String SUPERVISOR_APPROVAL YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value String RESOLUTION_CODE EE_Rescodes EE_Rescodes Coded Value Default value Default value String CODE_SUBDISTRICT CE_SubDistricts Code Grounds Services CE_SubDistricts Coded Value Default value Default value String TARGET_BLOCK CE_TargetBlocks Code Grounds Services CE_TargetBlocks Coded Value Default value Default value String MAP_PG MAP_PG Environmental Enforcement MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO Environmental Enforcement GRID_NO Coded Value Default value Default value SmallInteger SWM_AREA SWM_AREA Environmental Enforcement SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE Environmental Enforcement SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY Environmental Enforcement SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE Environmental Enforcement MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value String Court_AssignedTo Code_MemphisFightsBlightAssignedTo Memphis Fights Blight Assigned To Coded Value Default value Default value String Court_Status Code_MemphisFightsBlightStatus Memphis Fights Blight Status Coded Value Default value Default value String TireShop_Status Code_TireShopStatus Tire Shop Status Coded Value Default value Default value String Storage_Space YesNoNA_String Environmental Enforcement YesNoNA_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer EE-Illegal Dumping 31747 REC_EDIT_MODE MANUAL REC_EDIT_MODE Record Editing Mode Coded Value Default value Default value String REQUEST_TYPE EE-Illegal Dumping EE_RequestTypes Description Coded Value Default value Default value String REQUEST_STATUS Open REQUEST_STATUS Solid Waste REQUEST_STATUS Coded Value Default value Default value String REQUEST_PRIORITY Low REQUEST_PRIORITY REQUEST_PRIORITY Coded Value Default value Default value String CREATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value String UPDATED_BY_USER EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value String ASSIGNED_TO EE_Inspectors Environmental Enforcement Investigators Coded Value Default value Default value String NOTIFICATION Code_Notification Determines whether VO was mailed by data staff or delivered by inspector Coded Value Default value Default value String QAQC_YESNO YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value String SUPERVISOR_APPROVAL YesNo_String Environmental Enforcement YesNo_String Coded Value Default value Default value String RESOLUTION_CODE EE_Rescodes EE_Rescodes Coded Value Default value Default value String CODE_SUBDISTRICT CE_SubDistricts Code Grounds Services CE_SubDistricts Coded Value Default value Default value String TARGET_BLOCK CE_TargetBlocks Code Grounds Services CE_TargetBlocks Coded Value Default value Default value String MAP_PG MAP_PG Environmental Enforcement MAP_PG Coded Value Default value Default value String MAP_BLK MAP_BLK MAP_BLK Coded Value Default value Default value String GRID_NO GRID_NO Environmental Enforcement GRID_NO Coded Value Default value Default value SmallInteger SWM_AREA SWM_AREA Environmental Enforcement SWM_AREA Coded Value Default value Default value String SWM_ZONE SWM_ZONE Environmental Enforcement SWM_ZONE Coded Value Default value Default value String COLLECTION_DAY SWM_COLLECTION_DAY Environmental Enforcement SWM_COLLECTION_DAY Coded Value Default value Default value String MLGW_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value String SWF_RATE MLGW_SWF_RATE Environmental Enforcement MLGW_SWF_RATE Coded Value Default value Default value String SWF_STATUS MLGW_STATUS Environmental Enforcement MLGW_STATUS Coded Value Default value Default value String Court_AssignedTo Code_MemphisFightsBlightAssignedTo Memphis Fights Blight Assigned To Coded Value Default value Default value String Court_Status Code_MemphisFightsBlightStatus Memphis Fights Blight Status Coded Value Default value Default value String TireShop_Status Code_TireShopStatus Tire Shop Status Coded Value Default value Default value String Storage_Space YesNoNA_String Environmental Enforcement YesNoNA_String Coded Value Default value Default value String QAQC_RATING Rating_Integer Rating_Integer Coded Value Default value Default value Integer created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 GlobalID GlobalID GlobalID 38 0 0 20230118