|
|
Dear Patti,
Welcome to the Juniper GIS newsletter. This newsletter is coming to you from Juniper GIS South. We are currently operating Juniper GIS from our offices in southern Yucatan. The work seems to be the same, but the setting is much nicer and warmer. Our house is available as a vacation rental. Go to our website to see pictures -- www.casauvero.com. |
 |
Visit our booth at WAURISA |
Look for the Juniper GIS booth at the Washington URISA Conference, April 19 -21 at the Greater Tacoma Convention and Trade Center. This will be the first time we have had a booth at this conference and we are looking forward to seeing all of our Washington friends. Some of you may know from other conferences that we always have good chocolates at our booth. Please stop by and say hi.
|
|
Look for John at GIS-in-Action
|
The GIS-in-Action Conference will be at Portland State University on April 14 - 15. Look for John to be cruising about the conference. He will not be teaching, presenting, or hosting a booth, but he will be enjoying the conference and meeting old and new friends. If you don't see him before, you will probably find him at the pub crawl.
|
|
GIS Conservation Training in the Yucatan, Mexico
|
On our way to Juniper GIS South, we stopped to meet with staff at two conservation organizations doing significant work along the Mexican Yucatan Caribbean coast. We are planning a one-week GIS training session for each organization, and hope to get some gringos to sign up for the classes, too. These classes will focus on beginning and intermediate skill sets for those who want to learn and/or enhance their GIS techniques with a focus on conservation applications. Amigos de Sian Ka'an Amigos de Sian Ka'an promote the preservation of the Sian Ka'an Biosphere Reserve (RBSK) and its surrounding areas. The Sian Ka'an Biosphere Reserve is located just south of Tulum and is approximately 1.3 million acres in size and spans 120 kilometers from north to south, comprising almost one third of the Caribbean coast of Mexico. Centro Ecologico Akumal is based in Akumal and is currently working on three main conservation program fronts---marine and coastal protection, sea turtle protection and water quality, in the Akumal region. Akumal is widely known for its population of sea turtles off its shore and their nesting habitats. This class will be a one-week intensive GIS class appropriate for beginners or intermediate GIS users looking for more indepth skills and practices. There will be only four seats available in each class for $750 per person. Remaining seats will be filled by the participants of these two organizations or related organizations. The manuals for the class will be bilingual and there may be interpreters to help some the Spanish-speaking students with the language limitations of the Juniper GIS instructors. Travel arrangements and lodging are extra, but host organizations are working to put together packages to make the class affordable. Additional excursions are being organized to give class participants an "inside look" into the work of these organizations. Both of these classes are still in the planning stages at this time. If you are interested or if you would like a course outline, please send us an email - patti@junipergis.com. |
|
Class Schedule |
|
Dates |
Course |
Location |
|
Mar 29 - Apr 9 |
Working with Geodatabases
An E-learning class |
Your place |
|
Apr 12 - 13 |
ArcGIS Desktop I: Getting started with GIS |
Olympia, WA |
|
Apr 22 -23 |
Introduction to Spatial Analyst for ArcGIS |
Olympia, WA |
|
May 3 - 5 |
ArcGIS Desktop II: Tools & Functionality |
Boise, ID |
|
May 10 - 12 |
ArcGIS Desktop II: Tools & Functionality |
Portland, OR |
|
May 13 - 14 |
ArcGIS Desktop III: GIS Workflows & Analysis |
Portland, OR |
|
May 17 - 19 |
ArcGIS Desktop II: Tools & Functionality |
Olympia, WA |
|
May 20 - 21 |
ArcGIS Desktop III: GIS Workflows & Analysis |
Olympia, WA |
|
Oct 18 - 22 |
GIS for Environmental Analysis |
Cancun, Mexico |
|
Oct 25-29 |
GIS for Environmental Analysis |
Akumal, Mexico |
. |
|
Juniper John's Tropical Tips |
Using Wildcards in the Query Builder
I usually get a few blank stares when I talk about wildcards in queries, so here's a little explanation.
Wildcards are used to select subsets of a text string. The two wildcards are the "space holder", which is either an underscore _ or a ? and the "everything" which is either the % or the * depending on the type of table being queried. The wildcards are usually used with Like as the operator. Here are a few examples of how these would be used, showing the ? and the * as the wildcard characters.
In this example I want to select all the water meters in the 100 block of East Black Crater Avenue. Double-click on Address, click on Get Unique Values to see all the addresses, and then double click on any address in the 100 block such as 133 E BLACK CRATER AVE. Then just delete the "33" and replace that with the * wildcard. The result is all the meters in that block where the address starts with 1 are selected. In this case, this works because there is no 1000 block, but there is a way to select only from the 100 block even if there was a 100 block and a 1000 block.
In this example, you can see that we have addresses for 100 East Cascade Avenue and 1001 East Cascade Avenue. If I used the expression above, I would get all the addresses in both blocks. But here is how to use the space holder wildcard to get only those meters in the 100 block. I start the expression above, but tell ArcGIS I only want addresses that start with 1 and have two more characters by putting two ?? after the 1.
Let's try one more example. What if I want all the meters for the 100 block of East Cascade and West Cascade avenues? (If you ever drive through Sisters, Oregon these are the two blocks on the main street in the center of town.) I could just take the query above and change it to: [Address] LIKE '1?? * CASCADE AVE'
Understanding how to use these wildcards will make it a lot easier to query pieces of information out of any table. For more information on using the Query Builder, look for the Using the Query Builder PDF on our web site in the Links>Presentations area --http://www.junipergis.com/gis-links/presentations/.
|
|
Bandito Steps in for Layla this Month
|
Hola. My name is Bandito and when John and Patti are down at Juniper GIS South, I have to take care of them since Layla can't come down.
I'm glad they came down when they did. I had GPS points for all my favorite beach spots and was projecting them to line up with the map I got from the Mexican Navy (that's another story). Of course, I know how to do the projection correctly going from WGS84 to NAD 27 because I read John's presentation on projections. But he showed me one trick. I was using the NAD_1927_To_WGS_1984_18 method I found in the geographic_transformations.pdf in ArcGIS's documentation folder, which is for use in Mexico. But John suggested that since we were almost in Belize, it makes more sense to use NAD_1927_To_WGS_1984_2, which is for Belize. It's good to know the rules, but sometimes a little common sense works well also.
If you ever get down this way and John and Patti aren't here, I would like to welcome all the guests here to Juniper GIS South. Check it out at Casa Uvero. I bet Patti will give you 10% off if you mention that you heard about it from Bandito. Adios.
"I know Bandito is doing a good job (and he really does know his projections) and Travis and Kelly are taking really good care of me, but I miss Patti and John."--- Layla |
|
Visit our Blog |
|
Visit the Juniper GIS blog and interact with us about all things GIS, or whatever else you care to comment on -- Juniper GIS Blog.
| |
|
Sincerely,
Patti Bailey
Juniper GIS |
|
|
