26 places near Ogretin, Prahova, România
filter by placetype:
  1. Drajna de Sus
    Drajna de Sus, Prahova, România (Town)
  2. Făget
    Făget, Prahova, România (Town)
  3. Ogretin
    Ogretin, Prahova, România (Town)
  4. Poiana Mierlei
    Poiana Mierlei, Prahova, România (Town)
  5. Donau
    Donau, Magyarország (Drainage)
  6. Buzau River
    Buzau River, România (Drainage)
  7. Transylvania
    Transylvania, România (Colloquial)
  8. Wallachia
    Wallachia, România (Colloquial)
  9. Moldavia
    Moldavia (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.029 seconds ⌛; show me the details?

        
0.029 seconds ⌛

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