Township and Range Latitude/Longitude conversions

The latitude and longitude conversions at www.earthpoint.us/townships.aspx now include both Townships and Sections. You can convert from Township and Section to Latitude and Longitude, or go the other way, from Latitude and Longitude to Township and Section. The illustration below shows the conversion from Latitude and Longitude to Township and Section.


Click for larger image.
 

A few ideas for 2009

1. Expand the use of Earth Point in the Boise, Idaho market. Team up with a local Realtor^®. Promote Earth Point in the local media.
2. Allow the user to save their search criteria for real estate listings. Email an alert whenever a listing is added to the list.
3. Create a "favorites" page for real estate listings. Allow the user to add lisitngs to one or more favorites lists. Map the lists to Google Earth. Email an alert to the user anytime the price or characteristics of a listing changes.
4. Add instructional videos demonstrating the use of Earth Point.
5. Move higher in the search rankings by providing good content. Currently, Earth Point is number 80 in a Google search for Boise Real Estate, number 10 for Google Earth Real Estate, and number one in Google searches for Township and Range and Excel To Kml.

If you have more ideas for making Earth Point a better web site, please add a comment.

Township and Range Has Corner Points

Corner points are calculated for each Township, Section, and Quarter-Section using the coordinate data provided by BLM. These values are estimates only.

Earth Point gets its data from ESRI shapefiles supplied by BLM. Each Township/Range/Quarter polygon can have anywhere from eight to fifty or more points defining its perimeter. For each point, Earth Point calculates the interior angle and the orientation of that angle. If the angle is close to 90°, faces in the right direction, and is close a corner point of shape's bounding box, then the point is considered to be a corner point of the polygon itself. If a polygon is irregularly shaped, then it might not have all four corner points.

Excel To Kml - Direction Arrows for GPS Track

ExcelToKml can draw direction arrows on a GPS track.  The column headings to look at are "IconHeading" and "IconColor".

The picture to the right shows an example of a GPS track.  Note that the arrows point in the direction of travel.  This track was plotted with the following spreadsheet values:

	A	B	C	D	E	F
1	Latitude	Longitude	Icon	IconHeading	IconColor	LineColor
2	43.6097	-116.2048	196	line -180	yellow	aqua
3	43.6095	-116.2047	196	line -180	yellow	aqua
4	43.6094	-116.2046	196	line -180	yellow	aqua
5	43.6094	-116.2044	196	line -180	yellow	aqua
6	43.6094	-116.2042	196	line -180	yellow	aqua
7	43.6095	-116.2041	196	line -180	yellow	aqua
8	43.6096	-116.2043	196	line -180	yellow	aqua
9	43.6097	-116.2046	196	line -180	yellow	aqua

This spreadsheet is included in the sample data.

The column IconHeading specifies how many degrees to rotate the icon.  IconHeading can be a number, the word "line", or the word "line" plus or minus a number.

For example, Icon 222 is Google's airplane icon. It looks like this on Google Earth.

If a value of 90 is entered into the IconHeading column, the icon is rotated 90 degrees to the right.

If a value of -90 is entered into the IconHeading column, the icon is rotated 90 degrees to the left.

If the word "line" is entered into the IconHeading column, the airplane is rotated to point in the direction of travel.  That is, the airplane looks like it is flying along the line.

If the value "line-180" is entered into the IconHeading column, the airplane is lined up with the direction of travel, then spun around 180 degrees.  The airplane looks like it is flying backwards.

"line-180" is quite useful when using Icon 196, Google's arrow icon.  Notice that by default the arrow points down, not up.  If we specified a value of "line" in the IconHeading column, the arrow would point in the wrong direction.

To fix this, use a value of "line-180" (or "line+180"), which flips the arrow around 180 degrees and points it in the right direction.

Another problem is that the arrow is hard to see because it is just an outline.  Use IconColor to add color to any icon.  Yellow looks like this:

This combination of IconHeading and IconColor gives us the GPS track illustrated at the beginning of this article.

Changes to Listing Search Criteria

Due to the number of people looking for Condominium and Townhouses, changes have been made to the listings search criteria. "Residential" is now split into "Houses", "Condominiums/Townhouses", and "Manufactured Homes".

Please post your thoughts and comments. Include any other search criteria you would like to see.

Google Earth Imagery Updated

As mentioned in Google Earth Blog, Google updated quite a bit of imagery in December. I can report that this includes the area around Kuna, Idaho. Boise was updated over the summer, so it looks like we are rather current. Please add a comment if you know of other areas in Ada and Canyon counties that have been updated.

Earth Point for Your Town or Company

Several people have asked if Earth Point is available for other cities or projects. Like a new house, the answer is yes, we can build it. The following elements are needed for a presentation on Google Earth.

1. Good satellite imagery. For most urban areas, the imagery is excellent.
   
2. Digital mapping files of legal parcels. These are used to accurately locate properties on Google Earth. Digital mapping files are generally available from the local county assessor’s office, in the form of ESRI shape files. The cost varies greatly, anywhere from free to thousands of dollars.
   
