22 places near Trollhättan, Trollhättan, Västra Götalands Län, Sverige
filter by placetype:
  1. Trollhättan
    Trollhättan, Trollhättan, Västra Götalands Län, Sverige (Town)
  2. Göta älv
    Göta älv, Sverige (Drainage)
  3. The Gothenburg Region
    The Gothenburg Region, Sverige (Colloquial)
  4. Västragötaland
    Västragötaland, Sverige (Colloquial)
  5. Götaland
    Götaland, Sverige (Colloquial)
  6. Fennoscandia
    Fennoscandia (Colloquial)
  7. Lilla Edet
    Lilla Edet, Västra Götalands Län, Sverige (County)
  8. Trollhättan
    Trollhättan, Västra Götalands Län, Sverige (County)
  9. Vänersborg
    Vänersborg, Västra Götalands Län, Sverige (County)
  10. Europe/Oslo
    Europe/Oslo (Timezone)

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

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

        
0.03 seconds ⌛

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