15 places near Makaraingo, Morafenobe, Mahajanga, Madagascar
filter by placetype:
  1. Makaraingo
    Makaraingo, Morafenobe, Mahajanga, Madagascar (Town)
  2. Madagascar
    Madagascar, Madagascar (Island)
  3. Fenoarivo Be
    Fenoarivo Be, Antananarivo, Madagascar (County)
  4. Kandreho
    Kandreho, Mahajanga, Madagascar (County)
  5. Morafenobe
    Morafenobe, Mahajanga, Madagascar (County)
  6. Ambatomainty
    Ambatomainty, Mahajanga, Madagascar (County)
  7. Indian/Antananarivo
    Indian/Antananarivo (Timezone)
  8. Indian/Kerguelen
    Indian/Kerguelen (Timezone)
  9. Eastern
    Eastern, Eastern, Fiji (State)
  10. Mahajanga
    Mahajanga, Mahajanga, Madagascar (State)

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

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

        
0.023 seconds ⌛

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