11

I'm researching location search (ultimately on a Force.com site). For example's sake, the problem is to dynamically show a user what stores are w/in a certain distance (say miles) of a postal code that they enter. I'd probably have a few fixed options: 5, 10, 15, 25, 50, 50+ miles.

I'm wondering if the Geolocation pilot feature would be useful. I can't get access to the pilot and I don't see public API docs. The blog post shows the Geolocation object taking longitude and latitude parameters. Is there a Constructor that takes postal codes? Or, a recommended way of getting longitude and latitude from postal code?

I'm curious how other people solve this within Salesforce with or without the Geolocation object. Also, are there limitations and/or governor limits that people have hit and/or worry about in their solutions?

10

I've used Google Maps API to GeoCode data into Latitude and Longitude fields in SFDC. You then have to use a Google Maps Mashup to display the SFDC records based on SOQL queries. This was before SFDC offered Lat/Lon fields and SOQL calls for distance. Back then you had to use a bounding box algorithm with SOQL to find the records.

I have opensource code here: https://github.com/corycowgill/sfbusradar You can look at my Dreamforce 2011 Presentation here which has details: http://www.youtube.com/watch?v=wwTdGqOygBQ

Note: Minutes 9:30 - about 14 detail how to use GeoCoding Service and LAt/lon fields on your Object.

Also you can take a look at FindNearby on the AppExchange from Force.com Labs.

You'll have to use a GeoCoding service obviously as everyone else said above, either Google Maps which is free but limited to 2500 GeoCoded Records per Day as well as T&C that requires you to display in Google Map Mashup. My source code and video show you how to get started with GeoCoding. Or you could go and purchase a product like ArrowPointe or a few others on the AppExchange that do just GeoCoding.

Finally, here are the Google GeoCoding Docs: https://developers.google.com/maps/documentation/geocoding/

Good Luck!

3

I've messed with the pilot. It's just a field type for lat/lon. Salesforce does not supply any data to you or turn an address into a lat/lon (geocoding). If you are able to populate the data, then you can use SOQL to do things like find records within X miles of another.

Our app, Geopointe, can help with this kind of thing right now and includes geocoding.

2

I've heard some rather credible rumors that this might be a public beta (or even a GA if we're really lucky) in the next release of salesforce. I'd advise signing up for a prerelease sandbox and crossing your fingers for the moment.

As far as I know it won't support postal codes out of the box, you'd probably need a 3rd party service to resolve them into lat/long.

  • 2
    right, it has distance based queries but currently no geocoding service, its up to you to get your POI into lat/long – superfell Aug 14 '12 at 15:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.