There is a lot of feeling in the parent comment, but not a lot of fact. Just because you can smell the pollution in Pittsburgh doesn't mean that it's any worse than the cities with that have lower air quality ratings due to odorless contaminants.
Every city can do better. Just don't expect them to install giant fans on top of Mt Washington to blow away some odor.
It shouldn't be that hard to track at all with a little brainpower. When did we stop using lead and iron piping? Add another 10 years forward and start from that date back, and find every home matching the age/time range.
Everything else should be copper and/or plastic.
Edit: Another consideration - I'm not sure, but I wouldn't be surprised if there was a "lead scale" like with lime or calcium which could even hang around in "good" copper pipes. Someone more familiar with chemistry or water/wastewater engineering could probably give a more educated answer.
Who says we stopped? Water mains often have service life > 100 years. Old buildings have old plumbing.
My guess is they do have (some) data, but it's split among departments, in different formats. Assuming detailed records were kept that far back.
You'd assume I'm an armchair analyst instead of someone that actually does civil planning work.
They have ALL of that data. It's in the damned city plats. Go pay $20 and get a copy of your neighborhood's electrical and piping. Hell you can actually look it up for free online using ARCGIS.
http://www.arcgis.com/home/webmap/viewer.html?webmap=1aae14d...
It isn't exactly advertised, but the city water around the cmu-google-downtown region has failed tests many times, and at least on two occasions the city provided water filters due to contaminants. This is mostly due to how old the city is, rusty and lead pipes in old homes are impossible for the city to track and fix. This is true everywhere in the rust belt.
Air quality in Pittsburgh gets really bad once you go out past googles neck of the woods, that used to be covered in steel mills, plastics manufacturing, coal and trash burning plants. I understand the desire to live near work, but please don't move near bakery square. They can try to cover it up, but I'm sure the ground is contaminated as well. The entire thing used to be a factory before they bulldozed it in the early 2000s. And nearly all the land near a river will have been used by industry at some point. There's a reason why you can pick 4 locals and at least one has asthma.
Edit: for fun, here's a reminder of what the city looked like during the steel days. You couldn't wear white clothing because of the soot in the air. http://cdn.citylab.com/media/img/citylab/legacy/2012/06/05/p...