There were multiple points stacked on the same coordinates that I did not notice.
I am trying to count the number of points within 10km of lines (routes) so the routes can be styled according to the number of points within proximity. However, the results are not turning out as expected. Using Carto Builder, I created a 10km distance buffer around the points. On the lines layer I added the analysis for Intersect to the buffer layer with the count operation. However, when I check the results the count is incorrect (or rather, now what I want). For example, there are 6 points show below but results for the counts on the lines vary from 11, 12, 21, and 23.
I then tried the reverse to see why the results were behaving in this manner. I created 10km distance buffers around the lines (routes). On the points layer I added the analysis for Intersect to the buffer of the lines with the count operation. These results were accurate.
I welcome any suggestions on a different perspective of the problem, even if it requires a SQL query instead of the built in analyses.