Here’s the problem. You’ve got a number of test wells and have tested for lead (Pb) and arsenic (As). The file looks something like the CSV file below.
We’ll assume that the elevation mentioned is the collar elevation. The adjustment to the actual water table elevation I’ll leave for another post. What you want to show are only the wells that have returned Pb values greater than or equal to 100 ppm.
There are a couple of ways we can do this. We can use the Map 3D capabilities within AutoCAD Civil 3D 2011 to build a query and annotate the results to show us what we want, or we can use point groups within Civil 3D to display the data we want. We’ll look at the point group method in this post.
Start by creating two user defined point properties to hold the Pb and As values from the point file. Here’s the one for As.
When I’m done, I’ll see this in my Settings tab in the Toolspace.
Next, I’ll create an import format to import the points.
I’ve created a point group called Wells to contain the points. It uses a query based on the raw description (BH).
Here are some of the points in the drawing. Note that several of the Pb values fall below the 100 ppm threshold.
To show the points I want, I just need to modify the query. I’ve used a copy of the Wells point group, called it Wells with Pb GE 100 ppm and modified the query as you see below.
This point group will contain only the points that satisfy the query. Here’s what you see on the drawing.
Since the well points are contained in more than one point group, you may want to adjust the point group order relative to a No Display point group so that the other well points are not shown.
That’s it. But, before I leave, I wanted to share these bits of electronic mildew with you. I hope you get a laugh or two out of them.
Other Sources of Contamination
While we’re on the subject of contaminants and queries, here are some amusing email contaminations I’ve seen recently. Each of these has its own query to try to extract information from the unwary.
First, a variation of the Nigerian scam.
We do notify you as the Financial Advisory Group to the CHEVRON NIGERIA LTD , that your email amongst five others has been chosen randomly from a selection of sub regions within the six continents of the world domains and email as the beneficiary of the donation grant of 810,000GBP(Eight Hundred and Ten Great British Pound Starlings) with PHCV TAG NUMBER: 228.900.110.1111 To receive your Cash Donation Grant of 810,000GBP, kindly fill the claims form below
Now, what would I do with 810 one pound birds?
Keeping in the British tradition, it seems the Queen, with the help of Bill Gates, is being overly generous this month.
We are please to inform you of the announcement today of the QUEENELIZABETH International Poverty Alleviation Grant Scheme held on January2011. this Grant is given out to selected individuals around the world tohelp them actualize their dreams and also make the world a better placefor all. This Grant is made possible by Queen Elizabeth of England andalso the immense support of MR BILL GATES the CHAIRMAN and CEO OFMICROSOFT, USA. Your EMAIL ACCOUNT has been picked as a winner and there fore you havebeen approved FIVE HUNDRED THOUSAND POUNDS (Ј500,000) This is from thetotal Grant Money of FOUR MILLION POUNDS (Ј4,000,000) shared among theEight (8) International Grant Winners in Phase Six. All participants wereselected through their country Internet network. This Grant is part ofQueen Elizabeth Foundation.
You would think that with the royal wedding coming up that the Queen could use all the money she could get her hands on instead of throwing it about to all and sundry. Maybe I’ll get a call from Stephen Harper asking if I would like to be prime minister of Canada for a day.
And finally, good news fro our friends at the UN.
UNITED NATIONS OFFICE FOR THE COORDINATION OF HUMANITARIAN AFFAIR.
Good Day,
I am directed to inform you that your payment verification and confirmations are correct,
therefore we are happy to inform you that arrangements have been concluded to effect your payment as soon as possible. Due to your long over-due payment which you have been finding it difficult to receive via aCertified Bank Draft issued by the UN Promo, we have arranged your payment through HSBC Bank ATM Card Payment Center, this is an instruction passed by the United Nations in respect to all over delayed payment and debt re-scheduling.We will send you an International Swift ATM Card that has been approved in your favor with Card Number: -----------------, with valued sum of $315,810.00 USD (Three Hundred and Fifteen Thousand, Eight Hundred and Ten USD Only), which you are to use in accessing your fund in any ATM Stand/location worldwide, and remember that the maximum withdrawal daily limit is Five Thousand United States Dollars (US$5,000.00).We have concluded delivery arrangement with the UPS courier services. Please note that the UPS courier company is fully insured by Nicon Insurance Corporation. Kindly provide the details below for delivery.1. Valid Delivery Address.2. Full Names.3. Phone Number. Please do confirm that you will take responsibility for the cost ofdelivery ($200), so that I will know how to proceed with you. Please be informed that the delivery will be made to your address in 48 hours (2 days) after our confirmation of this payment for delivery, as you know that the delivery fee receipt will be also attached on your payment delivery documents to avoid your package being delayed by customs.Treat urgently and note that your ATM Card is ready and available for dispatch
Well, at least it’s not 810 starlings.
There are all kinds of contaminants out there, and not all of them flow through the groundwater or float as particles in the air.