Publication using geolocation

Data used for this Sydney Harbour Bridge demo is taken from the Google Maps Platform.

This demo uses a publication (created with the Data Publisher) with geolocation integration to built a list of places from a database table and shows the selected places on a map. Markers can be clicked on the list as well as the map. Searches within the publication are immediately reflected on the map. Ranges can be changed interactively. Geolocation is a premium feature.

NameTypeAddressDistance
NameTypeAddressDistance

Shortcode arguments used for this demo

[wpdataaccess pub_id="10"]

Adding geolocation to a publication

To use geolocation in a publication it needs to be enabled for the database table used in the publication. Ones the geolocation information is stored in a database table it can be used by adding the necessary options to the publication. Read more…

{
	"lengthMenu": [ 3, 6, 9 ],
	"pageLength": 3,
	"stateSave": false,
	"wpda_geo": {
		"show_map": true,
		"map_init": "open",
		"map_location": "fixed",
		"show_filter": true,
		"geo_filter": "before",
		"geo_marker_column": 1,
		"geo_marker_position": "after"
	}
}

Publication options

  • wpda_geo Adds geolocations support to a publication (geolocation must be enabled first)
  • wpda_geo > show_map Set to false to hide map (map shown for any other value and if option is missing)
  • wpda_geo > map_init Set to open to show map on startup (user needs to click globe icon on any other value and if options is missing)
  • wpda_geo > map_location Possible values: fixed (use fixed location), user (use user location) and plugin (use configuration settings)
  • wpda_geo > show_filter Allow user to change range (true | false)
  • wpda_geo > geo_filter Possible values: before | after (location geofilter against publication search filter)
  • wpda_geo > geo_marker_column Column index where to add marker
  • wpda_geo > geo_marker_position Possible values: before | after (position of marker against column values)

Notes

  • Places are ordered by distance (closest first)
  • The current version does not support additional sorting
  • Use globe icon to show/hide map
  • This is a responsive solution and works on any device

The sql script to create the table and insert the test data can be downloaded here. Start the Data Explorer to execute the script file, click “Import data/Execute script(s)“, select the ZIP (no need to unpack) and follow the instructions. Follow these instructions to create a map from your markers test table.