17 places near Ramarama, Waikato, New Zealand
filter by placetype:
  1. Auckland
    Auckland, Auckland, New Zealand (Town)
  2. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  3. Ramarama
    Ramarama, Waikato, New Zealand (Town)
  4. Karaka
    Karaka, Waikato, New Zealand (Town)
  5. South Auckland
    South Auckland, Auckland, New Zealand (Colloquial)
  6. Franklin District
    Franklin District, New Zealand (Colloquial)
  7. North Island
    North Island, New Zealand (Island)
  8. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  9. Auckland
    Auckland, Auckland, New Zealand (State)
  10. Waikato
    Waikato, Waikato, New Zealand (State)

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

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

        
0.034 seconds ⌛

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