24 places near Schmarrie, Landkreis Schaumburg, Niedersachsen, Deutschland
filter by placetype:
  1. Hülsede
    Hülsede, Landkreis Schaumburg, Niedersachsen, Deutschland (Town)
  2. Meinsen
    Meinsen, Landkreis Schaumburg, Niedersachsen, Deutschland (Town)
  3. Messenkamp
    Messenkamp, Landkreis Schaumburg, Niedersachsen, Deutschland (Town)
  4. Röhrsen
    Röhrsen, Hameln-Pyrmont, Niedersachsen, Deutschland (Town)
  5. Schmarrie
    Schmarrie, Landkreis Schaumburg, Niedersachsen, Deutschland (Town)
  6. Herriehausen
    Herriehausen, Landkreis Schaumburg, Niedersachsen, Deutschland (Town)
  7. Landermühle
    Landermühle, Hameln-Pyrmont, Niedersachsen, Deutschland (Town)
  8. Weser River
    Weser River, Deutschland (Drainage)
  9. Gemeinde Bad Münder am Deister
    Gemeinde Bad Münder am Deister, Hameln-Pyrmont, Niedersachsen, Deutschland (LocalAdmin)
  10. Gemeinde Hülsede
    Gemeinde Hülsede, Landkreis Schaumburg, Niedersachsen, Deutschland (LocalAdmin)

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

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

        
0.021 seconds ⌛

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