8 places near Bellaire, Ramsey, Minnesota, United States
filter by placetype:
  1. Bellaire
    Bellaire, Ramsey, Minnesota, United States (Town)
  2. Birchwood
    Birchwood, Washington, Minnesota, United States (Town)
  3. Dellwood
    Dellwood, Washington, Minnesota, United States (Town)
  4. Mahtomedi
    Mahtomedi, Washington, Minnesota, United States (Town)
  5. St. Paul
    St. Paul, Ramsey, Minnesota, United States (Town)
  6. White Bear Lake
    White Bear Lake, Ramsey, Minnesota, United States (Town)
  7. Grant
    Grant, Washington, Minnesota, United States (Town)
  8. White Bear
    White Bear, Ramsey, Minnesota, United States (Town)

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": [
                  -92.994347,
                  45.069691
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}