create_nyc.sql

CREATE OR REPLACE TABLE
  `PROJECT.DATASET.nyc` AS
SELECT
  *,
  st_geogpoint(pickup_longitude,
    pickup_latitude) AS geom
FROM
  `bigquery-public-data.new_york_taxi_trips.tlc_yellow_trips_2015`
WHERE
  pickup_datetime BETWEEN '2015-06-01T00:00:00'
  AND '2015-06-08T00:00:00'