27 places near Haapajoki, Joensuun, Pohjois-karjala maakunta, Suomi
  1. Pihlajavaara
    Pihlajavaara, Joensuun, Pohjois-karjala maakunta, Suomi (Town)
  2. Pötsönvaara
    Pötsönvaara, Joensuun, Pohjois-karjala maakunta, Suomi (Town)
  3. Haapajoki
    Haapajoki, Joensuun, Pohjois-karjala maakunta, Suomi (Drainage)
  4. Ilomants
    Ilomants, Joensuun, Pohjois-karjala maakunta, Suomi (LocalAdmin)
  5. Lieksa
    Lieksa, Pielisen Karjalan, Pohjois-karjala maakunta, Suomi (LocalAdmin)
  6. Lapland
    Lapland (Colloquial)
  7. Barents Region
    Barents Region (Colloquial)
  8. Sapmi
    Sapmi (Colloquial)
  9. Fennoscandia
    Fennoscandia (Colloquial)
  10. Muezerskiy Raion
    Muezerskiy Raion, Kareliya, Rossija (County)

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

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

        
0.013 seconds ⌛

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