76 places near 上台, 福島県, 日本
filter by placetype:
  1. 桑折町
    桑折町, 伊達郡, 福島県, 日本 (Town)
  2. 福島市
    福島市, 福島県, 日本 (Town)
  3. 伊達市
    伊達市, 福島県, 日本 (Town)
  4. 飯坂町東湯野
    飯坂町東湯野, 福島県, 日本 (LocalAdmin)
  5. 一本木
    一本木, 福島県, 日本 (LocalAdmin)
  6. 右城
    右城, 福島県, 日本 (LocalAdmin)
  7. 上台
    上台, 福島県, 日本 (LocalAdmin)
  8. 扇田
    扇田, 福島県, 日本 (LocalAdmin)
  9. 岡沼
    岡沼, 福島県, 日本 (LocalAdmin)
  10. 岡前
    岡前, 福島県, 日本 (LocalAdmin)

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

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

        
0.019 seconds ⌛

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