28 places near Riisikkala, Etelä-Pirkanmaan, Pirkanmaan maakunta, Suomi
  1. Riisikkala
    Riisikkala, Etelä-Pirkanmaan, Pirkanmaan maakunta, Suomi (Town)
  2. Vanajavesi
    Vanajavesi, Suomi (Drainage)
  3. Tarpianjoki
    Tarpianjoki, Etelä-Pirkanmaan, Pirkanmaan maakunta, Suomi (Drainage)
  4. Tavastehus
    Tavastehus, Hämeenlinnan, Kanta-Hämeen maakunta, Suomi (LocalAdmin)
  5. Kylmäkoski
    Kylmäkoski, Etelä-Pirkanmaan, Pirkanmaan maakunta, Suomi (LocalAdmin)
  6. Urjala
    Urjala, Etelä-Pirkanmaan, Pirkanmaan maakunta, Suomi (LocalAdmin)
  7. Norrland
    Norrland, Sverige (Colloquial)
  8. Southern Pirkanmaa
    Southern Pirkanmaa, Pirkanmaan maakunta, Suomi (Colloquial)
  9. Barents Region
    Barents Region (Colloquial)
  10. Fennoscandia
    Fennoscandia (Colloquial)

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

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

        
0.015 seconds ⌛

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