7 places near Ripalta Cremasca, Cremona, Lombardia, Italia
filter by placetype:
  1. Cascine San Carlo
    Cascine San Carlo, Cremona, Lombardia, Italia (Town)
  2. Ripalta Guerina
    Ripalta Guerina, Cremona, Lombardia, Italia (Town)
  3. Ripalta Nuova
    Ripalta Nuova, Cremona, Lombardia, Italia (Town)
  4. Ripalta Vecchia
    Ripalta Vecchia, Cremona, Lombardia, Italia (Town)
  5. Trampolino
    Trampolino, Cremona, Lombardia, Italia (Town)
  6. Zappello
    Zappello, Cremona, Lombardia, Italia (Town)
  7. San Michele
    San Michele, Cremona, Lombardia, Italia (Town)

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

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

        
0.014 seconds ⌛

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