Questions tagged [snowflake]
Snowflake is a data warehouse built on top of the Amazon Web Services or Microsoft Azure cloud infrastructure.
7
questions
0
votes
0
answers
54
views
ST_Intersection returns error in snowflake
I have two tables containing geometry columns. Table t1 holds the multipolygon data of parcels, and table t2 contains the multipolygon data of wireless coverage areas. The multipolygons in t2 are ...
- 249
1
vote
1
answer
66
views
QGIS - Export layer with one polygon subdivided as multiple rows to CSV
I have a GeoJSON file with quite precise boundaries of world's countries. I had to simplify it because Snowflake, where I want to keep the data, has 16MB limit and Canadian polygon is always too large....
- 291
0
votes
1
answer
332
views
Find the distances between stores with Lat/Long Coordinates in Python
I have a SQL query that pulls the Lat/Long values of all stores.
How do I find the distances between all stores in the column that is returned from the query? Is that even possible?
First, I imported ...
- 1
1
vote
1
answer
534
views
Publish a Query Feature Class from ArcGIS Pro to ArcGIS Online
I have created a Query Feature Class in ArcGIS Pro using point data that is stored in Snowflake (following the steps in this video https://www.youtube.com/watch?v=pnSaS95Rlqs).
Is there a way to ...
- 41
0
votes
0
answers
2k
views
How to handle invalid lat/long with st_makepoint
I am trying to create geohashes from lat/longs but some of my lat/long data is incorrect. I can't find a way to handle these rows.
With:
select
user_id
, st_makepoint(user_longitude, user_latitude)...
- 1
3
votes
0
answers
382
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 ...
- 3,183
2
votes
1
answer
1k
views
Connecting to Snowflake cloud warehouse to accessing data tables in QGIS
Is there a way in QGIS to connect to a Snowflake cloud data warehouse using ODBC, or other? I would like to access this data storage to natively create spatial content by accessing the WKT, Geography, ...
- 21