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.

[sourcecode language=”csharp”]

Add-PSSnapin Microsoft.SharePoint.PowerShell

$web = Get-SPWeb “http://servername/sites/sitecollection”
$list = $web.Lists[“My Offices”]


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.

[sourcecode language=”csharp”]

//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”

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.

[sourcecode language=”csharp”]

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


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


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.

About Karsten Schneider 312 Articles
Consultant for Microsoft 365 Applications with a strong focus in Teams, SharePoint Online, OneDrive for Business as well as PowerPlatform with PowerApps, Flow and PowerBI. I provide Workshops for Governance & Security in Office 365 and Development of Solutions in the area of Collaboration and Teamwork based on Microsoft 365 and Azure Cloud Solutions. In his free time he tries to collect tipps and worthy experience in this blog.

Be the first to comment

Leave a Reply

Your email address will not be published.