24 places near Cascina Colombara, Cremona, Lombardia, Italia
  1. Cremosano
    Cremosano, Cremona, Lombardia, Italia (LocalAdmin)
  2. Alps
    Alps (Colloquial)
  3. Cremona
    Cremona, Lombardia, Italia (County)
  4. Lodi
    Lodi, Lombardia, Italia (County)
  5. Europe/Rome
    Europe/Rome (Timezone)
  6. Lombardia
    Lombardia, Italia (State)
  7. Italia
    Italia, Italia (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. Pacific Ocean
    Pacific Ocean (Ocean)
  10. Mediterranean Sea
    Mediterranean Sea (Sea)

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

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

        
0.01 seconds ⌛

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