Skip to content

Instantly share code, notes, and snippets.

@missinglink
Created April 29, 2015 08:18
Show Gist options
  • Select an option

  • Save missinglink/bc9d5a751d83158b892f to your computer and use it in GitHub Desktop.

Select an option

Save missinglink/bc9d5a751d83158b892f to your computer and use it in GitHub Desktop.
Pelias category counts - OSM planet Apr 29 - 2015
{
"took": 344,
"timed_out": false,
"_shards": {
"total": 40,
"successful": 40,
"failed": 0
},
"hits": {
"total": 165113284,
"max_score": 0,
"hits": [
]
},
"aggregations": {
"popular": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "retail",
"doc_count": 2035329
},
{
"key": "food",
"doc_count": 1052789
},
{
"key": "education",
"doc_count": 1012070
},
{
"key": "transport",
"doc_count": 999489
},
{
"key": "recreation",
"doc_count": 913755
},
{
"key": "nightlife",
"doc_count": 622372
},
{
"key": "transport:public",
"doc_count": 618726
},
{
"key": "professional",
"doc_count": 532643
},
{
"key": "religion",
"doc_count": 505962
},
{
"key": "government",
"doc_count": 439336
},
{
"key": "entertainment",
"doc_count": 438220
},
{
"key": "health",
"doc_count": 359072
},
{
"key": "accomodation",
"doc_count": 294060
},
{
"key": "finance",
"doc_count": 184095
},
{
"key": "transport:rail",
"doc_count": 121378
},
{
"key": "transport:station",
"doc_count": 93877
},
{
"key": "transport:air",
"doc_count": 69042
},
{
"key": "food:regional",
"doc_count": 41614
},
{
"key": "transport:air:aerodrome",
"doc_count": 41028
},
{
"key": "food:pizza",
"doc_count": 31708
},
{
"key": "food:burger",
"doc_count": 30856
},
{
"key": "food:cuisine:italian",
"doc_count": 25551
},
{
"key": "transport:bus",
"doc_count": 21524
},
{
"key": "food:cuisine:chinese",
"doc_count": 16937
},
{
"key": "food:coffee_shop",
"doc_count": 13232
},
{
"key": "food:sandwich",
"doc_count": 11735
},
{
"key": "food:cuisine:german",
"doc_count": 10021
},
{
"key": "food:cuisine:japanese",
"doc_count": 8048
},
{
"key": "food:cuisine:mexican",
"doc_count": 7967
},
{
"key": "food:cuisine:indian",
"doc_count": 7397
},
{
"key": "food:kebab",
"doc_count": 7280
},
{
"key": "food:cuisine:american",
"doc_count": 7203
},
{
"key": "transport:taxi",
"doc_count": 7138
},
{
"key": "food:cuisine:french",
"doc_count": 6603
},
{
"key": "food:chicken",
"doc_count": 6556
},
{
"key": "food:cuisine:asian",
"doc_count": 6527
},
{
"key": "food:ice_cream",
"doc_count": 6345
},
{
"key": "food:cuisine:greek",
"doc_count": 6028
},
{
"key": "transport:sea",
"doc_count": 5795
},
{
"key": "food:cuisine:thai",
"doc_count": 4291
},
{
"key": "food:cuisine:international",
"doc_count": 4203
},
{
"key": "food:sushi",
"doc_count": 4122
},
{
"key": "food:fish_and_chips",
"doc_count": 3505
},
{
"key": "food:cuisine:turkish",
"doc_count": 2660
},
{
"key": "food:steak",
"doc_count": 2343
},
{
"key": "food:seafood",
"doc_count": 2315
},
{
"key": "food:cuisine:spanish",
"doc_count": 2177
},
{
"key": "food:fish",
"doc_count": 1414
},
{
"key": "food:cuisine:vietnamese",
"doc_count": 1400
},
{
"key": "food:noodle",
"doc_count": 1236
},
{
"key": "food:vegetarian",
"doc_count": 1164
},
{
"key": "food:cuisine:korean",
"doc_count": 796
},
{
"key": "food:barbecue",
"doc_count": 746
},
{
"key": "food:donut",
"doc_count": 740
},
{
"key": "food:friture",
"doc_count": 740
},
{
"key": "food:cuisine:bavarian",
"doc_count": 736
},
{
"key": "food:mediterranean",
"doc_count": 673
},
{
"key": "food:cake",
"doc_count": 460
},
{
"key": "food:crepe",
"doc_count": 421
},
{
"key": "food:cuisine:lebanese",
"doc_count": 362
},
{
"key": "food:curry",
"doc_count": 314
},
{
"key": "food:cuisine:russian",
"doc_count": 287
},
{
"key": "food:tapas",
"doc_count": 272
},
{
"key": "food:bagel",
"doc_count": 233
},
{
"key": "food:pasta",
"doc_count": 225
},
{
"key": "food:cuisine:portuguese",
"doc_count": 218
},
{
"key": "food:sausage",
"doc_count": 204
},
{
"key": "food:pancake",
"doc_count": 203
},
{
"key": "food:cuisine:polish",
"doc_count": 191
},
{
"key": "food:cuisine:african",
"doc_count": 190
},
{
"key": "food:cuisine:croatian",
"doc_count": 171
},
{
"key": "food:cuisine:arab",
"doc_count": 167
},
{
"key": "food:cuisine:malagasy",
"doc_count": 158
},
{
"key": "food:cuisine:balkan",
"doc_count": 154
},
{
"key": "food:vegan",
"doc_count": 153
},
{
"key": "food:cuisine:brazilian",
"doc_count": 151
},
{
"key": "food:cuisine:caribbean",
"doc_count": 146
},
{
"key": "food:cuisine:argentinian",
"doc_count": 136
},
{
"key": "food:cuisine:hungarian",
"doc_count": 132
},
{
"key": "food:savory_pancakes",
"doc_count": 108
},
{
"key": "food:cuisine:peruvian",
"doc_count": 96
},
{
"key": "food:couscous",
"doc_count": 79
},
{
"key": "food:pie",
"doc_count": 78
},
{
"key": "food:sub",
"doc_count": 78
},
{
"key": "food:cuisine:czech",
"doc_count": 77
},
{
"key": "food:fried_food",
"doc_count": 69
},
{
"key": "food:cuisine:basque",
"doc_count": 66
},
{
"key": "food:cuisine:latin_american",
"doc_count": 54
},
{
"key": "food:cuisine:danish",
"doc_count": 48
},
{
"key": "food:cuisine:cantonese",
"doc_count": 44
},
{
"key": "food:cuisine:australian",
"doc_count": 38
},
{
"key": "food:dessert",
"doc_count": 37
},
{
"key": "food:empanada",
"doc_count": 31
},
{
"key": "food:cuisine:pakistani",
"doc_count": 30
},
{
"key": "food:cuisine:iranian",
"doc_count": 29
},
{
"key": "food:cuisine:gaucho",
"doc_count": 27
},
{
"key": "food:wings",
"doc_count": 27
},
{
"key": "food:cuisine:sichuan",
"doc_count": 10
},
{
"key": "food:cuisine:mineira",
"doc_count": 8
},
{
"key": "food:gyro",
"doc_count": 8
},
{
"key": "food:bougatsa",
"doc_count": 5
},
{
"key": "food:cuisine:baiana",
"doc_count": 5
},
{
"key": "food:cuisine:okinawa_ryori",
"doc_count": 4
},
{
"key": "food:cuisine:capixaba",
"doc_count": 3
},
{
"key": "food:cuisine:belarusian",
"doc_count": 2
},
{
"key": "food:cuisine:hunan",
"doc_count": 2
},
{
"key": "food:cuisine:shandong",
"doc_count": 2
}
]
}
}
}
@missinglink
Copy link
Copy Markdown
Author

curl -XGET "http://localhost:9200/pelias/_search?search_type=count" -d'
{   
    "aggs": {
        "popular": {
            "terms": {
                "field": "category",
                "size": 107
            }
        }
    }
}'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment