5

Google BigQuery recently added GIS functionality (still in beta), see here.

I have a dataset in BigQuery that I would like to use as a data source in QGIS - much the same way as I would do with a normal PostGIS database or a CSV file.

Is there a way to do this?

I guess I could export the data from bigquery into a PostGIS instance in GCS, and then I would be able to load it into QGIS. But that doesn't feel like the right way to do it.

Size of data is not a concern, and I'm using QGIS 3.4.2 (Madeira).

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
joaopcoelho
  • 53
  • 1
  • 5
  • What do you think about exporting as GeoJSON and then importing in QGIS – Taras Jan 08 '19 at 10:10
  • Thanks for the tip, that's one possibility but it has the problem that if I update my data I will have to export and import it again. Ideally, I would like to avoid this - same way as I would if I was using a postGIS db – joaopcoelho Jan 08 '19 at 11:20
  • You are welcome, sorry for a poor suggestion. I am not an expert in this domain, so probably let's wait for a better hint/answer. Maybe you have to develop an add-on to let data update in PostGIS after the GeoJSON would be automatically created, e.g. Import GeoJSON into PostGIS – Taras Jan 08 '19 at 11:57
  • What I can think is creating a connection with R using the libraries bigqueryR and RQGIS3, everything in a single script; otherwise you should program a plugin in QGIS. @JoãoCoelho – Ariel Jan 09 '19 at 19:41
  • Thanks for the suggestion! I'll keep that in mind if I can't find a more straightforward solution. I'll also look into what it takes to create a plugin for QGIS - if you have any thoughts or tips on that feel free to share them :) – joaopcoelho Jan 10 '19 at 08:37

1 Answers1

3

There were two solutions people described using in BQGIS group,

One is import plugin for QGIS,

Another is foreign data wrapper for PostgreSQL, then using Postgre layers in QGIS:

Michael Entin
  • 1,017
  • 5
  • 8