29 places near 粟生津, 新潟県, 日本
filter by placetype:
  1. 長岡市
    長岡市, 新潟県, 日本 (Town)
  2. 三条市
    三条市, 新潟県, 日本 (Town)
  3. 燕市
    燕市, 新潟県, 日本 (Town)
  4. 信濃川
    信濃川, 日本 (Drainage)
  5. 粟生津
    粟生津, 新潟県, 日本 (LocalAdmin)
  6. 上河原
    上河原, 新潟県, 日本 (LocalAdmin)
  7. 熊森
    熊森, 新潟県, 日本 (LocalAdmin)
  8. 佐善
    佐善, 新潟県, 日本 (LocalAdmin)
  9. 下粟生津
    下粟生津, 新潟県, 日本 (LocalAdmin)
  10. 高木
    高木, 新潟県, 日本 (LocalAdmin)

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

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

        
0.019 seconds ⌛

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