28 places near Rogers Island, Columbia, New York, United States
filter by placetype:
  1. Hamburg
    Hamburg, Greene, New York, United States (Suburb)
  2. Catskill
    Catskill, Greene, New York, United States (Town)
  3. Greenport Center
    Greenport Center, Columbia, New York, United States (Town)
  4. Catskills
    Catskills, New York, United States (Colloquial)
  5. East Coast
    East Coast, United States (Colloquial)
  6. US Eastern States
    US Eastern States, United States (Colloquial)
  7. Middle Atlantic States
    Middle Atlantic States, United States (Colloquial)
  8. Northeastern States
    Northeastern States, United States (Colloquial)
  9. Canada International Border States
    Canada International Border States, United States (Colloquial)
  10. Great Lakes Region
    Great Lakes Region, United States (Colloquial)

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

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

        
0.029 seconds ⌛

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