Skip to content

Instantly share code, notes, and snippets.

@caged

caged/Session 2.js

Created March 19, 2011 21:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save caged/877801 to your computer and use it in GitHub Desktop.
Save caged/877801 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile2.js
> db.crimes.stats()
{
"ns" : "portlandcrime-dev.crimes",
"count" : 130161,
"size" : 39361684,
"avgObjSize" : 302.407664354146,
"storageSize" : 47822848,
"numExtents" : 9,
"nindexes" : 3,
"lastExtentSize" : 14495232,
"paddingFactor" : 1,
"flags" : 1,
"totalIndexSize" : 16211968,
"indexSizes" : {
"_id_" : 4947968,
"loc_2d" : 7151616,
"case_id_1" : 4112384
},
"ok" : 1
}
> points = db.crimes.find({address: /NE\s82/})
{ "_id" : ObjectId("4cdf7aa78aebb1a25b00219e"), "case_id" : 11967543, "reported_at" : ISODate("2010-03-23T19:25:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "fr", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000d"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b00219f"), "case_id" : 12007803, "reported_at" : ISODate("2010-08-06T07:31:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "NE COUCH ST and NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.523567830825534, "lon" : -122.57899323087476 }, "code" : "du", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000017"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a0"), "case_id" : 11983806, "reported_at" : ISODate("2010-05-18T05:07:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "la", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000005"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a1"), "case_id" : 11854796, "reported_at" : ISODate("2009-11-24T01:22:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "dr", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000a"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a2"), "case_id" : 11865389, "reported_at" : ISODate("2010-01-01T01:33:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "fo", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000c"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a3"), "case_id" : 13556128, "reported_at" : ISODate("2010-10-29T20:54:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "NE COUCH ST and NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.523567830825534, "lon" : -122.57899323087476 }, "code" : "la", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000005"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a4"), "case_id" : 11983427, "reported_at" : ISODate("2010-05-16T23:58:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "la", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000005"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a5"), "case_id" : 11963171, "reported_at" : ISODate("2010-03-09T02:41:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "dr", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000a"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a6"), "case_id" : 11975724, "reported_at" : ISODate("2010-04-21T01:21:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "la", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000005"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a7"), "case_id" : 11982019, "reported_at" : ISODate("2010-05-12T03:37:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "dr", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000a"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a8"), "case_id" : 11966376, "reported_at" : ISODate("2010-03-18T17:30:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "1-99 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "dr", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000a"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021a9"), "case_id" : 11974181, "reported_at" : ISODate("2010-04-16T00:00:00Z"), "district" : 932, "precinct" : "PORTLAND PREC EA", "address" : "E BURNSIDE ST and NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "di", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000016"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021aa"), "case_id" : 11968517, "reported_at" : ISODate("2010-03-26T23:45:00Z"), "district" : 932, "precinct" : "PORTLAND PREC EA", "address" : "E BURNSIDE ST and NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "li", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00001a"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021ab"), "case_id" : 11954419, "reported_at" : ISODate("2010-02-06T04:16:00Z"), "district" : 932, "precinct" : "PORTLAND PREC EA", "address" : "E BURNSIDE ST and NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "pr", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000e"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021ac"), "case_id" : 13575108, "reported_at" : ISODate("2010-11-06T17:18:00Z"), "district" : 932, "precinct" : "PORTLAND PREC EA", "address" : "E BURNSIDE ST and NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.52278609076184, "lon" : -122.57899599457029 }, "code" : "dr", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c00000a"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021ad"), "case_id" : 11953049, "reported_at" : ISODate("2010-02-02T00:00:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "101-199 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.523567830825534, "lon" : -122.57899323087476 }, "code" : "si", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000011"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021ae"), "case_id" : 12029379, "reported_at" : ISODate("2010-09-23T04:22:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "101-199 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.523567830825534, "lon" : -122.57899323087476 }, "code" : "la", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000005"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021af"), "case_id" : 11973590, "reported_at" : ISODate("2010-04-14T03:51:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "101-199 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.523567830825534, "lon" : -122.57899323087476 }, "code" : "di", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000016"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021b0"), "case_id" : 12007739, "reported_at" : ISODate("2010-08-06T03:15:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "101-199 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.523567830825534, "lon" : -122.57899323087476 }, "code" : "di", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000016"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
{ "_id" : ObjectId("4cdf7aa78aebb1a25b0021b1"), "case_id" : 12010778, "reported_at" : ISODate("2010-08-16T16:30:00Z"), "district" : 902, "precinct" : "PORTLAND PREC EA", "address" : "101-199 block of NE 82ND AVE, PORTLAND, OR 97220", "loc" : { "lat" : 45.523567830825534, "lon" : -122.57899323087476 }, "code" : "va", "created_at" : ISODate("2010-11-14T05:59:03Z"), "updated_at" : ISODate("2011-03-17T17:35:53Z"), "offense_id" : ObjectId("4cdf7a558aebb1a24c000013"), "neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3") }
has more
> point = points[0]
{
"_id" : ObjectId("4cdf7aa78aebb1a25b0021b2"),
"case_id" : 11951650,
"reported_at" : ISODate("2010-01-27T18:15:00Z"),
"district" : 902,
"precinct" : "PORTLAND PREC EA",
"address" : "101-199 block of NE 82ND AVE, PORTLAND, OR 97220",
"loc" : {
"lat" : 45.523567830825534,
"lon" : -122.57899323087476
},
"code" : "tr",
"created_at" : ISODate("2010-11-14T05:59:03Z"),
"updated_at" : ISODate("2011-03-17T17:35:53Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c00001c"),
"neighborhood_id" : ObjectId("4cdf7aa18aebb1a25b001ef3")
}
> db.runCommand({geoNear:'crimes', near: [point.loc.lon, point.loc.lat], spherical: true})
{
"ns" : "portlandcrime-dev.crimes",
"near" : "0100110010000000101100110111011100011001101000001010",
"results" : [
{
"dis" : 1.7431118613110719,
"obj" : {
"_id" : ObjectId("4cdf7b9f8aebb1a25b009017"),
"case_id" : 11954844,
"reported_at" : ISODate("2010-02-07T21:00:00Z"),
"district" : 822,
"precinct" : "PORTLAND PREC CE",
"address" : "200 Block NW Flanders St",
"loc" : {
"lat" : 45.40607944398113,
"lon" : -126.17708416168989
},
"code" : "la",
"created_at" : ISODate("2010-11-14T06:03:11Z"),
"updated_at" : ISODate("2011-03-17T17:38:34Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c000005"),
"neighborhood_id" : ObjectId("4cdf7a5f8aebb1a25b00000f")
}
},
{
"dis" : 1.7980789961043737,
"obj" : {
"_id" : ObjectId("4cdf7b868aebb1a25b008759"),
"case_id" : 12004732,
"reported_at" : ISODate("2010-07-27T21:30:00Z"),
"district" : null,
"precinct" : "HILLSBORO PREC DT",
"address" : "321-399 block of NE 5TH AVE, HILLSBORO, OR 97124",
"loc" : {
"lat" : 45.52546401432823,
"lon" : -122.98243821806952
},
"code" : "va",
"created_at" : ISODate("2010-11-14T06:02:46Z"),
"updated_at" : ISODate("2011-03-17T17:38:22Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c000013"),
"neighborhood_id" : ObjectId("4cdf7aad8aebb1a25b0024c7")
}
},
{
"dis" : 1.7982709380094541,
"obj" : {
"_id" : ObjectId("4d372dc28aebb11256000268"),
"case_id" : 13586459,
"reported_at" : ISODate("2010-11-05T04:55:00Z"),
"district" : null,
"precinct" : "HILLSBORO PREC DT",
"address" : "1101-1199 block of SE OAK ST, HILLSBORO, OR 97123",
"loc" : {
"lat" : 45.51869549548995,
"lon" : -122.97187476017808
},
"code" : "dr",
"created_at" : ISODate("2011-01-19T18:30:26Z"),
"updated_at" : ISODate("2011-03-17T17:45:27Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c00000a"),
"neighborhood_id" : ObjectId("4cdf7aad8aebb1a25b0024c7")
}
},
...
],
"stats" : {
"time" : 127,
"btreelocs" : 131018,
"nscanned" : 130161,
"objectsLoaded" : 430,
"avgDistance" : 1.8003774832436386,
"maxDistance" : 1.8013068888816
},
"ok" : 1
}
> db.crimes.find({"loc" : {"$within" : {"$centerSphere" : [ [point.loc.lon, point.loc.lat], 0.2 ] } } }).explain()
{
"cursor" : "GeoBrowse-circle",
"nscanned" : 0,
"nscannedObjects" : 0,
"n" : 0,
"millis" : 1,
"nYields" : 0,
"nChunkSkips" : 0,
"isMultiKey" : false,
"indexOnly" : false,
"indexBounds" : {
}
}
Raw
reproduce-mongo-1-8-issue.js
[
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ASH ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52174015245625, "lon" : -122.67138083659955 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "50-98 block of SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ASH ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52174015245625, "lon" : -122.67138083659955 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ASH ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52174015245625, "lon" : -122.67138083659955 } },
{ "address" : "SW ASH ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52174015245625, "lon" : -122.67138083659955 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ANKENY ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52252636108393, "lon" : -122.67120633959814 } },
{ "address" : "SW ASH ST and SW 1ST AVE, PORTLAND, OR 97204", "loc" : { "lat" : 45.52174015245625, "lon" : -122.67138083659955 } }
].forEach(function(c) {
db.crimes.insert(c)
})
db.crimes.ensureIndex({loc: '2d'})
var crime = db.crimes.findOne()
printjson(db.runCommand({geoNear:'crimes', near: [crime.loc.lon, crime.loc.lat], spherical: true}))
printjson(db.crimes.find({loc: { '$within': {'$centerSphere': [ [crime.loc.lon, crime.loc.lat], 0.2] } } }).toArray())
Raw
Session 2.js
> db.crimes.count({'loc.lat': 45.524583810712635, 'loc.lon': -122.67135799839151})
59
> db.crimes.findOne({'loc.lat': 45.524583810712635, 'loc.lon': -122.67135799839151})
{
"_id" : ObjectId("4cdf7a5f8aebb1a25b00000e"),
"case_id" : 11988211,
"reported_at" : ISODate("2010-06-01T20:50:00Z"),
"district" : 822,
"precinct" : "PORTLAND PREC CE",
"address" : "NW DAVIS ST and NW 1ST AVE, PORTLAND, OR 97209",
"loc" : {
"lat" : 45.524583810712635,
"lon" : -122.67135799839151
},
"code" : "li",
"created_at" : ISODate("2010-11-14T05:57:51Z"),
"updated_at" : ISODate("2011-03-17T17:35:07Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c00001a"),
"neighborhood_id" : ObjectId("4cdf7a5f8aebb1a25b00000f")
}
> db.crimes.find({"loc" : {"$within" : {"$centerSphere" : [ [-122.67135799839151, 45.524583810712635], 0.2] } } }).toArray()
[ ]
> db.crimes.find({"loc" : {"$within" : {"$centerSphere" : [ [-122.67135799839151, 45.524583810712635], 0.3] } } }).toArray()
[ ]
> db.crimes.find({"loc" : {"$within" : {"$centerSphere" : [ [-122.67135799839151, 45.524583810712635], 0.5] } } }).toArray()
Sun Mar 20 11:01:37 uncaught exception: error: {
"$err" : "Spherical distance would require wrapping, which isn't implemented yet",
"code" : 13462
// Note that I'm querying geoNear results that are *exactly* the same coordinates as the centerSphere and the distance of objects are 1.8+ even though they are the exact same location.
> db.runCommand({geoNear:'crimes', near: [-122.67135799839151, 45.524583810712635], spherical: true, query: { 'loc.lat': 45.524583810712635, 'loc.lon':-122.67135799839151}})
{
"ns" : "portlandcrime-dev.crimes",
"near" : "0100110010000000101100010111010100110111111101010011",
"results" : [
{
"dis" : 1.8033385016497163,
"obj" : {
"_id" : ObjectId("4cdf7a5f8aebb1a25b00000e"),
"case_id" : 11988211,
"reported_at" : ISODate("2010-06-01T20:50:00Z"),
"district" : 822,
"precinct" : "PORTLAND PREC CE",
"address" : "NW DAVIS ST and NW 1ST AVE, PORTLAND, OR 97209",
"loc" : {
"lat" : 45.524583810712635,
"lon" : -122.67135799839151
},
"code" : "li",
"created_at" : ISODate("2010-11-14T05:57:51Z"),
"updated_at" : ISODate("2011-03-17T17:35:07Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c00001a"),
"neighborhood_id" : ObjectId("4cdf7a5f8aebb1a25b00000f")
}
},
{
"dis" : 1.8033385016497163,
"obj" : {
"_id" : ObjectId("4cdf7a5f8aebb1a25b000010"),
"case_id" : 11970074,
"reported_at" : ISODate("2010-04-01T18:08:00Z"),
"district" : 822,
"precinct" : "PORTLAND PREC CE",
"address" : "NW DAVIS ST and NW 1ST AVE, PORTLAND, OR 97209",
"loc" : {
"lat" : 45.524583810712635,
"lon" : -122.67135799839151
},
"code" : "se",
"created_at" : ISODate("2010-11-14T05:57:51Z"),
"updated_at" : ISODate("2011-03-17T17:35:07Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c000010"),
"neighborhood_id" : ObjectId("4cdf7a5f8aebb1a25b00000f")
}
},
{
"dis" : 1.8033385016497163,
"obj" : {
"_id" : ObjectId("4cdf7a5f8aebb1a25b000011"),
"case_id" : 12010488,
"reported_at" : ISODate("2010-08-15T07:56:00Z"),
"district" : 822,
"precinct" : "PORTLAND PREC CE",
"address" : "NW DAVIS ST and NW 1ST AVE, PORTLAND, OR 97209",
"loc" : {
"lat" : 45.524583810712635,
"lon" : -122.67135799839151
},
"code" : "si",
"created_at" : ISODate("2010-11-14T05:57:51Z"),
"updated_at" : ISODate("2011-03-17T17:35:07Z"),
"offense_id" : ObjectId("4cdf7a558aebb1a24c000011"),
"neighborhood_id" : ObjectId("4cdf7a5f8aebb1a25b00000f")
}
},
....
}
],
"stats" : {
"time" : 240,
"btreelocs" : 130160,
"nscanned" : 130161,
"objectsLoaded" : 130161,
"avgDistance" : 1.8033385016497183,
"maxDistance" : 1.8033385016497163
},
"ok" : 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment