23 places near 百戸町北, 北海道, 日本
filter by placetype:
  1. 赤平市
    赤平市, 北海道, 日本 (Town)
  2. 芦別市
    芦別市, 北海道, 日本 (Town)
  3. 石狩川
    石狩川, 北海道, 日本 (Drainage)
  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.021 seconds ⌛; show me the details?

        
0.021 seconds ⌛

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