6 places near Ambatomena, Antananarivo Avaradrano, Antananarivo, Madagascar
filter by placetype:
  1. Ambatomitsangana
    Ambatomitsangana, Antananarivo Avaradrano, Antananarivo, Madagascar (Town)
  2. Ambondrona
    Ambondrona, Antananarivo Avaradrano, Antananarivo, Madagascar (Town)
  3. Ankadifotsy
    Ankadifotsy, Antananarivo Avaradrano, Antananarivo, Madagascar (Town)
  4. Antananarivo
    Antananarivo, Antananarivo Avaradrano, Antananarivo, Madagascar (Town)
  5. Antanimena
    Antanimena, Antananarivo Avaradrano, Antananarivo, Madagascar (Town)
  6. Soarano
    Soarano, Antananarivo Avaradrano, Antananarivo, Madagascar (Town)

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

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

        
0.037 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  47.516701,
                  -18.9
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}