34 places near 亀ケ谷新田, 新潟県, 日本
filter by placetype:
  1. 中野東
    中野東, 新潟県, 日本 (LocalAdmin)
  2. 西高山新田
    西高山新田, 新潟県, 日本 (LocalAdmin)
  3. 猫興野
    猫興野, 新潟県, 日本 (LocalAdmin)
  4. 野口
    野口, 新潟県, 日本 (LocalAdmin)
  5. 末宝
    末宝, 新潟県, 日本 (LocalAdmin)
  6. 真弓
    真弓, 新潟県, 日本 (LocalAdmin)
  7. 六所
    六所, 新潟県, 日本 (LocalAdmin)
  8. 下関町
    下関町, 新潟県, 日本 (LocalAdmin)
  9. 西今町
    西今町, 新潟県, 日本 (LocalAdmin)
  10. 中部地方
    中部地方, 日本 (Colloquial)

Search again including deprecated places, unknown places, places that visit Null Island or everything?

This query took 0.041 seconds ⌛; show me the details?

        
0.041 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  138.866226,
                  37.555882
                ]
              }
            }
          }
        }
      ],
      "must_not": [
        {
          "terms": {
            "woe:placetype": [
              0,
              11,
              25
            ]
          }
        },
        {
          "term": {
            "geom:latitude": {
              "value": 0.0
            }
          }
        },
        {
          "term": {
            "geom:longitude": {
              "value": 0.0
            }
          }
        },
        {
          "exists": {
            "field": "woe:superseded_by"
          }
        }
      ]
    }
  },
  "aggs": {
    "placetypes": {
      "terms": {
        "field": "woe:placetype_name",
        "size": 10000
      }
    }
  },
  "sort": [
    {
      "woe:scale": {
        "order": "desc",
        "mode": "max"
      }
    },
    {
      "woe:id": {
        "order": "asc",
        "mode": "max"
      }
    }
  ],
  "from": 10
}