6 places near Scorpeto, Caserta, Campania, Italia
filter by placetype:
  1. Piedimonte d'Alife
    Piedimonte d'Alife, Caserta, Campania, Italia (Town)
  2. San Potito Sannitico
    San Potito Sannitico, Caserta, Campania, Italia (Town)
  3. Scorpeto
    Scorpeto, Caserta, Campania, Italia (Town)
  4. Sepicciano
    Sepicciano, Caserta, Campania, Italia (Town)
  5. Castello del Matese
    Castello del Matese, Caserta, Campania, Italia (Town)
  6. Piedimonte Matese
    Piedimonte Matese, Caserta, Campania, Italia (Town)

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

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

        
0.018 seconds ⌛

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