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]

[/table]

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

January 21, 2013
  • Martin

    This is a great post….did you post the article on “Next week we will begin writing the Javascript and jQuery scripts to plot the data.”? Have been following this series and would really appreciate some direction on this last bit of plotting the data