Skip to content
Menu
geoMusings
  • About
geoMusings

Tag: SQL

BigQuery and Koop

Posted on 2021-03-22

As I continued my experimentation with BigQuery, I found myself wanting to more easily use it with my regular GIS tool set. BigQuery has a lot of powerful analytic capability, but the SQL console is intimidating for the casual user and the GeoViewer tool is fairly limited. As I began digging deeper in my previous…

Continue Reading

Routing with BigQuery and ArcGIS Platform APIs

Posted on 2021-03-11

This post is a continuation of last month’s post about analyzing location change with BigQuery. At the end of that post, I was already thinking of ways to extend the analysis and visualization. I decided to take the opportunity to explore Esri’s recently-announced ArcGIS Platform APIs. These APIs are the same that have been available…

Continue Reading

Analyzing Location Change Over Time in PostGIS

Posted on 2021-02-27

Following up on my previous post, I decided to attempt the same analysis in PostgreSQL. The analysis doesn’t make use of any spatial logic itself (yet), but I consider this a PostGIS post because it is using PostGIS geometries. In the past, I have noticed that BigQuery SQL is very reminiscent of that of PostgreSQL,…

Continue Reading

Analyzing Location Change Over Time in BigQuery

Posted on 2021-02-22

I’ve recently spent a lot of time doing various forms of business analytics in BigQuery. As discussed in a previous post, I’ve been using BigQuery as the data integration environment for several business systems. I’ve found integration at the data level via an ETL/ELT/IPaaS pipeline to be a lot more stable than system-level integrations that…

Continue Reading

Attribute Transfer in PostGIS Using Spatial SQL

Posted on 2020-04-06

Data conflation is a meat-and-potatoes task in most GIS workflows. There are numerous reasons one might need to get data from one data set into another. Perhaps you want to attach a new geometry type to existing attributes or a table. Or maybe you need to pull attributes from one or more data sets into…

Continue Reading

Working with Materialized Views in PostGIS

Posted on 2017-06-06

It’s been a few months since I’ve posted, owing mainly to getting my feet under me at Spatial Networks. About a month after I started, the company re-merged with Fulcrum, which had previously been spun off as a separate company. As a result, I’ve gotten to know the Fulcrum engineering team and have gotten to…

Continue Reading

Triggered Notifications Using PostGIS

Posted on 2011-08-01

My project work the last few months has kept me away from a lot of my favorite open-source tools and I was starting to get hives. Specifically, it had been a while since I had worked with PostgreSQL and PostGIS and I was missing the experience, so I dreamed up something to do. I do…

Continue Reading

Pages

  • About

Recent Posts

  • New Directions
  • Stripe API Pagination in FME
  • Mission Accomplished
  • Organizational Muscle Memory
  • Integrating Stripe with BigQuery

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org




Web Analytics Made Easy - StatCounter


©2023 geoMusings | WordPress Theme: EcoCoded