Executing a spatial join and assigning point attributes to a polygon

We'll now get back to some more golf action where we would like to execute a spatial attribute join. We're given a situation where we have a set of polygons, in this case, these are in the form of golf greens without any hole number. Our hole number is stored in a point dataset that is located spatially within the green of each hole. We would like to assign each green its appropriate hole number based on its location within the polygon.

The OSM data from the Pebble Beach Golf Course located in Monterey California is our source data. This golf course is one the great golf courses on the PGA tour and is well mapped in OSM.

Tip

If you are interested in getting golf course data yourself from OSM, it is recommended that you use the great Overpass API at http://overpass-turbo.eu/. This site enables you to export the OSM data as GeoJSON or KML, for example.

To download all the golf-specific OSM data, you will need to correct tags...