[DOCS-1363] duplicate keys in the file zips.json Created: 09/Apr/13  Updated: 30/Oct/23  Resolved: 19/Aug/14

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: v1.2
Fix Version/s: Server_Docs_20231030

Type: Bug Priority: Trivial - P5
Reporter: Wlodek Bzyl Assignee: Kay Kim (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 10 years, 37 weeks, 1 day ago

 Description   

The file zips.json is mentioned here:

http://docs.mongodb.org/manual/tutorial/aggregation-examples/

The data from this file are used in the examples.

This file contains duplicate _id keys listed below:

1290:

{"city": "LITTLE ROCK", "loc": [-92.422232, 34.787076], "pop": 16183, "state": "AR", "_id": "72212"}

4016:

{"city": "PINETTA", "loc": [-83.340463, 30.599703], "pop": 642, "state": "FL", "_id": "32350"}

5352:

{"city": "PINETTA", "loc": [-83.310491, 30.634794], "pop": 0, "state": "GA", "_id": "32350"}

6916:

{"city": "SAINT MARY", "loc": [-89.929268, 37.914034], "pop": 130, "state": "IL", "_id": "63673"}

9909:

{"city": "FORT CAMPBELL", "loc": [-87.459706, 36.653584], "pop": 18861, "state": "KY", "_id": "42223"}

13771:

{"city": "FLORA", "loc": [-90.323506, 32.557832], "pop": 3973, "state": "MS", "_id": "39071"}

14215:

{"city": "SAINT MARY", "loc": [-89.976989, 37.832481], "pop": 2730, "state": "MO", "_id": "63673"}

14652:

{"city": "KAISER", "loc": [-92.579869, 38.163673], "pop": 1213, "state": "MO", "_id": "65047"}

24521:

{"city": "FORT CAMPBELL", "loc": [-87.558507, 36.599497], "pop": 728, "state": "TN", "_id": "42223"}

28045:

{"city": "BLOOMINGROSE", "loc": [-81.636737, 38.141189], "pop": 191, "state": "WV", "_id": "25024"}

The utility program mongoimport silently ignores duplicates.
Which duplicate would be ignored could not be predicted, I believe.

For example I aggregated total population as: 248706415 and 248690240.
Some aggregation results presented on the above page could differ too.

I believe that this data could be easily corrected by an US citizen.

--Włodek Bzyl



 Comments   
Comment by Sam Kleinman (Inactive) [ 04/Jun/13 ]

tyler.brock@gmail.com go for it.

Comment by Tyler Brock [ 04/Jun/13 ]

I can update these. They are in the training repo. Does anyone want my to update the zips.json?

Generated at Thu Feb 08 07:40:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.