19 places near Lake Rotomata, Far North District, Northland, New Zealand
filter by placetype:
  1. Puhau
    Puhau, Far North District, Northland, New Zealand (Suburb)
  2. Rangi Point
    Rangi Point, Far North District, Northland, New Zealand (Suburb)
  3. Waiparera
    Waiparera, Far North District, Northland, New Zealand (Suburb)
  4. Waitapu
    Waitapu, Far North District, Northland, New Zealand (Suburb)
  5. Whangarei
    Whangarei, Whangarei District, Northland, New Zealand (Town)
  6. Hokianga Harbour
    Hokianga Harbour, Far North District, Northland, New Zealand (Town)
  7. Lake Rotomata
    Lake Rotomata, Far North District, Northland, New Zealand (Drainage)
  8. North Auckland Peninsula
    North Auckland Peninsula, New Zealand (Colloquial)
  9. North Island
    North Island, New Zealand (Island)
  10. Far North District
    Far North District, Northland, New Zealand (County)

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

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

        
0.02 seconds ⌛

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