Western Canada Land Location Geocoder
This is a Geocoder which will provide latitude and longitude values for correctly formatted legal land locations. Up to 1000 locations can be processed at a time
Designed for anyone managing large spreadsheets or databases containing land location data for western Canada, our land location geocoder provides a fast and effective way to generate map coordinates for every quarter section, half section, or entire section in your database. Converts legal land locations in Alberta, Saskatchewan, or Manitoba, into accurate latitude and longitude coordinates that can be used to build map-based applications to visualize data.
The geocoder is an Excel workbook, and requires you are running the latest version of Microsoft Excel ((currently Excel 2013) – older versions do not support enough worksheet rows). You’ll also need a PC with fairly fast processor, so higher-end laptops or desktops are a must here. Please note that this will not allow you to extract the raw data for use in creating other applications – if you are planning to build your own application to perform these or similar functions you should purchase the Legal Descriptions to Coordinates data instead.
How it Works:
- Open the Geocoder workbook for the desired Province (i.e. whichever Province your land locations are in).
- You’ll see a column in the Geocoder worksheet called Legal_Description.
- Paste or type your legal descriptions into this column. They must be formatted in the format SECTION-TOWNSHIP-RANGE-MERIDIAN, e.g. 33-33-33-W3 (returns section centre coordinates) OR using prefix NH/EH/WH/SH (for example NH-33-33-33-W3 returns the coordinates for the centre of the north half of the section) OR using prefix NE/NW/SE/SW (for example SW-33-3-33-W3 returns the coordinates for the centre of the South West quarter of the section). Here are the locations of the data returned for each prefix within the section:
- Once your locations have geocoded, the best method to export the data back into your original table is to copy the cells from the geocoder page containing the information you need, and paste them into the blank page in the workbook. MAKE SURE TO USE PASTE AS VALUES. Then, use Save As and save the contents of the single page as a CSV file.
Below is an example of how the geocoded data can be used; in just a few minutes geocoded data were imported into Google Fusion Tables. Below the video you can see the resulting map.