28 places near Farinate, Cremona, Lombardia, Italia
  1. Stazione di Capralba
    Stazione di Capralba, Cremona, Lombardia, Italia (POI)
  2. Capralba
    Capralba, Cremona, Lombardia, Italia (Town)
  3. Vailate
    Vailate, Cremona, Lombardia, Italia (Town)
  4. Pieranica
    Pieranica, Cremona, Lombardia, Italia (Town)
  5. Farinate
    Farinate, Cremona, Lombardia, Italia (Town)
  6. Quintano
    Quintano, Cremona, Lombardia, Italia (Town)
  7. Remuscita
    Remuscita, Cremona, Lombardia, Italia (Town)
  8. Donau
    Donau, Magyarország (Drainage)
  9. Adda River
    Adda River, Lodi, Lombardia, Italia (Drainage)
  10. Capralba
    Capralba, Cremona, Lombardia, Italia (LocalAdmin)

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

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

        
0.054 seconds ⌛

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