Mixing
Find duplicates of rounded geometries with mongo aggregation
0
I have the following mongodb query which find objects by duplicated geometries within a collection:
db.coll.aggregate([{
$match: { // Selection
}
},
{
$group: {
_id: {
geometry: "$geometry"
},
dups: {
"$addToSet": "$_id"
},
count: {
"$sum": 1
}
}
},
{
$match: {
count: {
"$gt": 1
} // Duplicates considered as count greater than one
}
}
],
{ allowDiskUse: true }
I would like to change this query to find "similar" geometries, which means if the first n digit of the coordinates (so floored coordinates) are the same they should consider identical. All of my geometries are LineStrings.
mongodb aggregation-framework
asked Nov 19 '18 at 15:07
Paxi
418
add a comment |
0
I have the following mongodb query which find objects by duplicated geometries within a collection:
db.coll.aggregate([{
$match: { // Selection
}
},
{
$group: {
_id: {
geometry: "$geometry"
},
dups: {
"$addToSet": "$_id"
},
count: {
"$sum": 1
}
}
},
{
$match: {
count: {
"$gt": 1
} // Duplicates considered as count greater than one
}
}
],
{ allowDiskUse: true }
I would like to change this query to find "similar" geometries, which means if the first n digit of the coordinates (so floored coordinates) are the same they should consider identical. All of my geometries are LineStrings.
mongodb aggregation-framework
asked Nov 19 '18 at 15:07
Paxi
418
2
"... but I do not think it matters" - Oh it most certainly does. matter. GeoJSON uses varying formats, mostly with different "ring" configurations of nested arrays. So the exact type of data you want to "extract these points" from is intrinsically important to the structure of the aggregation pipeline. There is no "generic" way to break apart either/or ofPolygon,MultiPolygonorLineStringsince they are all basically different in structure. That's by-design
– Neil Lunn
Nov 19 '18 at 15:12
Yes, you are right, I'm going to clarify the question then,
– Paxi
Nov 20 '18 at 6:54
add a comment |
0
0
0
I have the following mongodb query which find objects by duplicated geometries within a collection:
db.coll.aggregate([{
$match: { // Selection
}
},
{
$group: {
_id: {
geometry: "$geometry"
},
dups: {
"$addToSet": "$_id"
},
count: {
"$sum": 1
}
}
},
{
$match: {
count: {
"$gt": 1
} // Duplicates considered as count greater than one
}
}
],
{ allowDiskUse: true }
I would like to change this query to find "similar" geometries, which means if the first n digit of the coordinates (so floored coordinates) are the same they should consider identical. All of my geometries are LineStrings.
mongodb aggregation-framework
asked Nov 19 '18 at 15:07
Paxi
418
I have the following mongodb query which find objects by duplicated geometries within a collection:
db.coll.aggregate([{
$match: { // Selection
}
},
{
$group: {
_id: {
geometry: "$geometry"
},
dups: {
"$addToSet": "$_id"
},
count: {
"$sum": 1
}
}
},
{
$match: {
count: {
"$gt": 1
} // Duplicates considered as count greater than one
}
}
],
{ allowDiskUse: true }
I would like to change this query to find "similar" geometries, which means if the first n digit of the coordinates (so floored coordinates) are the same they should consider identical. All of my geometries are LineStrings.
mongodb aggregation-framework
mongodb aggregation-framework
asked Nov 19 '18 at 15:07
Paxi
418
asked Nov 19 '18 at 15:07
Paxi
418
edited Nov 20 '18 at 6:56
asked Nov 19 '18 at 15:07
Paxi
418
asked Nov 19 '18 at 15:07
Paxi
418
asked Nov 19 '18 at 15:07
Paxi
418
418
2
"... but I do not think it matters" - Oh it most certainly does. matter. GeoJSON uses varying formats, mostly with different "ring" configurations of nested arrays. So the exact type of data you want to "extract these points" from is intrinsically important to the structure of the aggregation pipeline. There is no "generic" way to break apart either/or ofPolygon,MultiPolygonorLineStringsince they are all basically different in structure. That's by-design
– Neil Lunn
Nov 19 '18 at 15:12
Yes, you are right, I'm going to clarify the question then,
– Paxi
Nov 20 '18 at 6:54
add a comment |
2
"... but I do not think it matters" - Oh it most certainly does. matter. GeoJSON uses varying formats, mostly with different "ring" configurations of nested arrays. So the exact type of data you want to "extract these points" from is intrinsically important to the structure of the aggregation pipeline. There is no "generic" way to break apart either/or ofPolygon,MultiPolygonorLineStringsince they are all basically different in structure. That's by-design
– Neil Lunn
Nov 19 '18 at 15:12
Yes, you are right, I'm going to clarify the question then,
– Paxi
Nov 20 '18 at 6:54
2
2
"... but I do not think it matters" - Oh it most certainly does. matter. GeoJSON uses varying formats, mostly with different "ring" configurations of nested arrays. So the exact type of data you want to "extract these points" from is intrinsically important to the structure of the aggregation pipeline. There is no "generic" way to break apart either/or of
Polygon, MultiPolygon or LineString since they are all basically different in structure. That's by-design– Neil Lunn
Nov 19 '18 at 15:12
"... but I do not think it matters" - Oh it most certainly does. matter. GeoJSON uses varying formats, mostly with different "ring" configurations of nested arrays. So the exact type of data you want to "extract these points" from is intrinsically important to the structure of the aggregation pipeline. There is no "generic" way to break apart either/or of
Polygon, MultiPolygon or LineString since they are all basically different in structure. That's by-design– Neil Lunn
Nov 19 '18 at 15:12
Yes, you are right, I'm going to clarify the question then,
– Paxi
Nov 20 '18 at 6:54
Yes, you are right, I'm going to clarify the question then,
– Paxi
Nov 20 '18 at 6:54
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53377462%2ffind-duplicates-of-rounded-geometries-with-mongo-aggregation%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53377462%2ffind-duplicates-of-rounded-geometries-with-mongo-aggregation%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
2
"... but I do not think it matters" - Oh it most certainly does. matter. GeoJSON uses varying formats, mostly with different "ring" configurations of nested arrays. So the exact type of data you want to "extract these points" from is intrinsically important to the structure of the aggregation pipeline. There is no "generic" way to break apart either/or of
Polygon,MultiPolygonorLineStringsince they are all basically different in structure. That's by-design– Neil Lunn
Nov 19 '18 at 15:12
Yes, you are right, I'm going to clarify the question then,
– Paxi
Nov 20 '18 at 6:54