26 places near 荒川口, 新潟県, 日本
filter by placetype:
  1. 村上市
    村上市, 新潟県, 日本 (Town)
  2. 鶴岡市
    鶴岡市, 山形県, 日本 (Town)
  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.008 seconds ⌛; show me the details?

        
0.008 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  139.569504,
                  38.483891
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}