18 places near Sandalpur, Araria, Bihar, India
filter by placetype:
  1. Sandalpur
    Sandalpur, Araria, Bihar, India (Town)
  2. Chatar
    Chatar, Araria, Bihar, India (Town)
  3. Bathna
    Bathna, Purnia, Bihar, India (Town)
  4. Nijgehuma
    Nijgehuma, Purnia, Bihar, India (Town)
  5. Ganges River
    Ganges River, India (Drainage)
  6. Araria
    Araria, Bihar, India (County)
  7. Purnia
    Purnia, Bihar, India (County)
  8. Asia/Kolkata
    Asia/Kolkata (Timezone)
  9. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  10. Bihar
    Bihar, Bihar, India (State)

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

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

        
0.038 seconds ⌛

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