Spatialists<p>New geospatial data in Google BigQuery: <a href="https://mapstodon.space/tags/Google" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Google</span></a> is adding geospatial content to its <a href="https://mapstodon.space/tags/DWH" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DWH</span></a> solution <a href="https://mapstodon.space/tags/BigQuery" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>BigQuery</span></a>. Additions encompass annotated Street View <a href="https://mapstodon.space/tags/imagery" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>imagery</span></a>, Places (<a href="https://mapstodon.space/tags/POI" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>POI</span></a>) data, and <a href="https://mapstodon.space/tags/traffic" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>traffic</span></a> data, among others. <br><a href="https://spatialists.ch/posts/2025/04-14-new-geospatial-data-in-google-bigquery/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">spatialists.ch/posts/2025/04-1</span><span class="invisible">4-new-geospatial-data-in-google-bigquery/</span></a> <a href="https://mapstodon.space/tags/GIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GIS</span></a> <a href="https://mapstodon.space/tags/GISchat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GISchat</span></a> <a href="https://mapstodon.space/tags/geospatial" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>geospatial</span></a> <a href="https://mapstodon.space/tags/SwissGIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SwissGIS</span></a></p>
sigmoid.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A social space for people researching, working with, or just interested in AI!
Administered by:
Server stats:
602active users
sigmoid.social: About · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.4.1
#dwh
0 posts · 0 participants · 0 posts today
Anoncheg<p>Part1: <a href="https://techhub.social/tags/dailyreport" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dailyreport</span></a> <a href="https://techhub.social/tags/powerbi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>powerbi</span></a> <a href="https://techhub.social/tags/datawarehouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>datawarehouse</span></a> <a href="https://techhub.social/tags/dwh" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dwh</span></a> <a href="https://techhub.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>postgresql</span></a><br> <a href="https://techhub.social/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>python</span></a><br>At this week I installed PowerBI and connect it to remote<br> PostgreSQL.<br>I asked AI to compare open-source data sources for<br> PowerBI and compare them by:<br>- Ease of Setup on Linux: SQLite > PostgreSQL > MySQL ><br> Redis > MongoDB<br>- Performance:<br> + For large datasets: MongoDB > PostgreSQL > MySQL ><br> Redis > SQLite.<br> + For real-time operations: Redis > MongoDB > MySQL ><br> PostgreSQL > SQLite.</p><p>For PostgreSQL I prepare data in Python script that use:<br>- pandas - for coverting types to datetime and numeric<br>- sqlalchemy - for simplifying type converstion<br>- asyncpg - sqlalchemy backend to connect to PostgreSQL</p>
ваят<p>“It’s possible that the Deepwater Horizon disaster caused more damage than nature can clean up.”</p><p><a href="https://mstdn.social/tags/DeepwaterHorizon" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DeepwaterHorizon</span></a> <a href="https://mstdn.social/tags/DWH" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DWH</span></a> <a href="https://mstdn.social/tags/Macondo" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Macondo</span></a></p><p><a href="https://hakaimagazine.com/news/the-deepwater-horizons-very-unhappy-anniversary/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">hakaimagazine.com/news/the-dee</span><span class="invisible">pwater-horizons-very-unhappy-anniversary/</span></a></p>
TrendingLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload