This post is a continuation of the previous posts: Intersection of the range of values MongoDB - Intersection of the range of multiple row values MongoDB: Intersection of the range of multiple row values with object fields Suppose we have…
Suppose we have a mongodb collection with 6 columns: RoomFrom RoomTo PoolFrom PoolTo FloorFrom FloorTo Now I would like to select rows where range *From / *To intersect with another ranges. For example: [ { _id: 1, RoomFrom: 100, RoomTo:…
I am using ST_Intersects to check if two polygons intersect. Relevant part of my query is: SELECT entity_number FROM coordinates WHERE ST_INTERSECTS($1, location) It works well to determine if one polygon scrosses the other's surface: I expected ST_Intersects to return…
Say I have an array of Polygons expressed as an array of an array [x,y] values, for example: var polygons = [ [ [8, 57], [15, 57], [15, 71], [8, 71], [8, 57] ], [ [77, 36], [85, 36], [85,…
A problem description: I have two strings and I need to find the length of intersection of them. Let's assume the both strings are Latin-ASCII and lower case. These are expected results: $str1 = "lorem ipsum"; $str2 = "rem"; echo…
I have the following aggregation pipeline running in the latest version of mongoDB and pymongo: [ { "$project": { "union": { "$setUnion": [ "$query_a", "$query_b" ] } } }, { "$unwind": "$union" }, { "$group": { "_id": "$union.ID", "date_a": {…