24 places near Cap Roșu, Prahova, România
filter by placetype:
  1. Florești
    Florești, Prahova, România (Town)
  2. Lunca Prahovei
    Lunca Prahovei, Prahova, România (Town)
  3. Cap Roșu
    Cap Roșu, Prahova, România (Town)
  4. Donau
    Donau, Magyarország (Drainage)
  5. Olt River
    Olt River, România (Drainage)
  6. Transylvania
    Transylvania, România (Colloquial)
  7. Wallachia
    Wallachia, România (Colloquial)
  8. Europe/Bucharest
    Europe/Bucharest (Timezone)
  9. Europe/Kiev
    Europe/Kiev, Ukrayina (Timezone)
  10. Dambovita
    Dambovita, Dambovita, România (State)

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

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

        
0.029 seconds ⌛

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