13 places near Maroambihy, Sambava, Antsiranana, Madagascar
filter by placetype:
  1. Maroambihy
    Maroambihy, Sambava, Antsiranana, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Antalaha
    Antalaha, Antsiranana, Madagascar (County)
  4. Sambava
    Sambava, Antsiranana, Madagascar (County)
  5. Andapa
    Andapa, Antsiranana, Madagascar (County)
  6. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  7. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  8. Antsiranana
    Antsiranana, Antsiranana, 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.022 seconds ⌛; show me the details?

        
0.022 seconds ⌛

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