Trying to Count Number of Points within Specified Distance from Lines using Carto?Number of lines within...
What is the domain in a tikz parametric plot?
How to simplify this time periods definition interface?
Opacity of an object in 2.8
How to write cleanly even if my character uses expletive language?
Brexit - No Deal Rejection
My adviser wants to be the first author
Use of undefined constant bloginfo
Can a druid choose the size of its wild shape beast?
Employee lack of ownership
If curse and magic is two sides of the same coin, why the former is forbidden?
What approach do we need to follow for projects without a test environment?
How does the Sleep spell interact with the Aspect of the Moon eldritch invocation?
A link redirect to http instead of https: how critical is it?
Python if-else code style for reduced code for rounding floats
Official degrees of earth’s rotation per day
What did Alexander Pope mean by "Expletives their feeble Aid do join"?
Are there other languages, besides English, where the indefinite (or definite) article varies based on sound?
Time travel from stationary position?
Why would a flight no longer considered airworthy be redirected like this?
Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?
Hacking a Safe Lock after 3 tries
SOQL: Populate a Literal List in WHERE IN Clause
How big is a MODIS 250m pixel in reality?
Define, (actually define) the "stability" and "energy" of a compound
Trying to Count Number of Points within Specified Distance from Lines using Carto?
Number of lines within specified distance of thousands of polygonsJoin attributes by location doesn’t appear to be including data that it shouldFinding points within distance of polygon using ArcGIS for Desktop?Point Distances to many buffer zonesUsing FME to aggregate POI to one pointCalculate Great Circle Distance between two point layers via way pointHow to identify multiple points with multiple buffersCalculating distance between pixel values on raster layers using QGISGrouping points with distance using ArcGIS Desktop?Calculating nearest distance between 2 points and creating line between them avoiding barrier using ArcGIS Desktop?
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.
carto proximity aggregation feature-count
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
bumped to the homepage by Community♦ 16 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
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.
carto proximity aggregation feature-count
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
bumped to the homepage by Community♦ 16 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
If you are trying to count the number of points that overlap with your lines, your second approach is the right one. In fact, you have pointed out that the results were accurate. Your main approach is wrong.
– ramiroaznar
Feb 13 at 8:22
add a comment |
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.
carto proximity aggregation feature-count
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
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.
carto proximity aggregation feature-count
carto proximity aggregation feature-count
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
edited Feb 14 at 1:13
PolyGeo♦
53.7k1781244
53.7k1781244
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
asked Feb 13 at 4:34
Samantha BambergerSamantha Bamberger
34
34
bumped to the homepage by Community♦ 16 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 16 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
If you are trying to count the number of points that overlap with your lines, your second approach is the right one. In fact, you have pointed out that the results were accurate. Your main approach is wrong.
– ramiroaznar
Feb 13 at 8:22
add a comment |
If you are trying to count the number of points that overlap with your lines, your second approach is the right one. In fact, you have pointed out that the results were accurate. Your main approach is wrong.
– ramiroaznar
Feb 13 at 8:22
If you are trying to count the number of points that overlap with your lines, your second approach is the right one. In fact, you have pointed out that the results were accurate. Your main approach is wrong.
– ramiroaznar
Feb 13 at 8:22
If you are trying to count the number of points that overlap with your lines, your second approach is the right one. In fact, you have pointed out that the results were accurate. Your main approach is wrong.
– ramiroaznar
Feb 13 at 8:22
add a comment |
1 Answer
1
active
oldest
votes
I'm not familiar with Carto Builder, but you do not want to do an analysis intersect. I can't tell by your illustration, but based on the counts you are getting it would seem that the approach you used is treating them as sliver polygons rather than overlapping buffer polygons. There are several approaches but the easiest would be to use overlapping point buffers and Spatial Join intersect, many to one (point buffers to lines) to get a count of point buffers.
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f311993%2ftrying-to-count-number-of-points-within-specified-distance-from-lines-using-cart%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I'm not familiar with Carto Builder, but you do not want to do an analysis intersect. I can't tell by your illustration, but based on the counts you are getting it would seem that the approach you used is treating them as sliver polygons rather than overlapping buffer polygons. There are several approaches but the easiest would be to use overlapping point buffers and Spatial Join intersect, many to one (point buffers to lines) to get a count of point buffers.
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
add a comment |
I'm not familiar with Carto Builder, but you do not want to do an analysis intersect. I can't tell by your illustration, but based on the counts you are getting it would seem that the approach you used is treating them as sliver polygons rather than overlapping buffer polygons. There are several approaches but the easiest would be to use overlapping point buffers and Spatial Join intersect, many to one (point buffers to lines) to get a count of point buffers.
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
add a comment |
I'm not familiar with Carto Builder, but you do not want to do an analysis intersect. I can't tell by your illustration, but based on the counts you are getting it would seem that the approach you used is treating them as sliver polygons rather than overlapping buffer polygons. There are several approaches but the easiest would be to use overlapping point buffers and Spatial Join intersect, many to one (point buffers to lines) to get a count of point buffers.
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
I'm not familiar with Carto Builder, but you do not want to do an analysis intersect. I can't tell by your illustration, but based on the counts you are getting it would seem that the approach you used is treating them as sliver polygons rather than overlapping buffer polygons. There are several approaches but the easiest would be to use overlapping point buffers and Spatial Join intersect, many to one (point buffers to lines) to get a count of point buffers.
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
answered Feb 13 at 14:47
RGfromRWBJVRGfromRWBJV
12
12
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f311993%2ftrying-to-count-number-of-points-within-specified-distance-from-lines-using-cart%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If you are trying to count the number of points that overlap with your lines, your second approach is the right one. In fact, you have pointed out that the results were accurate. Your main approach is wrong.
– ramiroaznar
Feb 13 at 8:22