Wherefore art thou?
Trying to deal with data in a location friendly manner is not a new problem. Years ago, when Apex was but a new language and lacked some higher mathematical functions like sine and cosine I was on a project to provide data sets based on an account record’s address. Trying to determine location without things like sine and cosine is difficult enough even for someone with an advanced knowledge of trigonometry. So that was three things I didn’t have. Our solution was to tag data based on a database which could translate ZIP codes into lat and long and then do queries based on squares. Because when you don’t have trig on your side, squares are much easier to deal with.
It was clumsy and hacky. It was also kind of awesome – and as a side note was the project that got me up on stage for the first time in front of developers. Now with Winter ’13, though, you can get even more awesome without the hackery.
Adding Geolocation to your Objects
The first thing you’ll need to do as a new custom field to your object. Go to the object definition in Setup, and click New Custom Field. In Winter ’13, you’ll see a new field type – Geolocation.
Currently you are not able to add Geolocation fields via Schema Builder. One of the choices you’ll need to make is whether you will want the field to be defined in degree or decimal notation. Personally, I find decimal more common when using most geolocation services and is overall easier to store. Apex will also refer to the value with decimal notation regardless, so this decision is mostly about how it will be represented externally and you’ll need to determine the number of decimal places to extend your field with regardless. More decimal places mean greater accuracy, with six decimal places equalling to about 1 meter of accuracy:
Having extended the definition of Contact to know latitude and longitude, let us update a contact record quickly so that we can start using SOQL and Apex. For this, I just grabbed this Geolocation Chrome Extension which makes it easy to look up lat and long based on an existing address, popped over to some sample records and added the information. Don’t worry though, we’ll get to how to programmatically update the data as well as adding it via Bulk API.
Searching for Data based on Location
Now the fun stuff. Having geocoded some contacts based on the Sears (err, uh … Willis) Tower here in Chicago as well as the Salesforce HQ in downtown San Francisco, we can hop into the also-new-to-Winter13 query editor within Developer Console and do the following search:
That SOQL statement will do the distance calculation for us and return our one contact within a mile tagged for those coordinates (One Market Street in San Francisco):
If I flip that lesser than over to a greater than, we get everyone outside of a mile from Salesforce HQ, namely:
Accessing Geolocation via Apex and Visualforce
Note the multiple uses of double underlines after the custom field name. So in our case, Contact.Location__c_Latitude__s would refer specifically to the Latitude portion of our Location field. So knowing that, we can create a Visualforce form powered by some HTML5 trickery to add latitude and longitude based on the current user’s actual location:
Here’s a screenshot of the page in action:
If you want to perform dynamic geolocation calls in Apex, you currently a little limited in that the DISTANCE filter does not allow for bound data (although I’m told this is high on the list for post-beta plans). So, in order to perform dynamic searches you would need to utilize a generated string passed into Database.query(). As an example, here’s a RemoteAction method to find anyone within 10 miles of a specific location:
Accessing Geolocation Via API
Using the same syntax, we can offer up API access to the Location fields as well. So if I sent this POST data via REST to create a new record:
The record would be created with the Location fields filled out. Or if I wanted to search, I could send this over GET:
A geocoded world of possibilities
Geolocation is one of those technologies which has become slowly more and more pervasive. It’s in our browsers, our tablets, our smartphones – and now in our datasets and query language for the Salesforce Platform. Even in beta form, Geolocation in Winter ’13 provides some pretty amazing capabilities to both existing and new applications.