12 places near Madrid, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. La Huerta del Obispo
    La Huerta del Obispo, Madrid, Comunidad de Madrid, España (Suburb)
  2. La Vaguada
    La Vaguada, Madrid, Comunidad de Madrid, España (Suburb)
  3. Tetuan
    Tetuan, Madrid, Comunidad de Madrid, España (Suburb)
  4. Fuencarral-el Pardo
    Fuencarral-el Pardo, Madrid, Comunidad de Madrid, España (Suburb)
  5. Mirasierra
    Mirasierra, Madrid, Comunidad de Madrid, España (Suburb)
  6. Almenara
    Almenara, Madrid, Comunidad de Madrid, España (Suburb)
  7. Valdeacederas
    Valdeacederas, Madrid, Comunidad de Madrid, España (Suburb)
  8. Valverde
    Valverde, Madrid, Comunidad de Madrid, España (Suburb)
  9. La Paz
    La Paz, Madrid, Comunidad de Madrid, España (Suburb)
  10. Castillejos
    Castillejos, Madrid, Comunidad de Madrid, España (Suburb)

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

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

        
0.045 seconds ⌛

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