25 places near 五泉市, 新潟県, 日本
filter by placetype:
  1. 五泉市
    五泉市, 新潟県, 日本 (Town)
  2. 加茂市
    加茂市, 新潟県, 日本 (Town)
  3. 三条市
    三条市, 新潟県, 日本 (Town)
  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.02 seconds ⌛; show me the details?

        
0.02 seconds ⌛

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