What everybody should like in SharePoint 2013? Geolocation field – Setup and use

SharePoint 2013 now offers a so called geolocation field. This field provides a new field of type geolocation where users can input longitude and latitude of a point of interest like office locations or customer locations, etc.

4 Tipps you should know:

Before you can use it, you should know that it’s not available in the choice of column types. You have to setup the field using Powershell or any other script.



Add-PSSnapin Microsoft.SharePoint.PowerShell

$web = Get-SPWeb "http://servername/sites/sitecollection"
$list = $web.Lists["My Offices"]
$list.Fields.AddFieldAsXml(
"<field Type='Geolocation' DisplayName='Office Location'></field>",
$true,
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)


In order to use the field, a bing maps key has to be add to the farm or the site collection by using Powershell or Javascript or any other script.



//for the farm
Set-SPBingMapsKey -BingKey "yourBINGmapsKEY"

//for a site collection
Add-PSSnapin Microsoft.SharePoint.PowerShell
Get-SPWeb "http://server/sites/sitecollection"
$web.AllProperties["BING_MAPS_KEY"] = "yourBINGmapsKEY"
$web.Update()

It is necessary to install a special software component to use the geolocation field. It’s a MSI-Package named “SQLSysClrTypes.msi – Here you find more information.

You can put your data manually by typing or you use a .csv file where the coordinates are included or using automatically scripts to insert the locations you like.



$item["Office Location"] = "POINT (Longitude Latitude)"


Another good source of resource is the post of Tobias Zimmergren with examples and pictures.

..:: I LIKE SHAREPOINT ::..

The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.

Karsten Pohnke About Karsten Pohnke
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.

Submit comment

Allowed HTML tags: <a href="http://google.com">google</a> <strong>bold</strong> <em>emphasized</em> <code>code</code> <blockquote>
quote
</blockquote>

Please fill in the captcha: * Time limit is exhausted. Please reload CAPTCHA.