Okay, the City of Dallas just joined the 21st Century when it comes to multi-family recycling…well, part way. Nonetheless, the opportunities to drop-off plastic, glass, paper and cardboard, and aluminum and other metal are great. You just need to drive to a site, and there’s no more need to find different locations for these individual recyclables. Everything is single stream at one stop which means spending less time and fuel. It’s not good to increase your carbon footprint while working to reduce it.
Hearing the good news that the first wave of big blue dumpsters was in place, I wanted to find out where they were. At the City of Dallas Sanitation Services, I found a drop-off site listing with addresses and some other location information but where exactly are these sites, especially in relation to me…
…sounds like a mapping job for ArcGIS Explorer.
The first task was to snag the locations listing and drop it into Microsoft Excel. It worked perfectly. I did do a little data cleanup, added a field to each record with the City’s recycling URL, and saved the data as a CSV file.
Next, I launched ArcGIS Explorer and zoomed to the Dallas area. While I basically know the boundary of the city, I decided for greater clarity to download a shapefile of the city limits from a site I discovered at the University of Texas—Dallas. I added the shapefile, chose a solid fill, and adjusted the transparency of the layer.
Importing the CSV was simple: Tools menu > Import File. I navigated to the file and then flowed through the dialog windows. Here’s my map so far including a popup so I can quickly find basic info about the City’s recycling program.
So what site is closest to me and how do I get there?
I added my house location to the map using the Find Address task. Flying to that location presented me with a few nearby recycling station choices and by visual inspection Reverchon Park is the closest. Creating a quick shortest distance route completes my work.
While my project is particular to my geography, imagine the similar projects you could tackle for places and topics of interest to you.
- George Dailey, ESRI Education Manager