23 places near 帯広市, 北海道, 日本
filter by placetype:
  1. 芽室町
    芽室町, 河西郡, 北海道, 日本 (Town)
  2. 帯広市
    帯広市, 北海道, 日本 (Town)
  3. 清川町
    清川町, 北海道, 日本 (LocalAdmin)
  4. 清川町基線
    清川町基線, 北海道, 日本 (LocalAdmin)
  5. 昭和町
    昭和町, 北海道, 日本 (LocalAdmin)
  6. 富士町
    富士町, 北海道, 日本 (LocalAdmin)
  7. 富士町基線
    富士町基線, 北海道, 日本 (LocalAdmin)
  8. Siberia
    Siberia, Rossija (Colloquial)
  9. 日高支庁
    日高支庁, 北海道, 日本 (Colloquial)
  10. 十勝支庁
    十勝支庁, 北海道, 日本 (Colloquial)

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

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

        
0.023 seconds ⌛

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