20 places near Gemeinde Appen, Landkreis Pinneberg, Schleswig-Holstein, Deutschland
filter by placetype:
  1. Appen
    Appen, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  2. Etz
    Etz, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  3. Hamburg
    Hamburg, Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (Town)
  4. Schäferhof
    Schäferhof, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  5. Katharinenhof
    Katharinenhof, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  6. Appen-Etz
    Appen-Etz, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (Town)
  7. Gemeinde Holm
    Gemeinde Holm, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  8. Gemeinde Appen
    Gemeinde Appen, Landkreis Pinneberg, Schleswig-Holstein, Deutschland (LocalAdmin)
  9. Landkreis Stade
    Landkreis Stade, Niedersachsen, Deutschland (County)
  10. Stadtkreis Hamburg
    Stadtkreis Hamburg, Freie und Hansestadt Hamburg, Deutschland (County)

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

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

        
0.036 seconds ⌛

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