19 places near Appingedam, Groningen, Nederland
filter by placetype:
  1. Appingedam
    Appingedam, Appingedam, Groningen, Nederland (Town)
  2. Oling
    Oling, Appingedam, Groningen, Nederland (Town)
  3. Solwerd
    Solwerd, Appingedam, Groningen, Nederland (Town)
  4. Tjamsweer
    Tjamsweer, Appingedam, Groningen, Nederland (Town)
  5. Appingedam
    Appingedam, Groningen, Nederland (County)
  6. Delfzijl
    Delfzijl, Groningen, Nederland (County)
  7. Loppersum
    Loppersum, Groningen, Nederland (County)
  8. Europe/Amsterdam
    Europe/Amsterdam (Timezone)
  9. Europe/Berlin
    Europe/Berlin (Timezone)
  10. Groningen
    Groningen, Groningen, Nederland (State)

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

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

        
0.024 seconds ⌛

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