4 places near Kaipatiki Local Board, Auckland, New Zealand
filter by placetype:
  1. North Shore City
    North Shore City, Auckland, New Zealand (Colloquial)
  2. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)
  3. Auckland City
    Auckland City, Auckland, New Zealand (Colloquial)
  4. Kaipatiki Local Board
    Kaipatiki Local Board, Auckland, New Zealand (Colloquial)

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.737671,
                  -36.754318
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 24
          }
        }
      ],
      "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"
      }
    }
  ]
}