18 places near 9934, Delfzijl, Groningen, Nederland
filter by placetype:
  1. Kroonstad
    Kroonstad, Delfzijl, Groningen, Nederland (Suburb)
  2. Delfzijl
    Delfzijl, Delfzijl, Groningen, Nederland (Town)
  3. Farmsum
    Farmsum, Delfzijl, Groningen, Nederland (Town)
  4. Ladysmith
    Ladysmith, Delfzijl, Groningen, Nederland (Town)
  5. Delfzijl
    Delfzijl, Groningen, Nederland (County)
  6. Landkreis Aurich
    Landkreis Aurich, Niedersachsen, Deutschland (County)
  7. Europe/Amsterdam
    Europe/Amsterdam (Timezone)
  8. Europe/Berlin
    Europe/Berlin (Timezone)
  9. Groningen
    Groningen, Groningen, Nederland (State)
  10. Nederland
    Nederland, Nederland (Country)

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

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

        
0.022 seconds ⌛

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