13 places near Bekoratsaka, Mampikony, Mahajanga, Madagascar
filter by placetype:
  1. Bekoratsaka
    Bekoratsaka, Mampikony, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Ambato-Boeny
    Ambato-Boeny, Mahajanga, Madagascar (County)
  4. Mampikony
    Mampikony, Mahajanga, Madagascar (County)
  5. Port Bergé
    Port Bergé, Mahajanga, Madagascar (County)
  6. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  7. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  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.021 seconds ⌛; show me the details?

        
0.021 seconds ⌛

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