24 places near Berceni, Bucuresti, România
filter by placetype:
  1. Apărătorii Patriei
    Apărătorii Patriei, Bucuresti, România (Suburb)
  2. Şerban Vodă
    Şerban Vodă, Bucuresti, România (Suburb)
  3. Berceni
    Berceni, Bucuresti, România (Town)
  4. București
    București, Bucuresti, România (Town)
  5. Progresu
    Progresu, Bucuresti, România (Town)
  6. Donau
    Donau, Magyarország (Drainage)
  7. Wallachia
    Wallachia, România (Colloquial)
  8. Europe/Bucharest
    Europe/Bucharest (Timezone)
  9. Bucuresti
    Bucuresti, Bucuresti, România (State)
  10. Giurgiu
    Giurgiu, Giurgiu, România (State)

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": [
                  26.10659,
                  44.381569
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}