12 places near Malakialina, Mampikony, Mahajanga, Madagascar
filter by placetype:
  1. Malakialina
    Malakialina, Mampikony, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Ambato-Boeny
    Ambato-Boeny, Mahajanga, Madagascar (County)
  4. Mampikony
    Mampikony, Mahajanga, Madagascar (County)
  5. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  6. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  7. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)
  8. Madagascar
    Madagascar, Madagascar (Country)
  9. Indian Ocean
    Indian Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.019 seconds ⌛

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