23 places near 扇田, 秋田県, 日本
filter by placetype:
  1. 能代市
    能代市, 秋田県, 日本 (Town)
  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.016 seconds ⌛; show me the details?

        
0.016 seconds ⌛

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