bq

with raw as (SELECT
  ar.key as key,
  ar.value as category,
  concat(osm_id,osm_way_id) as Index,geometry,
  ST_CENTROID(geometry) AS center_location,
  st_x(ST_CENTROID(geometry)) as x,
  st_y(ST_CENTROID(geometry)) as y
FROM
  `bigquery-public-data.geo_openstreetmap.planet_features`,
  UNNEST(all_tags) AS ar
WHERE
 ('amenity') in (
  SELECT
    (key)
  FROM
    UNNEST(all_tags)))
    select DISTINCT Index as index,x,y,category from raw where key="amenity"