13 places near Mairetahi, Auckland, New Zealand
filter by placetype:
  1. Shelly Beach
    Shelly Beach, Auckland, New Zealand (Town)
  2. Mairetahi
    Mairetahi, Auckland, New Zealand (Town)
  3. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)
  4. North Island
    North Island, New Zealand (Island)
  5. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  6. Auckland
    Auckland, Auckland, New Zealand (State)
  7. New Zealand
    New Zealand, New Zealand (Country)
  8. Tasman Sea
    Tasman Sea (Sea)
  9. Australia
    Australia (Continent)
  10. Polynesia
    Polynesia (Supername)

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": [
                  174.343307,
                  -36.551762
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}