Introduction

The following document is modeled after the article by Sunil Ray. The following are the 10 SQL operations that Ray performed:

  1. View Data

  2. Sort Data

  3. Filter Data

  4. Delete Records

  5. Add Records

  6. Update Data in Existing Record

  7. Show Unique Values

  8. Write an expression to generate a new column

  9. Look Up data from another table

  10. Pivot Table


Please note: More than 10 operations have been performed using R and/or SQL.



Replicate the R code

Install the packages

Note: If you wish to replicate the R code below, then you will need to copy and paste the following command in R first to make sure you have all the packages and their dependencies installed:

install.packages(c("install.load", "iemisc", "dplyr", "lubridate", "sqldf", "stringi", "data.table", "ggplot2", "rpivotTable", "pander", "pivottabler", "ExcelFunctionsR", "magrittr", "mgsub"))
# install the install.load package



Load the packages

Note: If you wish to replicate the R code below, then you will need to copy and paste the following commands in R first to make sure you have all the packages loaded:

install.load::load_package("iemisc", "dplyr", "lubridate", "sqldf", "stringi", "data.table",
    "ggplot2", "rpivotTable", "pander", "pivottabler", "ExcelFunctionsR", "magrittr",
    "mgsub")
# load needed packages using the load_package function from the install.load
# package (it is assumed that you have already installed these packages)



# set the pander options
panderOptions("table.continues", "")
panderOptions("table.caption.prefix", "")
panderOptions("missing", "")
# set pander options to have missing values in the tables as blank cells



Import the Data

The data set is all of the records of the Solid Waste Management Permits as part of the dataviewer application

Please note that the answers are truncated using head (first 6 rows) or tail (last 6 rows) to reduce the output size.

# prepare the data for analysis read in the file using fread
permit <- fread("https://www.ecoccs.com/R_Examples/SWM_Permits.csv")
# TDEC

# change the last column to Date class
change_class <- names(permit)[ncol(permit)]
for (col in change_class) set(permit, j = col, value = mdy(permit[[col]]))  # Source 1


# make all column names correct (no spaces between words, etc.)
setnames(permit, make.names(colnames(permit)))


# change all names to Title Case for the city names
change_classer <- "City"

for (col in change_classer) set(permit, j = col, value = stri_trans_totitle(permit[[col]]))
# Source 1


# change Mcminnville to McMinnville
permit$City <- mgsub(permit$City, "Mcminnville", "McMinnville")



Perform SQL and R operations on the data


Note: The following examples have the R code first followed by the equivalent code using SQL via the R package sqldf

1) View all data of the permit table

# R
pander(head(permit))
Facility Permit.Number Permit.Type Status
W. Jackson Convenience Center CCC710000598 CONVENIENCE Active
Denali Water Solutions - Gillespie Road LND380000098 LAND APPLICATION Active
Woody Convenience Center (New) CCC180000603 CONVENIENCE Active
New Clarkrange Convenience Center CCC250000604 CONVENIENCE Active
City of South Fulton Convenience Center CCC660000605 CONVENIENCE Withdrawn
ERC - Research, Development & Demonstration Facility (EKAMOR) SWP710001586 PROCESSING Active
Permittee Location City
W. Jackson Convenience Center 2105 W JACKSON ST Cookeville
Denali Water Solutions Gillespie Road Brownsville
Woody Conveneince Center (New) 6644 HWY 127N Crossville
New Clarkrange Convenience Center 770 OLD HIGHWAY 28 Clarkrange
City of South Fulton 4658 MILLTOWN RD South Fulton
EKAMOR Resource Corporation 1368 West Broad Street Cookeville
County Issuance
Putnam
Haywood 2022-06-16
Cumberland 2022-08-12
Fentress 2022-11-01
Obion
Putnam 2022-05-09 
# SQL
pander(head(sqldf("Select * from permit")))
Facility Permit.Number Permit.Type Status
W. Jackson Convenience Center CCC710000598 CONVENIENCE Active
Denali Water Solutions - Gillespie Road LND380000098 LAND APPLICATION Active
Woody Convenience Center (New) CCC180000603 CONVENIENCE Active
New Clarkrange Convenience Center CCC250000604 CONVENIENCE Active
City of South Fulton Convenience Center CCC660000605 CONVENIENCE Withdrawn
ERC - Research, Development & Demonstration Facility (EKAMOR) SWP710001586 PROCESSING Active
Permittee Location City
W. Jackson Convenience Center 2105 W JACKSON ST Cookeville
Denali Water Solutions Gillespie Road Brownsville
Woody Conveneince Center (New) 6644 HWY 127N Crossville
New Clarkrange Convenience Center 770 OLD HIGHWAY 28 Clarkrange
City of South Fulton 4658 MILLTOWN RD South Fulton
EKAMOR Resource Corporation 1368 West Broad Street Cookeville
County Issuance
Putnam
Haywood 2022-06-16
Cumberland 2022-08-12
Fentress 2022-11-01
Obion
Putnam 2022-05-09



2) View only the Facility, Permit.Number, and Issuance columns of the permit table

# R
pander(head(permit[, list(Facility, Permit.Number, Issuance)]))
Facility Permit.Number Issuance
W. Jackson Convenience Center CCC710000598
Denali Water Solutions - Gillespie Road LND380000098 2022-06-16
Woody Convenience Center (New) CCC180000603 2022-08-12
New Clarkrange Convenience Center CCC250000604 2022-11-01
City of South Fulton Convenience Center CCC660000605
ERC - Research, Development & Demonstration Facility (EKAMOR) SWP710001586 2022-05-09 
# SQL
pander(head(sqldf("Select Facility, [Permit.Number], Issuance from permit")))
Facility Permit.Number Issuance
W. Jackson Convenience Center CCC710000598
Denali Water Solutions - Gillespie Road LND380000098 2022-06-16
Woody Convenience Center (New) CCC180000603 2022-08-12
New Clarkrange Convenience Center CCC250000604 2022-11-01
City of South Fulton Convenience Center CCC660000605
ERC - Research, Development & Demonstration Facility (EKAMOR) SWP710001586 2022-05-09



3) Arrange permit records by descending order of Issuance date

# R
setorder(permit, -Issuance, na.last = TRUE)
pander(head(permit))
Facility Permit.Number Permit.Type Status
Smartt Station Convenience Center (New) CCC890000607 CONVENIENCE Active
Cumberland Composting LLC Tier I Composting Facility SWP180001597 PROCESSING Active
Global Processing Solutions, LLC SWP330001593 PROCESSING Active
Budget Drain Masters LLC (BDM Disposal) SWP840001594 PROCESSING Active
Mt. Vernon Convenience Center CCC140000606 CONVENIENCE Active
Atlas Organics CU60, LLC (FKA Interstate Storage LLC (Brown Bros)) CMP330000013 COMPOSTING Active
Permittee Location
Warren County Solid Waste 190 HENNESSEE AVE
Cumberland Composting LLC 9138 CHESTNUT HILL RD
Global Processing Solutions 312 WORKMAN RD
Budget Drain Masters LLC (BDM Disposal) 90 BCI CV
Mt. Vernon Convenience Center 4023 BAKERTON RD
Atlas Organics CU60, LLC 1045 E 23rd St (parcel: 155D C 006.01)
City County Issuance
Morrison Warren 2023-05-09
Crossville Cumberland 2023-04-25
Chattanooga Hamilton 2023-03-30
Brighton Tipton 2023-03-29
Red Boiling Springs Clay 2023-02-07
Chattanooga Hamilton 2023-01-06 
# SQL
pander(head(sqldf("Select * from permit order by Issuance desc")))
Facility Permit.Number Permit.Type Status
Smartt Station Convenience Center (New) CCC890000607 CONVENIENCE Active
Cumberland Composting LLC Tier I Composting Facility SWP180001597 PROCESSING Active
Global Processing Solutions, LLC SWP330001593 PROCESSING Active
Budget Drain Masters LLC (BDM Disposal) SWP840001594 PROCESSING Active
Mt. Vernon Convenience Center CCC140000606 CONVENIENCE Active
Atlas Organics CU60, LLC (FKA Interstate Storage LLC (Brown Bros)) CMP330000013 COMPOSTING Active
Permittee Location
Warren County Solid Waste 190 HENNESSEE AVE
Cumberland Composting LLC 9138 CHESTNUT HILL RD
Global Processing Solutions 312 WORKMAN RD
Budget Drain Masters LLC (BDM Disposal) 90 BCI CV
Mt. Vernon Convenience Center 4023 BAKERTON RD
Atlas Organics CU60, LLC 1045 E 23rd St (parcel: 155D C 006.01)
City County Issuance
Morrison Warren 2023-05-09
Crossville Cumberland 2023-04-25
Chattanooga Hamilton 2023-03-30
Brighton Tipton 2023-03-29
Red Boiling Springs Clay 2023-02-07
Chattanooga Hamilton 2023-01-06



