Ufdjrw

Why is my ESD wriststrap failing with nitrile gloves on?

Would the Life Transference spell be unbalanced if it ignored resistance and immunity?

AppleTVs create a chatty alternate WiFi network

Using audio cues to encourage good posture

What is a fractional matching?

Is it possible for SQL statements to execute concurrently within a single session in SQL Server?

ArcGIS Pro Python arcpy.CreatePersonalGDB_management

Take 2! Is this homebrew Lady of Pain warlock patron balanced?

Localisation of Category

Dating a Former Employee

Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?

Trademark violation for app?

Can a new player join a group only when a new campaign starts?

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

How do living politicians protect their readily obtainable signatures from misuse?

How to react to hostile behavior from a senior developer?

Selecting user stories during sprint planning

Why weren't discrete x86 CPUs ever used in game hardware?

Amount of permutations on an NxNxN Rubik's Cube

Can the Great Weapon Master feat's damage bonus and accuracy penalty apply to attacks from the Spiritual Weapon spell?

How can I reduce the gap between left and right of cdot with a macro?

Do I really need to have a message in a novel to appeal to readers?

Chinese Seal on silk painting - what does it mean?

What is the font for "b" letter?

Find all locations $geoWithin $geoIntersects

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I want to find out which Polygon from a collection, contains the most points from another collection.

I’m using one collection with restaurant data (points) and one with the neighborhood data (polygons)

Both collections are provided by mongodb:

https://raw.githubusercontent.com/mongodb/docs-assets/geospatial/neighborhoods.json
https://raw.githubusercontent.com/mongodb/docs-assets/geospatial/restaurants.json

Neighborhood document:

 "_id": 
 "$oid": "55cb9c666c522cafdb053a1a"
 ,
 "geometry": 
 "coordinates": [
 [
 [
 -73.9443878859649,
 40.70042452378256
 ],
 [
 -73.94424286147482,
 40.69969927964773
 ], 
[
 -73.94193078816193,
 40.70072523469547
 ],…
 ]
 ],
 "type": "Polygon"
 ,
 "name": "Bedford"

Restaurant document

"_id" : "$oid" : "55cba2476c522cafdb053add" ,
"location" : "coordinates":[-73.856077,40.848447] , "type":"Point" ,
"name" : "Morris Park Bake Shop"

Here an example to find out all restaurants within a single district:

Select one neighborhood (polygon) by a given point ($geoIntersects)

var neighborhood = db.neighborhoods.findOne( 
 
 geometry: 
 
 $geoIntersects: 
 
 $geometry: type: "Point", coordinates: [ -73.93414657, 40.82302903 ] 
 
 
 
)

Find out how many restaurants are in this neighborhood

db.restaurants.find( location: $geoWithin: $geometry: neighborhood.geometry ).count()

My question:

Which neighborhood contains the most restaurants?

mongodb

share|improve this question

edited Mar 8 at 20:26

nixor quixor

asked Mar 8 at 17:43

nixor quixornixor quixor

62

add a comment | 

1

I want to find out which Polygon from a collection, contains the most points from another collection.

I’m using one collection with restaurant data (points) and one with the neighborhood data (polygons)

Both collections are provided by mongodb:

https://raw.githubusercontent.com/mongodb/docs-assets/geospatial/neighborhoods.json
https://raw.githubusercontent.com/mongodb/docs-assets/geospatial/restaurants.json

Neighborhood document:

 "_id": 
 "$oid": "55cb9c666c522cafdb053a1a"
 ,
 "geometry": 
 "coordinates": [
 [
 [
 -73.9443878859649,
 40.70042452378256
 ],
 [
 -73.94424286147482,
 40.69969927964773
 ], 
[
 -73.94193078816193,
 40.70072523469547
 ],…
 ]
 ],
 "type": "Polygon"
 ,
 "name": "Bedford"

Restaurant document

