26 places near Roșu, Ilfov, România
filter by placetype:
  1. Ciurel
    Ciurel, Bucuresti, România (Suburb)
  2. Militari
    Militari, Bucuresti, România (Suburb)
  3. Şasesprezece Februarie
    Şasesprezece Februarie, Bucuresti, România (Suburb)
  4. București
    București, Bucuresti, România (Town)
  5. Roșu
    Roșu, Ilfov, România (Town)
  6. Treizeci Decembrie
    Treizeci Decembrie, Bucuresti, România (Town)
  7. Donau
    Donau, Magyarország (Drainage)
  8. Olt River
    Olt River, România (Drainage)
  9. Wallachia
    Wallachia, România (Colloquial)
  10. Europe/Bucharest
    Europe/Bucharest (Timezone)

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

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

        
0.028 seconds ⌛

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