17 places near Kolding Vamdrup Airport, Kolding, Syddanmark, Danmark
filter by placetype:
  1. Kolding Vamdrup Airport
    Kolding Vamdrup Airport, Kolding, Syddanmark, Danmark (Airport)
  2. Hjarup
    Hjarup, Kolding, Syddanmark, Danmark (Town)
  3. Søgårde
    Søgårde, Kolding, Syddanmark, Danmark (Town)
  4. Kongeå
    Kongeå, Syddanmark, Danmark (Drainage)
  5. Jutland
    Jutland (Colloquial)
  6. Fennoscandia
    Fennoscandia (Colloquial)
  7. Kolding
    Kolding, Syddanmark, Danmark (County)
  8. Europe/Copenhagen
    Europe/Copenhagen (Timezone)
  9. Syddanmark
    Syddanmark, Syddanmark, Danmark (State)
  10. Danmark
    Danmark, Danmark (Country)

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": [
                  9.3311,
                  55.4375
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}