"_id" : "$oid" : "55cba2476c522cafdb053add" ,
"location" : "coordinates":[-73.856077,40.848447] , "type":"Point" ,
"name" : "Morris Park Bake Shop"

Here an example to find out all restaurants within a single district:

Select one neighborhood (polygon) by a given point ($geoIntersects)

var neighborhood = db.neighborhoods.findOne( 
 
 geometry: 
 
 $geoIntersects: 
 
 $geometry: type: "Point", coordinates: [ -73.93414657, 40.82302903 ] 
 
 
 
)

Find out how many restaurants are in this neighborhood

db.restaurants.find( location: $geoWithin: $geometry: neighborhood.geometry ).count()

My question:

Which neighborhood contains the most restaurants?

mongodb

share|improve this question

edited Mar 8 at 20:26

nixor quixor

asked Mar 8 at 17:43

nixor quixornixor quixor

62

add a comment | 

I want to find out which Polygon from a collection, contains the most points from another collection.

I’m using one collection with restaurant data (points) and one with the neighborhood data (polygons)

Both collections are provided by mongodb:

https://raw.githubusercontent.com/mongodb/docs-assets/geospatial/neighborhoods.json
https://raw.githubusercontent.com/mongodb/docs-assets/geospatial/restaurants.json

Neighborhood document:

 "_id": 
 "$oid": "55cb9c666c522cafdb053a1a"
 ,
 "geometry": 
 "coordinates": [
 [
 [
 -73.9443878859649,
 40.70042452378256
 ],
 [
 -73.94424286147482,
 40.69969927964773
 ], 
[
 -73.94193078816193,
 40.70072523469547
 ],…
 ]
 ],
 "type": "Polygon"
 ,
 "name": "Bedford"

Restaurant document

"_id" : "$oid" : "55cba2476c522cafdb053add" ,
"location" : "coordinates":[-73.856077,40.848447] , "type":"Point" ,
"name" : "Morris Park Bake Shop"

Here an example to find out all restaurants within a single district:

Select one neighborhood (polygon) by a given point ($geoIntersects)

var neighborhood = db.neighborhoods.findOne( 
 
 geometry: 
 
 $geoIntersects: 
 
 $geometry: type: "Point", coordinates: [ -73.93414657, 40.82302903 ] 
 
 
 
)

Find out how many restaurants are in this neighborhood

db.restaurants.find( location: $geoWithin: $geometry: neighborhood.geometry ).count()

My question:

Which neighborhood contains the most restaurants?

mongodb

share|improve this question

edited Mar 8 at 20:26

nixor quixor

asked Mar 8 at 17:43

nixor quixornixor quixor

62

 "_id": 
 "$oid": "55cb9c666c522cafdb053a1a"
 ,
 "geometry": 
 "coordinates": [
 [
 [
 -73.9443878859649,
 40.70042452378256
 ],
 [
 -73.94424286147482,
 40.69969927964773
 ], 
[
 -73.94193078816193,
 40.70072523469547
 ],…
 ]
 ],
 "type": "Polygon"
 ,
 "name": "Bedford"

"_id" : "$oid" : "55cba2476c522cafdb053add" ,
"location" : "coordinates":[-73.856077,40.848447] , "type":"Point" ,
"name" : "Morris Park Bake Shop"

var neighborhood = db.neighborhoods.findOne( 
 
 geometry: 
 
 $geoIntersects: 
 
 $geometry: type: "Point", coordinates: [ -73.93414657, 40.82302903 ] 
 
 
 
)

db.restaurants.find( location: $geoWithin: $geometry: neighborhood.geometry ).count()

share|improve this question

edited Mar 8 at 20:26

nixor quixor

asked Mar 8 at 17:43

nixor quixornixor quixor

62

share|improve this question

edited Mar 8 at 20:26

nixor quixor

asked Mar 8 at 17:43

nixor quixornixor quixor

62

asked Mar 8 at 17:43

nixor quixornixor quixor

62

asked Mar 8 at 17:43

nixor quixornixor quixor

62