19 places near Ramhorst, Region Hannover, Niedersachsen, Deutschland
filter by placetype:
  1. Dolgen
    Dolgen, Region Hannover, Niedersachsen, Deutschland (Town)
  2. Immensen
    Immensen, Region Hannover, Niedersachsen, Deutschland (Town)
  3. Lehrte
    Lehrte, Region Hannover, Niedersachsen, Deutschland (Town)
  4. Ramhorst
    Ramhorst, Region Hannover, Niedersachsen, Deutschland (Town)
  5. Elbe
    Elbe, Deutschland (Drainage)
  6. Weser River
    Weser River, Deutschland (Drainage)
  7. Gemeinde Lehrte
    Gemeinde Lehrte, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  8. Gemeinde Sehnde
    Gemeinde Sehnde, Region Hannover, Niedersachsen, Deutschland (LocalAdmin)
  9. Landkreis Peine
    Landkreis Peine, Niedersachsen, Deutschland (County)
  10. Region Hannover
    Region Hannover, Niedersachsen, Deutschland (County)

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

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

        
0.035 seconds ⌛

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