I have shapefiles pertaining to NYC traffic density as well as NYC trucking routes, and what I'd like to do is join the attribute data from the trucking route file into the traffic file.
Seen here, blue is the traffic data and red is the trucking route data. In the trucking route attribute table is a column (titled TruckRoute) indicating that yes, this stretch of road is indeed a trucking route. Because only the trucking roads are included, there is only one value for that variable.
What I want to do: I want to get that TruckRoute column into the attribute table for my traffic data shapefile, so that when I eventually cross-reference this with another data source I can have traffic data and truck route data for any given point. I realize that for the non-overlapping street that column won't port over, but I can address that in R later on.
What I've tried: I tried just doing a standard spatial join (Vector -> DM tools -> Join attributes by location) but if it works at all, I only end up with null values in the TruckRoute column of the traffic attribute table, regardless of the settings I use. I tried manually creating the TruckRoute column in the traffic attribute table so that they would have that variable in common, but no dice.
I've also tried creating a small buffer around the traffic line layer so that the truck line layer would be well within it. Same result.
I've tried converting the layers to points and polygons, and doing a spatial join with every combination. No luck.