Convert shp file to geojson then upload to Bigquery

Yiling Liu
1 min readOct 2, 2019

--

Three steps:

  1. Convert shape file to geojson
  2. Get schema and convert data type to geometry:GEOGRAPHY
  3. Upload data to Bigquery using json and schema

The code for 3 steps as below:

bq load --source_format NEWLINE_DELIMITED_JSON \
[destination_database.destination_table] \
[schema(output of python)]

--

--

Yiling Liu
Yiling Liu

Written by Yiling Liu

Creative Technologist, ex-googler

No responses yet