4) Arrange permit records by descending order of Issuance date

# R
setorder(permit, City, -Issuance, na.last = TRUE)
pander(head(permit))
Facility Permit.Number Permit.Type Status
Maury County Solid Waste Transfer Station TRF600001565 TRANSFER Termination
City of Goodlettsville Convenience Center CCC190000586 CONVENIENCE Active
Southeastern Compost SWP750001515 PROCESSING Active
Tarlton Valley Convenience Center CCC310000562 CONVENIENCE Active
Centerview Road Convenience Center CCC780000552 CONVENIENCE Active
Southside Convenience Center CCC630000470 CONVENIENCE Active
Permittee Location City County
Maury County Solid Waste Transfer Station New Hwy 7 Maury
City of Goodlettsville Convenience Center 220 Connell St. Davidson
Southeastern Compost, LLC 5590 Hickory Grove Rd. Rutherford
Grundy County Government 26463 State Route 56 Grundy
Sevier County Government DML 78-0041 is on Centerview Road about 1000 feet north of the Compost Plant and landfills that are on Ridge Road and sits directly east of the landfills that are on RIdge Rd and Rainbow Rd Sevier
BI-COUNTY SOLID WASTE MANAGEMENT (PETE REED, DIRECTOR) Intersection Of 5068 Hwy 48 And Louise Ck Rd Montgomery
Issuance
2019-10-03
2018-11-01
2016-04-12
2013-03-22
2011-11-02
2002-08-07 
# SQL
pander(head(sqldf("Select * from permit order by City, Issuance desc")))
Facility Permit.Number Permit.Type Status
Maury County Solid Waste Transfer Station TRF600001565 TRANSFER Termination
City of Goodlettsville Convenience Center CCC190000586 CONVENIENCE Active
Southeastern Compost SWP750001515 PROCESSING Active
Tarlton Valley Convenience Center CCC310000562 CONVENIENCE Active
Centerview Road Convenience Center CCC780000552 CONVENIENCE Active
Southside Convenience Center CCC630000470 CONVENIENCE Active
Permittee Location City County
Maury County Solid Waste Transfer Station New Hwy 7 Maury
City of Goodlettsville Convenience Center 220 Connell St. Davidson
Southeastern Compost, LLC 5590 Hickory Grove Rd. Rutherford
Grundy County Government 26463 State Route 56 Grundy
Sevier County Government DML 78-0041 is on Centerview Road about 1000 feet north of the Compost Plant and landfills that are on Ridge Road and sits directly east of the landfills that are on RIdge Rd and Rainbow Rd Sevier
BI-COUNTY SOLID WASTE MANAGEMENT (PETE REED, DIRECTOR) Intersection Of 5068 Hwy 48 And Louise Ck Rd Montgomery
Issuance
2019-10-03
2018-11-01
2016-04-12
2013-03-22
2011-11-02
2002-08-07



5) Filter permit records with the City of ‘Memphis’

