25 places near Columbia, New York, United States
filter by placetype:
  1. Great North Woods
    Great North Woods, United States (Colloquial)
  2. Middle America
    Middle America, United States (Colloquial)
  3. Continental United States
    Continental United States, United States (Colloquial)
  4. Hudson River Valley
    Hudson River Valley, New York, United States (Colloquial)
  5. Appalachian Trail
    Appalachian Trail, United States (Colloquial)
  6. Columbia
    Columbia, New York, United States (County)
  7. America/New_York
    America/New_York, United States (Timezone)
  8. Illinois
    Illinois, Illinois, United States (State)
  9. New York
    New York, New York, United States (State)
  10. United States
    United States, United States (Country)

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

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

        
0.057 seconds ⌛

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