21 places near Sand Island, Honolulu, Hawaii, United States
filter by placetype:
  1. Iwilei
    Iwilei, Honolulu, Hawaii, United States (Suburb)
  2. Downtown
    Downtown, Honolulu, Hawaii, United States (Suburb)
  3. Kalihi-palama
    Kalihi-palama, Honolulu, Hawaii, United States (Suburb)
  4. Honolulu Ahupua`a
    Honolulu Ahupua`a, Honolulu, Hawaii, United States (Suburb)
  5. Moanalua Ahupua`a
    Moanalua Ahupua`a, Honolulu, Hawaii, United States (Suburb)
  6. Liliha - Kapalama
    Liliha - Kapalama, Honolulu, Hawaii, United States (Suburb)
  7. Honolulu
    Honolulu, Honolulu, Hawaii, United States (Town)
  8. Wake Island
    Wake Island, Honolulu, Hawaii, United States (Town)
  9. Fort Street
    Fort Street, Honolulu, Hawaii, United States (Town)
  10. Oahu
    Oahu, Honolulu, Hawaii, United States (Island)

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

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

        
0.022 seconds ⌛

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