21 places near Pietravairano, Caserta, Campania, Italia
filter by placetype:
  1. Pietravairano
    Pietravairano, Caserta, Campania, Italia (Town)
  2. Raviscanina
    Raviscanina, Caserta, Campania, Italia (Town)
  3. San Felice
    San Felice, Caserta, Campania, Italia (Town)
  4. Vairano Patenora
    Vairano Patenora, Caserta, Campania, Italia (LocalAdmin)
  5. Pietravairano
    Pietravairano, Caserta, Campania, Italia (LocalAdmin)
  6. Caserta
    Caserta, Campania, Italia (County)
  7. Europe/Belgrade
    Europe/Belgrade (Timezone)
  8. Europe/Rome
    Europe/Rome (Timezone)
  9. Campania
    Campania, Italia (State)
  10. Italia
    Italia, Italia (Country)

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": [
                  14.18846,
                  41.326069
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}