# R
pander(permit[permit[, which(grepl(pattern = "Memphis", permit$City))]])
Facility Permit.Number Permit.Type Status
Earth Complex City of Memphis CMP790000011 COMPOSTING Active
AllWaste Onsite, LLC, dba Onsite Environmental SWP790001528 PROCESSING Active
Trilogy MedWaste Southeast - Memphis TN TRF790001539 TRANSFER Termination
Medical Waste Services, LLC TRF790001543 TRANSFER Active
Switch Medical Waste Services, LLC SWP790001537 PROCESSING Active
Aftermath Services LLC - TN TRF790001504 TRANSFER Termination
Switch Medical Waste Transfer Station TRF790001470 TRANSFER Termination
Bio-Waste Solutions, LLC Transfer Station TRF790001466 TRANSFER Termination
Frayser Business Development Center Demolition Landfill DML790000123 CLASS III Active
Pear Street Transfer Station TRF790001418 TRANSFER Termination
City Of Memphis Farrisview Transfer Station TRF790001403 TRANSFER Active
Liberty Tire Recycling, LLC TRF790001397 TRANSFER Active
Frank C. Pidgeon Industrial Park Ash Structural Fill CAF790001393 COAL ASH Termination
Shelby County Recycle Center CCC790001522 CONVENIENCE Active
Belz Investco - Rivergate Road Structural Fill CAF790001385 COAL ASH Inactive
Eaton-Moery Environmental Services, Inc. TRF790001361 TRANSFER Inactive
North Memphis Landfill, Inc. DML790000109 CLASS III Active
Tobacco & Gas Discount, Inc. SWP790001317 PROCESSING Inactive
Domermuth Environmental Services Llc SWP790001305 PROCESSING Inactive
Chandler Demolition Company, Inc. DML790000074 CLASS IV Active
Environmental Tire Disposal Llc SWP790001259 PROCESSING Inactive
Trash Hunters Of Tunica TRF790001262 TRANSFER Inactive
Four F Corporation CAF790001237 COAL ASH Termination
J B Company SWP790001234 PROCESSING Inactive
Memphis Light Gas and Water Composting SWP790001217 COMPOSTING Termination
JIMMY T. WOOD, INC. LANDFILL DML790000077 CLASS III Inactive
Bfi Of Tn Mulching SWP790001210 PROCESSING Inactive
Inservco Corporation TRF790001191 TRANSFER Inactive
Domermuth Environmental Services SWP790001197 PROCESSING Inactive
Nature’S Earth Products SWP790001226 COMPOSTING Inactive
Earth Complex City of Memphis SWP790001168 PROCESSING Active
Earth Complex SNL790000259 CLASS I Inactive
Cold Springs Memphis SWP790001159 PROCESSING Inactive
Extrusion Technologies SWP790001156 PROCESSING Inactive
City Of Bartlett Compost SWP790001147 COMPOSTING Inactive
Safety Lights Inc. Class Iv Landfill DML790000039 CLASS IV Inactive
T R Systems Inc SWP790001121 PROCESSING Inactive
Covenant Envir Technols SWP790001117 PROCESSING Inactive
Bellevue Tire Shredder SWP790001118 PROCESSING Inactive
Southern Hydrocarbon Inc SWP790001105 PROCESSING Inactive
Bfi Recycling SWP790001082 PROCESSING Inactive
Waste Management Of Tennessee Transfer Station TRF790001072 TRANSFER Active
Ensley Berm Ash Landfill IDL790000077 CLASS II Inactive
Wood Processing, Inc./Builders Choice SWP790001038 PROCESSING Inactive
North 2Nd Street Incinerator SWP790001036 PROCESSING Termination
Scott Street Transfer Station TRF790001024 TRANSFER Active
Waste Connections Of Tenn.Inc. Transfer Station TRF790001022 TRANSFER Active
Mid South Reg Blood Incin SWP790001025 PROCESSING Inactive
Democrat Rd Transfer Station TRF790001023 TRANSFER Inactive
Stericycle, Inc. SWP790000213 PROCESSING Active
Fullendock Warehouse Lndf IDL790000073 CLASS II Inactive
First Moorehead Investmt IDL790000065 CLASS II Inactive
Ensley Berm Ash Landfill CAF790001093 COAL ASH Inactive
Mapco Petroleum Landfill IDL790000053 CLASS II Inactive
South Shelby Landfill SNL790000135 CLASS I Active
James Howell Demo Landfill DML790000001 CLASS III Inactive
BFI Shelby Drive Landfill (Closed) SNL790000118 CLASS I Inactive
Bellevue Transfer Station TRF790000099 TRANSFER Active
Memphis City Capleville Landfill SNL790000037 CLASS I Inactive
Martin Tire SWP790001452 PROCESSING Withdrawn
South Shelby Landfill Processing Facility SWP790001430 PROCESSING Active
Memphis Urban Wood, LLC SWP790001596 COMPOSTING Pending
Shelby Oaks Demolition Landfill DML790001032 CLASS III Withdrawn
Aftermath Services, LLC TRF790001598 TRANSFER Pending
Trilogy MedWaste Southeast, LLC TRF790001573 TRANSFER Active
Permittee Location City
Earth Complex City of Memphis Composting Facility 2389 HENNINGTON AVE Memphis
AllWaste Onsite, LLC, dba Onsite Environmental 2605 Chelsea & 2730 Mathews Memphis
MedSafe Waste, LLC 5565 E. Raines Road Memphis
Medical Waste Services, LLC 129 W. Trigg Avenue Memphis
Switch Medical Waste Services, LLC 2706 Huntley Drive Memphis
Aftermath Services LLC 3086 Summer Avenue Memphis
Switch Medical Waste Services, Inc. 2706 Huntley Drive Memphis
Bio-Waste Solutions, LLC 801 East Georgia Street, Memphis, TN Memphis
Steven L. Williamson and Carol Williamson 2948 Thomas Street Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
CITY OF MEMPHIS 3211 Farrisview Blvd. Memphis
Liberty Tire Recycling, LLC 3000 Elvis Presley Blvd Memphis
MEMPHIS AND SHELBY CO. PORT COMMISSION 0.7 Miles West Of Paul R. Lowery Rd Memphis
SHELBY COUNTY GOVERNMENT 1075 Mullins Station Road Memphis
BELZ INVESTCO, GP Rivergate Road Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
NORTH MEMPHIS LANDFILL, INC. 382 Klinke Rd Memphis
TAYSIR YOUSEF 2389 Summer Avenue Memphis
JAMES DOMERMUTH DBA DOMERMUTH ENVIRONMENTAL SERVICES LLC 1540 Thomas Street Memphis
CHANDLER DEMOLITION COMPANY, INC. 1223 North Watkins Street (Office) 955 Levee Road (Site) Memphis
FORD FARMS North 2nd And Pear Memphis
TRASH HUNTERS OF TUNICA 500 East Brooks Road Memphis
FOUR F CORPORATION 1115 Riverside Blvd. Memphis
J AND B COMPANY 1753 Thomas Road Memphis
Memphis Light, Gas and Water 2285 Hennington Road Memphis
JIMMY T. WOOD, INC. LANDFILL. 382 Klinke Rd Memphis
BFI OF TENNESSEE 5494 Malone Road Memphis
TBD 3097 Fontaine Memphis
DOMERMUTH ENVIRONM’AL SERVICES 3003 Harvester Lane Memphis
MR. E.T. BROWN 10961 Highway 64 Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
TBD 3003 Harvester Lane Memphis
MR. JAMES DOWNING, PRESIDENT 7430 Moore Road Memphis
TBD 6222 Old Brownsville Road Memphis
ALLIED WASTE INDUSTRIES OF TENNESSEE, INC. 2780 Frayser Boulevard Memphis
TBD 2850 Plant Road Memphis
TBD 3003 Harvester Lane Memphis
CITY OF MEMPHIS 1530 North Bellevue Memphis
TPS TECHNOLOGIES, INC. Trigg/Riverside Memphis
BFI OF TENNESSEE, INC. 3840 Homewood Road Memphis
WASTE MANAGEMENT INC. OF TENNESSEE 3750 Hatcher Circle Memphis
MEMPHIS PORT AU Sw Shelby Co/Frank Pidgeon Indust’L Memphis
TBD 5093 Getwell Road Memphis
CITY OF MEMPHIS 2401 North Second Street Memphis
CITY OF MEMPHIS 309 Scott St. Memphis
WASTE CONNECTIONS OF TENNESSEE, INC. 621 East Brooks Road Memphis
TBD Memphis Memphis
TBD 2482 Democrat Road Memphis
STERICYCLE, INC. 540 Rivergate Drive Memphis
FULLENDOCK CO. 382 Klinke Rd Memphis
WILLIAM THOMPSN 900 Firestone Boulevard Memphis
TBD Sw Shelby Co/Frank Pidgeon Indust’L Memphis
MAPCO CORP. Memphis Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
JAMES HOWELL 3654 Thomas Memphis
BFI, INC 4085 Shelby Drive Register of Deeds has it listed as 0 Shelby Drive. Memphis
CITY OF MEMPHIS 1500 North Bellevue Memphis
City of Memphis Southeast Corner - Shelby Drive and Malone Road Memphis
Martin Tire Operations, LLC 382 Klinke Rd Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
Memphis Urban Wood, LLC 1230 N. Watkins Memphis
Blaylock & Brown Construction 5559 Shelby Oaks Drive Memphis
Aftermath Services, LLC - Memphis 2856 LAMB PL Memphis
Trilogy MedWaste Southeast, LLC 4610 W DISTRIPLEX DR Memphis
County Issuance
Shelby 2020-11-19
Shelby 2018-04-13
Shelby 2017-06-30
Shelby 2017-06-22
Shelby 2017-05-08
Shelby 2015-07-23
Shelby 2013-05-29
Shelby 2012-12-17
Shelby 2009-07-02
Shelby 2009-05-26
Shelby 2006-11-09
Shelby 2006-09-26
Shelby 2006-05-01
Shelby 2005-07-27
Shelby 2005-07-27
Shelby 2003-06-09
Shelby 2002-03-11
Shelby 2001-01-11
Shelby 1999-12-17
Shelby 1997-09-26
Shelby 1997-02-25
Shelby 1997-01-16
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1995-11-06
Shelby 1995-06-23
Shelby 1995-03-27
Shelby 1995-01-27
Shelby 1995-01-09
Shelby 1994-09-13
Shelby 1994-04-18
Shelby 1994-02-22
Shelby 1993-10-06
Shelby 1993-07-06
Shelby 1993-01-01
Shelby 1992-11-13
Shelby 1992-10-08
Shelby 1992-10-08
Shelby 1992-06-17
Shelby 1992-03-13
Shelby 1991-07-03
Shelby 1991-01-01
Shelby 1990-12-10
Shelby 1990-12-03
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-07-12
Shelby 1988-01-01
Shelby 1986-01-01
Shelby 1985-01-01
Shelby 1982-01-01
Shelby 1978-01-01
Shelby 1976-01-01
Shelby 1975-01-01
Shelby 1973-01-01
Shelby 1972-01-01
Shelby
Shelby
Shelby
Shelby
Shelby
Shelby 
# or
pander(subset(permit, City == "Memphis"))
Facility Permit.Number Permit.Type Status
Earth Complex City of Memphis CMP790000011 COMPOSTING Active
AllWaste Onsite, LLC, dba Onsite Environmental SWP790001528 PROCESSING Active
Trilogy MedWaste Southeast - Memphis TN TRF790001539 TRANSFER Termination
Medical Waste Services, LLC TRF790001543 TRANSFER Active
Switch Medical Waste Services, LLC SWP790001537 PROCESSING Active
Aftermath Services LLC - TN TRF790001504 TRANSFER Termination
Switch Medical Waste Transfer Station TRF790001470 TRANSFER Termination
Bio-Waste Solutions, LLC Transfer Station TRF790001466 TRANSFER Termination
Frayser Business Development Center Demolition Landfill DML790000123 CLASS III Active
Pear Street Transfer Station TRF790001418 TRANSFER Termination
City Of Memphis Farrisview Transfer Station TRF790001403 TRANSFER Active
Liberty Tire Recycling, LLC TRF790001397 TRANSFER Active
Frank C. Pidgeon Industrial Park Ash Structural Fill CAF790001393 COAL ASH Termination
Shelby County Recycle Center CCC790001522 CONVENIENCE Active
Belz Investco - Rivergate Road Structural Fill CAF790001385 COAL ASH Inactive
Eaton-Moery Environmental Services, Inc. TRF790001361 TRANSFER Inactive
North Memphis Landfill, Inc. DML790000109 CLASS III Active
Tobacco & Gas Discount, Inc. SWP790001317 PROCESSING Inactive
Domermuth Environmental Services Llc SWP790001305 PROCESSING Inactive
Chandler Demolition Company, Inc. DML790000074 CLASS IV Active
Environmental Tire Disposal Llc SWP790001259 PROCESSING Inactive
Trash Hunters Of Tunica TRF790001262 TRANSFER Inactive
Four F Corporation CAF790001237 COAL ASH Termination
J B Company SWP790001234 PROCESSING Inactive
Memphis Light Gas and Water Composting SWP790001217 COMPOSTING Termination
JIMMY T. WOOD, INC. LANDFILL DML790000077 CLASS III Inactive
Bfi Of Tn Mulching SWP790001210 PROCESSING Inactive
Inservco Corporation TRF790001191 TRANSFER Inactive
Domermuth Environmental Services SWP790001197 PROCESSING Inactive
Nature’S Earth Products SWP790001226 COMPOSTING Inactive
Earth Complex City of Memphis SWP790001168 PROCESSING Active
Earth Complex SNL790000259 CLASS I Inactive
Cold Springs Memphis SWP790001159 PROCESSING Inactive
Extrusion Technologies SWP790001156 PROCESSING Inactive
City Of Bartlett Compost SWP790001147 COMPOSTING Inactive
Safety Lights Inc. Class Iv Landfill DML790000039 CLASS IV Inactive
T R Systems Inc SWP790001121 PROCESSING Inactive
Covenant Envir Technols SWP790001117 PROCESSING Inactive
Bellevue Tire Shredder SWP790001118 PROCESSING Inactive
Southern Hydrocarbon Inc SWP790001105 PROCESSING Inactive
Bfi Recycling SWP790001082 PROCESSING Inactive
Waste Management Of Tennessee Transfer Station TRF790001072 TRANSFER Active
Ensley Berm Ash Landfill IDL790000077 CLASS II Inactive
Wood Processing, Inc./Builders Choice SWP790001038 PROCESSING Inactive
North 2Nd Street Incinerator SWP790001036 PROCESSING Termination
Scott Street Transfer Station TRF790001024 TRANSFER Active
Waste Connections Of Tenn.Inc. Transfer Station TRF790001022 TRANSFER Active
Mid South Reg Blood Incin SWP790001025 PROCESSING Inactive
Democrat Rd Transfer Station TRF790001023 TRANSFER Inactive
Stericycle, Inc. SWP790000213 PROCESSING Active
Fullendock Warehouse Lndf IDL790000073 CLASS II Inactive
First Moorehead Investmt IDL790000065 CLASS II Inactive
Ensley Berm Ash Landfill CAF790001093 COAL ASH Inactive
Mapco Petroleum Landfill IDL790000053 CLASS II Inactive
South Shelby Landfill SNL790000135 CLASS I Active
James Howell Demo Landfill DML790000001 CLASS III Inactive
BFI Shelby Drive Landfill (Closed) SNL790000118 CLASS I Inactive
Bellevue Transfer Station TRF790000099 TRANSFER Active
Memphis City Capleville Landfill SNL790000037 CLASS I Inactive
Martin Tire SWP790001452 PROCESSING Withdrawn
South Shelby Landfill Processing Facility SWP790001430 PROCESSING Active
Memphis Urban Wood, LLC SWP790001596 COMPOSTING Pending
Shelby Oaks Demolition Landfill DML790001032 CLASS III Withdrawn
Aftermath Services, LLC TRF790001598 TRANSFER Pending
Trilogy MedWaste Southeast, LLC TRF790001573 TRANSFER Active
Permittee Location City
Earth Complex City of Memphis Composting Facility 2389 HENNINGTON AVE Memphis
AllWaste Onsite, LLC, dba Onsite Environmental 2605 Chelsea & 2730 Mathews Memphis
MedSafe Waste, LLC 5565 E. Raines Road Memphis
Medical Waste Services, LLC 129 W. Trigg Avenue Memphis
Switch Medical Waste Services, LLC 2706 Huntley Drive Memphis
Aftermath Services LLC 3086 Summer Avenue Memphis
Switch Medical Waste Services, Inc. 2706 Huntley Drive Memphis
Bio-Waste Solutions, LLC 801 East Georgia Street, Memphis, TN Memphis
Steven L. Williamson and Carol Williamson 2948 Thomas Street Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
CITY OF MEMPHIS 3211 Farrisview Blvd. Memphis
Liberty Tire Recycling, LLC 3000 Elvis Presley Blvd Memphis
MEMPHIS AND SHELBY CO. PORT COMMISSION 0.7 Miles West Of Paul R. Lowery Rd Memphis
SHELBY COUNTY GOVERNMENT 1075 Mullins Station Road Memphis
BELZ INVESTCO, GP Rivergate Road Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
NORTH MEMPHIS LANDFILL, INC. 382 Klinke Rd Memphis
TAYSIR YOUSEF 2389 Summer Avenue Memphis
JAMES DOMERMUTH DBA DOMERMUTH ENVIRONMENTAL SERVICES LLC 1540 Thomas Street Memphis
CHANDLER DEMOLITION COMPANY, INC. 1223 North Watkins Street (Office) 955 Levee Road (Site) Memphis
FORD FARMS North 2nd And Pear Memphis
TRASH HUNTERS OF TUNICA 500 East Brooks Road Memphis
FOUR F CORPORATION 1115 Riverside Blvd. Memphis
J AND B COMPANY 1753 Thomas Road Memphis
Memphis Light, Gas and Water 2285 Hennington Road Memphis
JIMMY T. WOOD, INC. LANDFILL. 382 Klinke Rd Memphis
BFI OF TENNESSEE 5494 Malone Road Memphis
TBD 3097 Fontaine Memphis
DOMERMUTH ENVIRONM’AL SERVICES 3003 Harvester Lane Memphis
MR. E.T. BROWN 10961 Highway 64 Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
TBD 3003 Harvester Lane Memphis
MR. JAMES DOWNING, PRESIDENT 7430 Moore Road Memphis
TBD 6222 Old Brownsville Road Memphis
ALLIED WASTE INDUSTRIES OF TENNESSEE, INC. 2780 Frayser Boulevard Memphis
TBD 2850 Plant Road Memphis
TBD 3003 Harvester Lane Memphis
CITY OF MEMPHIS 1530 North Bellevue Memphis
TPS TECHNOLOGIES, INC. Trigg/Riverside Memphis
BFI OF TENNESSEE, INC. 3840 Homewood Road Memphis
WASTE MANAGEMENT INC. OF TENNESSEE 3750 Hatcher Circle Memphis
MEMPHIS PORT AU Sw Shelby Co/Frank Pidgeon Indust’L Memphis
TBD 5093 Getwell Road Memphis
CITY OF MEMPHIS 2401 North Second Street Memphis
CITY OF MEMPHIS 309 Scott St. Memphis
WASTE CONNECTIONS OF TENNESSEE, INC. 621 East Brooks Road Memphis
TBD Memphis Memphis
TBD 2482 Democrat Road Memphis
STERICYCLE, INC. 540 Rivergate Drive Memphis
FULLENDOCK CO. 382 Klinke Rd Memphis
WILLIAM THOMPSN 900 Firestone Boulevard Memphis
TBD Sw Shelby Co/Frank Pidgeon Indust’L Memphis
MAPCO CORP. Memphis Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
JAMES HOWELL 3654 Thomas Memphis
BFI, INC 4085 Shelby Drive Register of Deeds has it listed as 0 Shelby Drive. Memphis
CITY OF MEMPHIS 1500 North Bellevue Memphis
City of Memphis Southeast Corner - Shelby Drive and Malone Road Memphis
Martin Tire Operations, LLC 382 Klinke Rd Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
Memphis Urban Wood, LLC 1230 N. Watkins Memphis
Blaylock & Brown Construction 5559 Shelby Oaks Drive Memphis
Aftermath Services, LLC - Memphis 2856 LAMB PL Memphis
Trilogy MedWaste Southeast, LLC 4610 W DISTRIPLEX DR Memphis
County Issuance
Shelby 2020-11-19
Shelby 2018-04-13
Shelby 2017-06-30
Shelby 2017-06-22
Shelby 2017-05-08
Shelby 2015-07-23
Shelby 2013-05-29
Shelby 2012-12-17
Shelby 2009-07-02
Shelby 2009-05-26
Shelby 2006-11-09
Shelby 2006-09-26
Shelby 2006-05-01
Shelby 2005-07-27
Shelby 2005-07-27
Shelby 2003-06-09
Shelby 2002-03-11
Shelby 2001-01-11
Shelby 1999-12-17
Shelby 1997-09-26
Shelby 1997-02-25
Shelby 1997-01-16
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1995-11-06
Shelby 1995-06-23
Shelby 1995-03-27
Shelby 1995-01-27
Shelby 1995-01-09
Shelby 1994-09-13
Shelby 1994-04-18
Shelby 1994-02-22
Shelby 1993-10-06
Shelby 1993-07-06
Shelby 1993-01-01
Shelby 1992-11-13
Shelby 1992-10-08
Shelby 1992-10-08
Shelby 1992-06-17
Shelby 1992-03-13
Shelby 1991-07-03
Shelby 1991-01-01
Shelby 1990-12-10
Shelby 1990-12-03
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-07-12
Shelby 1988-01-01
Shelby 1986-01-01
Shelby 1985-01-01
Shelby 1982-01-01
Shelby 1978-01-01
Shelby 1976-01-01
Shelby 1975-01-01
Shelby 1973-01-01
Shelby 1972-01-01
Shelby
Shelby
Shelby
Shelby
Shelby
Shelby 
# or
pander(permit[City == "Memphis", ])
Facility Permit.Number Permit.Type Status
Earth Complex City of Memphis CMP790000011 COMPOSTING Active
AllWaste Onsite, LLC, dba Onsite Environmental SWP790001528 PROCESSING Active
Trilogy MedWaste Southeast - Memphis TN TRF790001539 TRANSFER Termination
Medical Waste Services, LLC TRF790001543 TRANSFER Active
Switch Medical Waste Services, LLC SWP790001537 PROCESSING Active
Aftermath Services LLC - TN TRF790001504 TRANSFER Termination
Switch Medical Waste Transfer Station TRF790001470 TRANSFER Termination
Bio-Waste Solutions, LLC Transfer Station TRF790001466 TRANSFER Termination
Frayser Business Development Center Demolition Landfill DML790000123 CLASS III Active
Pear Street Transfer Station TRF790001418 TRANSFER Termination
City Of Memphis Farrisview Transfer Station TRF790001403 TRANSFER Active
Liberty Tire Recycling, LLC TRF790001397 TRANSFER Active
Frank C. Pidgeon Industrial Park Ash Structural Fill CAF790001393 COAL ASH Termination
Shelby County Recycle Center CCC790001522 CONVENIENCE Active
Belz Investco - Rivergate Road Structural Fill CAF790001385 COAL ASH Inactive
Eaton-Moery Environmental Services, Inc. TRF790001361 TRANSFER Inactive
North Memphis Landfill, Inc. DML790000109 CLASS III Active
Tobacco & Gas Discount, Inc. SWP790001317 PROCESSING Inactive
Domermuth Environmental Services Llc SWP790001305 PROCESSING Inactive
Chandler Demolition Company, Inc. DML790000074 CLASS IV Active
Environmental Tire Disposal Llc SWP790001259 PROCESSING Inactive
Trash Hunters Of Tunica TRF790001262 TRANSFER Inactive
Four F Corporation CAF790001237 COAL ASH Termination
J B Company SWP790001234 PROCESSING Inactive
Memphis Light Gas and Water Composting SWP790001217 COMPOSTING Termination
JIMMY T. WOOD, INC. LANDFILL DML790000077 CLASS III Inactive
Bfi Of Tn Mulching SWP790001210 PROCESSING Inactive
Inservco Corporation TRF790001191 TRANSFER Inactive
Domermuth Environmental Services SWP790001197 PROCESSING Inactive
Nature’S Earth Products SWP790001226 COMPOSTING Inactive
Earth Complex City of Memphis SWP790001168 PROCESSING Active
Earth Complex SNL790000259 CLASS I Inactive
Cold Springs Memphis SWP790001159 PROCESSING Inactive
Extrusion Technologies SWP790001156 PROCESSING Inactive
City Of Bartlett Compost SWP790001147 COMPOSTING Inactive
Safety Lights Inc. Class Iv Landfill DML790000039 CLASS IV Inactive
T R Systems Inc SWP790001121 PROCESSING Inactive
Covenant Envir Technols SWP790001117 PROCESSING Inactive
Bellevue Tire Shredder SWP790001118 PROCESSING Inactive
Southern Hydrocarbon Inc SWP790001105 PROCESSING Inactive
Bfi Recycling SWP790001082 PROCESSING Inactive
Waste Management Of Tennessee Transfer Station TRF790001072 TRANSFER Active
Ensley Berm Ash Landfill IDL790000077 CLASS II Inactive
Wood Processing, Inc./Builders Choice SWP790001038 PROCESSING Inactive
North 2Nd Street Incinerator SWP790001036 PROCESSING Termination
Scott Street Transfer Station TRF790001024 TRANSFER Active
Waste Connections Of Tenn.Inc. Transfer Station TRF790001022 TRANSFER Active
Mid South Reg Blood Incin SWP790001025 PROCESSING Inactive
Democrat Rd Transfer Station TRF790001023 TRANSFER Inactive
Stericycle, Inc. SWP790000213 PROCESSING Active
Fullendock Warehouse Lndf IDL790000073 CLASS II Inactive
First Moorehead Investmt IDL790000065 CLASS II Inactive
Ensley Berm Ash Landfill CAF790001093 COAL ASH Inactive
Mapco Petroleum Landfill IDL790000053 CLASS II Inactive
South Shelby Landfill SNL790000135 CLASS I Active
James Howell Demo Landfill DML790000001 CLASS III Inactive
BFI Shelby Drive Landfill (Closed) SNL790000118 CLASS I Inactive
Bellevue Transfer Station TRF790000099 TRANSFER Active
Memphis City Capleville Landfill SNL790000037 CLASS I Inactive
Martin Tire SWP790001452 PROCESSING Withdrawn
South Shelby Landfill Processing Facility SWP790001430 PROCESSING Active
Memphis Urban Wood, LLC SWP790001596 COMPOSTING Pending
Shelby Oaks Demolition Landfill DML790001032 CLASS III Withdrawn
Aftermath Services, LLC TRF790001598 TRANSFER Pending
Trilogy MedWaste Southeast, LLC TRF790001573 TRANSFER Active
Permittee Location City
Earth Complex City of Memphis Composting Facility 2389 HENNINGTON AVE Memphis
AllWaste Onsite, LLC, dba Onsite Environmental 2605 Chelsea & 2730 Mathews Memphis
MedSafe Waste, LLC 5565 E. Raines Road Memphis
Medical Waste Services, LLC 129 W. Trigg Avenue Memphis
Switch Medical Waste Services, LLC 2706 Huntley Drive Memphis
Aftermath Services LLC 3086 Summer Avenue Memphis
Switch Medical Waste Services, Inc. 2706 Huntley Drive Memphis
Bio-Waste Solutions, LLC 801 East Georgia Street, Memphis, TN Memphis
Steven L. Williamson and Carol Williamson 2948 Thomas Street Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
CITY OF MEMPHIS 3211 Farrisview Blvd. Memphis
Liberty Tire Recycling, LLC 3000 Elvis Presley Blvd Memphis
MEMPHIS AND SHELBY CO. PORT COMMISSION 0.7 Miles West Of Paul R. Lowery Rd Memphis
SHELBY COUNTY GOVERNMENT 1075 Mullins Station Road Memphis
BELZ INVESTCO, GP Rivergate Road Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
NORTH MEMPHIS LANDFILL, INC. 382 Klinke Rd Memphis
TAYSIR YOUSEF 2389 Summer Avenue Memphis
JAMES DOMERMUTH DBA DOMERMUTH ENVIRONMENTAL SERVICES LLC 1540 Thomas Street Memphis
CHANDLER DEMOLITION COMPANY, INC. 1223 North Watkins Street (Office) 955 Levee Road (Site) Memphis
FORD FARMS North 2nd And Pear Memphis
TRASH HUNTERS OF TUNICA 500 East Brooks Road Memphis
FOUR F CORPORATION 1115 Riverside Blvd. Memphis
J AND B COMPANY 1753 Thomas Road Memphis
Memphis Light, Gas and Water 2285 Hennington Road Memphis
JIMMY T. WOOD, INC. LANDFILL. 382 Klinke Rd Memphis
BFI OF TENNESSEE 5494 Malone Road Memphis
TBD 3097 Fontaine Memphis
DOMERMUTH ENVIRONM’AL SERVICES 3003 Harvester Lane Memphis
MR. E.T. BROWN 10961 Highway 64 Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
TBD 3003 Harvester Lane Memphis
MR. JAMES DOWNING, PRESIDENT 7430 Moore Road Memphis
TBD 6222 Old Brownsville Road Memphis
ALLIED WASTE INDUSTRIES OF TENNESSEE, INC. 2780 Frayser Boulevard Memphis
TBD 2850 Plant Road Memphis
TBD 3003 Harvester Lane Memphis
CITY OF MEMPHIS 1530 North Bellevue Memphis
TPS TECHNOLOGIES, INC. Trigg/Riverside Memphis
BFI OF TENNESSEE, INC. 3840 Homewood Road Memphis
WASTE MANAGEMENT INC. OF TENNESSEE 3750 Hatcher Circle Memphis
MEMPHIS PORT AU Sw Shelby Co/Frank Pidgeon Indust’L Memphis
TBD 5093 Getwell Road Memphis
CITY OF MEMPHIS 2401 North Second Street Memphis
CITY OF MEMPHIS 309 Scott St. Memphis
WASTE CONNECTIONS OF TENNESSEE, INC. 621 East Brooks Road Memphis
TBD Memphis Memphis
TBD 2482 Democrat Road Memphis
STERICYCLE, INC. 540 Rivergate Drive Memphis
FULLENDOCK CO. 382 Klinke Rd Memphis
WILLIAM THOMPSN 900 Firestone Boulevard Memphis
TBD Sw Shelby Co/Frank Pidgeon Indust’L Memphis
MAPCO CORP. Memphis Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
JAMES HOWELL 3654 Thomas Memphis
BFI, INC 4085 Shelby Drive Register of Deeds has it listed as 0 Shelby Drive. Memphis
CITY OF MEMPHIS 1500 North Bellevue Memphis
City of Memphis Southeast Corner - Shelby Drive and Malone Road Memphis
Martin Tire Operations, LLC 382 Klinke Rd Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
Memphis Urban Wood, LLC 1230 N. Watkins Memphis
Blaylock & Brown Construction 5559 Shelby Oaks Drive Memphis
Aftermath Services, LLC - Memphis 2856 LAMB PL Memphis
Trilogy MedWaste Southeast, LLC 4610 W DISTRIPLEX DR Memphis
County Issuance
Shelby 2020-11-19
Shelby 2018-04-13
Shelby 2017-06-30
Shelby 2017-06-22
Shelby 2017-05-08
Shelby 2015-07-23
Shelby 2013-05-29
Shelby 2012-12-17
Shelby 2009-07-02
Shelby 2009-05-26
Shelby 2006-11-09
Shelby 2006-09-26
Shelby 2006-05-01
Shelby 2005-07-27
Shelby 2005-07-27
Shelby 2003-06-09
Shelby 2002-03-11
Shelby 2001-01-11
Shelby 1999-12-17
Shelby 1997-09-26
Shelby 1997-02-25
Shelby 1997-01-16
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1995-11-06
Shelby 1995-06-23
Shelby 1995-03-27
Shelby 1995-01-27
Shelby 1995-01-09
Shelby 1994-09-13
Shelby 1994-04-18
Shelby 1994-02-22
Shelby 1993-10-06
Shelby 1993-07-06
Shelby 1993-01-01
Shelby 1992-11-13
Shelby 1992-10-08
Shelby 1992-10-08
Shelby 1992-06-17
Shelby 1992-03-13
Shelby 1991-07-03
Shelby 1991-01-01
Shelby 1990-12-10
Shelby 1990-12-03
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-07-12
Shelby 1988-01-01
Shelby 1986-01-01
Shelby 1985-01-01
Shelby 1982-01-01
Shelby 1978-01-01
Shelby 1976-01-01
Shelby 1975-01-01
Shelby 1973-01-01
Shelby 1972-01-01
Shelby
Shelby
Shelby
Shelby
Shelby
Shelby 
# SQL
pander(sqldf("Select * from permit where City = 'Memphis'"))
Facility Permit.Number Permit.Type Status
Earth Complex City of Memphis CMP790000011 COMPOSTING Active
AllWaste Onsite, LLC, dba Onsite Environmental SWP790001528 PROCESSING Active
Trilogy MedWaste Southeast - Memphis TN TRF790001539 TRANSFER Termination
Medical Waste Services, LLC TRF790001543 TRANSFER Active
Switch Medical Waste Services, LLC SWP790001537 PROCESSING Active
Aftermath Services LLC - TN TRF790001504 TRANSFER Termination
Switch Medical Waste Transfer Station TRF790001470 TRANSFER Termination
Bio-Waste Solutions, LLC Transfer Station TRF790001466 TRANSFER Termination
Frayser Business Development Center Demolition Landfill DML790000123 CLASS III Active
Pear Street Transfer Station TRF790001418 TRANSFER Termination
City Of Memphis Farrisview Transfer Station TRF790001403 TRANSFER Active
Liberty Tire Recycling, LLC TRF790001397 TRANSFER Active
Frank C. Pidgeon Industrial Park Ash Structural Fill CAF790001393 COAL ASH Termination
Shelby County Recycle Center CCC790001522 CONVENIENCE Active
Belz Investco - Rivergate Road Structural Fill CAF790001385 COAL ASH Inactive
Eaton-Moery Environmental Services, Inc. TRF790001361 TRANSFER Inactive
North Memphis Landfill, Inc. DML790000109 CLASS III Active
Tobacco & Gas Discount, Inc. SWP790001317 PROCESSING Inactive
Domermuth Environmental Services Llc SWP790001305 PROCESSING Inactive
Chandler Demolition Company, Inc. DML790000074 CLASS IV Active
Environmental Tire Disposal Llc SWP790001259 PROCESSING Inactive
Trash Hunters Of Tunica TRF790001262 TRANSFER Inactive
Four F Corporation CAF790001237 COAL ASH Termination
J B Company SWP790001234 PROCESSING Inactive
Memphis Light Gas and Water Composting SWP790001217 COMPOSTING Termination
JIMMY T. WOOD, INC. LANDFILL DML790000077 CLASS III Inactive
Bfi Of Tn Mulching SWP790001210 PROCESSING Inactive
Inservco Corporation TRF790001191 TRANSFER Inactive
Domermuth Environmental Services SWP790001197 PROCESSING Inactive
Nature’S Earth Products SWP790001226 COMPOSTING Inactive
Earth Complex City of Memphis SWP790001168 PROCESSING Active
Earth Complex SNL790000259 CLASS I Inactive
Cold Springs Memphis SWP790001159 PROCESSING Inactive
Extrusion Technologies SWP790001156 PROCESSING Inactive
City Of Bartlett Compost SWP790001147 COMPOSTING Inactive
Safety Lights Inc. Class Iv Landfill DML790000039 CLASS IV Inactive
T R Systems Inc SWP790001121 PROCESSING Inactive
Covenant Envir Technols SWP790001117 PROCESSING Inactive
Bellevue Tire Shredder SWP790001118 PROCESSING Inactive
Southern Hydrocarbon Inc SWP790001105 PROCESSING Inactive
Bfi Recycling SWP790001082 PROCESSING Inactive
Waste Management Of Tennessee Transfer Station TRF790001072 TRANSFER Active
Ensley Berm Ash Landfill IDL790000077 CLASS II Inactive
Wood Processing, Inc./Builders Choice SWP790001038 PROCESSING Inactive
North 2Nd Street Incinerator SWP790001036 PROCESSING Termination
Scott Street Transfer Station TRF790001024 TRANSFER Active
Waste Connections Of Tenn.Inc. Transfer Station TRF790001022 TRANSFER Active
Mid South Reg Blood Incin SWP790001025 PROCESSING Inactive
Democrat Rd Transfer Station TRF790001023 TRANSFER Inactive
Stericycle, Inc. SWP790000213 PROCESSING Active
Fullendock Warehouse Lndf IDL790000073 CLASS II Inactive
First Moorehead Investmt IDL790000065 CLASS II Inactive
Ensley Berm Ash Landfill CAF790001093 COAL ASH Inactive
Mapco Petroleum Landfill IDL790000053 CLASS II Inactive
South Shelby Landfill SNL790000135 CLASS I Active
James Howell Demo Landfill DML790000001 CLASS III Inactive
BFI Shelby Drive Landfill (Closed) SNL790000118 CLASS I Inactive
Bellevue Transfer Station TRF790000099 TRANSFER Active
Memphis City Capleville Landfill SNL790000037 CLASS I Inactive
Martin Tire SWP790001452 PROCESSING Withdrawn
South Shelby Landfill Processing Facility SWP790001430 PROCESSING Active
Memphis Urban Wood, LLC SWP790001596 COMPOSTING Pending
Shelby Oaks Demolition Landfill DML790001032 CLASS III Withdrawn
Aftermath Services, LLC TRF790001598 TRANSFER Pending
Trilogy MedWaste Southeast, LLC TRF790001573 TRANSFER Active
Permittee Location City
Earth Complex City of Memphis Composting Facility 2389 HENNINGTON AVE Memphis
AllWaste Onsite, LLC, dba Onsite Environmental 2605 Chelsea & 2730 Mathews Memphis
MedSafe Waste, LLC 5565 E. Raines Road Memphis
Medical Waste Services, LLC 129 W. Trigg Avenue Memphis
Switch Medical Waste Services, LLC 2706 Huntley Drive Memphis
Aftermath Services LLC 3086 Summer Avenue Memphis
Switch Medical Waste Services, Inc. 2706 Huntley Drive Memphis
Bio-Waste Solutions, LLC 801 East Georgia Street, Memphis, TN Memphis
Steven L. Williamson and Carol Williamson 2948 Thomas Street Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
CITY OF MEMPHIS 3211 Farrisview Blvd. Memphis
Liberty Tire Recycling, LLC 3000 Elvis Presley Blvd Memphis
MEMPHIS AND SHELBY CO. PORT COMMISSION 0.7 Miles West Of Paul R. Lowery Rd Memphis
SHELBY COUNTY GOVERNMENT 1075 Mullins Station Road Memphis
BELZ INVESTCO, GP Rivergate Road Memphis
EATON-MOERY ENVIRONMENTAL SERVICES, INC. 500 Plum Avenue Memphis
NORTH MEMPHIS LANDFILL, INC. 382 Klinke Rd Memphis
TAYSIR YOUSEF 2389 Summer Avenue Memphis
JAMES DOMERMUTH DBA DOMERMUTH ENVIRONMENTAL SERVICES LLC 1540 Thomas Street Memphis
CHANDLER DEMOLITION COMPANY, INC. 1223 North Watkins Street (Office) 955 Levee Road (Site) Memphis
FORD FARMS North 2nd And Pear Memphis
TRASH HUNTERS OF TUNICA 500 East Brooks Road Memphis
FOUR F CORPORATION 1115 Riverside Blvd. Memphis
J AND B COMPANY 1753 Thomas Road Memphis
Memphis Light, Gas and Water 2285 Hennington Road Memphis
JIMMY T. WOOD, INC. LANDFILL. 382 Klinke Rd Memphis
BFI OF TENNESSEE 5494 Malone Road Memphis
TBD 3097 Fontaine Memphis
DOMERMUTH ENVIRONM’AL SERVICES 3003 Harvester Lane Memphis
MR. E.T. BROWN 10961 Highway 64 Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
CITY OF MEMPHIS 2389 HENNINGTON AVE Memphis
TBD 3003 Harvester Lane Memphis
MR. JAMES DOWNING, PRESIDENT 7430 Moore Road Memphis
TBD 6222 Old Brownsville Road Memphis
ALLIED WASTE INDUSTRIES OF TENNESSEE, INC. 2780 Frayser Boulevard Memphis
TBD 2850 Plant Road Memphis
TBD 3003 Harvester Lane Memphis
CITY OF MEMPHIS 1530 North Bellevue Memphis
TPS TECHNOLOGIES, INC. Trigg/Riverside Memphis
BFI OF TENNESSEE, INC. 3840 Homewood Road Memphis
WASTE MANAGEMENT INC. OF TENNESSEE 3750 Hatcher Circle Memphis
MEMPHIS PORT AU Sw Shelby Co/Frank Pidgeon Indust’L Memphis
TBD 5093 Getwell Road Memphis
CITY OF MEMPHIS 2401 North Second Street Memphis
CITY OF MEMPHIS 309 Scott St. Memphis
WASTE CONNECTIONS OF TENNESSEE, INC. 621 East Brooks Road Memphis
TBD Memphis Memphis
TBD 2482 Democrat Road Memphis
STERICYCLE, INC. 540 Rivergate Drive Memphis
FULLENDOCK CO. 382 Klinke Rd Memphis
WILLIAM THOMPSN 900 Firestone Boulevard Memphis
TBD Sw Shelby Co/Frank Pidgeon Indust’L Memphis
MAPCO CORP. Memphis Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
JAMES HOWELL 3654 Thomas Memphis
BFI, INC 4085 Shelby Drive Register of Deeds has it listed as 0 Shelby Drive. Memphis
CITY OF MEMPHIS 1500 North Bellevue Memphis
City of Memphis Southeast Corner - Shelby Drive and Malone Road Memphis
Martin Tire Operations, LLC 382 Klinke Rd Memphis
BFI WASTE SYSTEMS OF NORTH AMERICA LLC 5494 Malone Road Memphis
Memphis Urban Wood, LLC 1230 N. Watkins Memphis
Blaylock & Brown Construction 5559 Shelby Oaks Drive Memphis
Aftermath Services, LLC - Memphis 2856 LAMB PL Memphis
Trilogy MedWaste Southeast, LLC 4610 W DISTRIPLEX DR Memphis
County Issuance
Shelby 2020-11-19
Shelby 2018-04-13
Shelby 2017-06-30
Shelby 2017-06-22
Shelby 2017-05-08
Shelby 2015-07-23
Shelby 2013-05-29
Shelby 2012-12-17
Shelby 2009-07-02
Shelby 2009-05-26
Shelby 2006-11-09
Shelby 2006-09-26
Shelby 2006-05-01
Shelby 2005-07-27
Shelby 2005-07-27
Shelby 2003-06-09
Shelby 2002-03-11
Shelby 2001-01-11
Shelby 1999-12-17
Shelby 1997-09-26
Shelby 1997-02-25
Shelby 1997-01-16
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1996-02-14
Shelby 1995-11-06
Shelby 1995-06-23
Shelby 1995-03-27
Shelby 1995-01-27
Shelby 1995-01-09
Shelby 1994-09-13
Shelby 1994-04-18
Shelby 1994-02-22
Shelby 1993-10-06
Shelby 1993-07-06
Shelby 1993-01-01
Shelby 1992-11-13
Shelby 1992-10-08
Shelby 1992-10-08
Shelby 1992-06-17
Shelby 1992-03-13
Shelby 1991-07-03
Shelby 1991-01-01
Shelby 1990-12-10
Shelby 1990-12-03
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-10-29
Shelby 1990-07-12
Shelby 1988-01-01
Shelby 1986-01-01
Shelby 1985-01-01
Shelby 1982-01-01
Shelby 1978-01-01
Shelby 1976-01-01
Shelby 1975-01-01
Shelby 1973-01-01
Shelby 1972-01-01
Shelby
Shelby
Shelby
Shelby
Shelby
Shelby



