20 places near Otewa, Otorohanga District, Waikato, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Otorohanga
    Otorohanga, Otorohanga District, Waikato, New Zealand (Town)
  3. Mangaorongo
    Mangaorongo, Otorohanga District, Waikato, New Zealand (Town)
  4. Otewa
    Otewa, Otorohanga District, Waikato, New Zealand (Town)
  5. Rangiatea
    Rangiatea, Otorohanga District, Waikato, New Zealand (Town)
  6. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  7. Waipa River
    Waipa River, Waikato, New Zealand (Drainage)
  8. North Island
    North Island, New Zealand (Island)
  9. Waitomo District
    Waitomo District, New Zealand (County)
  10. Otorohanga District
    Otorohanga District, Waikato, New Zealand (County)

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

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

        
0.137 seconds ⌛

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