16 places near Motairehe, Auckland, New Zealand
filter by placetype:
  1. Auckland
    Auckland, Auckland, New Zealand (Town)
  2. Motairehe
    Motairehe, Auckland, New Zealand (Town)
  3. Okiwi
    Okiwi, Auckland, New Zealand (Town)
  4. Kawa
    Kawa, Auckland, New Zealand (Town)
  5. Auckland City
    Auckland City, Auckland, New Zealand (Colloquial)
  6. Great Barrier Island
    Great Barrier Island, Auckland, New Zealand (Island)
  7. North Island
    North Island, New Zealand (Island)
  8. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  9. Auckland
    Auckland, Auckland, New Zealand (State)
  10. New Zealand
    New Zealand, New Zealand (Country)

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

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

        
0.009 seconds ⌛

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