23 places near Põltsamaa Vald, Jõgevamaa, Eesti
filter by placetype:
  1. Annikvere
    Annikvere, Põltsamaa Vald, Jõgevamaa, Eesti (Town)
  2. Põltsamaa
    Põltsamaa, Põltsamaa, Jõgevamaa, Eesti (Town)
  3. Võhmanõmme
    Võhmanõmme, Põltsamaa Vald, Jõgevamaa, Eesti (Town)
  4. Emajogi River
    Emajogi River, Eesti (Drainage)
  5. Fennoscandia
    Fennoscandia (Colloquial)
  6. Põltsamaa Vald
    Põltsamaa Vald, Jõgevamaa, Eesti (County)
  7. Põltsamaa
    Põltsamaa, Jõgevamaa, Eesti (County)
  8. Europe/Oslo
    Europe/Oslo (Timezone)
  9. Europe/Tallinn
    Europe/Tallinn (Timezone)
  10. Järvamaa
    Järvamaa, Järvamaa, Eesti (State)

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

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

        
0.059 seconds ⌛

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