Questions tagged [google-big-query]
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data.
8
questions
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 ...
- 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 ...
- 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 ...
- 41
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(...
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 ...
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 ...
- 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 ...
- 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 ...
- 2,769