16 places near La Porfía, Arauca, Arauca, Colombia
filter by placetype:
  1. La Porfía
    La Porfía, Arauca, Arauca, Colombia (Town)
  2. El Amparo
    El Amparo, Paez, Apure, Venezuela (LocalAdmin)
  3. Arauca
    Arauca, Arauca, Colombia (County)
  4. Paez
    Paez, Apure, Venezuela (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. America/Caracas
    America/Caracas (Timezone)
  7. Arauca
    Arauca, Arauca, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. North America
    North America (Continent)

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

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

        
0.027 seconds ⌛

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