Questions tagged [google-big-query]

BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data.

Filter by
Sorted by
Tagged with
1 vote
1 answer
62 views

How big geometry are best for BigQuery performance

I make a geospatial analysis, in Google BigQuery, which mostly includes making difference (I mean ST_Difference) between parcels geometry and some objects like woods, buildings etc. Some of objects I ...
user avatar
  • 19
1 vote
1 answer
38 views

Representing a route that doubles back on itself in BigQuery with a LineString

I'm trying to represent routes in BigQuery, but running into issues for routes that double back on themselves. Consider the following LineString that proceeds from the southwest to the northeast of ...
user avatar
  • 133
0 votes
1 answer
100 views

Converting SQL queries from PostGIS to BigQuery

I have a table called drawn_items with columns “the_geom”, “fsrn_db” , & “area” in Carto2 which is queried by SQL. Having recreated the table in Carto 3, in order to use the query, I must ...
user avatar
0 votes
1 answer
51 views

Clip a shapefile by a line border

I'm trying to generate a clipped file of a sample polygon geography (in this case, zip) and the U.S. coastline. This is the query I currently have: select state_code, zip_code, st_union(st_dump(...
user avatar
0 votes
0 answers
86 views

Big Query: ST_GeogFromText failed: Unexpected 'geometry' at position 0

I'm pretty new to the GIS field, so might be ignoring something obvious here. I'm trying to match Mlab speed test data (each record had lat long attribute) with map of administrative boundaries of ...
user avatar
0 votes
0 answers
175 views

How to store GeoJSON data in Big Query to be able to seamlessly work with Big Query GIS functions

I have this polygon which I have imported as such bq load \ --source_format=NEWLINE_DELIMITED_JSON \ --json_extension=GEOJSON \ --autodetect \ dataset.GeoJson \ sites.json From this I get this ...
user avatar
  • 101
3 votes
1 answer
347 views

How to import PostGIS into BigQuery GIS?

I have to import PostGIS data into BigQuery GIS. In order to do this, I dumped the PostGIS data in CSV and import it into BigQuery. This is working for all the columns but not the geometric one. If I ...
user avatar
  • 133
3 votes
0 answers
174 views

Which Big Data analytics platform has most extensive GIS support? [closed]

I've recently had to deal with datasets that are simply too large to be efficiently processed using PostgreSQL and so I've turned to Google's BigQuery for those tasks. BigQuery, while offering ...
user avatar
  • 2,769