Storing Country, State, City and Zip in NoSQL

Question

Hey I am trying to come up with a good schema for storing country, state, city, zip in a NoSQL(MongoDB) and I wanted from feed back on this schema.

{
    _id: xxxxx,
    country: {
        name: "United States",
        currency: "USD",
        states: {
                { 
                name: "NY"
                cites {
                      "name": Bronx
                     }
                }
        }
    }
}

Basically what I was going for was storing a country as a top level. Then countries have states as an array and states has cities as an array and cities will have an array of zip codes. THoughts please?

Depends on how you need to query the data. What kinds of queries will you be using? — Scott Willeke, Sep 16 '11 at 01:28
At times I will just one to query states. At other times I will just want to query zipcodes in a city. — Devin Dixon, Sep 16 '11 at 01:48
I will want access to at the data and want it to relate somehow. Just not sure of the best way(this would be so much easier with RDBMS) — Devin Dixon, Sep 16 '11 at 01:52

score 2 · Accepted Answer · answered Sep 16 '11 at 02:06

2

I think your schema is okay in mongo you can index array fields for perf and query subdocuments and partial arrays with $slice.

answered Sep 16 '11 at 02:06

Scott Willeke

8,884
1
40
52

@Devin: I'm just curious what way you went with and why. How did it work out? – Scott Willeke Oct 05 '11 at 05:01

score 0 · Answer 2 · answered Sep 16 '11 at 02:52

0

Actually, cities shouldn't have arrays of zip-codes as those can span across cities. I would instead have zip codes have of states and then cities. See the last area of this page for details: http://www.carrierroutes.com/ZIPCodes.html

answered Sep 16 '11 at 02:52

jschorr

3,034
1
17
20

You approach sounds backwards and hard to enter. Whats the advantage of that way? – Devin Dixon Sep 20 '11 at 15:19

Storing Country, State, City and Zip in NoSQL

2 Answers2