4 places near １８丁目, 中央区, 北海道, 日本
filter by placetype:
  1. ホテルハミルトン札幌
    ホテルハミルトン札幌, 中央区, 北海道, 日本 (POI)
  2. ロイトン札幌
    ロイトン札幌, 中央区, 北海道, 日本 (POI)
  3. 桑園グリーンホテル
    桑園グリーンホテル, 中央区, 北海道, 日本 (POI)
  4. ウェルシティ札幌
    ウェルシティ札幌, 中央区, 北海道, 日本 (POI)

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

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

        
0.018 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  141.32901,
                  43.059238
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 20
          }
        }
      ],
      "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"
      }
    }
  ]
}