19 places near 上庄, 熊本県, 日本
filter by placetype:
  1. 菊池市
    菊池市, 熊本県, 日本 (Town)
  2. 熊本市
    熊本市, 熊本県, 日本 (Town)
  3. 合志市
    合志市, 熊本県, 日本 (Town)
  4. 泗水町永
    泗水町永, 熊本県, 日本 (LocalAdmin)
  5. 泗水町福本
    泗水町福本, 熊本県, 日本 (LocalAdmin)
  6. 上庄
    上庄, 熊本県, 日本 (LocalAdmin)
  7. 幾久富
    幾久富, 熊本県, 日本 (LocalAdmin)
  8. 竹迫
    竹迫, 熊本県, 日本 (LocalAdmin)
  9. 豊岡
    豊岡, 熊本県, 日本 (LocalAdmin)
  10. 九州地方
    九州地方, 日本 (Colloquial)

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

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

        
0.028 seconds ⌛

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