3. Access to local MLS data. This is accomplished by either by joining the MLS organization or by forming a partnership with a current member.
   
4. A revenue model. Earth Point can capably take care of steps one through three. We need someone local to take care of step four. It would take about a month to map the county assessor data onto Google Earth. It would take perhaps two more months to include the MLS data. From there, it would be good to budget time for keeping it current and for a regular stream of enhancements.

With over 20-million records in its database and a fast presentation speed, Earth Point ably manages large ESRI shape files, robust databases, the web environment, and Google Earth. Earth Point can map fixed and mobile assets, turning Google Earth into an information manager for almost any system. Please call if Earth Point can assist with any of your IT or data processing needs.

Phone 208.860.6311 or email bill.clark@earthpoint.us.

Earth Point real estate software is protected by copyright. Local implementations are licensed to the client.

Quarter Sections available with BLM data

Quarter sections are now included with the BLM Township and Range data. Due to the sheer number of quarter sections (over 17 million), Earth Point did not included these previously.

How it works.

1. Earth Point gets it data from BLM shape files available at http://www.geocommunicator.gov/GeoComm/lsis_home/home/index.html
2. Earth Point formats the data, stores it in a database, and manages the interaction with Google Earth.

Note: I have spot-checked the data, but I have not checked all 17 million records! If you find an inconsistency, please let me know.

View the Township and Range Data on Google Earth.

1. Open Google Earth. Zoom into an area of interest over the western United States. The picture below is near Blackfoot, Idaho. It was selected because irrigated crop circles, which follow the pattern of land ownership, are generally laid out within the boundaries of quarter sections.
2. Go to www.earthpoint.us/Townships.aspx.
3. Scroll down to "BLM Township, Range, and Section."
4. Click the "View on Google Earth" button.
5. The screen switches back to Google Earth.
6. The orange grid shows the BLM Townships, which are six miles square.

BLM Townships on Google Earth. Click for larger image.

Zoom in on a Township, see Sections.

1. Double-click an orange dot. This zooms you in closer.
2. After a few seconds, the township is divided up into purple squares. These are Sections, which are one-mile square.

BLM Sections on Google Earth. Click for larger image.

Zoom in on a Section, see Quarters.

1. Double-click a purple dot. This zooms you in closer.
2. After a few seconds, the section divided up into green squares. Depending on the survey, these will be Quarter sections (1/2 mile square), Quarter/Quarter sections (1/4 mile square), or similar. The picture below shows Quarter/Quarter sections.

BLM Quarter/Quarters on Google Earth. Click for larger image.

Township and Range

A few months ago I was asked if I could overlay a parcel map onto Google Earth. The property was in a rural area south of San Francisco. Since I am not familiar with the area, it took an hour and numerous Google searches to get an idea of where map should be located.

However, now that Township and Range is available on Google Earth, the process only takes a few minutes.

You can see the result below, or download the corresponding kmz file.

Plat map overlaid on Google Earth. Shown with BLM section lines. Click for larger image.

Thanks to Nick Wold of Orbit Investments for suggesting that BLM townships be mapped onto Google Earth.

How to position a plat map onto Google Earth.

If the map is of an area that has BLM coverage and if you have a rough idea about its location, then you could possibly take this shortcut.

1. Zoom into the area on Google Earth.
2. Go to the Earth Point Township & Range page.
3. Under "BLM Townships, Ranges, and Sections" click the "View on Google Earth" button.
4. Once the Townships and Sections appear on Google Earth, mouse-over the purple icons and find the section you are looking for.
5. Then go directly to the Put the map onto Google Earth section below.

Otherwise, start at the beginning...

We need to know which state and which prime meridian the map is part of.

Plat map. Click for larger image.

1. Click on the plat map above to see it full size. At the top of the image we see that it is part of T10S R2E (Township 10 South, Range 2 East) in Santa Clara County, California. The map itself covers sections 16 and 17.
2. California has three principal meridians. The next few steps show one way to figure out which one to use.
3. Go to the Google Earth "Fly To" box and type in "Santa Clara, California". The city of Santa Clara is located in Santa Clara County, so now we are in the neighborhood.
4. Go to Earth Point's Township & Range page.
5. In the "National Atlas" section, click the "View On Google Earth" button. "National Atlas" is used because it has the best coverage.
6. The Google Earth screen fills with township outlines.
7. Mouse-over the yellow icons. You will see that these townships originate from the "Mount Diablo" principal meridian.
   
   
   "National Atlas" townships. Centered on T10S R2E, Santa Clara County. Click for larger image.
   
   
8. At this point, you could look for T10S R2E, but this is harder than it seems. Much of California's land survey is based on original land grants and is not laid out in a nice grid. Therefore, we will use Earth Point's "Fly To" button to locate the township.
9. To keep the Google Earth screen from becoming too cluttered, let's delete the townships we already have. In the Google Earth "My Places" section, right click on "Earth Point Townships ... National Atlas". On the pop-up menu, click "Delete".

"Fly To" takes you in.

1. Go to the Township & Range page. In the drop-down boxes, select "California", "Mount Diablo", "10S", and "2E".
2. Click the "Fly To On Google Earth" button.
3. T10S R2E is displayed on the Google Earth screen.
4. To position the plat map, we also need section lines.

