Is it possible to query which LineStrings are near another LineString in MongoDB?
0
If I have a MongoDB collection C with LineStrings {L1,L2,...,LN} composed of several points each and an extra LineString L0 not present in C, is it possible to query C for the nearest ones to L0?
I was trying without success something in line with the following:
A) Create geo index:
MongoConnection.getInstance().createIndex(DB, collection, new BasicDBObject("coordinates", "2d"), "geospacialIdx");
B) Add each LineString as:
double points = new double[N][2];
points= <- add coordinates
MongoConnection.getInstance().getCollection(DB,COLLECTION).insert(
new BasicDBObject("coordinates",points));
C) Query:
double points = new double[N][2];
points= <- coordinates of L0
MongoConnection.getInstance().getCollection(DB, COLLECTION).find(new BasicDBObject("$near",new BasicDBObject("coordinates",points)))
Thank you for your attention.
mongodb
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
add a comment |
0
If I have a MongoDB collection C with LineStrings {L1,L2,...,LN} composed of several points each and an extra LineString L0 not present in C, is it possible to query C for the nearest ones to L0?
I was trying without success something in line with the following:
A) Create geo index:
MongoConnection.getInstance().createIndex(DB, collection, new BasicDBObject("coordinates", "2d"), "geospacialIdx");
B) Add each LineString as:
double points = new double[N][2];
points= <- add coordinates
MongoConnection.getInstance().getCollection(DB,COLLECTION).insert(
new BasicDBObject("coordinates",points));
C) Query:
double points = new double[N][2];
points= <- coordinates of L0
MongoConnection.getInstance().getCollection(DB, COLLECTION).find(new BasicDBObject("$near",new BasicDBObject("coordinates",points)))
Thank you for your attention.
mongodb
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
No. The$nearand variants all require aPointtype ( or legacy pair ) and don't accept other objects.$geoWithinaccepts "shapes", but aLineStringis never "iwthin" aLineString. IMHO I have actually found it more useful to always storePointtypes, and instead of using things likeLineString, I just put other things in the document that says "These things are part of a group of things!". If I needLineStringas external data, then read the "group" and write theLineString. This seems to work best with the database logic implemented.
– Neil Lunn
Nov 21 '18 at 20:21
Forgot to mention$geoIntersects, but of course the reliance there is on the supplied shape actually intersecting with another. So that's not really "near" either.
– Neil Lunn
Nov 21 '18 at 20:36
@NeilLunn, thanks for the response. Don't you want to post it as an answer instead?
– João Matos
Nov 22 '18 at 9:43
add a comment |
0
0
0
If I have a MongoDB collection C with LineStrings {L1,L2,...,LN} composed of several points each and an extra LineString L0 not present in C, is it possible to query C for the nearest ones to L0?
I was trying without success something in line with the following:
A) Create geo index:
MongoConnection.getInstance().createIndex(DB, collection, new BasicDBObject("coordinates", "2d"), "geospacialIdx");
B) Add each LineString as:
double points = new double[N][2];
points= <- add coordinates
MongoConnection.getInstance().getCollection(DB,COLLECTION).insert(
new BasicDBObject("coordinates",points));
C) Query:
double points = new double[N][2];
points= <- coordinates of L0
MongoConnection.getInstance().getCollection(DB, COLLECTION).find(new BasicDBObject("$near",new BasicDBObject("coordinates",points)))
Thank you for your attention.
mongodb
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
If I have a MongoDB collection C with LineStrings {L1,L2,...,LN} composed of several points each and an extra LineString L0 not present in C, is it possible to query C for the nearest ones to L0?
I was trying without success something in line with the following:
A) Create geo index:
MongoConnection.getInstance().createIndex(DB, collection, new BasicDBObject("coordinates", "2d"), "geospacialIdx");
B) Add each LineString as:
double points = new double[N][2];
points= <- add coordinates
MongoConnection.getInstance().getCollection(DB,COLLECTION).insert(
new BasicDBObject("coordinates",points));
C) Query:
double points = new double[N][2];
points= <- coordinates of L0
MongoConnection.getInstance().getCollection(DB, COLLECTION).find(new BasicDBObject("$near",new BasicDBObject("coordinates",points)))
Thank you for your attention.
mongodb
mongodb
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
asked Nov 21 '18 at 17:57
João MatosJoão Matos
8481624
8481624
No. The$nearand variants all require aPointtype ( or legacy pair ) and don't accept other objects.$geoWithinaccepts "shapes", but aLineStringis never "iwthin" aLineString. IMHO I have actually found it more useful to always storePointtypes, and instead of using things likeLineString, I just put other things in the document that says "These things are part of a group of things!". If I needLineStringas external data, then read the "group" and write theLineString. This seems to work best with the database logic implemented.
– Neil Lunn
Nov 21 '18 at 20:21
Forgot to mention$geoIntersects, but of course the reliance there is on the supplied shape actually intersecting with another. So that's not really "near" either.
– Neil Lunn
Nov 21 '18 at 20:36
@NeilLunn, thanks for the response. Don't you want to post it as an answer instead?
– João Matos
Nov 22 '18 at 9:43
add a comment |
No. The$nearand variants all require aPointtype ( or legacy pair ) and don't accept other objects.$geoWithinaccepts "shapes", but aLineStringis never "iwthin" aLineString. IMHO I have actually found it more useful to always storePointtypes, and instead of using things likeLineString, I just put other things in the document that says "These things are part of a group of things!". If I needLineStringas external data, then read the "group" and write theLineString. This seems to work best with the database logic implemented.
– Neil Lunn
Nov 21 '18 at 20:21
Forgot to mention$geoIntersects, but of course the reliance there is on the supplied shape actually intersecting with another. So that's not really "near" either.
– Neil Lunn
Nov 21 '18 at 20:36
@NeilLunn, thanks for the response. Don't you want to post it as an answer instead?
– João Matos
Nov 22 '18 at 9:43
No. The
$near and variants all require a Point type ( or legacy pair ) and don't accept other objects. $geoWithin accepts "shapes", but a LineString is never "iwthin" a LineString. IMHO I have actually found it more useful to always store Point types, and instead of using things like LineString, I just put other things in the document that says "These things are part of a group of things!". If I need LineString as external data, then read the "group" and write the LineString. This seems to work best with the database logic implemented.– Neil Lunn
Nov 21 '18 at 20:21
No. The
$near and variants all require a Point type ( or legacy pair ) and don't accept other objects. $geoWithin accepts "shapes", but a LineString is never "iwthin" a LineString. IMHO I have actually found it more useful to always store Point types, and instead of using things like LineString, I just put other things in the document that says "These things are part of a group of things!". If I need LineString as external data, then read the "group" and write the LineString. This seems to work best with the database logic implemented.– Neil Lunn
Nov 21 '18 at 20:21
Forgot to mention
$geoIntersects, but of course the reliance there is on the supplied shape actually intersecting with another. So that's not really "near" either.– Neil Lunn
Nov 21 '18 at 20:36
Forgot to mention
$geoIntersects, but of course the reliance there is on the supplied shape actually intersecting with another. So that's not really "near" either.– Neil Lunn
Nov 21 '18 at 20:36
@NeilLunn, thanks for the response. Don't you want to post it as an answer instead?
– João Matos
Nov 22 '18 at 9:43
@NeilLunn, thanks for the response. Don't you want to post it as an answer instead?
– João Matos
Nov 22 '18 at 9:43
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%2f53418004%2fis-it-possible-to-query-which-linestrings-are-near-another-linestring-in-mongodb%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.
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%2f53418004%2fis-it-possible-to-query-which-linestrings-are-near-another-linestring-in-mongodb%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
No. The
$nearand variants all require aPointtype ( or legacy pair ) and don't accept other objects.$geoWithinaccepts "shapes", but aLineStringis never "iwthin" aLineString. IMHO I have actually found it more useful to always storePointtypes, and instead of using things likeLineString, I just put other things in the document that says "These things are part of a group of things!". If I needLineStringas external data, then read the "group" and write theLineString. This seems to work best with the database logic implemented.– Neil Lunn
Nov 21 '18 at 20:21
Forgot to mention
$geoIntersects, but of course the reliance there is on the supplied shape actually intersecting with another. So that's not really "near" either.– Neil Lunn
Nov 21 '18 at 20:36
@NeilLunn, thanks for the response. Don't you want to post it as an answer instead?
– João Matos
Nov 22 '18 at 9:43