25 places near 字砂原東, 茅部郡, 北海道, 日本
filter by placetype:
  1. ２丁目
    ２丁目, 茅部郡, 北海道, 日本 (Suburb)
  2. ２丁目
    ２丁目, 茅部郡, 北海道, 日本 (Suburb)
  3. ４丁目
    ４丁目, 茅部郡, 北海道, 日本 (Suburb)
  4. ５丁目
    ５丁目, 茅部郡, 北海道, 日本 (Suburb)
  5. 森町
    森町, 茅部郡, 北海道, 日本 (Town)
  6. 鹿部町
    鹿部町, 茅部郡, 北海道, 日本 (Town)
  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.014 seconds ⌛; show me the details?

        
0.014 seconds ⌛

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