13 places near Kandreho, Kandreho, Mahajanga, Madagascar
filter by placetype:
  1. Kandreho
    Kandreho, Kandreho, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Kandreho
    Kandreho, Mahajanga, Madagascar (County)
  4. Maevatanana
    Maevatanana, Mahajanga, Madagascar (County)
  5. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  6. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  7. Eastern
    Eastern, Eastern, Fiji (State)
  8. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  9. Madagascar
    Madagascar, Madagascar (Country)
  10. Indian Ocean
    Indian Ocean (Ocean)

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": [
                  46.090611,
                  -17.484221
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}