4 places near Scandolara Ripa d'Oglio, Cremona, Lombardia, Italia
filter by placetype:
  1. Alfiano Nuovo
    Alfiano Nuovo, Cremona, Lombardia, Italia (Town)
  2. Grontardo
    Grontardo, Cremona, Lombardia, Italia (Town)
  3. Pescarolo ed Uniti
    Pescarolo ed Uniti, Cremona, Lombardia, Italia (Town)
  4. Scandolara Ripa d'Oglio
    Scandolara Ripa d'Oglio, Cremona, Lombardia, Italia (Town)

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

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

        
0.088 seconds ⌛

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