20 places near MERCAMADRID, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Barrio Polvorines
    Barrio Polvorines, Madrid, Comunidad de Madrid, España (Suburb)
  2. Madrid
    Madrid, Madrid, Comunidad de Madrid, España (Town)
  3. Rosales
    Rosales, Madrid, Comunidad de Madrid, España (Town)
  4. MERCAMADRID
    MERCAMADRID, Madrid, Comunidad de Madrid, España (Town)
  5. Tajo River
    Tajo River, Cáceres, Extremadura, España (Drainage)
  6. Madrid
    Madrid, Madrid, Comunidad de Madrid, España (LocalAdmin)
  7. Madrid
    Madrid, Comunidad de Madrid, España (County)
  8. Europe/Madrid
    Europe/Madrid, España (Timezone)
  9. Comunidad de Madrid
    Comunidad de Madrid, España (State)
  10. Castilla-La Mancha
    Castilla-La Mancha, España (State)

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

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

        
0.027 seconds ⌛

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