18 places near Patillal, San Juan del Cesar, La Guajira, Colombia
filter by placetype:
  1. Patillal
    Patillal, San Juan del Cesar, La Guajira, Colombia (Town)
  2. Valledupar
    Valledupar, Cesar, Colombia (County)
  3. San Juan del Cesar
    San Juan del Cesar, La Guajira, Colombia (County)
  4. America/Bogota
    America/Bogota (Timezone)
  5. America/Caracas
    America/Caracas (Timezone)
  6. Cesar
    Cesar, Cesar, Colombia (State)
  7. Colombia
    Colombia, Colombia (Country)
  8. Caribbean Sea
    Caribbean Sea (Sea)
  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.022 seconds ⌛; show me the details?

        
0.022 seconds ⌛

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