25 places near Cîmpina, Prahova, România
filter by placetype:
  1. Slobozia
    Slobozia, Prahova, România (Suburb)
  2. Bănești
    Bănești, Prahova, România (Town)
  3. Bobolia
    Bobolia, Prahova, România (Town)
  4. Cîmpina
    Cîmpina, Prahova, România (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Olt River
    Olt River, România (Drainage)
  7. Transylvania
    Transylvania, România (Colloquial)
  8. Wallachia
    Wallachia, România (Colloquial)
  9. Europe/Bucharest
    Europe/Bucharest (Timezone)
  10. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)

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

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

        
0.044 seconds ⌛

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