6) Filter permit records for the Status of “Active” and the Issuance date after January 1, 2014

# R
pander(head(permit[permit[, Status == "Active" & Issuance >= "2014-01-01"]]))
Facility Permit.Number Permit.Type Status
City of Goodlettsville Convenience Center CCC190000586 CONVENIENCE Active
Southeastern Compost SWP750001515 PROCESSING Active
Glen Alpine Convenience Center CCC010000589 CONVENIENCE Active
City of Athens Recycling Convenience Center CCC540000588 CONVENIENCE Active
United Waste Haulers of Tennessee, LLC TRF200001579 TRANSFER Active
Southeastern Provision, LLC LND290000094 LAND APPLICATION Active
Permittee Location City
City of Goodlettsville Convenience Center 220 Connell St.
Southeastern Compost, LLC 5590 Hickory Grove Rd.
Anderson County Solid Waste 3065 NORRIS FREEWAY Andersonville
City of Athens 118 ROCKY MOUNT RD Athens
United Waste Haulers of Tennessee, LLC 324 LANDFILL LN Bath Springs
Southeastern Provision LLC 1617 Helton Road Bean Station
County Issuance
Davidson 2018-11-01
Rutherford 2016-04-12
Anderson 2019-03-22
McMinn 2019-03-15
Decatur 2021-04-26
Grainger 2020-09-01 
# or
pander(head(subset(permit, Status == "Active" & Issuance >= "2014-01-01")))
Facility Permit.Number Permit.Type Status
City of Goodlettsville Convenience Center CCC190000586 CONVENIENCE Active
Southeastern Compost SWP750001515 PROCESSING Active
Glen Alpine Convenience Center CCC010000589 CONVENIENCE Active
City of Athens Recycling Convenience Center CCC540000588 CONVENIENCE Active
United Waste Haulers of Tennessee, LLC TRF200001579 TRANSFER Active
Southeastern Provision, LLC LND290000094 LAND APPLICATION Active
Permittee Location City
City of Goodlettsville Convenience Center 220 Connell St.
Southeastern Compost, LLC 5590 Hickory Grove Rd.
Anderson County Solid Waste 3065 NORRIS FREEWAY Andersonville
City of Athens 118 ROCKY MOUNT RD Athens
United Waste Haulers of Tennessee, LLC 324 LANDFILL LN Bath Springs
Southeastern Provision LLC 1617 Helton Road Bean Station
County Issuance
Davidson 2018-11-01
Rutherford 2016-04-12
Anderson 2019-03-22
McMinn 2019-03-15
Decatur 2021-04-26
Grainger 2020-09-01 
# or
pander(head(permit[Status == "Active" & Issuance >= "2014-01-01", ]))
Facility Permit.Number Permit.Type Status
City of Goodlettsville Convenience Center CCC190000586 CONVENIENCE Active
Southeastern Compost SWP750001515 PROCESSING Active
Glen Alpine Convenience Center CCC010000589 CONVENIENCE Active
City of Athens Recycling Convenience Center CCC540000588 CONVENIENCE Active
United Waste Haulers of Tennessee, LLC TRF200001579 TRANSFER Active
Southeastern Provision, LLC LND290000094 LAND APPLICATION Active
Permittee Location City
City of Goodlettsville Convenience Center 220 Connell St.
Southeastern Compost, LLC 5590 Hickory Grove Rd.
Anderson County Solid Waste 3065 NORRIS FREEWAY Andersonville
City of Athens 118 ROCKY MOUNT RD Athens
United Waste Haulers of Tennessee, LLC 324 LANDFILL LN Bath Springs
Southeastern Provision LLC 1617 Helton Road Bean Station
County Issuance
Davidson 2018-11-01
Rutherford 2016-04-12
Anderson 2019-03-22
McMinn 2019-03-15
Decatur 2021-04-26
Grainger 2020-09-01 
# SQL
permits <- copy(permit)

# change the last column to character class
change_class <- names(permits)[ncol(permits)]
for (col in change_class) set(permits, j = col, value = as.character(permits[[col]]))  # Source 1

pander(head(sqldf("Select * from permits where Status = 'Active' and Issuance >= '2014-01-01'")))
Facility Permit.Number Permit.Type Status
City of Goodlettsville Convenience Center CCC190000586 CONVENIENCE Active
Southeastern Compost SWP750001515 PROCESSING Active
Glen Alpine Convenience Center CCC010000589 CONVENIENCE Active
City of Athens Recycling Convenience Center CCC540000588 CONVENIENCE Active
United Waste Haulers of Tennessee, LLC TRF200001579 TRANSFER Active
Southeastern Provision, LLC LND290000094 LAND APPLICATION Active
Permittee Location City