21 places near Colonna, Roma, Lazio, Italia
filter by placetype:
  1. Colonna
    Colonna, Roma, Lazio, Italia (Town)
  2. Monte Compatri
    Monte Compatri, Roma, Lazio, Italia (Town)
  3. Osteria
    Osteria, Roma, Lazio, Italia (Town)
  4. Casale Ricci
    Casale Ricci, Roma, Lazio, Italia (Town)
  5. Roma
    Roma, Roma, Lazio, Italia (LocalAdmin)
  6. Colonna
    Colonna, Roma, Lazio, Italia (LocalAdmin)
  7. Zagarolo
    Zagarolo, Roma, Lazio, Italia (LocalAdmin)
  8. Monte Compatri
    Monte Compatri, Roma, Lazio, Italia (LocalAdmin)
  9. San Cesareo
    San Cesareo, Roma, Lazio, Italia (LocalAdmin)
  10. Roma
    Roma, Lazio, Italia (County)

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

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

        
0.022 seconds ⌛

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