3

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).

  • What do you think about exporting as GeoJSON and then importing in QGIS – Taras Jan 8 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 8 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 8 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 9 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 at 8:37
2

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:

  • Unacast's plugin works wonderfully, thank you – joaopcoelho Apr 24 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.