Joining data from multiple road lines onto polygons by location in QGIS

by TE_gis   Last Updated August 13, 2019 20:22 PM - source

I'm looking to add traffic data linked to a polyline shapefile of road centerlines to a multipolygon shapefile of land parcels. I want to join this data using proximity to roads instead of by matching addresses to create the most accurate traffic data (i.e. if a parcel is addressed on a side road but is cornered on a major thoroughfare). Inevitably, many parcels will have multiple traffic data inputs since one parcel can be near multiple roads, eliminating the usefulness of the NNJoin plugin.

I created a buffer for the road centerline to overlap with parcels nearby. I then used the "Join attributes by location" to input traffic data onto the parcel shapefile. I selected the "one to many" feature to get all relevant traffic info onto each parcel polygon.

The join created several superimposed polygons for each parcel, each with different traffic data from a different individual neighboring road (which I feared would happen). This functionally works for my purposes but is very inefficient. The file is multiple times the size it needs to be and is delayed in loading with each pan/zoom action.

How can I converge multiple traffic data points into one polygon, instead of assigning one polygon per traffic data point?

One acceptable, but less than ideal, solution will be to only accept the polygon with the greatest traffic flow, but I'm unsure of how to filter and eliminate polygons in that way.

Related Questions

Join attributes by location - false information

Updated December 09, 2018 19:22 PM