Mapping Google Maps with SharePoint 2010 List Data (Part 2)

This is Part 2 of ‘Google Maps SharePoint’. We left off in Part 1 with referencing our jQuery and SPServices JavaScript files. Now we need to create a SharePoint list that will contain our plotting data.

Creating the List

For our example, we will be plotting some oil rigs. Navigate to a site where you would like to plot some SharePoint list data and create a custom list, named OilRigMapList, with the following fields:

  • Title (created by default)
  • Longitude (single line of text)
  • Latitude (single line of text)
  • Region (Choice: -, East, Central, West)
  • Manned (Yes/No)
  • Picture (Hyperlink or Picture: Set as Hyperlink)

Populating the List

Next we will populate our list with the following data to plot in our later sessions. Populate the list with the following data:

[table style=”1″]

[tr][th]Title[/th] [th]Longitude[/th] [th]Latitude[/th] [th]Region[/th] [th]Manned[/th] [th]Picture[/th][/tr]

[tr][td]OilRig Alpha[/td] [td]-88.24009[/td] [td]29.32725[/td] [td]East[/td] [td]Yes[/td] [td](Leave empty)[/td][/tr]

[tr][td]OilRig Beta[/td] [td]-91.255148[/td] [td]28.584194[/td] [td]East[/td] [td]Yes[/td] [td](Leave empty)[/td][/tr]

[tr][td]OilRig Charlie[/td] [td]-92.73882[/td] [td]28.950794[/td] [td]Central[/td] [td]No[/td] [td](Leave empty)[/td][/tr]

[tr][td]OilRig Delta[/td] [td]-93.933407[/td] [td]28.390265[/td] [td]West[/td] [td]Yes[/td] [td](Leave empty)[/td][/tr]


Next week we will begin writing the Javascript and jQuery scripts to plot the data.

January 21, 2013


Email [email protected] with any questions you have pertaining to this course.

New CPE Accredited Courses Now Available for Dynamics AX, GP, and NAVEARN CREDITS TODAY