BLM has sections.

1. Go to the Township & Range page.
2. Under "BLM Townships, Ranges, and Sections", click the "View On Google Earth" button.
3. The BLM townships are displayed on Google Earth. If you zoom in close enough, the sections are also displayed.
4. Mouse-over the purple dots to find sections 16 and 17. We could stop here, but let's place the map onto Google Earth.
   
   
   "BLM" townships, T10S R2E Section 16. Click for larger image.

Put the map onto Google Earth (optional).

1. Normally, we get plat maps from a county assessor's office, title company, or the like.
2. For this example, we can use the map above.
3. Scroll up to the picture captioned Plat map. Click for larger image. Right-click the map. Click "Save As" on the pop-up menu.
4. We are going to make an image overlay. The Google Earth User Guide has more information about image overlays.
5. On the Google Earth menu at the top of the screen, click "Add" then "Image Overlay".
6. On the window that pops-up, click the "Browse" button and get the plat map you saved.
7. Shrink, stretch, and rotate the plat map to fit BLM sections 16 and 17 as best you can. It will not be perfect.
8. Adjust the transparency so that you can see both the dark lines on the plat map and features on the underlying Google Earth imagery.
   
   
   Plat map aligned with Google Earth. Transparency is set to show the underlying satellite imagery. Transparency will be removed before the image overlay is saved. Click for larger image.
   
   
9. Shrink, stretch, and rotate the plat map again, this time to fit the Google Earth imagery.
10. Remove the transparency.
11. Add a comment or two and save the image overlay.
12. That's it!

Virtual Tours

Virtual tours are a great way to market a home. With 360-degree panoramas, additional pictures, and even room planners it is easy to see why virtual tours are so popular.

Each listing in our MLS can link to a virtual tour. Earth Point displays this link provided that it points to a known tour company.

Another requirement is that the tour company must offer a non-branded version of the tour. Branded tours promote a real estate company and its agents. Non-branded tours promote just the property. Earth Point always displays the non-branded tour, even if a branded link is entered into the MLS system.

The number of virtual tour companies is ever growing. If your listing uses a company that is not shown here, please let me know.

Virtual Tour Companies Known to Earth Point
360House
InTouch Home Tours
Just Snooping
Obeo
Real Estate Shows
Real Tour Vision
Tour Factory
Tour Real Estate
Vi360
Visual Tour
Windermere

Floor Plans on Google Earth

Recently, an out of town customer was was interested in City Side Lofts, a condominium project in downtown Boise. One challenge was that it was difficult to communicate how the units are laid out, which way the windows face, and what the different views might be. Our solution was to superimpose the floor plans onto Google Earth.

Click here to download the result. Once opened in Google Earth, click and unclick the various folders to see the floor plan for each level.

Combine this with the web cam, and you have a good idea of how the building is put together.

If you have a similar request, I am happy to help!

Touring Homes with Earth Point

When working with clients, I use MS Word or NotePad to keep lists of the MLS numbers we have looked at or are interested in.

To organize the lists, I put a short description at the beginning of each line. The MLS numbers follow, separated by commas. Like this:

Jan 12 looked at: 98280903, 98277414, 98281328
Jan 22 preparation: 98283878, 98280321, 98284890, 98259765

From there it is a simple matter to display the listings on Google Earth. I "copy" a row of MLS Numbers into the clipboard and "paste" it into the MLS Number(s) field on the Earth Point home page.

Download to Google Earth, and there are the listings. I can even take my laptop on tour and use Google Earth to navigate from house to house. Of course, someone else has to drive!

"Year Built" added to search critera

"Year Built" was added at the request of one of our users. Thanks for the input!

Updated Mapping Files

The county mapping files have been updated, which means that the newest addresses and subdivisions can be mapped onto Google Earth. Earth Point gets new mapping data every few months. For the current set, Ada County data was published December 28, 2006. Canyon County data was published January 11, 2007.

Two web cams added

City Side Lofts and Royal Plaza are condominiums under construction in downtown Boise. You can download Boise and Caldwell area web cams from the Around Town page.

Season's Greetings

It has been a real pleasure meeting some of you and helping you with Google Earth and your real estate questions. Thank you everyone for your support and words of encouragement. Based on your feedback, there have been several improvements made since Earth Point went live in March, 2006.

• Listings can be displayed on Google Earth or on Google Maps.
• Improved matching algorithms mean that several hundred more listings are mapped than were previously.
• County assessor data can be mapped for any property, whether or not it is for sale, using the Property Search and County GIS pages.
• Ada County traffic cameras, a guide to Idaho airports, an historical byway, and assorted web cams are featured on the Around Town page.
• Google released version 4 of Google Earth. Version 4 has an improved user interface and handles large amounts of data much better than version 3.
• Google updated the satellite imagery for the Boise area and fixed a large misalignment just west of town.

Remember Your Parents' Interest Rates

This picture helps put things into perspective. It appeared in the Idaho Business Review and was mailed to me by the author.