24 places near 12106, Columbia, New York, United States
filter by placetype:
  1. Martin Van Buren Elementary School
    Martin Van Buren Elementary School, Columbia, New York, United States (POI)
  2. Kinderhook
    Kinderhook, Columbia, New York, United States (Town)
  3. New England
    New England, United States (Colloquial)
  4. East Coast
    East Coast, United States (Colloquial)
  5. US Eastern States
    US Eastern States, United States (Colloquial)
  6. Middle Atlantic States
    Middle Atlantic States, United States (Colloquial)
  7. Northeastern States
    Northeastern States, United States (Colloquial)
  8. Canada International Border States
    Canada International Border States, United States (Colloquial)
  9. Great Lakes Region
    Great Lakes Region, United States (Colloquial)
  10. Great North Woods
    Great North Woods, United States (Colloquial)

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

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

        
0.015 seconds ⌛

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