21 places near Al Mandarah, Al Iskandariyah, Egypt
filter by placetype:
  1. Al Mandarah
    Al Mandarah, Al Iskandariyah, Egypt (Town)
  2. Izbat al Muntazah
    Izbat al Muntazah, Al Iskandariyah, Egypt (Town)
  3. المنتزة
    المنتزة, Al Iskandariyah, Egypt (Town)
  4. Al Mamoura
    Al Mamoura, Al Iskandariyah, Egypt (Town)
  5. العمراوي
    العمراوي, Al Iskandariyah, Egypt (Town)
  6. المندرة بحري
    المندرة بحري, Al Iskandariyah, Egypt (Town)
  7. المندرة قبلى-تشمل عزبة الجبل
    المندرة قبلى-تشمل عزبة الجبل, Al Iskandariyah, Egypt (Town)
  8. Africa/Cairo
    Africa/Cairo (Timezone)
  9. Al Iskandariyah
    Al Iskandariyah, Al Iskandariyah, Egypt (State)
  10. Matruh
    Matruh, Matruh, Egypt (State)

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": [
                  30.01861,
                  31.27887
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}