5 places near Crotta d'Adda, Cremona, Lombardia, Italia
filter by placetype:
  1. Crotta d'Adda
    Crotta d'Adda, Cremona, Lombardia, Italia (LocalAdmin)
  2. Grumello Cremonese Ed Uniti
    Grumello Cremonese Ed Uniti, Cremona, Lombardia, Italia (LocalAdmin)
  3. Meleti
    Meleti, Lodi, Lombardia, Italia (LocalAdmin)
  4. Pizzighettone
    Pizzighettone, Cremona, Lombardia, Italia (LocalAdmin)
  5. Maccastorna
    Maccastorna, Lodi, Lombardia, Italia (LocalAdmin)

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

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

        
0.03 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  9.85399,
                  45.159752
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 10
          }
        }
      ],
      "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"
      }
    }
  ]
}