Store GeoJSON polygons in MongoDB

mongodb indexing geo geojson
Dominik Nöger picture Dominik Nöger · Jun 21, 2012 · Viewed 11.1k times · Source

I have the following problem with MongoDB. I got some geo data from my home country and i have to store them into mongodb to set up a simple Web Feature Service. This service will mostly do bounding box queries using the $within operator. The data is in GeoJSON format. Therefore i imported at first the Villages and Cities which are represented as points ([1,2]) in this format. No problem. Next step rivers and streets which are LineStrings and according to GeoJSON represented this way [[1,2],[3,4]]. But when importing the districts (which are in fact polygon and according to the GeoJSON specification 3 dim arrrays) i got the error geo values have to be numbers when creating the index.

db.collection.ensureIndex({"geometry.coordinates" : "2d"});

All data are valid GeoJSON, and are in plain 2d coordinates in EPSG:4326 projection.

Does anybody have an idea?

Answer

Bob Grabar picture Bob Grabar · Mar 20, 2013

With MongoDB 2.4 use the "2dsphere" index for GeoJSON Points, LineStrings and Polygons.

For example, you can create this index:

db.mycoll.ensureIndex( { loc : "2dsphere" } )

And store this LineString:

{ loc : { type : "LineString" , coordinates : [ [ 1 , 2 ] , [ 3 , 4 ] ] } }

See http://docs.mongodb.org/manual/applications/2dsphere/.

Related questions

Can I do a MongoDB "starts with" query on an indexed subdocument field?

I'm trying to find documents where a field starts with a value. Table scans are disabled using notablescan. This works: db.articles.find({"url" : { $regex : /^http/ }}) This doesn't: db.articles.find({"source.homeUrl" : { $regex : /^http/ }}) I get the error: error: { "$…

Read More
MongoDB querying performance for over 5 million records

We've recently hit the >2 Million records for one of our main collections and now we started to suffer for major performance issues on that collection. They documents in the collection have about 8 fields which you can filter by using …

Read More
How to create indexes in MongoDB via .NET

I've programmatically created a new document collection using the MongoDB C# driver. At this point I want to create and build indexes programmatically. How can I do that?

Read More