25 places near Lunca Mare, Prahova, România
filter by placetype:
  1. Brebu Megieșesc
    Brebu Megieșesc, Prahova, România (Town)
  2. Podu Cheii
    Podu Cheii, Prahova, România (Town)
  3. Lunca Mare
    Lunca Mare, 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. Moldavia
    Moldavia (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.026 seconds ⌛; show me the details?

        
0.026 seconds ⌛

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