8 places near San Rocco, Cremona, Lombardia, Italia
filter by placetype:
  1. Crespiatica
    Crespiatica, Lodi, Lombardia, Italia (Town)
  2. Dovera
    Dovera, Cremona, Lombardia, Italia (Town)
  3. Barbuzzera
    Barbuzzera, Cremona, Lombardia, Italia (Town)
  4. Cadilana
    Cadilana, Lodi, Lombardia, Italia (Town)
  5. San Rocco
    San Rocco, Cremona, Lombardia, Italia (Town)
  6. Frazione Tormo
    Frazione Tormo, Lodi, Lombardia, Italia (Town)
  7. Roncadello
    Roncadello, Cremona, Lombardia, Italia (Town)
  8. Postino
    Postino, Cremona, Lombardia, Italia (Town)

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

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

        
0.032 seconds ⌛

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